Payroll came in $600 under budget. If you were looking at that line alone, you might approve a few extra shifts next month without giving it much thought. Then you get to the bottom of the report. You expected $10,000 in operating profit and finished with $1,800. Where did the other $8,200 go?
For a small business owner, that’s the point of budget vs actual analysis. It gives you a way to trace a disappointing month back to something you can act on. Sometimes a customer canceled, a supplier raised prices, or a job took longer than you quoted. Sometimes the work is still coming and the budget simply had it in the wrong month. You’d make a different decision in each case, even if the profit and loss statement looked exactly the same.
How to Read a Budget vs Actual Report
Start with a month your bookkeeper has closed. Make sure payroll has been recorded, the bank and credit card accounts have been reconciled, and the report covers the same dates and accounting basis you used for the budget. That last detail matters. If you planned sales based on when you would complete jobs but your report counts revenue when customers pay, an unpaid invoice can look like a lost sale.
Consider a service business that expected to bring in $60,000 for the month. Its budget vs actual report might look like this.
| Monthly Results | Budget | Actual | Difference |
| Service revenue | $60,000 | $52,000 | -$8,000 |
| Payroll | $24,000 | $23,400 | -$600 |
| Other operating costs | $26,000 | $26,800 | $800 |
| Operating profit | $10,000 | $1,800 | -$8,200 |
The difference column shows actual minus budget. On the revenue line, a negative number means the business earned less than planned. On the payroll line, it means the business spent less.
Look at those two lines together. You budgeted 40 cents of payroll for every dollar of sales. You actually spent 45 cents. Even so, your total operating costs were only $200 over budget because the payroll savings partly offset the extra $800 spent elsewhere. Of the $8,200 in missing profit, $8,000 came from the sales shortfall. Before spending an afternoon reviewing expense receipts, open the job schedule.
How to Analyze Business Budget Variances
Suppose the sales budget assumed 600 billable hours at $100 an hour. If your team delivered 520 hours at that rate, you can account for the entire $8,000 shortfall. Pull up the jobs you expected to complete and see which ones moved. A customer who pushed an installation into next month gives you a reason to keep the crew available. A customer who permanently reduced weekly service leaves hours you’ll need to fill.
Now suppose the team delivered all 600 hours and revenue still came to $52,000. You earned about $86.67 for each hour worked. In that case, start with the quotes and time records for a few completed jobs. Perhaps your crew made a second visit that the original quote didn’t cover. Perhaps a contract still carries last year’s rate. Either can leave you with a full calendar and less profit than you expected. Cutting shifts could make it harder to finish the very work you’re trying to make profitable.
This is where an owner often knows something the bookkeeper couldn’t pick up from the ledger. The payroll report shows six hours of overtime. You know whether those hours went toward training someone who can take over a route next month or sending an experienced employee back to fix the same problem for the third Friday in a row. That detail belongs in your monthly review.
Which Expenses Belong in Next Month’s Forecast?
One of the easier mistakes in budget variance analysis is to carry an unusual month forward as though it were typical. A $2,400 repair on a delivery van reduces this month’s profit. It doesn’t give you much reason to add $2,400 to every month left in the year. But if two other vans have similar mileage and have already needed work, it makes sense to ask the mechanic what’s coming due and put a realistic amount in the forecast.
A smaller expense can deserve more attention. If weekend coverage is costing $400 more than planned every month, that’s $4,800 over a full year. It may be money well spent if those shifts serve a profitable account. If the extra coverage became a permanent part of a contract you priced for weekdays, bring the numbers to the next renewal discussion.
Give favorable differences the same scrutiny. Before treating lower supply costs as savings, check whether a vendor invoice is still waiting for approval. Spending those “savings” now can leave you covering two bills next month.
A Late Job Can Affect Two Payrolls
Say a customer moves a project from February to March. You confirm the new date and move the expected sales into March. That fixes the revenue forecast. It still leaves a question about the bank account.
If the job finishes March 28 and the customer pays 30 days after the final invoice, most of the money may arrive in late April. Depending on your pay schedule, you could cover two payrolls before you collect. Put the expected payment date in a weekly cash forecast alongside wages, vendor bills and loan payments. You can then decide whether to delay a purchase, request a deposit under the contract, or follow up on older invoices before cash gets tight.
Keep your original budget when you make these changes. It gives you a record of what you assumed when you set prices, hired people or committed to equipment. Use the updated forecast to decide what you can afford now.
There’s a tax-planning reason to keep both, too. If you make individual estimated tax payments on business income and the revised forecast shows a meaningful change in annual profit, give it to your tax preparer before the next installment. They can review projected taxable income, withholding and payments already made. One customer paying late may put real pressure on payroll while barely changing your expected tax for the year.
What a Monthly Budget Performance Review Should Leave You With
Ask whoever prepares your actual vs budget financial reporting to show both the current month and the year to date. February may look weak and March unusually strong because one installation moved. Looking at the two months together tells you whether the revenue caught up. Looking at the jobs themselves tells you whether the delay cost you an extra crew visit or a rush delivery along the way.
For each difference large enough to change a decision, write down what happened and who will follow up. “Revenue below plan” won’t mean much when you reopen the report six weeks later. “Customer moved the installation to March 12. Confirm the deposit before ordering materials” gives your office manager a decision they can make on Monday morning. That’s the part of financial variance analysis worth keeping, even if your entire review fits on one page.
Frequently Asked Questions
What Percentage Over Budget Should a Small Business Investigate?
A useful cutoff depends on the size of the account and how much cash you have available. A software bill rising from $40 to $80 is 100% over budget, but the immediate difference is $40. A 3% shortfall on $100,000 of monthly sales is $3,000. Review the dollar impact alongside the percentage, and pay attention to smaller differences that repeat. If a variance could change a hiring, pricing or payment decision, it deserves a closer look.
Why Is My Business Under Budget but Still Short on Cash?
Your operating budget usually tracks income and expenses. Your bank balance also reflects when customers pay and where else cash goes. On accrual-basis books, an unpaid invoice can increase reported profit before the money reaches your account. Loan principal payments and owner draws can reduce cash without appearing as operating expenses. If profit looks healthy and cash feels tight, put your unpaid customer invoices and upcoming payments beside the profit and loss statement.
Can I Use Last Year’s Numbers if I Don’t Have a Formal Budget?
Yes. Comparing this month with the same month last year gives you a starting point, especially if your business is seasonal. Adjust for changes you already know about, such as a rent increase, a new employee or a customer you no longer serve. You can use those figures to build a simple monthly budget for revenue, payroll and your largest expenses, then add detail where it would help you make a decision.
How Often Should I Compare My Budget With Actual Results?
For most small businesses, monthly is a practical rhythm because the books can be closed and the details are still fresh. If cash is tight or labor commitments change quickly, review expected collections and the next few payrolls weekly. You can act on a delayed payment or an empty week on the schedule while your bookkeeper finishes the formal month-end report.
If your reports show a profit but you’re still moving bills around to cover payroll, bring your latest budget, profit and loss statement, and list of unpaid invoices to Prudent Accountants. Our Minneapolis team can help you trace where the gap started and decide what to change before the next pay run. Call 612-605-3178 or contact Prudent Accountants.
0 Comments