How do I connect my bank to QuickBooks Online the right way?
The connection itself takes about two minutes. In QuickBooks Online, go to Banking or Transactions in the left menu, click Link Account, search for your bank, and sign in with your online banking credentials. QuickBooks will pull in your recent transactions, usually the last 90 days.
But connecting is just the first step. The “right way” means setting up your account to work efficiently going forward.
After you connect, create categorization rules. QuickBooks learns from your categorizations over time, but rules give you direct control. If you pay the same vendor every month for rent or a software subscription, create a rule so those transactions automatically categorize correctly. Go to Banking, then Rules, and set up rules for recurring transactions like utilities, insurance, subscriptions, and regular suppliers. This saves time and reduces errors as your transaction volume grows.
Review downloaded transactions before accepting them. QuickBooks will suggest matches to existing transactions and propose categories for new ones. Don’t just click Accept All. Look at each transaction, verify the category is correct, and add payee details if QuickBooks didn’t pull them in. Accepting everything without review creates messy books that take hours to clean up later.
Match transactions to what you’ve already entered manually. If you recorded a check or marked an invoice as paid before it cleared, QuickBooks will try to match the downloaded transaction to your existing entry. Matching keeps your books accurate without creating duplicates. This matters especially for businesses with invoicing or small business bookkeeping on Long Island where multiple transactions flow through daily.
Reconcile to your bank statement monthly. The bank feed shows what cleared, but reconciliation confirms your books match the bank’s records exactly. Go to the Gear icon, then Reconcile, select the account, enter the ending balance and date from your statement, and check off transactions until the difference is zero. This catches errors that the bank feed won’t show on its own.
A few common mistakes to avoid when setting up bank feeds:
Connecting before your chart of accounts is ready. If you don’t have expense categories configured, you’ll miscategorize transactions and have to fix them later. Get your chart of accounts set up first.
Ignoring the downloaded transactions for weeks or months. Some business owners connect their bank and never review what downloads. The data piles up, categorizations default to “Ask My Accountant,” and the books become useless for decision-making.
Treating the bank feed as reconciliation. Downloaded transactions are not reconciled transactions. You still need to reconcile monthly to your statement to catch timing differences and bank errors.
If setup feels overwhelming, QuickBooks Online setup and training walks you through the process and ensures everything is configured correctly from the start. Getting it right the first time saves hours of cleanup later.
Long Island's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business and what you need. We'll ask a few questions and give you a straightforward quote.
More Questions
Are the products I sell in my salon taxable in New York?
Yes, retail products like shampoo, conditioner, and styling products are taxable in New York. Services are generally not taxable outside NYC. Your bookkeeping should keep product sales separate from service revenue for accurate sales tax filing.
Read answerHow much does a bookkeeper cost for a small business?
Most small businesses pay $200 to $2,000 per month for outsourced bookkeeping, depending on transaction volume. Pricing typically scales with your monthly expenses because more transactions mean more work to categorize and reconcile.
Read answerHow do I do bookkeeping for a karate studio or after-school program?
Track prepaid tuition as deferred revenue that converts to income as classes are delivered. Properly classify instructors as employees or contractors, and plan for seasonal enrollment swings that affect cash flow.
Read answerDo I need to send 1099s to the freelancers my agency hires?
Yes. If you pay an unincorporated freelancer $600 or more during the year, you must send them a 1099-NEC by January 31. Collect W-9 forms before the first payment and track payments throughout the year.
Read answerHow should a gym or studio record prepaid memberships and class packages?
Prepaid memberships and class packs are deferred revenue, not income. Record the payment as a liability when received, then recognize revenue as classes are used or membership time passes.
Read answerWhat is the difference between a bookkeeper and an accountant?
A bookkeeper handles day-to-day financial records like categorizing transactions, reconciling accounts, and producing monthly reports. An accountant or CPA handles tax filing, audits, and strategic financial advice. Most small businesses need both, with the bookkeeper keeping books clean throughout the year so the accountant has accurate records at tax time.
Read answer