Study guide

5.3 Connecting Bank Feeds, Transaction Matching & Bank Rules

Certified Public Bookkeeper CPB

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Introduction & CPB Certification Overview

1.1 About the Certified Public Bookkeeper (CPB) Credential 1.2 The Role of the Bookkeeper vs. Accountant 1.3 How to Use This Study Guide & Exam Strategy 1.4 The Business Communication Certification (Required January 1, 2027)

2 Chapter 2: Core Accounting Concepts & The Accounting Equation

2.1 The Accounting Equation & Account Classifications 2.2 Transaction Analysis & T-Accounts 2.3 The General Journal, General Ledger & Posting 2.4 The Unadjusted Trial Balance & Error Detection

3 Chapter 3: Adjusting Entries, Worksheet & Financial Statements

3.1 Accruals & Deferrals (Adjusting Journal Entries) 3.2 Depreciation & Fixed Asset Accounting 3.3 The 10-Column Accounting Worksheet 3.4 Preparing the Income Statement, Statement of Owner's Equity & Balance Sheet

4 Chapter 4: The Closing Process, Merchandising & Cash Controls

4.1 The 4-Step Closing Process & Post-Closing Trial Balance 4.2 Merchandising Operations & Perpetual/Periodic Inventory 4.3 Accounts Receivable & Bad Debt Accounting 4.4 Accounts Payable, Cash & Bank Reconciliations

5 Chapter 5: QuickBooks Online Setup, Banking Feeds & Lists

5.1 QBO Architecture, Subscription Levels & Company Settings 5.2 Chart of Accounts, Products/Services & List Management 5.3 Connecting Bank Feeds, Transaction Matching & Bank Rules 5.4 Performing Bank & Credit Card Reconciliations in QBO

6 Chapter 6: QuickBooks Online Sales, Expenses & Inventory Workflows

6.1 Sales Workflows: Estimates, Invoices, Sales Receipts & Customer Payments 6.2 Expense Workflows: Expenses, Checks, Bills & Accounts Payable 6.3 Inventory Tracking, Purchase Orders & FIFO Costing in QBO 6.4 Adjusting Journal Entries, Voiding/Deleting & Closing the Books

7 Chapter 7: QuickBooks Online Payroll & Financial Reporting

7.1 QBO Payroll Setup, Employee Records & Compensation Types 7.2 Running Payroll, Direct Deposit & Automated Payroll Taxes in QBO 7.3 Core Financial Reports: Profit and Loss, Balance Sheet & Statement of Cash Flows 7.4 Management Reports, Customization, Tagging & Exporting

8 Chapter 8: Payroll Laws, Worker Classification & Gross Pay Computations

8.1 Federal Payroll Legislation: FLSA, FICA, FUTA, SUTA & Form W-4 8.2 Employee vs. Independent Contractor Classification (W-2 vs. 1099-NEC) 8.3 FLSA Overtime Rules, Regular Rate of Pay & White-Collar Exemptions 8.4 Gross Pay Computations: Hourly, Salaried, Piecework, Tips & Commissions

9 Chapter 9: Payroll Deductions, Net Pay & Employer Tax Liabilities

9.1 Voluntary Deductions: Pre-Tax vs. Post-Tax Fringe Benefits (Section 125, 401(k), HSA) 9.2 Statutory Withholdings: Federal Income Tax, Social Security, Medicare & Net Pay 9.3 Involuntary Deductions: Wage Garnishments, Child Support & Tax Levies 9.4 Employer Payroll Taxes: Matching FICA, FUTA, SUTA & Total Cost of Labor

10 Chapter 10: Payroll Tax Compliance, Deposits & Accounting Entries

10.1 Federal Tax Deposit Rules: Monthly vs. Semi-Weekly Schedules & EFTPS 10.2 Quarterly & Annual Payroll Tax Returns (Forms 941, 940 & State Filings) 10.3 Year-End Wage Reporting: Forms W-2, W-3, 1099-NEC & 1096 Compliance 10.4 Payroll Accounting: Recording Payroll Journal Entries & General Ledger Accruals 10.5 Payroll Records: The Payroll Register & Employees' Earnings Records

5.3 Connecting Bank Feeds, Transaction Matching & Bank Rules

Key Takeaways Explain This Topic AI

The QuickBooks Online Bank Feed establishes a secure, automated data connection with financial institutions, staging downloaded transactions in the 'For Review' tab before they affect the general ledger.

The three primary bank feed triage actions are: Match (linking downloaded data to an existing general ledger entry), Add (creating a brand-new transaction in the ledger), and Transfer (moving funds between balance sheet accounts).

Automated Bank Rules evaluate transactions sequentially based on priority order, applying predefined conditions (description, bank text, amount) to assign payees, categories, classes, and split allocations.

The #1 cause of duplicate income and expense distortions in QBO is clicking 'Add' on a downloaded bank feed transaction when an invoice payment, sales receipt, or bill payment was already recorded in the ledger.

