Keywords: Banking, Reconciling, Transaction, Viewing Statement, Quickbooks.
Credit: Intuit-Quickbooks Online  Photo By: FP
Struggling to Keep Your Books in Order? 📊📅
Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.
👉 Click Here for a Free Consultation!
Let’s start with the first task in the occasional workflow and look at the bank or credit card account statement. If the bank account is connected to the Banking center, you can easily access the information needed to start the reconciliation. You’ll need the ending balance for the period you’re reconciling and the statement ending date.

Step 1 ;
- Select Transactions in the left-hand menu, and then go to the Reconcile tab.
- From the Account dropdown, select the account to reconcile.
- Select View Statements.
- If View statements are not available, there might be an Enroll now option. Selecting this guides you through allowing QuickBooks to access and download the statements. It’s a very good idea to enroll for statement auto-import so you don’t need to ask for your statement every month.

Step 2 ;
- Two lists of statements are displayed: those to be reconciled and those that have already been done.
- Select the statement to be reconciled and make a note of the ending balance. ( You can have the bank statement open while doing the reconciliation. If you have two monitors or a split screen, you can view the statement and the reconciliation side by side.)
- Select Done to return to the Reconcile page to begin the reconciliation.
- Note : If your bank doesn’t automatically upload bank statements to QuickBooks, you should upload them for record keeping purposes at the end of reconciling when prompted, or by selecting the History by account option from the Reconcile screen.
Reconcile the account in QuickBooks Online.
Let’s move on to the second task, which is to carry out the reconciliation. The Reconcile tool makes it easy to reconcile accounts and find discrepancies between QuickBooks accounts and the bank or credit card statement.

Step 1;
- In the Reconcile screen, from the Account dropdown, select the account to reconcile.
- From the bank statement, enter the ending balance and the ending date, and then you are ready to Start Reconciling

Step 2 ;
- There is an overview at the top of the reconciliation dashboard. It shows the difference between the Statement ending balance and the Cleared balance in QuickBooks.
- The Statement ending balance is the number you entered on the previous screen.

Step 3 ;
- The Cleared balance is calculated by taking the beginning balance minus Payment plus Deposits that have check marks next to them.
- Checkmarks indicate transactions that were cleared because they were added or matched from the bank feeds, or because you manually checked them off after comparing against the bank statement.

Step 4;
- QuickBooks calculates the Beginning balance based on the sum of all transactions previously marked reconciled. It should be the same as the prior period’s ending balance on the statement.
- The Difference is the all-important number you want to get to zero. It automatically updates when you include or exclude a transaction. QuickBooks and the bank agree when the difference equals $0.00.
- But remember, this must be a robust zero- you need to be sure that you’ve looked into any unclear transactions and that you are confident all is as it should be before you go ahead and accept that zero.

Step 5 ;
- To reconcile, compare the list of transactions on the bank statement with the transactions on this screen.
- There’s already a checkmark next to the transactions that were previously added when managing the bank feeds. And the icons in the column next to the Memo column indicate transactions that have come directly from the bank account.

Step 6 ;
- Start with the first transaction on the statement.
- Find the same transaction in the Reconcile list in QuickBooks.
- Compare the two transactions, if the match, put a checkmark next to the amount in QuickBooks.
- This marks it as cleared. If the transaction was added or matched from the bank feeds, it will already be checked.

Step 7 ;
- If a transaction doesn’t appear on the statement but you see it in QuickBooks, don’t select the checkmark next to it
- Investigate to determine if this is a duplicate transaction or perhaps even in the wrong bank or credit card account in QuickBooks.
- You should see most transactions in Quickbooks clear the bank in a timely manner and not remain on this list for a very long time.

Step 8;
- If you’re sure you’ve found a match but something small isn’t quite right, like the payee is missing, don’t worry.
- Select the transaction in QuickBooks to expand the view.
- Then select Edit. Make the edits so the details match the statement.
- When you reach the end, the difference between the statement and QuickBooks should be $0.00.
- If it is, the Finish now button will appear and you click on it.
Check out our Free Additional Articles

