{"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":18,"n_cols":8,"rows_kept":18}
[null,"Check register"]
[]
[null,"Legend",{"$nulls":5},"Current Balance"]
[]
[null,"DC - Debit card",null,"AP - Automatic payment ","AD - Automatic deposit ",null,null,{"$f":"CURRENT_BALANCE","v":{"v":3311,"d":"$3,311.00"}}]
[null,"ATM - Automated teller withdrawal",null,"BP - Online bill pay","TR - Online or phone transfer"]
[]
[null,"Check/Code","Date","Transaction","Description","Withdrawal","Deposit","Balance"]
[null,null,{"$f":"TODAY()-19","v":"2022-12-31"},"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-08"},"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-08"},"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-11"},"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-14"},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-19"},"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"}}]
[{"$nulls":7},{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[Withdrawal]]),H14+CheckRegister[[#This Row],[Deposit]],H14-CheckRegister[[#This Row],[Withdrawal]]), \"\")","v":""}]
[{"$nulls":7},{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[Withdrawal]]),H16+CheckRegister[[#This Row],[Deposit]],H16-CheckRegister[[#This Row],[Withdrawal]]), \"\")","v":""}]
[{"$nulls":7},{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[Withdrawal]]),H17+CheckRegister[[#This Row],[Deposit]],H17-CheckRegister[[#This Row],[Withdrawal]]), \"\")","v":""}]