Seeing Margin Per Order, Not Just Per Month
Short answer: Most trading companies discover their true margin per order only at month-end, when it is too late to change anything. A dashboard connected to your AutoCount cost data shows gross margin per order, per customer, and per product line in real time — so you can act on it.
The Problem With Monthly Margin Reports
Month-end P&L tells you the business was profitable (or not). It does not tell you which orders drove that result and which ones quietly eroded it.
For trading companies selling to dozens of customers across multiple product lines, the average margin number hides a lot. Within that average, you typically have:
- A group of customers buying at healthy margins
- A group where margins are thin but volume is high
- A handful of accounts where the actual landed cost, freight, and discounts given mean you are breaking even or worse
Without per-order visibility, you cannot tell those groups apart until month-end — and even then, AutoCount does not surface the breakdown without custom reporting.
What Per-Order Margin Requires
Calculating margin per order requires three data points arriving together:
- Selling price — already in your sales invoice
- Cost of goods — landed cost per unit, including supplier price and freight allocation
- Discounts and adjustments — credit notes, rebates, or special pricing that affect the actual realised price
AutoCount holds all three, but they live in separate modules. The AutoCount integration layer pulls them together and calculates gross margin at the line level, then rolls it up per order, per customer, and per product.
What the Dashboard Shows
| View | What You See |
|---|---|
| Per order | Selling price, landed cost, gross margin %, date |
| Per customer | Total revenue, total margin, average margin %, trend over 3/6/12 months |
| Per product line | Margin by SKU or category, volume vs margin scatter |
| Per salesperson | Revenue and margin side by side — so high-revenue reps aren't hiding low-margin orders |
The business dashboard updates from AutoCount data daily or in near real time, depending on your setup. No manual export, no spreadsheet consolidation.
Why This Changes Decisions
Two examples that appear regularly in trading businesses:
Freight-heavy orders. A customer ordering small quantities frequently looks healthy on revenue. Per-order margin shows the freight cost eating 8–12% of the margin on each order. The fix might be a minimum order value, a freight charge, or a conversation — but you can only have that conversation when you can see the number.
Special pricing without review. Sales teams grant discounts to move stock or close deals. Individually, each discount seems reasonable. Aggregated per customer over six months, the pattern shows which accounts are consistently receiving concessions that bring them below the margin threshold the business needs.
Both situations are common. Neither is visible from month-end totals alone.
How It Connects to AutoCount
Wei Yot, who previously worked at AutoCount, built much of our integration approach around how AutoCount stores cost data — specifically, how average cost is maintained per item and how landed cost can be allocated across a GRN. The integration reads that data directly rather than relying on manual journal entries or reports, which means the margin figures are consistent with AutoCount's own cost accounting.
This matters because any discrepancy between the dashboard margin and AutoCount's eventual P&L creates confusion. The integration is designed to produce numbers that reconcile cleanly at month-end.
FAQ
Does this work if we use different costs for different customers?
Yes. The margin calculation uses the actual cost recorded against each purchase order and GRN, not a fixed standard cost. If you buy the same item at different prices from different suppliers, the system uses the specific cost that was allocated to that stock.
What if our landed cost includes freight allocated across multiple items?
Freight allocation across a mixed GRN is one of the trickier parts of margin reporting, but it is handled in the integration. You define the allocation method — by value or by weight — and the system applies it consistently across all items on that GRN.
Can we filter margin reports by salesperson or region?
Yes. The dashboard can slice margin data by any dimension that exists in your AutoCount records — customer, salesperson, region, product category, or a custom field you define.
Book a System Audit