{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Check Register","How to use this template","Sample"],"not_rendered":{"charts":2,"images":2,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Check Register","index":0,"n_rows":19,"n_cols":11,"rows_kept":19,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6],[14,1,14,2]]}
[null,"Check Register"]
[null,"Enter your bank account number here"]
[null,{"$f":"CONCATENATE(\"Current Balance : \"&TEXT(MyTransactions[[#Totals],[Balance]],\"$#,##0.00\"))","v":"Current Balance : $1,940.00"}]
[]
[{"$nulls":4},"Check #","Date","Description","Category","Withdrawal","Deposit","Balance"]
[{"$nulls":5},"2010-08-01","Beginning Balance","Deposit",null,{"v":2000,"d":"$2,000.00"},{"$f":"MyTransactions[[#This Row],[Deposit]]","v":{"v":2000,"d":"$2,000.00"}}]
[{"$nulls":4},"Debit card","2010-08-02","Toy store","Other",{"v":20,"d":"$20.00"},null,{"$f":"IF(ISBLANK(MyTransactions[[#This Row],[Withdrawal]]),K6+MyTransactions[[#This Row],[Deposit]],K6-MyTransactions[[#This Row],[Withdrawal]])","v":{"v":1980,"d":"$1,980.00"}}]
[{"$nulls":4},1001,"2010-08-04","Grocery Store","Groceries",{"v":40,"d":"$40.00"},null,{"$f":"IF(ISBLANK(MyTransactions[[#This Row],[Withdrawal]]),K7+MyTransactions[[#This Row],[Deposit]],K7-MyTransactions[[#This Row],[Withdrawal]])","v":{"v":1940,"d":"$1,940.00"}}]
[{"$nulls":10},{"$f":"IF(ISBLANK(MyTransactions[[#This Row],[Withdrawal]]),K8+MyTransactions[[#This Row],[Deposit]],K8-MyTransactions[[#This Row],[Withdrawal]])","v":{"v":1940,"d":"$1,940.00"}}]
[{"$nulls":10},{"$f":"IF(ISBLANK(MyTransactions[[#This Row],[Withdrawal]]),K9+MyTransactions[[#This Row],[Deposit]],K9-MyTransactions[[#This Row],[Withdrawal]])","v":{"v":1940,"d":"$1,940.00"}}]
[{"$nulls":4},"Totals",{"$nulls":3},{"$f":"SUBTOTAL(109,MyTransactions[Withdrawal])","v":{"v":60,"d":"$60.00"}},{"$f":"SUBTOTAL(109,MyTransactions[Deposit])","v":{"v":2000,"d":"$2,000.00"}},{"$f":"MyTransactions[[#Totals],[Deposit]]-MyTransactions[[#Totals],[Withdrawal]]","v":{"v":1940,"d":"$1,940.00"}}]
[]
[]
[]
[null,"Summary"]
[null,"Category","Total"]
[null,"Deposit",{"$f":"SUMIF(MyTransactions[Category],\"=\" &CategoryTable[[#This Row],[Category]],MyTransactions[Deposit])","v":{"v":2000,"d":"$2,000.00"}}]
[null,"Groceries",{"$f":"SUMIF(MyTransactions[Category],\"=\" &CategoryTable[[#This Row],[Category]],MyTransactions[Withdrawal])","v":{"v":40,"d":"$40.00"}}]
[null,"Other",{"$f":"SUMIF(MyTransactions[Category],\"=\" &CategoryTable[[#This Row],[Category]],MyTransactions[Withdrawal])","v":{"v":20,"d":"$20.00"}}]

