5.2 Chart of Accounts, Products/Services & List Management

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:

1. Navigate to Gear Icon (⚙️) -> Account and Settings -> Advanced.
2. In the Chart of accounts section, click the pencil edit icon.
3. Check Enable account numbers and optionally check Show account numbers.
4. 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:

1. Open the list (e.g., Chart of Accounts or Customers).
2. Click the Gear Icon (⚙️) above the table header.
3. Check Include inactive.
4. 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:

1. Open the duplicate record that will be eliminated.
2. Edit its Display Name (for customers/vendors) or Account Name (for GL accounts) so that it matches the target surviving record's name exactly.
3. Click Save.
4. QBO displays a confirmation dialog: "That name is already being used. Would you like to merge the two?"
5. Click Yes. All historical transactions are permanently reassigned to the target record.