{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Your Budget Expenses","Budget Monitoring"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Your Budget Expenses","index":0,"n_rows":77,"n_cols":5,"rows_kept":77,"cut":false,"hidden":false,"merged":[[3,5,4,5],[3,0,4,1]]}
["FAMILY"]
[]
[null,"Weekly budget"]
["YOUR BUDGET EXPENSES",null,"AMOUNT","FREQUENCY","YEARLY "]
[null,null,null,"(Wk=52, Mth=12, Qtr=4)","TOTAL"]
[]
["Net Income"]
[null,null,null,52,{"$f":"+C8*D8","v":0}]
[null,null,null,52,{"$f":"+C9*D9","v":0}]
[null,null,null,52,{"$f":"D10*C10","v":0}]
[null,null,null,52,{"$f":"+C11*D11","v":0}]
["TOTAL INCOME",null,null,null,{"$f":"SUM(E8:E11)","v":0}]
[]
["Living Expenses"]
[null,"food",null,52,{"$f":"+C15*D15","v":0}]
[null,"beauty & hair",null,52,{"$f":"C16*D16","v":0}]
[null,"Clothing",null,52,0]
[null,"Medical/Denta/Pharmacy",null,52,0]
[null,"Alchol/Cigarettes",null,52,0]
[null,"Public Transport/Taxi Fees",null,52,0]
[null,"Other Personal Spending",null,52,0]
["TOTAL LIVING EXPENSES",null,null,null,{"$f":"+SUM(E15:E21)","v":0}]
[]
["Entertainment Expenses"]
[null,"Travel and Holidays",null,52,{"$f":"+C25*D25","v":0}]
[null,"Dining Out",null,52,0]
[null,"Sport and Recreation/Hobbies",null,52,0]
[null,"Club Membership/Sporting Fees",null,52,0]
[null,"Books Magazine/Newpapers",null,52,0]
[null,"Other Entertainment- entry fees",null,52,0]
["TOTAL ENTERTAINMENT EXPENSES",null,null,null,{"$f":"SUM(E25:E30)","v":0}]
[]
["Housing Expenses"]
[null,"Mortgage ",null,52,0]
[null,"Council/Shire/Body Corporate/Water Rates",null,52,0]
[null,"Electricity/Gas/Telephone/Internet",null,52,0]
[null,"House and Contents Insurance",null,52,0]
[null,"Home Maintenance",null,52,0]
[null,"Other - pool and garden",null,52,{"$f":"+C39*D39","v":0}]
[null,"Furnishing and Appliances",null,52,0]
["TOTAL HOUSING EXPENSES",null,null,null,{"$f":"SUM(E34:E40)","v":0}]
[]
["Motor Vehicle Expenses"]
[null,"Loan/Lease Repayment",null,52,{"$f":"+C44*D44","v":0}]
[null,"Regaistration and Third Party",null,52,0]
[null,"Insurance",null,52,0]
[null,"Petrol and Other Running Costs",null,52,0]
[null,"Maintenance/Service/Repairs",null,52,0]
[null,"Licence Fees/Fines/Parking/Road Assist",null,52,0]
["TOTAL MOTOR VEHICLES EXPENSES",null,null,null,{"$f":"SUM(E44:E49)","v":0}]
[]
["Insurance"]
[null,"Medical/Health",null,52,0]
[null,"Life and TPD",null,52,0]
[null,"Income Protection",null,52,0]
[null,"Via superanuation contributions",null,52,0]
[null,"Trauma Cover",null,52,0]
["TOTAL INSURANCE",null,null,null,{"$f":"+SUM(E53:E57)","v":0}]
[]
["Miscellaneous"]
[null,"Profession Services (Accountant Fees)",null,52,0]
[null,"Profession Membership",null,52,0]
[null,"Work Related Expenses",null,52,0]
[null,"Gifts and Donations",null,52,0]
[null,"Education Expenses",null,52,0]
[null,"Child Care",null,52,0]
[null,"Pet/Vet Fees",null,52,0]
[null,"Savings Plans (Existing Investment)",null,52,0]
[null,"Capital Expenses to Investment Properties",null,52,0]
[null,"Other Vehicles Expenses (Boat Caravan etc)",null,52,0]
[null,"Investment Loans",null,52,0]
[null,"Credit Cards",null,52,0]
[null,"Other - pocket money",null,52,0]
["TOTAL MISCELLANEOUS EXPENSES",null,null,null,{"$f":"+SUM(E61:E73)","v":0}]
[]
[]
["TOTAL EXPENSES",null,null,null,{"$f":"+E74+E58+E50+E41+E31+E22","v":0}]

