4.4
2,100+ reviews on G2
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:
Income at the top, then bills, spending and savings.
Two columns: the limit you set and what you spent.
Planned minus actual, so overspending stands out.
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.
Use Excel or Google Sheets. Name the first tab after the month, for example "November 2026".
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.
In row 2, enter your take-home pay for the month: what reaches your account after tax and deductions.
Bills first (rent, utilities, phone, insurance), then everyday spending (groceries, transport, eating out), then savings. Leave a blank row between groups.
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.
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.
Once a week, add up your receipts and card statement by category and type the totals into column C.
At month end, duplicate the tab, rename it, clear column C and adjust the planned amounts that did not match.
| A: Category | B: Planned | C: Actual | D: Difference |
|---|---|---|---|
| 3Take-home pay | $3,450 | $3,450 | |
| 4Bills | |||
| Rent | $1,250 | $1,250 | 0 |
| Utilities | $140 | $152 | −$12 |
| Phone and internet | $90 | $90 | 0 |
| Renters insurance | $20 | $20 | 0 |
| Everyday spending | |||
| Groceries | $400 | $431 | −$31 |
| Transport | $160 | $143 | +$17 |
| Eating out | $180 | $205 | −$25 |
| Subscriptions | $45 | $45 | 0 |
| Fun and shopping | $250 | $210 | +$40 |
| Savings | |||
| Emergency fund | $350 | $350 | 0 |
| Travel fund | $200 | $200 | 0 |
| 6Left over | $365 | $354 | |
Column D is =B minus C for each row. Left over is income minus the SUM of each column.
All three hold the same budget. They differ in how much you type, how much is automatic, and how much you can change.
| Tool | How it works | Best for | Watch out for |
|---|---|---|---|
| Spreadsheet | You 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 app | The 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 notebook | You 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. |
Copy it into Excel or Google Sheets, or save it to your Evernote account and fill it in each month.
| Category | Planned | Actual | Difference |
|---|---|---|---|
| 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 | $ | $ | $ |
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
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.
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.
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.
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.
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.
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.
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.
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.
Ask the AI Assistant "How much did I spend on groceries this month?" It searches your receipts and answers with the total.
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.
Ask it to remind you to review the budget on the last day of the month. It sets a reminder on the note.
Set up the columns once, snap receipts as you spend, and ask the AI Assistant to fill in what you spent.
Start for free