Accounting Operations
Bank Reconciliation Workpaper Template
Reconcile bank and book balances with outstanding checks, deposits in transit, signed adjustments, duplicate flags, and unresolved-item tracking.
About this template
Use this workpaper for monthly or period-end bank reconciliation review. Choose Paste Import for register or reconciliation-detail rows, or Manual Input for a compact balance and reconciling-item schedule. The workbook calculates adjusted bank and book balances, the remaining difference, unresolved amounts, and duplicate references.
This lightweight file does not perform fuzzy transaction matching. The preparer classifies outstanding checks, deposits in transit, bank adjustments, book adjustments, and unresolved items. The Summary can be printed or retained with the close file.