A business can miss its budget without anyone noticing the real problem.
Imagine a company that planned to generate ₹2.4 crore in quarterly revenue but finished at ₹2.23 crore. The sales shortfall is ₹17 lakh. Management may react by telling the sales team to work harder.
But that may not be the real issue.
Perhaps the company gave deeper discounts, which reduced gross margin. Maybe collections slowed from 42 days to 55 days, tying up cash in unpaid invoices. Maybe marketing spend exceeded plan by ₹6 lakh without producing enough qualified leads. A good budget vs actual report separates these issues and shows management what needs attention first.
A budget vs actual report compares planned financial results with real results for the same period. It explains the gap in rupees, percentages, and business drivers. It is one of the simplest and most useful reports a business can prepare because it turns accounting data into action.
Key Takeaways
- A budget vs actual report compares planned revenue, expenses, profit, cash flow, or departmental spend with actual results.
- The most useful reports show both the rupee variance and percentage variance, then explain whether the difference is favorable or unfavorable.
- Revenue, gross margin, operating expenses, cash flow, accounts receivable, inventory, and debt payments should be reviewed together.
- A positive variance is not always good. Higher revenue may be favorable, while higher payroll or advertising costs may be unfavorable.
- The report should use the same chart of accounts, period definitions, and accounting basis for both budget and actual results.
- Excel, Google Sheets, and LibreOffice Calc are enough for many small and mid-sized businesses. Larger teams may need dedicated budgeting or FP&A software.
- The best budget vs actual report ends with owners, actions, and a revised forecast. It should not stop at showing red and green numbers.
What Is a Budget vs Actual Report?
A budget vs actual report is a financial comparison that shows whether a company performed above or below its plan.
The budget is the target. Actuals are the recorded financial results from the general ledger, accounting software, bank records, payroll system, or operating reports.
A standard report compares:
| Report Item | Budget | Actual | Variance | Variance % | Status |
|---|---|---|---|---|---|
| Revenue | ₹24,00,000 | ₹22,30,000 | ₹(1,70,000) | -7.1% | Unfavorable |
| Cost of Goods Sold | ₹13,20,000 | ₹13,10,000 | ₹(10,000) | -0.8% | Favorable |
| Gross Profit | ₹10,80,000 | ₹9,20,000 | ₹(1,60,000) | -14.8% | Unfavorable |
| Operating Expenses | ₹7,50,000 | ₹8,10,000 | ₹60,000 | 8.0% | Unfavorable |
| EBITDA | ₹3,30,000 | ₹1,10,000 | ₹(2,20,000) | -66.7% | Unfavorable |
This report tells a fuller story than a simple income statement.
Revenue missed plan by ₹1.7 lakh. Cost of goods sold was slightly lower than budget, but gross profit still missed by ₹1.6 lakh because the revenue decline was much larger. Operating expenses were ₹60,000 above plan, which pushed EBITDA down by ₹2.2 lakh.
The report should prompt questions, not just display numbers.
Why did revenue miss? Was the problem lower sales volume, lower prices, lost customers, delayed orders, weak conversion rates, or a missed product launch? Why were expenses higher? Was the overspend intentional, temporary, or avoidable?
Why Budget vs Actual Reporting Matters
A budget is a plan. Actuals show what happened. The variance between them shows where management should investigate.
A company may have a healthy annual budget but still face a cash problem during the year. This often happens when management focuses on revenue and profit but ignores working capital.
Suppose a company has annual credit sales of ₹26.76 crore. Its budget assumed customers would pay in 42 days. Actual collections moved to 55 days.
The extra 13 collection days can tie up approximately ₹95.3 lakh in additional accounts receivable:
₹26.76 crore ÷ 365 × 13 days = about ₹95.3 lakh
The company may still report a profit. Yet it now has almost ₹1 crore less cash available for payroll, suppliers, loan repayments, tax payments, and inventory.
That is why a strong budget vs actual report includes operational metrics such as days sales outstanding, inventory days, customer churn, order volume, and gross margin. Finance teams need to explain what changed in the business, not only what changed in the spreadsheet.
For public companies, historical actuals are commonly drawn from annual Form 10-K and quarterly Form 10-Q filings. The SEC notes that these reports provide details on a company’s business, risks, operating results, and financial position. Form 10-K is filed annually, while Form 10-Q is generally filed after the first three fiscal quarters.
What a Good Budget vs Actual Report Should Include
A useful report usually has six parts.
| Section | Purpose |
|---|---|
| Executive Summary | Explains the biggest financial wins, misses, and required actions |
| Profit and Loss Comparison | Shows budget, actual, variance, and variance percentage |
| Key Operating Drivers | Explains volume, price, customer, staffing, and cost changes |
| Cash and Working Capital | Tracks cash, receivables, inventory, payables, and debt |
| Department Detail | Shows which teams or cost centers drove the result |
| Forecast and Action Plan | Updates the outlook and assigns accountability |
A report should be short enough for management to read but detailed enough for finance and department heads to investigate.
For a small business, that may be one page of summary tables plus a detailed supporting worksheet.
For a larger company, it may include separate sections for sales, marketing, operations, payroll, capital expenditure, cash flow, and business units.
Step 1: Decide What Decision the Report Should Support
Do not start with formulas. Start with the decision.
A monthly management report may need to answer:
- Are we on track to hit the annual revenue target?
- Should hiring continue as planned?
- Is marketing spend producing enough revenue?
- Are gross margins under pressure?
- Do we need to draw on a credit line?
- Which department needs a corrective action plan?
- Should the annual budget be revised?
A report for the CEO should focus on the biggest financial drivers. A report for the marketing director should go deeper into spend, leads, conversion rates, customer acquisition cost, and campaign results.
The report needs a clear audience. A 20-page expense ledger is not useful for a CEO. A one-line summary is not useful for the finance manager responsible for checking payroll, supplier costs, and accruals.
Step 2: Set the Reporting Period and Financial Basis
The budget and actual figures must cover the same period.
Compare January actuals with January budget. Compare year-to-date actuals with year-to-date budget. Compare full-year forecast with the full-year operating plan.
Avoid comparing a full month of expenses with revenue that is only recorded through the middle of the month.
You should also confirm whether both figures use the same accounting basis.
For example, a company may budget marketing expenses on an accrual basis but look at bank payments for actuals. That can create a misleading variance because cash may leave the bank before or after the expense appears in the income statement.
Use consistent definitions for:
- Reporting period
- Currency
- Entity or business unit
- Department code
- Account code
- Accrual or cash basis
- Tax treatment
- One-time expenses
- Internal transfers
If the accounting close is not finished, label the report as preliminary. It is better to show a preliminary report honestly than present incomplete results as final actuals.
Step 3: Use the Same Chart of Accounts for Budget and Actuals
The budget should use the same account structure as the actual general ledger.
For example, if actual payroll is split into salaries, bonuses, benefits, payroll taxes, and contractors, the budget should use the same categories.
A clean mapping table makes this easier.
| Account Code | Account Name | Report Category | Department |
|---|---|---|---|
| 4000 | Product Revenue | Revenue | Sales |
| 4010 | Services Revenue | Revenue | Services |
| 5000 | Product Cost | Cost of Goods Sold | Operations |
| 6100 | Salaries | Payroll | Corporate |
| 6200 | Paid Advertising | Marketing | Growth |
| 6300 | Software Subscriptions | Operating Expense | Technology |
This structure prevents one of the most common reporting mistakes: comparing broad budget categories with highly detailed actual categories.
For example, a budget may include “Marketing” as one ₹10 lakh line item, while actuals contain 25 separate accounts. The report becomes hard to interpret unless those actual accounts are mapped back to the same reporting category.
Step 4: Build the Core Budget vs Actual Formula
The basic formula is straightforward.
Variance in Rupees = Actual − Budget
For revenue, a positive result is usually favorable because the company earned more than planned.
For expenses, a positive result is usually unfavorable because the company spent more than planned.
A percentage variance adds context:
Variance Percentage = (Actual − Budget) ÷ Absolute Budget
In Excel, a simple version is:
=IF(Budget_Cell=0,"n.m.",(Actual_Cell-Budget_Cell)/ABS(Budget_Cell))
The n.m. result means “not meaningful.” It is useful when the budget was zero. Dividing by zero creates an error, while showing a 500% variance on a ₹1 budget line may exaggerate an unimportant issue.
You also need a favorable or unfavorable status.
| Metric Type | Actual Compared With Budget | Status |
|---|---|---|
| Revenue | Actual is higher | Favorable |
| Revenue | Actual is lower | Unfavorable |
| Expense | Actual is lower | Favorable |
| Expense | Actual is higher | Unfavorable |
| Profit | Actual is higher | Favorable |
| Cash Balance | Actual is higher | Usually favorable |
A practical Excel formula may look like this:
=IF(Account_Type="Revenue",
IF(Actual>=Budget,"Favorable","Unfavorable"),
IF(Account_Type="Expense",
IF(Actual<=Budget,"Favorable","Unfavorable"),
IF(Actual>=Budget,"Favorable","Unfavorable")))
Do not rely only on red and green formatting. A lower travel expense can be favorable, but it may also mean the sales team cancelled customer meetings. Context matters.
Step 5: Create a Monthly Budget vs Actual Profit and Loss Report
The income statement is usually the starting point.
Here is a practical monthly report for a consumer-products business.
| Profit and Loss Item | Budget | Actual | Variance | Variance % | Status |
|---|---|---|---|---|---|
| Revenue | ₹24,00,000 | ₹22,30,000 | ₹(1,70,000) | -7.1% | Unfavorable |
| Cost of Goods Sold | ₹13,20,000 | ₹13,10,000 | ₹(10,000) | -0.8% | Favorable |
| Gross Profit | ₹10,80,000 | ₹9,20,000 | ₹(1,60,000) | -14.8% | Unfavorable |
| Gross Margin | 45.0% | 41.3% | -3.7 points | N/A | Unfavorable |
| Payroll | ₹4,20,000 | ₹4,55,000 | ₹35,000 | 8.3% | Unfavorable |
| Marketing | ₹1,40,000 | ₹1,65,000 | ₹25,000 | 17.9% | Unfavorable |
| Rent and Utilities | ₹90,000 | ₹90,000 | ₹0 | 0.0% | On Plan |
| Other Operating Expenses | ₹1,00,000 | ₹1,00,000 | ₹0 | 0.0% | On Plan |
| EBITDA | ₹3,30,000 | ₹1,10,000 | ₹(2,20,000) | -66.7% | Unfavorable |
The report shows three main problems.
First, revenue missed budget by 7.1%.
Second, gross margin fell by 3.7 percentage points. This suggests the company may have discounted products, sold a lower-margin product mix, faced higher supplier costs, or absorbed additional shipping expenses.
Third, payroll and marketing costs exceeded plan by ₹60,000 combined.
The finance team should not simply write “EBITDA missed budget by ₹2.2 lakh.” It should explain the drivers.
| Variance Driver | Financial Effect | Management Question |
|---|---|---|
| Lower sales volume | ₹1,05,000 revenue shortfall | Did traffic, leads, conversions, or customer retention decline? |
| Higher customer discounts | ₹65,000 gross-profit impact | Did discounting increase enough unit volume to justify the margin loss? |
| Payroll overspend | ₹35,000 cost overrun | Was overtime, new hiring, or contractor spend approved? |
| Marketing overspend | ₹25,000 cost overrun | Did the extra spend create qualified leads or measurable future revenue? |
This turns the report into a management tool.
Step 6: Add Year-to-Date Results and a Revised Forecast
A monthly report tells you what happened recently. A year-to-date report tells you whether the annual plan remains realistic.
Suppose the company had a full-year revenue budget of ₹9.6 crore. After the first quarter, it is ₹24 lakh below plan.
Management now has two choices.
It can keep the original annual budget and expect the sales team to recover the gap. Or it can revise the forecast.
If the remaining annual revenue budget is ₹7.2 crore, the company needs to outperform the rest-of-year budget by:
₹24 lakh ÷ ₹7.2 crore = 3.3%
That may be achievable. It may also be unrealistic.
A revised forecast should show the expected full-year result under current conditions.
| Full-Year Metric | Original Budget | Revised Forecast | Difference |
|---|---|---|---|
| Revenue | ₹9.60 crore | ₹9.20 crore | ₹(40 lakh) |
| Gross Margin | 45.0% | 42.0% | -3.0 points |
| EBITDA | ₹1.32 crore | ₹84 lakh | ₹(48 lakh) |
| Capital Expenditure | ₹36 lakh | ₹24 lakh | ₹(12 lakh) |
| Year-End Cash | ₹1.10 crore | ₹68 lakh | ₹(42 lakh) |
The revised forecast may show that the business can protect cash by delaying equipment purchases, pausing lower-return marketing campaigns, slowing hiring, or improving collections.
This is why the forecast belongs in the same reporting package as the budget vs actual report.
Step 7: Include Cash, Receivables, and Inventory
A company can be on budget for revenue and still miss its cash target.
The report should include a liquidity section.
| Cash and Working Capital Metric | Budget | Actual | Variance | Status |
|---|---|---|---|---|
| Ending Cash Balance | ₹1.10 crore | ₹82 lakh | ₹(28 lakh) | Unfavorable |
| Days Sales Outstanding | 42 days | 55 days | 13 days | Unfavorable |
| Inventory Days | 60 days | 71 days | 11 days | Unfavorable |
| Accounts Payable Days | 35 days | 39 days | 4 days | Favorable, but monitor supplier risk |
| Debt Balance | ₹2.50 crore | ₹2.50 crore | ₹0 | On Plan |
| Interest Expense | ₹5.25 lakh | ₹5.80 lakh | ₹55,000 | Unfavorable |
A higher accounts payable balance can improve short-term cash because the company is taking longer to pay suppliers. But it can also damage supplier relationships or cause the company to lose early-payment discounts.
The report should explain the trade-off rather than label every lower cash outflow as a win.
Step 8: Build the Report in Excel, Google Sheets, or LibreOffice Calc
For many businesses, a spreadsheet is enough.
A simple workbook can have five tabs:
| Worksheet | Purpose |
|---|---|
| Actuals | General-ledger or accounting-system export |
| Budget | Approved monthly or annual budget |
| Mapping | Chart-of-accounts and department mapping |
| Report | Budget vs actual tables, formulas, and commentary |
| Dashboard | Management charts, KPIs, forecast, and action plan |
Excel is particularly useful for financial reporting because it supports structured tables, formulas, PivotTables, conditional formatting, charts, and connection workflows. Microsoft states that PivotTables can summarize, analyze, explore, and present summary data, while PivotCharts can show comparisons, patterns, and trends visually.
Use an Excel Table for the raw actuals rather than placing data in disconnected blocks across a worksheet. This makes it easier to filter, refresh, and build PivotTables.
A typical raw-data table may include:
| Date | Account Code | Department | Budget Amount | Actual Amount | Month | Report Category |
|---|---|---|---|---|---|---|
| Apr. 30 | 4000 | Sales | ₹8,00,000 | ₹7,40,000 | April | Revenue |
| Apr. 30 | 6200 | Growth | ₹45,000 | ₹58,000 | April | Marketing |
| Apr. 30 | 6100 | Corporate | ₹1,40,000 | ₹1,48,000 | April | Payroll |
Once the data is structured, create a PivotTable by department, category, month, or manager. Excel’s standard process is to select the data range, choose Insert, then select PivotTable. Microsoft recommends source data organized in columns with a single header row.
Google Sheets also supports PivotTables, with each source column requiring a header. Google notes that its PivotTables refresh when the underlying source data changes.
Step 9: Use Conditional Formatting Carefully
Conditional formatting helps management spot material variances quickly.
For example:
- Revenue variance below -5%: highlight for review
- Gross margin decline greater than 2 percentage points: highlight for review
- Department expense overspend above 10%: highlight for review
- Cash balance below the minimum operating threshold: highlight for review
- Accounts receivable more than 10 days above target: highlight for review
Microsoft explains that conditional formatting can make patterns and trends easier to identify by applying formatting rules based on cell values.
Use this feature to direct attention, not to replace analysis.
A ₹1 lakh overspend in office supplies may be less important than a ₹10 lakh revenue shortfall. A 200% marketing variance may be immaterial if the budget was only ₹5,000.
Set thresholds based on rupee impact and percentage impact.
Step 10: Write Variance Commentary That Explains the Business
The commentary is often more valuable than the report itself.
Weak commentary:
“Revenue was below budget.”
Better commentary:
“April revenue was ₹1.7 lakh below plan, primarily due to 12% lower order volume in the South region. Average selling price was also 3% below budget because the company extended a promotional discount to clear older inventory. Management expects half of the volume gap to recover in May, but the gross-margin impact is expected to continue until supplier pricing is renegotiated.”
A good variance note answers four questions:
| Question | Example Answer |
|---|---|
| What changed? | Revenue was ₹1.7 lakh below budget |
| Why did it change? | Lower order volume and deeper discounts |
| Is it temporary or structural? | Discounts may continue through the next quarter |
| What action is required? | Review pricing, supplier terms, and campaign-level marketing returns |
This is the point where finance becomes useful to operations.
Common Budget vs Actual Reporting Mistakes
Comparing Incomplete Actuals With a Full Budget
Do not compare a full month of budget with actuals that only include three weeks of sales or invoices.
Either wait for the close or clearly label the report as preliminary.
Using Different Account Categories
Budget and actuals should use the same reporting categories.
A budget line called “Operations” cannot be meaningfully compared with 30 ungrouped general-ledger accounts.
Ignoring Favorable Expense Variances
Lower spending is not always good.
A lower payroll number may indicate vacant roles. Lower marketing spend may explain lower sales. Lower maintenance expense may mean the company deferred a needed repair.
Reviewing Only the Profit and Loss Statement
Cash flow, receivables, inventory, debt, capital expenditure, and tax payments often explain why a profitable business feels short of cash.
Reporting Variances Without Assigning Action
A report should show the responsible owner and the next step.
| Issue | Owner | Required Action | Due Date |
|---|---|---|---|
| Revenue shortfall in South region | Sales Director | Review pipeline and lost-deal reasons | May 10 |
| Marketing overspend | Growth Lead | Pause low-return campaigns and submit ROI review | May 7 |
| Higher DSO | Finance Manager | Contact top overdue customers and revise collection plan | May 5 |
| Gross-margin decline | Operations Director | Renegotiate supplier rates and review pricing | May 15 |
Without ownership, the same variance can appear in every monthly report without being fixed.
The Cost of Making a Budget vs Actual Report
The report itself does not have a transaction fee. The cost comes from software, data preparation, finance-team time, and review.
The pricing below uses publicly listed India prices as of July 7, 2026. GST may apply to Microsoft business plans, and vendor prices can change.
| Tool or Cost Factor | Published Price | Best Use | Hidden Cost to Consider |
|---|---|---|---|
| Excel for the web | Free | Basic reports and collaboration | Limited offline and advanced desktop workflows |
| LibreOffice Calc | Free | Offline spreadsheets and low-cost reporting | More manual collaboration and file control |
| Microsoft 365 Business Basic | ₹170 per user per month, paid yearly | Web and mobile Excel, business email, cloud storage | GST extra; desktop Excel is not included |
| Microsoft 365 Apps for Business | ₹830 per user per month, paid yearly | Desktop Excel, advanced models, offline work | GST extra; annual subscription auto-renews |
| Google Workspace Business Starter | ₹270 per user per month with annual commitment | Shared Google Sheets reporting and collaboration | The plan is best for lighter spreadsheet workflows |
| Accountant or FP&A review | Quote-based | Report validation, commentary, cash forecasting | Cost depends on company size and data quality |
| Dedicated planning software | Quote-based | Multi-entity reporting, workflow approvals, forecast consolidation | Setup, integrations, training, and ongoing administration |
Microsoft lists Excel for the web as free to use online. In India, Microsoft 365 Business Basic is listed at ₹170 per user per month on annual billing and includes web and mobile versions of Excel, while Microsoft 365 Apps for Business is listed at ₹830 per user per month on annual billing and includes desktop Excel. GST is extra where applicable.
Google Workspace lists its Starter plan at ₹270 per user per month with an annual commitment. LibreOffice states that its office suite, including Calc, is free and open source, with free downloads for Windows, macOS, and Linux.
The largest hidden cost is usually manual work. If finance staff spend hours every month correcting account mappings, chasing department heads for explanations, or rebuilding reports because the workbook was overwritten, the true cost can exceed the software subscription.
Excel vs Google Sheets vs LibreOffice Calc for Budget vs Actual Reports
| Feature | Microsoft Excel | Google Sheets | LibreOffice Calc |
|---|---|---|---|
| Starting Cost | Free on web, or paid Microsoft 365 plan | Included with Google Workspace or standard Google account | Free |
| Offline Work | Strong with desktop Excel | More limited | Strong |
| Collaboration | Strong through OneDrive and SharePoint | Excellent live editing and comments | Limited compared with cloud-first tools |
| PivotTables | Strong for large reports and detailed analysis | Suitable for standard budget reports | Suitable for basic to mid-level reports |
| Conditional Formatting | Strong and detailed | Good for standard variance flags | Good for standard rules |
| Complex Financial Models | Excellent | Good for lighter to moderate models | Good for simple to mid-level models |
| Best For | Finance teams, analysts, detailed reporting | Startups and teams working in one shared file | Cost-sensitive offline users |
Excel wins when the report includes complex account mapping, large data exports, multi-sheet financial models, advanced formulas, detailed PivotTables, and offline work.
Google Sheets wins when several department heads need to comment on the same live report without emailing different file versions back and forth.
LibreOffice Calc wins when cost is the main issue and the business needs a free offline spreadsheet tool. LibreOffice describes Calc as a spreadsheet application for analyzing data, calculating figures, and creating visuals.
Final Strategic Verdict
A budget vs actual report is perfect for any business that has a budget, spends money across departments, or needs to understand why financial performance changed.
Small businesses can begin with a monthly profit-and-loss comparison, cash balance, receivables aging, and three to five key operating metrics.
Growing businesses should add year-to-date results, rolling forecasts, department owners, customer or product analysis, and a cash-flow section.
Larger businesses should use standardized account mappings, formal close timelines, review controls, and a reporting process that connects budget, actuals, forecast, and management actions.
Avoid building an overly complicated report before the accounting data is clean. First make sure the general ledger is accurate, accounts are mapped correctly, and the reporting period is complete.
The report should make one thing clear: what changed, why it changed, what it means for profit and cash, and what management needs to do next.