Free Budget vs. Actual Tracker (Excel)

A budget only has value if you actually check it against what happened. This free tracker lines up your planned numbers next to your real results and calculates the variance automatically, so overspending shows up while there’s still time to react.

Download Free — XLSX See the Full Library

No email required · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Business owners who set a budget but rarely check it against actuals
Anyone managing a department or project budget
Business owners trying to build a habit of monthly financial review
Students learning variance analysis

What's included

Budget column and Actual column side by side, by category
Automatic dollar and percentage variance calculation
Color-coded flags for categories running over budget
Built-in AI prompt to explain which variances matter most

Why use a template instead of starting from scratch?

Setting a budget once at the start of the year and never checking it again means it stops being useful the moment reality diverges from the plan — which happens almost immediately. Comparing budget to actual monthly is what turns a static plan into an active management tool.

How to Use This Template

Download and open in Excel or Google Sheets

Works identically in either — no macros or add-ins needed.

Enter your budgeted amount per category

Use your existing budget or projections as the starting point.

Enter actual results as each period closes

Pull these from your P&L once the month is finalized.

Review the automatic variance calculations

Both dollar and percentage variance are shown for each category.

Run the built-in AI prompt on the finished comparison

Attach the saved file to ChatGPT or Claude and ask which variances are worth investigating first.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on which budget variances are significant enough to investigate, versus normal month-to-month noise, no accounting background required.

Common Mistakes to Avoid

Only reviewing variance at year-end

Monthly review catches an overspending trend while it’s still small and fixable — waiting until year-end means the damage is already done.

Treating every variance as equally important

A large percentage variance on a tiny category matters far less than a small percentage variance on your biggest expense line — look at dollar impact, not just percentage.

Never updating the original budget

If circumstances genuinely change (a new hire, a price increase from a supplier), it’s reasonable to formally revise the budget rather than just accepting a permanent variance.

Not investigating favorable variances either

Spending significantly under budget isn’t always good news — it can mean a planned initiative didn’t happen, which is worth understanding too.

Frequently Asked Questions

What’s a healthy variance percentage?

There’s no universal number — small categories naturally show larger percentage swings. Focus on dollar-impact and consistency of the trend rather than a single fixed threshold.

How often should I compare budget to actual?

Monthly is standard for active management — frequent enough to catch a problem early, without over-reacting to normal noise.

What should I do when I find a significant unfavorable variance?

Investigate the specific cause first — a one-time event versus a genuine trend require very different responses — then decide whether to adjust spending, revise the budget, or just monitor it.

Is this template really free?

Yes, completely free, no email required. iLuvAccounting also has a paid Tools Club with 70+ templates, including an Annual Operating Budget if you need to build the original budget first.

Should I build a new budget every year or adjust the same one?

Most businesses rebuild or meaningfully revise their budget annually, informed by the prior year’s actual results — this tracker is exactly what generates that historical insight.

Can I use this for a personal budget instead of a business one?

Yes — the same budget-vs-actual structure works for personal finances, just swap in personal income and expense categories.

What if I don’t have a formal budget yet?

Use last year’s actual spending as a rough starting budget, or build one first with the Annual Operating Budget template — you need something to compare actuals against for this tracker to be useful.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club