Distribution
Route-wise reporting: the six numbers that matter
Distribution is a business of routes. If reports cannot be cut by route and booker, they cannot change what happens tomorrow morning.

The six numbers
For each route and booker, measure: net sales, returns, amounts received, balance due, receivables ageing and scheme/discount cost. Together they tell you whether a route is growing, leaking or being over-discounted.
- Net sales — invoices minus returns, by route and by company, category or item.
- Returns — returns per route next to sales; a rising share means bad ordering or damaged stock.
- Received — receipts allocated to the period's invoices, per route and booker.
- Balance due — what the route's shops still owe on those invoices.
- Ageing — balances per shop in 0–30, 31–60, 61–90 and 90+ day buckets, filtered by route.
- Scheme cost — bonus quantities and discounts compared with net sales.
Why most distributors cannot get them
The data exists — on invoices. The problem is that invoices rarely carry the route, booker and delivery person as structured fields, so reports need a clerk re-keying into Excel. By then the day is over.
Proaqsa ERP puts booker, delivery person, route, area and city on every invoice; receipts record the collector, and returns follow their original invoice. The Distribution Sales Report groups sales, returns, receipts and balance due by any of those fields, with CSV and print. The day plan lists which shops each route covers on a weekday, with last invoice and balance due.
A simple weekly routine
- Monday: receivable ageing by route → follow-up list to each booker.
- Daily: day plan in the morning, load sheet for the van, collections at close.
- Friday: net sales, returns and discounts per route; adjust next week.
Go plan and above
Route reports included.
FAQ
Frequently asked questions
Can I report by booker and delivery person separately?
Yes. Both are fields on the invoice; the report can group by either.
What about customers without a route?
They post normally. Customers without a route show as Unplanned, and their sales appear under Unassigned in the route report.