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
Financial Institution Dividend Discount Model
332
0
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
246
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
304
23
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
296
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
527
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
699
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…