Hi, shop-messages2022.
The reason your transaction report in QuickBooks Online is showing zero-quantity line items is due to the system design, which does not natively filter or exclude these lines in reports. While the customization options allow filtering by non-zero transaction amounts, they do not specifically target quantity fields for individual line items.
To filter out $0 quantity transactions in your report (though zero-quantity line items will remain), consider pulling up Transaction Detail by Account report and follow these steps:
- Click Group by in the top-right corner of the report and select Product/Service (with sub-products).
- In the Filter section, set:
- First column: Amount
- Second column: is greater than
- Third column: 0
- Click Save As to save your customized report.
You can also use this as another workaround:
- Manually delete unused (zero-quantity) lines from recurring invoices before saving them. This ensures your reports display active line items only and removes the clutter of unused lines. (manually removing unused or zero-quantity lines from recurring invoices is currently the only way within QuickBooks to prevent these lines from appearing in reports.)
- Export the report to Excel and use Excel’s filtering tools to remove rows with a quantity of 0. This gives you a clean version tailored to your needs.
Additionally, the type of report you’re running (e.g., Sales by Product/Service, Transaction List by Customer, or Transaction Detail by Account) may impact available options. Confirming the report type can help identify any report-specific adjustments that might be applied.
Feel free to reply below if you have further questions.
