Once you have finalised the commission pay run, Step 4 is where you export the data, generate the final salesperson invoices, download the final Agent Expense Report, and send commission statements if you did not send them while the pay run was still in draft. It also shows the Agent Payment Summary, the same one you saw in the previous step.
In Australia and New Zealand, every salesperson invoice also ends with an earnings, expenses and year-to-date summary, so agents can see what they have earned this financial year without asking your finance team.
How Do I Export the Data?
You have two options for exporting:
- Download CSV - downloads a CSV file you can open in Excel, or upload to payroll software other than Xero.
- Export to Xero - sends the data directly to Xero, covered below.
How Do I Export to Xero?
Once you have set up the Xero integration, you can export your data to Xero. This sends the commission for the attached agents and creates a draft pay run in Xero.
- Click Export to Xero.
- Verify the amount.
- Click Next.
- If you have not authorised in the last 30 minutes, see Agent Ledgers and Xero Integration: Authorising Xero Integration.
- Select which pay period you want to run this for, Scheduled or Unscheduled.
- Click Export.
❗ Please Note: You cannot use the export to Xero function if you already have a draft pay run sitting in Xero.
Invoices post to Xero with the GST treatment already applied, based on whether each agent is registered for GST. You do not need to correct the GST in Xero afterwards.
How Do I Generate the Final Salesperson Invoices?
Once the commission pay run is finalised, you can generate each agent's final salesperson invoice from Step 4.
- Click Generate Invoice in the row of buttons on this step.
- On Step 1 of the Generate Salesperson Invoice window, the agents on this pay run are already selected. Check the list.
- Move to Step 2 Preview & Generate to see each salesperson invoice exactly as the agent receives it.
You can also generate draft invoices before finalising, in Commissions Pay Run: Step 3 - Review & Finalise.
What Is on the Salesperson Invoice?
Each finalised salesperson invoice carries the agent's tax details and a summary of where they are up to, so the agent can see how the figure was reached without asking.
- GST - included or excluded based on whether the agent is registered for GST.
- GST/ABN number - shown on the invoice when a number has been stored against the agent.
- Withholding tax - applied automatically when a rate is set on the agent's ledger.
- Earnings, expenses and year-to-date summary - two tables at the foot of the invoice, explained in the sections below.
Where these are set up is covered in Agent Ledgers: Introduction to Agent Ledgers.
❗ Please Note: Automatic GST and withholding tax are available to Australian and New Zealand accounts using the Xero integration. They are not available in the United Kingdom.
What Is the Year-to-Date Summary on a Salesperson Invoice?
Every salesperson invoice for an Australian or New Zealand agency ends with an earnings, expenses and year-to-date summary. It shows two tables side by side:
- Year To Date - the agent's earnings and expenses from the start of the financial year up to this invoice's pay run, for example Year To Date (1 Jul 2026 - 28 Oct 2026).
- This Invoice - the same breakdown for this invoice on its own.
The summary is on every Australian and New Zealand account, on both draft and final salesperson invoices. There is nothing to set up or switch on, and it does not change the invoice totals, the balance due, or the amount paid to the agent.
What Do the Rows on the Year-to-Date Summary Mean?
Both the Year To Date and This Invoice tables on the salesperson invoice have an Earnings column and an Expenses column, with these rows:
| Row | Earnings | Expenses |
|---|---|---|
| Exc. GST | Earnings before GST | Expenses before GST |
| Inc. GST | Earnings including GST | Expenses including GST |
| GST | GST on earnings | GST on expenses |
| W/H Tax | Withholding tax on earnings | Not shown |
The W/H Tax row always shows. It is $0.00 when the agent has no withholding tax rate, which is common for Australian agents. Withholding tax follows the method your agency already uses, so there is nothing new to configure.
Which Dates Does Year to Date Cover?
The Year To Date table on a salesperson invoice runs from the start of the agent's financial year to the date the invoice's pay run was completed.
- Australia: the year starts on 1 July.
- New Zealand: the year starts on 1 April.
Only invoices from completed (paid) commission pay runs count towards Year To Date. The dates covered are shown in the table heading on the invoice.
❗ Please Note: Agencies cannot change the financial year start date for the Year To Date summary. If your agency uses a different financial year, contact Rex Support.
Why Doesn't Year to Date Include the Draft Invoice?
When you generate a draft salesperson invoice in Step 3 - Review & Finalise, the Year To Date table only counts completed pay runs, so the draft's own figures are not included yet. The This Invoice table still shows the draft's figures.
Once the pay run is finalised, the final salesperson invoice generated from Step 4 includes that invoice's figures in Year To Date.
What Happens When I Re-Send or Download an Older Salesperson Invoice?
Salesperson invoices are rebuilt each time they are viewed, re-sent or downloaded. This means an older invoice from before the summary was added now shows the earnings, expenses and year-to-date summary too.
- The Year To Date table ends at that invoice's own pay run date, not today's date.
- The totals and balance due on the older invoice do not change.
To open an older invoice, open the finished commission pay run and click Generate Invoice.
How Do I Download the Agent Expense Report?
Once the pay run is finalised, you can download the final Agent Expense Report. It's a spreadsheet of what each salesperson was charged in this pay run, split by expense type, with the totals and a general ledger summary already worked out.
- Click Agent Expense Report. It's the last button in the row of buttons on this step.
- The spreadsheet downloads straight away.
If you downloaded a draft copy in Commissions Pay Run: Step 3 - Review & Finalise, this final copy won't have (DRAFT) in its title. For more on what the report shows, see Commissions Pay Run: Agent Expense Report.
❗ Please Note: The Agent Expense Report is available in Australia and New Zealand only.
How Do I Send Commission Statements From Here?
If you did not send the commission statements in Step 3 - Review & Finalise, or you want to send them again, you can do that from this screen. At the very bottom you can add a note, which is included on every agent's commission statement.
- Click Generate Commission Statements. This opens a separate three-step wizard, with its own steps that are not the pay run steps.
- On the wizard's first step, add or remove agents as needed, then click Continue to step 2.
- The wizard's second step gives you a preview of what will be sent to each agent.
- Move between agents using the arrows in the top right corner, or click Jump To and choose an agent
- Click Download Statement if you would like a PDF version
- Click Continue to Step 3.
- Click Send Statements when you are ready to send.
❓ Frequently Asked Questions
Why can I not export to Xero?
The most common reason is that you already have a draft pay run sitting in Xero. Clear or complete that one first. If you have not authorised Xero in the last 30 minutes you will also be asked to re-authorise.
Can I export to something other than Xero?
Yes. Download CSV gives you a file you can open in Excel or upload to other payroll software.
I already sent the commission statements in Step 3. Can I send them again?
Yes. You can generate and send statements again from this screen.
What is the difference between Scheduled and Unscheduled pay periods?
This is the Xero pay period the commission is exported into. Choose the one that matches how your agency runs payroll in Xero.
The GST on an invoice in Xero looks wrong. Where do I fix it?
Fix it at the source rather than in Xero. The GST treatment comes from whether the agent is marked as registered for GST on their user record, so correct that and it will be right on the next pay run.
Can I still change the pay run at this point?
No. The pay run was finalised in Step 3, and finalising cannot be reversed.
Where can I see what each agent was charged in this pay run?
Click Agent Expense Report to download a spreadsheet of every salesperson's charges, grouped by expense type. See Commissions Pay Run: Agent Expense Report.
Do I need to turn on the year-to-date summary?
No. The earnings, expenses and year-to-date summary is on every salesperson invoice for Australian and New Zealand agencies.
Can we hide the year-to-date summary on our salesperson invoices?
No. There is no setting to turn the summary off.
Why is there a W/H Tax row of $0.00 on the salesperson invoice?
The W/H Tax row always shows. It is $0.00 when the agent has no withholding tax rate.
An older invoice I re-sent looks different. Did the amounts change?
No. It now includes the year-to-date summary, with Year To Date ending at that invoice's pay run date. The totals and balance due are unchanged.
Our financial year doesn't start on 1 July (or 1 April). Can we change it?
Not from your account. Contact Rex Support and let us know your agency's financial year.
Is the year-to-date summary on UK salesperson invoices?
No. The summary is for Australian and New Zealand agencies only.