How to make a budget spreadsheet

A budget spreadsheet is a table in Excel or Google Sheets with one row per spending category and columns for what you plan, what you spend and the difference, with formulas that add it all up. A useful one has four parts:

  1. 1

    One row per category

    Income at the top, then bills, spending and savings.

  2. 2

    Planned and Actual

    Two columns: the limit you set and what you spent.

  3. 3

    A Difference column

    Planned minus actual, so overspending stands out.

  4. 4

    Totals that add up

    SUM formulas for each column and what is left.

Keep yours in Evernote. Snap your receipts as you go, and the AI Assistant fills in the Actual column.

Make your budget in Evernote

How to make a budget spreadsheet in 8 steps

  1. 1

    Open a blank sheet

    Use Excel or Google Sheets. Name the first tab after the month, for example "November 2026".

  2. 2

    Add the column headers

    In row 1, type Category in column A, Planned in B, Actual in C and Difference in D. Make the row bold so it stays easy to read.

  3. 3

    Put income in the first row

    In row 2, enter your take-home pay for the month: what reaches your account after tax and deductions.

  4. 4

    List your categories in groups

    Bills first (rent, utilities, phone, insurance), then everyday spending (groceries, transport, eating out), then savings. Leave a blank row between groups.

  5. 5

    Add the Difference formula

    In D for each category, subtract Actual from Planned with the minus sign, for example =B5-C5. Excel has no SUBTRACT function. A negative result means the category went over.

  6. 6

    Total each column with SUM

    Below the last category, add =SUM(B5:B17) for Planned and the same for Actual. Then subtract each total from income to see what is left over.

  7. 7

    Fill in Actual every week

    Once a week, add up your receipts and card statement by category and type the totals into column C.

  8. 8

    Copy the tab for next month

    At month end, duplicate the tab, rename it, clear column C and adjust the planned amounts that did not match.

Budget spreadsheet example

November tab, one person, $3,450 take-home pay
A: CategoryB: PlannedC: ActualD: Difference
3Take-home pay$3,450$3,450
4Bills
Rent$1,250$1,2500
Utilities$140$152−$12
Phone and internet$90$900
Renters insurance$20$200
Everyday spending
Groceries$400$431−$31
Transport$160$143+$17
Eating out$180$205−$25
Subscriptions$45$450
Fun and shopping$250$210+$40
Savings
Emergency fund$350$3500
Travel fund$200$2000
6Left over$365$354

Column D is =B minus C for each row. Left over is income minus the SUM of each column.

Should you use a spreadsheet, an app or paper?

All three hold the same budget. They differ in how much you type, how much is automatic, and how much you can change.

ToolHow it worksBest forWatch out for
SpreadsheetYou type categories and amounts, and formulas add them up.People who want full control over categories and layout.Every number is typed by hand, so it only works if you update it.
Budgeting appThe app imports transactions from your bank and sorts them into categories.People who want tracking to happen with little effort.Categories can be sorted wrong, and some apps charge a fee.
Paper or a notebookYou write the plan and add up receipts by hand.A first budget, or anyone who remembers more by writing.No formulas, so totals take longer and mistakes are easy.

Free budget spreadsheet template

Copy it into Excel or Google Sheets, or save it to your Evernote account and fill it in each month.

CategoryPlannedActualDifference
Income
Take-home pay$$$
Other income$$$
Bills
Rent or mortgage$$$
Utilities$$$
Phone and internet$$$
Insurance$$$
Debt payments$$$
Everyday spending
Groceries$$$
Transport$$$
Eating out$$$
Subscriptions$$$
Fun$$$
Savings
Emergency fund$$$
Savings goal$$$
Totals
Total$$$
Left over$$$

Trusted by Millions Worldwide

4.4

2,100+ reviews on G2

4.4

8,200+ reviews on Capterra

4.4

73,000+ reviews on App Store

248M

Registered users

Budget spreadsheet questions

How do I make a budget in Excel?

Type Category, Planned, Actual and Difference across row 1. Put take-home pay in row 2 and one category per row below it. Use =B5-C5 for each Difference, and =SUM over each column for the totals.

How do I make a budget in Google Sheets?

The same way as in Excel. Google Sheets uses the same SUM function, for example =SUM(B5:B17), and the minus sign for the difference. You can share the sheet with a partner so you both update it.

What formulas does a budget spreadsheet need?

Two are enough. SUM adds up a column: =SUM(B5:B17). The minus sign gives the difference between planned and actual: =B5-C5. Income minus the planned total shows what is left to assign.

What columns should a budget spreadsheet have?

Category, Planned, Actual and Difference cover most budgets. Some people add a Notes column for one-off costs, or a Due date column for bills.

Should I make one tab per month?

Yes, it keeps each month separate and lets you compare them. Duplicate last month's tab, rename it, clear the Actual column and update the planned amounts.

How do I track spending in a spreadsheet?

Keep your receipts in one place and add them up by category once a week. Type each total into the Actual column. Weekly is easier than daily, and frequent enough to slow down before a category runs over.

Is a spreadsheet better than a budgeting app?

A spreadsheet gives you full control over categories and layout, and costs nothing if you already have Excel or Google Sheets. An app tracks spending for you. If you stop updating a spreadsheet, it stops being useful.

How to keep a budget table with Evernote

Write the same columns as a table in a note, and snap each receipt as a photo note in the same notebook. Evernote reads the text in photos, so the AI Assistant can use them.

  1. 1

    Total a category.

    Ask the AI Assistant "How much did I spend on groceries this month?" It searches your receipts and answers with the total.

  2. 2

    Fill the Actual column.

    Ask it to fill the Actual column of your budget table from your receipts. It writes the amounts into the cells, so you don't type them.

  3. 3

    Review at month end.

    Ask it to remind you to review the budget on the last day of the month. It sets a reminder on the note.

  • You can also attach your Excel file to the same note, and Evernote shows the spreadsheet inside it.
  • You can also share the budget note with your partner so you both see the same table.

Keep your budget table and receipts together

Set up the columns once, snap receipts as you spend, and ask the AI Assistant to fill in what you spent.

Start for free