AI accounting for a wholesale distributor

A distributor's profit and loss looks simple and its balance sheet does not. Thin margins on high volume, most of the value tied up in receivables and stock, and two mechanisms — customer credit and supplier rebates — that are difficult to account for and material to the result.

Those two are where distribution accounting is usually weakest, and they have almost nothing to do with each other.

Receivables: the number that is not what it says

A distributor's debtors ledger is the largest asset on the balance sheet and the least examined.

Three things make it unreliable:

Unallocated cash. Customers pay round amounts covering several invoices, sometimes short, sometimes with a deduction. Allocation is fiddly, so payments sit on account, and the aged debt report shows invoices as overdue that were paid weeks ago. Collections chase them, which damages the relationship and wastes the time.

Unrecorded deductions. Customers deduct for damages, shortfalls, promotional support and returns, often without documentation. Recorded as a payment shortfall rather than as a credit note, the invoice stays partly open forever and the cost never appears in margin.

Credit notes in transit. Raised, agreed, not yet processed. Real and invisible.

The consequence is an ageing report nobody trusts, which means credit decisions are made on relationship rather than data.

Automated allocation is genuinely good at this, because matching payments to invoices across combinations is a mechanical problem with a large search space — precisely the shape where a machine outperforms a person who has forty other things to do. See automating order to cash.

Rebates: the margin that arrives later

Volume rebates, growth incentives, promotional support and settlement discounts are a substantial part of distribution margin, and they are commonly accounted for on receipt.

That is wrong in a specific and expensive way. The margin belongs to the period the sales happened in, not the quarter the credit arrives. Accounting on receipt means:

• Monthly margin is understated during the year and overstated when rebates land
• Nobody knows whether the rebate received was the rebate earned
• Missed rebates are undetectable, because there is no expectation to compare against

Accruing the earned rebate as sales occur fixes all three. It requires the entitlement rules to be recorded — thresholds, tiers, qualifying products — which is exactly the kind of thing that lives in an email from a supplier rather than in a system.

Getting those rules into a system, so that entitlement is calculated and compared to what actually arrives, is one of the highest-return exercises available to a distributor. Underclaimed rebate is common and invisible.

Stock: three specific errors

Costing method applied loosely. Weighted average calculated at the wrong point produces margins that drift from reality.

Stock in transit. Ownership transferred at shipment, goods arriving in six weeks. Frequently unrecorded, so the balance sheet understates and the payable does not match.

Provisioning by feel. Slow-moving and obsolete stock written down when someone notices rather than by policy. See dead stock: what to do with products that will not sell.

What this adds up to

A distributor with weak receivables allocation and rebate-on-receipt accounting has monthly numbers with a margin of error wider than its net margin. The business is not wrong about whether it is profitable; it is wrong about which customers and which lines are, which is the information that decisions actually need.

Fixing the accounting does not change the trading. It changes which trading you choose to do more of.

The order to fix it in

1. Cash allocation. Fastest, and it makes the debtors ledger usable.
2. Deductions as credit notes. Puts real customer cost into margin.
3. Rebate accrual. Largest single accuracy improvement.
4. Stock in transit and provisioning policy. Balance sheet integrity.

Customer profitability analysis after those four, not before. Built on unallocated cash and receipt-basis rebates, it produces a confident ranking of customers that is wrong.

Common questions

Why is a distributor's debtors ledger usually unreliable?

Because unallocated payments leave settled invoices showing as overdue, customer deductions for damages and promotional support are recorded as shortfalls rather than credit notes so invoices stay partly open indefinitely, and agreed credit notes sit unprocessed. The result is an ageing report that credit decisions cannot safely be based on.

How should supplier rebates be accounted for?

Accrued as the sales that earn them occur, rather than recognised when the credit arrives. Accounting on receipt understates margin during the year and overstates it when rebates land, makes it impossible to check whether the rebate received matches the rebate earned, and leaves underclaimed rebates undetectable.

Can automation help with cash allocation?

It is one of the strongest applications available. Matching round-sum payments to combinations of invoices, with deductions and shortfalls, is a mechanical problem with a large search space, which is where automated matching clearly outperforms a person handling it alongside other work.

What should a distributor fix first?

Cash allocation, then recording customer deductions as credit notes, then rebate accrual, then stock in transit and a written provisioning policy. Customer profitability analysis should come after those, since built on unallocated cash and receipt-basis rebates it produces a confident customer ranking that is wrong.

Related: automating order to cash · AI ERP for distributors and wholesalers · credit notes, refunds and adjustments