Streamline your financial accounting with our Bank Reconciliation Statement Template, enabling accurate balance checks, discrepancy resolution, and audit readiness.
1
Obtain bank statement for the period concerned
2
Obtain cash book for the same period
3
Cross check and match payments in cash book with bank statement
4
Cross check and match deposits in cash book with bank statement
5
Identify and list any deposits in transit
6
Identify and list any outstanding checks
7
Calculate adjusted bank statement balance
8
Identify any bank charges or interest in bank statement that were not noted in cash book
9
Identify any direct deposits or collections by bank in bank statement that were not noted in cash book
10
Calculate adjusted cash book balance
11
Compare adjusted bank statement balance with adjusted cash book balance – any differences indicates errors
12
Investigate and correct any errors found
13
Prepare a draft bank reconciliation statement
14
Approval: Financial Manager
15
Update cash book with adjustments
16
File the bank reconciliation statement and supporting documents for audit trail
17
Update and close the ledger for the period
Obtain bank statement for the period concerned
In this task, you need to obtain the bank statement for the specific period you are reconciling. The bank statement provides a record of all the transactions that have taken place during that period. Obtaining the bank statement is crucial as it will serve as the basis for reconciling the cash book with the bank's records.
Obtain cash book for the same period
In this task, you need to obtain the cash book for the same period as the bank statement. The cash book is a record of all cash transactions made by the company. Obtaining the cash book is essential to compare and reconcile it with the bank statement.
Cross check and match payments in cash book with bank statement
In this task, you will cross check and match the payments recorded in the cash book with the transactions listed in the bank statement. This step is important to ensure that all payments made by the company are accurately recorded in both the cash book and the bank statement.
1
Matched
2
Not Matched
3
Need further verification
Cross check and match deposits in cash book with bank statement
In this task, you will cross check and match the deposits recorded in the cash book with the transactions listed in the bank statement. This step is crucial to ensure that all deposits received by the company are accurately recorded in both the cash book and the bank statement.
1
Matched
2
Not Matched
3
Need further verification
Identify and list any deposits in transit
In this task, you need to identify and list any deposits that have been made by the company but have not yet been recorded in the bank statement. These deposits are referred to as 'deposits in transit'. It is important to identify these deposits to ensure that they are recorded in the bank statement and properly reconciled.
Identify and list any outstanding checks
In this task, you need to identify and list any checks that have been issued by the company but have not yet cleared the bank. These checks are referred to as 'outstanding checks'. Identifying these checks is crucial to ensure that they are properly recorded in the bank statement and the cash book.
Calculate adjusted bank statement balance
In this task, you need to calculate the adjusted bank statement balance. To do this, you will take the beginning balance of the bank statement, add any deposits in transit, subtract any outstanding checks, and add or subtract any bank charges or interest not noted in the cash book. The adjusted bank statement balance reflects the accurate balance after considering these adjustments.
1
Add
2
Subtract
Identify any bank charges or interest in bank statement that were not noted in cash book
In this task, you need to identify any bank charges or interest that have been recorded on the bank statement but were not noted in the cash book. It is important to identify these charges or interest to ensure they are properly recorded in the cash book and considered in the bank reconciliation process.
Identify any direct deposits or collections by bank in bank statement that were not noted in cash book
In this task, you need to identify any direct deposits or collections made by the bank that have been recorded in the bank statement but were not noted in the cash book. These direct deposits or collections may include interest payments, loan disbursements, or other transactions made directly by the bank. Identifying these transactions is important to ensure they are properly recorded in the cash book and considered in the bank reconciliation process.
Calculate adjusted cash book balance
In this task, you need to calculate the adjusted cash book balance. To do this, you will take the beginning balance of the cash book, add any deposits in transit, subtract any outstanding checks, and add or subtract any bank charges or interest not noted in the bank statement. The adjusted cash book balance reflects the accurate balance after considering these adjustments.
1
Add
2
Subtract
Compare adjusted bank statement balance with adjusted cash book balance – any differences indicates errors
In this task, you need to compare the adjusted bank statement balance with the adjusted cash book balance. Any differences between the two balances indicate errors in either the cash book or the bank statement. Identifying these errors is crucial to ensure the accuracy of the bank reconciliation process. If differences are found, further investigation and correction are needed.
1
Matched
2
Not Matched
3
Investigation required
Investigate and correct any errors found
In this task, you need to investigate and correct any errors that have been identified during the comparison of the adjusted bank statement balance and the adjusted cash book balance. Errors can include missing transactions, discrepancies in amounts, or incorrect recording of transactions. Correcting these errors is vital to ensure the accuracy of the bank reconciliation process.
Prepare a draft bank reconciliation statement
In this task, you need to prepare a draft bank reconciliation statement. The bank reconciliation statement summarizes the adjustments made to the cash book and the bank statement to bring them into agreement. The statement provides a clear and concise overview of the reconciled balances and the reasons for any differences.
Approval: Financial Manager
Will be submitted for approval:
Prepare a draft bank reconciliation statement
Will be submitted
Update cash book with adjustments
In this task, you need to update the cash book with the adjustments made during the bank reconciliation process. This step ensures that the cash book reflects the corrected and reconciled balances. Updating the cash book accurately is important for maintaining accurate financial records.
File the bank reconciliation statement and supporting documents for audit trail
In this task, you need to file the bank reconciliation statement and all the supporting documents for the audit trail. Filing these documents ensures that there is a clear and organized record of the bank reconciliation process, making it easier for future reference and audits.
Update and close the ledger for the period
In this task, you need to update and close the ledger for the period covered by the bank reconciliation. Updating the ledger involves recording the adjustments made during the bank reconciliation process, ensuring that all transactions are accurately reflected in the financial records. Closing the ledger finalizes the accounts for the period, preparing them for the next accounting cycle.