Budget vs Actual: A Monthly Review Framework for SMBs

Why Most SMB Budgets Fail

Here is the pattern we see repeatedly with Brazilian SMBs: The owner and their accountant build a budget in January. By March, nobody is looking at it. By June, it is forgotten entirely. By December, the owner wonders why the year did not go as planned. Learn more about our financial strategy services.

The problem is rarely the budget itself. The problem is the absence of a monthly review ritual — a structured process for comparing what you planned against what actually happened, understanding why they differ, and taking corrective action.

This is budget vs. actual analysis, and it is the single most important financial discipline for companies in the R$2M–R$50M range.

Step 1: Build a Budget Worth Reviewing

A budget is only useful if it is realistic, structured, and simple enough to actually review every month.

Budget Structure for Brazilian SMBs

Section	Line Items	Notes
Revenue	3-5 revenue streams	By product line, service type, or client segment
Deductions	Tax deductions (ICMS, PIS, COFINS, ISS)	As % of gross revenue by tax regime
COGS	Direct materials, direct labor, freight	Tied to revenue drivers
Gross Profit	Calculated	Target: industry benchmark ± 5%
Operating Expenses	8-12 categories	Payroll, rent, marketing, technology, travel, professional services, utilities, insurance, misc
EBITDA	Calculated	Your primary operating target
Below the line	Interest, depreciation, taxes	Financing and accounting items
Net Profit	Calculated	Bottom line target

Common Budgeting Mistakes

Mistake 1: Budget from zero every year. Unless your business model is changing dramatically, start with last year’s actuals and adjust. Zero-based budgeting sounds elegant but takes too long for most SMBs.

Mistake 2: Budget revenue optimistically and costs conservatively. This creates a fantasy budget you will never hit. Be honest about both sides. If anything, budget revenue conservatively and costs realistically.

Mistake 3: Lump everything into “Other.” If your “other expenses” category is more than 5% of operating expenses, break it down further. Hidden costs live in “other.”

Mistake 4: Forget about seasonality. Brazilian SMBs often have significant seasonal patterns. Distribute your annual budget by month based on historical patterns, not just dividing by 12.

Monthly Distribution Template

Do not divide your annual budget by 12. Use a weighted distribution based on historical revenue patterns:

Month	Typical Weight (Services)	Typical Weight (Retail)
January	6%	5%
February	6%	5%
March	8%	7%
April	8%	8%
May	9%	9%
June	8%	8%
July	8%	7%
August	9%	8%
September	9%	9%
October	9%	10%
November	10%	12%
December	10%	12%

Adjust these percentages based on your own historical data from the last 2–3 years.

Step 2: Close the Books by the 5th

You cannot review budget vs. actual if your books are not closed. This is where most SMBs break down.

Monthly Closing Calendar

Day	Task	Owner
Day 1	Bank reconciliation complete	Finance / Accounting
Day 2	All invoices posted, payroll processed	Accounting firm
Day 3	Inventory count reconciled (if applicable)	Operations
Day 4	Accruals posted, preliminary P&L generated	Accounting firm
Day 5	Books closed, final P&L and balance sheet available	Accounting firm
Day 8-10	Management review meeting	Owner + leadership

If your accounting firm cannot close your books by the 5th of the following month, this is a serious operational problem. Consider whether you need a different firm or an in-house bookkeeper to prepare for the external accountant.

What “Closed Books” Means

• All revenue recognized for the period
• All expenses posted (including accruals for known but unpaid expenses)
• Bank statements reconciled to the general ledger
• Payroll and social charges posted
• Tax obligations calculated
• Inventory adjusted (for product companies)

Step 3: Build the Variance Report

The variance report is the core document for your monthly review. It compares budgeted vs. actual figures for every line item.

Variance Report Template

Line Item	Budget	Actual	Variance (R$)	Variance (%)	Status
Gross Revenue	500,000	475,000	-25,000	-5.0%	Watch
Net Revenue	400,000	380,000	-20,000	-5.0%	Watch
COGS	200,000	210,000	-10,000	-5.0%	Watch
Gross Profit	200,000	170,000	-30,000	-15.0%	Alert
Payroll	80,000	82,000	-2,000	-2.5%	OK
Marketing	15,000	22,000	-7,000	-46.7%	Alert
EBITDA	60,000	35,000	-25,000	-41.7%	Alert

Color-Coding System

• Green (OK): Variance within ±5%
• Yellow (Watch): Variance between 5–10%
• Red (Alert): Variance above 10% or above R$10,000

Types of Variances

Not all variances are created equal. Categorize each significant variance:

Timing variances — The money was spent or earned, just in a different month than planned. These correct themselves. Example: a supplier invoice arrived early.

Volume variances — You sold more or fewer units than planned. This affects revenue and variable costs proportionally.

Price variances — You sold at a different price or paid a different cost than planned. This affects margins.

Structural variances — Something fundamentally changed. A new hire, a lost client, a regulatory change. These do not self-correct and require action.

Step 4: The Monthly Review Meeting

