Payroll reconciliation is what tells you whether the payroll reports, employee payments, PAYE liability, pension deductions and accounting records all agree with one another. You can pay every employee the right net amount and still have a payroll control account that makes no sense because the journal, HMRC payment or pension entry was posted incorrectly.

The useful question after payday is not simply, “Did everyone get paid?” It is, “Can I trace gross pay through deductions, liabilities and bank payments and explain every remaining balance?” Good payroll reconciliation should make that answer clear before the next payroll is run.

What payroll reconciliation is actually checking

Payroll reconciliation compares the payroll software output with the accounting records and the payments that actually left the bank. The process should confirm that gross wages, employee deductions, employer costs, net pay and liabilities to HMRC or pension providers have all been recorded in the right places.

HMRC’s PAYE record-keeping guidance says employers must keep records that show they have reported accurately. Those records normally include what employees were paid, deductions made and information supporting payroll submissions. The bookkeeping should then reflect those payroll records consistently.

This is why payroll reconciliation is different from simply checking the total wages payment. A bank transfer proves that money moved. It does not prove that the payroll journal, PAYE balance or pension liability is correct.

You paid every employee, but the payroll still does not balance

This is a common bookkeeping problem. The payroll software says net wages were £18,400. The bank shows £18,400 paid to employees. Nobody has complained about their pay. Yet the balance sheet still contains an unexplained payroll figure.

The problem may be in the journal rather than the payments. Gross wages may have been posted incorrectly, employer National Insurance may be missing, pension deductions may have been combined with PAYE, or the journal may have been entered twice.

A proper payroll reconciliation starts with the payroll report and follows each part of the calculation into the bookkeeping. The net-pay total is only one part of that route.

Payroll reconciliation starts with the payroll report, not the bank

The payroll report is the source that explains how each pay run was calculated. It should show the gross pay, deductions, employer costs and net amount due to employees. The accounting journal should reflect those totals using the appropriate wage and liability accounts.

If the business starts from the bank instead, it sees only the net wages and later payments to HMRC or the pension provider. Posting those bank movements directly to payroll expenses can understate gross employment costs and leave no clear record of the liabilities created by the pay run.

Good payroll reconciliation therefore begins with the payroll output, checks the journal created from it and only then matches the later payments.

The payroll journal should separate gross wages from deductions

The payroll journal is the bridge between payroll software and the general ledger. It should not reduce the whole pay run to one wages expense and one bank payment.

A complete journal normally distinguishes gross wages, employee deductions, employer National Insurance, employer pension costs, net wages and the amounts owed to HMRC and pension providers. Other deductions may need separate treatment where they apply.

During payroll reconciliation, the totals in the journal should agree with the payroll reports for the same pay period. If the payroll report shows one gross-pay figure and the nominal ledger shows another, the difference should be investigated before the month is closed.

Your existing guide to payroll services explains how payroll journals, bank payments and liabilities fit together within a managed payroll process.

Net wages should agree with the payments made to employees

Once the journal agrees with the payroll report, the next step in payroll reconciliation is to compare net pay with the actual payments made.

If the payroll report says £18,400 is due to employees, the payments from the bank should explain that total. The business may make one bulk payment through a banking file or individual transfers to staff. Either way, the payments should clear the net-wages liability created by the journal.

A difference may indicate an employee was missed, someone was paid twice, a payment bounced, an advance was processed outside payroll or the bank payment belongs to a different payroll period. The point is not that every difference is necessarily an error. The point is that it should have an explanation.

Do not post net wage payments straight to the wages expense

One of the easiest ways to break payroll reconciliation is to record the payroll journal and then post employee bank payments straight to wages expense as well.

The expense was already recognised when the payroll journal recorded gross wages and employer costs. The later bank payment should normally clear the net-pay liability rather than create a second wages expense.