{"sheet":"Budget Monitoring","index":1,"n_rows":69,"n_cols":58,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,1,1,3]]}
["FAMILY BUDGET MONITORING"]
[null,"YTD Budget Enter Number of Weeks",null,null,12]
[null,"Annual","Weekly",null,"YTD Budget","YTD Actual","Wk 1","Wk 2","Wk 3","Wk 4","Wk 5","Wk 6","Wk 7","Wk 8","Wk 9","Wk 10","Wk 11","Wk 12","Wk 13","Wk 14","Wk 15","Wk 16","Wk 17","Wk 18","Wk 19","Wk 20","Wk 21","Wk 22","Wk 23","Wk 24","Wk 25","Wk 26","Wk 27","Wk 28","Wk 29","Wk 30","Wk 31","Wk 32","Wk 33","Wk 34","Wk 35","Wk 36","Wk 37","Wk 38","Wk 39","Wk 40","Wk 41","Wk 42","Wk 43","Wk 44","Wk 45","Wk 46","Wk 47","Wk 48","Wk 49","Wk 50","Wk 51","Wk 52"]
[{"$f":"+[1]Budget!A3","v":"Net Income"},{"$f":"+'Your Budget Expenses'!E8+'Your Budget Expenses'!E9","v":0},{"$f":"ROUND(+B4/52,0)","v":0},null,{"$f":"+C4*$E$2","v":0},{"$f":"+SUM(G4:BF4)","v":0}]
[{"$f":"+[1]Budget!A4","v":"Rental"},{"$f":"+'Your Budget Expenses'!E11","v":0},{"$f":"ROUND(+B5/52,0)","v":0},null,{"$f":"+C5*$E$2","v":0},{"$f":"+SUM(G5:BF5)","v":0}]
[null,{"$f":"SUM(B4:B5)","v":0},0,null,{"$f":"+C6*$E$2","v":0},{"$f":"+SUM(F4:F5)","v":0},{"$f":"+SUM(G4:G5)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"+'Your Budget Expenses'!A14","v":"Living Expenses"}]
[{"$f":"+'Your Budget Expenses'!B15","v":"food"},{"$f":"+'Your Budget Expenses'!E15","v":0},0,null,{"$f":"+C9*$E$2","v":0},{"$f":"+SUM(G9:BF9)","v":0}]
[{"$f":"+'Your Budget Expenses'!B17","v":"Clothing"},{"$f":"+'Your Budget Expenses'!E17","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B18","v":"Medical/Denta/Pharmacy"},{"$f":"+'Your Budget Expenses'!E18","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B19","v":"Alchol/Cigarettes"},{"$f":"+'Your Budget Expenses'!E19","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B20","v":"Public Transport/Taxi Fees"},{"$f":"+'Your Budget Expenses'!E20","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B21","v":"Other Personal Spending"},{"$f":"+'Your Budget Expenses'!E21","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!A22","v":"TOTAL LIVING EXPENSES"},{"$f":"SUM(B9:B14)","v":0},{"$f":"SUM(C9:C14)","v":0},null,{"$f":"+SUM(E9:E14)","v":0},{"$f":"+SUM(F9:F14)","v":0},{"$f":"SUM(G9:G14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"+'Your Budget Expenses'!A24","v":"Entertainment Expenses"}]
[{"$f":"+'Your Budget Expenses'!B25","v":"Travel and Holidays"},{"$f":"+'Your Budget Expenses'!E25","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B26","v":"Dining Out"},{"$f":"+'Your Budget Expenses'!E26","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B27","v":"Sport and Recreation/Hobbies"},{"$f":"+'Your Budget Expenses'!E27","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B28","v":"Club Membership/Sporting Fees"},{"$f":"+'Your Budget Expenses'!E28","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B29","v":"Books Magazine/Newpapers"},{"$f":"+'Your Budget Expenses'!E29","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B30","v":"Other Entertainment- entry fees"},{"$f":"+'Your Budget Expenses'!E30","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!A31","v":"TOTAL ENTERTAINMENT EXPENSES"},{"$f":"SUM(B18:B23)","v":0},0,null,0,0,{"$f":"SUM(G18:G23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"+'Your Budget Expenses'!A33","v":"Housing Expenses"}]
[{"$f":"+'Your Budget Expenses'!B34","v":"Mortgage "},{"$f":"+'Your Budget Expenses'!E34","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B35","v":"Council/Shire/Body Corporate/Water Rates"},{"$f":"+'Your Budget Expenses'!E35","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B36","v":"Electricity/Gas/Telephone/Internet"},{"$f":"+'Your Budget Expenses'!E36","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B37","v":"House and Contents Insurance"},{"$f":"+'Your Budget Expenses'!E37","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B38","v":"Home Maintenance"},{"$f":"+'Your Budget Expenses'!E38","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B40","v":"Furnishing and Appliances"},{"$f":"+'Your Budget Expenses'!E40","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!A41","v":"TOTAL HOUSING EXPENSES"},{"$f":"+'Your Budget Expenses'!E41","v":0},0,null,0,{"$f":"+SUM(G33:BF33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AM33:CL33)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"+'Your Budget Expenses'!A43","v":"Motor Vehicle Expenses"}]
[{"$f":"+'Your Budget Expenses'!B44","v":"Loan/Lease Repayment"},{"$f":"+'Your Budget Expenses'!E44","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B45","v":"Regaistration and Third Party"},{"$f":"+'Your Budget Expenses'!E45","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B46","v":"Insurance"},{"$f":"+'Your Budget Expenses'!E46","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B47","v":"Petrol and Other Running Costs"},{"$f":"+'Your Budget Expenses'!E47","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B48","v":"Maintenance/Service/Repairs"},{"$f":"+'Your Budget Expenses'!E48","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B49","v":"Licence Fees/Fines/Parking/Road Assist"},{"$f":"+'Your Budget Expenses'!E49","v":0},{"$f":"ROUND(+B41/52,0)","v":0},null,{"$f":"+C41*$E$2","v":0},{"$f":"+SUM(G41:BF41)","v":0}]
[{"$f":"+'Your Budget Expenses'!A50","v":"TOTAL MOTOR VEHICLES EXPENSES"},{"$f":"+'Your Budget Expenses'!E50","v":0},0,null,{"$f":"+C42*$E$2","v":0},{"$f":"+SUM(F8:F41)","v":0},{"$f":"+SUM(G8:G41)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"+'Your Budget Expenses'!A52","v":"Insurance"}]
[{"$f":"+'Your Budget Expenses'!B53","v":"Medical/Health"},{"$f":"+'Your Budget Expenses'!E53","v":0},{"$f":"ROUND(+B45/52,0)","v":0},null,{"$f":"+C45*$E$2","v":0},{"$f":"+SUM(G45:BF45)","v":0}]
[{"$f":"+'Your Budget Expenses'!B54","v":"Life and TPD"},{"$f":"+'Your Budget Expenses'!E54","v":0},{"$f":"ROUND(+B46/52,0)","v":0},null,{"$f":"+C46*$E$2","v":0},{"$f":"+SUM(G46:BF46)","v":0}]
[{"$f":"+'Your Budget Expenses'!B55","v":"Income Protection"},{"$f":"+'Your Budget Expenses'!E55","v":0},{"$f":"ROUND(+B47/52,0)","v":0},null,{"$f":"+C47*$E$2","v":0},{"$f":"+SUM(G47:BF47)","v":0}]
[{"$f":"+'Your Budget Expenses'!B56","v":"Via superanuation contributions"},{"$f":"+'Your Budget Expenses'!E56","v":0},{"$f":"ROUND(+B48/52,0)","v":0},null,{"$f":"+C48*$E$2","v":0},{"$f":"+SUM(G48:BF48)","v":0}]
[{"$f":"+'Your Budget Expenses'!B57","v":"Trauma Cover"},{"$f":"+'Your Budget Expenses'!E57","v":0},{"$f":"ROUND(+B49/52,0)","v":0},null,{"$f":"+C49*$E$2","v":0},{"$f":"+SUM(G49:BF49)","v":0}]
[{"$f":"+'Your Budget Expenses'!A58","v":"TOTAL INSURANCE"},{"$f":"+'Your Budget Expenses'!E58","v":0},0,null,0,0,{"$f":"+SUM(H50:BG50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AN50:CM50)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"+'Your Budget Expenses'!A60","v":"Miscellaneous"}]
[{"$f":"+'Your Budget Expenses'!B61","v":"Profession Services (Accountant Fees)"},{"$f":"+'Your Budget Expenses'!E61","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B62","v":"Profession Membership"},{"$f":"+'Your Budget Expenses'!E62","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B63","v":"Work Related Expenses"},{"$f":"+'Your Budget Expenses'!E63","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B64","v":"Gifts and Donations"},{"$f":"+'Your Budget Expenses'!E64","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B65","v":"Education Expenses"},{"$f":"+'Your Budget Expenses'!E65","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B66","v":"Child Care"},{"$f":"+'Your Budget Expenses'!E66","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B67","v":"Pet/Vet Fees"},{"$f":"+'Your Budget Expenses'!E67","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B68","v":"Savings Plans (Existing Investment)"},{"$f":"+'Your Budget Expenses'!E68","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B69","v":"Capital Expenses to Investment Properties"},{"$f":"+'Your Budget Expenses'!E69","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B70","v":"Other Vehicles Expenses (Boat Caravan etc)"},{"$f":"+'Your Budget Expenses'!E70","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B71","v":"Investment Loans"},{"$f":"+'Your Budget Expenses'!E71","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B72","v":"Credit Cards"},{"$f":"+'Your Budget Expenses'!E72","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B39","v":"Other - pool and garden"},{"$f":"+'Your Budget Expenses'!E39","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!B73","v":"Other - pocket money"},{"$f":"+'Your Budget Expenses'!E73","v":0},0,null,0,0]
[{"$f":"+'Your Budget Expenses'!A74","v":"TOTAL MISCELLANEOUS EXPENSES"},{"$f":"+'Your Budget Expenses'!E74","v":0},0,null,0,0,{"$f":"+SUM(H67:BG67)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+SUM(AN67:CM67)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"+'Your Budget Expenses'!A77","v":"TOTAL EXPENSES"},{"$f":"+B67+B50+B42+B33+B24+B15","v":0},{"$f":"+C67+C50+C42+C33+C24+C15","v":0},null,{"$f":"+E67+E50+E42+E33+E24+E15","v":0},{"$f":"+F67+F50+F42+F33+F24+F15","v":0},{"$f":"+G67+G50+G42+G33+G24+G15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]