Week 2: Bank Feeds : Make Your Bank Your Best Data Entry Clerk
Welcome back to QuickBooks Without the Guesswork, a 10-week series designed to help small-business owners feel more confident with their bookkeeping.
In Week 1, we talked about creating a roadmap for your QuickBooks journey. Now it is time to put one of the biggest time-saving tools to work: bank feeds.
Bank feeds allow your bank and credit card transactions to flow into QuickBooks Online (QBO) automatically. That means fewer receipts to type, fewer transactions to enter by hand, and much less time spent copying numbers from one screen to another.
But there is one important detail:
Automation brings transactions into QBO. You still review and approve them.
Think of your bank feed as a very fast data entry clerk. It is helpful, efficient, and available around the clock: but it should not be allowed to make every bookkeeping decision without supervision.
That is where you come in.
What Are Bank Feeds in QuickBooks Online?
A bank feed is a secure connection between a financial account and QBO. Once connected, QBO can download transactions from eligible:
Checking accounts
Savings accounts
Business credit cards
Certain loan accounts
Depending on your bank or credit card provider, QBO may download recent transactions automatically, often updating at least once every 24 hours. You can also refresh the connection manually when you need the latest available information.
The feed generally moves information from your financial institution into QBO. It does not automatically understand the complete story behind every transaction. A deposit could be a customer payment, an owner contribution, or a transfer from another account. A charge could be office supplies, meals, equipment, or something personal.
The bank knows that money moved. Your bookkeeping system needs to know why.
Why Bank Feeds Are a Major Bookkeeping Time-Saver
Before bank feeds, business owners often entered every check, debit card purchase, credit card charge, and deposit manually. That process was repetitive and easy to fall behind on: especially during a busy season.
Bank feeds reduce that manual data entry. Transactions appear in QBO with information such as:
Date
Amount
Payee or merchant description
Account involved
Transaction type
QBO may also use previous activity to suggest a category or identify a possible match. Over time, this can make your monthly bookkeeping workflow faster and more consistent.
Still, faster does not automatically mean accurate. A feed can save you from typing a transaction, but it cannot always tell whether “AMZN Mktp” was office equipment, shipping supplies, or a personal purchase.
The goal is not to click through everything as quickly as possible. The goal is to review efficiently while keeping two eyes on your books.
How to Connect a Bank or Credit Card Account Safely
The exact wording may vary slightly depending on your QBO subscription and financial institution, but the general process looks like this:
Open QBO and go to Bank transactions or Banking.
Select Connect account or Link account.
Search for your bank or credit card provider.
Follow the prompts to sign in through the secure connection.
Complete any security verification requested by your bank.
Choose the specific checking, savings, or credit card account you want to connect.
Carefully select the matching account in your QBO Chart of Accounts.
Choose how far back you want transactions downloaded.
Confirm the connection.
Intuit explains the bank-feed process in its QuickBooks Online bank feeds overview and its help article about adding and matching bank-feed transactions.
A few safety reminders
Connect accounts only through QBO or your bank’s official website. Do not send your online banking password by email or text. If someone is helping with your bookkeeping, use appropriate QBO user permissions rather than sharing your personal login credentials.
Also, pause before connecting an account that is already being updated manually. Connecting the same account in multiple ways can create duplicate transactions and extra cleanup later.
Most importantly, make sure you connect the bank account to the correct QBO account. For example, a business credit card should connect to the corresponding credit card liability account: not a checking account or a generic expense category.
What Happens When Transactions Start Flowing In?
Once your account is connected, new transactions will appear in the For review area of QBO.
This is a holding area. Transactions sitting there have been downloaded, but they have not necessarily been added to your books yet. They are waiting for you to review them.
To find them, open QBO and go to:
Bookkeeping → Transactions → Bank transactions
Depending on your QBO layout, you may see a For review tab or a similar banking screen. From there, you can review transactions one at a time, filter by account or date, and take the appropriate action.
Here is what the common labels mean.
Downloaded
A downloaded transaction is information that QBO received from your bank or credit card provider.
Downloaded does not mean fully recorded. It simply means the transaction has arrived in the feed and is ready for review.
Categorized
A transaction is categorized when you assign it to the appropriate income, expense, asset, liability, or other account and add it to your books.
For example, a payment to a website hosting company may be categorized as a software or website expense. A deposit from a customer may be categorized as income: or matched to an existing invoice payment.
Once added or approved, the transaction becomes part of your account registers and financial reports.
Matched
A transaction is matched when QBO finds an existing transaction in your books that appears to be the same activity.
For example, you may have already recorded a customer payment against an invoice. When the bank feed downloads the deposit, QBO may suggest matching it to that existing payment.
Matching connects the downloaded bank activity to the transaction already in QBO. This is often preferable to adding a new transaction because it helps prevent duplicates.
If QBO suggests a match, review the date, amount, payee, and related transaction before accepting it. A suggestion is helpful: but it is still a suggestion.
Excluded
Sometimes a transaction in For review is a “double,” meaning it is a duplicate of something that is already recorded in QBO.
For example, you may have entered the transaction manually earlier, or it may have already been added another way. If the downloaded transaction already exists in your books, do not add it again. Instead, use Exclude.
In the For review area, the Exclude option appears with the other action choices for that transaction. Depending on your QBO view, you may see it directly on the transaction row or after opening the transaction details.
Excluding a duplicate keeps that downloaded item from being added to your books a second time. That matters because duplicates can overstate income, expenses, or account balances and make your reports less reliable.
Exclude does not mean “ignore bookkeeping.” It means “this item is already accounted for, so do not record it twice.”
The Golden Rule of Bank Feeds
Here it is again because it matters:
Never assume that an automatic bank feed is automatically correct.
Review every transaction before you add, match, or exclude it.
Ask yourself:
Do I recognize this merchant?
Is the amount correct?
Is this a business transaction?
Should it be categorized as an expense, income, transfer, loan payment, or something else?
Is there already a transaction in QBO that should be matched?
Do I have a receipt, invoice, or other support for this activity?
A few extra seconds of review can prevent incorrect reports, duplicate income, overstated expenses, and confusing account balances later.
Common First-Time Bank Feed Questions
Why are old transactions showing up?
When you first connect an account, QBO may download transactions from a previous period. The available history depends on your financial institution and the connection. Some banks provide around 90 days of activity, while others may provide more.
Old transactions are not automatically a problem. They simply need to be reviewed. If you already entered some of them manually, match them carefully instead of adding them again.
Why does the amount in QBO differ from what I expected?
A transaction may appear different because of pending activity, tips, deposits, refunds, foreign exchange, bank adjustments, or transaction timing. Check the bank’s posted activity and compare it with your receipts or records.
If the difference is small but unexplained, do not force the transaction into a category just to clear the screen. Investigate it first.
What about pending transactions?
Pending transactions have not fully posted at the bank. They may change, disappear, or post with a different amount. Many pending items will not flow into QBO until they are finalized, but timing can vary by institution.
Avoid recording a pending transaction manually unless you understand how it will affect your books. Otherwise, you may create a duplicate when the final transaction downloads.
Should I connect my business credit card, too?
Yes. Connecting business credit cards can save significant time because charges and payments flow into QBO just like bank transactions.
If your business has multiple employee cards, ask how the cards are structured in QBO before connecting them. A parent credit card account and individual cardholder subaccounts may require a little planning so the accounts reconcile properly.
Your Week 2 Bank Feed Routine
For this lesson, connect one business checking account or credit card account: if it is not already connected: and review the transactions waiting in For review.
Do not worry about mastering every category or bank rule today. Those topics are coming in later weeks. For now, focus on understanding the flow:
Downloaded → Reviewed → Matched or categorized → Added to the books
That simple sequence is the foundation of a reliable QBO workflow.
The Tip Jar
Bank feeds are powerful, but they are not mind readers. Let them handle the repetitive work while you provide the judgment.
A good habit is to review bank-feed transactions regularly instead of letting them pile up. A few minutes every few days: or a focused weekly review: usually feels much easier than facing several months of uncategorized activity at once.
And if a transaction is unclear, leave it for review rather than guessing. “I need more information” is a perfectly valid bookkeeping decision.
At Ledgers By Liisa LLC, our approach is Clear. Creative. Calm. We believe bookkeeping should give you useful information and confidence: not a growing list of question marks.
If you would rather have a professional review your feeds, categories, and workflow, book a consultation or explore our QuickBooks Online coaching. We also offer monthly bookkeeping services for business owners who would rather stay focused on running the business.
Visit www.ledgersbyliisa.com to get started. We will keep two eyes on your books so you can keep your attention where it belongs( on growing your business.)
Comments