Finance / Free editable template

Bank reconciliation process template

A bank reconciliation proves that the cash in your books matches the cash in the bank. This example shows the steps from importing the statement and auto-matching, through sorting unmatched items into timing differences, bank charges and errors, to reviewer sign-off, with a worked example that brings both balances to the same figure.

This is a planning example, not financial, accounting, tax or legal advice. Check your own policies, auditors and local rules.

Use this template →See the example ↓

No account needed · Opens as your own editable page

Preview the bank reconciliation process

View full-size preview ↗
Bank reconciliation process example showing import, match and adjust steps, three kinds of unmatched item, worked reconciliation example
Everything in this example is editable. Replace the labels, move the shapes and adapt the layout to your work.

How to use this template

  1. Match what you can automatically

    Import the statement and let your system match routine items. Set rules for regular payments to cut the manual work.

  2. Sort the rest

    Group unmatched items as timing differences, bank charges or interest to post, and errors to correct. Each group has a different fix.

  3. Prove and sign off

    Show both adjusted balances agreeing, then have someone other than the preparer review and sign. File it with the close pack.

Questions about this template

Can I use the worked example with my own figures?

Yes. Replace the statement and ledger balances and the unmatched items, and the example shows how they reconcile to the same closing balance.

Do I need an account to use it?

No. Open the template and edit it in your browser. Your work saves on this device. An account is optional if you want to sync your workspace.

Can I export the finished diagram?

Yes. Use Export in the editor to save a PNG, SVG or PDF, or download an editable .epicdraw backup.

More Finance templates →