Last updated: August 2026

5.3 Connecting Bank Feeds, Transaction Matching & Bank Rules

Core Principle: The Bank Feed is the primary data ingestion pipeline in modern cloud bookkeeping. Downloaded bank transactions represent raw external reality; bookkeepers must systematically match, categorize, or transfer these entries to ensure the general ledger is complete, accurate, and free of duplicate postings.

1. Bank Feed Architecture & Balances

QuickBooks Online connects to financial institutions (banks, credit unions, and credit card issuers) via Open Banking APIs (OAuth 2.0 direct feeds) or secure aggregator protocols. When a bank account is linked, transactions download automatically on a nightly schedule. +-----------------------------------------------------------------------------+

  • | UNDERSTANDING THE TWO BANK BALANCES |
  • +-----------------------------------------------------------------------------+
  • | BANK BALANCE |
  • | - The actual cleared balance reported by the financial institution at the |
  • | moment of the latest successful automated download. |
  • | - Reflects only transactions that have cleared the bank's servers. |
  • +-----------------------------------------------------------------------------+
  • | IN QUICKBOOKS BALANCE (GL Cash Account Balance) |
  • | - The general ledger cash account balance in QBO. |
  • | - Includes all transactions posted to the register (manual checks, bill |
  • | payments, approved bank feed entries), including uncleared items. |
  • +-----------------------------------------------------------------------------+
  • Web Connect Manual Uploads

If a financial institution does not support automated API connections, bookkeepers can manually import bank activity using Web Connect files. Supported file formats include:

  • .QBO (QuickBooks Online standard data format)
  • .CSV (Comma-Separated Values - requires mapping Date, Description, and Amount columns)
  • .OFX (Open Financial Exchange)
  • .QFX (Quicken Financial Exchange)
  • 2. The 3-Tab Bank Feed Workflow

The Bank Transactions screen ( Transactions -> Bank transactions ) organizes downloaded data into three operational tabs: +-----------------------------------------------------------------------------+

  • | THE 3-TAB BANK FEED STAGING ENGINE |
  • +-----------------------------------------------------------------------------+
  • | 1. FOR REVIEW TAB (The Staging Area) |
  • | - Transactions downloaded from the bank wait here. |
  • | - Transactions have ZERO effect on the General Ledger while in review. |
  • | - Bookkeeper must take action: Match, Add, or Transfer. |
  • +-----------------------------------------------------------------------------+
  • | 2. CATEGORIZED TAB (The Audit Register) |
  • | - Displays all transactions accepted into QBO from the bank feed. |
  • | - Includes an 'Undo' button to roll mistaken entries back to For Review.|
  • +-----------------------------------------------------------------------------+
  • | 3. EXCLUDED TAB (The Holding Vault) |
  • | - Contains transactions removed from review (e.g., duplicates, personal |
  • | owner expenses in mixed accounts, pre-conversion data). |
  • | - Excluded entries never post to the General Ledger. |
  • +-----------------------------------------------------------------------------+
  • 3. The Three Primary Bank Feed Actions

For every transaction in the For Review tab, the bookkeeper must execute one of three actions: +-----------------------------------------------------------------------------+

  • | THE 3 PRIMARY BANK FEED ACTIONS |
  • +-----------------------------------------------------------------------------+
  • | ACTION | WHEN TO USE | GL IMPACT |
  • +----------------+----------------------------+-------------------------------+
  • | 1. MATCH | Transaction ALREADY exists | Links bank download to GL |
  • | (Green) | in QBO (Invoice Payment, | entry; changes register status|
  • | | Bill Payment, Check, Dep) | to Cleared ('C'). NO DUPLICATE|
  • +----------------+----------------------------+-------------------------------+
  • | 2. ADD | Transaction does NOT exist | Creates a BRAND NEW entry in |
  • | (Blue) | in QBO (Debit card charge, | GL; posts to category & marks |
  • | | ATM withdrawal, wire fee) | as Cleared ('C'). |
  • +----------------+----------------------------+-------------------------------+
  • | 3. TRANSFER | Funds moved between two | Records transfer between two |
  • | | Balance Sheet accounts | balance sheet accounts (e.g., |
  • | | (Checking to Credit Card) | Checking -> Savings). |
  • +-----------------------------------------------------------------------------+
  • 1. Match (The Golden Rule of Bank Feeds)

When QBO identifies an existing transaction in the general ledger (matching amount, date proximity, and payee), it displays a green Match banner. Clicking Match:

Confirms that the external bank activity matches the internal accounting record.

Updates the transaction status in the account register from blank to Cleared ( C ) .

Crucial: Match creates no new general ledger entries , preventing balance distortion.

Advanced Matching: The "Find Match" Drawer

If a single bank deposit represents multiple customer invoice payments, or a single vendor payment satisfies multiple bills, the automated engine will not show a simple match. The bookkeeper must click the transaction, select Find Match , and check off the multiple underlying entries that sum to the exact downloaded deposit or disbursement amount.