If the bank payment is coded to wages again, payroll costs can be duplicated while the liability account remains uncleared. The profit and loss account becomes wrong and the balance sheet still looks as though employees are owed money.

PAYE control accounts need their own payroll reconciliation

The PAYE control account should explain what the employer owes HMRC after payroll has been processed and any valid adjustments have been taken into account. This can include Income Tax deducted, employee National Insurance, employer National Insurance and other relevant payroll amounts.

HMRC’s payroll reporting guidance explains that employers report employee pay and deductions through a Full Payment Submission and can view what they owe based on payroll reports. An Employer Payment Summary can affect the amount due where applicable.

For payroll reconciliation, the liability in the bookkeeping should be compared with the payroll reports and, where useful, the employer’s HMRC account. The later payment to HMRC should then reduce that liability rather than being posted as a fresh payroll expense.

The amount paid to HMRC may not equal the payroll journal

A business can see a difference between the PAYE liability generated by a pay run and the amount ultimately paid to HMRC without the bookkeeping necessarily being wrong.

An Employer Payment Summary can reduce the amount due in certain circumstances. Employment Allowance, statutory payment recovery, CIS deductions suffered by a limited company or other valid adjustments can also affect the amount payable depending on the employer’s circumstances.

That is why payroll reconciliation should compare the liability with the complete payroll reporting position, not assume that one bank payment must equal the gross PAYE journal total.

Where an adjustment is unclear, the payroll reports and HMRC records should be checked before a balancing journal is posted.

Payroll reconciliation should check the HMRC payment itself

HMRC’s PAYE payment guidance says monthly employers normally need to pay electronically by the 22nd of the following tax month, with different timing for payment by post and for authorised quarterly payment arrangements.

During payroll reconciliation, the payment should be matched to the PAYE liability for the correct period. A payment can leave the bank but still create confusion if it is coded to the wrong account or associated with the wrong tax month in the bookkeeping.

If HMRC’s online account does not appear to agree with the bookkeeping, the employer should first check the payroll reports, payment amount, payment date and reference rather than assuming the accounting balance should simply be written off.

Pension deductions need a separate control account

Workplace pension deductions should not disappear inside PAYE. Employee pension deductions and employer pension contributions create amounts payable to the pension provider rather than HMRC.

As part of payroll reconciliation, the pension schedule should agree with the amount recorded in the accounting system and the payment eventually made to the pension provider. The Pensions Regulator’s record-keeping guidance notes that accurate records can help employers check or reconcile contributions made to the pension scheme.

If the payroll journal combines pension deductions with PAYE, the PAYE control account can look too high while the pension account looks too low or does not exist at all. Separating the liabilities makes both easier to review.

One pension payment may cover a different period from payroll

Pension timing can make a monthly balance look unusual. The payroll journal may create the pension liability at payday, while the provider collects the contribution later.

A good payroll reconciliation should therefore allow a genuine outstanding pension balance to remain until payment is made. Forcing the account to zero at month end would hide a real liability.

The key question is whether the closing balance can be traced to a pension schedule and is cleared by the appropriate later payment.

Employer costs should not be confused with employee deductions

Employer National Insurance and employer pension contributions are additional employment costs. They are different from amounts deducted from employees’ gross pay.

If these figures are mixed together, payroll reconciliation becomes harder because the expense and liability accounts no longer mirror the payroll reports clearly.

Your PAYE and National Insurance guide explains the distinction between employee deductions and employer liabilities in more detail. The bookkeeping should retain that distinction rather than compressing everything into one payroll cost.

FPS and EPS reports should support payroll reconciliation

HMRC says employers report pay and deductions through the Full Payment Submission, normally on or before payday. The Employer Payment Summary is used for certain adjustments and situations where an FPS alone does not tell HMRC the final amount due.

For payroll reconciliation, these reports are useful because they show what the employer has actually reported to HMRC. A payroll journal that agrees with the internal payroll report but not with the submitted FPS or relevant EPS may indicate that a correction or resubmission has occurred outside the bookkeeping.

