Bank Reconciliation Example 4 Examples Steps + Excel Template

Their bank balance closes at $1,000 on 31st March 2023, and the cash book shows the balance of $1,050. Here, we need to create a reconciliation statement by adjusting the balance with the help of the following details. The purpose of the bank reconciliation is to be certain that the company’s general ledger Cash account is complete and accurate. With the true cash balance reported in the Cash account, the company could prevent overdrawing its checking account or reporting the incorrect amount of cash on its balance sheet. The bank reconciliation also provides a way to detect potential errors in the bank’s records. Before the reconciliation process, business should ensure that they have recorded all transactions up to the end of your bank statement.

Before you reconcile your bank account, you should ensure that you record all the transactions of your business until the date of your bank statement. But, you will record such transactions only in your business’ cash book only when you receive the bank statement. Until then, your balance as per the cash book would differ from the balance as per the passbook. NSF cheques are an item to be reconciled while preparing the bank reconciliation statement. This is because when you deposit a cheque in your bank account, you consider that the cheque has been cleared by the bank. Such deposits are not showcased in the bank statement on the reconciliation date.

Companies or individuals can use this general ledger (GL) reconciliation template for bank reconciliation. Businesses can also use it for reconciling balance sheet accounts, such as accounts payable, by editing the template to show the appropriate account information. Enter the balance from your bank statement or subledger along with the general ledger balance, and adjust amounts based on outstanding deposits and checks. If they are not reconciled, you can examine the records for errors or other discrepancies that need to be resolved.

You will know about such information only when you receive the bank statement at the end of the month. Therefore, you record no entry in the business’ cash naic consumer alert: property insurance book for the above items. At times, you might give standing instructions to your bank to make some payments regularly on specific days to the third parties.

If you find any errors or omissions, determine what happened to cause the differences and work to fix them in your records. After adjusting the balance as per the cash book, make sure that you record all adjustments in your company’s general ledger accounts. There are times when the bank may charge a fee for maintaining your account. Therefore, while preparing a bank reconciliation statement you must account for any fees deducted by the bank from your account.

The final step in the bank reconciliation process is to record journal entries to complete the balancing process. It’s common for your bank statement to have a higher ending balance than your G/L account shows. While it may be tempting to assume you have more money in the bank than you think, it’s a safe bet that the difference is checks and other payments made that have not yet hit the bank. When you record the reconciliation, you only record the change to the balance in your books. The change to the balance in your bank account will happen “naturally”—once the bank processes the outstanding transactions.

  1. Reconciling the two accounts helps determine if accounting changes are needed.
  2. The final step in the bank reconciliation process is to record journal entries to complete the balancing process.
  3. Such cheques are the ones that have been issued by your business, but the recipient has not presented them to the bank for the collection of payment.
  4. Bank errors are mistakes made by the bank while creating the bank statement.
  5. ABC Corp, has a balance of $2000 as per passbook as on 31st march 2021.

You’ll need to account for these fees in your G/L in order to complete the reconciliation process. Those payments are recorded in your G/L, but they have yet to hit the bank. You need to subtract both checks from your bank balance, as well as any other checks listed in your check register that haven’t cleared. The easiest way to check for this is to print a check register for the month and compare it to the checks that have cleared the bank. Any checks that have been issued that haven’t cleared the bank must be accounted for under your bank balance column. If you commonly make deposits into your account, you’ll want to compare your bank account deposit totals to those listed in your general ledger.

Depending on how you choose to receive notifications from your bank, you may receive email or text alerts for successful deposits into your account. Contact your bank to investigate further and find where the issue lies. Once solved, be sure to adjust your records to reflect deposits as needed. Next, check to see if all of the deposits listed in your records are present on your bank statement. Whatever method you prefer, it’s important to keep solid records of every transaction to reconcile your bank account properly. This is done by taking into account all the transactions that have occurred until the date preceding the day on which the bank reconciliation statement is prepared.

Therefore, it makes sense to first record these items in the cash book to determine the adjusted balance of the cash book. However, in the bank statement, such a balance is showcased as a debit balance and is known as the debit balance as per the passbook. The above case presents preparing a bank reconciliation statement starting with positive bank balances. As mentioned above, debit balance as per the cash book refers to the deposits held in the bank. This balance exists when the deposits made by your business at your bank are more than the withdrawals.

CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path. However, there can be situations where your business has overdrafts at the bank. The Ascent is a Motley Fool service that rates and reviews essential products for your everyday money matters.

Daily Cash Flow Template

As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy. Bank reconciliation helps to identify errors that can affect estimated tax payments and financial reporting. Kevin Payne is a personal finance and travel writer who covers credit cards, banking, and other personal finance topics. In addition to Forbes, his work has been featured by Bankrate, Fox Business, Slick Deals, and more.

Create a free account to unlock this Template

After careful investigation, ABC Holding found that a vendor’s check for $20,000 hadn’t been presented to the bank. It also missed two $25 fees for service charges and non-sufficient funds (NSF) checks during the month. Bank reconciliation statements compare transactions from financial records with those on a bank statement. Where there are discrepancies, companies can identify and correct the source of errors. There could be transactions unaccounted for in your personal financial records because of a bank adjustment. This may occur if you were subject to any fees, like a monthly maintenance fee or overdraft fee.

Timing Differences in Recording of Transactions

However, there might be a situation where the receiving entity may not present the cheques issued by your business to the bank for immediate payment. Therefore, such adjustment procedures help in determining the balance as per the bank that goes into the balance sheet. Not Sufficient Funds (NSF) refers to a situation when your bank does not honour your cheque.

Five key points you may want to know about our Bank Reconciliation Software

Whereas, credit balance as the cash book indicates bank overdraft or the excess amount withdrawn from your bank account over the amount deposited. The easiest way to find these adjustments when completing a bank reconciliation is to look at the bank fees. You’ll also want to look at any miscellaneous deposits that haven’t been accounted for. Once you locate these items, you’ll need to adjust your G/L balance to reflect them.

To safeguard this critical and tempting asset, a company should establish internal controls over its cash. Effective bank reconciliation process offers various advantages to businesses. It allows businesses to identify any expected payments that haven’t been made, and detect fraud. Bank reconciliation can also help businesses quickly identify any disruptions in their cash flow. To quickly identify and address errors, reconciling bank statements should be done by companies or individuals at least monthly. They also can be done as frequently as statements are generated, such as daily or weekly.

Therefore, the bank needs to add back the cheque’s amount to the bank balance. Such errors are committed while recording the transactions in the cash book. As a result, the balance as per the cash book differs from the passbook. At times, the balance as per the cash book and passbook may differ due to an error committed by either bank or an error in the cash book of your company. Thus, such a situation leads to the difference between bank balance as per the cash book and balance as per the passbook. These items are typically service fees, overdraft fees, and interest income.