Study guide

5.2 Chart of Accounts, Products/Services & List Management

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.2 Chart of Accounts, Products/Services & List Management

Key Takeaways Explain This Topic AI

The Chart of Accounts (COA) is the general ledger backbone of QBO, categorized by Account Type (determining financial statement placement and debit/credit rules) and Detail Type (providing Intuit tax line and operational mapping).

QBO contains specialized default system accounts—including Retained Earnings, Opening Balance Equity (OBE), and Undeposited Funds / Payments to Deposit—which follow strict operational rules and should never be deleted.

The Products and Services list acts as the accounting bridge between customer/vendor operational forms and the general ledger, supporting four distinct item types: Inventory, Non-inventory, Service, and Bundle.

List items with historical transactional data cannot be permanently deleted from QBO; they must be made Inactive, or merged by renaming an item to match another existing record exactly.

Last updated: August 2026

5.2 Chart of Accounts, Products/Services & List Management

Core Principle: In QuickBooks Online, daily data entry forms (invoices, bills, checks, sales receipts) never post directly to account numbers chosen at random. Instead, transactions are categorized via the Chart of Accounts and routed systematically through the Products and Services List , ensuring structured financial statement integrity.

1. Chart of Accounts (COA) Structure & Numbering Architecture

The Chart of Accounts (COA) is the complete list of general ledger accounts used by a business to record financial transactions. In QBO, accounts can be organized hierarchically using parent accounts and sub-accounts (up to 5 levels of nesting) to provide structured financial reporting. +-----------------------------------------------------------------------------+

  • | STANDARD GAAP ACCOUNT NUMBERING CONVENTION |
  • +-----------------------------------------------------------------------------+
  • | NUMBER RANGE | ACCOUNT CATEGORY | FINANCIAL STATEMENT DESTINATION |
  • +----------------+--------------------------+---------------------------------+
  • | 10000 - 19999 | Assets | Balance Sheet |
  • | 20000 - 29999 | Liabilities | Balance Sheet |
  • | 30000 - 39999 | Owner's / Stockholder Eq | Balance Sheet |
  • | 40000 - 49999 | Revenues / Income | Income Statement (Top Line) |
  • | 50000 - 59999 | Cost of Goods Sold (COGS)| Income Statement (Gross Profit) |
  • | 60000 - 79999 | Operating Expenses | Income Statement (Operating Inc)|
  • | 80000 - 89999 | Other Income | Income Statement (Bottom Line) |
  • | 90000 - 99999 | Other Expenses | Income Statement (Bottom Line) |
  • +-----------------------------------------------------------------------------+
  • Enabling Account Numbers in QBO

Account numbering is disabled by default in new QBO companies. To enable numbering:

Navigate to Gear Icon (⚙️) -> Account and Settings -> Advanced .

In the Chart of accounts section, click the pencil edit icon.

Check Enable account numbers and optionally check Show account numbers .

Click Save and Done .

2. Account Type vs. Detail Type

When creating a new account in QBO, two classification fields must be defined: Account Type and Detail Type . Candidates must understand the distinct operational function of each field: +-----------------------------------------------------------------------------+

  • | ACCOUNT TYPE vs. DETAIL TYPE |
  • +-----------------------------------------------------------------------------+
  • | DIMENSION | ACCOUNT TYPE | DETAIL TYPE |
  • +------------------+----------------------------+-----------------------------+
  • | Definition | Primary financial category | Specific sub-descriptor |
  • | Function | Determines financial | Provides tax line mapping |
  • | | statement placement & Dr/Cr| guidance and Intuit tips |
  • | GL Impact | Absolute & Direct | Informational / Advisory |
  • | Examples | Current Assets, Expenses, | Checking, Advertising, |
  • | | Accounts Payable, Equity | Office Supplies, Inventory |
  • +-----------------------------------------------------------------------------+

Account Type (Structural Driver): Dictates whether the account resides on the Balance Sheet or Income Statement, its normal balance (Debit vs. Credit), and how it behaves during year-end closing.

