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 answerHow much cash reserve should my business have?
The standard answer is 3-6 months of operating expenses. Where you land in that range depends on your revenue stability, fixed costs, and exposure to seasonal slowdowns or client concentration.
Read answerIs it worth paying someone to catch up my books?
For most business owners, yes. Professionals work faster, find missed deductions, and deliver books you can trust. The cost usually pays for itself through recovered deductions and time saved.
Read answerAre there virtual bookkeepers who work with Massachusetts businesses?
Yes, many bookkeepers work with Massachusetts businesses remotely. Cloud-based accounting software makes virtual bookkeeping secure and efficient. What matters most is finding someone who understands Massachusetts tax requirements and your industry.
Read answerHow do I set up direct deposit for employees?
Setting up direct deposit requires a payroll provider, employee authorization forms with bank details, and typically 2-4 business days lead time before your first payroll run. Most payroll software walks you through the process.
Read answerWhat's a 13-week cash flow forecast?
A 13-week cash flow forecast is a week-by-week projection of money coming in and going out over the next three months. It shows your cash position each week so you can spot shortfalls before they happen and plan accordingly.
Read answer