Study guide

7.4 Management Reports, Customization, Tagging & Exporting

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

7.4 Management Reports, Customization, Tagging & Exporting

Key Takeaways Explain This Topic AI

Operational subsidiary reports provide essential working capital intelligence: Accounts Receivable (AR) Aging Summary and Detail track past-due customer balances across 30-day aging buckets, while AP Aging manages vendor obligations.

Multi-dimensional financial segmentation is enabled via Classes (departmental/product-line P&L tracking), Locations (geographic/branch tracking), and Tags (custom non-posting transaction labels for operational reporting).

The QuickBooks Online Audit Log maintains an unalterable chronological record of all system activities, capturing transaction creations, edits, deletions, user logins, and automated recurring actions with user IDs and timestamps.

Customized reports can be memorized into Report Groups and scheduled for automated recurring email distribution to key stakeholders in PDF or Excel attachments.

Management Report packages assemble formal, multi-page executive presentation booklets containing cover pages, executive summaries, tables of contents, and compiled financial statements suitable for boards and lenders.

Last updated: August 2026

7.4 Management Reports, Customization, Tagging & Exporting

Core Principle: Beyond standard financial statements, QuickBooks Online features a comprehensive suite of operational subsidiary reports, multidimensional tracking dimensions (Classes, Locations, Tags), forensic audit logging, and automated management reporting tools. Bookkeepers must know how to extract granular working capital insights from AR/AP aging schedules, track departmental profitability, enforce internal controls via the Audit Log, and distribute customized executive reporting packages.

Operational & Subsidiary Reports: Working Capital Analytics

While primary financial statements provide consolidated entity-level data, operational subsidiary reports provide the transactional detail required to manage daily working capital, collections, vendor relationships, and inventory velocity. +-------------------------------------------------------------------------------------------------+

  • | KEY QBO OPERATIONAL & SUBSIDIARY REPORTS |
  • +-------------------------------------------------------------------------------------------------+
  • | REPORT NAME | PRIMARY ACCOUNTING PURPOSE | KEY METRICS & STRUCTURE |
  • +------------------------------+--------------------------------+---------------------------------+
  • | AR Aging Summary | Monitors customer credit risk | Displays total unpaid balances |
  • | | and past-due invoice aging | grouped by: Current, 1-30, |
  • | | | 31-60, 61-90, and 91+ days past |
  • +------------------------------+--------------------------------+---------------------------------+
  • | AR Aging Detail | Granular collections tool for | Lists individual unpaid invoice |
  • | | credit managers | dates, invoice numbers, due |
  • | | | dates, and open balances |
  • +------------------------------+--------------------------------+---------------------------------+
  • | AP Aging Summary / Detail | Manages vendor debt obligations| Categorizes unpaid vendor bills |
  • | | and cash outflow timing | by aging bracket to prevent |
  • | | | late payment fees |
  • +------------------------------+--------------------------------+---------------------------------+
  • | Sales by Customer Summary | Identifies revenue concentration| Ranks customers by total gross |
  • | | and top revenue drivers | sales volume and % of sales |
  • +------------------------------+--------------------------------+---------------------------------+
  • | Sales by Product/Service | Evaluates product line margins | Displays units sold, gross |
  • | | and inventory sales velocity | revenue, COGS, and margin % |
  • +------------------------------+--------------------------------+---------------------------------+
  • | Expenses by Vendor Summary | Analyzes vendor spend and | Aggregates total disbursements |
  • | | concentration risk | across all operating vendors |
  • +------------------------------+--------------------------------+---------------------------------+
  • Accounts Receivable Aging Analysis Walkthrough

The AR Aging Summary report divides outstanding invoices into aging brackets based on the Days Past Due (calculated from the transaction due date to the report date):

Current: Invoices within agreed credit terms (e.g., Net 30 terms where 15 days have elapsed).

1 - 30 Days Past Due: Invoices 1 to 30 days overdue; triggers standard friendly reminder emails.

31 - 60 Days Past Due: Invoices requiring direct phone collections contact and credit holds.

61 - 90 Days Past Due: Severely delinquent accounts requiring formal demand letters.