Detail Type (Tax & Organizational Descriptor): Created by Intuit to assist users in selecting appropriate accounts and to assist with automated tax mapping. Detail type does not alter debit/credit rules, but selecting an accurate detail type ensures correct categorization in Intuit automated reporting.

3. Special Default System Accounts

QBO automatically provisions specialized default system accounts that govern specific operational workflows. Bookkeepers must understand the behavior and audit requirements of these accounts: +-----------------------------------------------------------------------------+

  • | SPECIAL DEFAULT SYSTEM ACCOUNTS |
  • +-----------------------------------------------------------------------------+
  • | ACCOUNT NAME | ACCOUNT TYPE | OPERATIONAL PURPOSE |
  • +-----------------------------+---------------------+-------------------------+
  • | Retained Earnings | Equity | Cumulative Net Income |
  • | Opening Balance Equity | Equity | Setup Balancing Vault |
  • | Undeposited Funds | Other Current Asset | Payment Clearing Vault |
  • | Uncategorized Income/Exp | Income / Expense | Bank Feed Holding Acct |
  • | Reconciliation Discrepancy | Expense / Income | Forced Rec Variance |
  • +-----------------------------+---------------------+-------------------------+
  • 1. Retained Earnings

Function: Automatically accumulates net income or net loss from all prior closed fiscal years. At the start of a new fiscal year, QBO dynamically rolls the prior year's Profit and Loss balance into Retained Earnings without requiring a manual closing journal entry.

Rule: Bookkeepers should never enter manual journal entries directly to Retained Earnings during routine operations.

2. Opening Balance Equity (OBE)

Function: A temporary holding account generated by QBO during initial setup when beginning balances are entered for bank accounts, credit cards, customers (unpaid invoices), vendors (unpaid bills), or fixed assets.

