A monthly bank reconciliation template that walks through the full reconciliation process: adjusting the bank statement balance for deposits in transit and outstanding checks, adjusting the book balance for unrecorded credits and debits, and confirming the two sides tie out to zero difference.

Designed as a reusable monthly template — input cells are clearly marked so a client's bookkeeping can be reconciled quickly and accurately every month with minimal setup.

(Note: figures are illustrative sample data for portfolio purposes.)