91+ Days Past Due: High-risk debt requiring bad debt allowance evaluation or collection agency placement.

Multidimensional Tracking: Classes, Locations & Tags

QuickBooks Online provides three distinct tools to segment financial performance without creating an overly bloated, convoluted Chart of Accounts. +-------------------------------------------------------------------------------------------------+

  • | MULTIDIMENSIONAL TRACKING: CLASSES VS. LOCATIONS VS. TAGS |
  • +-------------------------------------------------------------------------------------------------+
  • | FEATURE | CLASSES | LOCATIONS | TAGS (TAG GROUPS) |
  • +--------------------+-----------------------------+-----------------------------+-------------------------+
  • | Availability | QBO Plus & Advanced | QBO Plus & Advanced | All QBO Tiers |
  • +--------------------+-----------------------------+-----------------------------+-------------------------+
  • | Primary Purpose | Track departmental / segment| Track geographic branches, | Custom operational |
  • | | profitability (e.g., Sales, | retail stores, regions, or | project tracking |
  • | | Service, Construction) | operating divisions | (e.g., Marketing event) |
  • +--------------------+-----------------------------+-----------------------------+-------------------------+
  • | Transaction Level | Line-item level (split | Header level (entire | Header & line level |
  • | | across multiple lines) | transaction assigned) | (non-posting tag group) |
  • +--------------------+-----------------------------+-----------------------------+-------------------------+
  • | Financial Reports | Profit and Loss by Class | Profit and Loss by Location | Profit and Loss by Tag; |
  • | Supported | (Balance Sheet by Class | AND Balance Sheet by | Tag performance metrics |
  • | | unassigned balances exist) | Location (Full segmentation)| |
  • +--------------------+-----------------------------+-----------------------------+-------------------------+
  • | General Ledger | Modifies GL reporting slices| Modifies GL reporting slices| NON-POSTING; does not |
  • | Impact | | | alter GL accounts |
  • +--------------------+-----------------------------+-----------------------------+-------------------------+
  • Practical Implementation: Departmental Class Tracking

When a commercial contractor runs a project, an invoice line for $5,000 in roofing is tagged with the class Commercial Construction , while a second line for $2,000 in architectural design is tagged with Design Services . Running a Profit and Loss by Class report provides gross margin and net operating income for each business unit side-by-side, allowing leadership to eliminate unprofitable divisions.

The QBO Audit Log: Forensic Internal Controls & History

The Audit Log ( Gear > Tools > Audit Log ) is an immutable, forensic audit tracking system built into QuickBooks Online. It maintains a permanent, tamper-proof record of every system event, user action, and transaction modification. +-------------------------------------------------------------------------------------------------+

  • | FORENSIC AUDIT LOG CAPABILITIES |
  • +-------------------------------------------------------------------------------------------------+
  • | EVENT CATEGORY | WHAT THE AUDIT LOG CAPTURES AND DISPLAYS |
  • +------------------------+------------------------------------------------------------------------+
  • | Transaction Lifecycle | Records exact user name, date, and timestamp for when any transaction |
  • | | is Added, Edited, Deleted, Voided, or Cleared. |
  • +------------------------+------------------------------------------------------------------------+
  • | History & Value Diffs | Clicking 'View' on an edited transaction shows side-by-side historical |
  • | | changes (e.g., Original Amount: $500 -> Modified Amount: $5,000). |
  • +------------------------+------------------------------------------------------------------------+
  • | Reconciliation Events | Tracks when reconciliations are started, completed, or when reconciled|
  • | | transactions are manually unreconciled in the register. |
  • +------------------------+------------------------------------------------------------------------+
  • | User Logins & Access | Tracks user login timestamps, sign-offs, password changes, and access |
  • | | permission modifications by Master Administrators. |
  • +------------------------+------------------------------------------------------------------------+
  • | System Automation | Tracks automated recurring transactions, bank feed auto-rules, and |
  • | | third-party app synchronization activities. |
  • +------------------------+------------------------------------------------------------------------+

Bookkeeper Forensic Tip: If a previously reconciled bank balance becomes unreconciled due to a deleted check, the bookkeeper opens the Audit Log, filters by Transactions and Deleted/Voided Transactions , identifies the offending transaction details (check number, payee, amount, original account), and re-enters the transaction to restore reconciliation integrity.

