
Linnworks records almost every event in an ecommerce operation: each order, each stock movement, each despatch and each return. The operations team uses that data every day to get orders out of the door. Directors and managers ask different questions. Are we making money on each channel? How much cash is tied up in stock? Are we keeping our promises to customers?
In many businesses, the answers come from a monthly spreadsheet pack that someone builds by hand from Linnworks exports and the accounts. This post explains how to build management reporting around Linnworks data instead, so the numbers arrive on time, match each other and can be trusted.
Operational reports and management reporting are not the same
Operational reports tell people what to do today: which orders to ship, which items to reorder, which listings have errors. Management reporting shows whether the business is heading in the right direction. It uses fewer numbers, looks at trends over weeks and months, and combines Linnworks data with costs that Linnworks may not hold.
If your day-to-day reports are the problem, start with our post on when standard Linnworks reports are not enough. This post builds on that and looks one level up.
What a management view built on Linnworks data usually includes
1. Sales and orders by channel
Revenue, order count and average order value by channel and sub-source, compared with the previous period and the same period last year. This is the easiest part, because Linnworks already holds all of it.
2. Margin by channel and product
Revenue alone hides a lot. Contribution margin takes off product cost, channel fees, postage and packaging. Linnworks can hold purchase prices and postage costs, but channel fees and advertising spend usually live elsewhere and have to be added.
3. Stock health
Stock value, days of cover, and slow or aged stock, by location and category. Reports such as inventory sales analysis by category and channel inventory by location provide the building blocks.
4. Fulfilment performance
The share of orders despatched on time, late orders by warehouse and courier, and how long orders wait before they are processed. Marketplaces measure this, so management should see it before the marketplace does.
5. Returns and refunds
Return and refund rates by channel and product, with the main reasons. A product with a high return rate can look profitable in a sales report and lose money in reality.
6. Data quality
A short count of SKUs without a cost price, items without weights and listings not linked to a stock item. A channel linking report is one example. These gaps make every other number less reliable, so they belong in the pack.
Why management reporting often goes wrong
- Numbers from different moments. Sales are exported on the 1st, stock on the 3rd and costs from last month’s accounts, so the figures never quite agree.
- No agreed definitions. One report counts orders by order date, another by despatch date. Refunds, cancellations and VAT are treated differently in each.
- Missing costs. Without purchase prices and fees, margin is a guess.
- Too many measures. A pack with forty charts gets skimmed, not used.
- One person holds it together. When they are on holiday, the pack is late or doesn’t happen.
What poor management reporting costs
- Time: days each month spent exporting, matching and checking, often by senior finance or operations staff.
- Cost: continuing to push channels or products that make little margin, and cash tied up in stock nobody noticed was slowing down.
- Risk: decisions made on figures that are weeks old or quietly wrong, and problems such as falling despatch performance spotted only after a marketplace warning.
A practical example
Imagine a seller with two warehouses, selling on Amazon, eBay and their own website. Each month the finance manager spends the first two working days building a management pack from Linnworks exports, the accounting system and marketplace fee reports. The directors see it around the middle of the month, and the first part of every meeting is spent questioning why sales in one table don’t match another. This is an illustration, but it is a common picture.
A review leads to four changes. The directors agree eight measures and write down how each one is calculated. Missing purchase prices are filled in for the top-selling SKUs. Scheduled custom queries pull orders, costs and stock from Linnworks every night, and channel fees and advertising spend are added from the accounts. A one-page dashboard updates daily, and the monthly pack is produced automatically on the first working day.
The finance manager gets those two days back, the directors see the month as soon as it closes, and meetings move from checking numbers to acting on them. The exact gain depends on how many sources you combine and how clean your data is.
How to build management reporting around Linnworks data
- Start with the decisions. List the decisions management makes each month and the questions behind them.
- Choose a short list of measures. Eight to ten is usually enough, each with a named owner.
- Write the definitions down. Decide once how to treat order dates, refunds, cancellations, VAT and costs.
- Fill the gaps in Linnworks first. Purchase prices, postage costs and SKU links make the biggest difference to accuracy.
- Bring in what Linnworks doesn’t hold. Channel fees, advertising spend and overheads usually come from your accounts or ERP.
- Automate the extract. Custom SQL queries or the Linnworks API can deliver data on a schedule to a spreadsheet, a dashboard tool or a reporting database.
- Check, then review. Compare the new figures with a month you have already checked by hand, and review the list of measures every quarter.
This doesn’t have to be a large project. For a smaller team, a scheduled report delivered to a shared spreadsheet may be enough. Businesses combining several systems often benefit from a dashboard tool or from connecting Linnworks to an ERP such as Odoo, as covered in our post on Linnworks and ERP integration. Our Linnworks reporting and SQL services and Linnworks API integration work cover the technical side.
Want management reporting you can trust?
We offer a free, no-obligation 30-minute Linnworks Efficiency Review. We look at how your management figures are put together today, where the data comes from and where time goes on manual spreadsheets, before any work is discussed.
Book your free Linnworks Efficiency Review
To see everything we do for Linnworks users, from reporting and macros to integrations and support, visit our Linnworks services page.
