Bookkeeping, payroll, and CFO services for small businesses across Los Angeles County.

Call or Text: (626) 353-9790

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

What bookkeeping software integrates with Clio for law firm accounting?

QuickBooks Online is the primary accounting software that integrates directly with Clio. The integration syncs invoices, payments, and time entries between systems, though trust accounting still requires careful manual oversight.

Read answer

How do I set up client ledgers for my law firm's trust account?

Create a separate ledger for each client matter, tracking every deposit and disbursement against that specific client's funds. The sum of all client ledger balances must always equal your total trust account balance.

Read answer

What is the S-Corp election and should real estate agents consider it?

The S-Corp election lets you be taxed as an S-Corporation, reducing self-employment taxes by splitting income between salary and distributions. Real estate agents typically benefit when net profit consistently exceeds $40,000 to $50,000 annually, though added costs and complexity mean it's not right for everyone.

Read answer

How do optometrists track inventory and frame costs?

Track each frame as an individual SKU with its cost, vendor, and category. Use practice management software or QuickBooks inventory features to connect purchases to sales, and run physical counts regularly to catch shrinkage and slow-moving stock.

Read answer

What is three-way trust reconciliation for law firms?

Three-way trust reconciliation compares your bank statement, your checkbook register, and the total of all individual client ledger balances. All three numbers must match exactly. This process is required by the California State Bar to ensure client funds are properly safeguarded.

Read answer

Can I deduct my home office as a real estate agent?

Yes, most real estate agents can deduct their home office. Even though you meet clients at properties rather than your home, you qualify through the administrative activities exception if you use a dedicated space for paperwork, marketing, and transaction management.

Read answer

Villa Group is a San Marino accounting firm serving small businesses across Los Angeles County. We handle bookkeeping, payroll, CFO services, and business sale preparation. Led by Christian Villalba, MBA, with over a decade of experience and 400+ clients served.

Client Reviews

5-Star Rated Firm

Social

© 2026 Villa Group LLC