A step-by-step checklist for reconciling bank statements to your general ledger. Match transactions, investigate discrepancies, post adjustments, and close with a clean cash position.
Check off tasks, assign owners, and set due dates. The live preview updates as you reconcile each cash account.
Collect bank statements, GL exports, and prior-period outstanding items for every cash account in scope.
Compare each bank line item against the GL. Mark matched items and isolate discrepancies for investigation.
Research every unmatched debit and credit. Contact the bank for unidentified charges or errors.
Book journal entries for bank fees, interest, reclassifications, and errors found during investigation.
Confirm the adjusted bank balance equals the adjusted GL balance. Obtain sign-off and archive workpapers.
Pre-built with transaction matching columns, outstanding item tracking, and auto-calculated reconciliation summary.
Print-friendly reconciliation workpaper with checkboxes, signature lines, and space for explanatory notes.
Locked format for audit archives. All 27+ tasks grouped by phase with status and owner columns.
A typical monthly bank reconciliation runs over four business days. Here is how each phase maps to the cycle.
Bluecopa imports bank feeds, auto-matches transactions to the GL, and flags only the exceptions that need your attention.
Bank reconciliation is the process of comparing a company's internal cash records in the general ledger against the bank statement for the same period. The goal is to identify and resolve every difference so the reported cash balance is accurate, complete, and audit-ready.
Gather the bank statement and the GL cash balance for the same period. The two starting figures almost never match due to timing differences, fees, and recording gaps.
Walk through every transaction on both sides. Cleared items get checked off; anything left over is a reconciling item that needs investigation or an adjusting entry.
Research each unmatched item: outstanding checks, deposits in transit, bank errors, or GL coding mistakes. Post correcting journal entries for fees, interest, and reclassifications.
After adjustments, the adjusted bank balance and the adjusted GL balance should agree. Document the result, get it reviewed by the controller, and file the workpapers for audit.
A check issued and recorded in the GL but not yet cleared by the bank. It appears as a reconciling item until the payee deposits or cashes it.
Cash received and recorded in the GL before the bank processes it. Common when deposits are made near the end of the business day or over a weekend.
A check deposited by the company that the bank returns because the payer's account lacks sufficient funds. The company must reverse the original deposit entry.
Any transaction that causes a difference between the bank statement balance and the GL cash balance. Examples include outstanding checks, deposits in transit, and bank errors.
A mistake made by the bank, such as posting a transaction to the wrong account. The company notifies the bank for correction rather than adjusting its own books.
The time lag between when a transaction is initiated and when it clears the bank. Managing float helps treasury teams optimize cash positions and working capital.
Pre-close, core close, and post-close tasks for a 5-day financial close cycle.
Match AR/AP pairs across entities, resolve disputes, and prepare elimination entries.
Match GSTR-2B with purchase register and resolve ITC mismatches before filing.
Calculate period-over-period variances, investigate root causes, and document commentary.
Enter your work email and your download starts straight away.
Free. No credit card needed.