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 month.

Paid for labels
$1,944.11
112 labels
Charged to customers
$1,353.00
Lost on shipping
$591.11
Average label
$17.36

What stands out

  • 70 orders of 112 cost more to ship than the customer was charged.
  • 55 orders shipped free, costing $1,005.20 in labels. That cost has to be covered by the part's price.
  • USPS · Ground Advantage is the most-used service: 41 labels averaging $17.36.

By carrier and service

Download CSV
CarrierLabelsPaidAverage label
USPS · Ground Advantage41$711.70$17.36
USPS · Priority Mail38$661.03$17.40
UPS · 2nd Day Air22$371.67$16.89
UPS · Ground11$199.71$18.16

Orders that cost more to ship than was charged

Download CSV
OrderCustomerPackagesChargedLabel costShortfall
20549Sofia Tanaka1$0.00$28.77$28.77
20210Elena Jensen1$0.00$28.59$28.59
20180Riverbend Machine (Greenville)1$0.00$28.56$28.56
20208Caleb Okafor1$0.00$28.04$28.04
20202Ottawa Packaging (Fort Wayne)1$0.00$27.35$27.35
20096Tom Tanaka1$0.00$26.23$26.23
20663Great Lakes Conveyor (Holland)1$0.00$26.19$26.19
20752Lakeshore Fabrication (Fort Wayne)1$0.00$25.55$25.55
20057Harbor Plating (Kalamazoo)1$0.00$25.35$25.35
20478Nadia Moreau1$0.00$24.62$24.62
20230Harbor Plating (Grand Rapids)1$0.00$24.45$24.45
20232Harbor Plating (Holland)1$0.00$24.26$24.26
20645Elena Baker1$0.00$24.24$24.24
20037Great Lakes Conveyor (Holland)1$0.00$23.45$23.45
20704Nadia Okafor1$0.00$22.72$22.72
20019Diego Baker1$0.00$22.71$22.71
20545Kent Tool & Die (Kalamazoo)1$0.00$22.51$22.51
20222Cedar Valley Foods (Louisville)1$0.00$22.28$22.28
20693Ottawa Packaging (Grand Rapids)1$0.00$21.22$21.22
20023Riverbend Machine (Rockford)1$0.00$21.20$21.20
20184Cedar Valley Foods (Toledo)1$0.00$21.14$21.14
20522Northfield Dairy (Louisville)1$0.00$20.93$20.93
20391Ibrahim Petrov1$0.00$20.84$20.84
20125Hannah Hoekstra1$0.00$19.37$19.37
20221Kent Tool & Die (Erie)1$0.00$19.12$19.12
20706Andre Castillo1$0.00$18.89$18.89
20082Kent Tool & Die (Kalamazoo)1$0.00$18.22$18.22
20685Midwest Hydraulics (Grand Rapids)1$0.00$17.93$17.93
20351Midwest Hydraulics (Kalamazoo)1$0.00$17.85$17.85
20016Ottawa Packaging (Grand Rapids)1$0.00$17.69$17.69
20188James Moreau1$8.00$25.32$17.32
20196Nadia Moreau1$0.00$16.80$16.80
20141Summit Auto Repair (Greenville)1$0.00$16.69$16.69
20509Andre Petrov1$0.00$16.59$16.59
20117Northfield Dairy (Rockford)1$0.00$16.35$16.35
20631Lakeshore Fabrication (Green Bay)1$0.00$16.17$16.17
20115Elena Tanaka1$0.00$15.95$15.95
20118Lakeshore Fabrication (Green Bay)1$0.00$15.91$15.91
20707Ruth Tanaka1$12.00$27.76$15.76
20070Ibrahim Okafor1$0.00$15.75$15.75