{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Expenses","Budget vs. Spent","©"],"not_rendered":{"charts":2,"images":3,"defined_names":6},"unopened":[{"sheet":"Budget vs. Spent","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Expenses","index":0,"n_rows":39,"n_cols":15,"rows_kept":39}
["Expense Tracking"]
[{"$nulls":14},"© 2009-2019 Vertex42 LLC"]
[null,null,"Budget",null,{"v":18750,"d":"18,750"},{"v":13125,"d":"13,125"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},{"v":2500,"d":"2,500"},500,null,{"$f":"SUM(D3:L3)","v":{"v":42375,"d":"42,375"}},null,{"$f":"HYPERLINK(\"https://www.vertex42.com/ExcelTemplates/expense-tracker.html\",\"Expense Tracking Template\")","v":"Expense Tracking Template"}]
[null,null,"% Spent",{"$f":"IF(D3=0,\"-\",D39/D3)","v":"-"},{"$f":"IF(E3=0,\"-\",E39/E3)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(F3=0,\"-\",F39/F3)","v":{"v":0.01180952380952381,"d":"1.2%"}},{"$f":"IF(G3=0,\"-\",G39/G3)","v":{"v":0.9376,"d":"93.8%"}},{"$f":"IF(H3=0,\"-\",H39/H3)","v":{"v":2E-3,"d":"0.2%"}},{"$f":"IF(I3=0,\"-\",I39/I3)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(J3=0,\"-\",J39/J3)","v":{"v":0,"d":"0.0%"}},{"$f":"IF(K3=0,\"-\",K39/K3)","v":{"v":0.17446,"d":"17.4%"}},{"$f":"IF(L3=0,\"-\",L39/L3)","v":"-"},{"$f":"IF(M3=0,\"-\",M39/M3)","v":{"v":0.06114997050147493,"d":"6.1%"}}]
[null,null,"Remaining",null,{"$f":"E3-E39","v":{"v":18750,"d":"18,750"}},{"$f":"F3-F39","v":{"v":12970,"d":"12,970"}},{"$f":"G3-G39","v":156},{"$f":"H3-H39","v":{"v":2495,"d":"2,495"}},{"$f":"I3-I39","v":{"v":2500,"d":"2,500"}},{"$f":"J3-J39","v":{"v":2500,"d":"2,500"}},{"$f":"K3-K39","v":{"v":412.77,"d":"413"}},{"$f":"L3-L39","v":0},{"$f":"M3-M39","v":{"v":39783.77,"d":"39,784"}}]
[{"$nulls":12},"[42]"]
["Date","Payment\nType","Description",null,"Category 1","Category 2","Category 3","Category 4","Category 5","Category 6","Other",null,"Subtotal",null,"← You can update category labels in this row"]
["2019-01-01","CrCard","XYZ Supply Store",{"$nulls":3},{"v":2344,"d":"2,344.00"},{"$nulls":3},87.23,null,{"$f":"SUM(D8:L8)","v":{"v":2431.23,"d":"2,431.23"}}]
["2019-01-10",2032,"ABC Services, Inc.",null,null,{"v":155,"d":"155.00"},null,{"v":5,"d":"5.00"},{"$nulls":4},{"v":160,"d":"160.00"},null,"Additional Templates"]
[{"$nulls":12},0,null,"► More Budget Templates"]
[{"$nulls":12},0,null,"► Money Manager"]
[{"$nulls":12},0,null,"► Financial Calculators"]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0,null,"Add Another Category"]
[{"$nulls":12},0,null,"1. Insert a new column before the Other column"]
[{"$nulls":12},0,null,"2. Copy/Paste formulas in the header and total rows"]
[{"$nulls":12},0,null,"3. Update the new category label"]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0]
[{"$nulls":12},0,null,"← Insert new rows ABOVE this one"]
[{"$nulls":12},0]
[null,null,"Expense Total",{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E7:E38)","v":0},{"$f":"SUM(F7:F38)","v":{"v":155,"d":"155.00"}},{"$f":"SUM(G7:G38)","v":{"v":2344,"d":"2,344.00"}},{"$f":"SUM(H7:H38)","v":{"v":5,"d":"5.00"}},{"$f":"SUM(I7:I38)","v":0},{"$f":"SUM(J7:J38)","v":0},{"$f":"SUM(K7:K38)","v":87.23},{"$f":"SUM(L8:L38)","v":0},{"v":2591.23,"d":"2,591.23"}]

{"sheet":"©","index":2,"n_rows":17,"n_cols":2,"rows_kept":17}
[null,"Expense Tracking Template"]
[]
[null,"By Vertex42.com"]
[null,"https://www.vertex42.com/ExcelTemplates/expense-tracker.html"]
[]
[null,"© 2009-2019 Vertex42 LLC"]
[]
[null,"This spreadsheet, including all worksheets and associated content is a copyrighted work under the United States and other copyright laws."]
[]
[null,"Do not submit copies or modifications of this template to any website or online template gallery."]
[]
[null,"Please review the following license agreement to learn how you may or may not use this template. Thank you."]
[]
[null,"License Agreement"]
[null,"https://www.vertex42.com/licensing/EULA_privateuse.html"]
[]
[null,"Do not delete this worksheet"]