📦 UF Postage Audit — Master Dashboard

📅 Period:
Feb 7–28, 2026 · Fully audited period
⚠️ Action Items
Master Summary

Total Shipments

2,102
Feb 7–28, 2026
Total Shipments Count of all shipments processed by UF across all carriers in the selected period. Includes UPS, DHL, eHub/USPS, FedEx, and USPS. Does not include pickups, freight, or non-postage orders.

Total Billed

$48,538
Applied to clients
Total Billed The rate applied to each client's shipment in Shipedge — what UF charged the client for postage. This is the "applied rate" from the Shipedge export, not the carrier's actual invoice amount.

Carrier Cost

$36,402
Actual invoices
Carrier Cost What UF (as the 3PL) actually paid to the carrier — sourced from UPS, DHL, eHub, FedEx, and USPS invoices. UF pays carriers directly, then charges clients the Applied Rate. Excludes the $4.75 handling fee which is a separate line item.

Profit

$11,992
24.7% margin
Profit / Margin Profit = What UF charged clients − What UF paid carriers. UF is the 3PL — they buy postage at carrier rates and mark it up. The $4.75 handling fee is separate revenue. Margin % = Profit ÷ Billed. Healthy target: 20–30% depending on carrier mix.

Billbacks to Recover

$1,085
Post-delivery adj.
Billbacks to Recover Post-delivery charges applied by carriers after the shipment closed — weight/dim corrections, address corrections, returns, and import duties. UF paid these but has not yet invoiced the client. This money is owed to UF.

DHL Margin

32.0%
All-time matched shipments
DHL Billing — Corrected Model (Mar 13 2026) Previous $93K "unbilled surcharges" figure was a phantom based on wrong assumptions. DHL API sends all-in rate to Shipedge (fuel + signature + residential all baked in). Shipedge marks up the full rate. Surcharges ARE passing through to clients. Real issue: DHL weight adjustments (~$4K absorbed all-time on 386 shipments). Action: Bill clients based on DHL invoiced weight, not quoted weight.
Filters
Carrier:
Client:
Carrier Performance
Carrier Ships Billed Cost Profit Margin Status Notes
UPS 710$22,630$15,831 $6,79930.0% ✅ Complete Acct H15C44 · Autopay pending → ~$24k/yr savings
eHub / USPS 340$4,189$3,110 $93522.3% ✅ Complete API live · eHub cheaper <2 lb; USPS wins at 5+ lb
DHL Express 129$14,463$11,421 $3,04221.0% ✅ Complete CPAP Specials intl · $88.54 avg cost · 32% margin (corrected model Mar 13 2026 — phantom surcharge gap closed)
FedEx 25$383$336 $4712.3% ⏳ Est. Only Invoice CSV pending (2 accts) · Mar–Jul 2025 historical queued
USPS 878$5,832$4,663 $1,16920.1% ⏳ Est. Only Catholic Library Media Mail only · Invoice source TBD
TOTAL — Feb 2026 2,102$48,538 $36,402 $11,992 24.7% Profit = Billed − Carrier Cost (excl. $4.75 handling)
UPS ——$363k hist. —— 📂 Data Loaded H15C44 Jan 2026 · 8,010 rows loaded · analysis pending
FedEx ——$20.7k hist. —— 📂 Data Loaded Jan 2026 · 559 rows loaded · analysis pending
No carriers match selected filters.
Post-Delivery Charges — Pass Through to Clients
CarrierCharge TypeAmountClientStatus
UPSWeight / Dim Corrections $389.19CPAP Specials ⚠️ Bill Back
UPSImport Duties $341.77CPAP Specials ⚠️ Bill Back
UPSAddress Corrections $99.75Various ⚠️ Bill Back
UPSReturns $228.64Various ⚠️ Bill Back
DHLAddress Correction (Ship# 63973) $25.50CPAP Specials ⚠️ Bill Back
TOTAL $1,084.85
No billbacks match selected filters.
Revenue Opportunities — Money on the Table
CarrierOpportunityEst. Monthly Impact ClientStatus
DHL Remote Area Delivery — bill $50 flat (currently absorbed) +$650 CPAP Specials ⚠️ Not yet billed
DHL Residential surcharge ($6.95/ship) — markup covers it but it silently reduces margin from 26.9% → 20.6% +$2,259 CPAP Specials ⚠️ Margin leak
DHL Direct Signature — remove unnecessary default ($7.60/ship) +$937 CPAP Specials ❌ Fix Shipedge
DHL Shipedge box dims don't match actual packed size — DHL billing 39% larger volume · avg $9.97/ship gap ~$3,340 CPAP Specials ❌ Fix dims in Shipedge
UPS Autopay setup — eliminates late fee charges +$1,969 All ⚠️ Setup pending
UPS Post-delivery billbacks (weight/dim, duties, returns, address) +$1,059 Various ⚠️ Not yet invoiced
TOTAL If all items resolved +$5,441/mo
No opportunities match selected filters.
Client Breakdown
ClientCarriers UsedShipsNotes / Constraints
CPAP SpecialsUPS + DHL Express 586 UPS · 129 DHL $88.54 avg DHL cost · intl shipments · post-delivery billbacks apply
Catholic LibraryUSPS Media Mail only 877 ⚠️ Cannot use eHub consolidator · domestic only · ~$5.20 avg cost
Flavour BlastereHub/USPS + UPS + FedEx 279 + 9 intl 9 intl Canada via UPS · FedEx 2 accounts (invoice pending)
No clients match selected filters.
Profit = Applied Rate − Actual Carrier Cost (excl. $4.75 handling) · Last updated: Mar 11, 2026