How to use the free family budget spreadsheet

Download the free workbook and use it for one month at a time. You do not need to connect a bank account or create a login. The file calculates totals from your entries; it cannot tell whether your entries are complete or correct.

1. Save a copy and name the month

Keep an unchanged original. Save a working copy with a name such as Family-budget-October-2026, then enter the month in B4. The template uses U.S. dollars and does not convert currencies. Yellow cells are your inputs. Columns B and C are planned and actual amounts; column D calculates actual minus plan. Leave formula cells unchanged.

2. Enter take-home income

Use rows 14–17 for pay after taxes and payroll deductions, net self-employment income, and other money available for the month. Do not enter gross salary and then deduct withholding again as an expense. Planned income goes in B; actual receipts go in C as the month progresses. Enter 0 where a category does not apply. Blank inputs count as zero in totals, so unfinished entries can make the result misleading.

3. List expenses and new savings

Expenses go in rows 22–35 and new savings in rows 39–41. Use debt payments for earlier balances. If you record this month’s card purchase under groceries, do not count the same purchase again in debt payments. Record money set aside for a future bill as savings now; when the bill is paid later, record the expense in that month. The template does not track withdrawals from existing savings or account balances.

4. Read the totals and differences

The summary at rows 6–8 shows income, expenses plus savings, and remaining money. Detail totals are at rows 18, 36, and 42–44. A positive number in D means the actual amount was higher than planned. For income that means more received; for expenses it means more spent. For individual categories, the difference is blank until both entries are present. Actual remaining money is only meaningful after you have entered the relevant income and outflows.

5. Review the month without overwriting formulas

Compare the results with receipts and statements, then choose one adjustment for next month. Check bill dates separately: money remaining is a monthly calculation, not your bank balance. You can rename categories, but if you insert rows or change formulas, verify all totals. If an imported copy looks different in another application, check calculations against the original before relying on it.

Your action checklist

Download and save a working copy.
Enter the month and planned take-home income.
Fill each expense and savings row, using 0 where appropriate.
Check totals and review bill dates separately.

Start with the free budget

Download the free spreadsheet

Spreadsheet use terms. No signup. Your entries stay in your file.

Sources and checks

Cell references and examples were checked against our free budget workbook.

Sources and examples checked October 5, 2026. No independent professional review.

Keep learning

Back to Budgeting