A dropshipping store can look busy — orders coming in, ads running — while quietly losing money on every one of them. The only way to know for certain is a profit and loss statement that accounts for every cost that moves with an order, not just the product price and the ad spend.
This template lays out twelve months side by side. Enter orders, average order value, product cost, shipping, payment fees, ad spend, and returns for each month, and revenue, total costs, net profit, and net margin calculate themselves — with a yearly total column that blends the months you have filled in.
| Field | What goes in it |
|---|---|
| Orders / Average order value | Monthly order count and the average revenue per order. |
| Product cost / Shipping cost | What the supplier charges and what it costs to ship, per order. |
| Payment fee (% and fixed) | Your processor’s percentage and per-transaction fixed fee. |
| Advertising spend | Ad spend as a percentage of that month’s revenue. |
| Returns reserve | Allowance for refunds and chargebacks as a percentage of revenue. |
| Apps & software / Other overhead | Fixed monthly costs that do not move with order volume. |
| Revenue, total costs, net profitauto | Calculated per month and totalled for the year. |
| Net marginauto | Net profit divided by revenue, per month and for the year. |
A 4x ROAS looks healthy until product cost, shipping, payment fees, and returns are subtracted. This sheet forces every one of those costs into the same view as the ad spend.
A 2.9% + $0.30 fee looks trivial per order and is not: at a $25 average order value it is close to 4% of revenue, every single order, with no exceptions.
Apps, subscriptions, and contractor hours do not show up on a per-order profit calculation, but they come out of the same bank account. This template allocates them monthly so they are never quietly excluded.
Standardised PO with automatic line totals, HS code fields, Incoterms, and payment terms.
Carton-level packing list that calculates total units, net and gross weight, CBM, and chargeable weight.
Customs-ready invoice with per-line HS codes, country of origin, Incoterms, and a declaration block.
Weighted scorecard comparing up to four suppliers across eight criteria, with automatic ranking.
Per-SKU stock sheet that calculates safety stock, reorder point, days of cover, and reorder alerts.
A spreadsheet works until there are eleven versions of it and nobody knows which one the supplier filled in. SupplyAutomate keeps purchase orders, supplier documents, shipments, and landed costs in one workspace that updates as the order moves.