Financial Models
6 min
chord gives you three oms explores for financial, refund, and return analysis the transactions explore covers cash movement (sales, captures, and refunds) and books refunds on the date they were issued the refund line items and return line items explores break refunds and returns down to the order line, so you can read them by product these explores are available to oms tenants quick reference, which explore should i use? business question what you want to understand explore how much revenue moved in this period, including refunds? cash basis revenue and refund dollars by date transactions which products are getting refunded, and for how much? refund dollars and refunded units by product refund line items which products are getting returned, and why? returned units and return reasons by product return line items were these refunds tied to a customer return or a cancellation? restock type behind each refunded line refund line items when was the return opened versus when was the refund issued? the two date axes (return date and refund date) transactions, return line items key dimensions and metrics transactions one row per successful cash moving transaction (sale, capture, or refund) refunds book on the date the refund was issued rather than the original order date, which keeps month over month revenue stable common metrics gross sales, net sales, # refunds, # refunds (distinct), refunded amount sum, # returns (distinct), returned quantity sum common dimensions transaction date (cash basis), transaction kind (sale, capture, refund), refund created at, return created at, return status, return closed at use this explore for revenue reporting and for refund or return dollars grouped by date refund line items one row per refunded order line join to the order line to group refunds by product (product title, sku) metrics # refund lines, refunded quantity, refunded subtotal, refunded tax, refunded amount (incl tax) dimensions restock type, refund created at, plus product fields from the joined order line use this explore to see refund dollars and refunded units by product a note on coverage the line item amounts cover merchandise only they do not include shipping refunds or order adjustments such as restocking fees, because those are not attributed to a product line the sum of per line refund amounts will be lower than a refund's full amount by that non product portion return line items one row per returned order line join to the order line to group returns by product metrics # return lines, returned quantity, refunded quantity, refundable quantity dimensions return reason, return reason note, return created at, plus product fields from the joined order line use this explore to see returned units and return reasons by product, and to find returns that are not yet fully refunded (refundable quantity greater than zero) glossary term definition how to use it where you'll see it return created at the date the return was opened matches your oms total sales and net sales reporting, which book a return when it is opened return line items, transactions (return created at) refund created at the date the refund was issued matches your oms finance and refunds reporting, which book on the refund date transactions (refund created at and transaction date), refund line items restock type how the refunded items were handled (no restock, cancel, return, legacy restock) tells you whether a refunded line was a cancellation before fulfillment (cancel) or a customer return (return) refund line items returned quantity units returned on the line the volume of product coming back return line items refunded quantity units that have already been refunded compare against returned quantity to see how much of a return has been settled return line items refundable quantity units on a return still eligible to be refunded find returns that are open and not yet fully refunded return line items refunded amount (incl tax) refunded subtotal plus refunded tax for a line product level refund value does not include shipping or restocking fee refunds refund line items choosing the right date returns and refunds sit on two different dates, and they can be weeks apart a return is opened first (return created at), and the refund is issued later (refund created at) group by return created at when you want to match your oms total sales view group by refund created at (or the transactions explore's transaction date) when you want to match your oms finance and refunds view