Process Timesheet Batches for Xero Payroll Integration
Overview
Once scheduling is complete and employee shifts have been reviewed, create a Timesheet Batch and export it to Xero Payroll. Astalty creates draft Xero timesheets containing the mapped earnings-rate IDs and daily units. Review those drafts in Xero before processing the pay run.
Process Timesheet Batches
To create a batch for payroll export:
- Navigate to Scheduling and check that all Shift Alerts and Shift Approvals have been processed for the Pay Period. You can learn more on these processes by checking the following guides:
- Navigate to Timesheet Batches in Scheduling

- Click on Create Batch and choose how to generate it:
- By Xero payroll calendar - pick the Payroll calendar you're paying. The dates are set automatically to that calendar's next pay period, and only staff assigned to the calendar in Xero are included. This choice only appears once you have payroll calendars synced from Xero.
- Manual date range - set the From and To dates yourself. All staff with eligible shifts in the range are included. Xero export validation compares these dates with the next period for the default payroll calendar in your Xero settings, so the range must match that period exactly.
Review any warnings shown for the period, including unapproved shifts or shift alerts, shifts still in progress and staff with no payroll calendar. Then click Create Batch. See Creating Timesheet Batches for the full detail on both options.

Validate and Export the Batch
- Select the Batch from the Timesheet Batches page, and click Actions > Export Xero Timesheet (API).

- Click Validate. Blocking errors must be fixed before export. A warning can be accepted with Continue anyway after you review it. Most errors include a Fix issue button (wrench icon) that opens the relevant screen. See Resolving Timesheet Batch Validation Errors for the full list.
When your Xero connection can read pay runs, validation also warns before sending a worker whose timesheet is held by a posted future pay run. The warning names the pay run period. Reversing that pay run doesn't clear it, so ask Xero Support how to move it. Compare the worker's payslips with the batch before changing anything, because some of the hours may already have been paid. Connections made before pay run access was available show a prompt to refresh on Settings > Integrations > Xero - see Pay Run Access.
Validation also warns when a worker's Xero employee has no ordinary earnings rate, because Xero refuses their timesheet. Set one on the employee's Employment tab in Xero and validate again, or continue and send everyone else.

- Once validation passes, the Employees field appears. Leave it on All Employees to include every eligible employee in the batch, or click it to select specific employees. A worker shows Exported once any export of this batch has sent them, even if a later export failed for them. To resend after a failure, see If the Export Fails. Review and accept the required agreements before clicking on Create Export.

The export runs in the background. While it is Queued, Details reads Waiting to start. While it is Processing, it shows how many workers are done and roughly how long is left. You can leave the page. Astalty sends and records each worker separately, so one rejection does not undo timesheets Xero already accepted.
| Result | What it means |
|---|---|
| Completed | Every selected worker was sent, or the export completed the required changes to earlier drafts. |
| Partially failed | Some workers were sent or had earlier draft hours removed, but others failed. The result gives the counts, then lists the workers Xero refused, with the reason. If Astalty stopped before finishing, it says why, without naming every worker it did not reach. |
| Failed | No worker was successfully sent or cleared. A failed worker can still have a partly updated draft, so check the error and the draft in Xero before retrying. |
Only one active export can run for a batch. Wait for a Queued or Processing export to finish before starting another export or deleting the batch. Successful workers receive Draft timesheets in Xero, where your payroll administrator can review and approve them before processing the pay run. The accounting integration's New Invoice Status setting does not change payroll timesheet status.

