Comprehensive Sales Report with all fields in ONE report

Accounting & Taxes
, , ,

Topic summary

A user is requesting the restoration of a previously available “Comprehensive Detailed Sales Report” in Shopify, which they describe as essential for tax preparation.

Core Issue:

  • Current reports require manual cutting and pasting across multiple sources
  • Data totals differ between existing reports, creating accuracy concerns
  • The removed report provided all necessary tax data in a single, filterable export

Required Data Fields (in one report):

  • Transaction details: Order ID, Sale ID, Date, Transaction type, Sale type
  • Location data: Sales channel, POS location, Billing/Shipping geography (country/region/city)
  • Product information: Product details, Variant SKU, Quantities
  • Financial breakdown: Gross sales, Discounts, Returns, Net sales, Shipping, Taxes, Total sales, Shopify fees per transaction

Key Need:
Ability to filter by date and state to calculate state-specific totals for gross sales, net sales, discounts, returns, fees, and taxes.

Status: The discussion remains unresolved with no response from Shopify or other users.

Summarized with AI on October 31. AI used: claude-sonnet-4-5-20250929.
1

Please put back the Comprehensive Detailed Sales Report!

I just need that report! I can’t move forward without it. The other reports require me to cut and paste and they don’t have the same data…the totals are different. This is crucial for everyone doing their taxes. We need the comprehensive report because we need Gross Sales, Net Sales, Discounts, Returns, Fees and Taxes paid by each State. The old report had that data so it was easy to filter by state.

We need ONE report that we can filter by date and export that includes ALL the fields you need in one comprehensive report, including:

Order ID

Sale ID

Date

Transaction type

Sale type

Sales channel

POS location

Billing country/region/city

Shipping country/region/city

Product details

Variant SKU

Quantities

Gross sales

Discounts

Returns

Net sales

Shipping

Taxes

Total sales

Fees - taken by Shopify on each sale

Please email me once you have put this report back.

1 Like