Templates /
Bank Reconciliation Template

Bank Reconciliation Template

Use this checklist to reconcile your internal financial records with your bank statement on a daily basis.
1
Introduction:
2
Daily tasks:
3
Print daily declaration
4
Add all cash taken over the day's sales
5
Fill in bank deposit slips
6
Record in the cash receipts journal
7
File declaration, cash records, and copy of deposit slips
8
Deposit cash in the bank
9
Daily reconciliation:
10
Tick off bank statement against cash receipts journal (CRJ)
11
Tick off bank statement against cash payments journal (CPJ)
12
Check for any bank errors
13
Record bank errors
14
Add unticked credits to the CRJ
15
Add unticked debits to the CPJ
16
Check every item on the bank statement is ticked
17
Calculate the bank balance
18
Prepare bank reconciliation
19
Verify the two results
20
Contact the bank to notify them of errors
21
Sources:
22
Related checklists:

Introduction:

This checklist will guide you through the necessary steps to check your internal financial activity lines up with the financial activity recorded on your bank statement.

It is important to know whether all expected payments have been recorded as this helps you note any potential mistakes made by the bank. 

This bank reconciliation process works on a daily basis.

You can watch the video below for a quick visual explanation of the process.

Daily tasks:

Add all cash taken over the day’s sales

Adding the cash from the registers seems like a simple process, but it is important to include a series of checks along the way. 

Follow the steps laid out in this subchecklist to complete your cashing-up process.

  • 1

    Add all cash taken over the course of the day’s trading
  • 2

    Record this information
  • 3

    Less the float(s) from cash registers
  • 4

    Check against the declaration statement
  • 5

    Double count the cash
  • 6

    Record any variance
  • 7

    Bag all cash separately for the bank

Fill in bank deposit slips

Fill in the bank deposit slips with the appropriate names, addresses, and account numbers

Be sure to document the quantity of cash correctly on the deposit.

For some banks, this may be a simple paper form and for others, it may be a form printed on to the deposit bag itself. 

Record in the cash receipts journal

Record the details of the sales takings in your cash receipts journal

You will need to consult the cash receipts journal when running the bank reconciliation.

File declaration, cash records, and copy of deposit slips

File all the documents safely in case they are needed later for further review or audit. 

It’s important to develop a clear and comprehensive filing system to make sure you are always on top of your historical paperwork. 

Deposit cash in the bank

Take all the cash takings, plus any checks, to the bank to be deposited and collect a bank statement.

Daily reconciliation:

Tick off bank statement against cash receipts journal (CRJ)

Compare the figures on the bank statement with the figures on the cash receipts journal.

Where two figures for transactions are present on both, put a tick next to each of them.


Tick off bank statement against cash payments journal (CPJ)

Compare the figures on the bank statement with the figures on the cash payments journal.

Where two figures for transactions are present on both, put a tick next to each of them.


Check for any bank errors

Sometimes banks can make mistakes. Part of the purpose of a bank reconciliation process is to find these mistakes and account for them.

Some common mistakes can be the fault of data entry. For example, the bank may have recorded a payment of $524 when it should have been $254. 

Be sure to carefully check for any errors before moving on. 


Record bank errors

Record the errors you have found in the statement.


In order to easily contact your bank manager to report the errors at the end of the checklist, fill in their contact details below. 

Bank manager contact details




Add unticked credits to the CRJ

From your unticked lists, you want to run through the bank statement to find any unticked credits. 

This refers to credits that have been recorded by the bank but are not present in your cash receipts journal. Add these unticked credits into the CRJ and then tick them off.

Update your cash receipts journal to reflect these omissions. 

Add unticked debits to the CPJ

Once you’ve added any unticked credits to the CRJ, repeat the process for unticked debits. 

Add these unticked debits into the CPJ and then tick them off.

Update your cash payments journal to reflect these omissions. 

Check every item on the bank statement is ticked

After entering your unticked debits into your CPJ and your unticked credits into your CRJ, ticking each transaction off the bank statement as you go, you should be left with a fully ticked off bank statement.

Calculate the bank balance

Instead of just looking at the bank balance, we want to calculate the bank balance to know what it should be – rather than simply what the statement says.

Begin with the balance as recorded at the end of the previous day’s reconciliation

Add the receipts total to this opening bank balance, and then subtract the payments total.

The final answer should record the “real” bank balance.

Record that figure below in the form field.


Prepare bank reconciliation

Start with the bank balance from the bank statement. Add all the unticked receipts and then less the unticked payments

This should provide you with an amended version of the bank statement bank balance.

Record the final figure below.


Verify the two results

Now compare the “real” bank balance calculated in task 17 with the adjusted bank statement balance calculated in task 18.

“Real” bank balance: {{form.”Real”_bank_balance}}

Adjusted bank statement balance: {{form.Adjusted_bank_statement_balance}}

These two numbers should be the same, and the balance reconciled. 

If they are not the same, check your maths by reviewing all calculations and begin the reconciliation again from task 10 if necessary.

Contact the bank to notify them of errors

If you recorded any bank errors in task 12, you should contact the bank to notify them

Either contact by phone, or if you have the email address of your bank manager use the email widget below.

Sources:

Take control of your workflows today.