Understanding your numbers
How Total Sales Are Calculated
Total Sales is the amount your customers actually paid (or owe) for their orders, after returns and refunds are accounted for. Juicy calculates it the same way every time, so the number stays consistent even when orders are edited or partially refunded weeks later.
The formula
Total Sales = Gross Sales − Discounts − Returns + Shipping Charges + Return Fees + Taxes
| Component | Description |
|---|---|
| Gross Sales | The original price of all line items, before any discounts or taxes |
| − Discounts | The total value of all discount codes and automatic discounts applied |
| − Returns | The net value of returned items (refunded line items minus order adjustments) |
| = Net Sales | Gross Sales − Discounts − Returns |
| + Shipping Charges | What the customer paid for shipping, minus any refunded shipping |
| + Return Fees | Restocking fees and return shipping fees charged to the customer |
| + Taxes | All taxes collected, minus taxes refunded |
| = Total Sales | Net Sales + Shipping Charges + Return Fees + Taxes |
Which date a number lands on
Juicy splits every component between two dates, and this is the part that most often causes confusion when comparing against Shopify's own reports.
Order date
These are always attributed to the date the order was originally placed:
- Gross Sales
- Discounts
- Shipping charges (before refunds)
- Taxes (before refunds)
This includes items added to an order after it was originally placed. Even if an item is added days later through an order edit, the revenue still counts on the original order date.
Refund date
These are attributed to the date the refund was actually processed, not the original order date:
- Returns (refunded line items and refunds independent of line items)
- Refunded shipping
- Refunded taxes
- Return fees (restocking fees, return shipping fees)
- Restocked COGS
So if a customer orders on January 1st and returns an item on February 15th, the original sale shows up in your January numbers and the return shows up in February — not both on January 1st.
Worked example
A customer places an order on March 1st with a $20.00 discount code:
| Item | Net price | Taxes |
|---|---|---|
| T-Shirt | $80.00 | $10.00 |
| Socks | $50.00 | $6.25 |
| Shipping | $5.00 | — |
On March 10th, the customer returns the T-Shirt. They receive an $80.00 refund (the item price minus the $10.00 discount allocated to it) plus the $10.00 tax on that item. A $5.00 restocking fee is charged.
March 1st — order date
| Component | Calculation | Amount |
|---|---|---|
| Gross Sales | $80.00 + $50.00 | $130.00 |
| Discounts | discount code | −$20.00 |
| Net Sales | $110.00 | |
| Shipping Charges | $5.00 | |
| Taxes | $10.00 + $6.25 | $16.25 |
| Total Sales | $131.25 |
March 10th — refund date
| Component | Calculation | Amount |
|---|---|---|
| Returns | T-Shirt net after discount | −$70.00 |
| Refunded Taxes | tax on T-Shirt | −$10.00 |
| Return Fees | restocking fee | +$5.00 |
| Impact on Total Sales | −$75.00 |
Frequently asked questions
Why doesn't my Total Sales match Shopify's report for this month?
The most common cause is order edits. Shopify can move edited revenue to the edit date, while Juicy keeps it on the original order date — so totals for the same period can differ slightly between the two even though the underlying orders are identical.
Does a return always reduce the month it was ordered in?
No. Returns are attributed to the refund date, not the order date. An order placed in one month and refunded the next will show the original sale in the first month and the return in the second.
Does Total Sales include taxes?
Yes. Taxes collected are added, and any taxes refunded are subtracted, as part of the Total Sales formula.
Still have questions? Email support@easyapps.cloud and we'll walk through your numbers with you.