{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Budget","Record Expenses","Expenses Automatically Sorted","Notes","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[18,0,18,3]]}
[null,null,null," Monthly Budget for ","Month Year"]
[null,null,null,"Available Funds",null,null,"Calculate Priority Payments"]
[null,null,null,"Net earnings",100.0,"Income: "]
[{"$nulls":5},"Percent: ",0.1]
[{"$nulls":6},{"$f":"iferror($G$3*G4,\"\")","v":0}]
[]
[]
[]
[null,null,null,"Total available:",{"$f":"SUM(E3:E8)","v":100}]
[]
[null,null,null,"Priority Payments ","Amount Paid"]
[null,null,null,"Savings"]
[]
[]
[]
[null,null,null,"Total priority payments: ",{"$f":"sum(E12:E15)*-1","v":0}]
[null,null,null,"Total remaining:",{"$f":"E9+E16","v":100}]
[]
["Amount unassigned to categories:",null,null,null,{"$f":"E17-E22","v":95}]
[]
[{"$nulls":4},"Total Assigned","Total Spent","Total Remaining"]
[{"$nulls":4},{"$f":"SUM(E25:E59)","v":5},5,{"$f":"E22-ABS(F22)","v":0}]
[{"$nulls":6},{"$f":"'Record Expenses'!C1","v":"F"}]
[null,null,null,"Category ","Amount Assigned","Amount Spent","Amount Remaining"]
[null,null,1.0,"Your own categories",null,{"$f":"IF(D25=\"\",\"\",SUMIF('Record Expenses'!A:A,D25,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":0},{"$f":"IF(D25=\"\",\"\",E25-ABS(F25))","v":0}]
[null,null,2.0,"Mortgage",null,{"$f":"IF(D26=\"\",\"\",SUMIF('Record Expenses'!A:A,D26,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":0},0]
[null,null,3.0,"Utilities",null,{"$f":"IF(D27=\"\",\"\",SUMIF('Record Expenses'!A:A,D27,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":0},0]
[null,null,4.0,"Household",5.0,{"$f":"IF(D28=\"\",\"\",SUMIF('Record Expenses'!A:A,D28,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":5},0]
[null,null,5.0,"Clothing",null,{"$f":"IF(D29=\"\",\"\",SUMIF('Record Expenses'!A:A,D29,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":0},0]
[null,null,6.0,"Car maintenance",null,{"$f":"IF(D30=\"\",\"\",SUMIF('Record Expenses'!A:A,D30,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":0},0]
[null,null,7.0,"Car payment",null,{"$f":"IF(D31=\"\",\"\",SUMIF('Record Expenses'!A:A,D31,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":0},0]
[null,null,8.0,"Groceries",null,{"$f":"IF(D32=\"\",\"\",SUMIF('Record Expenses'!A:A,D32,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":0},0]
[null,null,9.0,"Gasoline",null,{"$f":"IF(D33=\"\",\"\",SUMIF('Record Expenses'!A:A,D33,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":0},0]
[null,null,10.0,"Recreation",null,{"$f":"IF(D34=\"\",\"\",SUMIF('Record Expenses'!A:A,D34,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":0},0]
[null,null,11.0,null,null,{"$f":"IF(D35=\"\",\"\",SUMIF('Record Expenses'!A:A,D35,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,12.0,null,null,{"$f":"IF(D36=\"\",\"\",SUMIF('Record Expenses'!A:A,D36,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,13.0,null,null,{"$f":"IF(D37=\"\",\"\",SUMIF('Record Expenses'!A:A,D37,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,14.0,null,null,{"$f":"IF(D38=\"\",\"\",SUMIF('Record Expenses'!A:A,D38,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,15.0,null,null,{"$f":"IF(D39=\"\",\"\",SUMIF('Record Expenses'!A:A,D39,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,16.0,null,null,{"$f":"IF(D40=\"\",\"\",SUMIF('Record Expenses'!A:A,D40,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,17.0,null,null,{"$f":"IF(D41=\"\",\"\",SUMIF('Record Expenses'!A:A,D41,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,18.0,null,null,{"$f":"IF(D42=\"\",\"\",SUMIF('Record Expenses'!A:A,D42,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,19.0,null,null,{"$f":"IF(D43=\"\",\"\",SUMIF('Record Expenses'!A:A,D43,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,20.0,null,null,{"$f":"IF(D44=\"\",\"\",SUMIF('Record Expenses'!A:A,D44,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,21.0,null,null,{"$f":"IF(D45=\"\",\"\",SUMIF('Record Expenses'!A:A,D45,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,22.0,null,null,{"$f":"IF(D46=\"\",\"\",SUMIF('Record Expenses'!A:A,D46,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,23.0,null,null,{"$f":"IF(D47=\"\",\"\",SUMIF('Record Expenses'!A:A,D47,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,24.0,null,null,{"$f":"IF(D48=\"\",\"\",SUMIF('Record Expenses'!A:A,D48,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,25.0,null,null,{"$f":"IF(D49=\"\",\"\",SUMIF('Record Expenses'!A:A,D49,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,26.0,null,null,{"$f":"IF(D50=\"\",\"\",SUMIF('Record Expenses'!A:A,D50,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,27.0,null,null,{"$f":"IF(D51=\"\",\"\",SUMIF('Record Expenses'!A:A,D51,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,28.0,null,null,{"$f":"IF(D52=\"\",\"\",SUMIF('Record Expenses'!A:A,D52,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,29.0,null,null,{"$f":"IF(D53=\"\",\"\",SUMIF('Record Expenses'!A:A,D53,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,30.0,null,null,{"$f":"IF(D54=\"\",\"\",SUMIF('Record Expenses'!A:A,D54,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,31.0,null,null,{"$f":"IF(D55=\"\",\"\",SUMIF('Record Expenses'!A:A,D55,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,32.0,null,null,{"$f":"IF(D56=\"\",\"\",SUMIF('Record Expenses'!A:A,D56,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]
[null,null,33.0]
[null,null,34.0,null,null,{"$f":"IF(D58=\"\",\"\",SUMIF('Record Expenses'!A:A,D58,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},{"$f":"IF(D58=\"\",\"\",E58-ABS(F58))","v":""}]
[null,null,35.0,null,null,{"$f":"IF(D59=\"\",\"\",SUMIF('Record Expenses'!A:A,D59,INDIRECT(\"'Record Expenses'!\"&$G$23&\":\"&$G$23)))","v":""},""]

{"sheet":"Record Expenses","index":1,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Record Expenses","Select Column with Expense Amounts:","F","  The expense column is highlighted in yellow."]
[null,null,{"$f":"if(C1 = \"B\",2,if(C1 = \"C\",3, if(C1 = \"D\",4, if(C1 = \"E\",5, if(C1 = \"F\",6, if(C1 = \"G\",7, if(C1 = \"H\",8, if(C1 = \"I\",9, if(C1 = \"J\",10,if(C1 = \"K\",11,if(C1 = \"L\",12,\"\") ))))))))))\n","v":6}]
["Select Category Per Expense:","Copy & Paste Data from Bank"]
[null,"Expenses","Expenses",null,"Expenses","Expenses",null,"Expenses","Expenses","Expenses","Expenses","Expenses","Expenses"]
[]
[]
[]
["Household",null,null,"Sample Expense",null,5.0]

{"sheet":"Expenses Automatically Sorted","index":2,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[{"$f":"SORT('Record Expenses'!5:886)","v":"Household"},null,null,"Sample Expense",null,5.0]

{"sheet":"Notes","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions","index":4,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["https://amonthlybudget.com/"]
["version 2.0 for Google Sheets"]
["2019-08-01"]
["This budget is licensed as public domain."]
[]
["Budget tab",1.0,"Complete the section for available funds on the first tab. Yellow fields are for data entry."]
["",2.0,"If desired, complete the section for priority payments, such as 10% to a savings account."]
[null,3.0,"Create your own budget categories."]
[null,4.0,"Assign a portion of the remaining funds to each category."]
["Record Expenses",5.0,"On the \"Record Expenses\" tab, copy and paste data from your bank or manually enter expenses."]
[null,null,"You may want to copy data that has been downloaded or exported to a .CSV or Excel file."]
["Select Column",6.0,"Select the row that column for the expense amounts in the selector near the top of the page."]
[null,null,"You may want to add comments or edit the data for your needs, but all expenses should be in the same column."]
[null,null,"Expenses may be entered as negative or positive numbers."]
["Select Category",7.0,"In the drop-down menus in the first column, assign a category to each expense."]
[null,null,"Expenses can be edited or explained with comments. For example:"]
[null,null,"If one purchase covers multiple categories, enter additional sub-amounts on separate rows."]
[null,null,"These sub-amounts can be categorized instead of the total."]