Reconcile payroll reports with accounting records monthly

Payroll
Blog

Why should payroll reports be reconciled with your accounting records each month?

Running payroll and paying employees is only part of the process. The accounting system also needs to show the same wages, tax, National Insurance, pension costs and HMRC liabilities that payroll actually processed.

N
Niall O'Driscoll Founder & Managing Director, FCMA, CGMA
20 November 2026 10 min read

Payroll reports should be reconciled with your accounting records each month, so that the wages, tax, National Insurance, pension costs and amounts owed to HMRC shown in the ledger agree with what was actually processed through payroll. Running payroll and paying employees is only part of the process. The accounting system also needs to reflect those figures correctly.

The 2025 Longitudinal Small Business Survey found that 64% of SME employers using technology or web-based software to manage or sell through their business used payroll software, rising to 87% among medium-sized businesses. The software can calculate the figures, but they still need to be reflected correctly in the accounting records.

If payroll shows £45,000 of gross wages but the ledger contains £42,500, the £2,500 difference needs to be understood. Leaving it until year-end can mean several months of incorrect payroll costs or liability balances have to be investigated at once. Below, we cover what to compare, why differences arise and how to review them each month.

What to reconcile between payroll and accounts

The payroll system contains information about what employees were paid and the deductions made from their pay. The accounting records should reflect those same transactions. A monthly payroll reconciliation will commonly compare the following.

Payroll figureWhat to check in the accounts
Gross wagesStaff cost recorded in the profit and loss account
Employer’s National InsuranceEmployer NI expense
Employer pension contributionsPension cost
PAYE and employee National InsuranceRelevant HMRC liability
Employee pension deductionsPension liability
Net payAmount paid or still owed to employees
Other deductionsRelevant liability or balance-sheet account

Suppose the payroll report shows:

  • Gross wages: £50,000
  • Employer's National Insurance: £6,000
  • Employer pension contributions: £2,000

The accounts should contain payroll costs that can be reconciled back to those figures.

The same applies to the balance sheet. If payroll shows £14,000 due to HMRC for PAYE and National Insurance, the relevant PAYE and National Insurance liability in the accounts should reflect what remains outstanding after payments already made to HMRC are taken into account.

The purpose of the exercise is to explain how the payroll figures have moved through the accounts and what remains unpaid at month-end. Two totals that happen to agree do not show that.

Why payroll and accounting records sometimes differ

A difference does not always mean the payroll calculation itself is wrong. The issue may be in how the payroll information reached the accounting system. Common causes include:

  • the payroll journal was not posted
  • a journal was posted twice
  • part of the payroll was posted manually to the wrong account
  • employer's National Insurance was omitted
  • pension contributions were posted incorrectly
  • a payroll adjustment was made after the original journal was created
  • a payment to HMRC was posted against the wrong liability
  • payroll software and accounting software cover different dates
  • bonuses or other adjustments were not reflected consistently

For example, suppose payroll originally shows gross wages of £30,000. A correction is then made before the final payroll submission, increasing the figure to £31,200. If the accounting journal was created before that correction and never updated, the ledger may still contain £30,000. The difference is £1,200 for that month. If similar differences remain unresolved for several months, the year-end payroll cost becomes harder to reconcile.

HMRC also warns that missing, duplicate or incorrect Real Time Information submissions can create differences between an employer's payroll records and its PAYE position with HMRC. That can result in PAYE appearing overpaid or underpaid. It is another reason to compare the payroll reports, accounting ledger and HMRC balance regularly.

The objective is to identify the underlying reason for a difference rather than posting another journal simply to make the balance agree.

How to reconcile payroll reports with accounting records

A payroll reconciliation should start with the final payroll reports for the period. Those figures can then be compared with the payroll journal, bank payments and the balances recorded in the accounting system. A practical monthly review may include:

  1. Confirm the final payroll totals for the month.
  2. Check that the payroll journal has been posted once.
  3. Compare gross wages, employer's National Insurance and employer pension costs with the profit and loss account.
  4. Compare PAYE, National Insurance and employee pension deductions with the balance-sheet liabilities.
  5. Check net wages against payments made to employees.
  6. Match payments to HMRC and pension providers against the relevant liability accounts.
  7. Investigate and document any remaining differences.