This is where the discipline pays off. Block 90 minutes on the calendar between the 8th and 10th of every month. This meeting is non-negotiable.

Attendees

• Business owner / CEO
• Finance lead (CFO, controller, or bookkeeper)
• Operations lead
• Sales / commercial lead

For smaller companies, this may be just 2–3 people. That is fine.

Agenda (90 Minutes)

Time	Topic	Focus
0-10 min	Revenue review	Actual vs. budget, pipeline, forecast
10-25 min	Gross margin analysis	COGS variances, pricing issues, mix changes
25-40 min	Operating expense review	Top 3 variances by magnitude
40-55 min	Cash flow and balance sheet	Working capital, collections, upcoming obligations
55-75 min	Action items from variances	Specific corrective actions with owners and deadlines
75-90 min	Forward look	Next month forecast, risks, opportunities

Five Questions to Answer Every Month

1. Are we on track for our annual revenue target? Calculate year-to-date actual vs. year-to-date budget. If you are behind, what is the recovery plan?

2. Which variances are structural vs. timing? Do not panic about timing differences. Focus your energy on structural changes that will persist.

3. What are the top 3 variances by dollar impact? You cannot investigate everything. Focus on the three largest deviations and understand them deeply.

4. What corrective actions do we need to take? Every significant negative variance should have a specific action: renegotiate a contract, adjust pricing, pause hiring, accelerate collections.

5. Do we need to update our rolling forecast? If actuals are consistently different from budget, your forecast needs to reflect the new reality.

Step 5: Take Corrective Action (and Track It)

The review is worthless without action. Every meeting should produce 3–5 specific action items.

Corrective Action Framework

Variance Type	Typical Corrective Actions
Revenue shortfall	Accelerate pipeline, launch promotion, expand to new segment, revisit pricing
COGS overrun	Renegotiate supplier terms, find alternative suppliers, review waste, adjust product mix
Payroll overrun	Freeze new hires, review overtime, defer non-critical positions
Marketing overrun	Pause low-ROI campaigns, shift budget to higher-performing channels
Working capital squeeze	Tighten payment terms for new clients, accelerate collections, negotiate extended payables

Action Item Tracker

Every action item needs three things:

1. Owner — One specific person responsible (not a department, a person)
2. Deadline — A specific date, not “soon” or “next month”
3. Success metric — How will you know it worked?

Track these in a simple spreadsheet or project management tool. Review status at the start of each monthly meeting.

The Rolling Forecast

In addition to your fixed annual budget, maintain a rolling 3-month forecast that you update each month. This captures your current best estimate of where you are heading.

Element	Annual Budget	Rolling Forecast
Time horizon	Full year, set in January	Next 3 months, updated monthly
Purpose	Accountability benchmark	Current trajectory
Flexibility	Frozen (do not change)	Updated with latest data
Comparison	Actuals vs. budget	Actuals vs. forecast
Value	Measures plan accuracy	Guides operational decisions

Building the Habit

The hardest part of budget vs. actual analysis is not the analysis — it is the discipline. Here are practical tips for making the monthly review stick:

Calendar Commitment

• Block the review meeting for the entire year in January
• Make it recurring — same day, same time, same room
• No cancellations unless the building is on fire
• Send the variance report 48 hours before the meeting so people come prepared

Progressive Complexity

Months 1–3: Just get the basics right. Close books by the 5th, build the variance report, hold the meeting. Do not worry about perfection.

Months 4–6: Add rolling forecast. Start tracking action items formally. Introduce variance categories (timing, volume, price, structural).

Months 7–12: Refine your budget model based on learnings. Add department-level budgets. Introduce KPIs alongside financial metrics.

Common Objections (and Responses)

“We do not have time for monthly reviews.” You do not have time not to. Companies that review monthly catch problems 8 weeks earlier on average. The cost of late discovery far exceeds 90 minutes per month.

“Our accounting firm is always late.” Set clear expectations. If they cannot close by the 5th, provide the information they need by the 28th of the current month. If they still cannot perform, consider alternatives.

“The budget was wrong from the start.” That is exactly why you do this. Each month teaches you to budget better. By year two, your budgets will be materially accurate.

“Things change too fast for budgets.” That is why you pair the fixed budget with a rolling forecast. The budget measures your planning ability; the forecast tracks reality.

What Good Looks Like

After 6–12 months of disciplined budget vs. actual reviews, here is what our financial strategy clients typically achieve:

• Revenue forecasts accurate within ±5% on a monthly basis
• No cash flow surprises — all major outflows anticipated 4+ weeks ahead
• Operating expense growth consistently below revenue growth
• Faster decision-making because data is fresh and shared
• Better relationships with banks and lenders because you can explain your numbers

The companies in the R$2M–R$50M range that do this consistently outperform their peers. Not because the budget itself is magic, but because the discipline of monthly review forces accountability, surfaces problems early, and creates a shared financial language across the leadership team.

---

Want to assess how your financial management practices compare to industry benchmarks? Take our free diagnostic — 5 minutes, completely confidential, actionable results.