The reconciliation process matches your QuickBooks records against your actual bank statement

Bank reconciliation in QuickBooks Online is the step where you confirm that the transactions recorded in your books match what your bank actually processed. You pull your bank statement—whether from your bank's website, email, or paper—and tell QuickBooks which transactions cleared and which are still pending. QuickBooks then flags any discrepancies so you can find missing deposits, duplicate entries, or timing differences before they become problems.

The process takes 10 to 30 minutes for a typical small business account, depending on how many transactions you have and whether everything matches on the first pass. You do not need to reconcile every single day, but most businesses do it monthly when the bank statement arrives.

Key Takeaways

  • Start reconciliation by opening your bank account in QuickBooks Online, clicking the account name, and selecting Reconcile from the menu.
  • Enter the ending balance from your bank statement and the statement date, then QuickBooks will show you which transactions have cleared.
  • Check off each transaction in QuickBooks that appears on your bank statement, working through deposits and withdrawals separately.
  • If your QuickBooks balance does not match your bank balance after checking off all cleared transactions, the difference amount tells you what to search for.
  • Uncleared transactions—those you recorded but the bank has not processed yet—stay unchecked and will reconcile in the next period.

Where to find the reconciliation tool in QuickBooks Online

Open QuickBooks Online and go to the left sidebar. Click Accounting, then Chart of Accounts. Find the bank account you want to reconcile and click its name. A menu will appear on the right side of the screen. Click Reconcile.

If you have connected your bank account through QuickBooks' direct bank feed feature, the reconciliation screen will already show transactions that your bank has sent to QuickBooks. If you have not connected your bank, you will see only the transactions you manually entered into QuickBooks, and you will need to type in the statement details yourself.

Entering your bank statement information

When you click Reconcile, QuickBooks asks for two pieces of information: the ending balance from your bank statement and the statement date. The ending balance is the total shown at the bottom of your statement. The statement date is the last day covered by that statement—usually the last day of the month.

Type both of these in exactly as they appear on your statement. QuickBooks uses the ending balance as the target number it is trying to match. If your statement shows $5,847.32 on June 30, enter 5847.32 and select June 30 from the date picker.

Checking off transactions that have cleared

After you enter the statement details, QuickBooks shows two lists: Deposits and other credits and Checks and payments. These are the transactions in your QuickBooks records. Your bank statement shows the same transactions, but sometimes in a different order.

Go through your bank statement line by line. For each transaction on the statement, find it in the QuickBooks list and click the checkbox next to it. This tells QuickBooks that the bank has processed that transaction. Work through all deposits first, then all withdrawals. If a transaction appears on your statement but not in QuickBooks, you will need to add it manually before you can check it off—QuickBooks will prompt you to do this.

Transactions that you recorded in QuickBooks but do not appear on the statement yet should stay unchecked. These are usually checks you wrote that have not cleared, or deposits you made near the end of the statement period. They will show up on next month's statement.

What to do when the balances do not match

After you check off all the transactions that appear on your statement, QuickBooks shows you the difference between your bank balance and your QuickBooks balance. If the difference is zero, you are done—click Finish now and the reconciliation is complete.

If there is a difference, QuickBooks tells you the amount. A difference of $50 means either you recorded a $50 transaction that the bank did not process, or the bank processed a $50 transaction you did not record. Start by searching your QuickBooks records for that exact amount. Look at the dates around your statement period—sometimes a deposit or check clears later than expected. If you find a transaction you missed, check it off. If you find a transaction in QuickBooks that should not be there, delete it or mark it as void.

If you cannot find the transaction, check your bank statement again for fees, interest, or automatic transfers you may have overlooked. Banks sometimes charge monthly fees or explore interest that you did not record in QuickBooks. Add these to QuickBooks, then check them off in the reconciliation.

Handling timing differences and outstanding items

The most common reason for a mismatch is timing. You might write a check on June 15, record it in QuickBooks when ready, but the recipient does not cash it until July 8. Your June statement will not show that check, so you leave it unchecked. Your QuickBooks balance will be lower than your bank balance by that check amount. This is normal and expected.

When July's statement arrives, that check will appear on it, and you will check it off then. Your balances will match. The same thing happens with deposits—you might deposit a check on June 28, record it in QuickBooks, but the bank does not process it until July 2. Leave it unchecked in June, and check it off in July.

QuickBooks keeps a running list of these outstanding items. After you finish reconciling, you can see which transactions are still pending by going back to the account and looking at the reconciliation history. This helps you understand why your QuickBooks balance differs from your bank balance on any given day.

Reconciling accounts connected to bank feeds

If you have set up a direct connection between QuickBooks Online and your bank, the reconciliation process is faster because QuickBooks already knows which transactions your bank has processed. The bank feed automatically downloads your transactions, and QuickBooks marks them as cleared on your behalf.

You still need to reconcile—to confirm that what QuickBooks received from the bank matches what you see on your statement—but you are mostly checking that nothing was missed or duplicated. If your bank feed is working correctly, you should see almost all transactions already marked as cleared when you open the reconciliation screen. You just need to verify the ending balance matches and click Finish.

If a transaction appears on your statement but not in QuickBooks, the bank feed may not have picked it up. This sometimes happens with transfers between accounts at the same bank, or with pending transactions that the bank has not fully processed. Add the transaction manually to QuickBooks, then check it off in reconciliation.

Frequently Asked Questions

What if I reconcile and then find a mistake in a transaction I already checked off?

You can undo a reconciliation by going back to the account, clicking Reconcile, and selecting the statement you want to undo. QuickBooks will uncheck all the transactions from that period so you can fix the mistake and reconcile again. You do not lose any data—you are just reopening that month's reconciliation.

Can I reconcile a credit card account the same way as a bank account?

Yes. The process is identical. You enter the statement balance and date from your credit card statement, check off the transactions that appear on it, and let QuickBooks match the balances. Credit card statements often include fees or interest charges that you need to add to QuickBooks before reconciling.

What does it mean if a transaction shows as pending in QuickBooks but cleared on my bank statement?

Your bank has processed the transaction, but QuickBooks has not received the confirmation yet. If you have a bank feed connection, wait a day or two and the status should update automatically. If you are entering transactions manually, you can mark it as cleared by checking it off during reconciliation.

Do I have to reconcile every month?

Monthly reconciliation is standard practice and catches errors early, but the timing depends on your business. If you reconcile quarterly or less often, the process takes longer because more transactions accumulate. Monthly reconciliation is faster and makes it easier to find mistakes because you have fewer transactions to review.

What if my bank statement shows a transaction I never recorded in QuickBooks?

During reconciliation, QuickBooks will ask if you want to add it. Click yes, and QuickBooks will create the transaction for you. You can then check it off when ready. This usually happens with bank fees, interest deposits, or automatic transfers you forgot to record.