Banyan

Concept. Real parts; orders, customers and money are sample data. Nothing live is changed.

Reports › Accounting

Shipping costs Sample data

What labels cost against what customers were charged, by carrier, and the orders that lost money on shipping. This year.

Paid for labels
$12,477.83
720 labels
Charged to customers
$9,024.00
Lost on shipping
$3,453.83
Average label
$17.33

What stands out

  • 466 orders of 720 cost more to ship than the customer was charged.
  • 375 orders shipped free, costing $6,505.00 in labels. That cost has to be covered by the part's price.
  • USPS · Ground Advantage is the most-used service: 258 labels averaging $17.13.

By carrier and service

Download CSV
CarrierLabelsPaidAverage label
USPS · Ground Advantage258$4,420.15$17.13
USPS · Priority Mail231$4,006.49$17.34
UPS · Ground121$2,140.09$17.69
UPS · 2nd Day Air110$1,911.10$17.37

Orders that cost more to ship than was charged

Download CSV
OrderCustomerPackagesChargedLabel costShortfall
20246Kent Tool & Die (Toledo)1$0.00$28.90$28.90
20240Kent Tool & Die (Kalamazoo)1$0.00$28.86$28.86
20249Summit Auto Repair (Kalamazoo)1$0.00$28.85$28.85
20128Northfield Dairy (Toledo)1$0.00$28.81$28.81
20549Sofia Tanaka1$0.00$28.77$28.77
20753Northfield Dairy (Toledo)1$0.00$28.68$28.68
20378Nadia Okafor1$0.00$28.68$28.68
20583Elena Nguyen1$0.00$28.64$28.64
20210Elena Jensen1$0.00$28.59$28.59
20180Riverbend Machine (Greenville)1$0.00$28.56$28.56
20341Northfield Dairy (Kalamazoo)1$0.00$28.52$28.52
20293Kent Tool & Die (Toledo)1$0.00$28.34$28.34
20646Midwest Hydraulics (Green Bay)1$0.00$28.25$28.25
20287Diego Baker1$0.00$28.18$28.18
20111Lakeshore Fabrication (Green Bay)1$0.00$28.10$28.10
20081Ottawa Packaging (Holland)1$0.00$28.05$28.05
20696Diego Castillo1$0.00$28.05$28.05
20208Caleb Okafor1$0.00$28.04$28.04
20538Harbor Plating (Lansing)1$0.00$27.90$27.90
20038Nadia Okafor1$0.00$27.85$27.85
20381Kent Tool & Die (Grand Rapids)1$0.00$27.76$27.76
20514Lakeshore Fabrication (Louisville)1$0.00$27.71$27.71
20677Lakeshore Fabrication (Louisville)1$0.00$27.50$27.50
20178Midwest Hydraulics (Louisville)1$0.00$27.48$27.48
20282Summit Auto Repair (Greenville)1$0.00$27.45$27.45
20202Ottawa Packaging (Fort Wayne)1$0.00$27.35$27.35
20105Midwest Hydraulics (Louisville)1$0.00$27.34$27.34
20034Lakeshore Fabrication (Green Bay)1$0.00$27.33$27.33
20566Kent Tool & Die (Kalamazoo)1$0.00$27.30$27.30
20494Riverbend Machine (Grand Rapids)1$0.00$27.29$27.29
20263Ottawa Packaging (Erie)1$0.00$27.22$27.22
20510Midwest Hydraulics (Tulsa)1$0.00$27.18$27.18
20567Summit Auto Repair (Holland)1$0.00$27.13$27.13
20371Tom Tanaka1$0.00$27.02$27.02
20491Great Lakes Conveyor (Erie)1$0.00$26.96$26.96
20587Summit Auto Repair (Kalamazoo)1$0.00$26.83$26.83
20074Northfield Dairy (Erie)1$0.00$26.75$26.75
20577Caleb Okafor1$0.00$26.71$26.71
20157Northfield Dairy (Erie)1$0.00$26.56$26.56
20073Lakeshore Fabrication (Green Bay)1$0.00$26.51$26.51