Skip to content
Tutorials Center
My learning

Topics

Lesson 19 of 36 ยท Banking and Reconciliation

Bank Feeds and Categorizing Transactions

Connect a bank to QuickBooks, review the For review tab, and decide whether each downloaded transaction should be matched, categorized or excluded, with a runnable triage stand-in.

Typing every bank transaction by hand is slow and error-prone. QuickBooks can download them for you through a bank feed. The feed does not create finished bookkeeping, though. It creates a queue of proposed transactions that you review and accept. Your job is to decide, for each line, what it really was.

QuickBooks cannot run on this site. The menu paths below describe QuickBooks Online and may differ slightly between plans and desktop versions. The TryIts use JavaScript stand-ins that imitate the decision logic; they are not QuickBooks code and never connect to a bank.

Connecting an account

In QuickBooks Online, open Transactions > Bank transactions (older layouts say Banking) and choose Connect account. Search for your bank, sign in on the bank's own secure page, and pick which accounts to link. QuickBooks asks how far back to import, commonly up to 90 days, depending on the bank. Pick a start date that matches your opening balances so you do not import transactions you already entered.

You can also import a CSV or bank file when a bank is not supported. The columns usually need a date, a description and either one amount column or separate debit and credit columns.

Each connected bank account is linked to an account in your chart of accounts. A checking account in the bank maps to a Bank account in QuickBooks; a credit card maps to a Credit Card account. This pairing matters: the transactions you accept post into that account.

The three tabs

The bank transactions screen sorts downloaded lines into tabs:

  • For review: new lines waiting for you.
  • Categorized: lines you accepted (and rules accepted automatically).
  • Excluded: lines you chose to ignore, such as duplicates.

For every line in For review, QuickBooks offers one of three paths:

  1. Match: the line is a payment or expense you already recorded (an invoice payment, a bill payment, a check). Accepting the match links the bank line to the existing record, so nothing is entered twice.
  2. Categorize (Add): the line is new. You choose the account (category), payee and optionally class, location or tax, and QuickBooks creates the transaction.
  3. Exclude: the line should not be recorded, for example a transaction downloaded twice.

Do not categorize a customer payment you can match to an open invoice. If you add it as income, you will count the sale twice: once when you issued the invoice and again when the money arrived.

flowchart TD
    A["Bank line in For review"] --> B{"Already recorded in QuickBooks?"}
    B -- Yes --> C["Match to the existing record"]
    B -- No --> D{"A real transaction?"}
    D -- Yes --> E["Categorize: account, payee, memo"]
    D -- No --> F["Exclude (duplicate or personal)"]

Every downloaded line takes exactly one of three paths.

Choosing the right category

The category is the account that receives the other side of the entry. Money coming in is usually income, a payment from a customer, a loan or an owner contribution. Money going out is usually an expense, a bill payment, an asset purchase or a draw.

Common traps:

  • Transfers between your own accounts are not income or expense. Use the Transfer option (see Credit Cards, Transfers and Deposits).
  • Owner payments into or out of the business are equity (contributions and draws), not income or expense.
  • Loan payments split into interest (expense) and principal (reduces the liability). Use a split.
  • Sales tax belongs in a liability account, not income.

Use a split when one bank line covers more than one category: click the split icon and enter each portion. The parts must add up to the bank amount.

A stand-in for triage

The stand-in below classifies a few downloaded lines the way a careful reviewer would. It matches an amount to an open invoice, flags a transfer, and leaves the rest for categorizing.

JS Triage downloaded bank lines

Press Run (or Ctrl + Enter) to see the console output here.

No output.

JS Check that a split adds up

Press Run (or Ctrl + Enter) to see the console output here.

No output.

Good habits

Review the feed at least weekly. A short queue is easy; a three-month queue invites mistakes. Always confirm the payee and category rather than trusting QuickBooks' suggestion, especially at first. Add a clear memo for unusual items so you (or your accountant) understand them later. Never delete a bank-feed transaction you have accepted without first checking whether it was reconciled, which the next lessons explain.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. A bank line shows a customer paying an invoice you already issued. What should you do?

    The sale was recorded when you created the invoice. Matching links the deposit to that record, so income is not counted twice.
  2. 2. Which tab holds downloaded lines you have not yet accepted?

    New downloaded lines wait in For review until you match, categorize or exclude them.
  3. 3. Money moves from your checking account to your savings account. How is it recorded?

    A transfer moves money between your own accounts and does not change profit.
  4. 4. When should you use a split?

    A split divides one amount across several accounts, and the parts must add up to the bank amount.

Summary

  • A bank feed downloads proposed transactions into For review; you decide each one.
  • Each line is matched, categorized (possibly split) or excluded.
  • Transfers, owner money, loans and sales tax are not ordinary income or expenses.
  • Review the queue often and add memos for unusual items.

Next: Bank Rules and Auto-Matching