The reconciliation file should therefore retain the final reports used for the period rather than relying only on an early draft payroll run.

Payroll corrections can create differences between months

Payroll errors are sometimes corrected after the original pay run. HMRC’s guidance on correcting FPS and EPS errors explains the reporting process where information previously sent was wrong.

When a correction changes year-to-date payroll values, payroll reconciliation should make sure the accounting journal also reflects the corrected figures where necessary. Correcting the payroll software without updating the bookkeeping can leave the financial accounts tied to an obsolete pay run.

The reverse is also true. Changing only the bookkeeping does not correct an inaccurate payroll submission to HMRC. Payroll reporting errors should be corrected through the appropriate payroll process.

Payments made outside payroll need to be investigated

Businesses sometimes pay employees advances, expenses, bonuses or corrections outside the normal payroll run. Those payments can create confusion if nobody decides whether they belong in payroll, expenses or another account.

During payroll reconciliation, unusual employee payments should be reviewed rather than automatically matched to net wages. A payment may relate to reimbursed business expenses, an approved advance or a genuine payroll amount that should have been processed through the payroll software.

The correct treatment depends on the facts. Where employment tax treatment is uncertain, it should be referred to an appropriately qualified payroll or tax adviser.

Leavers and final pay can create payroll reconciliation problems

Final pay can include ordinary wages, holiday pay, deductions and other adjustments. A leaver may also be paid separately from the main payroll run.

That makes payroll reconciliation especially important in the period somebody leaves. The payroll report, FPS, bank payment and accounting journal should all reflect the final amount consistently.

If a final payment is made manually after the payroll has already been submitted, the payroll team should confirm how that payment is reported before the bookkeeper decides how to post it.

Directors can make the payroll ledger look unusual

Director payroll can create different patterns from ordinary employee payroll, particularly where pay is not taken evenly through the year or National Insurance is calculated using director-specific rules.

The bookkeeping principle remains the same. Payroll reconciliation should use the actual payroll report and submitted records rather than assuming every month will contain identical figures.

Salary and dividend planning is outside routine bookkeeping and should not be inferred from the reconciliation. The bookkeeper’s role is to record authorised payroll correctly and make the resulting balances explainable.

Payroll reconciliation should include benefits or deductions where relevant

Student loan deductions, attachment orders, salary sacrifice arrangements and other payroll items can create additional liabilities or change the route by which money is paid.

A detailed payroll reconciliation does not need a separate nominal account for every minor deduction, but material or recurring amounts should be easy to trace from the payroll report to the ledger and eventual payment.

If several unrelated liabilities are pushed into one payroll control account, the total may balance overall while individual obligations remain impossible to explain.

Bank reconciliation and payroll reconciliation are different controls

A reconciled bank account confirms that transactions and balances in the bookkeeping agree with the external bank record. It does not confirm that the payroll journal was constructed correctly.

A payment to HMRC can be present in the bank and categorised correctly while the underlying PAYE liability is wrong. Employee payments can all clear the bank while gross wages or employer costs are missing from the journal.

That is why bank reconciliation should sit alongside payroll reconciliation, not replace it. One checks the movement of cash. The other checks the relationship between payroll calculations, liabilities and those cash movements.

Xero payroll reconciliation still needs human review

Accounting software can automate part of the payroll journal and payment-matching process, but automation does not remove the need to review balances.

Your guide to Xero payroll setup explains how payroll settings, employee records and accounting links need to be configured before the process can work reliably.

In any software, payroll reconciliation should still confirm that the journal actually posted, the right accounts were used, payments cleared the right liabilities and no duplicate manual journal was added afterwards.

