Welcome to Common Cents. Know what you really make.

Every cost on every order, down to one number, with the working shown.

Common Cents

Ana Serra’s Business Tote, Black Business Tote, Black Ana Serra · New York Your own US entity Price, one order US$360.00 Duties and taxes included
  • Product cost Supplier’s unit cost US$136.80
  • Shipping and fulfilment US$24.66
  • Freight US$3.00 a kg by air, 3 kg a tote US$9.00
  • Delivery Ground rate, zone 2, 5 lb US$10.41
  • Pick and pack US$2.73 an order + US$0.48 an item US$3.21
  • Packaging A box and two tissue sheets US$1.43
  • Storage US$0.45 per cu ft, about 2 months US$0.61
  • Payments US$12.72
  • Card processing 2.9% + US$0.30, Shopify Payments US$10.74
  • Chargebacks and fraud 0.6% of sales before tax US$1.98
  • Marketing 12.6% of sales before tax US$41.66
  • Duty and tax US$45.05
  • Duty 10% on the import value US$13.68
  • Customs processing fee 0.3464% of the import value US$0.47
  • Customs broker US$154.95 an entry of 100 totes US$1.55
  • NY sales tax 8.875%, inside the price US$29.35
  • Returns and filing US$15.48
  • Returns 2.8% of the price US$10.08
  • Filing 1.5% of the price US$5.40

Fifteen cost lines US$276.37

What you make US$83.63

Excel reconciliation, from Excel into Lumanora

Map it once. Let it flow.

Coming next: bring the spreadsheets that hold your orders, purchase orders and stock straight into Lumanora.

The illustration shows one sheet’s run:

  1. Sheet added: ana-serra.xlsx, with its Products, Stock, Orders and POs tabs; the Products tab carries the Cream Serra Blazer with its HS code, 6204.31.20.10. Adding it is the trigger.
  2. Map columns, on the Products tab: Style code (AS-BLZ-CRM) is matched to SKU, Style name (Cream Serra Blazer) to Product, HS code (6204.31.20.10) to HS code and Supplier (Italian Denim Co) to Supplier.
  3. Your agent checks the HS code. It can reach your spreadsheets and Lumanora, and nothing else.
  4. Clare, in Operations, confirms the mapping.
  5. Lumanora is updated: Products, Inventory, Sales orders and Purchase orders.
  6. The steps are saved as a flow, ready for the next sheet.
  1. Bring your sheet

    Orders, purchase orders or stock, laid out the way you already keep them.

  2. Matched for you

    Columns find their place in Lumanora, and you confirm anything unclear.

  3. Your agent, within bounds

    Use your own AI agent or Lumanora’s, limited to your sheets and Lumanora.

  4. Make it a flow

    Save the steps you repeat as flows of your own, ready for the next sheet.

Forecasting. From your own sales.

Units sold, last 30 days 684
Pace 22.8 a day
Sell-through 28%
Stock cover 79 days
684 units sold in the last 30 days, 22.8 a day. Projected at that pace, the 1,800 units in stock last 79 days; the Business Tote, Black is reordered in 12 days.

Get in touch with Lumanora. Talk to one of our experts.