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!  
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
REIT Financial Model Template
This REIT financial model template acts as a guideline for modeling a real estate investment trust (REIT). This model will…
Energy Industry Comps Template Energy Industry Comps Template
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
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
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
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
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
See All