7 essential payroll reconciliation checks before month end

  1. Agree payroll reports to the journal. Gross pay, deductions, employer costs, net wages and liabilities should match the final payroll output.
  2. Agree net pay to employee payments. Confirm that the bank explains the amount due to employees and investigate rejected, duplicate or unusual payments.
  3. Reconcile the PAYE control account. Compare the ledger with payroll reports, FPS and relevant EPS information and the amount due to HMRC.
  4. Reconcile pensions separately. Match employee and employer pension amounts to provider schedules and subsequent payments.
  5. Review payroll corrections. Make sure corrected payroll reports and corrected accounting entries agree rather than leaving the ledger tied to an obsolete pay run.
  6. Investigate unusual employee payments. Separate genuine payroll, expenses, advances and other transactions rather than forcing everything into wages.
  7. Explain every remaining balance. A month-end payroll control account does not have to be zero, but each material balance should be supported and understood.

These seven checks make payroll reconciliation a repeatable month-end process instead of a year-end repair exercise.

What records should support payroll reconciliation?

A useful payroll file should contain enough evidence to reproduce the route from the pay run to the accounts.

HMRC says employers must keep PAYE records for three years from the end of the tax year they relate to. A consistent payroll reconciliation file also makes later queries easier because the business can show how the payroll reports became the balances in the accounting system.

Why payroll reconciliation should happen every pay period

If reconciliation is delayed for several months, one unexplained balance can be rolled forward repeatedly. A duplicated journal in April may still be sitting in the PAYE control account in December, mixed with later payrolls and payments.

Monthly or pay-period payroll reconciliation keeps the problem small. The payroll reports are recent, staff changes are still familiar and the person responsible for payroll can explain unusual adjustments before the details are forgotten.

Our guide to good bookkeeping habits recommends reconciling payroll with employee payments, HMRC liabilities, pension contributions and the bookkeeping system as part of a regular routine.

When payroll reconciliation becomes a year-end warning sign

A payroll control account containing several months of unexplained balances is a warning that the bookkeeping and payroll processes have drifted apart.

The accountant may then need to compare twelve payroll reports, HMRC submissions, pension statements and bank payments before the year-end liability can be trusted. That is routine bookkeeping reconstruction rather than a specialist year-end accounting adjustment.

Regular payroll reconciliation reduces that clean-up by resolving ordinary differences before they become historical ones.

When payroll reconciliation should be handed over

A business with a small stable payroll may manage the monthly process internally. The workload becomes more demanding when there are frequent starters and leavers, variable pay, bonuses, pensions, statutory payments, multiple payrolls or corrections.

The warning sign is not simply that payroll takes time. It is that nobody can explain the PAYE, pension or net-wage control accounts without rebuilding previous months.

Bookkeeping Packages Ltd provides bookkeeping services that can include regular payroll-related reconciliation where this forms part of the agreed scope. Outsourced bookkeeping can also keep the accounting side of payroll current while payroll processing itself remains with the business, an accountant, a bureau or another agreed provider.

Payroll reconciliation should leave no mystery balance

Employees being paid correctly is vital, but it is only one part of a complete payroll process. Reliable payroll reconciliation should also show that gross wages, deductions, employer costs, PAYE, pensions and bank payments all connect.

A payroll liability does not need to be zero at every month end. It does need to be explainable. If the books show money owed to HMRC, employees or a pension provider, somebody should be able to say exactly what creates that balance and when it is expected to clear.

If everyone has been paid but the payroll accounts still do not make sense, you can contact Bookkeeping Packages Ltd to discuss the current records and the bookkeeping work needed to reconcile them.

About the Author

Stuart Kerr is Managing Director of Bookkeeping Packages Ltd, an outsourced bookkeeping service supporting UK small businesses and accountancy practices. With over 20 years of bookkeeping experience, Stuart specialises in helping businesses maintain reliable financial records and useful management information.

This article is provided for general information only. Stuart Kerr is a professional bookkeeper, not a regulated financial adviser. Nothing in this article constitutes tax, legal or financial advice. Advice specific to your circumstances should be obtained from an appropriately qualified professional.