Settings

Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.

Monthly budget open in Sheets, in the light themeMonthly budget open in Sheets, in the dark theme

What is in it

Money in and money out for a household month, planned against actual, with the difference on each line and what is left at the end. The figures are examples to type over.

Monthly budget
Type your own figures over the examples. Difference is what you planned less what you spent: below nought, you spent more than you planned.
Money inPlannedActual
Pay after tax24002400
Other income0150
Total in=SUM(B5:B6)=SUM(C5:C6)
Money outPlannedActualDifference
Rent or mortgage950950=B10-C10
Council tax140140=B11-C11
Gas and electricity120134=B12-C12
Water3535=B13-C13
Phone and internet4545=B14-C14
Food shopping300326=B15-C15
Transport12098=B16-C16
Insurance4040=B17-C17
Subscriptions2525=B18-C18

Worked out for you

These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.

Total in
=SUM(B5:B6)
Difference
=B10-C10
Total out: Planned
=SUM(B10:B22)
Total out: Actual
=SUM(C10:C22)
Total out: Difference
=SUM(D10:D22)
Left at the end of the month: Planned
=B7-B23
Left at the end of the month: Actual
=C7-C23

Filling it in

  • Start from your bank statements for the last three months, not from memory. Most people underestimate food, eating out and subscriptions.
  • Put savings in as a line of spending, paid on payday, so it happens before the rest of the month does.
  • Look at the lines where the difference is below nought two months running. That is the plan to change, not your spending.
  • Bills that come once or twice a year, such as car insurance or a TV licence, can be divided by twelve and set aside each month.

More templates

All 32 templates