Open P58 claims by days-since-opened. RMG’s standard window is 30 days; anything beyond signals abandoned cash + customer goodwill loss.
At a glance
Histogram of currently-open Royal Mail P58 claims grouped by days-since-filed. The P58 form is Royal Mail’s lost / damaged / late-delivery claim form for tracked services; it is the merchant’s mechanism to recover service credits and parcel value. Royal Mail’s published resolution window is typically 30 working days; claims older than 30 days are either stuck pending merchant evidence, queued at Royal Mail awaiting review, or de facto abandoned. This card surfaces the ageing distribution so the merchant can chase, escalate, or write off appropriately.
| What it counts | COUNT(p58_claims WHERE status = 'OPEN') bucketed by DATEDIFF(NOW(), filed_at) into ranges (0-7d, 8-14d, 15-30d, 31-60d, 61-90d, 90+d). |
| Claim type | P58 only. Royal Mail has multiple claim forms; P58 is the standard “delayed, lost, or damaged” form for tracked consignments. P58 covers Tracked 24, Tracked 48, Special Delivery, and 1st / 2nd Class. International and Tracked Returns claims use different forms. |
| API endpoint | Royal Mail’s claims API surface (currently file-upload via the Business Account portal; Vortex IQ pulls the claim register weekly). Reads claimReference, consignmentNumber, filedAt, status, claimedValue, lastUpdatedAt. |
| Status definition | OPEN includes Royal Mail’s “Filed”, “Under Review”, “Awaiting Documents” states. Closed states (Paid, Declined, Withdrawn) are excluded. |
| Service level scope | All tracked services. P58 cannot be filed against untracked 1st / 2nd Class beyond a basic “missed-aim” complaint. |
| Filing window | P58 must be filed within 80 working days of expected delivery (the standard window). Once filed, Royal Mail’s published resolution SLA is 30 working days. |
| Currency | GBP. Claimed values include the parcel value (typically up to £100 for Tracked 24, up to £500 for Special Delivery 500), the carriage charge, and Royal Mail’s optional declared-value uplift if purchased. |
| Returns / RTO | RTS consignments are not directly P58-eligible; the P58 covers the original outbound failure that led to RTS. |
| Time window | RT (real-time, not period-windowed). |
| Alert trigger | any >30d triggers amber. Claims aged more than 30 days are likely stuck and need active chase. Claims aged more than 60 days are de facto abandoned unless escalated. |
| Roles | owner, operations, finance |
Calculation
Calculated automatically from your Royal Mail data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A UK DTC accessories brand running Royal Mail Tracked 24 / Tracked 48 across 8,500 consignments per month. Active customer service team files P58 claims on lost and significantly-late parcels. Reading taken at 11:00 BST on 12 Mar 26 (real-time pulse).| Claim age bucket | Open count | Median claimed value | Total claimed value |
|---|---|---|---|
| 0-7 days | 18 | £42 | £756 |
| 8-14 days | 12 | £38 | £456 |
| 15-30 days | 9 | £55 | £495 |
| 31-60 days | 5 | £68 | £340 |
| 61-90 days | 2 | £85 | £170 |
| 90+ days | 1 | £180 | £180 |
| Total open | 47 | £48 | £2,397 |
- The 0-30 day buckets (39 claims) are normal in-flight claims. Royal Mail’s published resolution SLA is 30 working days; claims in this range are simply working through the queue. No action needed.
- The 31-60 day bucket (5 claims) is the chase pile. Each is a candidate for active follow-up. Email Royal Mail’s Business Customer Services with the claim reference and the original P58 submission, ask for a status update. Most claims in this range either resolve within a week of chase or surface a missing-document gap the merchant can fix.
- The 61-90 day bucket (2 claims) is the escalation pile. These claims need a Royal Mail account-team escalation (if the merchant has a Business Account) or a written formal complaint via Royal Mail’s escalation route. Post the complaint via tracked recorded delivery (yes, tracked Royal Mail to Royal Mail) for paper-trail purposes.
- The 90+ day bucket (1 claim) is effectively written off. Royal Mail’s internal handling rarely revives a 90-day-old claim unless escalated to executive complaints. The £180 is unlikely to recover; treat it as a write-off and learn what went wrong (likely missing supporting documentation that Royal Mail has been waiting for and the merchant never re-sent).
- Total claimed value at £2,397. That is the cash recovery pipeline. At a healthy 65 to 75 percent payout rate, the merchant should expect ~£1,560 to £1,800 to land in the next 4 to 8 weeks, contingent on the 31-60d and older buckets clearing. Pair this with the merchant’s accounts-receivable view of expected service credits.
Sibling cards merchants should reference together
Claim ageing is a workflow metric. Pair it with these to act:| Card | Why pair it | What the combination tells you |
|---|---|---|
| Open Claims | The total claims register. | Open count tells workload; ageing distribution tells you how stuck the claims are. |
| Claim Value (open) | The cash-flow pipeline. | A high-value claim in the 90+ bucket is more painful than ten low-value claims in 0-7d. |
| Late Shipments | Each significantly-late shipment is a P58 candidate. | If late count is 100 per week and P58 filing rate is 5 per week, there is a 95-claim-per-week filing gap. |
| Tracked24 Service Day Promise | Tracked 24 missed-SLA shipments are direct P58 candidates. | Drops on the SLA card translate directly to filings on this card 1 to 2 weeks later. |
| Exception Rate | Lost / damaged exceptions feed P58 claims. | Spike here predicts P58 filing surge. |
| Collection vs Post-Office Handover Failure Rate | Failed handovers often produce lost-parcel P58 claims. | Identifies the upstream cause for many of the open claims. |
Cross-connector: shopify.refund_rate | Customer-side refunds for the same lost parcels. | Customer is refunded first, P58 filed second; the two metrics move together with a delay. |
Reconciling against the vendor’s own dashboard
Where to look in Royal Mail’s own portal: Royal Mail Business Account → Claims → Claim Register. Filter by Status = Open. The portal exposes per-claim age but does not aggregate into the histogram view; this card is the merchant’s first single-glance ageing distribution. For Click & Drop merchants without a Business Account, claims are filed via the P58 form and tracked manually by reference number. Vortex IQ’s connector polls the merchant’s claim-confirmation emails for status updates if the API surface is not available. Why our number may legitimately differ from Royal Mail’s portal:| Reason | Direction | Why |
|---|---|---|
| Status taxonomy mapping | Either | Royal Mail’s portal exposes ~7 status states; this card pools the open-equivalent states. Reconcile by toggling all open-states on the portal filter. |
| Email-polling lag | Ours stale | For accounts using the email-polling fallback, status updates lag by up to 24 hours. |
| Withdrawn claims | Either | A merchant-withdrawn claim sometimes shows in the portal as “closed - withdrawn” but Vortex IQ classifies as closed regardless. |
| Bulk-uploaded claims | Spike on initial connect | When a merchant first connects Royal Mail, the existing open-claims register is fully imported. Expect a one-time spike on day 1. |
| Time zone of filed_at | Boundary days off | Royal Mail’s portal in UK local; the card uses UTC for the day-difference calc. |
Sum across age buckets = roy_open_claims. The claim-age distribution is the same data as the open-claims count, just bucketed. If they diverge, ingestion is mis-classifying.
Cross-connector reconciliation:
| Card | Expected relationship | Causes of legitimate divergence |
|---|---|---|
| Open-claims cards on other carriers | Each carrier has its own claim form and process. Not directly comparable. | Use only for portfolio-level workload visibility. |
stripe.dispute_count | Lagged downstream. Lost-parcel P58 claims sometimes surface as Stripe chargebacks 3 to 6 weeks later. | Customer-side recovery (refund or replacement) usually pre-empts the chargeback. |
Documentation cross-reference (claim-age cards on other carriers). Claim-age distributions are unique to Royal Mail in the current connector set because of the formal P58 process; couriers track open claims as a single count without ageing distribution.