Budget vs actual — how to do it step by step

What is budget vs actual, and why does a small business need it?

Budget vs actual (also called variance analysis) is a table where every category has three numbers next to it: what you planned to earn or spend, what you actually earned or spent, and the difference. It answers one question: is the month going to plan, and if not, where exactly is it off?

A small business doesn't need budget vs actual for compliance — it needs it to manage. The owner of an agency or a clinic usually knows revenue, but often doesn't know that contractors cost 30% more this month or that software subscriptions quietly doubled. Variance analysis makes these things visible while they can still be fixed.

It builds on two other management reports: the profit and loss statement (P&L) shows whether you made money, and the cash flow statement shows whether you have enough of it. The difference is covered in cash flow vs P&L. Budget vs actual lays your expectations on top of those numbers.

Variance formulas: amount, percent, favorable and unfavorable

The variance is calculated the same way for every line. Whether it's good or bad depends on whether the line is income or an expense.

Variance (amount) = actual − budget

Variance (%) = (actual − budget) / budget × 100%

Budget used (%) = actual / budget × 100%

Overspend is an expense category where actual is above budget. Savings deserve a check too: often it's not a saving but a payment that hasn't been recorded yet or was booked to the wrong category.

For checks during the month, use run rate: expected spend to date = budget × days elapsed / days in month. If by the 15th of a 30-day month a category with a $4,000 budget has already spent $3,100 against an expected $2,000, it is heading for overspend even though the budget isn't technically exceeded yet.

How to do budget vs actual step by step

The process below works for a business with monthly revenue from tens of thousands to a few hundred thousand dollars, and it doesn't need a finance department.

1. Define your categories. 10–25 expense categories in 4–6 groups: people, marketing, premises, software, taxes, other. Each category should support a decision: "Advertising" — yes; "Miscellaneous" at 20% of spend — no.
2. Collect history. At least 3 months of actual transactions assigned to those categories. Without history, a budget is a guess. If your history sits in bank statements or Finmap, importing it is faster than retyping — see how to move from Excel or Finmap to a CRM.
3. Set a baseline from history. Two simple methods: "same as last month" for stable lines like rent and subscriptions; "3-month average" for lines that fluctuate (advertising, contractors, consumables).
4. Adjust for this month's decisions. A new project, a rent increase, a planned campaign — anything you already know should go into the budget before the month starts, not get explained as a variance afterwards.
5. Assign owners. Each category has one person who explains its variance: the marketer for advertising, the project lead for contractors, the office manager for supplies.
6. Set a reaction threshold. For example: review a variance only if it is above 10% and above $500 at the same time. Small noise stops eating time, and big amounts don't hide behind small percentages.
7. Review on a schedule. Weekly: run rate on the big categories (5–10 minutes). Monthly, after close: a full review with owners (30–60 minutes).
8. Record decisions. Every variance above the threshold ends in one of three outcomes: fix it (cut, postpone), accept it (raise next month's budget), or reclassify it (a bookkeeping error).

Budget vs actual example: an agency month

Say a digital agency with a team of 12 runs a budget for September. The figures are hypothetical; all calculations use the formulas above. Amounts are in US dollars.

First, the baseline. For two categories, the owner looked at history:

Averages are rounded to $100. The contractors budget was raised to $12,000 for a new project; advertising was set slightly below the average.

September results:

What the table shows:

1. Revenue missed by only 6% and expenses ran 7.5% over, yet profit fell by more than half. That's operating leverage: small variances in income and costs stack up against profit.
2. Three categories crossed the "above 10% and above $500" threshold: advertising, contractors, software. Those are the ones to review with their owners — not all eight lines.
3. Contractors grew by $3,100 while revenue fell. Some work was outsourced but not billed to the client, or will be billed next month. That's a question for the project lead.
4. "Other" came in 34.7% under budget — a reason to check whether some transactions are still uncategorized.

What budget vs actual looks like in a clinic or service business

The logic is the same; the category structure changes. In a clinic, the big lines are doctor and staff pay, consumables, rent, an external lab and advertising. In a field service company, they are field staff, vehicles, materials and advertising.

For costs that grow with revenue (consumables, contractors, piece rates), also track them as a share of revenue. If the budget assumed 13% of revenue and actual came in at 18%, the problem is efficiency, not volume.

How budget vs actual works in 95sales CRM

In 95sales CRM, budget vs actual runs on the same transactions as the P&L, so you never compile actuals by hand. You set a monthly budget for each expense category, plus separate lines for revenue and for "Salaries (payroll sheet)". Each line shows budget, actual, variance and a progress bar with a "today" marker, so you can see whether spending is running ahead of the month. At the top: revenue budget vs actual, expenses budget vs actual, profit and the number of categories over budget.

The baseline takes one click: "Same as last month" copies last month's budget, and "3-month average" calculates the average of actual spending per category, payroll and revenue over the previous three months, rounded to 100. Actuals come from client payments, expenses and payroll, and you can load history by importing bank statements or Finmap data. Month-by-month detail lives in the P&L with category groups and projects.

Common budget vs actual mistakes

1. Budgets pulled out of thin air. Numbers with no basis in history produce variances that mean nothing. Start from past actuals.
2. Too many tiny categories. Nobody reviews 60 lines of $200 each. Merge small ones; keep the ones that drive decisions.
3. A large "Other" category. If more than 5–10% of spending lands there, the analysis loses its point — that's exactly where overspending hides.
4. Reviewing once a quarter. By then the money is gone. Check run rate on the big categories at least weekly.
5. No owner. A variance nobody owns becomes "it just happened."
6. Mixing cash and accrual. If actuals are cash-based but the budget follows invoices, variances will jump between months. Keep budget and actuals on the same basis. More in management accounting for agencies and clinics.
7. Reacting to every line. Without a threshold, the team drowns in noise and eventually stops reading the report.