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. Last 30 days.

Paid for labels
$4,075.56
232 labels
Charged to customers
$2,981.00
Lost on shipping
$1,094.56
Average label
$17.57

What stands out

  • 146 orders of 232 cost more to ship than the customer was charged.
  • 116 orders shipped free, costing $2,065.29 in labels. That cost has to be covered by the part's price.
  • USPS · Ground Advantage is the most-used service: 86 labels averaging $17.58.

By carrier and service

Download CSV
CarrierLabelsPaidAverage label
USPS · Ground Advantage86$1,511.62$17.58
USPS · Priority Mail72$1,245.83$17.30
UPS · 2nd Day Air42$739.35$17.60
UPS · Ground32$578.76$18.09

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
20287Diego Baker1$0.00$28.18$28.18
20208Caleb Okafor1$0.00$28.04$28.04
20514Lakeshore Fabrication (Louisville)1$0.00$27.71$27.71
20202Ottawa Packaging (Fort Wayne)1$0.00$27.35$27.35
20263Ottawa Packaging (Erie)1$0.00$27.22$27.22
20567Summit Auto Repair (Holland)1$0.00$27.13$27.13
20491Great Lakes Conveyor (Erie)1$0.00$26.96$26.96
20073Lakeshore Fabrication (Green Bay)1$0.00$26.51$26.51
20652Summit Auto Repair (Fort Wayne)1$0.00$26.35$26.35
20096Tom Tanaka1$0.00$26.23$26.23
20663Great Lakes Conveyor (Holland)1$0.00$26.19$26.19
20334Great Lakes Conveyor (Grand Rapids)1$0.00$26.02$26.02
20176Grace Lindqvist1$0.00$25.64$25.64
20752Lakeshore Fabrication (Fort Wayne)1$0.00$25.55$25.55
20057Harbor Plating (Kalamazoo)1$0.00$25.35$25.35
20384Great Lakes Conveyor (Greenville)1$0.00$25.32$25.32
20496Ottawa Packaging (Lansing)1$0.00$25.12$25.12
20039Northfield Dairy (Rockford)1$0.00$25.12$25.12
20588Great Lakes Conveyor (Tulsa)1$0.00$24.97$24.97
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
20126Great Lakes Conveyor (Holland)1$0.00$24.09$24.09
20337Northfield Dairy (Louisville)1$0.00$23.53$23.53
20290Great Lakes Conveyor (Holland)1$0.00$23.52$23.52
20037Great Lakes Conveyor (Holland)1$0.00$23.45$23.45
20326Kent Tool & Die (Tulsa)1$0.00$23.04$23.04
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
20632Diego Castillo1$0.00$22.35$22.35
20222Cedar Valley Foods (Louisville)1$0.00$22.28$22.28
20745Lakeshore Fabrication (Louisville)1$0.00$22.11$22.11
20598Cedar Valley Foods (Fort Wayne)1$0.00$21.89$21.89
20701Great Lakes Conveyor (Erie)1$0.00$21.54$21.54
20693Ottawa Packaging (Grand Rapids)1$0.00$21.22$21.22