Learn How Bank Reconciliation Works in QuickBooks Online

What Bank Reconciliation Actually Is (And Why QuickBooks Online Makes It Matter)

Bank reconciliation is the process of comparing your accounting records in QuickBooks Online with the actual transactions your bank reported. Think of it like this: you write down what you spent from your checking account in a ledger, and your bank also keeps their own record of those same transactions. Sometimes these two records don't match, and reconciliation is how you find out why and fix it.

Learn What IRS TREAS 310 Means on Bank Statements →

In QuickBooks Online, bank reconciliation serves as your monthly reality check. Your software might show you have $5,000 in your business checking account, but your bank statement says $4,800. That $200 difference could be a check that hasn't cleared yet, a bank fee you forgot to record, a deposit that's pending, or—sometimes—an honest accounting mistake on your end. Without reconciliation, you're working with incomplete information, which leads to poor financial decisions.

The reason this matters for QuickBooks Online users specifically is that this software connects to your bank through a feature called bank feeds. When you set up bank feeds, QuickBooks automatically downloads transactions from your bank, which saves you time entering data manually. But automatic doesn't mean perfect. Your bank might categorize a transaction differently than you do, or QuickBooks might miss something. Reconciliation catches these issues.

Most accounting professionals recommend reconciling your bank account every single month, ideally shortly after your bank statement closes. If you run a small business with just a few transactions weekly, monthly reconciliation is usually enough. If you're moving significant money daily, some business owners reconcile weekly. The frequency depends on your cash flow and how closely you want to monitor your account.

Takeaway: Bank reconciliation in QuickBooks Online isn't busywork—it's your monthly check that your financial records actually match reality. Start thinking of it as non-negotiable accounting maintenance, like changing the oil in a vehicle.

Setting Up Your Bank Connection in QuickBooks Online

Before you can reconcile anything, QuickBooks Online needs to know about your bank account. The setup process is where most people either breeze through or get frustrated, depending on their bank.

Learn How to Transfer Money From Acorns →

Here's how to connect your bank to QuickBooks Online: Go to the Settings menu (the gear icon), select Accounts and Settings, then choose Banking. From there, you'll see an option to add your bank account. QuickBooks will ask which bank you use. If your bank is one of the major ones—Chase, Bank of America, Wells Fargo, Citibank, or regional banks—QuickBooks likely supports it directly. You'll enter your online banking username and password, and QuickBooks securely connects to your bank's system to start pulling in transactions.

Some smaller regional banks or credit unions aren't directly connected to QuickBooks Online. In those cases, you have two options: you can manually enter transactions, or you can use a file-based connection method like OFX or CSV format. This means downloading a file from your bank and uploading it into QuickBooks. It's more work, but it still works.

An important detail: QuickBooks doesn't store your banking password. The connection uses secure technology, and you're giving permission for information to flow one direction—from your bank to QuickBooks. You're not giving QuickBooks the ability to move money or make changes at your bank. Once connected, QuickBooks automatically downloads new transactions into a holding area called "For Review."

If you have multiple bank accounts—a checking account, a savings account, a business credit card—you'll repeat this process for each one. Some business owners set up four or five connections if they're managing multiple funding sources. Each account reconciles independently in QuickBooks.

Takeaway: Getting your bank connected to QuickBooks Online is a one-time task that takes 10-15 minutes for most banks. If your bank isn't directly supported, plan to work with manual uploads instead, which adds a few extra steps each month but is still workable.

Understanding the "For Review" Section and Transaction Matching

Once your bank is connected, transactions start appearing in QuickBooks Online's "For Review" section. This is a staging area where all downloaded transactions wait for you to do something with them. You'll see a list of deposits, checks, and other transactions your bank reported. Each transaction shows the date, amount, and sometimes a description (like "AMAZON PURCHASE" or "PAYROLL DEPOSIT").

Learn How Vehicle Excise Tax Works →

QuickBooks Online's job here is to match these bank transactions with transactions you've already entered in your accounting records. Let's say you wrote a check for $500 to pay a vendor on March 5th. You entered this in QuickBooks on March 5th. When that check clears your bank on March 8th, QuickBooks downloads it and tries to match it to the $500 check you recorded earlier. If QuickBooks finds a match, it marks both as connected and the transaction moves out of "For Review."

The matching works in a few different ways. For many transactions, QuickBooks matches automatically. An incoming deposit for $1,200 that you recorded as "Client Payment" gets matched when the bank reports the same $1,200 deposit. The software is smart enough to connect them without you doing anything.

Other times, you'll see transactions in "For Review" that don't match anything in your records. This might be because (1) you haven't entered the transaction in QuickBooks yet, or (2) you entered it for a different amount, or (3) it's a bank fee or charge you didn't anticipate. When QuickBooks can't auto-match, you can manually match the transaction by clicking on it and selecting the corresponding entry in your QuickBooks register. Or you can create a new transaction directly from "For Review" if it's something you hadn't recorded yet.

Here's a real example: Your bank shows a $35 monthly maintenance fee on the statement. You didn't enter this in QuickBooks because it was unexpected. You go to "For Review," click the $35 charge, and create a new transaction that categorizes this as a bank fee expense. Now QuickBooks knows about it, and the transaction is marked as cleared.

Takeaway: The "For Review" section is where you handle the gap between what your bank recorded and what your QuickBooks records show. Most transactions match automatically, but you'll manually handle the ones that don't.

Running the Bank Reconciliation Report in QuickBooks Online

Once you've matched or reviewed most of your transactions, it's time to run the actual reconciliation in QuickBooks Online. This is where the software formally compares your QuickBooks balance to your bank statement balance and tells you whether they match.

Free Guide to Big O Tires Credit Card Information →

To start reconciliation, go to Accounting, then Reconcile. You'll see a list of your connected bank accounts. Select the one you want to reconcile and enter the statement date (usually the last day of the month from your bank statement) and the statement balance (the ending balance your bank shows on your statement).

QuickBooks then shows you two columns: transactions that have cleared the bank and transactions that haven't. Transactions that cleared are checked off automatically. Transactions still pending—like a check you mailed three days ago that the bank hasn't processed yet—remain unchecked. Your job is to verify that the checked transactions match your bank statement.

Here's how this works in practice: Your bank statement says your ending balance on March 31st is $8,450. In QuickBooks, you see your account balance is $8,725. QuickBooks automatically found and marked 47 transactions as cleared. The difference between $8,725 and $8,450 is $275. You look at your unchecked transactions and find two pending checks: one for $150 and one for $125. Those add up to $275, which explains the difference perfectly.

When QuickBooks shows that your account balance and statement balance match (after accounting for the pending transactions), the reconciliation is complete. The software displays a "Reconciliation Complete" message. From that point forward, those cleared transactions are locked. You can't modify them without specifically undoing the reconciliation, which is good because it protects the integrity of past months.

If your QuickBooks balance doesn't match your bank statement balance, QuickBooks shows you the difference amount. This is where troubleshooting begins. You might need to look for a transaction you missed, check for data entry errors (like