Home Uncategorized How To Do Bank Reconciliation

How To Do Bank Reconciliation

written by Barry and Joyce Vissell January 8, 2021

how to prepare a bank reconciliation

Deposit in transit refers to any checks that the company has received from another party, mostly customers. Deposits in transit are also checks that the company has presented to the bank, but the check did not clear before the preparation of the bank statement. Apart from fraud, bank reconciliation can also help a company detect errors. Performing regular bank reconciliation can help the company identify any issues within its internal processes related to bank transactions that may result in errors. It can, in turn, help the company improve its bank processes and make them more efficient and effective.

  1. Therefore, you record no entry in the business’ cash book for the above items.
  2. For simplicity, our examples and discussion assume that the company has only one checking account with one general ledger account entitled Cash.
  3. As a result, the balance as per the cash book differs from the passbook.
  4. The statement also includes bank charges such as for account servicing fees.
  5. It can, in turn, help the company improve its bank processes and make them more efficient and effective.

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. For interest-bearing accounts, a bank adjustment could be the amount of interest you earned over the statement period. While a business may choose to prepare its bank reconciliation statement at any time, it is best to prepare it once per month after you receive the bank statement for your business.

Some mistakes could adversely affect financial reporting and tax reporting. Without reconciling, companies may pay too much or too little in taxes. 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. Typically, the difference between the cash book and passbook balance arises due to the items that appear only in the passbook. Therefore, it makes sense to first record these items in the cash book to determine the adjusted balance of the cash book.

Our picks for 2024’s best credit cards

When you’re completing a bank reconciliation, the biggest difference between the bank balance and the G/L balance is outstanding checks. If a bank reconciliation is off by a very small amount, it is usually due to rounding errors. Similarly, it can also be because the preparer of the bank reconciliation has missed some expense from the bank statement.

It also missed two $25 fees for service charges and non-sufficient funds (NSF) checks during the month. In addition to this, the interest or dividends earned on investments is directly deposited into your bank account after a specific period of time. Therefore, you need to pass a journal entry in your books of accounts showcasing the increase in cash balance due to the interest or dividend earned.

In accounting, a company’s cash includes the money in its checking account(s). To safeguard this critical and tempting asset, a company should establish internal controls over its cash. When you do a bank reconciliation, you first find the bank transactions that are responsible for your books and your bank account being out of sync. You only need to reconcile bank statements if you use the accrual method of accounting.

In this guide, we’ll explain exactly why doing a bank reconciliation is so important, and give you step-by-step instructions on how to complete one. 💡 If you are an accounting student, we have several business accounting calculators that may interest you. Be sure to visit our business budget calculator and the cost of doing business calculator. The longer you go without doing it, the longer it will take to catch up. It won’t just be that you have more transactions to do, it will take longer per transaction because you’ll have a harder time recalling the details.

If you work with a bookkeeper or online bookkeeping service, they’ll handle it for you. Automating bank reconciliation can bring numerous benefits to a business, including increased accuracy, productivity, and cost savings. By using software tools to automate bank reconciliation, businesses can focus on other critical tasks and make informed business decisions based on accurate financial data. If your beginning balance in your accounting software isn’t correct, the bank account won’t reconcile. This can happen if you’re reconciling an account for the first time or if it wasn’t properly reconciled last month.

Steps to Prepare Bank Reconciliation Statement

In addition, there may be cases where the bank has not cleared the cheques, however, the cheques have been deposited by your business. Therefore, the bank needs to add back the cheque’s amount to the bank balance. In such a case, you simply need to mention a note indicating https://www.quick-bookkeeping.net/ the reasons for the discrepancy between your bank statement and cash book. From the following particulars of Zen Enterprises, prepare a bank reconciliation statement as of December 31, 2021. Therefore, you record no entry in the business’ cash book for the above items.

how to prepare a bank reconciliation

This makes the bank reconciliation process efficient and controllable. How you choose to perform a bank reconciliation depends on how you track your money. Some people rely on accounting software or mobile apps to track financial transactions and reconcile banking activity. Others use a paper checkbook, and balance it each month, to keep a record of any written checks and other transactions.

What is a bank reconciliation statement?

This is why you’re doing bank rec, and there’s often a straightforward explanation. This includes things like bank fees, which you might not have accounted for yet. This might be in a logbook, on a spreadsheet, or in an accounting software package. Some https://www.online-accounting.net/ accounting software will pull in bills and receipts with the help of data capture tools and extract the data automatically. Reconciling bank statements typically happens at the end of each month when your financial institution sends over your statement.

The next step in preparing a bank reconciliation statement is to identify the reason for the differences. Usually, there are two categories of differences that may cause differences between the two balances. As mentioned above, these include timing differences and unrecorded differences. The reason why companies must categorize the differences is that the treatment for both is different. First of all, compare the records in the company’s bank statement and ledger cash account.

Similarly, it is a good practice for companies to maintain a separate bank book for each corresponding bank account. When the company pays the bill, it debits accounts payable and credits the cash account. Again, the left (debit) and right (credit) sides of the journal entry should agree, reconciling to zero. The frequency of reconciling bank statements depends on the size and complexity of the business and its transaction volume. Cloud accounting software like Quickbooks makes preparing a reconciliation statement easy. Because your bank account gets integrated with your online accounting software, all your bank transactions get updated automatically.

The Benefits of Automating Your Bank Reconciliation

First, make sure that all of the deposits listed on your bank statement are recorded in your personal record. If not, add the missing deposits to https://www.kelleysbookkeeping.com/ your records and your total account balance. The goal of bank account reconciliation is to ensure your records align with the bank’s records.

All of this can be done by using online accounting software like QuickBooks. In case you are not using accounting software, you can use Excel to record such items. At times, your business entity may omit or record incorrect transactions for cheques issued, cheques deposited, the wrong total, etc. You will know about such information only when you receive the bank statement at the end of the month. As a result of such direct payments made by the bank on your behalf, the balance as per the passbook would be less than the balance as per the cash book.

Related Articles

Log In

Lost Password


The first step to becoming a member of the RD&T Community and the beginning of your personal Journey to Ultimate Success:

Join Now

Click the button below to register for a free membership and have access to unlimited articles.