Home / Blog / Budget vs Actual Report
How-to · 2026

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.

By · Published November 17, 2026 · 7 min read

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.

LineBudgetActualVarianceVariance %
Revenue: retainers48,00048,00000.0%
Revenue: project work12,00015,500+3,500+29.2%
Contractors9,00010,200+1,200+13.3%
Marketing8,0009,450+1,450+18.1%
Software2,1002,10000.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:

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.

📚 Connector reference: every dataset and metric definition behind this, and how each is calculated, is in the QuickBooks connector. All connectors.

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 →

Frequently asked questions

How do I calculate a variance on a budget vs actual report?
Subtract the budget from the actual for each line, and divide by the budget to get the percentage. For an expense, a positive variance is unfavorable. For income, a positive variance is favorable. Label the convention at the top of the report.
What counts as a material variance?
It depends on the business and the client. A common approach is a dollar threshold and a percentage threshold together, such as more than $1,000 and more than 10% of the line. Agree the thresholds with the client once, and write them on the report.
Should I explain every variance?
No. Explain the lines above your threshold and any line that changed direction from last month. A commentary that covers everything gets skimmed, and the important line is missed.
What is the difference between timing and a real variance?
Timing means the cost or revenue moved between periods, so it reverses later. A real variance means the level changed and is likely to persist. Say which it is, because the forecast depends on it.
Can the commentary be drafted from the figures?
A first draft can be, as long as someone who knows the business checks each cause. The numbers say what moved; only the business owner or the bookkeeper knows why.