Go Back

Video: How to Reconcile a Bank Statement in QuickBooks Online

A fundamental step in keeping your finances organized and up-to-date is is to reconcile your bank statements in QuickBooks Online.

Reconciling a bank account in QuickBooks Online enables users to verify their transactions are recorded accurately, on the correct date, and during the right time period. Reconciling also helps you identify any fraudulent charges and mitigate any statement errors.

What is reconciliation?

Reconciliation is simply the process of matching the transactions on your bank statements with the transactions recorded in Quickbooks Online.

Before reconciling your bank accounts in QuickBooks Online, make sure all transactions have been recorded in your accounting software and you have your physical bank or credit card statements handy to compare them to your statements in Quickbooks.

Follow these 4 steps to reconcile your bank accounts in QuickBooks Online

Once you login to QuickBooks, you’ll be routed to your main dashboard (shown below). From your main dashboard, you can begin the reconciliation process in QuickBooks Online.

QuickBooks dashboard for bank reconciliation

Step 1:

To begin the reconciling process in QuickBooks Online, find the Accounting option on the left (gray) sidebar in your main dashboard. From the dropdown menu, select the Reconcile tab.

Open up the bank reconciliation tab

Step 2:

After clicking Reconcile, a new page will load with an Account dropdown menu for you to choose which account you’d like to reconcile.

Choose which account to reconcile inside QuickBooks Online

Once you’ve selected the account you wish to reconcile, the Beginning balance should appear. You can then reference your physical bank statements to input the Ending balance and Ending date into the prompts provided.

Enter your ending balance in QuickBooks Online

You can also click on the Bank Register button to open a new page which will display the Ending balance in the top right corner. If you use this option, make sure to cross-reference this information with your bank statements.

After you’ve entered all this information, click Start Reconciling.

Step 3:

The QuickBooks Online Reconcile page will display all your transactions during the time range you selected.

Match your bank statement transactions with the data in QuickBooks Online

This is where you’ll match your transactions listed on your physical bank or credit card statements with the information listed in QuickBooks Online.

Some of the transaction details listed in QuickBooks Online include the payment date, transaction type, account name, payee, payment amount, and more.

Once you’ve matched the transaction information from QuickBooks Online with your physical statements, you can select each transaction by clicking on the circle selection tool on the right side of the page. A checkmark will be auto-filled into each circle to confirm your transaction selection. Be sure to go through each transaction listed to ensure it’s accurate.

Once you’ve finished checking all of the transactions in QuickBooks Online, there should be a zero dollar difference displayed in the top right corner if all the information is correct.

Double check there's a $0 difference left in your reconciliation list

If there is not a zero-dollar difference, make sure all the information is entered correctly and there are no duplicate entries. You can also click on Edit info tab above the dollar difference to ensure your Ending balance is correctly matched with your bank statements balance.

Step 4:

After you’ve confirmed all your transactions match and there is a $0.00 difference, click the green Finish now button in the top right corner to reconcile your bank account in QuickBooks Online.

You'll get a confirmation message if the account was reconciled correctly

A pop-up notification will appear to notify you that your bank account has been reconciled.

For a full report of this reconciliation, you can click the View reconciliation report link to view a more detailed breakdown of the completed reconciliation. You can also view a full list of the reconciliations you’ve completed in Quickbooks Online by clicking the History by account link in the top left corner of this page.

If everything is reconciled correctly in QuickBooks Online, the beginning balance of next month’s statement (on the Reconcile page from Step 2) should match the ending balance of the previous month.

If you’d like to learn more about how you can reduce your credit card processing costs and simplify your accounts receivable in QuickBooks Online, visit https://ebizcharge.com/.

Share This Article!