MyProfit

Purchases: invoices, freight and duties

Enter supplier invoices and freight or duty bills: see where every unit went and each unit's landed cost.

The Purchases page keeps your supplier invoices and the bills that land the goods (freight, duties, anything else), follows the units into the FBA shipments you send Amazon, and works out what each unit cost you landed.

Add a supplier invoice

  1. Press Supplier invoice, fill in the supplier, the invoice number and its date.
  2. If the invoice isn't in dollars, enter its currency and what one unit of it is worth in dollars (for example 0.14 for yuan).
  3. Paste the lines from your spreadsheet: the SKU, the units and the unit price on each row (a description after them is optional). Copy the columns from Excel or Google Sheets and paste; commas work too. Use your Amazon SKUs, the ones on Costs.

Add freight, duty and other bills

Freight and duties usually come on their own bills, from your forwarder or customs broker, and one bill often covers several invoices. Press Freight or duty bill, say what it is (freight by sea or by air, duties and tariffs, or other), its amount, tick the invoices it covers, and choose how to share it across their lines:

  • By value: each line's share of the goods' value. Usual for duties, which customs charge on value.
  • By volume: each SKU's cubic feet, from your package sizes on the Fee check page or Amazon's measurements. Usual for freight, so a big item carries more of it than a small one. If a SKU has no size yet, the bill is shared by units.
  • By units: the same amount on every unit.

Where every unit went

MyProfit loads your FBA shipments to Amazon every night, with what Amazon received. Each shipment takes its units from the oldest invoice that still has units of that SKU (a shipment can't take units from an invoice dated more than 60 days after it), so you see per invoice and per line:

  • Sent to Amazon and received by Amazon.
  • Not sent: still with you or your prep center, or the supplier sent fewer than invoiced.
  • Missing: Amazon closed the shipment without receiving them. These also appear on Amazon owes you as a claim, with the invoice to attach.

Landed cost

Each line's cost per unit is the invoice price in dollars plus its share of every bill, split like the Costs page: product, freight by sea, freight by air, duties and other.

Your profit uses these costs, first in, first out

Every night MyProfit puts each sale's real cost on the order: the landed cost of the batch the units came from. The units Amazon received from your oldest invoice sell first; once they are gone, sales take the next invoice's cost, and a sale never takes units from a shipment that hadn't arrived yet. So Products, Profit & loss and the Overview show what each sale really cost, without entering costs by hand, and a price rise from your supplier shows up exactly when that stock starts selling.

  • Stock you already had at Amazon before your first entered invoice sells first, at the cost on your Costs page.
  • A shipment no entered invoice covers is stock of unknown cost: its sales also keep the cost on your Costs page. Enter every invoice to have them all costed.
  • Changing a cost on the Costs page doesn't touch sales costed from an invoice. Edit the invoice or a bill instead: the sales are re-costed a few minutes later.
See it with your own Amazon data. 30 days of everything free, then $19.99 a month or the free plan. No credit card to start. Start your free trial