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

Paid for labels
$539.75
32 labels
Charged to customers
$410.00
Lost on shipping
$129.75
Average label
$16.87

What stands out

  • 20 orders of 32 cost more to ship than the customer was charged.
  • 15 orders shipped free, costing $257.81 in labels. That cost has to be covered by the part's price.
  • USPS · Priority Mail is the most-used service: 9 labels averaging $17.68.

By carrier and service

Download CSV
CarrierLabelsPaidAverage label
USPS · Priority Mail9$159.13$17.68
USPS · Ground Advantage10$159.07$15.91
UPS · 2nd Day Air9$154.87$17.21
UPS · Ground4$66.68$16.67

Orders that cost more to ship than was charged

Download CSV
OrderCustomerPackagesChargedLabel costShortfall
20208Caleb Okafor1$0.00$28.04$28.04
20704Nadia Okafor1$0.00$22.72$22.72
20545Kent Tool & Die (Kalamazoo)1$0.00$22.51$22.51
20023Riverbend Machine (Rockford)1$0.00$21.20$21.20
20522Northfield Dairy (Louisville)1$0.00$20.93$20.93
20391Ibrahim Petrov1$0.00$20.84$20.84
20706Andre Castillo1$0.00$18.89$18.89
20141Summit Auto Repair (Greenville)1$0.00$16.69$16.69
20509Andre Petrov1$0.00$16.59$16.59
20707Ruth Tanaka1$12.00$27.76$15.76
20710Harbor Plating (Toledo)1$0.00$14.61$14.61
20319Kent Tool & Die (Erie)1$0.00$14.08$14.08
20159Riverbend Machine (Grand Rapids)1$0.00$13.67$13.67
20511Ottawa Packaging (Grand Rapids)1$0.00$11.20$11.20
20059Ottawa Packaging (Louisville)1$17.00$26.57$9.57
20104Maria Petrov1$0.00$8.57$8.57
20705Summit Auto Repair (Kalamazoo)1$0.00$7.27$7.27
20132Summit Auto Repair (Kalamazoo)1$10.00$17.06$7.06
20211Great Lakes Conveyor (Grand Rapids)1$14.00$15.35$1.35
20185Harbor Plating (Grand Rapids)1$17.00$18.27$1.27