AI accounting for a trading company

A trading company knows its selling price on day one and its true cost about six weeks later, once freight, duty, handling, the forwarder charges and an exchange difference have all arrived.

Everything difficult about trading accounting follows from that gap.

The landed cost problem

Gross margin on a trade is meaningless until landed cost is complete, and landed cost completes in instalments.

The goods invoice arrives first. Freight follows. Duty and clearance follow that. The forwarder charges are last and frequently include lines nobody anticipated. Meanwhile the goods have been sold.

Two common responses, both bad:

Post costs as they arrive. Margin is overstated for weeks, then a correction lands in a later period, and neither month describes what actually happened.

Wait until everything is in. The books are accurate and six weeks late, which is too late to reprice anything.

The workable answer is accruing expected costs at the point of receipt and truing up as actuals arrive — straightforward in principle and tedious enough in practice that it is often skipped. Automation makes the accrual routine rather than a decision, and flags only the true-ups that exceed a threshold.

Foreign exchange in three places

Trading businesses meet currency at three separate points, and conflating them is the most common source of an unexplained gain or loss.

At purchase, fixing the cost of goods in your reporting currency. At payment, when the rate has moved and a realised difference appears. At period end, revaluing what is still owed.

The exchange difference is not a margin problem and should not be buried in cost of sales, because doing so makes it impossible to tell a poor buying decision from a currency movement. See importing and foreign currency and multi-currency accounting with AI.

Supplier statements are where the money is

Trading businesses have concentrated supplier relationships, high invoice values and frequent credits for short shipments, damage and price adjustments.

That combination makes supplier statement reconciliation the highest-yield accounting task available to a trading company, and it is almost never done monthly because it is slow.

What is typically found: credits raised by the supplier and never recorded, invoices entered twice under slightly different references, and price differences between order and invoice on individual lines. See supplier statement reconciliation with AI.

Automating the comparison changes the economics of this task completely, because the work was never the reading — it was the line-by-line matching.

Margin per deal, not margin per month

A monthly gross margin percentage hides everything that matters in trading. The month figure is an average of deals ranging from excellent to loss-making, and the average tells you nothing about which was which.

Deal-level margin requires costs to be attributable to the consignment they belong to, which is a data structure question rather than an intelligence one. Get that right and the interesting patterns appear on their own: the customer whose deals are always thin, the supplier whose landed cost consistently exceeds the quote, the product line that only works at volume.

What automation will not do here

Negotiate. The system will tell you a supplier landed cost runs eight per cent above quotation. The conversation is yours.

Fix a bad buy. Stock bought wrong is bought wrong. Better books surface it faster, which is worth a great deal and is not the same as preventing it.

Predict a rate. Currency forecasting is not an accounting function, and any system offering it should be treated with suspicion.

The order to tackle it in

1. Supplier statements first. Fastest findings, builds the case internally.
2. Landed cost accrual second. Makes monthly margin real.
3. Deal-level attribution third. Makes it actionable.
4. Currency separation last. Cleans up what remains unexplained.

Most trading companies attempt this in reverse, starting with a margin dashboard built on costs that are not yet complete — which produces a confident-looking number that is wrong by a variable amount.

Common questions

Why is trading margin hard to calculate accurately?

Because landed cost arrives in instalments over several weeks — goods, freight, duty, clearance and forwarder charges — while the goods have often already been sold. Posting costs as they arrive overstates margin and then corrects it later; waiting for completeness produces accurate figures too late to act on.

How should foreign exchange be handled in a trading business?

Separately at each of the three points it occurs: fixing cost at purchase, realising a difference at payment, and revaluing outstanding balances at period end. Keeping exchange differences out of cost of sales is what makes it possible to distinguish a poor buying decision from a currency movement.

What is the highest-value accounting task for a trading company?

Supplier statement reconciliation. Concentrated supplier relationships, high invoice values and frequent credits for short shipments and price adjustments mean unrecorded credits and duplicate entries are common, and the task gets skipped manually because line-by-line matching is slow rather than difficult.

Why is deal-level margin better than monthly margin?

A monthly gross margin is an average across deals that ranged from excellent to loss-making, which conceals exactly what a trading business needs to see. Attributing costs to the consignment they belong to surfaces the patterns on their own — the thin customer, the supplier whose landed cost exceeds quotation, the line that only works at volume.

Related: importing and foreign currency · supplier statement reconciliation with AI · multi-currency accounting with AI