Guide · My Expenses

Monthly budget template

Quick answer

This monthly budget template has three columns for each category: what you planned, what you actually spent and the difference. Fill in the plan at the start of the month, the actual at the end, and adjust next month's plan from the gaps. My Expenses can supply the actual column.

Updated 2 min readGambit Studio

The template

CategoryPlannedActualDifference
Income (take-home)
Rent or mortgage
Utilities and phone
Groceries
Eating out
Transportation
Insurance and health
Debt payments
Subscriptions
Personal and shopping
Fun money
Gifts and giving
Sinking funds
Savings
Total spending and saving
Income minus total

How to fill it in

  1. Day 1: fill the Planned column so the total equals take-home income.
  2. During the month: log every expense in its category.
  3. Last day: copy each category total into Actual and calculate the difference.
  4. Next month: raise the lines that were always over, lower the ones always under.

The 10-minute review

  • Which line was furthest from the plan, and why?
  • Was it a one-off or will it repeat?
  • Do you need a new sinking fund for it?

Need more categories? Use the budget categories list. New to budgeting? Start with how to make a budget.

Fill the Actual column automatically

My Expenses, by Gambit Studio, is built for this part: you log amount, description, category and date in seconds, and its charts show each category's share of the month and how it compares with last month.

Sources

  1. CFPB: Budgeting, how to create a budget and stick with it (June 5, 2019)

Frequently asked questions

What people ask most about this, answered with the source.

What should a monthly budget template include?
Take-home income and every spending category with planned, actual and difference columns, plus savings.
How do I use a budget vs actual template?
Plan at the start of the month, record actual spending at the end, compare and adjust next month's plan.
Is there a free monthly budget template?
Yes: copy the table on this page into a notebook, Numbers, Excel or Google Sheets.
My ExpensesWhere's My Money? Easy Control
Get