{"sheet":"How to use this template","index":1,"n_rows":4,"n_cols":2,"rows_kept":4}
[]
[null,"Get started using the electronic check register\n\nUse this electronic check register to record your payments, purchases, deposits, and any interest you earn in your checking account. As you choose a category in the Category column for any payment or purchase amounts that you enter, the category slices in the pie chart are updated to show where your money goes. And best of all, this check register always keeps the correct running balance for you.\n\nTo get started, type your account number in cell B2 on the Checkbook Register tab, and replace the value in the first cell of the Deposit column with your own beginning balance. The Balance column automatically updates to show your current balance. Then replace the first few sample entries in the register with your own entries. Make sure you don't overwrite the formulas in the Balance column. Take a look at the Sample tab to see how the register and the expense chart look with a few more sample transactions entered.\n\nBecause this template uses Excel tables, it's easy to add and remove rows, and any formulas in those tables are easy to work with. And the alternate shading of rows in tables is a built-in feature!\n\nAs you make payments or purchases, enter your check or transaction number in the Check # column, type a date in the Date column, type a description in the Description column, choose a category from the dropdown list in the Category column, and type the amount in the Withdrawal column.\n\nMake sure you enter only a positive amount in the Withdrawal and Deposit columns – the formula in the Balance column always subtracts withdrawals and adds deposits. No need to enter negative values!\n\nAs you make deposits or record any earned interest, enter those amounts in the Deposit column. Enter a date and description, and make sure you choose Deposit from the dropdown list in the Category column. It's important to choose Deposit for any deposits or other non-expense related items, because you don't want those amounts calculated in the pie chart that shows your outflow of funds."]
[null,"You can add a new row to the end of the register by positioning your cursor or mouse pointer in the last used cell in the Balance column and then pressing the TAB key. If you need to insert a row between existing rows in the register, do the following:\n\n  1.  Select a cell in the row below where you want to insert the new row.\n  2.  On the Home tab, in the Cells group, point to Insert. Or, you can right-click the mouse and click Insert.\n  3.  Click Insert Table Rows Above."]
[null,"It's important to know that after you have inserted a row between existing rows, you'll need to fix the formula in the row below the new row. Do this by dragging the formula in the Balance column to the cell in the row below it.\n\nYou can further customize your check register by adding your own categories. Do this by following the same steps for inserting a new row in the register, but be sure that you do this in the Category table. To delete categories that you won't use, delete the row in the Category table. Any transactions that had that category value in the Category column of the register won't change or disappear, but that category won't be available to use in the future."]

