Budget vs Actual Tracker: Excel + Google Sheets

A budget only helps if you compare it with what really happened. This Excel and Google Sheets tracker lets you set a monthly budget for each category, log your real income and spending, and see budget, actual and variance for any month and for the whole year, so you spot an overspend while you can still fix it.

What's inside:

1. Dashboard: pick any month to see income, expenses and net against budget, savings rate, categories over budget, year-to-date result, a 12-month table, the five biggest overspends and two charts

2. Monthly View: every category with budget, actual, variance, percent used and a status (On track, Near limit, Over) plus year-to-date totals; prints on one page

3. Annual: 12 months side by side with budget to date and variance for each category

4. Budget: type one monthly amount per category and all months fill in; overwrite any single month

5. Transactions: log up to 1,000 rows; pick Income or Expense and the category list adjusts

6. Settings: your own categories (8 income, 20 expense), first month and warning level

7. A sample file (fictional household, 10 months) and a blank file, plus a 2-page Quick Start PDF

Works in Microsoft Excel 2010+ and Google Sheets. No macros, no add-ins. Any currency. Formulas are unlocked so you can adapt it.

Good to know: for your own personal or business use only; please don't resell or share the files.

You get an instant download after payment.

We don't do refund & return ✌️

Zero Minute Studios