Vedron’s analytics is the number that is the same whether finance, warehouse or marketing opens it. One source for revenue by channel, margin per SKU, customer acquisition cost by campaign, inventory turn by category and cash conversion cycle, across every currency and every company in the group. The source is the operational data itself, which keeps the number honest.
The three metrics that drive a growing ecommerce business
Margin per SKU per channel. The headline revenue number does not say which SKUs make money. A SKU selling well on Amazon at a 7 percent commission makes a different margin from the same SKU on Allegro at 12 percent. After returns and refunds, two SKUs with identical gross margin can have very different net contribution.
Vedron calculates per SKU per channel: gross revenue, marketplace commission, FBA or LVB fee, return cost, net revenue, cost of goods sold, net margin. The result is a ranking of SKUs by actual profit contribution, not by top-line sales.
Return rate by SKU. Returns hide margin. A 20 percent return rate on a SKU with an 18 percent gross margin means the SKU is losing money. Vedron tracks returns per SKU per channel and surfaces SKUs where return rate exceeds the margin.
Cash conversion cycle. Days inventory outstanding plus days sales outstanding minus days payable outstanding. For an ecommerce business, this is the number that tells you how much working capital the next unit of growth needs. Vedron calculates it live from inventory, invoices and bank data.
Multi-currency, with the correct FX rate
Revenue posted in PLN, GBP and EUR aggregates to the reporting currency at the right FX rate per the rules in post 135. The analytics view carries both: the local-currency figure (what the buyer paid) and the reporting-currency figure (what the business books).
A seller running Allegro in PLN, Shopify in EUR and TikTok Shop in GBP sees the margin per SKU in each local currency and the group total in EUR, with FX gain and loss broken out separately.
Multi-company consolidation
A group with a Polish entity (PLN), a German entity (EUR) and a UK entity (GBP) consolidates in Vedron at the group level. Intercompany transactions are eliminated, FX is applied at the consolidation date, and the group P&L and balance sheet are available in the chosen group currency without a spreadsheet export.
The same analytics are available per entity (local currency, local accounting standard) and at the group level (reporting currency), with one click to switch between views.
Live, not batch
The numbers update as transactions post. A sale on Allegro at 14:00 shows in the margin view at 14:01. A supplier invoice entered at 15:30 updates the cash conversion cycle at 15:31. Finance does not wait for a nightly ETL; purchasing does not wait for a monthly rollup.
The infrastructure cost of live analytics on operational data is paid by the shared database architecture: analytics queries hit the same tables that run operations, with the right indexes.
Dashboards per role
Finance, warehouse, marketing and operations each get a default dashboard with the metrics that matter for their role, built from the same source:
- Finance: revenue by channel and company, margin per SKU, cash conversion cycle, aged receivables, VAT by jurisdiction
- Warehouse: inventory turn by category, stock-out risk, pending receipts, open transfers
- Marketing: CAC by campaign, return rate by category, conversion rate by channel, LTV by acquisition source
- Operations: order volume by channel, SLA performance (shipping, service), supplier lead time variance
A number that appears in all four dashboards is the same number everywhere; a change in operational data updates every dashboard at the same time.
FAQ
How does Vedron calculate margin per SKU per channel?
Gross revenue minus marketplace commission minus fulfillment fee (FBA, LVB, etc.) minus return cost minus cost of goods sold. The cost of goods sold uses the inventory valuation method set at the company level (FIFO, weighted average or standard cost).
Can I see margin in both the sales currency and my reporting currency?
Yes. Each line carries both the local-currency figure (what the buyer paid) and the reporting-currency figure (converted at the correct FX rate per the rules of the invoicing country). FX gain and loss are broken out separately.
How does the multi-company consolidation work?
Each entity keeps its local books in local currency with local accounting standards. The group view consolidates at the chosen group currency, eliminates intercompany transactions, and presents the group P&L and balance sheet. Switching between entity view and group view is one click.
Are the dashboards live or batch-updated?
Live. Analytics queries run on the operational database with the right indexes, so a transaction posted at 14:00 shows in the dashboard at 14:01. Finance does not wait for a nightly ETL.
Can marketing see the same revenue number as finance?
Yes, that is the point. One source of operational data drives every dashboard. The revenue number is the same whether finance, marketing or warehouse opens it.
