Management reporting for trade and wholesale: margin, inventory and working capital (2026)

Management reporting for trade and wholesale: margin, inventory and working capital

From margin per product group to inventory turnover and the cash conversion cycle — the reporting that makes a wholesaler steerable.

What makes management reporting for trade and wholesale different?

Management reporting for trade and wholesale differs from other business models on three points: the result consists of a thin margin on high volume, the capital is tied up in inventory and receivables, and the profit on paper can sit far from the cash in the bank.

‍

The first point sets the sensitivity. Where a service firm works with gross margins of tens of percent, a wholesaler earns the difference between purchase and sale — often a few percent after discounts. A margin shift of one percentage point, through price pressure, a changed customer mix or increased purchase prices that were not passed on, can cut the result in half. The report must therefore surface that shift early, and at the level where it arises: per product group, per customer and per supplier.

‍

The second point is the balance sheet. Inventory is typically a wholesaler’s largest item, with receivables right behind it. Together they determine how much capital the business needs to run — and how much room there is to grow. A report that only shows the P&L misses half the story.

‍

The third point follows from the first two: at a wholesaler, growth costs money first. More revenue means more inventory and more receivables, and those must be financed before the margin comes in. A growing business with a healthy P&L can still run into its credit limit — and exactly that is what the report must make predictable, for management and investors.

‍

The foundation remains the standard structure of a good management report: summary, P&L, balance sheet, cash flow, variance analysis, KPIs and commentary. The rest of this article fills in that structure for the trading model.

Which KPIs belong in the management report of a wholesaler?

The management report of a wholesaler runs on five to eight KPIs, with gross margin and inventory turnover at the core. This is the set that makes the difference in practice:

• Gross margin per product group, customer and supplier. The total says little; the breakdown shows where the margin is earned and where it leaks away.
• Inventory turnover. How often the inventory turns per year — per category, because an average hides the slow movers.
• Obsolete inventory. The aging profile of the inventory and the provision against it: what no longer sells is not an asset but a loss in the making.
• DSO and DPO. How fast customers pay and how fast the business itself pays — together with inventory days the building blocks of the cash conversion cycle.
• Working capital as a percentage of revenue. The measure of how much capital every euro of revenue ties up — and the first indicator when growth starts to pinch.
• Delivery reliability. The percentage of order lines delivered complete and on time: the operational KPI that predicts revenue and customer retention.
• Order intake and order book. The forward-looking revenue indicator, especially where customers order on contract or on call.
• Result per branch or entity. With multiple branches, sales entities or countries: the same layout per unit, next to the group picture.

For presentation, the fixed rule from the main article applies: per KPI the level, the trend over at least twelve months and the comparison against budget and last year — with seasonal patterns, the comparison against the same month last year is indispensable. And limit the first page to a maximum of eight figures; the breakdowns belong in the appendices.

How do you report margin per product group, customer and supplier?

The margin reporting of a wholesaler starts from one principle: total gross margin is an outcome, not a steering figure. Steering happens on the layers beneath it — and each asks for its own angle.

‍

Per product group, the report shows margin and revenue side by side, with the movement against budget and last year. That makes visible whether a margin decline comes from price pressure or a shifted mix: identical margins per group, but more volume in the thin groups, depresses the total just as hard as a real price cut — and calls for a different response.

‍

Per customer, it is about the net margin: after volume discounts, rebate agreements and early-payment discounts. Large customers with deep discounts can deliver less at the bottom line than mid-sized customers without them — you only see that when the discounts are attributed to the customer instead of parked as one collective line below revenue.

‍

Per supplier, the purchasing terms come into play: annual rebates, growth bonuses and promotional contributions. The pitfall is timing — whoever books a supplier rebate only on receipt reports a margin that is too low all year and a spike in the rebate month. Accrue the expected rebate pro rata to the months in which the purchases fall, and true up at settlement.

‍

Two valuation agreements make the margin figures reliable. First: use one consistent cost basis for all groups, so margins are comparable. Second: fix how supplier price increases flow through into cost of goods sold, so a margin decline does not stay hidden for months in an outdated inventory valuation. The commentary then names the groups and customers where action is needed — with the action attached.

How do you get a grip on inventory in the report?

Inventory is a wholesaler’s largest balance sheet item and the easiest to ignore: as long as the shelves are full, it feels like an asset. The report makes it steerable with three fixed components.

‍

The first is turnover per category: the velocity of the inventory, calculated as cost of goods sold divided by average inventory. Report it not as one total but per product group — fast and slow movers otherwise average each other out. Falling turnover at flat revenue means: more is coming in than going out, and that is a purchasing decision that can be corrected.

‍

The second is the aging profile. Classify the inventory by how long it has been sitting and by the last sale date per item, and tie the obsolescence provision to it. Whatever sits longer than an agreed threshold enters the provision — on a fixed schedule, not as an annual surprise at the physical count. That shifts the conversation from “how much do we write off” to “what do we do with these items”: mark down, return or phase out.

‍

The third is the reconciliation between system and reality. The inventory in the books and the inventory in the warehouse drift apart through count differences, breakage and unbooked receipts. Report the count difference from the cycle counts as a fixed line — a growing difference points to process problems that also pollute the margin figures.