Suppose payroll calculates net employee pay of £38,000, but the bank shows £37,200 paid to employees. The £800 difference needs explaining. It could relate to:

  • a payment made after month-end
  • an employee whose payment failed
  • an amount withheld
  • a manual adjustment
  • an incorrect bank posting

Tracing differences and keeping records

The next step is to identify when the difference first appeared. If March agrees but April does not, the investigation can focus on April rather than reviewing the entire year. The payroll reports can then be compared with:

  • payroll journals
  • bank transactions
  • HMRC payments
  • pension payments
  • manual journals
  • payroll corrections

The objective is to identify the underlying reason rather than posting another journal simply to make the balance agree.

For example:

  • PAYE and NI liability per payroll: £18,500
  • Payment made to HMRC: £17,000
  • Expected closing liability: £1,500

If the accounting ledger instead shows £4,000, there is a £2,500 difference to investigate. That gives the review a clear starting point.

Supporting records should also be retained. HMRC requires employers to keep records of employee payments and deductions, payroll reports submitted to HMRC and payments made to HMRC. These payroll records generally need to be kept for three years from the end of the tax year they relate to. HMRC can charge a penalty of up to £3,000 where full records are not kept.

Why monthly reconciliation beats waiting until year-end

Payroll runs every month, so differences can also build up every month. Resolving them while the transactions are recent is usually easier.

Suppose an employer's PAYE liability is £500 higher than expected in April. In May, another unexplained £700 remains. By June, another £400 difference appears. If each month is reviewed separately, the business can check the payroll submission, accounting journal, HMRC payment and any adjustments made during that period. If the problem is first identified nine months later, several months of payroll reports, journals and bank payments may need to be reviewed to establish where the difference began.

Monthly reconciliation also helps keep management accounts more reliable. If payroll costs are understated, the profit shown for the month may be too high. If a payroll journal has been duplicated, employment costs may be too high. If a payment to HMRC has been posted incorrectly, the balance sheet may continue showing a liability that has already been paid. The employees may still have received the correct amount, but management can be looking at the wrong staff costs or payroll liabilities in the accounts.

Regular review also allows the business to identify older balances that no longer make sense. An employee wage balance that remains outstanding several months after the pay run should have a clear explanation. The same applies to PAYE or pension liabilities that do not reduce when the corresponding payments are made.

Where we stand

We think you should reconcile payroll reports with your accounting records each month, as part of the monthly accounting process. The payroll reports should be capable of being reconciled back to the ledger, bank payments and outstanding payroll liabilities. Where they do not agree, the difference should be investigated while the payroll period is still recent.

That keeps staff costs accurate, PAYE and pension liabilities explainable and monthly management accounts more reliable.

If payroll balances are not agreeing with your accounting records, OD Accountants can help review your payroll and bookkeeping records and identify differences before they build up into a larger year-end reconciliation.

N
Written by

Niall O'Driscoll

Founder & Managing Director, FCMA, CGMA · OD Accountants

Frequently asked questions

Does payroll software automatically reconcile with accounting software?

Not necessarily. Some systems can transfer payroll journals automatically, but the figures should still be checked. Incorrect mappings, later payroll changes or duplicate journals can still create differences between the payroll reports and the accounting records, so a monthly comparison is still needed.

Should PAYE and National Insurance be reconciled every month?

Yes. The liability in the accounts should be compared with payroll reports and payments made to HMRC so unexplained balances do not build up. Doing this monthly means that if a difference appears, the payroll submission, journal and HMRC payment for that period can be checked while they are recent.

What happens if the payroll journal is posted twice?

Payroll expenses and related liabilities can be overstated. The duplicate journal should be identified and corrected rather than leaving the additional cost in the accounts. Left in place, a duplicate can mean employment costs look too high in the management accounts, even though employees were paid the correct amount.

Why might net wages not match the bank payment?

Timing differences, failed payments, manual payments or adjustments can cause differences. A payment made after month-end or an employee whose payment failed would leave the bank below the payroll figure. The amount should be investigated so any unpaid or incorrectly recorded wages can be identified.

Should pension balances also be reconciled with payroll reports each month?

Yes. Employer and employee pension amounts should be checked against payroll reports and payments to the pension provider so the remaining liability can be explained. Pension costs and employee pension deductions form part of the monthly comparison, alongside PAYE, National Insurance and gross wages.

Book a free discovery call Book a call Call now Email now