QuickBooks Sales by Product/Service Report

Summary versus Detail

Start with the Summary. It puts one row per product or service against your date range. A QuickBooks moderator on Intuit’s community forum lists what it includes: "the quantity, amount, % of sales, average price, cost of goods sold, and Gross Margin." The cost and margin columns matter for inventory items. For a business selling subscriptions or services through Stripe, quantity, amount and % of sales are the ones to read.

Then open the Detail for any row that looks wrong. Intuit describes it as your sale transactions grouped by product or service, so each item expands into the sales receipts, invoices and other sales forms that used it. That is the version you use to answer "which sale put this here?"

One row the Summary will show you that has no product behind it is Not Specified. A QuickBooks Team reply on the community forum explains it: "Not Specified shows in the report if there are line items that don't have PRODUCT/SERVICE." The same thread names discounts as a common cause, because a discount entered at the bottom of an invoice is not a product line. A Not Specified balance is worth a look on any file, since it is revenue or a reduction that no item explains.

Using it to check Stripe product mapping

A Stripe integration decides which QuickBooks item each sale lands on. Whatever tool you use, this report shows you the outcome in one screen.

Run the Summary for last month and read it top to bottom with three questions.

First, does every Stripe product you sell have its own row? If you sell a monthly plan, an annual plan and a setup fee, and the report shows one item carrying all of it, the split you wanted is not happening.

Second, how much sits on the default item? Most syncs have a fallback product for sales that match no rule. A small number there is normal. A large one means new Stripe products or prices were added without a matching rule, and that revenue is reaching QuickBooks unclassified.

Third, does the average price make sense? The Summary shows one for each item. If an item you sell at 49 dollars shows an average of 12, something else is posting to it. Open the Detail for that item and look at which transactions are pulling the average down.

Then compare the report’s total with income on the Profit and Loss for the same dates and method. They will rarely match to the cent, because fees, refunds and other lines can be recorded differently. A gap that is roughly the size of a payout, though, is a strong hint that a Stripe deposit was categorized to an income account from the bank feed. That money is on the Profit and Loss and missing here, because a deposit line has no product on it.

Daily summary lines versus one receipt per sale

How busy the Detail looks depends on how your sales were written.

If each Stripe charge becomes its own sales receipt, the Detail is a long list: one line per sale under each item, with the quantity and amount of that sale. You can find a single customer’s purchase by date and amount.

If sales are posted as a daily summary instead, each item gets one line per day rather than one per charge. The totals for the month come out the same, but the Detail stops being a list of customer purchases. That is expected, not an error. It does mean the per-sale questions belong in Stripe’s own reporting, while QuickBooks answers the per-item, per-day ones.

Either way, a negative line on a sales form uses an item too. If your sync records Stripe fees as a negative line on each sales receipt, the fee item can show up on this report with a negative amount, and the report’s total is then net of fees. If fees post as a separate expense instead, they stay off the report and the item totals are gross.

Cash or accrual: which setting to run it on

The report has an Accounting method setting, and you can change it on the report itself, under Accounting method or in Customize. Intuit’s definitions are short. A cash report "counts income or expenses only once you get a payment or pay a bill." An accrual report "counts income and expenses regardless of if the invoice or bill was paid or not."

For sales recorded as sales receipts, the setting barely matters, because a sales receipt is a sale and its payment in one transaction. It lands on the same date under either method.

For sales recorded as invoices, it matters a lot. On accrual, an invoice counts toward its item when it is issued. On cash, the same revenue counts only when the invoice is paid. A Stripe subscription billed on the 28th and paid on the 2nd moves between months depending on which you pick. When you check mapping, use the method your books are reported on, and use the same one on the Profit and Loss you compare it with.