How to Prepare a Budget Using Xero—Properly
A useful budget is not last year’s figures with 10% added. It is a documented plan for sales, costs, capacity and profit—entered into Xero so the business can compare expectations with reality every month.
🥕 Get Help Preparing Your Budget
The thinking comes first. Xero stores the result.
Xero’s Budget Manager is a practical place to enter monthly profit-and-loss targets and compare them with actual results. But software cannot decide how many customers you will serve, what capacity your team has or which costs will rise.
The most valuable part of budgeting happens before data entry: agreeing on assumptions, testing whether they are realistic and identifying the decisions that must follow if performance changes.
Give every important decision a financial consequence.
Set a sales target
Translate customers, jobs, appointments, products or billable hours into monthly revenue.
Protect gross margin
Understand how direct labour, materials and subcontractor costs move with sales.
Plan capacity
See when revenue growth requires another employee, contractor, vehicle or piece of equipment.
Control overhead
Make room for rent, subscriptions, insurance, marketing and other operating costs.
Set a profit target
Decide what return the business needs after delivering its products or services.
Review performance
Compare actual results with the plan and investigate material differences promptly.
You need both because profit and cash answer different questions.
Profit-and-loss budget
- Plans income earned and expenses incurred
- Usually prepared exclusive of GST
- Includes non-cash costs such as depreciation
- Measures gross profit and operating profit
- Does not show when customers will pay
Cash-flow forecast
- Plans when money reaches or leaves the bank
- Includes GST and BAS payment timing
- Includes asset purchases and loan principal
- Includes owner drawings or distributions
- Shows potential cash shortages
A profitable budget can still produce a cash crisis when customers pay slowly, stock is purchased early, equipment is paid upfront or BAS and loan payments fall in the same month.
Start with clean history and known future changes.
- Monthly profit and loss for the last 12–24 months
- Sales by product, service, location or customer type
- Gross-margin and direct-cost history
- Current payroll and employment on-costs
- Recurring contracts and subscriptions
- Insurance, registration and annual renewals
- Signed customer or supplier agreements
- Confirmed price and wage changes
- Planned hires, equipment and premises
- Known seasonal or industry patterns
- One-off costs that should not repeat
- Owner and management profit expectations
Do not build from unreconciled accounts. Duplicated income, missing supplier bills or personal spending in business accounts can turn historical errors into future targets.
From business plan to monthly Xero budget.
Define the purpose and period
Choose the financial year or rolling period, identify who will use the budget and decide which decisions it must support.
Clean and normalise historical results
Reconcile the accounts, remove duplicated or misclassified transactions and identify unusual items that should not be repeated automatically.
Build the sales assumptions
Calculate revenue from operational drivers such as customers × average sale, appointments × average fee, units × price or billable hours × rate.
Calculate direct costs and gross profit
Link materials, subcontractors, merchant fees and other direct costs to the activity that creates revenue. Check the resulting gross-margin percentage.
Budget payroll and operating overhead
Include wages, employment on-costs, rent, software, insurance, marketing, professional fees and every other operating account.
Schedule lumpy and seasonal months
Place annual renewals, campaigns, quiet periods, peak sales, shutdowns and new hires in the months in which they are expected.
Review profit, capacity and plausibility
Test whether the sales target can actually be delivered with the staff, hours, stock, equipment and customer demand assumed.
Build the separate cash-flow forecast
Add collection timing, supplier-payment timing, GST, tax, loans, asset purchases and owner drawings to identify funding pressure.
Enter or import the budget into Xero
Use Budget Manager for the approved monthly profit-and-loss figures. Keep the supporting assumptions and model outside Xero as working papers.
Review actual versus budget every month
Investigate material variances, decide what action is required and update the forecast when circumstances change.
Every number needs a reason.
Sales and other income
Start with volume and price. Separate different revenue streams when they behave differently. Allow for seasonality, customer churn, conversion rates, capacity, discounts and the start date of new work.
Cost of sales
Use a cost per unit, percentage of revenue or job-by-job estimate. Consider supplier price rises, wastage, freight, merchant fees, direct labour and subcontractor availability.
Wages and employment costs
Budget gross wages plus relevant superannuation, leave, workers compensation, payroll tax where applicable, recruitment, training and other employment costs. Allow for commencement dates and pay increases.
Fixed overheads
Use current contracts for rent, software, telecommunications, insurance and professional services. Place annual or quarterly charges in the correct months instead of dividing everything evenly.
Variable and discretionary overheads
Link costs such as travel, packaging or casual labour to activity. Give marketing, repairs, training and professional projects an approved amount and timing.
Depreciation and finance costs
Include depreciation and the interest component of finance in the profit budget where appropriate. Loan principal and asset-purchase cash belong in the cash-flow forecast, not as ordinary operating expenses.
Not every payment belongs in the Xero profit-and-loss budget.
Usually part of the P&L budget
- Sales and service income
- Cost of goods or services
- Wages and operating expenses
- Depreciation
- Interest expense
- Other income or expenses
Usually handled separately
- GST collected and paid
- BAS and income-tax payments
- Purchase price of capital assets
- Loan principal repayments
- New borrowings or owner contributions
- Owner drawings and distributions
The accounting treatment depends on the transaction and business structure. Coordinate the budget with your bookkeeper, BAS agent and tax agent rather than deciding from the bank description alone.
From sales assumptions to budgeted profit.
Assume a service business expects 1,200 jobs during the year at an average selling price of $550. Direct costs are expected to average 35% of sales.
| Budget line | Assumption | Annual budget |
|---|---|---|
| Sales | 1,200 jobs × $550 | $660,000 |
| Direct costs | 35% of sales | ($231,000) |
| Gross profit | 65% gross margin | $429,000 |
| Wages | Staffing plan | ($192,000) |
| Employment on-costs | Budget estimate | ($36,000) |
| Other overhead | Monthly and annual commitments | ($144,000) |
| Operating result before depreciation and interest | Gross profit less operating costs | $57,000 |
| Depreciation | Asset schedule estimate | ($12,000) |
| Interest | Finance schedule estimate | ($9,000) |
| Budgeted profit | Before income tax | $36,000 |
The annual totals must then be distributed across the months. If the business expects fewer jobs in January and a major campaign in March, entering the same amount every month would hide the real operating plan.
Use Budget Manager after the model has been approved.
Open Budget Manager
From Xero’s Accounting or Reports area, open Budget Manager. Menu wording and access can vary with the organisation, user permissions and product changes, so use Xero’s report search if needed.
Select or create the budget
Choose the overall budget or create the available budget type required for the organisation. Confirm its name, start month and period before entering figures.
Enter monthly amounts
Enter each approved income and expense figure against the correct chart-of-accounts line. Use the available fill or adjustment tools carefully, then replace flat amounts where seasonality applies.
Save and inspect the total
Confirm monthly and annual totals against the approved model. Check gross profit, payroll, overhead and final profit rather than assuming a successful save means the figures are correct.
Run the comparison report
Use Xero’s budget comparison or variance reporting to compare actual results with the selected budget and reporting period.
Xero changes features and navigation from time to time. For the current product instructions, refer to Xero Central’s Create a budget guide.
A spreadsheet is often faster for detailed monthly modelling.
For a large chart of accounts or seasonal budget, use Xero’s budget export or import template rather than building a CSV from memory.
Export the correct template
Start from the organisation’s own Budget Manager so account codes, names, columns and periods align with the Xero file.
Keep the required structure
Do not casually rename headings, delete required identifiers or change the date-column structure. Work in a copy and preserve an untouched template.
Use formulas in the working workbook
Calculate volume, price, cost percentages and timing in a controlled spreadsheet. Before import, paste or export the final values into the Xero-compatible template.
Validate after importing
Compare annual totals and several monthly account lines with the approved model. An imported file can be structurally accepted while still containing wrong figures or signs.
Use Xero Central’s current Import a budget instructions when preparing the file.
Use separate budgets only when the underlying tracking is reliable.
Where the Xero organisation and subscription support the required budget and tracking options, a business may compare areas such as locations, divisions or departments. This can be valuable—but only if transactions are consistently assigned to the right tracking categories.
- Define each category clearly
- Avoid overlapping category meanings
- Train every person coding transactions
- Review uncategorised transactions
- Allocate shared costs using a documented method
- Reconcile totals to the overall budget
- Keep the category list manageable
- Retire categories carefully
Do not create a detailed departmental budget when the actual transactions are not coded with the same discipline. The variance report will look precise while comparing incompatible data.
A budget becomes useful only after actual results arrive.
1. Finalise the month
Reconcile banks, enter supplier bills, review payroll, post known adjustments and resolve material suspense items.
2. Run actual versus budget
Use the correct period, basis, budget and tracking option. Compare month and year-to-date results.
3. Set a materiality threshold
Investigate variances large enough to matter rather than spending hours explaining every small difference.
4. Separate timing from performance
Ask whether the variance will reverse next month or reflects a genuine change in sales, price, cost or activity.
5. Assign an action
Record what will change, who owns the action and when it will be reviewed.
6. Update the forecast—not history
Keep the approved budget as the benchmark. Create or maintain a forecast that reflects new information.
The same mathematical difference can mean opposite things.
A sales result above budget is usually favourable. An expense above budget is usually unfavourable. That is why variance reports must be interpreted by account type and business context.
Questions for revenue variances
- Was volume, price or sales mix different?
- Was work completed but not invoiced?
- Did timing move revenue between months?
- Was the budget beyond available capacity?
- Is a customer or service line changing?
Questions for cost variances
- Did unit costs or quantities change?
- Was an annual cost budgeted monthly?
- Is the cost one-off or recurring?
- Was it coded to the correct account?
- Did higher spending create higher revenue?
Do not rewrite the target every time reality changes.
The approved budget records the plan agreed at the beginning of the period. A forecast updates the expected outcome using current information. Keeping both allows the business to see the original target and the latest likely result.
Base case
The most likely result using reasonable assumptions.
Downside case
Lower sales, slower collections or higher costs—plus the actions needed to protect cash.
Upside case
Higher demand and the staff, stock or equipment required to deliver it.
Most bad budgets fail before they reach Xero.
Flat monthly figures
Every month is identical even though the business is seasonal.
Revenue without capacity
Sales grow but no additional labour, stock or equipment is included.
GST mixed into profit
GST-inclusive bank amounts are compared with GST-exclusive income and expenses.
Missing employment costs
Wages are budgeted without adequate on-costs or planned increases.
Cash items treated as expenses
Loan principal, assets or drawings are placed in the P&L model.
No monthly review
The budget is entered once and ignored until the year has finished.
Preparing a budget in Xero FAQs
Does Xero prepare the budget for me?🐰
Xero stores budget figures and compares them with actual results. The business assumptions, calculations, scenarios and decisions still need to be developed by the business and its advisers.
Should my Xero budget include GST?🐰
A profit-and-loss budget is generally prepared exclusive of GST where the related income and expenses are reported that way. GST payment and refund timing belongs in the cash-flow forecast. Confirm the approach for your file.
Can I use last year’s actual figures as the new budget?🐰
They are a useful starting point, not a finished budget. Adjust for one-off items, price changes, staffing, capacity, contracts, seasonality and the business’s current plan.
Can I import a budget into Xero from Excel?🐰
Use Xero’s supported CSV budget template and current import process. Keep your detailed formulas in the working spreadsheet, then transfer final values into the required template and verify the imported totals.
Should loan repayments appear in the Xero budget?🐰
The interest component may be a P&L expense. Loan principal is generally a balance-sheet and cash-flow item, so it should be planned in the cash-flow forecast rather than treated as an operating expense.
Where do asset purchases go?🐰
The asset purchase is generally planned as capital expenditure and cash flow, while depreciation may appear in the P&L budget. Obtain advice on the correct treatment for your circumstances.
How often should I review actual versus budget?🐰
Monthly is suitable for many small businesses. A business with tight cash, rapid growth or volatile trading may need weekly operational and cash monitoring as well.
Should I change the budget when sales fall?🐰
Keep the approved budget as the original benchmark. Update a separate forecast with the new expectation and record the actions being taken.
Why does the Xero variance report look wrong?🐰
Check the report period, accounting basis, selected budget, signs, chart-of-accounts mapping, tracking options and whether the month’s bookkeeping is complete.
Can a bookkeeper help prepare the budget?🐰
Yes. A bookkeeper can help clean the historical data, assemble assumptions, structure the monthly model, enter it into Xero and maintain the actual-versus-budget review. Strategic, finance or tax matters may also require the appropriate accountant or adviser.
Build a budget you can explain, measure and act on.
My Great Bookkeeper can help clean the historical figures, build realistic monthly assumptions, enter or import the approved budget into Xero and establish a practical variance-review process.
🥕 Book a Free Bookkeeping Call