Budget vs actuals: a simple monthly routine for small teams
Budget vs actuals means comparing what you planned to earn and spend with what really happened. The budget is the plan. The actuals are the real figures. Done once a month, the comparison takes a small team less than an hour. It answers three questions: where did things turn out differently, why, and what do we change?
Why it is worth the hour
Most households know the feeling. You planned 400 for food this month, and at the end the bank account shows 520. If you look once a month, you can still react. If you only look at the end of the year, the money is gone and nobody remembers why.
One thing matters here. A difference is not good or bad in itself. Spending more on advertising in a month when sales doubled may be exactly right. The aim is to notice and decide, not to blame anyone.
An example
A small agency looks at its costs for March.
| Cost | Planned | Actual | Difference |
|---|---|---|---|
| Salaries | 30,000 | 30,000 | 0 |
| Freelancers | 4,000 | 6,200 | 2,200 over |
| Software | 1,500 | 1,620 | 120 over |
| Advertising | 2,000 | 900 | 1,100 under |
| Travel | 800 | 1,150 | 350 over |
| Total | 38,300 | 39,870 | 1,570 over |
The total looks harmless. The single lines tell more.
Freelancers cost 2,200 more than planned. One project needed extra design work that was not in the price the customer agreed to. Advertising is 1,100 under, because a campaign was moved to April. Software is slightly over and not worth a conversation.
Two decisions follow. First, ask whether the extra design work can be charged to the customer. Second, move the advertising money into the April plan. That is the whole point of the exercise.
Which differences deserve attention
Agree on a limit in advance, so the meeting does not get lost in small amounts. A simple rule: only talk about lines that are off by more than an amount that matters to you, for example 500. In the table, that leaves freelancers and advertising. Travel is 350 over, so it gets a glance and nothing more.
For each line above the limit, ask which of three kinds it is.
- Moved. The cost or income landed in another month. Shift it in the plan and you are done.
- One-off. Something unusual happened and will not happen again. Note it and move on.
- Here to stay. The plan was wrong and will stay wrong. Change the plan, or change the spending.
The monthly routine in four steps
- Get the figures ready first. All receipts are entered and all invoices are sent. Pick a fixed day for this, such as the fifth working day of the month.
- Read the table (10 minutes). Planned, actual and difference for each line. Mark the lines above your limit.
- Explain the marked lines (20 minutes). The person responsible for each line gives the reason in one sentence.
- Decide (15 minutes). Three actions at most, each with a name and a date. Then adjust the plan for the coming months.
What makes the routine fail
- Late figures. If receipts turn up six weeks later, you are talking about a month nobody remembers.
- Different names on each side. The plan says "advertising" and the bookkeeping splits it into four lines. Use the same list on both sides.
How Worknano handles this
In Worknano's finance module you take a photo of a receipt. Worknano reads the seller, the date, the amount and the tax from the photo and sorts the receipt into your cost categories. A receipt can be split across projects or cost centres and linked to a client or a deal. You set spending rules by amount, category, project or department. Each request then goes to the right person for approval, and every step is kept on record. You can export your data to QuickBooks, Xero, Sage or the format your accountant uses. Costs, their projects and the dashboards that show them use the same up-to-date records. So the actual figures are ready when the month ends.
- Finance in Worknano: receipts, approvals and invoices
- Approvals: tracked sign-offs with a full history
- Dashboards built from the same data
Create a free workspace and have this month's receipts categorised before your next review.