{"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":13,"n_cols":8,"rows_kept":13}
[null,"Check Register"]
[null,"LEGEND",{"$nulls":5},"CURRENT BALANCE"]
[null,"DC = Debit Card",null,"AP = Automatic Payment ",{"$nulls":3},{"$f":"CURRENT_BALANCE","v":{"v":3311,"d":"£3,311.00"}}]
[null,"ATM = Automated Teller Withdrawal",null,"BP = Online note pay"]
[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-03-13"},"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":"2022-03-21"},"School of Fine Art","Kelly's art class - 6 weeks",{"v":100,"d":"£100.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H7+CheckRegister[[#This Row],[DEPOSIT]],H7-CheckRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":1900,"d":"£1,900.00"}}]
[null,"AD",{"$f":"TODAY()-11","v":"2022-03-21"},"Pay cheque",null,null,{"v":1500,"d":"£1,500.00"},{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H8+CheckRegister[[#This Row],[DEPOSIT]],H8-CheckRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3400,"d":"£3,400.00"}}]
[null,"DC",{"$f":"TODAY()-8","v":"2022-03-24"},"Southridge Video","Film rental + $10 cash back",{"v":16,"d":"£16.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H9+CheckRegister[[#This Row],[DEPOSIT]],H9-CheckRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3384,"d":"£3,384.00"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2022-03-27"},null,"Cash for dining out",{"v":50,"d":"£50.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H10+CheckRegister[[#This Row],[DEPOSIT]],H10-CheckRegister[[#This Row],[WITHDRAWAL]]), \"\")","v":{"v":3334,"d":"£3,334.00"}}]
[null,"BP",{"$f":"TODAY()","v":"2022-04-01"},"The Phone Company",null,{"v":23,"d":"£23.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegister[[#This Row],[WITHDRAWAL]]),H11+CheckRegister[[#This Row],[DEPOSIT]],H11-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"}}]