Xero → Reports → Profit and Loss → By Month → Export as Excel
Click to choose — a payroll export or even a plain-text note works, pre-fills Q1
Estimate missing months?
Your report has no actuals for .
By default each account's missing months are estimated as the average of the months that
do have data. Untick any account you don't want estimated — its missing months stay $0.
Fill in the details for full-time employees. Increase % is the salary increase over last year.
Name
Base Salary ($/yr)
Increase %
Leave Loading
Incentive
TOTAL
$0
Q2 — Casual Employees
Enter the total casual wages spend for each month of the budget year.
Month
Casual Amount ($)
FY26 Wages & Salaries (ref)
Total Casual
$0
Total All Wages (FT + Casual)
$0
Q3 — Oncost Rates
Confirm the employer oncost rates.
Item
Rate (%)
Superannuation
WorkCover
Payroll Tax
Q4 — Incentive Cap
Employees with Incentive checked in Q1 share this pool: (Cap − |FY27 Net Profit|) ÷ 10, floored at $0. Updates automatically as the budget changes.
Q5 — Additional Events
Add any additional events not already covered in the P&L. Each event adds $2,000 to the FY27 Budget for that month. External (third-party operated) → Clinics/Events (Third party operated). Internal → Events - Sponsorship/General.
Rows auto-sort chronologically.
Event Name
Month
Type
Almost there
Sign in with Google and the budget sheet will be created in your Drive.
⚠️ Please confirm these values look correct:
Yes, these values are correct — proceed
Building your budget — this takes about 30 seconds…
What gets built: FY26 Actuals · Assumptions · Wages Summary · FY27 Budget · Incentive · Budget vs Actual · CapEx Budget · Summary · Answers