Create a Budget vs Actual Report

Why most budgets stop being used by March

Most small and mid-sized businesses make a budget once a year in a spreadsheet. It takes days, because someone has to export last year's numbers, paste them into twelve monthly columns, add an uplift and argue about each line. By the time it is agreed, it is a static file on a shared drive.

Then the comparison never happens. Every month someone has to export the profit and loss, match the accounts to the budget rows by hand and work out the variances. When the chart of accounts changes or a new expense account appears, the rows stop lining up. After two or three months the budget file is no longer opened, and overspending is found at year end instead of in the month it happened.

A budget gets used when it lives next to the ledger. If the plan is stored against the same accounts the business posts to, the comparison is automatic: every posted sale, bill, payroll run and voucher updates the actual column, and the variance is there whenever someone looks.

Why this happens

The budget is a spreadsheet that has to be matched to the ledger by hand.
Last year's actuals are retyped instead of copied.
The agreed numbers are edited later with no record of the change.
Variances are calculated at year end instead of monthly.
Nobody can see which costs are already over budget this quarter.

Biznsbook addresses this through twelve-month P&L budgets, prefill from last year's actuals, budget approval, Budget vs Actual variances in the Accounting module, built on the same ledger that every posted sale, bill, payroll run and voucher updates.

Financial reporting rarely fails because the arithmetic is hard. It fails because the numbers are rebuilt by hand every month and nobody trusts the copy. Reading the ledger directly removes that step.

Step-by-step: Create a Budget vs Actual Report That Gets Used

Written for owners, bookkeepers and finance managers in small and mid-sized businesses using Biznsbook Accounting, where sales, purchases, inventory and payroll post to the same ledger the reports read.

Create the budget. Open Accounting → Financial reporting → Budgets and choose New budget. Give it a name, pick the first month and, if cost centers are turned on, choose the whole company or one cost center.
Prefill from last year. Tick Start from last year's actuals and set an uplift such as 5%. Every income and expense account with activity gets the same calendar month from one year earlier, adjusted by the uplift.
Adjust the months. On the budget grid, change any month. Type an annual figure in an account's Total column and press Enter to spread it evenly across the twelve months. Enter amounts the way the income statement shows them: income and costs positive, returns and discounts negative.
Check the planned profit. The tiles above the grid show planned revenue, planned costs, planned profit and margin as you type, so you can see the effect of each change before saving.
Approve the budget. Approve locks the figures, so the plan you report against cannot change quietly. Move it back to draft to revise it; archive old budgets when the year is over.
Compare with actuals. Open Budget vs actual, pick the budget and a month range or a quarter. Each account shows the posted actual, the budget, the variance and the percent of budget used, with cost overruns in red.
Investigate and export. Click any account to open its general ledger for the same months and see the entries behind the number. Export the report to Excel for the management pack.

Review results after the first full monthly cycle. Adjust roles, mappings, or approvals where the same exception repeats.

Inside Biznsbook, every financial report has a short "How this is built" note at the bottom and the Accounting guide (Accounting → Accounting guide) walks through each screen. This article focuses on the finance process behind those screens.

Common mistakes to avoid

Mistake 1: The budget is a spreadsheet that has to be matched to the ledger by hand. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 2: Last year's actuals are retyped instead of copied. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 3: The agreed numbers are edited later with no record of the change. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 4: Variances are calculated at year end instead of monthly. Repeating this each month usually shows up first in a management pack nobody trusts.
Mistake 5: Nobody can see which costs are already over budget this quarter. Repeating this each month usually shows up first in a management pack nobody trusts.

Each of these turns a monthly review into an argument about whose spreadsheet is right. Report from the ledger instead.

Best practices that hold up as you scale

Create the budget — Open Accounting → Financial reporting → Budgets and choose New budget.
Prefill from last year — Tick Start from last year's actuals and set an uplift such as 5%.
Adjust the months — On the budget grid, change any month.
Check the planned profit — The tiles above the grid show planned revenue, planned costs, planned profit and margin as you type, so you can see the effect of each change before saving.
Approve the budget — Approve locks the figures, so the plan you report against cannot change quietly.

