Reconciling leave balances during a payroll provider switch is one of the most error-prone tasks in HR operations — and the errors follow the employee for months. When you migrate from one payroll system to another, leave balances must be transferred accurately, accrual rules must be reconfigured, and the crossover period must be handled carefully to avoid overpayments, underpayments, or employee disputes. A single miscalculation can cascade into incorrect payslips, compliance issues, and eroded employee trust.
This guide covers the end-to-end process for reconciling leave balances during a payroll switch: pre-migration audit, data extraction, reconciliation, common discrepancies, crossover period handling, and post-migration verification.
Key takeaways
- Audit leave balances before migration — do not assume the source system’s balances are accurate.
- Extract leave data at a single point in time — balances, accrual rates, leave history, and policy rules.
- Reconcile against payslips and timesheets — the payroll record should match the leave management record.
- Handle the crossover period carefully — partial pay periods are where most discrepancies occur.
- Verify post-migration — run parallel payroll for at least one cycle to catch discrepancies.
Pre-migration audit
Before extracting any data, conduct a leave balance audit on the source system. This step catches errors that have accumulated in the old system — errors you do not want to migrate.
Step 1: Run a leave balance report
Extract a report showing:
- Current leave balance for every employee (annual leave, personal leave, long service leave, and any other leave types).
- Accrual rate per employee (daily, weekly, or per pay period).
- Last accrual date.
- Any leave taken since the last accrual.
- Any manual adjustments in the last 12 months.
Step 2: Compare against payslips
Cross-reference leave balances against recent payslips. The leave balance on the payslip should match the leave balance in the leave management system. If they do not match, investigate before proceeding.
Step 3: Check for manual adjustments
Manual adjustments are the most common source of discrepancies. Check for:
- Leave taken but not recorded in the system.
- Leave accrued but not reflected on payslips.
- Policy overrides (e.g., extended leave, leave loading adjustments).
- Historical errors carried forward from previous payroll providers.
Step 4: Identify discrepancies
Document every discrepancy found. Common sources include:
| Discrepancy Type | Cause | Frequency |
|---|---|---|
| Accrual timing mismatch | Payroll and leave systems accrue at different times | High |
| Manual adjustment errors | HR entered leave manually without updating payroll | High |
| Policy configuration errors | Accrual rate calculated incorrectly (e.g., pro-rata for part-time) | Medium |
| Rounding differences | Different rounding rules between systems | Medium |
| Leave loading errors | Leave loading not calculated or calculated incorrectly | Low |
Data extraction
Once the audit is complete, extract leave data from the source system at a single point in time — typically the last day of the final pay period on the old system.
Data to extract
| Data Field | Why It Matters |
|---|---|
| Current leave balance | The starting balance in the new system |
| Accrual rate | Ensures continued accrual in the new system |
| Leave type mapping | Maps old leave types to new system’s leave types |
| Leave history (12 months) | Provides a reference for post-migration verification |
| Policy rules | Ensures the new system applies the same rules |
| Pro-rata calculations | Part-time employees may have different accrual rates |
| Leave loading rules | If applicable, transfer the leave loading calculation |
Data format
Extract data in a structured format (CSV, Excel, or API) that can be imported into the new system. Avoid screenshots, PDFs, or manual re-entry — these introduce transcription errors.
Reconciliation process
With the extracted data, reconcile leave balances against three sources:
1. Source system vs payslips
Compare the leave balance in the source system against the most recent payslip for each employee. They should match. If they do not:
- Check whether the payslip includes leave taken but not yet recorded in the system.
- Check whether the leave system includes accruals not yet reflected on the payslip.
- Document the discrepancy and resolve before migration.
2. Source system vs timesheets
If the employer uses timesheets, compare leave balances against timesheet records. Employees who recorded leave on timesheets should have that leave reflected in the leave balance.
3. Source system vs employment contracts
Verify that the accrual rate in the source system matches the employment contract or award. Part-time employees should accrue on a pro-rata basis. Fixed-term employees may have different accrual rules.
Common discrepancies and how to resolve them
1. Accrual timing mismatch
Problem: The old system accrues leave at the end of the month; the new system accrues per pay period.
Resolution: Calculate the difference in accrual timing and adjust the starting balance. If the old system accrued monthly and the new system accrues per pay period, ensure the new system does not double-accrue for the first period.
2. Part-time pro-rata errors
Problem: The old system accrued leave at full-time rates for part-time employees.
Resolution: Identify affected employees, calculate the correct pro-rata accrual, and adjust the starting balance in the new system.
3. Leave loading discrepancies
Problem: Leave loading was calculated in the old system but not carried to the new system.
Resolution: Transfer leave loading rules to the new system and verify that future leave loading calculations match the old system.
4. Historical leave not migrated
Problem: Leave taken before the migration date was not recorded in the new system.
Resolution: Import the full leave history (at least 12 months) into the new system to ensure accurate records.
Crossover period handling
The crossover period — the final pay period on the old system and the first pay period on the new system — is where most discrepancies occur.
Best practice: Parallel payroll run
Run parallel payroll for at least one pay period during the crossover:
- Run the final payroll on the old system.
- Run the same payroll on the new system using migrated data.
- Compare payslips for every employee.
- Investigate and resolve any differences.
- Use the new system’s payroll as the live payroll.
Timing the migration
The cleanest migration occurs at the start of a pay period or the start of a leave year:
- Start of pay period: No partial-period accruals to reconcile.
- Start of leave year: Leave balances reset (if the policy provides for it) and the new system starts fresh.
Avoid migrating mid-period if possible — partial-period accruals are difficult to calculate accurately.
Post-migration verification
After migration, verify the following:
1. Individual employee verification
Spot-check at least 10% of employees (or every employee if the workforce is small). For each employee:
- Verify the starting balance matches the extracted data.
- Verify the accrual rate matches the employment contract.
- Verify the leave history is complete.
2. Aggregate verification
Run an aggregate leave balance report on the new system and compare against the source system:
- Total leave balances across all employees should match.
- Total accrual per period should match.
- Leave taken since migration should be recorded correctly.
3. Policy configuration check
Verify that the new system applies the same policy rules as the old system:
- Accrual rates per employee category (full-time, part-time, fixed-term).
- Leave caps (maximum accrual).
- Leave loading calculations.
- Public holiday handling.
- Rounding rules.
Data migration checklist
| Step | Task | Status |
|---|---|---|
| 1 | Conduct leave balance audit on source system | ☐ |
| 2 | Identify and resolve discrepancies | ☐ |
| 3 | Extract leave data at single point in time | ☐ |
| 4 | Map old leave types to new system leave types | ☐ |
| 5 | Import starting balances into new system | ☐ |
| 6 | Configure accrual rules in new system | ☐ |
| 7 | Import leave history (12 months minimum) | ☐ |
| 8 | Run parallel payroll for one pay period | ☐ |
| 9 | Compare payslips and resolve differences | ☐ |
| 10 | Spot-check individual employees (10% minimum) | ☐ |
| 11 | Verify aggregate balances match | ☐ |
| 12 | Document the migration and file for audit | ☐ |
leave emails? Track your employee's leave with Leave Balance
A leave management system that handles leave balance migration, tracks accrual rules per employee category, and maintains accurate records across payroll provider switches keeps employers compliant and employees confident in their leave balances.
Frequently asked questions
How long does leave balance reconciliation take?
For a workforce of 50-200 employees, expect 2-4 weeks for the full reconciliation process, including audit, extraction, reconciliation, and post-migration verification. Larger workforces may take longer.
What if the source system’s leave balances are inaccurate?
Do not migrate inaccurate balances. Conduct the pre-migration audit, identify discrepancies, resolve them, and migrate corrected balances. Migrating known errors creates更大的 problems in the new system.
Can I migrate leave balances mid-period?
You can, but it is not recommended. Mid-period migrations require partial-period accrual calculations, which are error-prone. If you must migrate mid-period, run parallel payroll for the partial period to verify accuracy.
What about long service leave balances?
Long service leave rules are state-based in Australia and vary by jurisdiction. Verify the accrual rules and balances for long service leave separately, as the rules differ from annual leave.
Should I use a leave management system for migration?
Yes. Modern leave management systems can import leave balances, configure accrual rules, and track leave history — reducing manual effort and error risk during migration.
Sources
This article is general information, not legal advice. Leave migration requirements vary by jurisdiction — confirm current rules with the relevant government agencies and your legal advisor.