Bookkeeping for contractors and service businesses in MetroWest and Greater Boston.

Call or Text: (774) 277-8683

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 questions should I ask before hiring a bookkeeper?

Ask about their industry experience, monthly process, software proficiency, communication style, and pricing structure. The right questions reveal whether a bookkeeper will actually meet your needs or create more problems than they solve.

Read answer

How should contractors handle progress billing?

Progress billing means invoicing at intervals throughout a project rather than at completion. Break contracts into a schedule of values, bill by percentage completion or milestones, track retainage separately, and make sure your billing ties back to job costs.

Read answer

What'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

Why does my business have cash flow problems?

Cash flow problems usually come from timing mismatches, not lack of profitability. Money is going out before it comes in. The most common causes are slow-paying customers, paying vendors too quickly, or seasonal revenue swings without reserves to cover the gaps.

Read answer

Should I offer payment terms to customers?

It depends on your business type. Retail and consumer services typically collect at time of sale, but B2B services and contractors often need to offer terms to compete. The key is structuring them to protect your cash flow.

Read answer

Why is my contractor bookkeeping so complicated?

Contractor bookkeeping is inherently more complex because you track costs by job and phase, manage timing gaps between deposits and final payments, and handle subcontractor documentation across multiple projects simultaneously.

Read answer

Full-service bookkeeping firm serving contractors and small businesses in MetroWest and Greater Boston. From monthly bookkeeping to job costing and payroll, we bring 20 years of hands-on business experience to your back office. Locally owned in Bellingham, Massachusetts.

Client Reviews

5-Star Rated Firm

© 2026 Janek Business Solutions, LLC