How do I reconcile my bank accounts in QuickBooks?
Before you start, grab your bank statement. You need the statement ending date and ending balance. These two numbers are what QuickBooks will compare against your recorded transactions.
In QuickBooks Online, click the gear icon in the top right and select Reconcile. Choose the bank account you want to reconcile from the dropdown. Enter the ending balance and ending date from your statement. QuickBooks will pull up all transactions that cleared before that date.
Go through each transaction and check the box next to it if it matches what appears on your bank statement. Look at the dollar amount, date, and payee. The goal is to verify that what your bank shows actually happened matches what you recorded in QuickBooks.
Watch the difference field at the top of the screen. As you check off transactions, this number should move toward zero. When it hits zero, your books match the bank and you’re done. Click Finish Now to complete the reconciliation.
If the difference isn’t zero, something doesn’t match. Common causes include transactions you entered but the bank hasn’t processed yet, bank fees or interest you forgot to record, duplicate entries, or transactions recorded for the wrong amount. Don’t force a reconciliation to balance by adjusting the difference. Find the actual error and fix it.
Reconcile monthly at minimum. Weekly is better for businesses with high transaction volume. The longer you wait, the harder it becomes to track down discrepancies because you forget what actually happened. A San Gabriel Valley bookkeeper for small business will reconcile accounts as part of regular monthly work, catching issues before they compound.
Start with the oldest unreconciled month and work forward. Skipping ahead creates problems because beginning balances won’t match. If you’ve never reconciled or it’s been years, you may need to establish an opening balance and reconcile forward from there.
Keep your bank feeds connected so transactions download automatically. This reduces manual entry errors that cause reconciliation headaches later. But remember that downloaded transactions still need to be categorized correctly. A transaction that imports into the wrong account or with the wrong amount will throw off your reconciliation.
If reconciliation consistently frustrates you or your books are already a mess, consider QuickBooks training to learn the right workflow. Small mistakes in how you record transactions create big headaches when you try to reconcile. Getting the process right from the start saves hours of frustration every month.
LA's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a clear price for the work.
More Questions
How do learning centers track student payments and schedules?
Learning centers need scheduling software connected to billing and accounting. The challenge is matching sessions used against payments collected, especially with prepaid packages and monthly tuition models.
Read answerHow do I set up IOLTA accounts in QuickBooks for my law practice?
Set up your IOLTA as a liability account in QuickBooks, not a bank account. You'll need sub-accounts or a tracking method for each client, plus the ability to run three-way reconciliations to satisfy California State Bar requirements.
Read answerHow do real estate investors track income from multiple properties?
Set up each property as its own profit center in your accounting software using classes or locations. Every rent payment, fee, and expense gets tagged to the specific property so you can see performance at the individual level.
Read answerWhat is financial due diligence when buying a small business?
Financial due diligence is the process of verifying a seller's financial claims before you buy. You're confirming revenue, expenses, liabilities, and assets are what the seller says they are, not just taking their word for it.
Read answerHow do music schools handle bookkeeping for multiple instructors?
Track lessons taught by each instructor, calculate pay based on lesson completion or revenue splits, and process payments consistently. The complexity depends on whether instructors are employees or contractors and how your scheduling software feeds into your accounting.
Read answerHow do I set up sales tax tracking in QuickBooks?
Turn on sales tax in QuickBooks settings, configure your products as taxable or exempt, and enable automatic rate calculation based on customer location. California has complex local rates, so using QuickBooks' automated feature helps avoid manual errors.
Read answer