Packaging marketing reporting dashboard: one parcel cost, named owners

What to take away

Finance, the agency and the warehouse each count a different thing, so three correct spreadsheets can still disagree on cost per shipped parcel.
Fix one definition firsttotal packaging and fulfilment cost divided by parcels sent.
Reconcile each source to that definition every month, and publish a variance note with a named owner when the numbers differ.
A tile with no named source of record and no named owner is not ready for the dashboard.
Any plastic cost line needs its Plastic Packaging Tax position checked with HMRC, including the rate in force.

Why three correct spreadsheets disagree

Finance, the agency and the warehouse each measure a different event, so all three can be right and still not match. Finance counts invoiced cost. The agency counts media and creative spend. The warehouse counts parcels despatched.

An illustrative England subscription box team runs one spreadsheet from each, and none agrees on cost per shipped parcel. That is a normal starting point, not a sign of poor bookkeeping. The fault lies in the missing shared definition.

A single dashboard does not remove the disagreement, it exposes it early. Build one core view first, then add filtered views for channel and product line once the core numbers reconcile.

Fix one definition of cost per shipped parcel

Cost per shipped parcel means total packaging and fulfilment cost divided by parcels sent. Write that sentence into the build notes before any chart exists, because every disagreement between the sources traces back to what each one leaves out.

The cost includes packaging materials, pick and pack labour, carrier charge and any Plastic Packaging Tax. Agency media and creative spend sits outside that sum and feeds the response figures instead, so it should not be pushed into the parcel cost to make the totals agree.

cost per shipped parcel = (packaging materials + pick and pack labour + carrier charge + Plastic Packaging Tax) / parcels sent

For fuller metric definitions and reporting cycles, the measurement and reporting guide sets out the terms used here.

Reconcile monthly and publish the variance

Reconcile each source to the definition every month. Then publish a variance note with a named owner whenever the numbers differ, so the gap becomes a task with a name on it instead of an argument in a meeting.

Pull the finance, agency and warehouse figures for the same calendar month.
Map each figure to the definition of cost per shipped parcel, line by line.
Compare the finance-based result with the warehouse parcel count.
Write the variance notethe gap, the likely cause and the owner chasing it.
Publish the note beside the tile, with the refresh date.

The aim is one shared number for decisions. Where a reconciliation fails, show the failure rather than a rounded figure, and fix the common measurement mistakes before the first board report.

Five tiles, five sources, five owners

Each metric needs a system of record and a person who defends it. Write both into the build notes, so that when a figure moves, the owner explains why.

Front-page tile	Source of record	Owner
Cost per shipped parcel	Finance ledger reconciled with warehouse despatch count	Finance manager
Response rate	Agency campaign platform	Agency account lead
Damage rate	Warehouse management system	Warehouse operations manager
Tax-relevant tonnage	Packaging specification sheet and HMRC Plastic Packaging Tax records	Sustainability lead
Engagement figure, such as landing page sessions	Web analytics platform	Marketing analyst

Core packaging metrics

Cost per shipped parcel, by component
Response rate by channel vs baseline
Unboxing content engagement
Return and damage rate
Plastic packaging tonnage for tax

Keep the front page to five tiles. The Office for National Statistics publishes leisure and tourism spending data that can explain seasonal swings in packaging demand, so a dip is not misread as a campaign failure.

If the response tile will justify budget, agree how credit is assigned first. The attribution methods article covers the practical options.

The plastic tax line

Where packaging includes plastic, cost lines should reflect the Plastic Packaging Tax on packaging with less than 30% recycled content. The sustainability lead owns that tile and should confirm which duties fall on your business.

HMRC says a business that has manufactured or imported 10 or more tonnes of plastic packaging in the last 12 months may need to register for the tax. Ask your packaging supplier which side of that line it sits on.

The rate changes, so do not hard-code it into a tile. Read the figure in force from HMRC's guidance on the day you refresh, and record that date beside the cost line.

Before the numbers go to the board

Choose metrics that answer a decision someone actually makes. Which ones earn a place on the page is a separate job, covered in the key metrics guide. Reconciliation comes first, because a metric built on unreconciled sources only repeats the disagreement in a tidier chart.

One written definition of cost per shipped parcel.
Each source reconciled to it for the latest month.
A variance note, with a named owner, for every gap.
Every tile has a source of record, an owner and a refresh date.
The plastic tax line carries the rate in force, dated.

Common questions

Whose number is right when finance and the warehouse disagree?

Neither wins by default. Each counts a different event, so reconcile both to the written definition and publish a variance note with a named owner.

How often should the sources be reconciled?

Monthly. Publish the refresh date, so readers know how current the data is.

Does agency spend belong in cost per shipped parcel?

No. The definition covers packaging materials, pick and pack labour, carrier charge and any Plastic Packaging Tax. Agency spend is reported from the agency's own records and sits beside the parcel cost, not inside it.