Payroll and HR templatesAutomate leave balance reconciliation in Xero
Leave booked in one system and paid in another drifts apart. Every two weeks Modern compares leave balances in Workday with Xero Payroll, explains each difference and proposes updates.
TriggerEvery 2 weeks
Steps4 steps, from trigger to sign-off
ControlPayroll manager approves every update
Free to start. No card needed.
Every 2 weeksThe instruction
“Every 2 weeks, after the pay run, compare annual and sick leave balances for every employee in Workday with Xero Payroll. Explain any difference over half a day, such as leave taken but not processed or a wrong accrual rate. Propose the update in Xero Payroll and ask the payroll manager to approve it. Report the total leave liability for the month-end accrual.”
Works with every major ERP
- +100 more
How it runs
4 steps from trigger to sign-off
- 01
Pull HR balances
Reads leave balances and leave taken for every employee.
Workday - 02
Pull payroll balances
Reads the matching leave balances from Xero Payroll.
Xero - 03
Explain differences
Names the likely cause of each difference, such as unprocessed leave or a wrong accrual rate.
Modern - 04
Approve updates
The payroll manager approves each proposed update before Modern saves it in Xero Payroll.
Xero
Related templates
More payroll and hr automations
20th of the monthPayroll and HR
Check payroll before it is approved
Compares the draft Workday pay run with last month, flags unusual changes, starters and leavers, and posts findings to Slack.
5 stepsUse template →
When an HR change is approvedPayroll and HR
Keep HR records in sync with Xero Payroll
Copies approved starters, leavers and pay changes from HiBob, BambooHR or Deel into Xero Payroll, and flags mismatches.
4 stepsUse template →- When a new starter is added
Payroll and HR
Check new starters are ready for payroll
Checks every new starter for missing tax details, bank details and pay settings before their first pay run, and chases the gaps.
4 stepsUse template →
FAQs
Reconcile leave balances with payroll: FAQs
Can’t find what you’re looking for? Send us a message and a person on the team will answer.
Leave taken but not processed in payroll, wrong accrual rates and changes to working hours. Modern names the likely cause for each one.
Yes. Modern totals the balances at current pay rates so you can post the accrual at month end.
Yes. Modern compares HiBob, BambooHR or Deel with Xero Payroll, QuickBooks Payroll or your payroll provider.