Payroll Register Reconciliation
Check that everyone on the payroll register was actually paid, and paid the right amount — before anyone has to tell you they were not.
Nothing you paste leaves this page. Parsing and matching happen in your browser.
How it works
The payroll register says what each person should receive; the bank statement says what actually left. Reconciling the two catches the failures that are most damaging to discover late: someone missed entirely, someone paid twice, someone paid the wrong figure.
Matching runs on employee identifier and net amount, so a mismatch on either side is surfaced rather than hidden. Amount variances are separated from missing payments because they mean different things — a variance is usually a mid-cycle change that did not carry through, while a missing payment is a failed transfer.
Match register net pay against bank debits by employee reference
- Register — what payroll calculated each employee should receive
- Bank debits — what actually left the account
- Variance — a payment made for an amount other than the register figure
Worked example
A register of 8 employees against 8 bank debits
Inputs
Results
One employee unpaid and one paid 12,600 short. Both are worth finding before payday rather than after.
Frequently asked questions
What format should I paste?
Copy straight out of a spreadsheet, or paste CSV. A header row is optional — columns are identified by their headings when present and by their content when not. Dates, references and amounts are detected automatically, and amounts may carry currency symbols, thousands separators or accounting parentheses.
Should I use gross or net pay?
Net — the amount actually transferred. Gross pay never matches a bank debit, because deductions and contributions are paid separately and usually on a different date.
What if the bank shows one lump sum for the whole payroll?
Then reconcile the register total against that single debit and check the total agrees. Per-employee matching needs a per-employee bank file, which most banks provide as a bulk-transfer confirmation.
Why would someone be paid an amount that is not on the register?
Usually a mid-cycle change — a loan deduction, an advance recovery or a correction — applied to the transfer but not to the register, or the other way round. Either way the two records disagree and one of them is wrong.
Is my ledger data uploaded anywhere?
No. Every line you paste is parsed and matched inside your browser. Nothing is transmitted to us, nothing is stored, and closing the tab discards it. That is the whole reason this tool exists in this form.
More in Reconciliation
Two-List Matcher
Paste any two lists of transactions and find what does not line up — matched pairs, exceptions on each side, and duplicates within either.
ReconciliationBank Reconciliation
Match your cash book against the bank statement and produce a proper reconciliation — outstanding items, unrecorded charges and adjusted balances on both sides.
ReconciliationInvoice vs Payment Reconciliation
Match payments received against invoices raised, and find the short payments, overpayments and unallocated cash sitting in your receivables.
ReconciliationPayment Gateway Payout Reconciliation
Reconcile what the gateway actually paid you against what your orders say it should have — with fees, refunds and missing settlements itemised.
ReconciliationGST / VAT Return Reconciliation
Match your purchase register against what your suppliers actually filed, and find the input tax credit you are about to lose.
ReconciliationDuplicate Payment Detector
Scan a payment run or a full year of ledger for payments made twice — the same supplier, the same amount, days apart.