Num Sum
Log In
|
Create a FREE Account
|
Everyone's Spreadsheets
|
Tags
The comma separated values (CSV) data for spreadsheet:
Copy of FAMILY EXPENSES SPREADSHEET
Just copy and paste it to where-ever you need it...
Family Monthly Budget,,,,,,,,,, ,,,,,,,,,, ,Total Projected Cost,Total Actual Cost,Total Difference,,Projected Monthly Income,,,,, ,=SUM(B19\,B30\,B37\,B43\,B55\,B63\,B73\,G37\,G46\,G53\,G60\,G66\,G73),=SUM(C19\,C30\,C37\,C43\,C55\,C63\,C73\,H37\,H46\,H53\,H60\,H66\,H73),=SUM(D19\,D30\,D37\,D43\,D55\,D63\,D73\,I37\,I46\,I53\,I60\,I66\,I73),,Income 1,4333,,,, ,,,,,Income 2,,,,, ,,,,,Extra income,,,,, Housing,Projected Cost,Actual Cost,Difference,,Total monthly income,=SUM(G4:G6),,,, Mortgage or rent,$1290,$1290,=B8-C8,,,,,,, Second mortgage or rent,$0,100,=B9-C9,,Actual Monthly Income,,,,, Phone,$0,$0,=B10-C10,,Income 1,$4\,333,,lt,, Electricity,$100,$100,=B11-C11,,Income 2,,,,, Gas,$120,$120,=B12-C12,,Extra income,,,,, Water and sewer,$50,$50,=B13-C13,,Total monthly income,=SUM(G10:G12),,,, Cable,$50,$50,=B14-C14,,,,,,, Waste removal,$22,$22,=B15-C15,,Projected balance,=G7-B4,,,, Maintenance or repairs,$0,$0,=B16-C16,,,,,,, Supplies,$0,$0,=B17-C17,,Actual balance,873,,,, Other,$75,$75,=B18-C18,,,,,,, Subtotals,=SUM(B8:B18),=SUM(C8:C18),=SUM(D8:D18),,Difference,=G17-G15,,,, ,,,,,,,,,, Transportation,,,,,,,,,, Vehicle 1 payment,$460,$460,=B22-C22,,,,,,, Vehicle 2 payment,$276,$276,=B23-C23,,,,,,, Bus/taxi fare,,,=B24-C24,,,,,,, Insurance,$107,$107,=B25-C25,,,,,,, Licensing,,,=B26-C26,,,,,,, Fuel,,,=B27-C27,,,,,,, Maintenance,,,=B28-C28,,,,,,, Other,,,=B29-C29,,Entertainment,Projected Cost,Actual Cost,Difference,, Subtotals,=SUM(B22:B29),=SUM(C22:C29),=SUM(D22:D29),,Video/DVD,,,,,,=G30-H30, ,,,,,CDs,,,=G31-H31,, Insurance,,,,,Movies,,,=G32-H32,, Home,,,=B33-C33,,Concerts,,,=G33-H33,, Health,,,=B34-C34,,Sporting events,,,=G34-H34,, Life,,,=B35-C35,,Live theater,,,=G35-H35,, Other,,,=B36-C36,,Other,,,=G36-H36,, Subtotals,=SUM(B33:B36),=SUM(C33:C36),=SUM(D33:D36),,Subtotals,=SUM(G30:G36),=SUM(H30:H36),=SUM(I30:I36),, ,,,,,,,,,, Food,,,,,Loans,,,,, Groceries,$600,$600,=B40-C40,,Personal,,,=G40-H40,, Dining out,,,=B41-C41,,Student,,,=G41-H41,, Other,,,=B42-C42,,Credit card,,,=G42-H42,, Subtotals,=SUM(B40:B42),=SUM(C40:C42),=SUM(D40:D42),,Credit card,,,=G43-H43,, ,,,,,Credit card,,,=G44-H44,, Children,,,,,Other,,,=G45-H45,, Medical,,,=B46-C46,,Subtotals,=SUM(G40:G45),=SUM(H40:H45),=SUM(I40:I45),, Clothing,$100,$100,=B47-C47,,,,,,, School tuition,$60,$60,=B48-C48,,Taxes,,,,, School supplies,,,=B49-C49,,Federal,,,=G49-H49,, Organization dues or fees,,,=B50-C50,,State,,,=G50-H50,, Lunch money,,,=B51-C51,,Local,,,=G51-H51,, Child care,,,=B52-C52,,Other,,,=G52-H52,, Toys/games,$50,$50,=B53-C53,,Subtotals,=SUM(G49:G52),=SUM(H49:H52),=SUM(I49:I52),, Other,$100,$100,=B54-C54,,,,,,, Subtotals,=SUM(B46:B54),=SUM(C46:C54),=SUM(D46:D54),,Savings or Investments,,,,, ,,,,,Retirement account,,,=G56-H56,, Pets,,,,,Investment account,,,=G57-H57,, Food,,,=B58-C58,,College,,,=G58-H58,, Medical,,,=B59-C59,,Other,,,=G59-H59,, Grooming,,,=B60-C60,,Subtotals,=SUM(G56:G59),=SUM(H56:H59),=SUM(I56:I59),, Toys,,,=B61-C61,,,,,,, Other,,,=B62-C62,,Gifts and Donations,,,,, Subtotals,=SUM(B58:B62),=SUM(C58:C62),=SUM(D58:D62),,Charity 1,,,=G63-H63,, ,,,,,Charity 2,,,=G64-H64,, Personal Care,,,,,Charity 3,,,=G65-H65,, Medical,,,=B66-C66,,Subtotals,=SUM(G63:G65),=SUM(H63:H65),=SUM(I63:I65),, Hair/nails,,,=B67-C67,,,,,,, Clothing,,,=B68-C68,,Legal,,,,, Dry cleaning,,,=B69-C69,,Attorney,,,=G69-H69,, Health club,,,=B70-C70,,Alimony,,,=G70-H70,, Organization dues or fees,,,=B71-C71,,Payments on lien or judgment,,,=G71-H71,, Other,,,=B72-C72,,Other,,,=G72-H72,, Subtotals,=SUM(B66:B72),=SUM(C66:C72),=SUM(D66:D72),,Subtotals,=SUM(G69:G72),=SUM(H69:H72),=SUM(I69:I72),, ,,,,,,,,,,
You can also
export the spreadsheet's formulas
instead of its calculated data.
Go back to spreadsheet:
Copy of FAMILY EXPENSES SPREADSHEET
.
[ default color ]
recent: