Budget vs. Actuals: The One Report That Tells You Whether Your Budget Is Working
A budget you never review is just a document. A budget you compare to actuals every month is a management tool that keeps your finances on track all year.
EveryCentCounts
•
•
-- views
•
6 min read
We close Budgeting Week with the report that makes the budget worth building in the first place. Thursday's post gave you a six-step system for constructing a budget in under two hours. Today's post shows you what to do with it every month after that; because a budget that gets built once and filed away is one of the most common financial management failures in small business and nonprofit finance.
The Budget vs. Actuals report, also called a BvA, a budget-to-actual, or a variance report, is the primary financial management tool for any organization that has a budget. According to the AICPA, regular budget-to-actual review is one of the foundational internal controls that distinguishes well-managed organizations from those that react to financial problems rather than anticipating them (AICPA 2024). Done monthly, it takes 30 minutes. Done never, it renders the budget useless.
Budgeting Week: What We Covered
Watch: Budget vs. Actuals Explained
This quick explainer covers what a BvA report is, how to read variance signals, and why the comparison matters more than the budget itself.
Video: EveryCentCounts — Quick Explainer Saturday Series.
What a Budget vs. Actuals Report Actually Is
A BvA report is a side-by-side comparison of three columns for every line in your income statement: what you budgeted, what actually happened, and the difference between the two. That difference is called the variance. The variance can be expressed as a dollar amount, a percentage, or both; and it can be favorable or unfavorable depending on whether you are looking at a revenue line or an expense line.
Most accounting software generates this report automatically once you have entered a budget. In QuickBooks, it is Reports → Budgets & Forecasts → Budget vs. Actual. In Xero, it is Reports → Budget Manager. In a spreadsheet, it is simply a column of budgeted figures next to a column of actual figures, with a third column showing the difference (FASB ASC 230, 2023).
Figure 1. Sample Budget vs. Actuals report — April 2026 (simplified)
| Line Item | Budget | Actual | Variance $ | Variance % | Signal |
|---|---|---|---|---|---|
| REVENUE | |||||
| Client service fees | $18,000 | $19,400 | +$1,400 | +7.8% | Favorable |
| Retainer income | $4,500 | $4,500 | $0 | 0% | On track |
| Referral revenue | $1,200 | $640 | –$560 | –46.7% | Investigate |
| EXPENSES | |||||
| Rent & utilities | $2,800 | $2,800 | $0 | 0% | On track |
| Payroll | $8,500 | $8,220 | +$280 | +3.3% | Favorable |
| Marketing | $1,000 | $1,490 | –$490 | –49.0% | Review |
| Software & subscriptions | $420 | $420 | $0 | 0% | On track |
| Net income (surplus) | $10,980 | $11,610 | +$630 | +5.7% | Favorable overall |
Note: Variance sign convention here uses positive = favorable for both revenue and expenses. Some reporting formats reverse the sign for expenses; what matters is consistency. Your accounting software will apply its own convention—learn which one it uses.
Four Terms You'll See in Every Budgeting Conversation
The week's Wednesday post covered these in depth. Here's the plain-English version for quick reference.
Budget
The plan. What you expected to earn and spend over a defined period. Static once set—changing it defeats the purpose of comparing actuals against it.
Actuals
What actually happened. The real income and expenses recorded in your books for the same period. Comes directly from your general ledger.
Forecast
A revised projection that incorporates what has actually happened so far. Unlike the static budget, a forecast updates as the year progresses and new information becomes available.
Variance
The difference between budget and actuals. A favorable variance means you performed better than planned. An unfavorable variance means you did not—and needs investigation.
How to Read Variance Signals—and When to Act
Not every variance requires the same response. A 2% unfavorable variance in a variable expense category is noise, normal month-to-month fluctuation that does not warrant investigation. A 47% unfavorable variance in a revenue line, as in the referral revenue line in the example above, is a signal that something has changed and needs to be understood before it becomes a pattern.
Favorable variance
Revenue: You earned more than budgeted. Investigate why—was it a one-time event or a repeatable trend? If repeatable, consider revising the budget upward.
Expenses: You spent less than budgeted. Confirm the saving was intentional (cost control) not incidental (delayed spending that will show up next month).
Small unfavorable variance
A variance under 10–15% on a variable expense line is typically normal fluctuation. Note it, monitor it next month, and take no immediate action unless the pattern continues for two or more months in a row.
The threshold for action is lower for revenue lines: even a 10% revenue shortfall compounded over several months can materially affect cash position.
Large unfavorable variance
A variance over 20% on any significant line, or any unfavorable revenue variance, requires immediate investigation. Ask: is this a recording error, a timing difference, or a real change in business performance?
If it is a real change, update your forecast—not your budget—to reflect the new reality and decide what operational response is warranted.
Visualizing Your Variance: Budget vs. Actuals by Month
The table format shows precision. A chart shows the pattern—which is often the more actionable insight. This example shows revenue budget vs. actuals across six months, with variances plotted separately.
Figure 2. Illustrative example only—not based on a real organization. The pattern shown (actuals tracking slightly below budget in Q1, then recovering) is representative of the kind of trend a monthly BvA review makes visible in time to act.
How to Run Your Monthly BvA Review in 30 Minutes
Pull the BvA report for the month just closed
In QuickBooks: Reports → Budgets & Forecasts → Budget vs. Actual. Set the date range to the month just closed. In Xero: Reports → Budget Manager → select the month. In a spreadsheet: open your budget tab and enter actuals in the corresponding column from your income statement.
Flag every variance over 15% on any significant line
Start with revenue lines—these have the largest downstream impact. Then review expense lines. Flag anything over your threshold, whether favorable or unfavorable. A favorable variance is still worth understanding: it may represent deferred spending that will hit next month.
Determine whether each flagged variance is a recording error, a timing difference, or a real change
A missing invoice (recording error) gets corrected in the books. A payment that cleared late (timing difference) resolves itself next month. A real change in revenue or cost structure needs a response: an operational adjustment, a budget note, or a forecast revision.
Check your year-to-date position against the annual budget
A single month's variance is context-dependent. Four consecutive months of the same variance is a trend. Run the BvA for the year-to-date period and compare cumulative actuals to cumulative budget. If the gap is widening, that is the signal that matters most for cash planning.
Write one sentence summarizing the month and one action item
Keep a running log—a single cell in your spreadsheet or a note in your accounting software. “April: overall favorable, referral revenue 47% under budget—follow up with referral sources.” That note is your institutional memory. Without it, every review starts from scratch.
Where to Find the BvA Report in Your Software
| Software | Navigation Path | Notes |
|---|---|---|
| QuickBooks Online | Reports → Budgets & Forecasts → Budget vs. Actual | Requires budget entered under Budgeting tool. Supports monthly, quarterly, and annual views. |
| Xero | Reports → Budget Manager → select period | Budget entered in Budget Manager. Exports to Excel for further analysis. |
| Sage Intacct | Reporting → Financial Reports → Budget vs. Actual | Most flexible format; supports fund-level, program-level, and grant-level BvA for nonprofits. |
| Spreadsheet | Manual: column B = budget, column C = actuals, column D = =C-B, column E = =D/B |
Requires manual data entry from your P&L each month. Works but does not scale. |
| Nonprofit (GAAP) | Statement of Activities: budget vs. actual columns by fund or program | Many funders require a BvA for grant reporting. Build the report format to match the grant's budget template. |
Sources: QuickBooks Help Center (2024); Xero Support (2024); Sage Intacct Documentation (2024); FASB ASC 958 (2016).
Action Steps
- If you built your budget this week following Thursday's system, run your first BvA review right now for the most recently completed month. You already have the budget in place. Pull your actual income and expenses from your accounting software for the same period and drop them into the comparison. Your very first BvA review will tell you immediately whether your budget numbers were realistic—and where you need to calibrate.
- Set the 30-minute monthly review on your calendar today alongside the month-end close. The BvA review is Step 6 of the month-end close checklist—running the P&L and comparing it to budget. If you set the month-end close appointment last week, this is already blocked. If you did not, do it now: last business day of each month, 30 minutes, recurring.
- Establish your variance threshold—the percentage at which you will investigate rather than note and move on. For most small businesses, 15% on variable lines and 10% on revenue lines is a reasonable starting point. Write it down. Having a defined threshold prevents the human tendency to rationalize large variances away (“we'll make it up next month”) and forces the investigation that actually improves financial performance.
- If you are a nonprofit, confirm that your BvA report format matches your grant's budget template. Grant expenditure reports are essentially BvA reports by grant—showing how much of each budget line was spent versus what was approved. If your chart of accounts is not aligned to the grant's budget categories, producing an accurate expenditure report requires manual reconstruction every time. Build the alignment into your budget structure from the start.
References
- AICPA (American Institute of Certified Public Accountants). 2024. Financial Management Best Practices for Small and Mid-Sized Entities. New York: AICPA. https://www.aicpa-cima.com.
- FASB (Financial Accounting Standards Board). 2016. Accounting Standards Update 2016-14: Presentation of Financial Statements of Not-for-Profit Entities (ASC 958). Norwalk, CT: FASB. https://www.fasb.org.
- FASB (Financial Accounting Standards Board). 2023. Accounting Standards Codification: ASC 230 — Statement of Cash Flows. Norwalk, CT: FASB. https://asc.fasb.org/230.
- QuickBooks (Intuit). 2024. How to Create and Use Budget vs. Actual Reports in QuickBooks Online. Intuit Inc. https://quickbooks.intuit.com.
EveryCentCounts
Financial Services & Digital Presence Management — Ladysmith, VA
Our CFO Advisory and bookkeeping teams build, maintain, and review budgets for small businesses and nonprofits across Virginia. Budget-vs-actual reporting, monthly variance analysis, and board-ready financial summaries are a standard part of how we keep our clients financially informed and in control all year long.
Ready to Make Your Budget a Management Tool?
We build budgets, run monthly BvA reviews, and produce the financial reports that keep business owners and nonprofit boards informed and in control. Book a free consultation to find out what a managed budget review looks like for your organization.
Book a Free Consultation