How to Do a Bank Reconciliation: Step-By-Step Process

Company A paid $3,750 worth of checks into its bank account and debited its cash book accordingly, but the bank has not yet credited the funds to the depositor’s account. As of 30 September 20XX, the ending debit cash balance in the accounting records of Company A was $1,500, whereas its bank account showed an overdraft of $500.

• A bank statement is a record, typically sent to the account holder every month, summarizing all transactions in an account during a set time period.
• To reconcile a bank statement cash balance, add back deposits in transit and deduct uncleared checks.
• Mark the item appearing in both records and identify any uncleared checks or deposits in transit.
• For example, a restaurant or a busy retail store both process a lot of transactions and take in a lot of cash.
• Given the amount of time required to complete the bank reconciliation process, some companies attempt to minimize its impact on the period-end closing process by running a daily reconciliation.

Make sure to check the prior month’s statement as well to ensure that any outstanding checks from the previous period have cleared this month. If a check has yet to clear, contact the payee to learn why. If the check is still outstanding after a month, it may be lost. You increase your cash account for the amount of the deposit immediately. The bank’s delay in posting the deposit means that you have a reconciling item. No matter how you do bank reconciliation, you’ll come across mystery transactions from time to time. There will be amounts that appear in one set of records but not the other.

Steps to Manually Reconcile a Bank Statement

There are times when a bank statement will fail to accurately reflect a company’s transactions. Common causes could be outstanding checks, bank errors or deposits that are still in transit. Whatever the reason, make the necessary changes to the bank statement.

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. For example, a restaurant or a busy retail store both process a lot of transactions and take in a lot of cash. They might reconcile on a daily basis to make sure everything matches and all cash receipts hit the bank account. On the other hand, a small online store—one that has days when there are no new transactions at all—could reconcile on a weekly or monthly basis. For the most part, how often you reconcile bank statements will depend on your volume of transactions. We’ll go over each step of the bank reconciliation process in more detail, but first—are your books up to date?

ADJUST THE BANK STATEMENTS

The bank transactions are imported automatically allowing you to match and categorize a large number of transactions at the click of a button. This makes the bank reconciliation process efficient and controllable. Outstanding checks are those that have been written and recorded in cash account of the business but have not yet cleared the bank account.

• Understated figures are also called undercast, while overstated figures are also called overcast.
• These are transactions in which payment is en route but the cash has not yet been accepted by the recipient.
• If there are any differences between the two, the company, through bank reconciliation, can identify those differences.
• To ensure that all transactions that effect your bank account have been properly recorded in your accounting system.
• Julia Kagan has written about personal finance for more than 25 years and for Investopedia since 2014.
• The difference between these two balances is due to reconciling items.

The company deposits its cash receipts in a bank checking account and writes checks to pay its bills. Keep in mind—a bank account is an asset to the company BUT to the bank, your account is a liability because the bank owes the money in your bank account to you. For this reason, in your bank account, deposits are credits and checks and other reductions are debits .

More about running your business

Consequently, the company’s general ledger cash account and its balance sheet will reflect the reconciled, adjusted, correct and true cash balance. The bank statement is reconciled when the adjusted cash balance as per bank equals the adjusted cash balance as per company books. As you compare your cash account activity to the bank, you may find errors that you made. For example, you might post the wrong dollar amount for a check or deposit to your cash records. If a $10 service fee is posted to the bank statement, for example, it would need to be deducted from the cash account. Until you post the amount to your cash records, it is a reconciling item.

• Cash and/or checks that have been received and recorded by an entity, but which have not yet been recorded in the records of the bank where the entity deposits the funds.
• Next, add interest to the cash balance in a company’s books and subtract bank fees and rejected checks.
• Understated and overstated are accounting terms that refer to inaccurate figures.
• Notice that the bank reconciliation form above still does not balance, even after including the outstanding checks.
• Bank charges are service charges and fees deducted for the bank’s processing of the business’ checking account activity.

By doing so, it may be easier to invest the residual funds, as well as to monitor the status of the investment. The bank may have recorded some deposits that the company did not record. If so, access the check image posted on the bank’s website to verify who issued the check and the amount of it.

Step 1: Adjust Bank Statement for Timing Differences

The bank adds its own fees and interest that must be accounted for and recorded in a company’s books as well. A bank reconciliation statement is produced after comparing the cash balance on a balance sheet to the corresponding balance on the bank statement.

A check for the amount of $470 issued to the office supplier was misreported in the cash payments journal as $370. Mary Girsch-Bock is the expert on accounting software and payroll software for The Ascent. The goal is to get your ending bank balance and ending G/L balance to match. Direct debit payments of $500 automatically deducted from the account. Subtract any drawn checks that have been written to make a payment but not yet cleared by the bank. “Very nice. This has helped me in preparing the reconciliation of my bank statement. Thank you.” If the discrepancy isn’t a bank error, it may represent fraudulent activity.

Step 2: Adjust Cash Account for Unrecorded Items

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. When each payment is reconciled with the bank statement, the system credits the VAT A/R Received account. For A/P transactions, after a processed check is reconciled with the bank, the system debits the VAT A/P Paid account. Accounting software enables a business to perform bank reconciliations on a more frequent basis.

A bank reconciliation is a critical tool for managing your cash balance. Reconciling is the process of https://www.bookstime.com/ comparing the cash activity in your accounting records to the transactions in your bank statement.

How to Prepare Bank Reconciliation? A Step-by-Step Guide

Large numbers of un-cashed checks can indicate a business owner or vendor or supplier is sloppy in maintaining his company’s accounting information. Avoiding this is one of the main uses of bank reconciliation statements. Outstanding bank and preparing a bank reconciliation ledger items will be marked so business owners can verify these items clear the company’s bank account in subsequent months. Business owners often keep bank reconciliations for several months in case they need to research bank transactions.