{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cheque Register"],"not_rendered":{"charts":1,"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Cheque Register","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[3,1,11,2],[12,1,12,2]]}
[null,"Cheque Register"]
[null,"Enter your bank account number in this cell"]
[null,{"$f":"CONCATENATE(\"Current Balance : \"&TEXT(ChequeRegister[[#Totals],[Balance]],\"£#,##0.00\"))","v":"Current Balance : £2,730.84"}]
[]
[{"$nulls":4},"Cheque no.","Date","Description","Category","Withdrawal","Deposit","Balance"]
[{"$nulls":5},{"$f":"TODAY()-60","v":"2018-03-11"},"Beginning Balance","Deposit",null,{"v":2916.73,"d":"£2,916.73"},{"$f":"InitialBalance","v":{"v":2916.73,"d":"£2,916.73"}}]
[{"$nulls":4},2251,{"$f":"TODAY()-59","v":"2018-03-12"},"Supermarket","Food and household supplies",{"v":205.61,"d":"£205.61"},null,{"$f":"Balance","v":{"v":2711.12,"d":"£2,711.12"}}]
[{"$nulls":4},67112449,{"$f":"TODAY()-45","v":"2018-03-26"},"Home Mortgage","Mortgage",{"v":961.77,"d":"£961.77"},null,{"$f":"Balance","v":{"v":1749.35,"d":"£1,749.35"}}]
[{"$nulls":4},"Debit",{"$f":"TODAY()-40","v":"2018-03-31"},"Coffee Shop","Other",{"v":3.65,"d":"£3.65"},null,{"$f":"Balance","v":{"v":1745.6999999999998,"d":"£1,745.70"}}]
[{"$nulls":4},2252,{"$f":"TODAY()-35","v":"2018-04-05"},"Gas and Electricity Company","Utilities",{"v":145.33,"d":"£145.33"},null,{"$f":"Balance","v":{"v":1600.37,"d":"£1,600.37"}}]
[{"$nulls":4},"ATM",{"$f":"TODAY()-30","v":"2018-04-10"},"Cash","Other",{"v":50,"d":"£50.00"},null,{"$f":"Balance","v":{"v":1550.37,"d":"£1,550.37"}}]
[{"$nulls":4},68240158,{"$f":"TODAY()-25","v":"2018-04-15"},"Credit Card","Credit Card",{"v":936.48,"d":"£936.48"},null,{"$f":"Balance","v":{"v":613.8899999999999,"d":"£613.89"}}]
[null,"Summary",{"$nulls":3},{"$f":"TODAY()-20","v":"2018-04-20"},"Pay slip","Deposit",null,{"v":2365.82,"d":"£2,365.82"},{"$f":"Balance","v":{"v":2979.71,"d":"£2,979.71"}}]
[null,"Category","Total",null,null,{"$f":"TODAY()-15","v":"2018-04-25"},"Mutual fund investment","Investment",{"v":200,"d":"£200.00"},null,{"$f":"Balance","v":{"v":2779.71,"d":"£2,779.71"}}]
[null,"Deposit",{"$f":"CategoryTotal","v":{"v":5282.55,"d":"£5,282.55"}},null,2253,{"$f":"TODAY()","v":"2018-05-10"},"The Phone Company","Utilities",{"v":48.87,"d":"£48.87"},null,{"$f":"Balance","v":{"v":2730.84,"d":"£2,730.84"}}]
[null,"Credit Card",{"$f":"CategoryTotal","v":{"v":936.48,"d":"£936.48"}},null,"Totals",{"$nulls":3},{"$f":"SUBTOTAL(109,ChequeRegister[Withdrawal])","v":{"v":2551.71,"d":"£2,551.71"}},{"$f":"SUBTOTAL(109,ChequeRegister[Deposit])","v":{"v":5282.55,"d":"£5,282.55"}},{"$f":"ChequeRegister[[#Totals],[Deposit]]-ChequeRegister[[#Totals],[Withdrawal]]","v":{"v":2730.84,"d":"£2,730.84"}}]
[null,"Investment",{"$f":"CategoryTotal","v":{"v":200,"d":"£200.00"}}]
[null,"Food and household supplies",{"$f":"CategoryTotal","v":{"v":205.61,"d":"£205.61"}}]
[null,"Utilities",{"$f":"CategoryTotal","v":{"v":194.20000000000002,"d":"£194.20"}}]
[null,"Insurance",{"$f":"CategoryTotal","v":{"v":0,"d":"£0.00"}}]
[null,"Mortgage",{"$f":"CategoryTotal","v":{"v":961.77,"d":"£961.77"}}]
[null,"Other",{"$f":"CategoryTotal","v":{"v":53.65,"d":"£53.65"}}]