{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Check register"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Check register","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[2,6,3,7],[4,6,5,7]]}
[null,"CHECK REGISTER"]
[]
[null,"LEGEND",{"$nulls":4},"CURRENT BALANCE"]
[null,"DC = Debit card",null,"AP = Automatic payment "]
[null,"ATM = Automated teller withdrawal",null,"BP = Online bill pay",null,null,{"$f":"CURRENT_BALANCE","v":{"v":3311,"d":"$3,311.00"}}]
[null,"AD = Automatic deposit ",null,"TR = Online or phone transfer"]
[]
[null,"CHECK/CODE","DATE","TRANSACTION","DESCRIPTION","WITHDRAWAL","DEPOSIT","BALANCE"]
[null,null,{"$f":"TODAY()-19","v":"2022-12-27"},"Woodgrove Bank","Opening Balance",null,{"v":2000,"d":"$2,000.00"},{"$f":"IFERROR(CheckRegister[[#This Row],[DEPOSIT]], \"\")","v":{"v":2000,"d":"$2,000.00"}}]
[null,1001,{"$f":"TODAY()-11","v":"2023-01-04"},"School of Fine Art","Kelly's art class - 6 weeks",{"v":100,"d":"$100.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H9+CheckRegister[[#This Row],[DEPOSIT]],H9-CheckRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":1900,"d":"$1,900.00"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2023-01-04"},"Paycheck",null,null,{"v":1500,"d":"$1,500.00"},{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H10+CheckRegister[[#This Row],[DEPOSIT]],H10-CheckRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3400,"d":"$3,400.00"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2023-01-07"},"Southridge Video","Movie rental + $10 cash back",{"v":16,"d":"$16.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H11+CheckRegister[[#This Row],[DEPOSIT]],H11-CheckRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3384,"d":"$3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2023-01-10"},null,"Cash for dining out",{"v":50,"d":"$50.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H12+CheckRegister[[#This Row],[DEPOSIT]],H12-CheckRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3334,"d":"$3,334.00"}}]
[null,"BP",{"$f":"TODAY()","v":"2023-01-15"},"The Phone Company",null,{"v":23,"d":"$23.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H13+CheckRegister[[#This Row],[DEPOSIT]],H13-CheckRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3311,"d":"$3,311.00"}}]
[null,"TOTALS",null,{"$f":"CONCATENATE(\"TRANSACTION COUNT: \",SUBTOTAL(103,CheckRegister[TRANSACTION]))","v":"TRANSACTION COUNT: 5"},null,{"$f":"SUBTOTAL(109,CheckRegister[WITHDRAWAL])","v":{"v":189,"d":"$189.00"}},{"$f":"SUBTOTAL(109,CheckRegister[DEPOSIT])","v":{"v":3500,"d":"$3,500.00"}},{"$f":"CheckRegister[[#Totals],[DEPOSIT]]-CheckRegister[[#Totals],[WITHDRAWAL]]","v":{"v":3311,"d":"$3,311.00"}}]