About
If you've noticed that the "Returned Sales" on your Dashboard doesn't match the "Refunds & Returns" line on your P&L report, you're not wrong, and nothing is broken. They're designed to show you different things, and that difference is actually working in your favor.
Here's a quick guide to understanding what each number means and when to use which.
The Short Version
Dashboard = your operational view. It shows you all returns as they happen, so you can act on them right now.
P&L Report = your accounting view. It follows strict accounting rules (accrual or cash basis) to produce accurate financial statements.
Both numbers are correct. They're just answering different questions.
What's Actually Different?
1. The Dashboard Shows All Returns & Refunds. The P&L Only Shows Recognized Ones.
This is the biggest difference. Under accrual accounting, a return only hits your P&L when the original sale was already recognized as revenue. If the order was never shipped, the revenue was never recognized, so the refund simply reverses a "pending" entry behind the scenes, without touching your P&L at all.
The Dashboard doesn't care about that distinction. A return is a return.
Example: TikTok / Amazon (Marketplace)
A customer orders a $50 item on TikTok Shop. Before it ships, they cancel and get a refund.
Dashboard: Shows $50 in returned sales. You need to see this because your operations team should know about it. Maybe there's a trend, maybe inventory needs adjusting.
P&L: Shows $0. The revenue was never recognized (it was sitting in deferred revenue), so there's nothing to reverse on the P&L statement.
Another customer receives their $50 order, then returns it a week later.
Dashboard: Shows $50 in returned sales.
P&L: Also shows $50. The sale was recognized at fulfillment, so the return reverses it.
Example: Shopify (DTC)
A customer buys a $75 shirt and it ships the next day. Two weeks later, they return it.
Dashboard: Shows $75 in returned sales.
P&L: Also shows $75. The order was fulfilled, so the sale was already recognized. Both numbers agree here.
Another customer places a $75 order but cancels before it ships.
Dashboard: Shows $75 in returned sales. Your ops team needs to see the cancellation.
P&L: Shows $0. No revenue was ever booked, so there's nothing to reverse.
What about sales tax? When a return includes a sales tax refund, that amount is tracked separately under Sales Tax Liability in your Balance Sheet. It doesn't appear in the Dashboard's returned sales or in the P&L's Refunds & Returns line. So when we say a $75 item was returned, the returned sales number is $75 regardless of the tax that was collected or refunded.
2. Marketplace Adjustments (TikTok, Amazon)
On marketplaces, when a return happens, the platform may reimburse fees they previously charged you (selling fees, fulfillment fees, etc.). These reimbursements reduce the cost of the return on your P&L but don't appear on the Dashboard.
Example: TikTok
A customer returns a $50 item. TikTok reimburses you $3 in marketplace fees they originally deducted.
Dashboard: Shows $50 in returned sales.
P&L: Shows $47 ($50 return minus $3 fee reimbursement). The accounting view nets the reimbursement because it reduces the actual financial impact of the return.
On Shopify, payment processing fees (Shopify Payments, Stripe, PayPal) are tracked as a separate selling expense. They don't affect your returns number on either view.
When Should I Use Which?
I want to... | Use |
Know how many returns I had this month | Dashboard |
Spot a product with a high return rate | Dashboard |
Track return trends across my stores | Dashboard |
See the financial impact on my bottom line | P&L |
Share numbers with my accountant or lender | P&L |
Understand my gross margin after returns | P&L |
The Dashboard is built to help you make faster business decisions. It shows you what's happening right now across all your stores and channels in one place. The P&L gives you the precise accounting picture that follows GAAP rules.
Why the Gap Gets Smaller Over Time
If you look at a period far enough in the past (say, two or more months ago), the gap between the Dashboard and P&L numbers gets much smaller. That's because most orders that were going to be fulfilled have been fulfilled, and most returns have completed their lifecycle. The main remaining differences will just be small marketplace adjustments.
For recent periods, the gap is naturally larger because many orders are still in transit or pending fulfillment.
The Bottom Line
Your Dashboard is your real-time operational command center. It gives you the full picture of what's happening with returns right now, so you can act on it. Your P&L follows accounting rules to give you the precise financial impact. Both are correct, both are useful, and together they give you a more complete view of your business than either one alone.
Sales are also recognized differently for the dashboard and the P&L. To learn more, check out this article on why sales look different in your dashboard and P&L.