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

Posted by

a bank reconciliation should be prepared

If a company has more than one bank accounts, it will need to carry out the process for each account separately. After identifying the reasons your bank statement https://www.bookkeeping-reviews.com/ doesn’t match accounting records, you have to update your records. If the bank has made errors, notify them so that they correct the transactions.

a bank reconciliation should be prepared

This is where your accounting software can help you reconcile and keep track of outstanding checks and deposits. Most reconciliation modules allow you to check off outstanding checks and deposits listed on the bank statement. Bank Reconciliation is the process of comparing your business’ books of accounts with your bank statements. It is done periodically to check whether the bank-related transactions are recorded properly in your books of accounts. Bank reconciliation is the process of matching the bank balances reflected in the cash book of a business with the balances reflected in the bank statement of the business in a given period. Such a process determines the differences between the balances as per the cash book and bank passbook.

Your All-Encompassing Guide to Bank Reconciliations

And if you’re consistently seeing a discrepancy in accounts receivable between your balance sheet and your bank, you know you have a deeper issue to fix. 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. Therefore, you record no entry in the business’ cash book for the above items. There are times when your business entity deposits a cheque or draws a bill of exchange discounted with the bank.

  1. The company may need to repeat the process until the balance becomes zero, or it identifies any errors.
  2. Bank Example 2 showed that the bank debits the depositor’s checking account to decrease the checking account balance (since this is part of the bank’s liability Customers’ Deposits).
  3. The solution will securely import data from both the ERP or general ledger systems and bank files or statements.
  4. You need to make sure that all the deposits you’ve recorded in the books reflect in the bank statement.

This will ensure your unreconciled bank statements don’t pile up into an intimidating, time-consuming task. If you do your bookkeeping yourself, you should be prepared to reconcile your bank statements at regular intervals (more on that below). If you work with a bookkeeper or online bookkeeping service, https://www.quick-bookkeeping.net/ they’ll handle it for you. Any credit cards, PayPal accounts, or other accounts with business transactions should be reconciled. Nowadays, many companies use specialized accounting software in bank reconciliation to reduce the amount of work and adjustments required and to enable real-time updates.

Therefore, a check dated June 29 will be recorded in the company’s accounts using the date of June 29, even if the check clears (is paid through) the company’s bank account one week later. So, to reconcile the amounts, you simply add the additions (interest income) and subtract the subtractions (bank charges and overdraft fees) to reach the bank balance. Ideally, the balance in your books is the same as the closing bank balance. It’s possible there are additional transactions on the bank statement that you may not have in your records.

Step 4: Make adjustments to the books

That is why one will often see bank notices that deposited funds cannot be withdrawn for several days. Such restrictions are intended to make sure that a deposit clears the bank on which it is drawn before releasing those funds. Enhanced electronic clearing procedures adopted by banks have made kiting far more difficult to accomplish. Doing them monthly after receiving the bank statements helps the financial department to close off the month and carry over the balance to the next one.

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. For instance, if you haven’t reconciled your bank statements in six months, you’ll need to go back and check six months’ worth of line items. Whether this is a smart decision depends on the volume of transactions and your level of patience.

a bank reconciliation should be prepared

Once you complete the bank reconciliation statement at the end of the month, you need to print the bank reconciliation report and keep it in your monthly journal entries as a separate document. 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. Thus, such debits made by the bank directly from your bank account lead to a difference between the balance as per cash book and the balance as per the passbook.

Reduce reconciliation delays and optimize your cash flow management with HighRadius!

Cash management software allows businesses to gather real-time cash positions across the organization, helping to make better business decisions based on accurate data. Some businesses, which have money entering and leaving their accounts multiple times every day, will reconcile on a daily basis. Bank reconciliations are like a fail-safe for making sure your accounts receivable never get out of control.

Find out the reason for the additional or missing bank transactions before making adjustments. After you’ve received bank statements, establish the last reconciled transaction from the previous period and begin there. 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.

If you’re not careful, your business checking account could be subject to overdraft fees. When you do a bank reconciliation, you first find the bank transactions that are responsible for your books and your bank https://www.online-accounting.net/ account being out of sync. You only need to reconcile bank statements if you use the accrual method of accounting. This is to confirm that all uncleared bank transactions you recorded actually went through.

Required Information to Create a Bank Reconciliation Statement

If you use accounting software, then your reconciliation is done largely for you. However, as a business owner, it’s important to understand the reconciliation process. For some entrepreneurs, reconciling bank transactions creates a sense of calm and balance. If you’re in the latter category, it may be time to think about hiring a bookkeeper who will do the reconciling for you.

Match Deposits and Withdrawals to the Balance Sheet

This allows the company to verify its checking account balance more frequently and to make any necessary corrections much sooner. Bank reconciliation plays a crucial role in the internal control process of a company and helps in detecting fraud and error in the process. When preparing a bank reconciliation, the company must look for two types of differences, timing and unrecorded differences.

Leave a Reply

Your email address will not be published. Required fields are marked *