Bank Reconciliation: Purpose, Example, Process

When you compare the balance of your cash book with the balance showcased by your bank passbook, there is often a difference. One of the primary reasons this happens is due to the time delay in recording the transactions of either payments or receipts. Book transactions are transactions that have been recorded on your books but haven’t cleared the bank.

Step 4: Confirm the Bank Reconciliation Has a Difference of Zero

You’ll need a few items to perform a bank reconciliation, including your bank statement, internal accounting records, and a record of any pending cash transactions (either inflows or outflows). Yes, you can generate bank reconciliation reports in QuickBooks Online. These reports provide a summary of the reconciled transactions and help you review the reconciliation process and its results. Many bank statements will separately summarize deposits and withdrawals as does the summary at the top of the QuickBooks reconciliation screen. First, try to match total bank deposits to total QuickBooks deposits by reviewing only deposit transactions.

QuickBooks organizes your data for you, making bank reconciliation easy. When all these adjustments have been made to the books of accounts, the balance as per the cash book must match that of the passbook. If both the balances are equal, it means the bank reconciliation statement has been prepared correctly. Just like balancing simple interest calculator with regular deposits withdrawals your checkbook, you need to regularly review your accounts in QuickBooks.

If it is, then click the green Finish now button in the upper right-hand corner of the screen, as seen in the sample completed reconciliation below. After adjusting the balance as per the cash book, you’ll need record all adjustments in your company’s general ledger accounts. When your balance as per the cash book does not match with your balance as per the passbook, there are certain adjustments that you have to make in order to balance the two accounts. This way, the number of items that can cause the difference between the passbook and the cash book balance is reduced.

As a small business, you may find yourself paying vendors and creditors by issuing check payments. Note that this process is exclusively for reconciliations performed by hand. 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.

1. Keeping your financial records in order is hugely important to the success of your business.
2. When you’re done reviewing your statement, you’ll know everything made it into QuickBooks.
3. If you still can’t fix the discrepancy, we cover troubleshooting tips on finding the difference later on, after Step 5.
4. Compare the ending balance of your accounting records to your bank statement to see if both cash balances match.
5. We prefer and recommend using the Accountant View because it shows a full range of business accounting features and tools that you can use in QuickBooks.

Common accounting mistakes business owners make

Once the adjusted balance of the cash book is worked out, then the bank reconciliation statement can be prepared. NSF checks are an item to be reconciled when preparing the bank reconciliation statement, because when you deposit a check, often it has already been cleared by the bank. But this is not the case as the bank does not clear an NFS check, and as a result, the cash on hand balance gets reduced.

Step 2: Select the Bank Account to Reconcile

And as a result, it gets easier to ascertain the correct balance in the balance sheet. Therefore, an overdraft balance is treated as a negative figure on the bank reconciliation statement. After adjusting all the above items, you’ll end up with the adjusted balance as per the cash book, the social security which must match the balance as per the passbook. If you adjusted a reconciliation by mistake or need to start over, reach out to your accountant.

Join over 6.5 million customers globally.1 Find the QuickBooks plan that works for your small business.

By diligently following the steps outlined in this guide, you’re not just reconciling accounts — you’re reconciling your financial aspirations with your financial reality. In doing so, you pave the way for a thriving and sustainable future for your business. We offer reconciliation reports, discrepancy identification, and live accountants to work with for ease and confidence when closing your books. It’s important to perform a bank reconciliation periodically to identify fraudulent activities or bookkeeping and accounting errors.

This report is useful if you have trouble reconciling the following month. Your bank may collect interest and dividends on your behalf and credit such an amount to your bank account. Typically, the difference between the cash book and passbook balance arises due to the items that appear only in the passbook. So it makes sense to record these items in the cash book first in order to determine the adjusted balance of the cash book.

When you’re done reviewing your statement, you’ll know everything made it into QuickBooks. Below, we delve into a detailed explanation of the account reconciliation process within QuickBooks. Now, simply how to hold effective nonprofit board meetings compare the transactions on your statement with what’s in QuickBooks.