ADP Workforce Now Debits Not Matching: QuickBooks Reconciliation Guide
ADP Workforce Now debits often clear before the pay date and split into several amounts. Here is why they miss in QuickBooks and how to reconcile them.
If your client moved from ADP RUN to ADP Workforce Now mid-year, the bank feed probably stopped matching overnight. Debits land on unexpected dates, arrive in odd amounts, and refuse to line up with the payroll register. We see this pattern every time a client graduates between the two products. The payroll itself is usually fine; the shape of the withdrawals is what changed.
Why do the debits stop lining up?
ADP Workforce Now typically pulls funds on a funding schedule that runs ahead of the check date. The money has to clear before payday, so the debit posts first and the register follows later. Reconciling by pay date therefore finds nothing to match on the day you expect it. The exact lead time depends on the funding setup and the bank, so confirm yours with your ADP service representative.
One payroll can arrive as several debits
A single payroll rarely leaves the bank as one withdrawal. Tax impounds are often separated from net pay. Direct deposits can post in batches, and garnishments, benefit premiums, and off-cycle checks each take their own path. A $40,000 run might reach the account as five debits of unrelated sizes, none equal to the net pay total. That is why searching the register for individual amounts only works some of the time.
Partner draws are not payroll
Payments to owners frequently move through ADP outside the payroll run itself. They debit the bank on their own dates and may never appear on the payroll register at all. Matching them to a pay period will fail every time. Record them as owner distributions, dated when they clear, and keep them out of the payroll reconciliation entirely.
Reconcile by check date, not by debit date
Date your payroll entries by check date, the way the register reports them. Then treat every ADP debit in the surrounding window as a candidate for that one payroll. Group the debits, tie the group to the entry, and set aside anything that belongs to benefits or prior corrections. A payroll clearing account keeps the noise out of the bank feed while you work. ADP can supply a summary of each run’s withdrawals; ask your representative to send it with every payroll.
Can QuickBooks match these debits automatically?
Not reliably. Bank feeds try to match one transaction to one entry, and this pattern is many-to-one across different dates. A bank rule that recognizes ADP withdrawals and routes them to the clearing account saves clicks. The final tie-out still needs a human eye, at least until every debit type has a known home.
Does the mid-year switch change anything?
You now have two payroll products inside one fiscal year. Keep the RUN reports and the Workforce Now reports side by side, and reconcile each period against the system that actually cut the checks. Quarter-end totals should still tie to the combined registers.
Start with the most recent payroll. Export its register, list every ADP debit from the weeks around it, and label each one until nothing is unexplained. Once a single period closes cleanly, the rest tend to follow the same pattern.