Study guide
7.3 Customizing Reports, Memorized Report Groups & Management Report Packages
QuickBooks Online Certified ProAdvisor Exam
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Certification Overview & QuickBooks Online Ecosystem
1.1 Exam Logistics, ProAdvisor Academy & Certification Standards 1.2 QuickBooks Online Subscription Levels & Feature Matrix 1.3 QuickBooks Online Accountant (QBOA) Workspace, Team Management & Security
2 Chapter 2: Client Onboarding & Company Configuration
2.1 Setting Up a New Client Company, Company Settings & Custom Preferences 2.2 Chart of Accounts Architecture: Account Types, Detail Types & Numbering 2.3 Data Migration, List Imports & Beginning Balance Integrity
3 Chapter 3: Products, Services & Inventory Management
3.1 Product and Service Item Types: Services, Non-Inventory, Inventory & Bundles 3.2 Perpetual Inventory Accounting: FIFO Valuation, Asset Tracking & COGS Flow 3.3 Managing Inventory Counts, Quantity Adjustments & Reorder Points
4 Chapter 4: Sales & Customer Workflows ("Money In")
4.1 Estimates, Progress Invoicing, Invoices & Sales Receipts 4.2 Receiving Customer Payments, Undeposited Funds / Payments to Deposit & Bank Deposits 4.3 Credit Memos, Refund Receipts, Customer Statements & Bad Debt Write-offs 4.4 Automated Sales Tax Configuration, Tax Agencies & Liability Reporting
5 Chapter 5: Expenses & Vendor Workflows ("Money Out")
5.1 Purchasing Transactions: Expenses, Checks, Bills & Pay Bills 5.2 Vendor Credits, Purchase Orders & Recurring Transactions 5.3 Contractor Management, 1099 Compliance & Billable Expenses
6 Chapter 6: Banking Feeds & Account Reconciliations
6.1 Connecting Bank and Credit Card Feeds & Navigation 6.2 Feed Categorization: Match, Add, Transfer, Split & Bank Rules Engine 6.3 Month-End Account Reconciliation, Beginning Balance Discrepancies & Corrections
7 Chapter 7: Reporting & Business Insights
7.1 Core Financial Statements: Profit & Loss, Balance Sheet & Statement of Cash Flows 7.2 Cash vs. Accrual Accounting Reporting & Operational Reports (A/R & A/P Aging) 7.3 Customizing Reports, Memorized Report Groups & Management Report Packages
8 Chapter 8: Period-End Close & Accountant Tools
8.1 Books Review / Month-End Review Workflow 8.2 ProAdvisor Tools: Reclassify Transactions, Void vs. Delete & Journal Entries 8.3 Closing Date Lock, Password Protection & Tax Preparer Handoff
7.3 Customizing Reports, Memorized Report Groups & Management Report Packages
Key Takeaways Explain This Topic AI
The QuickBooks Online report customization drawer allows granular modification across four distinct panels: General (basis and rounding), Rows/Columns (reordering, % comparisons), Filter (multidimensional segmentation), and Header/Footer (branding and metadata).
Memorized custom reports can be organized into Report Groups and scheduled for automated recurring email delivery (daily, weekly, monthly, quarterly) as attached Excel spreadsheets or consolidated single PDF files.
The Management Reports tool (Reports > Management reports) creates comprehensive, publication-ready financial dossiers comprising a Cover Page, Table of Contents, Preliminary Pages, Financial Reports, and End Notes.
Preliminary Pages and End Notes within Management Reports feature a rich-text editor, enabling ProAdvisors to provide executive summaries, analytical commentary, and formal GAAP compilation disclosures.
Management Report packages can be exported to professional PDF format for client presentation or to DOCX (Microsoft Word) format for external editing, corporate branding additions, and narrative expansion.
Last updated: September 2026
Customizing Reports, Memorized Report Groups & Management Report Packages
Quick Answer: Standard financial statements provide raw data, but QuickBooks Online's customization tools transform them into actionable management intelligence. Clicking Customize on any report opens a 4-panel drawer: General (accounting basis, negative number formatting, cents suppression), Rows/Columns (reordering, prior period/year variances, % of Income), Filter (class, location, customer, vendor), and Header/Footer (company title, date/time stamps). Customized reports can be saved to Custom Report Groups and scheduled for automated recurring email delivery. For executive-level and board presentations, the Management Reports center compiles branded, multi-page financial dossiers complete with Cover Pages, Table of Contents, Executive Summaries, and End Notes, exportable to PDF and DOCX (Word) .
Deep Dive: The 4-Panel Customization Drawer
Clicking the green Customize button in the upper right corner of any standard report opens the report customization drawer. This drawer contains four distinct functional configuration panels: ┌─────────────────────────────────────────────────────────────────────────────┐
- │ Customize Report │
- ├─────────────────────────────────────────────────────────────────────────────┤
- │ [▸] General │
- │ Report period: [ This Year-to-date ▾ ] Accounting: ( ) Cash (•) Accrual│
- │ Number formatting: [ ] Divide by 1000 [x] Without cents │
- │ Negative numbers: (•) (100) ( ) -100 [x] Show in red │
- ├─────────────────────────────────────────────────────────────────────────────┤
- │ [▸] Rows / Columns │
- │ Columns: [ Select and reorder columns ] │
- │ Compare another period: [x] Previous year (PY) [x] $ change [x] % chg│
- │ Add percentage of: [x] % of Income [ ] % of Row [ ] % of Column │
- ├─────────────────────────────────────────────────────────────────────────────┤
- │ [▸] Filter │
- │ [x] Class: [ Commercial ▾ ] [x] Location: [ West Coast ▾ ] │
- │ [ ] Customer: [ All ] [ ] Vendor: [ All ] │
- ├─────────────────────────────────────────────────────────────────────────────┤
- │ [▸] Header / Footer │
- │ Company name: [ Meridian Design Group ] Report title: [ Executive P&L]│
- │ Show: [x] Date prepared [x] Time prepared [x] Report basis │
- │ Header alignment: [ Center ▾ ] Footer alignment: [ Right ▾ ]│
- └─────────────────────────────────────────────────────────────────────────────┘
- 1. General Panel
Report Period & Accounting Basis: Modify date ranges and toggle between Cash and Accrual reporting.
Number Formatting:
Divide by 1000: Compresses large corporate balances by omitting thousands (e.g., displaying $2,450,000 as $2,450), ideal for executive summaries.
Without Cents: Rounds all figures to the nearest whole dollar, eliminating visual clutter on presentation reports.
Negative Number Presentation: ProAdvisors can format negative numbers using a minus sign ( -500 ), parentheses ( (500) ), or highlighting in bold red font. Parentheses in red is the corporate standard for financial statement reporting.
2. Rows / Columns Panel
Select and Reorder Columns: Add or remove data columns (e.g., adding Memo, Account Number, or Payment Terms) and drag the column reorder handles to customize horizontal layout sequence.
Comparative Columns: Add historical benchmarks to evaluate performance trajectories:
- Previous Period (PP) vs. Previous Year (PY)
- $ Change and % Change variance columns
Common-Size Percentage Analysis:
% of Income (Gross Margin & Cost Ratio Analysis): Evaluates every line item as a percentage of Total Income. Essential for P&L benchmarking across fiscal years or against industry peers.
% of Expense: Evaluates each expense line as a fraction of total operating expenses, highlighting runaway overhead categories.
% of Column & % of Row: Evaluates structural distributions across multi-column reports.
3. Filter Panel
The Filter panel applies multi-criteria restrictions without modifying underlying transaction data:
Dimensional Segmentation: Filter by specific Classes or Locations to generate branch-level or project-specific operating statements.
Entity Filtering: Isolate activity by specific Customers , Vendors , or Employees .
General Ledger Account Filters: Restrict reports to specific accounts (e.g., generating an expense report filtered exclusively for Travel, Meals, and Entertainment).
Cleared Status: Filter by cleared status (Uncleared, Cleared, Reconciled) for bank balance audits.
4. Header / Footer Panel
Custom Nomenclature: Edit the company name, report title (e.g., changing "Profit and Loss" to "Management Performance Summary"), and subtitle.
Metadata Footers: Toggle the display of Date prepared , Time prepared , and Report basis (Cash vs. Accrual) stamps, establishing an audit trail.
Visual Alignment: Adjust alignment of header and footer text blocks to Left , Center , or Right .
Saving Custom Reports & Scheduled Automation
Once a report is tailored to client specifications, clicking Save customization preserves the configuration for future access.
The Save Customization Workflow
When saving a custom report, the user defines three core parameters:
Custom Report Name: A distinct, intuitive title (e.g., Monthly Departmental P&L by Class (No Cents) ).
Add this report to a group: Option to assign the report to an existing group or create a new group (e.g., Month-End Close Package or Weekly Cash Flow Review ).
Share with: Restrict report access to the creator ( None ) or share it with All company users. Saved reports reside permanently under the Reports > Custom reports tab. ┌─────────────────────────────────────────────────────────────────────────────┐
- │ Save Custom Report │
- ├─────────────────────────────────────────────────────────────────────────────┤
- │ Custom report name: [ Monthly Executive Board Dossier ]│
- │ Add this report to a group: [ Board of Directors Package ▾ ] [ + Add new ] │
- │ Share with: (•) All ( ) None (Private to me) │
- │ [ Cancel ] [ Save ] │
- └─────────────────────────────────────────────────────────────────────────────┘
- Report Groups & Scheduled Automated Email Delivery
One of the most powerful workflow automations in QuickBooks Online is the ability to schedule recurring, hands-free delivery of entire report groups.
Configuring the Recurrence Schedule:
Repeats: Daily, Weekly, Monthly, or Quarterly.
Delivery Timing: Select the precise day of the week (e.g., every Monday at 7:00 AM) or day of the month (e.g., the 5th day of every month, or the Last day of the month).
End Date: Can run indefinitely ( None ) or terminate on a specific calendar date.
Email Distribution Configuration:
Recipients: Enter multiple stakeholder email addresses separated by commas.
Custom Subject & Body: Enter professional messaging (e.g., "Attached is the monthly operating report package for your review" ).
Attachment Settings:
File Formats: Deliver reports as PDF or Excel spreadsheets.
The Merged PDF Feature: Selecting "Attach the report as a single PDF" consolidates all individual reports in the group into a single continuous, multi-page PDF document rather than cluttering the recipient's inbox with multiple separate file attachments.
Tip
Closing Date Synchronization: Set automated monthly report group emails to trigger after your firm's standard monthly closing date (e.g., on the 10th or 15th of the following month) to guarantee that all bank feeds are reconciled and adjusting journal entries are posted before reports are dispatched to executives.
Management Reports: Executive Financial Dossiers
While Custom Report Groups deliver raw financial statements, the Management Reports feature (accessible via Reports > Management reports ) elevates client deliverables into polished, publication-ready financial presentations suitable for board meetings, investors, and commercial lenders. ┌─────────────────────────────────────────────────────────────────────────────┐
- │ MANAGEMENT REPORT ARCHITECTURE (5 Core Building Blocks) │
- ├─────────────────────────────────────────────────────────────────────────────┤
- │ 1. COVER PAGE - Theme, Title, Subtitle, Prepared For/By, Logo │
- │ 2. TABLE OF CONTENTS - Automated Section & Page Numbering │
- │ 3. PRELIMINARY PAGES - Executive Summary / Narrative Transmittal Letter │
- │ 4. FINANCIAL REPORTS - P&L, Balance Sheet, Cash Flows, Aging (Custom Dates)│
- │ 5. END NOTES - GAAP Footnotes, Compilation Disclaimers, Disclosures│
- └─────────────────────────────────────────────────────────────────────────────┘
- The 5 Structural Components of a Management Report
- 1. Cover Page
Branding & Visual Themes: Choose from four pre-designed corporate aesthetic themes: Classic , Modern , Compact , or Simple .
Cover Metadata: Enter Cover Title (e.g., "Quarterly Performance Review" ), Subtitle ( "Third Quarter 2026" ), Prepared for, Prepared by, and Report Date.
Company Logo: Upload a high-resolution company or firm logo to display prominently on the title page.
2. Table of Contents
Automatically generates an itemized table listing every included financial statement and preliminary/end note page.
Maintains dynamic page numbering that automatically adjusts as sections are added or removed.
Can be retitled or toggled off if delivering a brief package.
3. Preliminary Pages (Executive Narrative)
Provides a dedicated rich-text document preceding the financial statements.
Use Cases: Writing an Executive Summary , Management Discussion & Analysis (MD&A), or an Accountant's Compilation Transmittal Letter.
Rich-Text Capabilities: Supports bold, italics, underline, bulleted lists, numbered lists, text alignment, and section headings.
ProAdvisors can insert customized commentary highlighting quarterly achievements, revenue trends, and working capital challenges.
4. Reports Section
Incorporates standard or customized reports into the core body of the package.
Granular Controls per Report:
Select any standard report (P&L, Balance Sheet, Cash Flows, A/R Aging, A/P Aging, Sales by Customer).
Set independent Date Ranges and Accounting Methods (Cash or Accrual) for each individual report within the package.
Reorder the sequence of reports using drag-and-drop handles.
Rename individual reports within the package (e.g., renaming "Profit and Loss" to "Consolidated Statement of Operations").
5. End Notes (Disclosures & Disclaimers)
Appears immediately following the financial statements.
Use Cases: Including formal GAAP footnote disclosures, significant accounting policies, summary of debt covenants, Non-GAAP metric reconciliations, or standard CPA compilation disclaimers ( "No assurance is provided on these financial statements..." ).
Supports full rich-text formatting identical to Preliminary Pages.
Export Formats: PDF vs. DOCX (Word)
Once a Management Report is assembled and previewed, QuickBooks Online supports two distinct export formats:
Export Format Optimal Use Case Capabilities & Limitations
Export to PDF Final client delivery, board presentations, lender submissions. Generates a fixed-layout, professionally paginated, read-only PDF with crisp vector fonts and embedded logos. Ready for immediate emailing or printing.
Export to DOCX (Word) Advanced formatting, corporate collaboration, external graphics. Generates an editable Microsoft Word document. Enables ProAdvisors to embed external Excel charts, insert complex custom tables, modify margins, or collaborate with legal counsel on disclosure text.
Important
Exam Distinction: Custom Reports vs. Management Reports: Exam questions often test when to use Custom Report Groups versus Management Reports. Use Custom Report Groups for automated recurring email delivery of operational reports to internal staff. Use Management Reports when the client requires a branded, styled financial presentation package with cover pages, executive commentary, and formal footnotes.