# What is a budget variance? > A budget variance is the gap between what you planned to spend or earn and what really happened. How to calculate it, read it and explain it. Source: https://learn.ynteractive.com/content/glossary/budget-variance · Updated 2026-10-06 · Free from Stepthrough (https://learn.ynteractive.com) [Business](https://learn.ynteractive.com/content/glossary#topic-business) · [AI glossary](https://learn.ynteractive.com/content/glossary) Quick answer A budget variance is the difference between a budgeted amount and the actual amount for the same period and line, such as travel for March. It is usually shown in dollars and as a percent of the budget. Spending less than planned, or earning more, is called favorable; the opposite is unfavorable. Last updated October 6, 2026 Updated October 6, 2026 · By [Robert Breen](https://learn.ynteractive.com/content/about) ## Why it matters for a small business A budget is only useful if someone compares it with reality. A budget versus actual report puts the two side by side, line by line, so you can see which categories ran over and which came in under. Most managers don't need every line explained, just the big or surprising ones, along with the reason behind each. Variances are questions, not verdicts. Travel may be over because a trip was booked early, which is a timing difference that will even out, or because prices went up, which will not. Clean categories make this work possible: if expenses land in the wrong category, the variance report points at the wrong problem. That is why [expense categorization](https://learn.ynteractive.com/content/glossary/expense-categorization) and review matter. ## In a real lesson: Build an AI Agent That Categorizes Business Expenses The [AI Expense Categorizer Agent lesson](https://learn.ynteractive.com/content/n8n-ai-agent-categorize-business-expenses-google-sheets) builds the raw material for a variance report. For Maple Street Bookkeeping, a made-up firm, the agent sorts each expense into one of six categories: Office Supplies, Software & Subscriptions, Meals, Travel, Utilities or Needs Review, and saves it to an **Expense Log** sheet with **Date**, **Vendor**, **Amount**, **Category** and **Note**. In the test batch, Corner Office Supply for $64.18 becomes Office Supplies, CloudLedger for $45.00 becomes Software & Subscriptions, and Harbor Street Cafe for $38.50 becomes Meals. Totaled by category over a month, those rows are the "actual" column. The lesson stops there. It doesn't build a budget or compare anything. But once you have actuals by category, a budget column next to them and one subtraction give you the variance for each line. The Needs Review category is a reminder to clear unclear items before you trust the totals. [Try this lesson free](https://learn.ynteractive.com/modules/n8n-ai-agent-finance) or [read the step-by-step guide](https://learn.ynteractive.com/content/n8n-ai-agent-categorize-business-expenses-google-sheets). ## Common confusions ### Favorable vs unfavorable Favorable means better for profit than planned: lower costs or higher revenue. It is not always good news. Spending far below budget on marketing might mean a campaign never ran. ### Budget variance vs forecast A variance looks back at a period that has ended. A [cash flow forecast](https://learn.ynteractive.com/content/glossary/cash-flow-forecast) looks ahead. Variances can improve the next forecast. ## Tips - Calculate actual minus budget the same way on every line, so signs mean the same thing. - Set a threshold for explaining variances, such as a set dollar amount or percent, and skip the small ones. - Ask AI to draft variance explanations from your notes, then check that every reason is true. ## Related terms [Cash flow forecast](https://learn.ynteractive.com/content/glossary/cash-flow-forecast) · [Gross margin](https://learn.ynteractive.com/content/glossary/gross-margin) · [Expense categorization](https://learn.ynteractive.com/content/glossary/expense-categorization) · [Closing the books](https://learn.ynteractive.com/content/glossary/closing-the-books) · [KPI (key performance indicator)](https://learn.ynteractive.com/content/glossary/kpi) ## More Business terms [Buyer persona](https://learn.ynteractive.com/content/glossary/buyer-persona) · [Call to action (CTA)](https://learn.ynteractive.com/content/glossary/call-to-action) · [Candidate experience](https://learn.ynteractive.com/content/glossary/candidate-experience) · [Candidate pipeline](https://learn.ynteractive.com/content/glossary/candidate-pipeline) ## Where you use it: free lessons - [Build an AI Agent That Categorizes Business Expenses](https://learn.ynteractive.com/content/n8n-ai-agent-categorize-business-expenses-google-sheets) (n8n, 12 min) - [AI Receipt Extractor: Receipts to Google Sheets with n8n](https://learn.ynteractive.com/content/ai-receipt-extractor-n8n-google-sheets) (n8n, 12 min) ## Prompt templates that use it [Budget request memo prompt](https://learn.ynteractive.com/content/prompts/budget-request-memo-prompt) · [Cash flow forecast assumptions prompt](https://learn.ynteractive.com/content/prompts/cash-flow-forecast-assumptions-prompt) ## Frequently asked questions **How do I calculate budget variance as a percent?** Subtract the budget from the actual, then divide by the budget. A budget of 1,000 dollars and an actual of 1,100 dollars is a 100 dollar variance, or 10 percent over. These numbers are made up. **How often should I review budget variances?** Monthly is common, after the books are closed, so the actuals are complete. [All AI glossary terms, A to Z](https://learn.ynteractive.com/content/glossary) · [Free prompt templates](https://learn.ynteractive.com/content/prompts)