2. Add

Used when the transaction represents a new expenditure or receipt not previously entered into QBO. The user must assign:

Payee / Vendor / Customer: Mandatory for audit compliance.

Category (GL Account): The appropriate Expense, Income, or Asset account.

Class / Location: Optional tracking tags.

3. Transfer

Used exclusively when moving money between two existing balance sheet accounts belonging to the company (e.g., transferring funds from Business Checking to Business Savings, or making a credit card payment from Checking). Recording a transfer in the Checking feed creates a corresponding pending match in the Savings feed.

4. Automated Bank Rules

Bank Rules automate the categorization of recurring transactions, accelerating bank reconciliation and enforcing coding consistency. +-----------------------------------------------------------------------------+

  • | BANK RULE CONFIGURATION SCHEMA |
  • +-----------------------------------------------------------------------------+
  • | 1. RULE NAME : Descriptive title (e.g., 'Adobe Creative Cloud Sub') |
  • | 2. APPLY TO : Money In OR Money Out | Select specific bank accounts|
  • | 3. CRITERIA LOGIC : Match ANY condition (OR) vs Match ALL conditions(AND)|
  • | 4. CONDITIONS : Description | Bank Text | Amount |
  • | [ Contains | Exactly matches | Does not contain ] |
  • | 5. ASSIGNMENTS : Transaction Type (Expense, Check, Transfer, Deposit) |
  • | Payee, Category (GL Account), Class, Location |
  • | 6. SPLIT OPTION : Split by Percentage (%) or Fixed Dollar Amount ($) |
  • | 7. AUTO-ADD TOGGLE : Automatically add to General Ledger without review |
  • +-----------------------------------------------------------------------------+
  • Bank Text vs. Description

Bank Text (Recommended): The exact, raw string transmitted electronically by the banking institution (e.g., DEBIT-PURCHASE 10/12 SQ *ROASTER CAFE SAN FRANCISCO CA ).

Description: QBO's cleaned, algorithmically shortened interpretation of the bank text.

Best Practice: Always build rules using Bank Text contains to ensure robust matching against variations in bank transmission strings.

Rule Priority Order

Bank rules are evaluated sequentially from top to bottom ( Priority 1, 2, 3... ). When a downloaded transaction satisfies the criteria of Rule #1, QBO applies Rule #1 and stops evaluating subsequent rules . Rules can be reordered in the Rules window via drag-and-drop or priority editing.

Auto-Add Rules & Risk Management

Enabling the Auto-add checkbox instructs QBO to bypass the "For Review" staging tab entirely and post matched transactions directly into the general ledger.

Warning

Auto-Add Safety Protocol: Auto-Add should only be enabled for predictable, non-variable recurring expenses with a single fixed GL account (e.g., monthly software subscriptions like Zoom or Adobe, or recurring bank service fees). Never enable Auto-Add for vendors where purchase orders, bills, or invoices are pre-recorded, as Auto-Add will bypass the Match engine and create duplicate transactions.

5. Avoiding Duplicate Entries: The #1 Bookkeeping Trap

The most common error in computerized bookkeeping occurs when a user ignores matching protocols and clicks Add on pre-existing transactions. +-----------------------------------------------------------------------------+

  • | THE DUPLICATE INCOME DISASTER SCENARIO |
  • +-----------------------------------------------------------------------------+
  • | 1. Bookkeeper creates Invoice #1001 for $5,000. |
  • | -> GL Posting: Dr. Accounts Receivable $5,000 / Cr. Revenue $5,000 |
  • | |
  • | 2. Customer pays $5,000. Bookkeeper records 'Receive Payment'. |
  • | -> GL Posting: Dr. Undeposited Funds $5,000 / Cr. AR $5,000 |
  • | |
  • | 3. Bookkeeper deposits check via 'Bank Deposit'. |
  • | -> GL Posting: Dr. Checking Account $5,000 / Cr. Undeposited Funds $5k |
  • | |
  • | 4. Bank Feed downloads the $5,000 deposit from the bank. |
  • | -> THE MISTAKE: User clicks 'ADD' to 'Sales Income' instead of 'MATCH'. |
  • | -> GL Posting: Dr. Checking Account $5,000 / Cr. Sales Income $5,000 |
  • | |
  • | CONSEQUENCES: |
  • | - Revenue is DOUBLE-COUNTED ($10,000 total revenue reported). |
  • | - Cash balance in QBO register is overstated by $5,000. |
  • | - Bank reconciliation will have an irreconcilable $5,000 variance! |
  • +-----------------------------------------------------------------------------+
  • How to Fix Bank Feed Duplicates

Navigate to Transactions -> Bank transactions -> Categorized tab.

Locate the erroneously added transaction.

Click Undo in the action column. The transaction is removed from the general ledger and returned to the For Review tab.

In the For Review tab, find the downloaded entry and select Match to link it to the existing Bank Deposit.

Loading diagram... QuickBooks Online Bank Feed Triage & Matching Workflow