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 are the biggest bookkeeping challenges for restaurants?
Restaurants deal with daily cash reconciliation, complex tip tracking, perishable inventory, and payroll for tipped employees. These challenges compound because thin margins mean small errors have outsized impact on profitability.
Read answerHow do I clean up my books before selling my company?
Separate personal expenses from business transactions, reconcile every account, and fix categorization inconsistencies. Buyers examine two to three years of records during due diligence, so start cleaning up well before you plan to sell.
Read answerCan a bookkeeper help me catch up on years of unfiled records?
Yes. A bookkeeper who specializes in catch-up work can take years of neglected records and organize them into accurate financial statements. Bank statements provide the foundation, and most everything can be reconstructed from there.
Read answerWhat is the best way to track commission income for real estate agents?
Track each transaction individually with the gross commission, brokerage split, and your net amount. Use cash basis accounting to record income when you receive payment, not when escrow closes. Reconcile monthly against brokerage statements to catch discrepancies early.
Read answerHow do virtual bookkeeping services work?
Virtual bookkeeping works just like traditional bookkeeping, except everything happens through cloud software and digital communication instead of in-person visits. You share documents online, your bookkeeper works remotely, and you communicate through email and video calls.
Read answerCan I use QuickBooks Online for law firm trust accounting?
Yes, but it requires proper setup and usually integration with legal practice management software like Clio. QuickBooks Online doesn't have native trust accounting features, so configuration matters.
Read answer