‍

Together these three tell what the balance sheet item is really worth and how much cash sits inside it. That makes the inventory section the bridge between the P&L and working capital — the subject of the next section.

How do you steer on working capital and the cash conversion cycle?

The cash conversion cycle (CCC) measures how long a euro stays tied up between paying the supplier and collecting from the customer: inventory days plus receivable days (DSO) minus payable days (DPO). It is the summarizing working capital KPI for a wholesaler.

‍

A worked example. A wholesaler has 60 inventory days, a DSO of 45 days and a DPO of 40 days. The cash conversion cycle is then 60 + 45 − 40 = 65 days: every euro of cost is on the road for over two months before it comes back. At EUR 12 million of revenue and a margin of a few percent, that quickly means several million in permanently tied-up capital — capital that grows along with growth.

‍

The report makes the cycle steerable by showing the three components separately, as trends over at least twelve months and against budget — one composite number otherwise hides which component is moving. DSO improves with tight receivables management and credit limits per customer; inventory days with the turnover steering from the previous section; DPO by actually using the agreed payment terms — where deliberate payment behavior is something else than structurally paying late, because that costs supplier credit and purchasing position.

‍

What matters is the link with growth. Whoever wants to grow 20% with a CCC of 65 days must pre-finance the extra working capital before the extra margin comes in. The report should show that need next to the credit headroom, so the financing question is on the table before it becomes urgent. For the translation into scenarios and liquidity forecasts, this connects to forecasting for SME CFOs.

How do you structure the management report for a wholesaler?

The management report for a wholesaler follows the seven fixed sections from the main article on the good management report — each with its own trading interpretation:

1. Summary. One page with the margin and working capital trend in charts, the largest deviations and the three messages of the month.
2. Profit and loss statement. Revenue, cost of goods sold and gross margin as the core, with discounts and rebates visibly attributed; month and year-to-date next to budget and last year.
3. Balance sheet. Inventory, receivables and payables first, with the aging analyses of inventory and receivables as fixed appendices.
4. Cash flow. The working capital movement shown separately: how much cash growth cost or released this month.
5. Variance analysis. The margin deviation split into price, volume and mix, against budget and last year — so the conversation is about the cause instead of the amount.
6. KPIs. The set from this article as trends: margin breakdowns, turnover, obsolescence, DSO/DPO, CCC, delivery reliability, order intake.
7. Commentary. The story: which product groups and customers carried the deviation, what is the purchasing market doing, which decisions are on the table?

With multiple entities — a purchasing entity that supplies sales entities, branches per country or a holding on top — the group level comes on top: the intercompany deliveries and margins must be eliminated at group level, otherwise revenue double-counts and internal margin stays stuck in the inventory. How that works is covered in management reporting for a holding company with multiple entities and consolidation for SME CFOs.

‍

For the format, the norms from the main article apply: at most around ten pages as Word or PowerPoint in PDF format, or a dashboard with the same layout, delivered within 5-10 working days after month-end.

How do you automate the reporting from your accounting system?

The figures for the report come from two layers: the ERP or inventory system (items, orders, stock levels) and the accounting system (revenue, cost of goods sold, receivables, payables, cash). The automation gain sits mainly on the financial side — and it can be captured directly.

‍

Dutch trading companies run their administrations on accounting packages such as Exact Online, AFAS or MS Dynamics 365 Business Central. Finstack connects these and more packages — including Twinfield, Odoo, Xero and QuickBooks — directly via the API, read-only and at transaction level: the actuals refresh automatically every day, with a manual refresh at any moment. With multiple entities, the consolidation from the previous section runs along automatically, including the elimination of intercompany deliveries — from 1 to 50 entities, without separate intercompany accounts.

‍

Reporting then happens wherever the team wants to work. The Finstack dashboards show revenue, margin, working capital and the cash position in real time, with every line clickable through to the source transaction. Whoever builds the management report in their own Excel or Google Sheets model — for example to place item and order data from the ERP next to the financial figures — uses the 2-way integration: the financial actuals refresh in the existing model in one click. You can also share dashboards and reports with stakeholders such as management, investors and the accountant, by giving them access to Finstack, with access rights set per user.

‍

The effect on the rhythm: the numbers side of the report is ready on day one instead of after days of copy-paste work, and the time shifts to margin analysis and purchasing conversations. Finstack starts from EUR 39 per month for the first entity: live in 5 minutes, set up within a day.

The 3 most common mistakes in wholesale reports

Three patterns we see again and again at trading and wholesale companies. Each costs margin or cash; each is preventable with the right setup.

Sources and provenance

• Finstack — Reporting & insights (dashboards, Excel/Sheets sync): finstack.io/solutions/reporting-insights
• Finstack — Integrations with Exact, AFAS, Business Central and other packages: finstack.io/solutions/integrations
• Finstack Help Center — Sources & connections (sync frequency, security): help.finstack.io
• Finstack — Pricing (from EUR 39/month): finstack.io/pricing

Last reviewed: 25 July 2026 · Next review: October 2026