Short answer: In QuickBooks Online, open Reports, search for Sales by Product/Service Summary or Sales by Product/Service Detail, choose the reporting period, and use the report’s available filters. The Detail report is useful when you need the transactions behind the total. Available reports and filters can vary by subscription and report.
Choose the question before the report
| Question | Best starting report | Important filters |
|---|---|---|
| How much did product X sell? | Sales by Product/Service Summary | Date range, product/service, customer, class or location when available. |
| Which transactions make up that number? | Sales by Product/Service Detail | The same scope, then transaction and customer detail. |
| What did customer X buy? | Sales by Customer Detail or Product/Service Detail | Customer, date, product/service. |
| Was product X profitable? | Not sales alone | Revenue plus correctly classified direct and indirect costs. |
| What is the company’s profit? | Profit and Loss | Date, cash or accrual basis, class/location when available. |
Why sales and profit and loss differ
A sales report organizes revenue around customers, products, services, and transactions. A profit-and-loss statement organizes income and expenses by accounts. Product sales can answer “what was sold,” but they do not automatically answer “what was profitable.” Cost classification, timing, discounts, refunds, payroll, overhead, and accounting basis all affect that answer.
When a connected command center exposes both, it should label the source report, applied filters, refresh time, and cash-or-accrual basis. It should not combine the numbers into an invented financial conclusion.
A safe guided-filter pattern
- Report: sales summary, sales detail, or profit and loss.
- Time: exact start and end dates, not only labels such as “last month.”
- Scope: product/service or P&L account line.
- Segments: customer, class, location, or other fields the connected company actually uses.
- Basis: cash or accrual where the report supports it.
- Evidence: source, refresh time, applied filters, and a route to the underlying report.
What the QuickBooks Online API can support
Intuit’s official Sales by Product documentation lists report inputs including item, customer, class, start date, end date, accounting method, and summary grouping. That makes dropdown-style guided queries possible in a read-only interface, but only when the company’s QuickBooks data uses those fields consistently and the connected account supports them.
When the answer should stop
Stop and reconcile when the result lacks a source timestamp, the product mapping is incomplete, reports use different bases, or a command-center total does not match the authoritative QuickBooks report. Read-only reporting is safer than writing corrections from a dashboard; financial corrections belong in QuickBooks under the company’s accounting controls.