Troubleshooting • reference
Troubleshooting Subledger & Bank Reconciliation Differences
Investigating and resolving variances between General Ledger control accounts and subsidiary ledgers for Inventory (12000), AR (11000), AP (20000), and Bank Cash (10100).
Reviewed on 2026-10-07
Compare the same period and currency#
- 1Open the bank reconciliation and the related ledger or aging report using the same date, account, and currency.
- 2Trace the amount to the invoice, bill, payment, stock movement, or journal behind it.
- 3Check whether that record is draft, posted, reversed, or outside the period.
- 4Open the unmatched statement line and compare it with posted candidates.
- 5Check bank account, date, currency, direction, and earlier matches.
If no source transaction exists, record a documented adjustment only when the bank item is genuine.
Trace the difference to a source#
Correct the source record and refresh the comparison before closing the statement. Keep bank evidence with the investigation.
WARNING: Do not plug a difference with an unexplained journal. Preserve bank evidence and the source transaction trail.
Previous
Troubleshooting Financial Posting Blocked Errors
NextTroubleshooting Serial Number & Lot Tracking Errors
Have a question about this workflow?
Subscribed customers can ask questions about this guide inside the authenticated dashboard.
Ask about Troubleshooting Subledger & Bank Reconciliation Differences in Dashboard