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

Illustrative balances at a single cutoff
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.