Customizing, Saving & Scheduling Report Groups

QuickBooks Online allows bookkeepers to customize standard reports, save them to the Custom Reports tab ( Reports > Custom reports ), and organize them into Report Groups for automated distribution. +-------------------------------------------------------------------------------------------------+

  • | REPORT CUSTOMIZATION & AUTOMATION WORKFLOW |
  • +-------------------------------------------------------------------------------------------------+
  • | STEP 1: CUSTOMIZE STANDARD REPORT |
  • | • Open base report (e.g., Profit and Loss) |
  • | • Customize Report Period (e.g., 'This Year-to-Date'), Accounting Method ('Accrual') |
  • | • Apply Filters (e.g., Class = 'Commercial', Customer = 'All Active') |
  • | • Configure Header/Footer (Add Company Name, Report Title, Disclaimer Note) |
  • | |
  • | STEP 2: SAVE CUSTOMIZATION & ASSIGN TO REPORT GROUP |
  • | • Click 'Save Customization' button |
  • | • Enter Custom Report Name (e.g., 'Executive Monthly P&L - Accrual') |
  • | • Add to an existing or new Report Group (e.g., 'Monthly Board Review Package') |
  • | |
  • | STEP 3: CONFIGURE SCHEDULED EMAIL DISTRIBUTION |
  • | • Navigate to Reports > Custom reports > Edit Report Group |
  • | • Set Schedule: Repeats Monthly (e.g., 5th business day of each month) |
  • | • Enter Recipient Email Addresses, Subject Line, and Email Body Text |
  • | • Attach file formats (PDF attachment or Excel spreadsheet) |
  • | • QBO automatically compiles and transmits the report batch on the scheduled dates |
  • +-------------------------------------------------------------------------------------------------+
  • Management Report Packages & Data Export (Excel vs. PDF)

In addition to custom report groups, QuickBooks Online includes a specialized Management Reports builder ( Reports > Management reports ). Management reports produce polished, professional presentation booklets that package financial statements with formal executive narrative documents. +-------------------------------------------------------------------------------------------------+

  • | QBO MANAGEMENT REPORT PACKAGE STRUCTURE |
  • +-------------------------------------------------------------------------------------------------+
  • | DOCUMENT SECTION | CUSTOMIZATION OPTIONS AND CONTENT |
  • +------------------------+------------------------------------------------------------------------+
  • | 1. Cover Page | Custom booklet title, subtitle, company logo, author name, and date |
  • | | formatted with professional graphic themes (e.g., Modern, Airy, Bold). |
  • +------------------------+------------------------------------------------------------------------+
  • | 2. Table of Contents | Auto-generated page numbering linking all included financial statements|
  • +------------------------+------------------------------------------------------------------------+
  • | 3. Executive Summary | Customizable narrative section where the bookkeeper writes operational |
  • | | commentary, highlights working capital variances, and notes milestones |
  • +------------------------+------------------------------------------------------------------------+
  • | 4. Financial Reports | Bundled statements: Profit and Loss, Balance Sheet, Cash Flows, |
  • | | AR Aging Summary, and custom management schedules |
  • +------------------------+------------------------------------------------------------------------+
  • | 5. End Notes | Financial disclaimers, basis of presentation disclosures, or GAAP notes|
  • +------------------------+------------------------------------------------------------------------+
  • Exporting Report Data: Excel vs. PDF Comparison

When sharing report data with external parties, QBO provides two export formats, each serving distinct professional objectives:

Export to PDF: Generates fixed-layout, print-ready, read-only documents preserving formatting, borders, and page breaks. Best for formal client presentations, board meetings, and regulatory filings where data immutability is required.

Export to Excel (.xlsx): Generates active electronic spreadsheets preserving full general ledger data. Crucially, QBO exports mathematical subtotals as live Excel formulas (e.g., =SUM(C5:C22) ), allowing CPAs, financial analysts, and tax preparers to conduct dynamic financial modeling, scenario planning, and tax workpaper cross-referencing.

Loading diagram... QuickBooks Online Operational Reporting & Management Report Architecture