A budget spreadsheet is an editable table that compares planned
income and spending with actual transactions for a defined period. This
free template includes monthly income, fixed expenses, variable
expenses, periodic costs, debt payments and savings, plus the resulting
balance and variance.
What is
included in the free budget spreadsheet?
The workbook has a monthly budget sheet with three working columns:
planned, actual and variance. Positive income variance means more income
arrived than planned. Positive expense variance means spending was below
plan. Separate totals show income, expenses, debt payments, savings and
the final monthly balance.
The category list is a starting point, not a rule. Rename or remove
rows that do not match your household. Add a row only when it represents
a distinct recurring decision. Forty vague categories can make
maintenance harder than ten useful ones.
How do you set up the
spreadsheet?
Choose one calendar month and enter after-tax income expected during
that period. Enter fixed commitments such as rent, mortgage, utilities,
insurance and childcare. Add realistic amounts for variable spending
based on recent statements rather than an ideal month.
Convert non-monthly costs into reserves. If vehicle insurance costs
$900 every six months, enter $150 as the monthly planned amount and
transfer it to a dedicated account or category. Apply the same method to
maintenance, holidays, annual memberships and medical costs.
Enter debt payments and savings as planned uses of money. This
prevents the sheet from treating them as an accidental remainder. Keep
required debt minimums separate from optional extra repayments so you
can see what can change when income is lower.
How do planned and
actual columns work?
The planned column is the decision made before or at the start of the
month. The actual column records what happened. The variance is
calculated automatically. Do not rewrite the plan halfway through the
month to make it match actual spending; that destroys the information
needed to improve the next budget.
Correct genuine mistakes, but leave ordinary overspending visible.
Add a short note if a large difference came from timing, a one-off event
or a category that needs a permanent increase.
What bills should
appear in the template?
Use the previous 12 months to find rent or mortgage, electricity,
gas, water, phone, internet, insurance, groceries, transport,
healthcare, subscriptions, childcare, education and debt. Search
statements for annual renewals and small recurring charges.
Separate required bills from flexible spending without pretending
every item fits perfectly. Basic food is necessary; premium convenience
purchases may be flexible. The distinction is useful only when it leads
to a realistic adjustment.
How do you budget with
irregular income?
Base the core plan on income you can reasonably rely on. One method
is to use the lowest normal month from the past year. Another is to
calculate a 12-month average while holding a cash buffer for months
below that average.
Create an allocation order for income above the baseline: overdue
obligations first, then the buffer, periodic reserves, debt reduction
and longer-term goals. This prevents every strong month from creating
new recurring costs.
Should you use
Excel, Google Sheets or an app?
Excel works offline and offers control over the file. Google Sheets
makes household sharing and access across devices easy. A budgeting app
may import transactions and reduce manual work, but it requires account
connections or subscription choices. The method matters more than the
software.
The included file is an Excel workbook and can be uploaded to Google
Sheets. Check formulas and number formats after conversion, especially
when changing locale or currency.
How often should
you update the spreadsheet?
Update actual spending weekly or on each payday. A short weekly
review catches a category problem while there is still time to respond.
At month-end, reconcile the sheet with bank and card balances, explain
major variances and create the next plan.
Keep prior months rather than overwriting them. Three to six months
of history shows which categories are consistently underestimated and
which planned savings amounts are not being transferred.
What should the spreadsheet
not do?
It should not give personal investment, tax or debt advice. It should
not hide a negative balance or assume that a percentage rule can
override actual obligations. Use it to make income, costs and trade-offs
visible. When debt, arrears or tax issues require a formal plan, use a
qualified adviser or an appropriate nonprofit service.
