The bank statement shows $18,420 out. The payroll register shows $18,420 approved for the card channel. The numbers agree perfectly, but two payments are still unresolved. This is why a payroll-card reconciliation starts with separate records rather than one control total.
Write down what each source proves
The approved register supports the amount and population your organization intended to pay. The bank proves a movement of money from the funding account; it does not establish the result of each individual load. A provider report says what the provider recorded, using its own status vocabulary. The general ledger shows what the employer recognized. Link the four with a batch identifier, settlement date and any mapped references, rather than matching dollar amounts alone. The bank’s booking date and the report’s effective date may also legitimately differ.
Work the batch
| Evidence | Amount | Interpretation |
|---|---|---|
| Approved card-channel wages | $18,420 | Expected population only |
| Bank debit | $18,420 | Funding moved; no item outcome shown |
| Confirmed loads | $18,100 | Matching provider outcome, subject to status definition |
| Reject + pending | $320 | $120 rejected and $200 still pending |
The bridge is $18,100 + $120 + $200 = $18,420. That arithmetic makes the reporting population intelligible; it does not make the $320 disappear. The reject needs a verified disposition; the pending item needs an owner and a next observation time. Keep the exceptions separate instead of labeling both as failed. Never publish a real batch or employee-level wage detail as part of this exercise.
Finish in the ledger, not in the spreadsheet
A reviewer should be able to locate the ledger entry and understand why any related balance remains open at the cutoff. The correct entries depend on the actual agreement, your accounting policy and the facts; the table is not a journal-entry template. If a debit nets fees with funding, split the reconciliation lines before declaring a wage shortfall. If source timestamps differ, document which time each report uses and rerun the bridge using the same cutoff.
Follow the unresolved amount into the close memo and guard against paying the reject twice with the replay checklist.
Reference: GAO Green Book, a federal internal-control framework used here for design ideas, not a private-employer mandate.