Overview
A bank reconciliation statement is a tool that is used on a periodic basis to ensure that the company’s cash balances are correct. They can also be a good auditing tool to help detect cash manipulations and fraud. They are also useful in detecting if any accounting changes are needed. Download this free bank reconciliation statement template to start matching your company's cash balance on the balance sheet to the amount on its bank statement. There are a few differences between the bank statement and the accounting record of a company, causing the cash balances on the two sides to rarely be the same. Things such as deposits in transit (cash and checks received but have not been recorded on the bank statement), outstanding checks, bank service fees, and interest income are the most common reasons for the discrepancies in cash balances.

Bank Reconciliation Procedure

Below are the steps to reconciliating a company's cash balance using this Bank Reconciliation Statement Template:
  1. On the bank statement, compare the company’s list of issued checks and deposits to the checks shown on the statement to identify uncleared checks and deposits in transit.
  2. Using the cash balance shown on the bank statement, add back any deposits in transit.
  3. Deduct any outstanding checks.
  4. This will provide the adjusted bank cash balance.
  5. Next, use the company’s ending cash balance, add any interest earned and notes receivable amount.
  6. Deduct any bank service fees, penalties, and NSF checks. This will arrive at the adjusted company cash balance.
  7. After reconciliation, the adjusted bank balance should match with the company’s ending adjusted cash balance.

Learn More on This Topic

Read CFI's guide on bank reconciliation to understand the difference between bank statement and company's accounting record, recap the whole procedure, and go through an example to learn how to construct the bank reconciliation statement!  
Share
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Energy Industry Comps Template Energy Industry Comps Template
240
13
This energy industry comps template provides a guideline and example of what a comparables universe would look like for a…
Financial Institution Dividend Discount Model
842
16
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
527
0
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
655
52
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
583
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
restructuring financial model template preview 1 Restructuring Financial Model Template
849
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…