Budget vs Actual Report: How to Read It, Calculate Variance and Write the Commentary
The report is the easy part. The variance column tells you which lines moved, and the commentary is the sentence the client or owner actually reads. Most of the close time goes into that sentence.
A budget vs actual report compares what you planned to spend or earn with what happened, line by line, and shows the difference. The formula is simple: variance = actual − budget. The hard part is writing a sentence for each material line that says what caused it, because the client or owner will read that sentence, not the table. Below is a worked example and a method for writing the commentary without retyping it every month.
A worked example
The figures are illustrative: one month for a small services business.
| Line | Budget | Actual | Variance | Variance % |
|---|---|---|---|---|
| Revenue: retainers | 48,000 | 48,000 | 0 | 0.0% |
| Revenue: project work | 12,000 | 15,500 | +3,500 | +29.2% |
| Contractors | 9,000 | 10,200 | +1,200 | +13.3% |
| Marketing | 8,000 | 9,450 | +1,450 | +18.1% |
| Software | 2,100 | 2,100 | 0 | 0.0% |
For revenue, a positive variance is favorable. For expenses, a positive variance is unfavorable. The columns are the same, so label the convention once at the top.
Sort by dollars, not by percentage
The contractor line is 13% over, and the software line is exactly on budget. A 13% overrun on $9,000 is $1,200 of cash, and that matters more than a 40% overrun on a $300 subscription. Sort by the absolute dollar variance so the large lines lead, and show the percentage beside them for context.
Writing the commentary
One sentence per material line, in this order: what happened, the amount, whether it is timing or a real change. For the example:
- Project work, +$3,500 (+29%). Two projects closed early in the month that were scheduled for next quarter. Timing: expect the budgeted amount to come in lower next month.
- Contractors, +$1,200 (+13%). The design contractor was retained for a second round of the same project. Real: plan for it to continue until the project closes.
- Marketing, +$1,450 (+18%). A paid campaign ran two weeks longer than planned to finish the test. Timing, but the spend is committed for next month too.
Retainers and software are on budget, so they get no line. A reader can see the total is over budget and why, in about thirty seconds.
Stop retyping the same paragraph
The slow part of a month-end close is usually not the variance. It is rewriting the same paragraph for each client, and checking that the figure quoted in the sentence matches the table. Two habits help. Keep a short list of standing explanations, such as "retainer, unchanged" or "timing, reverses next month", and reuse them. And tie the figures in the commentary to the report itself, so when the actuals change after a late invoice, the sentence changes with them.
Connecting the report to the commentary
If the actuals come from QuickBooks, the QuickBooks profit and loss analysis covers the source report. Quiriz reads the connected books, asks for the variance by line against the budget you give it, and returns the lines above your threshold. In a Word report, the Quiriz Word add-in can keep the figures in the commentary live, so a corrected number updates the sentence that quotes it. The add-in is at Word on Microsoft marketplace.
What it does not decide. The cause of a variance is a fact about the business. Quiriz can show that marketing ran over, and by how much. It cannot know whether the campaign was extended on purpose. Put that explanation in the commentary yourself.
Variance by line, not a blank page
Upload a budget and an actuals export, ask for the variance by line, and get the lines above your threshold. Free to start.
Try Quiriz free →