Budget vs actuals for small companies: a weekly view instead of a quarterly surprise
A budget only steers the business if you can see the gap while there is still time to act. How to set up budget vs actuals that stays current, with a worked example.
David van Duijn7 min read
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
On this page
Budget vs actuals is the comparison between what you planned to earn and spend in a period and what the books show you actually earned and spent. For a small company it is only useful when you see it while the period is still running, because that is the only moment you can still change the outcome.
Most growing companies have a budget, and most of them look at it properly about four times a year. In between, decisions are made on feel. A freelancer is extended, a trade fair is booked, a hire starts a month early. When the quarterly comparison finally arrives, it explains what happened instead of changing it.
This post is for finance leads, controllers and founders who run their own finance in companies of roughly 5 to 200 people. It covers what a live comparison needs, a worked example, and how finance agents change who does the weekly work.
Why does quarterly budget vs actuals fail?
A quarterly review fails for a simple reason. The information arrives after the decisions it should have informed.
There are three usual causes, and they reinforce each other.
- The books lag. Supplier invoices sit in an inbox for two weeks, the bank is reconciled at month-end, and accruals only appear during the close. Any comparison made before the close is comparing the budget with an incomplete ledger.
- Every comparison is a small project. The budget lives in one file and the actuals in the ledger, with account names that no longer line up. Producing a single report costs somebody a day, so nobody asks for it often.
- The budget is annual, not phased. An annual figure divided by twelve does not match how costs actually fall. Insurance is paid in January, the trade fair is in April, holiday pay builds up all year. So every month shows variances that are not real, and people stop reading them.
Fix those three and the review stops being a project. It becomes a page you glance at on Monday.
What do you need for a live budget comparison?
You need four things. None of them needs a large finance team, but all four have to be true at the same time.
1. Books that are current during the month
This is the foundation, and it is the one most companies skip. If the bank is reconciled daily and supplier invoices are booked when they arrive, your profit and loss on the 12th of the month is a fair picture of the first 12 days. If not, the comparison is meaningless until the close.
Current does not mean perfect. It means the large items are in, and you know which ones are still missing.
2. A budget mapped to your chart of accounts
The budget has to speak the same language as the ledger. That does not mean budgeting on every one of your 140 accounts. Budget on a sensible grouping, such as revenue per product line, personnel, marketing, software, housing and other costs, and make sure every ledger account belongs to exactly one budget line.
Write the mapping down once. If an account is added later, it needs a budget line too, otherwise its costs quietly fall outside the comparison.
3. Monthly phasing that follows reality
Spread each line over the months in the way the money will actually be booked. Salaries are flat, with a bump in May when Dutch holiday pay is usually paid out if you book it on payment rather than accruing it monthly. Annual licences either land in one month or are released evenly as a prepayment, depending on how your accountant books them. Seasonal revenue follows last year's pattern.
The rule is that the budget should be phased the same way the books are kept. If you accrue holiday pay monthly, phase it monthly. If you book the annual insurance as a prepayment, phase it evenly.
4. Saved budget versions
Budgets change. You raise money, lose a client or decide to hire earlier. Keep the original budget as version one and save each reforecast as a new version. Compare actuals against the latest version to steer, and against the original to explain the year to your board or bank.
A worked example: March at a Dutch services company
Here is an illustrative example for a company of about 25 people. The numbers are invented, and they add up.
The budget for March:
- Revenue €120,000
- Personnel €62,000
- Freelancers €9,000
- Software €4,500
- Housing €6,500
- Other costs €5,000
- Total costs €87,000, operating result €33,000
The actuals for March:
- Revenue €112,400
- Personnel €62,850
- Freelancers €12,300
- Software €4,420
- Housing €6,500
- Other costs €4,180
- Total costs €90,250, operating result €22,150
The operating result is €10,850 below budget. That gap has two parts. Revenue is €7,600 short, and costs are €3,250 over. Within costs, freelancers are €3,300 over (37% above plan), personnel €850 over, software €80 under and other costs €820 under. Together that is €850 + €3,300 − €80 − €820 = €3,250.
Seen at the end of the quarter, this is just a weak month. Seen on the 10th of March, it is two decisions. The freelancer overspend came from a contract that was extended by three weeks without a budget change, and in a live view it would have shown up the week it was extended. The revenue gap came from one project that slipped into April, which is a timing difference rather than a lost sale, and worth saying so to the board before they ask.
How do you tell a real variance from a timing difference?
Not every gap deserves attention. Sort each variance into one of three groups before anyone reacts to it.
- Timing. The cost or revenue will still happen, just in a different month. A project slipping by two weeks, an invoice that arrived late. These usually reverse next month.
- Booking. The variance exists only because something was booked to a different account or period than the budget assumed. A software subscription booked under marketing, an invoice dated in the wrong month. Fix the booking, not the budget.
- Real. The business is earning or spending differently than planned. A freelancer extended, a price increase that did not land, a hire made earlier. These are the ones that need a decision.
A useful habit is to only discuss lines that are more than 10% and more than €1,000 away from budget. Smaller gaps are noise at this size of company. Pick thresholds that fit your own business and write them down, so the weekly review stays short.
How often should you look?
Weekly for a handful of lines, monthly for the full picture.
A good weekly view fits on one screen. Revenue so far against the phased budget, the three or four cost lines that move, cash, and anything over your threshold. It takes five minutes when the books are current.
The monthly review is where you look at every line, agree on the timing and booking variances, and decide whether the budget needs a new version. Give each budget line an owner. The person who runs marketing should explain the marketing variance, not the finance lead.
Common mistakes
- Comparing against an unfinished month without saying so. Mid-month, payroll may not be booked yet, so show the budget to date or mark which large items are still expected.
- Budgeting VAT-inclusive amounts. For a business that can reclaim VAT the profit and loss is net, so a gross budget makes every cost line look 21% better than it is.
- Letting unmapped accounts pile up. A new ledger account without a budget line is invisible.
- Overwriting the original budget, which leaves you unable to explain the year.
How do finance agents change budget vs actuals?
The comparison itself is arithmetic. The work around it is what eats a finance lead's week, and that is where agents help.
- Keeping the actuals current. An agent that reconciles bank lines and books supplier invoices on arrival is what makes a mid-month comparison possible in the first place. Without that, nothing else in this list works.
- Checking the mapping. When a new ledger account appears, an agent can spot that it has no budget line and ask which one it belongs to, instead of the costs disappearing from the report.
- Sorting variances before you see them. For each line over your threshold, an agent can open the underlying entries and say what drives the gap: one invoice dated in the wrong month (booking), a project that moved to April (timing), or a freelancer contract that kept running (real). You start the review with explanations, not a list of numbers.
- Writing the weekly note. A short Monday summary per budget owner, with the lines that moved and the entries behind them, replaces the meeting where someone reads the spreadsheet aloud.
What stays with people is the judgement. Whether the extension was worth it, whether to reforecast, what to tell the board. An agent can prepare all of that. It should not decide it.
Where Thred fits
Most of the work above is not budgeting. It is keeping the books current enough that the comparison can be trusted. That is the part Thred takes off your plate: agents reconcile bank and payment transactions and book supplier invoices as they come in, so your profit and loss reflects today rather than last month-end.
With books that current, budget vs actuals stops being a spreadsheet you rebuild. You ask for it in chat and get a dashboard built from live numbers, and The Analyst, the agent that explains the numbers, sends a weekly summary. It works on top of the ledger you already use through Thred Layer, or on Thred's own ledger. You keep the budget and the decisions.
If you want a budget that steers the business every week, book a demo and we will show you on your own numbers.
Frequently asked questions
How do you calculate a budget variance?
Subtract the budgeted amount from the actual amount for the same line and period, and divide by the budget to get a percentage. A cost line budgeted at €9,000 with €12,300 actual has a variance of €3,300, or about 37% over plan.
What is the difference between a timing variance and a real variance?
A timing variance means the cost or revenue will still happen, but in another period, such as a project that slips by two weeks. A real variance means the business is earning or spending differently than planned and usually needs a decision.
Should a budget include VAT?
If your business can reclaim VAT, budget net amounts, because the profit and loss is kept excluding VAT. A budget with VAT-inclusive costs will not line up with the ledger. Check with your accountant if part of your VAT is not recoverable.
How often should a small company review budget vs actuals?
A short weekly look at revenue, cash and the few cost lines that move, and a full monthly review of every line. Weekly only works if bank transactions and supplier invoices are booked during the month rather than at the close.
Can AI prepare a budget vs actuals report?
Agents can keep the actuals current, check that every ledger account maps to a budget line, and explain which entries drive each large variance. The decisions about reforecasting and what to change stay with the finance lead and budget owners.
Sources
Read next
- Year-end close in the Netherlands: a practical checklist for small companies
- Automated accounting controls for small companies, and which ones matter
- What AI tools really cost a finance team, and how to justify the spend
Where Thred comes in
For finance leaders who want more capacity without more headcount.



