How do I reconcile my bank accounts in QuickBooks?
Bank reconciliation confirms that the transactions in your books actually happened and that nothing is missing or duplicated. You’re comparing what QuickBooks recorded against what your bank says occurred. When they match, you know your numbers are reliable. When they don’t, you’ve found a problem worth investigating.
Before you start, pull up your bank statement for the month you’re reconciling. You need the statement ending date and the ending balance from that statement. These two numbers drive the entire process.
In QuickBooks Online, click the gear icon and select Reconcile. Choose the bank account you want to reconcile from the dropdown. Enter the ending date and ending balance from your statement. QuickBooks will display all transactions it has recorded for that period.
Work through each transaction on the screen. If a transaction in QuickBooks matches one on your statement, check it off. Deposits and credits appear on one side, payments and withdrawals on the other. Keep checking items until you’ve gone through both lists completely.
The goal is to reach a difference of zero. When the checked items in QuickBooks equal the ending balance on your statement, you’re reconciled. Save the reconciliation and move to your next account.
If the difference isn’t zero, something is off. Common causes include transactions in QuickBooks that haven’t cleared the bank yet, transactions on the statement that were never entered in QuickBooks, duplicate entries, or amounts that were recorded incorrectly. Bank fees and interest charges often get missed because they don’t come from your normal transaction flow.
Don’t use the “adjustment” option to force a balance. That just hides the problem. Find the actual discrepancy. Compare the statement to QuickBooks line by line if needed. The error is usually a single transaction that’s missing, duplicated, or has the wrong amount.
Outstanding checks and deposits in transit are normal. If you wrote a check last week but it hasn’t cleared the bank yet, it won’t appear on your statement. Leave it unchecked during this reconciliation. It should clear and match next month.
Reconcile monthly at minimum. Full-service bookkeeping always includes monthly reconciliation because it’s the foundation of accurate financial records. Waiting longer means more transactions to sort through and more opportunities for errors to compound.
If you use bank feeds, reconciliation should be straightforward because transactions flow in automatically. But bank feeds can create duplicates if you also enter transactions manually or import data from another source. Watch for this during reconciliation.
Keep reconciliation reports. QuickBooks saves them automatically, but they’re useful if you ever need to trace back when something went wrong or prove to an auditor that your books were reviewed monthly.
When reconciliation consistently takes too long or you keep finding unexplained discrepancies, that usually signals a problem with how transactions are being recorded. Getting bookkeeping services in MetroWest to clean up and maintain your books means reconciliation becomes a quick monthly check rather than a frustrating puzzle.
Greater Boston's Trusted Bookkeeping Partner
The Next Step:
A Short Conversation
We'll ask a few questions, figure out what you need, and give you a straightforward quote.
More Questions
What reports should I run in QuickBooks each month?
Run your Profit & Loss, Balance Sheet, and AR/AP aging reports every month at minimum. Comparing to prior periods and budget gives context that makes the numbers meaningful.
Read answerWhy am I profitable but still struggling with cash?
Profit measures performance while cash measures actual money movement. The timing gap between when you earn revenue and when you collect it, plus cash drains that don't show on your P&L, creates the disconnect.
Read answerHow do I handle tip reporting for restaurant employees?
Employees report tips to you monthly, and you withhold payroll taxes on them just like regular wages. Restaurants with more than 10 employees must also file Form 8027 annually with the IRS.
Read answerWhat bookkeeping do home service companies need?
Home service companies need more than basic transaction recording. You need job-level profitability tracking, labor cost visibility, cash flow planning for seasonal slowdowns, and proper invoicing and collections systems.
Read answerCan someone clean up my QuickBooks for me?
Yes. A bookkeeper who knows QuickBooks can reconcile your accounts, fix miscategorizations, and get your books current. Most cleanups take a few weeks depending on how many months are behind.
Read answerWhat does a fractional controller do?
A fractional controller provides senior-level financial oversight without a full-time hire. They manage budgets, create forecasts, analyze margins, and turn your bookkeeping data into actionable insights for running the business.
Read answer