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
How do I track subcontractor expenses by project?
Link every sub invoice to a specific job or project in your accounting system. Require subs to include the job name or number on their invoices, enter costs with the project code attached, and reconcile against your estimates regularly.
Read answerWhen should a small business hire a fractional CFO?
A fractional CFO makes sense when you're facing strategic decisions that require more than monthly reports can provide. Signs include unpredictable cash flow despite growth, preparing for a sale or major investment, or spending your time on financial strategy instead of running the business.
Read answerWhat bookkeeping do consulting firms need?
Consulting firms need bookkeeping that tracks profitability by client or engagement, handles retainers properly, and manages accounts receivable. The basics are simpler than inventory businesses, but project-level tracking matters.
Read answerWhat reports do contractors need from their bookkeeper?
Contractors need job profitability reports, work in progress (WIP) reports, accounts receivable aging, and cash flow forecasts at minimum. These reports show which jobs make money, where you stand on billing, and whether you can cover upcoming expenses.
Read answerWhat's the best accounting software for restaurants?
QuickBooks Online is the standard for restaurants. But the software matters less than how well it integrates with your POS system and whether it's configured for restaurant operations.
Read answerHow do HVAC companies track service calls and jobs?
Service calls need dispatch software for technician time and parts tracking. Installation jobs require job costing to compare estimated versus actual costs. The key is getting both types of data to flow correctly into your accounting system.
Read answer