{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["START","PERSONAL MONTHLY BUDGET"],"read":"whole","date_system":"1900"}

{"sheet":"START","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this Personal Monthly Budget worksheet to track your Projected and Actual Monthly Income and Projected and Actual Cost."]
[null,"Enter expenses incurred for various categories in the respective tables."]
[null,"Projected Balance, Actual Balance and Difference are auto-calculated."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in PERSONAL MONTHLY BUDGET worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font colour."]
[null,"To learn more about tables in the worksheet, press SHIFT and then F10 within a table, select the TABLE option, then select ALTERNATIVE TEXT."]

{"sheet":"PERSONAL MONTHLY BUDGET","index":1,"n_rows":64,"n_cols":10,"rows_kept":64,"merged":[[3,1,5,1],[3,2,3,3],[3,6,4,8],[3,9,4,9],[4,2,4,3],[5,2,5,3],[5,6,6,8],[5,9,6,9],[7,1,9,1],[7,2,7,3],[7,6,8,8],[7,9,8,9],[8,2,8,3],[9,2,9,3],[22,6,22,9],[23,1,23,4],[31,6,31,9],[33,1,33,4],[38,6,38,9],[40,1,40,4],[44,6,44,9],[46,1,46,4],[50,6,50,9],[54,1,54,4],[57,6,57,9],[58,6,59,8],[58,9,59,9],[60,6,61,8],[60,9,61,9],[62,6,63,8],[62,9,63,9],[64,1,64,4]]}
["Create a Personal Monthly Budget in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow-down to get started."]
["Title of this worksheet is in cell to the right. Next instruction is in cell A4.","PERSONAL MONTHLY BUDGET"]
[]
["Projected Monthly Income label is in cell to the right. Enter Income 1 in cell E4 and Extra Income in E5 to calculate Total monthly income in E6. Next instruction is in cell A6.","PROJECTED MONTHLY INCOME","Income 1",null,{"v":4300,"d":"£4,300.00"},null,"PROJECTED BALANCE \n(Projected income minus expenses)",null,null,{"$f":"E6-J59","v":{"v":3405,"d":"£3,405.00"}}]
[null,null,"Extra income",null,{"v":300,"d":"£300.00"}]
["Projected Balance is auto-calculated in cell J4, Actual Balance in J6, and Difference in J8. Next instruction is in cell A8.",null,"Total monthly income",null,{"$f":"SUM(E4:E5)","v":{"v":4600,"d":"£4,600.00"}},null,"ACTUAL BALANCE \n(Actual income minus expenses)",null,null,{"$f":"E10-J61","v":{"v":3064,"d":"£3,064.00"}}]
[]
["Actual Monthly Income label is in cell to the right. Enter Income 1 in cell E8 and Extra Income in E9 to calculate Total monthly income in E10. Next instruction is in cell A12.","ACTUAL MONTHLY INCOME","Income 1",null,{"v":4000,"d":"£4,000.00"},null,"DIFFERENCE \n(Actual minus projected)",null,null,{"$f":"J6-J4","v":{"v":-341,"d":"£341.00"}}]
[null,null,"Extra income",null,{"v":300,"d":"£300.00"}]
[null,null,"Total monthly income",null,{"$f":"SUM(E8:E9)","v":{"v":4300,"d":"£4,300.00"}}]
[]
["Enter details in Housing table starting in cell to the right and in Entertainment table starting in cell G12. Next instruction is in cell A25.","HOUSING","Projected Cost","Actual Cost","Difference",null,"ENTERTAINMENT","Projected Cost","Actual Cost","Difference"]
[null,"Mortgage or rent",{"v":1000,"d":"£1,000.00"},{"v":1000,"d":"£1,000.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Videos/DVDs",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Phone",{"v":54,"d":"£54.00"},{"v":100,"d":"£100.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":-46,"d":"-£46.00"}},null,"CDs",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Electricity",{"v":44,"d":"£44.00"},{"v":56,"d":"£56.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":-12,"d":"-£12.00"}},null,"Films",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Gas",{"v":22,"d":"£22.00"},{"v":28,"d":"£28.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":-6,"d":"-£6.00"}},null,"Concerts",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Water and sewer",{"v":8,"d":"£8.00"},{"v":8,"d":"£8.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Sporting events",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Cable",{"v":34,"d":"£34.00"},{"v":34,"d":"£34.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Live theatre",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Waste removal",{"v":10,"d":"£10.00"},{"v":10,"d":"£10.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Other",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Maintenance or repairs",{"v":23,"d":"£23.00"},{"v":0,"d":"£0.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":23,"d":"£23.00"}},null,"Other",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Supplies",{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Other",null,null,{"$f":"Entertainment[[#This Row],[Projected Cost]]-Entertainment[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Other",{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$f":"Housing[[#This Row],[Projected Cost]]-Housing[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Entertainment[Difference])","v":{"v":0,"d":"£0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Housing[Difference])","v":{"v":-41,"d":"-£41.00"}}]
[{"$nulls":6},"LOANS","Projected Cost","Actual Cost","Difference"]
["Enter details in Transport table starting in cell to the right and in Loans table starting in cell G24. Next instruction is in cell A35.","TRANSPORT","Projected Cost","Actual Cost","Difference",null,"Personal",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Vehicle payment",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Student",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Bus/taxi fare",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Insurance",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Licensing",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Credit card",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Fuel",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Other",null,null,{"$f":"Loans[[#This Row],[Projected Cost]]-Loans[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Maintenance",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Loans[Difference])","v":{"v":0,"d":"£0.00"}}]
[null,"Other",null,null,{"$f":"Transport[[#This Row],[Projected Cost]]-Transport[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Transport[Difference])","v":{"v":0,"d":"£0.00"}},null,"TAXES","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Income tax",null,null,{"$f":"Taxes[[#This Row],[Projected Cost]]-Taxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
["Enter details in Insurance table starting in cell to the right and in Taxes table starting in cell G33. Next instruction is in cell A42.","INSURANCE","Projected Cost","Actual Cost","Difference",null,"Council tax",null,null,{"$f":"Taxes[[#This Row],[Projected Cost]]-Taxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Home",null,null,{"$f":"Insurance[[#This Row],[Projected Cost]]-Insurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"VAT/Corporation tax",null,null,{"$f":"Taxes[[#This Row],[Projected Cost]]-Taxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Health",null,null,{"$f":"Insurance[[#This Row],[Projected Cost]]-Insurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Other",null,null,{"$f":"Taxes[[#This Row],[Projected Cost]]-Taxes[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Life",null,null,{"$f":"Insurance[[#This Row],[Projected Cost]]-Insurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Taxes[Difference])","v":{"v":0,"d":"£0.00"}}]
[null,"Other",null,null,{"$f":"Insurance[[#This Row],[Projected Cost]]-Insurance[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Insurance[Difference])","v":{"v":0,"d":"£0.00"}},null,"SAVINGS OR INVESTMENTS","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Retirement account",null,null,{"$f":"Savings[[#This Row],[Projected Cost]]-Savings[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
["Enter details in Food table starting in cell to the right and in Savings table starting in cell G40. Next instruction is in cell A48.","FOOD","Projected Cost","Actual Cost","Difference",null,"Investment account",null,null,{"$f":"Savings[[#This Row],[Projected Cost]]-Savings[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Food and drink",null,null,{"$f":"Food[[#This Row],[Projected Cost]]-Food[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Other",null,null,{"$f":"Savings[[#This Row],[Projected Cost]]-Savings[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Dining out",null,null,{"$f":"Food[[#This Row],[Projected Cost]]-Food[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Savings[Difference])","v":{"v":0,"d":"£0.00"}}]
[null,"Other",null,null,{"$f":"Food[[#This Row],[Projected Cost]]-Food[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Food[Difference])","v":{"v":0,"d":"£0.00"}},null,"GIFTS AND DONATIONS","Projected Cost","Actual Cost","Difference"]
[{"$nulls":6},"Charity 1",null,null,{"$f":"Gifts[[#This Row],[Projected Cost]]-Gifts[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
["Enter details in Pets table starting in cell to the right and in Gifts table starting in cell G46. Next instruction is in cell A56.","PETS","Projected Cost","Actual Cost","Difference",null,"Charity 2",null,null,{"$f":"Gifts[[#This Row],[Projected Cost]]-Gifts[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Food",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Charity 3",null,null,{"$f":"Gifts[[#This Row],[Projected Cost]]-Gifts[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Medical",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Gifts[Difference])","v":{"v":0,"d":"£0.00"}}]
[null,"Grooming",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Toys",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"LEGAL","Projected Cost","Actual Cost","Difference"]
[null,"Other",null,null,{"$f":"Pets[[#This Row],[Projected Cost]]-Pets[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Lawyer",null,null,{"$f":"Legal[[#This Row],[Projected Cost]]-Legal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Pets[Difference])","v":{"v":0,"d":"£0.00"}},null,"Spousal maintenance support",null,null,{"$f":"Legal[[#This Row],[Projected Cost]]-Legal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":6},"Payments on lien or judgment",null,null,{"$f":"Legal[[#This Row],[Projected Cost]]-Legal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
["Enter details in Personal Care table starting in cell to the right and in Legal table starting in cell G52. Next instruction is in cell A59.","PERSONAL CARE","Projected Cost","Actual Cost","Difference",null,"Other",null,null,{"$f":"Legal[[#This Row],[Projected Cost]]-Legal[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Medical",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Legal[Difference])","v":{"v":0,"d":"£0.00"}}]
[null,"Hair/nails",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
["Total Projected Cost is auto-calculated in cell J59, Total Actual Cost in J61, and Total Difference in J63.","Clothing",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"TOTAL PROJECTED COST",null,null,{"$f":"SUBTOTAL(109,Housing[Projected Cost],Transport[Projected Cost],Insurance[Projected Cost],Food[Projected Cost],Pets[Projected Cost],PersonalCare[Projected Cost],Entertainment[Projected Cost],Loans[Projected Cost],Taxes[Projected Cost],Savings[Projected Cost],Gifts[Projected Cost],Legal[Projected Cost])","v":{"v":1195,"d":"£1,195.00"}}]
[null,"Dry cleaning",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Health club",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"TOTAL ACTUAL COST",null,null,{"$f":"SUBTOTAL(109,Housing[Actual Cost],Transport[Actual Cost],Insurance[Actual Cost],Food[Actual Cost],Pets[Actual Cost],PersonalCare[Actual Cost],Entertainment[Actual Cost],Loans[Actual Cost],Taxes[Actual Cost],Savings[Actual Cost],Gifts[Actual Cost],Legal[Actual Cost])","v":{"v":1236,"d":"£1,236.00"}}]
[null,"Organisation dues or fees",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}}]
[null,"Other",null,null,{"$f":"PersonalCare[[#This Row],[Projected Cost]]-PersonalCare[[#This Row],[Actual Cost]]","v":{"v":0,"d":"£0.00"}},null,"TOTAL DIFFERENCE",null,null,{"$f":"J59-J61","v":{"v":-41,"d":"£41.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,PersonalCare[Difference])","v":{"v":0,"d":"£0.00"}}]