Cash Flow Tracker Create free account

Free Monthly Budget Template

A simple monthly budget template built around budget vs actual — with a running balance so you can see where you stand after every line, not just at month-end. Copy the layout below into any spreadsheet, or skip the manual upkeep entirely.

The template layout

A budget template only needs five columns to be genuinely useful. Here it is, filled in with a sample month so you can see how it flows:

DayItemBudgetActualBalance
Opening balance
1Starting balance1,2001,200
Income
1Salary3,2003,2004,400
15Side income3002604,660
Expenses
2Rent1,1501,1503,510
3Insurance95953,415
5Subscriptions45523,363
Groceries4504862,877
Transport1801712,706
Everything else4003952,311
Net (income − expenses)+1,180+1,1112,311

What each column does

How to use it in a spreadsheet

  1. Recreate the five columns and the Income / Expenses sections above.
  2. Enter your opening balance on the first row.
  3. For the running balance, add this row's income and subtract this row's expense from the row above (e.g. =E2 + C3 − D3).
  4. Add a variance column if you like: =Actual − Budget.
  5. Start the template on your pay date, not the 1st, if you're paid mid-month.

Or skip the spreadsheet entirely

Cash Flow Tracker is this template, automated: add line items, set budget vs actual, and the running balance and variance are calculated for you — for any pay cycle, free.

Use the free tracker

Frequently asked questions

Why include a running balance instead of just a total?

A monthly total can look healthy while you still go negative mid-month. The running balance shows the lowest point you'll hit, so you can reorder or delay a payment before it bounces.

Spreadsheet or app — which is better?

A spreadsheet is fine to start and totally free. The app wins once the manual formulas, day-sorting, and copying last month's plan into this month start eating your time.

Related reading

New to the concept? Read budget vs actual, explained. Paid mid-month? See budgeting on a 20th-to-20th pay cycle.