If the Export Fails
A Partially failed or Failed result lists the workers Xero refused, with the reason. If Astalty stopped before finishing, for example because Xero was unavailable or another export was still sending, it says so without naming every worker it did not reach.
- On the failed result, select Fix issue to open the Why this export failed drawer.
- Read the card for the worker's reason and follow its case, or select How to fix this. See After an Export Fails for the buttons the drawer offers.
- Make the change, in Xero or in Astalty, that the card describes.
- Select Validate again, so the next export sees what Xero now holds. Validate warns about every draft the export would replace, including those of workers already sent. Select Continue anyway.
- In Employees, leave All Employees unless you have entered or changed any worker's hours by hand in Xero since the last export: leave those workers out, because an export replaces a draft's hours with the batch's. A draft that already holds exactly this batch's hours is left as it is, so All Employees also reaches workers a stopped export did not name. Selecting only the workers the result names is quicker, but only when the result does not say Astalty stopped early. Then select Create Export.
- When every worker is sent, review and approve the drafts in Xero, then run the pay run.
Where Xero won't take a worker's timesheet for this period at all, first compare their payslips for this and later periods with the batch, because a pay run may already have paid some of the hours. Then add only the hours not yet paid straight onto their payslip in the pay run. Export Xero spreadsheet in the drawer, or Export as Excel on the Export for Xero panel, lists the batch's hours.
Recover From an Incomplete Draft
A worker can fail after Xero has accepted some changes to their draft. Read that worker's result before approving anything in Xero:
- Holds only part of this batch's hours means some of the intended hours are missing. Fix the reason Xero refused the line, then validate and export again to send the remaining hours.
- Only partly updated means the draft matches neither its previous hours nor the current batch. Check the draft in Xero, resolve the reported issue, then validate and export again.
- Only partly cleared means a worker who is no longer in the batch still has some hours from an earlier export in their draft. Fix the reported issue, then validate and export again so Astalty can remove the remaining hours.
- Xero kept returning an error, so Astalty stopped trying means Xero failed for that worker several times while accepting others. A draft Xero holds for them may not have this batch's hours, so don't approve it yet. Send them again later, and contact support if it keeps happening.
- Another export to Xero was still sending or Xero was unavailable means Astalty stopped before it could confirm the workers it had not finished. Check Xero, then export again once the other export has finished or Xero responds, choosing Employees as step 5 of If the Export Fails says, because the result does not name every worker it did not reach.
- Astalty reverted this worker's approved timesheet to draft means the revert worked but a later step failed. The timesheet stays a draft, and out of any pay run, until it is approved again in Xero.
Keep the affected timesheet as a draft until the export succeeds and its hours match the batch. Approving it early prevents Astalty from correcting it on the next export.
Re-exporting a Batch
Run Validate again before every re-export. Xero allows one timesheet per worker for a pay period. A draft is replaced with the current batch's hours after a warning. Most other timesheets leave that worker out until they are changed in Xero. Timesheet Already Exists lists what happens for each status and who can change it.
Warnings that leave a worker out affect only that worker. If there are no blocking errors, select Continue anyway to send everyone else. The export result lists anyone Xero refused.
When payroll has approved timesheets an earlier export of this batch created, and nothing else blocks the export, a switch beside Continue anyway offers Revert approved timesheets Astalty sent to draft and replace their hours. With it on, Astalty reverts each one to draft and replaces its hours, or leaves it approved when its hours already match. Approve the reverted timesheets again in Xero before the pay run. With it off, those workers are not sent. See Reverting Approved Timesheets During the Export.

If a previous export of this batch sent a worker who no longer has hours in the batch, validation warns that re-exporting will remove every hour from that earlier draft, including hours added in Xero since. Astalty can do this only while the timesheet is still a draft. If it is no longer a draft, the worker fails and the hours remain in Xero.
Choosing specific employees does not remove hours for an unselected worker who is still in the batch. A worker who has left the batch is still cleared because they no longer appear in the employee selection.
This automatic removal applies only when Astalty recorded the worker's draft during an earlier export of the same batch. Some older Astalty drafts may not have been recorded. Older drafts, drafts created manually, and drafts since used by another batch may need to be corrected in Xero.
If validation warns, or an export result says, that the employee has no ordinary earnings rate, set one on the employee's Employment tab in Xero before exporting them again. Xero requires this even when the batch lines use mapped earnings rates.
Payslip Preview
After Xero processes payroll, the payslip reflects the pay items and rates configured in Xero. Astalty's export sends mapped earnings-rate IDs and daily units, not calculated dollar totals. Check the Xero pay run against the interpreted batch before posting it.

Processing Timesheet Batches Video Walk-Through
In this video, we walk through how to prepare and submit Timesheet Batches from Astalty to Xero.