Budgets versus actuals in Zoho Books: what the report shows and who can use it
Budgets versus actuals in Zoho Books is a report that sets the targets you entered against what your ledger recorded, period by period. It shows where spending drifts. To make the report useful, budget against a tidy chart of accounts and tag budgets by department or project. Set the budget period to monthly. The feature is available on the Premium, Elite and Ultimate plans.
Zoho's own help page defines the three terms you need. A budget is a target a business sets to forecast how it will perform, either by increasing revenue or by decreasing expenses. Actuals are the business's real performance, which is prone to unprecedented events. Budget variance is the process of comparing the projected budget against that actual performance.
The variance report can only be as clear as the structure underneath it. A budget entered against vague accounts, with no tags, gives you one large number that is over or under. Nobody can act on that number. A budget built on accounts that match how you manage the business shows you which line moved and which team owns it.
This guide covers the setup in the order that matters: accounts first, then reporting tags, then the budget itself, then reading the report. It ends with the point where Zoho Analytics is the better tool. If you are still choosing a plan, start with our overview of Zoho Books for UK businesses.
Chart of accounts structure decides how detailed a Zoho Books budget can be
A Zoho Books budget is built account by account. Your chart of accounts therefore sets the finest level of detail the variance report can show. The chart of accounts is the list of income, expense, asset, liability and equity accounts your bookkeeping posts to. By default you budget income and expense accounts. You can also tick Include Assets, Liability, and Equity Accounts in Budget if you want balance sheet lines in the budget too.
Split an account only where a difference would change a decision. If all marketing spend posts to one general expense account, the report shows one marketing line. If you would act differently on paid advertising and on events, those deserve separate accounts. If you would not, keep them together and spare your bookkeeper the extra coding.
Balance sheet budgets carry one extra check. When total assets in a budget do not equal total liabilities plus equity, Zoho Books adds an equity account. That account is called Budget Mismatch Account, and it keeps the two sides equal. If that account appears in your budget, the balance sheet figures you entered do not agree with each other. Correct the figures rather than leave the mismatch in place.
At Svennis, we review the chart of accounts with the finance lead before anyone types a budget figure. A budget built on accounts that are about to be merged or renamed has to be rebuilt. The team then loses trust in the first report they see.
Reporting tags for departments and projects in a Zoho Books budget
Reporting tags let a Zoho Books budget follow a department or a project instead of the whole company. A reporting tag is a label, such as Department or Project, that you attach to transactions so reports can be cut by it. Zoho's help page confirms that you can associate reporting tags with your budgets as well.
Tags solve a problem that accounts alone cannot. Your Sales team and your Operations team may both spend on travel. Creating separate travel accounts for every team bloats the chart of accounts. One travel account plus a Department tag keeps the chart lean and still tells you which team overspent.
Decide the tag values before you budget
Pick one dimension for your first budget, either departments or projects, and fix the list of values. Use the names people already say in meetings. A short list that everyone uses beats a long list that half the team ignores.
Make tagging part of entering every bill
A tagged budget compares only against tagged transactions. A bill that nobody tagged cannot be counted against the department it belongs to, so that department looks under budget when it is not. Make the tag part of the routine for entering bills, expenses and invoices. Check untagged transactions before you run the report each month.
Setting up a monthly budget in Zoho Books, step by step
Setting up a monthly budget in Zoho Books takes a handful of choices, and each one shapes the variance report you will read later. The steps below follow the order in the Zoho Books help page on budgets.
The setup runs in this order:
- Create a new budget and give it a clear name. Include the year and the scope, so a list of budgets reads plainly.
- Choose the budget period. Zoho Books offers monthly, quarterly, half-yearly or yearly. Choose monthly if you want to see drift early.
- Select the accounts. Pick the income and expense accounts you want to track. Tick Include Assets, Liability, and Equity Accounts in Budget only if you also plan balance sheet figures.
- Associate a reporting tag if the budget belongs to one department or project.
- Enter the amounts. Type them, pre-fill them from previous years' actuals, or auto-fill them. The next section explains each option.
- Save and run the budget versus actuals report.
A monthly period costs you nothing in flexibility. Zoho Books lets you run reports on budget periods other than the one you set when you created the budget. A monthly budget can still be read as quarterly, half-yearly or yearly figures for a board meeting.
Once saved, Zoho Books uses the budget to generate Profit and Loss, Balance Sheet and Cash Flow Statement reports, so you can forecast your company's finances from the same figures.
Filling budget amounts in Zoho Books: manual entry, prior-year actuals or auto-fill
Zoho Books gives you three ways to fill budget amounts: enter them manually, pre-fill them based on previous years' actuals, or auto-fill accounts. The right choice depends on how much history you have and how much you expect to change.
Manual entry
Manual entry suits a new business with no history, or a line that will behave differently from last year. A new hire or a new office lease are good examples. Manual entry is slow for long account lists, so keep it for the lines where judgement matters.
Pre-fill from previous years' actuals
Pre-filling copies last year's pattern into the budget, including seasonal peaks and quiet months. Pre-filling is the fastest starting point when last year was a normal year. If last year contained a one-off, such as a large repair, edit that month after the pre-fill.
Auto-fill
Auto-fill spreads an amount across the periods using one of three rules:
- Apply a fixed amount for each period, which suits rent or a retainer.
- Adjust by an amount for each period, which suits a cost that climbs steadily.
- Adjust by a percentage for each period, which suits a revenue line you expect to grow.
Most budgets mix all three methods. Pre-fill the bulk, auto-fill the fixed costs, then type over the few lines where you know something last year's figures cannot.
Worked example: a monthly Zoho Books budget for one department
This worked example follows an illustrative design agency with two departments, Studio and Sales, through a monthly budget for its Studio team. The agency already uses a Department reporting tag on its bills and invoices. The settings named below are the ones on the Zoho Books help page.
The finance manager creates a budget named "Studio operating budget" and sets the budget period to monthly. She selects the income accounts for design fees and the expense accounts for freelance costs, software and travel. She leaves Include Assets, Liability, and Equity Accounts in Budget unticked, because the Studio team does not manage balance sheet items. She then associates the Department tag with the value Studio.
For the amounts, she uses Pre-fill based on previous years' actuals for design fees and travel. Software is a flat subscription, so she uses auto-fill with Apply fixed amount for each period. Freelance costs are expected to rise through the year, so she uses Adjust by percentage for each period with the uplift the Studio lead agreed.
At each month end she runs the budget versus actuals report from the first to the last day of the month, on an accrual basis. Freelance costs come in over budget in the second month. Because the line is tagged, she knows the overspend sits with Studio, not Sales. She exports the budget summary to XLSX for the monthly management meeting.
The same budget, read quarterly, gives the directors their quarterly view without a second budget.
Reading the budget versus actuals report in Zoho Books without misreading it
The budget versus actuals report in Zoho Books is easy to misread on three points: dates, accounting basis and VAT. Each one can make a healthy month look wrong.
Run the report on whole months
The Budget column covers whole months from the From date to the To date. The Actuals column uses the exact custom dates you set. Run the report from 10 March to 9 April and the budget counts all of March and April, while actuals count only the days in between. Always run the report on month boundaries.
Choose accrual or cash deliberately
You can run the report on an accrual or a cash basis. Accrual counts income and expenses when you invoice or receive a bill. Cash counts them when money moves. Pick the basis your budget was written on, and keep it the same each month.
Budget net of VAT
A user on Zoho's community forum reported that the report showed actual totals without VAT, so they looked wrong by 19% against expectations. That user entered all line items as tax-exclusive, with tax calculated on the sub-total. The safe reading is that actuals in the report are net figures. Write your budget amounts net of VAT too, so you compare like with like.
The report also exports. You can export the budget summary as PDF, XLS or XLSX, and to Zoho Sheet.
Budget settings checklist for a useful Zoho Books variance report
The table below lists each budget setting in Zoho Books, the options the product offers, and the choice that usually gives the most useful variance report. Use it as a checklist before you save a budget.
| Setting | Options in Zoho Books | Choice for a useful variance report |
|---|---|---|
| Budget period | Monthly, quarterly, half-yearly or yearly | Monthly, then read it quarterly or yearly when needed |
| Accounts | Income and expense; optionally assets, liabilities and equity | Income and expense first; add balance sheet accounts only if you plan them |
| Reporting tags | Associate tags with the budget | One dimension, departments or projects, with a short fixed list |
| Filling amounts | Manual, pre-fill from previous years' actuals, auto-fill | Pre-fill the bulk, auto-fill fixed costs, type over known changes |
| Auto-fill rule | Fixed amount, adjust by amount, adjust by percentage | Match the rule to how the cost or income behaves |
| Report basis | Accrual or cash | The basis the budget was written on, every month |
| Report dates | Budget uses whole months; actuals use exact dates | First to last day of a month or quarter |
If the Budget Mismatch Account appears after saving, go back to the balance sheet figures before you share the report.
What budgets versus actuals in Zoho Books means for a UK company
For a UK company, budgets versus actuals in Zoho Books turns the bookkeeping you already do into monthly management information. Zoho publishes the budgets help page on its UK site, and the feature works on the Premium, Elite and Ultimate plans. If you are on a lower plan, check the plan before you plan the budget.
VAT is the point UK teams should settle first. Your VAT return and your management figures answer different questions. The variance report compares net amounts, so budget net of VAT and leave VAT to the return process. Mixing gross budget figures with net actuals makes every month look underspent.
The cash or accrual choice also matters for a UK owner-managed business. Many directors think about the bank balance, while their accountant thinks in accruals. Agree one basis for the management report and say which one in the pack you send round. The report runs on either.
The exports help with the people outside your finance team. A PDF suits directors who read on a phone. An XLSX file suits an external accountant who wants to add commentary. If you want help beyond the first setup, our guide to Zoho Books partner services explains what ongoing support usually covers.
When Zoho Analytics should take over from Zoho Books budgets
Zoho Analytics should take over when your budget question needs data that does not live in the Zoho Books ledger. Zoho Books budgets compare targets with posted accounts, optionally cut by a reporting tag. That covers most departmental cost control. It stops covering the need once the targets sit at a level the ledger does not hold.
A community thread shows the boundary. A user named Kerri needed a management report tracking total sales per division against total budget per quarter. She had entered invoiced amounts by client into a table but could not find a way to enter a budget figure and compare against it. That is a reporting model problem, not a bookkeeping one.
Move to Zoho Analytics when you see these signs:
- Sales targets are set per salesperson, client or product rather than per account.
- The budget needs figures from another system, such as a CRM pipeline.
- Directors want one dashboard that blends budget, actuals and operational numbers.
- Forecasts should reflect outside factors, not only last year's pattern.
Zoho now presents Zoho Analytics as an agentic analytics platform, which brings it close to AI for reporting. Its August 2026 update added forecasts using external drivers and Deployment Management for promoting content between workspaces. Our Zoho Analytics page covers what the product does for UK firms.
Next steps for budgets versus actuals in Zoho Books
The next step for budgets versus actuals in Zoho Books is a short audit of your structure before you build anything. Most poor variance reports come from accounts and tags, not from the budget screen.
Work through these steps in order:
- Confirm your Zoho Books plan is Premium, Elite or Ultimate.
- Review the chart of accounts and split only the accounts where a variance would change a decision.
- Choose one reporting tag dimension, departments or projects, and fix its values.
- Check that last month's bills and invoices carry the tag.
- Create one monthly budget for one department, net of VAT, using pre-fill and auto-fill.
- Run the report on whole months, on the basis you budgeted on, and review it with the budget owner.
After two or three months of reports, decide whether the questions people ask still fit the ledger. If they do not, plan the move to Zoho Analytics. If you would like someone to check the structure with you, read what a Zoho partner does and then talk to us through the Zoho Books page.