To reconcile a payroll variance, work backwards through the pay cycle: quantify the difference between expected and actual pay, then trace the data from roster to timesheet to payroll to bank payment to find where it broke. Compare rostered hours against paid hours, verify each employee’s pay rate and penalty calculations, check leave and allowances, and confirm the gross-to-net total matches what left your bank account and what you reported through Single Touch Payroll. Underpayments should be corrected in the next pay run at the latest; overpayments can only be recovered with the employee’s written agreement.
Every pay run should result in the right people being paid the right amounts at the right time. Reality often differs. Payroll variances — differences between expected and actual pay amounts — are common in Australian businesses, particularly those with variable hours, complex award coverage, or manual data entry. These variances mean employees are either underpaid (a compliance risk) or overpaid (a cost to your business), and both require investigation and resolution. Use our free payroll cost estimator to benchmark expected costs.
This guide covers the practical process of identifying, investigating, and reconciling payroll variances — including the year-to-date, super, and bank reconciliation checks that catch errors a shift-by-shift review misses. Whether you are dealing with a single employee query or systematic issues affecting many staff, effective variance reconciliation protects your business from Fair Work compliance issues while ensuring employees are paid correctly.
Quick summary
- Identify:
Compare timesheets, rosters, and payroll outputs systematically to isolate the variance
- Trace:
Follow the data flow from roster to pay to bank to find root causes, not just symptoms
- Correct:
Fix underpayments promptly and recover overpayments only with written agreement
- Reconcile & record:
Match gross-to-net, super, and STP totals, and document everything to prevent recurrence
Understanding payroll variances
Payroll variances occur at different levels and for different reasons. Recognising which type you are dealing with focuses the investigation.
Individual employee variances
These are differences between what an individual employee should have been paid and what they actually received. They can arise from timesheet errors, incorrect pay rates, missed penalty rates, leave calculation mistakes, or allowances not applied. Individual variances often surface when employees query their pay or during routine audits.
Total payroll variances
These are differences between expected total labour costs and actual payroll totals. They indicate either widespread individual errors or systematic issues in how pay is calculated. Large total variances without obvious individual errors may point to problems with pay rule configuration or system integration.
Budget variances
These are differences between budgeted or forecast labour costs and actual costs. They may be due to payroll errors but can also reflect legitimate operational variations — more hours worked than planned, higher overtime than expected, or roster changes that altered cost profiles. Not all budget variances indicate errors.
Period-on-period variances
Comparing payroll totals or individual pay between periods can reveal issues. Significant changes without an obvious reason — no roster changes, no pay rate increases, the same employees — may indicate errors. Using integrated payroll systems helps track these variances automatically.
Common causes of payroll variances
Understanding typical causes helps focus your investigation:
Timesheet errors
Hours entered incorrectly, shifts missed entirely, or duplicate entries. Manual timesheet entry is particularly prone to errors, and clock-in/out times recorded wrongly or rounded incorrectly can affect pay. Using rostering software with integrated time tracking reduces these issues.
Pay rate issues
Wrong base rate applied, pay rises not implemented, casual loading missed, or incorrect classification level. Rate issues cause systematic variances until corrected and may require back-payment calculations.
Penalty rate miscalculations
Evening, night, weekend, or public holiday rates applied incorrectly. Penalty rate errors are common because of complex award rules — shift timing determines rates, and small timing errors can change which rate applies.
Overtime calculation errors
Overtime not triggered when it should be, calculated at the wrong rate, or double-counted. Daily versus weekly overtime rules vary by award, and hours need to be tracked cumulatively to apply overtime correctly.
Leave processing errors
Annual leave, personal leave, or public holiday leave paid incorrectly or not at all. Leave loading missed for permanent staff. Leave balances not updated correctly after payment.
System integration issues
Data not flowing correctly between time tracking and payroll systems. Field mapping errors causing data to land in the wrong places. Sync failures leaving payroll with incomplete data.
The variance investigation process
Follow this systematic approach to investigate variances:
1. Quantify the variance
Determine exactly how much the variance is and which employees or cost centres are affected. For individual variances, calculate the difference between expected and actual pay. For total variances, identify how much total payroll differs from forecast or prior periods. Precise quantification focuses your investigation.
2. Gather source documents
Collect rosters, timesheets, leave records, and payroll outputs for the affected period and employees. You need to trace data from original source through to final pay calculation. Having all documents together speeds investigation significantly.
3. Compare hours at each stage
Check rostered hours match timesheet hours. Check timesheet hours match what flowed to payroll. Check payroll hours match what was paid. Differences at any stage show where the error occurred. Use time and attendance systems with clear audit trails.
4. Verify pay rates applied
Check the employee’s pay rate in the system against their contract and applicable award. Verify casual loading if applicable. Confirm any recent pay increases were applied. Rate errors cause consistent variances that compound over time.
5. Manually calculate expected pay
For a sample of shifts, manually calculate what should have been paid — base hours times rate, plus penalty rates for applicable hours, plus any allowances. Compare your manual calculation to system output to identify calculation errors.
6. Identify root cause
Determine not just what went wrong but why. Was it a one-off data entry error or a systematic issue? Is the pay rule configured incorrectly? Is there a training gap? Is the system integration broken? Root cause identification prevents recurrence.
7. Document findings
Record what the variance was, what caused it, how you identified the cause, and what correction is needed. This documentation supports audit requirements and provides a reference if similar issues occur in future.
Reconciling gross-to-net, super, and STP totals
A shift-by-shift review catches most hour and rate errors, but some variances only appear when you reconcile the pay run’s totals against your other financial records. This is the step most businesses skip — and where the SERP is dominated by accounting platforms rather than practical guidance. Before you consider a pay run closed, run these three checks:
- Gross-to-net reconciliation — Confirm that gross wages, less PAYG withholding and other deductions, equals the net pay total, and that the net total matches the amount actually paid from your bank account. A mismatch here points to a deduction applied to the wrong employee, a rounding error, or a payment that didn’t clear.
- Superannuation reconciliation — Check that the super calculated on ordinary time earnings for the period matches what was accrued and what you’ll remit to the fund. Super is a frequent source of quiet variances, especially when a rate change or a new employee’s ordinary time earnings aren’t set up correctly.
- Single Touch Payroll reconciliation — Compare the year-to-date gross and tax you’ve reported to the ATO through STP against your payroll system’s YTD totals. A variance of more than a few dollars (allowing for rounding) needs investigating before you finalise — common causes are a pay category mapped incorrectly, salary sacrifice classified wrongly under STP Phase 2, or a pay event that failed to lodge.
Doing these checks each period rather than only at end of financial year means small discrepancies are corrected while they’re still small, instead of compounding into a large year-end reconciliation headache.
Correcting payroll variances
How you correct a variance depends on whether employees were underpaid or overpaid:
Correcting underpayments
Calculate the exact amount owing, including any superannuation. Process the correction as soon as practicable — significant amounts may warrant immediate payment rather than waiting for the next pay run. Annotate the pay slip clearly to show what the payment covers, update the employee’s records, and inform them of the correction.
Recovering overpayments
Notify the employee of the overpayment with a clear explanation of how it occurred and the amount. Obtain written agreement for recovery — you cannot make unilateral deductions. Agree on a reasonable recovery schedule that does not cause hardship, and ensure deductions do not drop pay below minimum wage in any period.
Fixing systemic issues
If the variance reveals a systematic problem affecting multiple employees or an ongoing period, fix the underlying issue first. Then calculate corrections for all affected employees across all affected periods. Process corrections methodically with proper documentation for each.
Updating system settings
If the variance was caused by incorrect configuration — wrong pay rate, incorrect penalty rule, broken integration — correct the setting to prevent future occurrences. Test the correction before the next pay run, and document what was changed and why.
Preventing payroll variances
Systematic prevention reduces the time and cost of variance reconciliation:
Automate data flow
Integrate time and attendance with payroll to eliminate manual data entry. Automated data transfer removes transcription errors and ensures all approved hours flow to payroll accurately.
Configure award rules correctly
Ensure your system has correct penalty rate schedules, overtime triggers, and allowance rules for all applicable awards. Proper award interpretation configuration reduces errors. Test configurations against manual calculations and review when awards are updated.
Implement approval workflows
Require manager approval for timesheets before payroll processing. Approvers should verify hours match actual work performed, and flagged anomalies should be investigated before approval.
Pre-process variance reports
Generate reports comparing this pay run to previous periods before finalising. Investigate significant variances before processing rather than after — catching errors early is easier than correcting them later.
Maintain employee records
Keep pay rates, employment types, and award classifications current. Process rate changes promptly when employees are promoted, reclassified, or when awards are updated. Stale data causes errors.
Regular system audits
Periodically audit pay calculations for a sample of employees against manual calculations. Test penalty rate triggers, overtime calculations, and leave payments to catch configuration drift before it causes widespread errors.
Documentation and record keeping
Proper documentation supports compliance and protects your business:
Variance investigation records
Document each variance investigated — the amount, affected employees, investigation steps taken, root cause identified, and resolution. These records demonstrate due diligence if compliance questions arise later.
Correction documentation
Keep records of all corrections made — calculations showing amounts owing, when corrections were processed, and evidence of payment. For overpayment recoveries, retain employee agreements and recovery schedules.
Employee communications
Document communications with employees about variances affecting their pay. Keep copies of written notifications about underpayments or overpayments, and record verbal conversations in file notes.
System change records
When variances lead to system changes, document what was changed, when, and why. Keep records of system configurations before and after changes — this audit trail supports future troubleshooting.
Related RosterElf features
Reduce payroll variances with integrated systems. RosterElf connects rostering, time tracking, and payroll so approved hours flow straight through with Australian award rates applied — eliminating the data entry errors that cause variances, and giving you the audit trail and roster-vs-actual reporting to catch the rest before pay day.
Disclaimer
This article provides general guidance only and does not constitute financial or legal advice. Payroll and wage recovery matters should be handled in accordance with your specific circumstances, applicable awards, and Fair Work requirements. Always consult qualified professionals and refer to official Fair Work Ombudsman resources for specific matters.
Frequently asked questions
What is a payroll variance?
A payroll variance is any difference between expected and actual pay amounts. This includes differences between budgeted and actual labour costs, between rostered and paid hours, and between calculated and processed pay amounts. Variances can be positive (overpayment) or negative (underpayment) and may affect individual employees or total payroll costs.
How do you reconcile payroll after a pay run?
Work backwards through the pay cycle. First quantify the variance and gather the roster, timesheets, and payroll output. Compare rostered hours to paid hours, verify each pay rate and penalty calculation, then reconcile the totals: confirm gross-to-net ties out, that net pay matches your bank payment, and that super and Single Touch Payroll year-to-date figures match your payroll system before you finalise.
What causes payroll variances?
Common causes include timesheet errors or omissions, incorrect pay rate application, penalty rate mistakes, overtime not captured or calculated correctly, leave recorded incorrectly, allowances missed or duplicated, data entry errors during processing, system integration issues between time and payroll, and timing differences between when work occurs and when it is processed.
How quickly should payroll variances be resolved?
Underpayments should be resolved as quickly as possible, ideally in the next pay run. Fair Work requires employees to be paid correctly and on time, and significant underpayments may warrant immediate correction rather than waiting. Overpayments can typically be recovered over subsequent pay periods with employee agreement, but must be handled carefully and in accordance with award provisions.
Can you deduct overpayments from future wages?
You can recover overpayments but must follow proper processes. You need written agreement from the employee for deductions, and deductions cannot leave employees earning below minimum wage in any pay period. Some awards have specific overpayment recovery provisions. Document the overpayment, explain it to the employee, and agree a reasonable recovery plan — do not make unilateral deductions.
How do you investigate a payroll variance?
Start by identifying the specific variance amount and affected employees. Compare timesheets to rosters to find hour discrepancies, verify pay rates for each classification, check penalty calculations against shift times, and review leave records. Trace the data flow from timesheet through to payroll to identify where the error occurred, and document your steps and findings.
How do you reconcile super and STP as part of a pay run?
Check that the superannuation calculated on ordinary time earnings matches what was accrued and will be remitted, then compare your Single Touch Payroll year-to-date gross and tax against your payroll system’s YTD totals. A variance above a few dollars (allowing for rounding) usually points to a pay category mapped incorrectly, salary sacrifice misclassified under STP Phase 2, or a failed pay event — fix it before finalising rather than at year end.
What records should you keep for payroll reconciliation?
Keep detailed records of all variances identified, investigation steps taken, root causes determined, corrections made, and amounts adjusted. Document employee communications and any agreements reached, and retain copies of original and corrected timesheets. These payroll records support compliance audits and protect both employer and employees if questions arise later.
How can integrated systems reduce payroll variances?
Integrated rostering, time tracking, and payroll systems reduce variances by automating data flow, eliminating manual entry errors. They apply pay rules consistently, calculate penalty rates automatically based on shift times, flag anomalies for review before processing, and maintain audit trails showing exactly how each pay amount was calculated — reducing both errors and investigation time.
What variance threshold should trigger investigation?
Any variance affecting employee pay should be investigated regardless of size, as even small errors can indicate systematic issues. For budget variance monitoring, many businesses use a threshold of 2–5% deviation from forecast before requiring investigation. The appropriate threshold depends on your business size, payroll complexity, and risk tolerance — document your threshold policy and apply it consistently.
