Report: Orders and profit
Short answer
Shows what your EJD orders earned after EJD's invoice and freight, how fast they shipped, and which orders lost money or need you now.
This report shows how your EJD orders are going and what they earned. It comes with Growth, and needs EDI orders turned on.
- Open Reports and select Orders and profit.
- Pick a period at the top: Last 30 days, Last 90 days or Last 12 months.
- Read the sentence at the top, for example "You sent 64 orders to EJD in the last 90 days. They took 2.1 days to ship on average. 58 invoiced orders earned $1,412.60 after EJD's invoice and freight; 3 lost money."
What's on it
- Orders sent to EJD: the total and how many shipped, with a chart per day or week.
- Average days to ship: from sending the order to EJD's ship notice (856).
- Profit after EJD's invoice: what customers paid for EJD's items minus EJD's invoice total (items, freight and tax), plus any credit EJD gave back on the order. In the Profit from invoiced orders chart, red bars are periods that lost money.
- Profit per order, and how many orders lost money. These are the orders on Orders > Lost money.
- Held or with a problem: orders that need you now. Select Review them to open them on Orders.
- Problem orders, by reason: why the checks held orders in the period, such as a shipping method with no EJD code. See The order card and its checks.
- Invoiced orders: each order with EJD's invoice date, what the customer paid for EJD's items, EJD's total, the freight in that total, EJD's credits and profit, with a Download CSV button. Select an order to open it in the app. See Invoices and adjustments.
Good to know
- Profit counts once EJD's invoice (810) arrives. Orders at EJD and not yet invoiced aren't included.
- Orders are dated by EJD's invoice date, so a month here matches EJD's statement for that month. When EJD bills an order in parts, the order counts on the date of its last invoice.
- EJD total already includes freight and tax. The Freight column shows how much of the total was freight: don't add it on top. The CSV splits the total into EJD items, freight and tax, and lists EJD's invoice numbers.
- If the app has no record of what the customer paid for an order, the order shows a dash for Paid and Profit and isn't counted in the profit totals. The sentence at the top says how many.
- In the CSV, dates and times are in your store's time zone, and the file name has the period's first and last day.
- "Paid for EJD items" is what the customer paid, shipping included and sales tax left out, after any refunds. When the order also had items EJD didn't ship (from your shelf, or a gift card), it's only the EJD items' share, by what each item sold for, leaving out refunded items. It's the same amount Orders > Lost money compares, and the same as Export EJD invoices on Orders.
- Credits are EJD credit memos received for the order, such as a settled claim. They add to profit, but an order that lost money still counts as a loss.
- Payment processing fees and Shopify fees aren't included.
- Customer names and addresses aren't shown. They're removed once an order is invoiced.
- A pattern of losses on freight usually means the shipping rates you charge in Shopify are too low for what EJD bills. See Shipping profiles and freight.