Use the same report, the same dates and the same order every month. Consistency is what turns numbers into a trend people trust.

How Biznsbook supports this workflow

twelve-month P&L budgets is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

prefill from last year's actuals is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

budget approval is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

Budget vs Actual variances is part of Biznsbook Accounting and reads the posted ledger directly, so the numbers match the trial balance and change the moment a document is posted. Every amount on the report can be opened in the general ledger to see the entries behind it.

Access is permission-based: viewing reports needs View financial reports, and creating, approving or archiving budgets needs Manage budgets. Company admins see everything.

Suggested implementation timeline

Week 1: Check account sub types and account mapping so cost of sales, other income and expenses, cash, receivables and payables are classified correctly.
Week 2: Set up twelve-month P&L budgets and run the report for last month alongside your current spreadsheet.
Week 3: Agree with the owner or finance manager which lines and ratios go into the monthly pack.
Month 2: Run the monthly review from Biznsbook only and retire the spreadsheet copy.
Ongoing: Monthly review using a monthly budget review in fifteen minutes.

Metrics to track monthly

Net profit and margin against budget, year to date
Number of cost lines over budget this quarter
Gross margin month by month
Days sales outstanding and cash runway

Start with three metrics; trend direction matters more than a single point-in-time snapshot.

Spreadsheets vs Biznsbook Accounting

Compare a typical export-and-spreadsheet process with Biznsbook twelve-month P&L budgets and the related Accounting reports.

Capability	Manual / Spreadsheet	Biznsbook
Building the budget	❌ Export last year, paste into 12 columns	✅ Prefill from last year's actuals with an uplift
Matching accounts	❌ Rows matched to the ledger by hand	✅ Budget stored on the same ledger accounts
Agreed figures	❌ Edited in the file with no trace	✅ Approval locks the budget
Actuals	❌ Monthly export and reconciliation	✅ Posted documents update the actual column
Variances	❌ Formulas that break when accounts change	✅ Variance and percent used per account
Finding the cause	❌ Search the ledger separately	✅ Click through to the general ledger

A monthly budget review in fifteen minutes

After the month's postings are in, open Budget vs actual for the year to date. Start with the net profit line, then look at the four or five red cost lines with the biggest variance and click into each one to see what drove it. Note one action per overrun, such as a supplier price change or an unplanned repair, and check the same lines next month. Revise and re-approve the budget only when the business plan genuinely changes, not to make a variance disappear.

Put the routine in your month-end checklist so it happens after every close, not only when a question comes up.

Frequently asked questions

Which accounts can a budget hold?

Income and expense accounts: revenue, cost of sales, operating expenses, other income and other expenses. Budgets in Biznsbook are profit and loss budgets; balance sheet and cash budgets are not part of this feature.

Can I budget for one branch or department?

Yes, when cost centers are turned on in Accounting settings. Choose the cost center when you create the budget, and Budget vs Actual compares it only with postings tagged to that cost center.

What does prefill from last year do?

It copies each income and expense account's actual amount for the same calendar month one year earlier into the new budget, multiplied by the uplift you choose. You can then change any month before approving.

Can I change an approved budget?

Not while it is approved. Move it back to draft, make the change and approve it again. The approval date and approver are shown on the budget.

Does a budget block spending?

No. A GL budget is planning data only: it never posts to the ledger and never stops a transaction. Expense and Procurement have their own spend budgets for that.

How is a variance marked good or bad?

For income, actual above budget is favourable. For costs, actual below budget is favourable. Accounts with actuals but no budget show as unbudgeted.

How this differs by industry

Retail

Store owners budget sales and staff costs by month around their seasonal peaks, then check each month whether wages and rent stayed inside the plan while sales moved.

Wholesale & distribution

Distributors prefill the year from last year's sales and cost of sales, add the agreed price increase as the uplift, and watch gross margin against plan every month.

Manufacturing

Plants budget materials, labour and overheads per cost center, so the production manager sees their own line's spend against plan rather than the whole company's.