How to build a budget vs actual dashboard from your spreadsheets

In a lot of companies, the monthly budget review starts with someone in finance exporting actuals from the accounting system, pasting them into a large spreadsheet, fixing the formulas that broke since last month, and emailing department-specific tabs to managers. Managers reply with questions about numbers they do not recognize. By the time everyone agrees on the figures, half the month has passed and the meeting is about the past instead of the next decision.

A budget vs actual dashboard turns that monthly rebuild into a refresh. This guide covers what the spreadsheet way costs, what the dashboard should contain, a worked example request, a step-by-step rollout, mistakes to avoid and how to know it is working.

What the spreadsheet way costs you

• Days of rebuild every month. Copying, pasting, fixing links and checking totals eats the finance team's time right when the close is busiest.
• Broken formulas. One inserted row and a total silently skips a line. Nobody notices until the numbers do not tie.
• Version confusion. "Budget v7 final revised" and three emailed copies. Managers comment on different versions.
• No ownership. Variances get explained in email threads that are gone by next month, so the same questions come back.
• Managers disengage. A large spreadsheet with every account in the company is hard to read. Department heads who cannot find their own numbers quickly stop looking.
• No forecast. Spreadsheets show what happened. Leaders need to know where the year is heading, and keeping a forecast current by hand is rarely done.

What the dashboard should contain

The budget

Load the approved budget once per year, plus any approved revisions. Each budget line has:

• Account, mapped to your chart of accounts
• Department, location or cost center
• Project or job, if you track them
• Amount by month, phased the way costs actually land
• The version: original, revised, or reforecast, so you can always compare against the original plan

The budget should be locked once approved. Revisions create a new version rather than overwriting the old one.

The actuals

Actuals come from your accounting system, the books of record. Start with a monthly export file that the finance lead uploads after close. The app checks the totals against the trial balance, warns about any account that is not mapped, and refuses to publish the month until every amount has a home. Later, a scheduled or direct connection can replace the upload.

The mapping

This is the foundation. Budgets are often built in friendlier categories than the chart of accounts, such as "marketing events" rather than three separate accounts. A mapping table connects each account and department to a budget line. Keep it in the app, editable only by finance, with a record of every change.

The views

Different people need different cuts of the same numbers:

• Company summary: revenue, gross margin, operating expenses and net income, budget vs actual for the month and year to date, with a forecast for the year
• Department view: each manager sees their own lines, sorted by largest variance
• Location view: for multi-site companies, every location side by side
• Account drill-down: click any line to see the transactions behind the actual, from the export
• Trend: twelve months of budget and actual for any line

Variances and comments

The dashboard calculates the variance for every line in dollars and percent, and marks it favorable or unfavorable. Lines over a threshold you set, such as more than 10 percent and more than $2,000, are flagged and assigned to the line's owner for a comment. The owner chooses a reason (timing, volume, price, one-time, error, real overspend) and writes a sentence. Comments stay attached to the month, so next month's review starts with last month's explanations.

Forecast

Each line has a forecast for the remaining months. A simple start is budget for future months plus actuals for past ones. Owners can override future months with a better estimate and a note. Leaders see three numbers for the year: budget, forecast and the gap.

Statuses for the monthly cycle

1. Actuals loaded: export uploaded, totals checked
2. Mapping complete: every account mapped
3. Published to managers: views open, comment requests sent
4. Comments in: all flagged lines explained
5. Reviewed: finance lead or CFO signed off
6. Closed: month locked, comments archived

Roles

Notifications

• Managers: when the month is published, with a list of their flagged lines
• Finance lead: when a manager has not commented by the deadline
• CFO: when all comments are in and the month is ready to review

Example request

Here is an example of a request a controller could hand to FORGE in plain words. Change the structure to match your company.

"We are a three-location dental group with about 70 staff. Our budget is a spreadsheet with lines by location and category, by month, for the year. Build a budget vs actual dashboard. I upload the budget once a year and any revisions as new versions. Each month after close, I upload the trial balance export from our accounting software, and the app maps each account and location to our budget lines using a mapping table I can edit; it must not publish the month until every account is mapped and the totals tie. Show a company summary, each location side by side, and each category, with the month and year to date, variance in dollars and percent, and a forecast for the year. Flag any line more than 10 percent and more than $1,500 off budget, and send it to the location manager to pick a reason and write a comment by the 15th. Location managers only see their own location. I want to click any line and see the transactions behind it. Keep every month's comments so we can see the history."

Rolling it out

1. Pick the budget version that matters. Start with the approved budget for the current year. Do not try to load five years of history on day one.
2. Build the mapping. List every account and department in your chart of accounts and match it to a budget line. Flag accounts that have no budget line; they will create variances every month.
3. Phase the budget properly. Spread annual costs like insurance or software renewals into the months they land, so timing does not produce false alarms.
4. Load one closed month and tie it out. Compare the dashboard against your existing spreadsheet for the same month. Fix every difference before showing anyone.
5. Set thresholds with your CFO or owner. Tight enough to catch real problems, loose enough that managers comment on a handful of lines, not dozens.
6. Walk each manager through their view. Ten minutes each, on their own numbers, with the comment process shown live.
7. Run the next close through the dashboard. Use it in the monthly meeting instead of the spreadsheet.
8. Retire the spreadsheet. Keep last year's version for reference, read only.
9. Add forecasting. Once the monthly cycle runs smoothly, ask managers to update their forecasts each month.

Mistakes to avoid

• Skipping the mapping work. If accounts do not map cleanly to budget lines, every view is wrong. This is the one step to over-invest in.
• Flat monthly budgets. Dividing the annual budget by twelve creates variance noise every month a seasonal or annual cost lands.
• Showing managers everything. A department head who sees only their lines, sorted by variance, will engage. One who gets the whole company will not.
• Comments without reasons. A reason picked from a short list lets you see patterns, such as repeated timing differences, that free text hides.
• Treating the dashboard as the ledger. Your accounting system remains the books of record. The dashboard reads from it.
• Publishing before the numbers tie. One wrong month destroys trust. Check totals against the trial balance every time.

How to measure that it works

Launch checklist

1. Current year's approved budget collected
2. Chart of accounts mapped to budget lines, gaps resolved
3. Budget phased by month the way costs land
4. One closed month loaded and tied to the trial balance
5. Variance thresholds agreed with the CFO or owner
6. Comment reasons agreed
7. Managers invited and shown their own view
8. Comment deadline set in the monthly calendar
9. First live month reviewed in the meeting from the dashboard
10. Old spreadsheet archived read only
11. Forecast updates added after the first quarter

How FORGE handles it

FORGE lets your finance lead describe the budget structure and monthly cycle in plain words and get a working dashboard back, and most teams have their first real tool the same day. A panel of top AI models plans it around your chart of accounts, departments and thresholds, a dedicated AI crew builds it, and every piece is checked for quality and security before it is saved. It runs on the web for the finance team and on phones for managers who want a quick look between meetings.

Your financial data stays inside your company. People join only by invite, each manager sees only their own numbers, and there is a complete record of who changed what, including every mapping change. Managers who only view and comment are free. When you add a location or restructure departments, you describe the change and the dashboard follows; changes cost a small fraction of a build and only count when something changes. Our team onboards every company ourselves, starting with a workflow workshop on your real numbers. Talk to us or see how it works.

Questions people ask