{"sheet":"Sample","index":2,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6],[14,1,14,2]]}
[null,"Check Register"]
[null,123456789]
[null,{"$f":"CONCATENATE(\"Current Balance : \"&TEXT(MyTransactions1[[#Totals],[Balance]],\"$#,##0.00\"))","v":"Current Balance : $2,730.84"}]
[]
[{"$nulls":4},"Check #","Date","Description","Category","Withdrawal","Deposit","Balance"]
[{"$nulls":5},"2010-08-01","Beginning Balance","Deposit",null,{"v":2916.73,"d":"$2,916.73"},{"$f":"MyTransactions1[[#This Row],[Deposit]]","v":{"v":2916.73,"d":"$2,916.73"}}]
[{"$nulls":4},2251,"2010-08-01","Grocery Store","Groceries",{"v":205.61,"d":"$205.61"},null,{"$f":"IF(ISBLANK(MyTransactions1[[#This Row],[Withdrawal]]),K6+MyTransactions1[[#This Row],[Deposit]],K6-MyTransactions1[[#This Row],[Withdrawal]])","v":{"v":2711.12,"d":"$2,711.12"}}]
[{"$nulls":4},67112449,"2010-08-02","Home Mortgage","Mortgage",{"v":961.77,"d":"$961.77"},null,{"$f":"IF(ISBLANK(MyTransactions1[[#This Row],[Withdrawal]]),K7+MyTransactions1[[#This Row],[Deposit]],K7-MyTransactions1[[#This Row],[Withdrawal]])","v":{"v":1749.35,"d":"$1,749.35"}}]
[{"$nulls":4},"Debit","2010-08-04","Coffee Shop","Other",{"v":3.65,"d":"$3.65"},null,{"$f":"IF(ISBLANK(MyTransactions1[[#This Row],[Withdrawal]]),K8+MyTransactions1[[#This Row],[Deposit]],K8-MyTransactions1[[#This Row],[Withdrawal]])","v":{"v":1745.6999999999998,"d":"$1,745.70"}}]
[{"$nulls":4},2252,"2010-08-05","Gas and Electric Company","Utilities",{"v":145.33,"d":"$145.33"},null,{"$f":"IF(ISBLANK(MyTransactions1[[#This Row],[Withdrawal]]),K9+MyTransactions1[[#This Row],[Deposit]],K9-MyTransactions1[[#This Row],[Withdrawal]])","v":{"v":1600.37,"d":"$1,600.37"}}]
[{"$nulls":4},"ATM","2010-08-07","Cash","Other",{"v":50,"d":"$50.00"},null,{"$f":"IF(ISBLANK(MyTransactions1[[#This Row],[Withdrawal]]),K10+MyTransactions1[[#This Row],[Deposit]],K10-MyTransactions1[[#This Row],[Withdrawal]])","v":{"v":1550.37,"d":"$1,550.37"}}]
[{"$nulls":4},68240158,"2010-08-10","Credit Card","Credit Card",{"v":936.48,"d":"$936.48"},null,{"$f":"IF(ISBLANK(MyTransactions1[[#This Row],[Withdrawal]]),K11+MyTransactions1[[#This Row],[Deposit]],K11-MyTransactions1[[#This Row],[Withdrawal]])","v":{"v":613.8899999999999,"d":"$613.89"}}]
[{"$nulls":5},"2010-08-15","Paycheck","Deposit",null,{"v":2365.82,"d":"$2,365.82"},{"$f":"IF(ISBLANK(MyTransactions1[[#This Row],[Withdrawal]]),K12+MyTransactions1[[#This Row],[Deposit]],K12-MyTransactions1[[#This Row],[Withdrawal]])","v":{"v":2979.71,"d":"$2,979.71"}}]
[{"$nulls":5},"2010-08-18","Mutual fund investment","Investment",{"v":200,"d":"$200.00"},null,{"$f":"IF(ISBLANK(MyTransactions1[[#This Row],[Withdrawal]]),K13+MyTransactions1[[#This Row],[Deposit]],K13-MyTransactions1[[#This Row],[Withdrawal]])","v":{"v":2779.71,"d":"$2,779.71"}}]
[null,"Summary",null,null,2253,"2010-08-20","The Phone Company","Utilities",{"v":48.87,"d":"$48.87"},null,{"$f":"IF(ISBLANK(MyTransactions1[[#This Row],[Withdrawal]]),K14+MyTransactions1[[#This Row],[Deposit]],K14-MyTransactions1[[#This Row],[Withdrawal]])","v":{"v":2730.84,"d":"$2,730.84"}}]
[null,"Category","Total",null,"Totals",{"$nulls":3},{"$f":"SUBTOTAL(109,MyTransactions1[Withdrawal])","v":{"v":2551.71,"d":"$2,551.71"}},{"$f":"SUBTOTAL(109,MyTransactions1[Deposit])","v":{"v":5282.55,"d":"$5,282.55"}},{"$f":"MyTransactions1[[#Totals],[Deposit]]-MyTransactions1[[#Totals],[Withdrawal]]","v":{"v":2730.84,"d":"$2,730.84"}}]
[null,"Deposit",{"$f":"SUMIF(MyTransactions1[Category],\"=\" &CategoryTable1[[#This Row],[Category]],MyTransactions1[Deposit])","v":{"v":5282.55,"d":"$5,282.55"}}]
[null,"Credit Card",{"$f":"SUMIF(MyTransactions1[Category],\"=\" &CategoryTable1[[#This Row],[Category]],MyTransactions1[Withdrawal])","v":{"v":936.48,"d":"$936.48"}}]
[null,"Investment",{"$f":"SUMIF(MyTransactions1[Category],\"=\" &CategoryTable1[[#This Row],[Category]],MyTransactions1[Withdrawal])","v":{"v":200,"d":"$200.00"}}]
[null,"Groceries",{"$f":"SUMIF(MyTransactions1[Category],\"=\" &CategoryTable1[[#This Row],[Category]],MyTransactions1[Withdrawal])","v":{"v":205.61,"d":"$205.61"}}]
[null,"Utilities",{"$f":"SUMIF(MyTransactions1[Category],\"=\" &CategoryTable1[[#This Row],[Category]],MyTransactions1[Withdrawal])","v":{"v":194.20000000000002,"d":"$194.20"}}]
[null,"Insurance",{"$f":"SUMIF(MyTransactions1[Category],\"=\" &CategoryTable1[[#This Row],[Category]],MyTransactions1[Withdrawal])","v":{"v":0,"d":"$0.00"}}]
[null,"Mortgage",{"$f":"SUMIF(MyTransactions1[Category],\"=\" &CategoryTable1[[#This Row],[Category]],MyTransactions1[Withdrawal])","v":{"v":961.77,"d":"$961.77"}}]
[null,"Other",{"$f":"SUMIF(MyTransactions1[Category],\"=\" &CategoryTable1[[#This Row],[Category]],MyTransactions1[Withdrawal])","v":{"v":53.65,"d":"$53.65"}}]