Excel Spreadsheet · Personal Budget Tracker

Take control of your spending.
Without the complexity.

A single Excel file with annual budget, transaction log and dashboard. No apps, no subscriptions, no data leaves your computer.

Pay what you want, including free. You decide what it's worth.


12
months in a single view
4
integrated tabs
100%
Native Excel, no macros
0
data sent to servers

Features

Everything included in this Excel budget spreadsheet

Designed so you know exactly where your money goes each month, with no learning curve required.

01

Annual budget

All 12 months on one screen. Enter income and budget per category; spending is calculated automatically from your transactions.

02

Transaction log

Record every expense with date, description and category. The budget updates automatically via formulas — no macros needed.

03

Monthly summary

Pick any month from a dropdown and instantly see budgeted, spent, available and execution percentage.

04

Category groups Full

Organise categories into groups (Fixed Costs, Variable, Savings…) with automatic subtotals per group.

05

Balance rollover Full

Unspent budget from one month rolls automatically into the next. Configurable per category.

06

Dashboard with charts Full

4 automatic charts: category comparison, group breakdown, monthly trend and remaining balance.

Inside the file

Four tabs, fully integrated

Manage your categories

Set up groups and categories once. The entire file updates when you click "Update Budget".

  • Rename groups and categories freely
  • Add new categories in the empty rows
  • Type the name and the key fills itself automatically
  • Enable or disable balance rollover per category
⚙️ Configuration · Fixed Costs
#NameKeyRollover
1 · Fixed Costs
1.1HousingHousingY
1.2InsuranceInsuranceY
1.3SubscriptionsSubscriptionsY
1.4
2 · Variable Expenses
2.1GroceriesGroceriesN

Annual budget

All 12 months at a glance. Blue cells are inputs; the rest are automatic formulas.

  • Enter income and budget per category
  • Spent is calculated automatically from Transactions
  • Available = Budgeted − Spent (colour-coded traffic lights)
  • Automatic subtotals per group
  • Unspent balance rolls over to the next month
📅 Annual Budget 2026
CategoryJan 2026Feb 2026
Budg.SpentAvail.Budg.SpentAvail.
Fixed Costs
Housing80080008008000
Insurance12012001200120
Subtotal9209200920800120
TOTAL1.4501.2102401.450900550

Transaction log

Record your day-to-day expenses. The category dropdown fills itself from your configuration.

  • 500 pre-formatted rows ready to use
  • Validated category dropdown
  • Date, description, amount and note
  • Budget formulas read this table automatically
💳 Transactions
DateDescriptionCategoryAmount
01/05/2026SupermarketGroceries€87.40
03/05/2026Petrol stationTransport€65.00
05/05/2026SpotifySubscriptions€11.99
07/05/2026PharmacyHealth€24.50
10/05/2026RestaurantDining Out€42.00

Monthly summary

Pick the month and review all your data at once. No touching any formula.

  • Month selector (1–12) that refreshes the entire view
  • Budgeted, spent, available and % per category
  • Total income and unallocated balance
  • Dashboard with 4 automatic charts
📊 Summary · May 2026
CategoryBudg.SpentAvail.%
Fixed Costs
Housing8008000100%
Insurance12001200%
Variable Expenses
Groceries4003128878%
TOTAL1.4501.11233877%
Download

You decide what it's worth.

During the first months, the spreadsheet is available with a pay-what-you-want model — including free. If you find it useful, any contribution helps keep it going.

"No apps. No subscriptions. No data ever leaves your computer."
  • Complete annual budget · 12 months
  • Dashboard with 4 automatic charts
  • Balance rollover between months
  • Compatible with Excel 2016+ · Mac and Windows
  • Updates included
Pay what you want

Budget Tracker 2026

Pay what you want — including €0

Download the spreadsheet →

Minimum price: €0 · Suggested price: €9.99
Excel 2016+ · Mac and Windows · No sign-up required


FAQ

Frequently asked questions

If you don't find the answer, reach out via the form below.

Do I need to know Excel?+

No. You just need to type in cells. All formulas, calculations and charts are already built in. You enter your data — the rest is automatic.

Which Excel version does it work with?+

Excel 2016 or higher, on both Windows and Mac. Also works with Excel for Microsoft 365. Not compatible with Google Sheets.

What is balance rollover?+

If you have €50 left in "Groceries" in January and rollover is enabled for that category, those €50 are automatically added to your February budget. You never "lose" money you didn't spend.

Can I add my own categories?+

Yes, as many as you need. Edit the Configuration tab, click the green button and the budget rebuilds automatically.

Why pay-what-you-want? Can't I just get it free?+

You can download it completely free — set it to €0 and go. The pay-what-you-want model is for those who want to support the project. Any contribution, however small, helps keep improving the spreadsheet.

Does my data go anywhere?+

No. It's an Excel file that runs on your computer. No data ever leaves your device.

Community

Got an idea or suggestion?

This spreadsheet improves through real-world use. If something's missing or you find a bug, let me know — I read every message.

New featureSomething you'd like it to do that it doesn't yet
🐛
Bug or errorA formula that doesn't work, an incorrect result
🎨
Design improvementSomething that feels confusing visually or hard to read
💬
Anything elseQuestions, comments or whatever comes to mind

I reply to all messages within 48 hours.

✅ Message received! Thanks for taking the time. I'll get back to you soon.

Ready to get started?
It's free.

Pay what you want, including zero. You decide what it's worth. No sign-up, no subscription.