How do we report DTC and wholesale sales together without double counting?
By Trayan Hristov · Founder, Thrivelia · 19 November 2026
Put DTC and wholesale in the same financial report. Give each its own customer report underneath. A boutique paying one wholesale invoice is one trade account. It may sell those clothes to 200 shoppers you never identify. Blending the two into a single repeat rate makes the number nearly impossible to act on.
Decide who made the sale
Use the economic seller and the transaction your finance team recognises. A wholesale invoice is brand revenue when recognised under your accounting policy. The boutique’s point-of-sale report measures sell-through. If you add both, you count the same units at two points in the chain. Stock sent to a shop on consignment needs its own treatment. Confirm with finance when revenue belongs in the ledger.
Give order and invoice lines a source-system key, a channel, a currency, an effective date and a return or credit link. A draft wholesale order raised in Shopify and later invoiced in an ERP can look like two sales with different IDs. Map them to a single transaction. Keep taxes and currency conversion consistent across months.
Reconcile money first
Imagine web orders contribute £88,000 after £12,000 of returns on £100,000 of merchandise sales. A shop contributes £27,000 after returns. Wholesale invoices recognised this month are £50,000, with £5,000 of credit notes. The brand-level net merchandise figure is £160,000. A partner reports £31,000 of retail sell-through. It goes beside the £45,000 wholesale figure as a stock and demand signal. It adds zero to this month’s £160,000 bridge.
Channel | Recognised net merchandise sales | Retention unit |
Web | £88,000 | Identified buyer |
Owned shop | £27,000 | Identified buyer where available |
Wholesale | £45,000 | Trade account |
All channels | £160,000 | Report the units separately |
Give the CEO three questions they can use
For DTC, ask how many first-time buyers placed a second paid order within 90 days. Match verified store and web identities where available and report the percentage of store orders with a known customer. For wholesale, ask how many eligible accounts reordered in the next buying season. Show units sold through versus received when partner data exists. Keep unknown retail consumers anonymous.
If wholesale orders slow but partner sell-through is healthy, check stock availability, minimum order sizes and buying-calendar timing. If retail sell-through is weak, look at size curves and merchandising before asking the rep to chase another order. If DTC repeat slows, investigate customer progression. The same revenue headline can produce three different decisions.
The wholesale-to-DTC lifecycle guide covers how to earn a direct relationship. This report tells you what you can measure before one exists. Shopify sales report definitions.
What I’d ask finance to sign off
Use four lines under the channel bridge: open credits, unrecognised orders, currency differences and unmatched transactions. Keep a list of the records behind each difference. Pick a web return credited after month-end and a wholesale invoice imported into two systems. Trace both before sending the board report. When finance changes the recognition date or a retailer corrects last month’s sell-through, version the figures. Otherwise your commercial team can spend an hour explaining a change in customer behaviour that was actually an accounting adjustment.
Ask ChatGPT or Claude about your own numbers
Reconcile these anonymised channel totals against recognised net merchandise sales. Flag duplicated invoices, store transfers, credits and consignment. Then give me one consumer retention measure and one trade account measure with separate denominators.

.png)



Comments