Payroll register to bank debits
Each pay run is matched to its net pay debit, with the individual employee lines grouped into one batch under the reason "net pay batch for run". Manual checks match to their cleared check numbers.
Payroll reconciliation software that ties payroll to the bank and GL
Reconciles is payroll reconciliation software for US finance teams that run payroll through ADP, Gusto, Paychex, Paylocity, Rippling or a PEO. It matches every pay run in your payroll register to the debits on your bank statement, splits the one big net pay debit back into employees, ties tax impounds, 401(k) and benefit remittances to the liabilities they clear, and flags anything that does not agree. Plans are published, from $888 a year, and you can try it on your own files before you sign up.
Your files are processed in your browser and never stored. No card needed.
Why payroll almost never ties out by itself
Payroll looks simple from the outside. You approve a run, people get paid. On the bank statement it is anything but simple. A single biweekly run for 140 employees can show up as four or five separate debits: one net pay batch, one federal and state tax impound, a 401(k) remittance a day later, a benefits premium, and the provider's own fee. None of those amounts equal anything on the payroll register, and none of them land on the pay date.
Then the exceptions pile up. A paper check from three runs ago is still outstanding. An employee's direct deposit bounced and the provider credited it back. A garnishment went out on a different schedule. A mid-cycle bonus run was processed off cycle. A manual adjustment was keyed into the ledger but never into the payroll system. Each item is small, and together they are why the payroll clearing account carries a balance nobody can explain at quarter end.
Reconciles turns that explanation into matching work. You bring the payroll register and the bank statement you already have, and every debit is tied to the run and the liability it belongs to, with a reason you can show your auditor.
Where payroll reconciliation usually breaks
- The net pay batch is one bank debit for the whole run, so it never matches a single line on the register.
- Tax impounds are debited separately, often a day or two before or after the pay date, and sometimes split between federal and state.
- 401(k), HSA, benefits and garnishment remittances follow their own schedules and are easy to post twice or not at all.
- Returned direct deposits, voided checks and stale paper checks leave old items sitting in the bank reconciliation for months.
- Off cycle runs, bonus runs and manual checks are processed outside the normal calendar and get missed in the monthly tie out.
- The payroll journal entry posts summary totals, so when the clearing account is off there is no line level trail to find out why.
Reconciles vs other ways teams reconcile payroll
| Reconciles | Payroll provider reports | Enterprise payroll recon tools | Spreadsheets | |
|---|---|---|---|---|
| Examples | Reconciles | ADP, Gusto, Paychex built-in reports | Payroll Recon Toolset, Payslip, consulting builds | Excel or Google Sheets |
| Main job | Prove payroll register, bank debits and GL agree | Show what the provider processed | Validate time, pay and benefits data across HR systems | Whatever the formulas do |
| How you buy | Self-serve, published plans | Included with payroll | Quote, Payroll Recon Toolset lists from $18,000 a year | Already installed |
| Bank statement matched | Yes, every debit to its run | No, the provider does not see your bank | Some | Manual lookups |
| Net pay batch split back into employees | Yes, one to many match | Not applicable | Yes | Manual |
| Tax impounds and remittances tied to liabilities | Yes | Totals only | Yes | Manual |
| Stale checks and returned deposits tracked | Yes, in the exceptions queue | Partly | Varies | Manual |
| Gross to net payroll calculation | No, keep your payroll provider | Yes | Some validate it | No |
| Best for | Controllers who want a clean payroll tie out every close without an IT project | Checking a single run | Large multi-country payroll teams | A handful of employees |
Your payroll provider is the system of record for what was calculated and paid. It does not see your bank account or your general ledger, which is exactly where payroll differences show up. Reconciles sits between those three and proves they agree.
What Reconciles matches in a payroll reconciliation
Tax impounds to payroll tax liabilities
Federal and state tax debits from your provider are matched to the employee and employer taxes withheld on the register, so the liability rolls to zero after each run.
Remittances to deductions
401(k), HSA, benefits and garnishment payments are matched to the deductions they clear, one remittance against several runs where your provider batches them.
Payroll journal to the general ledger
The payroll clearing and liability accounts from your GL export are matched against the register totals, so a manual entry or a duplicate posting shows up as an exception instead of a year end surprise.
How to reconcile payroll in one close
1. Export the payroll register for the month from ADP, Gusto, Paychex, Paylocity or Rippling as CSV or XLSX, with run date, employee or batch, net pay, taxes and deductions.
2. Export the bank statement for the payroll account for the same dates, plus a few days on either side to catch early and late debits.
3. Upload the two files. Reconciles reads the columns on its own, matches the net pay batches, tax impounds and remittances, and saves rules so next month's run matches without review.
4. Work the exceptions queue: stale checks, returned deposits and anything that does not tie. Export the reconciliation report, or journal entries for fees and corrections to QuickBooks, Xero or NetSuite.
A payroll month, line by line
Say your company ran two biweekly payrolls in March for 140 employees, plus one off cycle bonus run. The register shows gross wages of $612,000, employee taxes and deductions of $171,400 and net pay of $440,600. On the bank statement you see 11 payroll debits: three net pay batches, three federal tax impounds, two state impounds, two 401(k) remittances and the provider fee.
Reconciles groups the 140 employee lines of each run into its net pay debit and matches all three. The tax impounds tie to the withheld and employer taxes on the register. One 401(k) remittance covers both regular runs, so it matches one to many. Two items move to the exceptions queue: a $1,842.17 direct deposit that was returned and credited back on March 19, and a $96.00 provider fee with no ledger entry, with a suggested journal entry. The clearing account ties to zero, and the review takes minutes instead of an afternoon.
Who buys payroll reconciliation software
- Controllers and accounting managers at US companies with 50 to a few thousand employees who own the payroll tie out at month end and quarter end.
- Multi entity groups that run several payroll accounts, see intercompany reconciliation software for the cross entity side.
- Teams preparing for an audit who need line level proof behind the payroll clearing and liability accounts, see general ledger reconciliation software.
- Outsourced accountants and bookkeepers who close the books for several clients on different payroll providers, see reconciliation software for accountants.
Which plan fits a payroll reconciliation
A company with one entity and one payroll account usually fits Starter: 3 accounts, 3,000 transactions matched per month, $74 per month billed yearly or $149 monthly. Once you reconcile several payroll and operating accounts, more than one entity or more than 3,000 lines a month, Growth gives you 15 accounts, 20,000 transactions, 5 entities and journal entries for QuickBooks and Xero at $199 per month billed yearly. Scale adds NetSuite journal entries, 100,000 transactions, approvals and the audit log. See the full table on pricing, and if payroll is only one part of your close, the month end close software page shows how it fits together.
Payroll reconciliation questions
Payroll reconciliation is the process of proving that what your payroll register says was paid agrees with what actually left the bank and what was posted to the general ledger. It matches net pay, tax impounds and deduction remittances to bank debits and liability accounts, and explains every difference such as timing, returned deposits, voided checks or manual entries.
Compare the payroll register totals for each run with the payroll journal entry in the GL: wage expense, employer taxes, tax and deduction liabilities and the cash or clearing account. Then confirm each liability was cleared by a matching remittance. Reconciles matches the register, the bank and your GL export in one place and lists anything that does not tie.
After every pay run is best, and at least monthly as part of the close. Payroll tax liabilities should also be reconciled quarterly against Form 941 and the state returns, and annually against W-2 and W-3 totals before they are filed, because a difference found in January is far cheaper to fix than one found by the IRS.
A payroll clearing account is a temporary GL account that holds net pay between the moment payroll is recorded and the moment the bank debit settles. After each run it should return to zero. A balance that does not clear usually points to a returned deposit, an uncashed check, a duplicate entry or a run posted in the wrong period.
No. Reconciles does not calculate gross to net pay and does not file tax returns. Keep your payroll provider for that. Reconciles checks the result: it proves the amounts your provider calculated were paid from the bank and posted to the ledger correctly, and flags the items that were not.
See whether last month's payroll ties
Upload your payroll register and the payroll bank statement. You will see which runs tie, which debits have no match and how much is sitting unexplained before the auditors ask.