Reconciling your bank account ensures your financial records match reality. When you know how to do a bank reconciliation in QuickBooks Online, you catch missing expenses and prevent tax-time surprises. Many business owners skip this step because they assume the bank feed handles everything automatically. The bank feed only imports data. Reconciliation proves that data is accurate and complete. If you skip this process, you risk making decisions based on inflated cash balances or missing deductions. You can learn more about these risks in our guide on why your QuickBooks reports do not match your bank account.
Prerequisites before you start reconciling
Before clicking the reconcile button, you need to prepare your workspace. The most common point of confusion for beginners is the difference between the Banking tab and the Reconcile tab. The Banking tab is your staging area. This is where you categorize imported transactions, assign vendors, and select expense accounts. The Reconcile tab is where you verify those categorized transactions against your actual bank statement.
You must categorize all bank feed transactions for the statement period before starting the reconciliation process. If you leave items in the For Review tab, they will not show up in the reconciliation window. Have your official bank statement ready, either as a PDF or a printed copy. Do not rely solely on your online banking dashboard, as the running balance can change based on pending transactions. Use the finalized monthly statement. If your team needs help establishing these daily habits, we offer customized QuickBooks training and support to get everyone on the same page.
Once your bank feed is clear and your statement is in hand, you are ready to begin matching records.
Step-by-step guide: how to do a bank reconciliation in QuickBooks Online
Start by navigating to the left menu in your dashboard. Click on Accounting, then select Reconcile. If you do not see this option, check your user permissions. Choose the specific bank or credit card account from the dropdown menu.
QuickBooks will prompt you to enter two pieces of information from your bank statement: the ending balance and the ending date. Type these numbers exactly as they appear on your document. Once you enter these details, click Start reconciling.
You will see a list of transactions in QuickBooks next to a summary of your statement details. Your goal is to check off each transaction in QuickBooks so it matches the statement. You can sort the list by date, amount, or reference number to make finding specific items easier. When the difference between your QuickBooks records and the bank statement reaches exactly $0.00, your account is reconciled. Click Finish Now to lock the period.
Intuit recently introduced an AI-powered reconciliation feature for QuickBooks Online. You can upload your PDF account statement directly into the system. The software takes up to an hour to verify and match the transactions automatically. This optional step saves time for businesses with high transaction volumes. You still need to review the final matches, but the automated system handles the bulk of the manual clicking. The AI reads the dates, amounts, and descriptions from your uploaded PDF and pairs them with the data already in your register. If the AI cannot find a match, it leaves the item unchecked for you to review manually. You can read more about automated matching in the QuickBooks bank reconciliation guide.
After finishing the basic steps, you might encounter grouped payments that complicate the matching process.
Handling combined payments and undeposited funds
Payment processors and banks often combine several customer payments into a single daily deposit. If a bank combines several payments into a single record, you cannot match them directly to individual invoices in the reconciliation window.
You must put the individual payments into the Undeposited Funds account first. Then, use the Bank Deposit function to group those specific payments together. This creates a single deposit record in QuickBooks that matches the exact lump sum on your bank statement. We explain this workflow in detail in our post on app management and undeposited funds. Proper app management prevents these deposit mismatches from happening in the first place.
For example, if you run a retail store, your point-of-sale system might batch all credit card sales for the day into one transfer. You must replicate that exact batch in QuickBooks. We help clients across many industries set up these workflows so their daily sales match their bank deposits perfectly.
Even with proper deposit grouping, you may still finish checking off items and find that the difference is not zero.
Troubleshooting errors when you learn how to do a bank reconciliation in QuickBooks Online
A reconciliation difference other than $0.00 means your books contain an error. Do not force the reconciliation by creating an adjustment entry. Adjustment entries hide mistakes and distort your financial reports. Instead, investigate the discrepancy using a few standard checks.
Identifying duplicate entries
If your reconciliation difference is exactly double a transaction amount, you almost certainly have a duplicate entry. This happens when a user manually enters an expense and then adds the same expense again from the bank feed instead of matching it. Search your register for that specific amount. If you find two identical entries, delete the manual duplicate and keep the one tied to the bank feed.
Managing bank fees and interest
Missing bank fees are the most frequent cause of minor discrepancies. Check your statement for monthly maintenance fees, wire transfer charges, or interest earned. You can add these directly in the reconciliation setup screen or record them as separate expenses before reconciling.
Fixing incorrect opening balances
When reconciling for the first time, errors usually stem from an incorrect opening balance. The opening balance is the starting point for your account. QuickBooks records this as a journal entry in the Opening Balance Equity account. If this number does not match the beginning balance on your statement, you must edit the original journal entry to reflect the correct amount. Many business owners accidentally create duplicate opening balances when they connect their bank feed, which throws off the very first reconciliation. You must ensure that the starting figure in QuickBooks matches the exact beginning balance printed on your first month’s bank statement.
Using the Reconcile Discrepancy Report
Sometimes a previously reconciled month suddenly becomes unbalanced. This occurs when someone edits or deletes a transaction that was already cleared. Use the Reconcile Discrepancy Report to find these changes. The report lists every modified transaction, showing the original amount and the changed amount so you can reverse the error. Maintaining clean records requires strict rules about editing past periods, which is a core part of our business consulting and strategic planning services.
Fixing these errors clears the current month, but you also need a plan for lingering items that never clear.
What to do with uncleared checks from previous months
You will often see old, uncleared checks sitting in your reconciliation window from previous months. These are known as stale checks. If a vendor has not cashed a check after 90 days, you need to investigate.
Contact the vendor to see if they lost the check. If they did, you can void the original check in QuickBooks and issue a new one. Do not simply delete the old check. Deleting it will alter your past financial reports and break your previous reconciliations. Handling stale checks promptly keeps your vendor records accurate, which is especially important when preparing for year-end tax reporting. Clean vendor records make our 1099 filing services much faster and more accurate.
Managing these details regularly prevents massive cleanup projects at the end of the year.
Why monthly reconciliation matters for your business
We recommend reconciling your accounts every single month. A monthly reconciliation takes about 10 to 20 minutes. If you wait and try to reconcile quarterly, the process can take hours as you untangle overlapping errors and track down old receipts. When you reconcile monthly, you catch fraudulent charges or bank errors while you still have time to dispute them. Banks typically only give you 60 days to report unauthorized transactions.
Consistent monthly checks give you an accurate picture of your cash flow. You can read your Profit and Loss statements with confidence and make informed operational decisions. If you want to see how this fits into a broader financial strategy, read our guide on how year-end reviews can help your business thrive. If you need help establishing this routine, our team at Anne Terese Hayes Consulting can guide you through the setup.
Frequently asked questions about bank reconciliations
Can I undo a bank reconciliation in QuickBooks Online?
Yes, but only accountant users have the built-in tool to undo an entire reconciliation at once. Standard users must manually uncheck each transaction in the register to reverse a reconciliation. If you need to undo a period, it is usually safer to invite an accounting professional to handle it.
What happens if I force a reconciliation with an adjustment?
QuickBooks creates a new expense or income transaction called Reconciliation Discrepancy. This forces the balance to match, but it hides the actual missing or duplicated transactions. Your tax reports will be inaccurate. You should always find the actual error instead of forcing the balance.
Do I need to reconcile credit cards too?
Yes. You should reconcile every account connected to your business, including credit cards, loans, and petty cash. The process for credit cards is identical to bank accounts. You use the monthly credit card statement and match the charges and payments.
Knowing how to do a bank reconciliation in QuickBooks Online protects your business from hidden cash flow leaks and reporting errors. Start by categorizing your bank feed, match your ending balances, and investigate any discrepancies before finalizing the month. When you maintain this habit, your financial reports become a reliable tool for running your business rather than a source of stress. For more bookkeeping tips, browse our articles or reach out directly through our contact page to schedule a consultation.