The Bookkeeper Cleanup Protocol: A non-zero balance in Opening Balance Equity indicates an incomplete setup. The professional bookkeeper must investigate the origin of every entry in OBE, reclassify balances to their appropriate balance sheet accounts (such as Owner's Capital, Common Stock, or Retained Earnings), and verify that Opening Balance Equity equals $0.00 before issuing final financial statements.

3. Undeposited Funds (Payments to Deposit)

Function: An Other Current Asset clearing account that temporarily holds customer payments received (cash, paper checks, daily credit card merchant batches) until the funds are grouped and physically deposited into the bank account via the + New -> Bank Deposit workflow.

4. Products and Services List Management & Item Types

The Products and Services List is the central catalog of everything a business sells or purchases. Sales forms (Invoices, Sales Receipts, Estimates) and Purchase forms (Purchase Orders, Bills, Expenses) utilize Products and Services items to record transactions. Behind each item, an account mapping routes the financial data to the appropriate General Ledger account. +-----------------------------------------------------------------------------+

  • | THE 4 PRODUCTS AND SERVICES ITEM TYPES |
  • +-----------------------------------------------------------------------------+
  • | 1. INVENTORY (Plus/Advanced Only) |
  • | - Physical products tracked in quantity on hand. |
  • | - Automatically links to 3 GL Accounts: |
  • | * Inventory Asset (Balance Sheet) |
  • | * Sales / Income Account (Income Statement) |
  • | * Cost of Goods Sold / COGS (Income Statement) |
  • | - Uses FIFO (First-In, First-Out) perpetual inventory valuation. |
  • +-----------------------------------------------------------------------------+
  • | 2. NON-INVENTORY |
  • | - Physical goods bought or sold whose quantity on hand is NOT tracked. |
  • | - Used for office supplies, materials drop-shipped directly to clients. |
  • | - Links to an Income account, and optionally an Expense account. |
  • +-----------------------------------------------------------------------------+
  • | 3. SERVICE |
  • | - Intangible labor, professional services, or consulting hours sold. |
  • | - Links to a Service/Fee Income account, and optionally an Expense acct.|
  • +-----------------------------------------------------------------------------+
  • | 4. BUNDLE (Group Items) |
  • | - A collection of multiple existing items sold together under one name. |
  • | - Does NOT link directly to GL accounts; postings route through each |
  • | individual underlying component item within the bundle. |
  • +-----------------------------------------------------------------------------+
  • Item Account Mapping Mechanics

When configuring a Service or Non-inventory item:

Income Account: Selected under "Income account" (e.g., 40100 Consulting Revenue ). When this item appears on an Invoice or Sales Receipt, QBO credits this income account.

Purchasing Information: If the box "I purchase this product/service from a vendor" is checked, an Expense Account must be mapped (e.g., 50100 Subcontractor Expense ). When the item appears on a Bill, Expense, or Check, QBO debits this expense account. +-----------------------------------------------------------------------------+

  • | ITEM TO GL POSTING MECHANISM |
  • +-----------------------------------------------------------------------------+
  • | OPERATIONAL EVENT | ITEM MAPPING ROUTING | GL POSTING ENTRY |
  • +----------------------------+------------------------+-----------------------+
  • | Invoice Issued to Client | Mapped Income Account | Dr. AR / Cr. Income |
  • | Sales Receipt Cash Sale | Mapped Income Account | Dr. Cash / Cr. Income |
  • | Bill Entered from Vendor | Mapped Expense Account | Dr. Expense / Cr. AP |
  • | Inventory Item Sold | Mapped Asset & COGS | Dr. COGS / Cr. Inv. |
  • | | | Dr. AR / Cr. Income |
  • +-----------------------------------------------------------------------------+
  • 5. Customer and Vendor Lists Management

Managing business relationships in QBO requires structured setup in the Customers and Vendors centers:

Customer List Hierarchy & Sub-Customers

Parent-Child Relationships: QBO allows establishing sub-customers (jobs or properties) under a parent customer.

Billing Options:

Bill with parent: Invoices issued for the sub-customer roll up onto the parent customer's statement.

Bill this customer: The sub-customer is invoiced independently with its own distinct billing address.

Vendor List Parameters & 1099 Compliance

1099 Contractor Tracking: Checking the box "Track payments for 1099" flags all non-credit card payments (checks, ACH, cash) made to this vendor for inclusion on annual Form 1099-NEC / Form 1099-MISC reporting.

Tax Identification Number (TIN): Captures the contractor's Social Security Number (SSN) or Employer Identification Number (EIN) as substantiated by Form W-9.

6. List Maintenance: Inactivating vs. Merging Records

In QuickBooks Online, historical data integrity is protected by strict list management rules: +-----------------------------------------------------------------------------+

  • | MAKING INACTIVE vs. MERGING |
  • +-----------------------------------------------------------------------------+
  • | ACTION | INACTIVATING (Soft Delete) | MERGING RECORDS |
  • +----------------+----------------------------+-------------------------------+
  • | Purpose | Hides unused accounts/names| Combines duplicate records |
  • | History | Preserved completely | Reassigned to target record |
  • | Reversible? | YES (Click 'Make Active') | NO (PERMANENT & IRREVERSIBLE) |
  • | Restrictions | System accounts cannot be | Cannot merge accounts of |
  • | | made inactive | different Account Types |
  • +-----------------------------------------------------------------------------+
  • Making Records Inactive

QBO does not allow hard-deleting accounts, customers, vendors, or items that have transaction history. Instead, users select Make Inactive . To view or restore an inactive record:

Open the list (e.g., Chart of Accounts or Customers).

Click the Gear Icon (⚙️) above the table header.

Check Include inactive .

Click Make active next to the deactivated record.

Merging Duplicate List Items

When duplicate accounts, customers, or vendors exist, they can be merged into a single consolidated record:

Open the duplicate record that will be eliminated.

Edit its Display Name (for customers/vendors) or Account Name (for GL accounts) so that it matches the target surviving record's name exactly .

Click Save .

QBO displays a confirmation dialog: "That name is already being used. Would you like to merge the two?"

Click Yes . All historical transactions are permanently reassigned to the target record.

Loading diagram... Products and Services List GL Account Mapping Architecture