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
Can 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 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 answerWhat bookkeeping records do I need to keep as a real estate agent?
Keep commission statements, mileage logs, marketing receipts, professional dues documentation, and all business expense receipts. Vehicle mileage is especially important since agents drive constantly for showings and client meetings.
Read answerWhat is the best way to manage revenue for a test prep business?
Track revenue based on when services are delivered, not when payment is received. Most test prep businesses collect payment upfront for courses or packages, which creates deferred revenue that needs proper tracking.
Read answerHow do I track insurance reimbursements for my medical practice?
Record insurance payments when you receive the EOB, separating the amount received from contractual adjustments. Track amounts by payer and reconcile your billing software to your accounting software monthly to catch discrepancies.
Read answerWhat is the difference between QuickBooks Simple Start and Essentials?
The main differences are user count, bill management, and time tracking. Simple Start works for one person doing basic invoicing and expense tracking. Essentials adds up to three users, accounts payable features, and built-in time tracking.
Read answer