Make it the report your team actually wants
Break it down your way
SKU and week in one table. Channels pivoted across the top. A calculated column for return rate. One filter for the vendor meeting.
In the inbox every Monday
Schedule it as CSV, Excel or PDF to the people who need it, filtered to last week, and nobody exports it by hand again.
Or we build the version you need
Describe it in the app. Our team builds it and emails you when it is ready, soon after. How it works.
What it looks like
One row per product, variants and SKUs rolled up: gross sales, then the discounts and refunds that came off, then what was left. Sorted by net sales, so the products that carried the month sit at the top and the revenue lost to returns is easy to spot.
| Product | Net quantity | Gross sales | Discounts | Returns | Net sales |
|---|---|---|---|---|---|
| Trail Runner 2 | 1,284 | $166,920 | -$12,418 | -$9,360 | $145,142 |
| Merino Crew Sock, 3-pack | 3,910 | $109,480 | -$8,205 | -$1,960 | $99,315 |
| Alpine Shell Jacket | 412 | $98,880 | -$6,120 | -$7,200 | $85,560 |
| Daypack 22L | 736 | $66,240 | -$3,975 | -$2,880 | $59,385 |
| Insulated Bottle 750ml | 2,118 | $52,950 | -$2,640 | -$750 | $49,560 |
| Total | 8,460 | $494,470 | -$33,358 | -$22,150 | $438,962 |
What each number means
So the figure means the same thing to everyone who reads it.
- Gross sales
- Price times quantity on each sold line, before discounts, taxes and shipping.
- Discounts
- Line discounts plus each line's share of order-level discounts, as a signed amount. Discounts reduce sales; discount reversals on refunds add back to this column.
- Returns
- Returned product value before discounts and tax, as a negative amount. A refund counts whether or not the goods came back.
- Net sales
- Product revenue after discounts, refunds and order adjustments. No tax, shipping, duties or payment fees, so this is what the products earned.
- Net quantity
- Units sold minus units refunded in the period.
- Dates
- Every sale and every refund is dated to the day it happened. A September refund of an August order lands in September.
Already have Shopify's reports?
Shopify's own reports can be edited, saved and exported to a spreadsheet (Shopify Help). That covers a one-off. ReportNerds keeps the exact version your team needs, sends it on a schedule, and our nerds build the ones you would rather not.
More reports
Inventory value
What is the stock we hold worth right now, at cost and at retail?
Gross margin by product
Which products make money after the cost of goods, and which only look like they do?
Sales by vendor
Which vendors' products earned the most after discounts and refunds?
Inventory by location
How many units of each SKU sit at each location, and how many are already spoken for?
Inventory on a date
What did we hold, where, and what was it worth, on any past day?
Monthly tax summary
How much tax was recorded on last month's orders, and where?
Custom reporting
Your reports, your shape, on schedule. Or our team builds them for you.