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 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 property managers track rental income and expenses?
Track everything by individual property using classes or locations in your accounting software. Income includes rent, late fees, and other charges. Expenses are categorized by type and assigned to the specific property they relate to.
Read answerWhat are the bookkeeping requirements for property management companies?
Property management companies must maintain separate trust accounts for tenant funds, perform monthly three-way reconciliations, and track income and expenses by property. California has strict compliance requirements.
Read answerWhat are common bookkeeping mistakes dental practices make?
Dental practices commonly struggle with tracking production versus actual revenue, managing insurance adjustments, and following up on aging claims. Other frequent issues include miscategorizing lab fees, mixing owner draws with payroll, and failing to reconcile practice management software with QuickBooks.
Read answerWhat is the difference between a bookkeeper and an accountant?
Bookkeepers handle day-to-day financial record-keeping like categorizing transactions and reconciling accounts. Accountants focus on tax preparation, compliance, and financial strategy. Most small businesses need both.
Read answerHow long does it take to catch up on a year of bookkeeping?
For most small businesses, catching up on one year of bookkeeping takes two to four weeks. More complex situations with multiple accounts, high transaction volumes, or missing documentation can take six weeks or longer.
Read answer