Guide to payroll reconciliation

While paying your team accurately and on time is essential, there’s more to payday than simply getting paid – especially with the layers of complex calculations involved. 

Running a systematic payroll account reconciliation will help you ensure that your actual bank pay-outs, general ledger entries, and HMRC liabilities align perfectly, without any hidden errors.

Read on to find out more about payroll reconciliations with QuickBooks.

Payroll reconciliations: In summary

• Performing a regular reconciliation helps you to verify that gross pay, net pay-outs and deductions match across your payroll software, general ledger, and bank accounts, allowing you to identify discrepancies.

• Balancing figures via payroll reconciliation prevents you from under- or over-paying statutory liabilities, such as Income Tax or National Insurance Contributions. 

• Many businesses with cross-border operations need specialised processes to manage their global payroll reconciliation across multiple currencies and tax rules. 

What is payroll reconciliation?

Simply put, payroll reconciliation is the process of comparing your payroll register and wage calculations against your general ledger entries and bank statements to ensure all figures match. It’s a method to compare important financial records. Think of it as a companion to payroll reporting or monitoring.

By completing a payroll reconciliation regularly, you can catch discrepancies such as unrecovered bonuses, misapplied tax codes, bank fee mismatches and so on, before they impact your business account or statutory filings. It’s an essential technique for payroll accounting.

The step-by-step payroll reconciliation process

Now we’ve clarified the meaning of payroll reconciliation, the next step is to understand the process itself.

Step 1: Gather your financial registers and bank statements

Before you start the payroll reconciliation process, you need to collect your payroll register for the pay period, gross-to-net summaries, bank transaction logs and general ledger journal entries. Without this information, your pay reconciliation won’t be accurate, or the process will not be viable.

Step 2: Compare gross pay totals and variable additions

Another step in preparing the payroll reconciliation process is to confirm that the total gross pay matches the basic wage rates, overtime hours logged, commission structures, and statutory pay additions across all documentation. If these are incorrect, then you’re running reconciliation against flawed data before you even begin.

Step 3: Check statutory deductions and liabilities

We now need to focus on reconciling all statutory deductions against your P32 employer payment record to confirm exact amounts owed to HMRC. These deductions and liabilities include:

• Income Tax

• Student loan repayments

• Workplace pension contributions.

Step 4: Verify net wage payouts against bank statements

You must cross-check the total net pay figures calculated in your payroll run against actual outgoing bank transfers recorded on your business account statements. You should compare line-by-line with the actual funds to ensure accuracy.

Step 5: Adjust discrepancies and update general ledger entries

Performing a payroll reconciliation may surface some mistakes, issues or inconsistencies. While no mistakes at all is preferable, payroll reconciliation is designed to catch any discrepancies. As such, you need to correct any identified mismatches such as manual transcription slips or unrecorded bank charges, then post balancing journal entries into your central bookkeeping setup. 

Payroll software comes with many benefits, and many can assist with payroll reconciliations. 

What is global payroll reconciliation and why is it complex?

While it may seem daunting, global payroll reconciliation involves cross-referencing payroll registers, local tax withholdings, and bank disbursements across multiple countries, currencies, and local regulatory frameworks.

The main challenges of global payroll reconciliation are:

• Fluctuating Exchange Rates. These include the currency conversion gaps between payroll calculation dates and the actual bank settlement dates.

• Diverse Statutory Rules. It can be challenging to manage varying local social security contributions and income tax withholding deadlines alongside UK rules. 

• Cross-Border Banking Fees. Hidden or forgotten international transfer charges and intermediary bank fees can rack up, causing discrepancies in net payouts.

Best practice approaches to payroll account reconciliation

Maintaining clean accounts and simplifying audits needn’t be a headache. Tidying your accounts is always easier with a method before you tackle the mess. Here’s our advice for efficient and clear payroll reconciliation:

• Reconcile regularly, or every pay period. Like with many recurring tasks, if you leave things to pile up it becomes harder, messier and more unwieldy. Perform monthly or weekly checks alongside your pay run, rather than waiting for year-end closeouts. By making it a part of your process, you ensure discrepancies are caught early, and the task remains more manageable each time. 

• Connect time-tracking to payroll. Faulty information is a common issue, and manual entry increases the risk of mismatched data. Use integrated time-tracking tools to prevent human slip-ups whilst transcribing shift hours into your payroll software.  

• Keep centralised digital audit trails. Good data hygiene pays dividends in the future. Store past payroll summaries, P32 reports, and bank receipts in cloud records to make internal reviews straightforward. This helps to maintain a clear registry that is easy to search as and when required – no matter where you are. 

Payroll software can help you to execute efficient and effective payroll account reconciliations.

Keep your payroll organised with QuickBooks

Streamline your payroll account reconciliation and keep your books organised with QuickBooks. Link payroll data straight to your central general ledger and make your payroll reconciliation quick, accurate and easy.

By connecting your accounts through QuickBooks, you can make payroll compliance simpler, keep your books organised and catch discrepancies early, while getting full oversight of your total labour costs.

Keep your payroll organised and your data consistent, with QuickBooks.

Learn more about QuickBooks for payroll.

Payroll reconciliation FAQs

How often should a small business do a payroll reconciliation? 

The most effective frequency for a small business to perform a payroll reconciliation is monthly, after each pay run, with a deeper review quarterly. If your business runs weekly pay, then running your payroll reconciliation weekly is also a good idea. The less frequently you reconcile payroll, the more likely it is to be a complex exercise that demands extra time.

What causes discrepancies during the payroll account reconciliation process?

The most common causes of discrepancies during a payroll account reconciliation include manual spreadsheet entry slips, unrecorded variable overtime, unrecorded transactions, incorrect tax codes, timing delays in bank transfers, and unaccounted payroll software fees. Additionally, delayed payments can also cause issues. 

Does payroll software automatically reconcile my accounts and submit data to HMRC?

No, payroll software doesn’t automatically reconcile your accounts and submit that data to HMRC – this includes final bank reconciliations and RTI submissions, which must be done yourself. However, cloud payroll software can match ledger entries and format your figures cleanly, helping you to remain accurate over time. 

How do you fix discrepancies in a payroll reconciliation?

To fix any discrepancies found during a payroll reconciliation, you first need to identify the exact pay period of the data mismatch. Once done, you should update your payroll register or general ledger and resubmit any corrected tax documentation. 

What do I do if a payment is still pending during a payroll reconciliation?

Timing differences or uncashed employee checks can cause pay gaps. You should check any pending payments and include them in your payroll reconciliation as reconciling items. This should ensure your payroll records match your bank statements and general ledger.

The information on this website is provided free of charge and is intended to be helpful to a wide range of businesses. Because of its general nature the information cannot be taken as comprehensive and they do not constitute and should never be used as a substitute for legal, accounting, tax or professional advice. We cannot guarantee that the information applies to the individual circumstances of your business. Despite our best efforts it is possible that some information may be out of date. Any reliance you place on information found on this site or linked to on other websites will be at your own risk.

This information is intended to outline our general product direction, but represents no obligation and should not be relied on in making a purchasing decision. Additional terms, conditions and fees may apply with certain features and functionality. Eligibility criteria may apply. Product offers, features, functionality are subject to change without notice.