The Orders screen lists every Amazon sale SeroBooks knows about, one row per order, with the invoice it became, the province it shipped to, the tax on it, what was refunded and what Amazon kept. It is the list you use when you reconcile SeroBooks invoices against an Amazon payout, look up an order a customer or Amazon support asks about, or check why an order carries the tax it does.
Every figure is Amazon's own. The columns are the amounts Amazon settled, stored as Amazon sent them; nothing on this screen adds, nets or estimates money.
How to open it
- Amazon ▸ Orders.
- The same table appears inside a settlement under Orders, tax & charges. See Settlements.
Where the orders come from
Orders are built from settlement lines as each settlement is imported. An order therefore normally appears once Amazon has settled it, up to about two weeks after the sale. If your company receives Amazon's live order feed, orders can appear earlier. References Amazon attaches to things that are not sales (a removal fee, a chargeback, a service adjustment, with no product charge, shipping or tax) are left out of this list; their money is on the Fees screen.
Each order also has its ship-to city and province added from Amazon's order report, usually within minutes of import. The province decides the tax rate on the invoice (for example 13% HST in Ontario, or 5% GST plus 7% PST in British Columbia).
Filtering
The shared period and marketplace bar filters the list. Here the period uses the order's first posted date. Picking a settlement in Any settlement shows the orders in that payout's date range; for exactly the orders in one payout, open the settlement and choose Orders, tax & charges.
Orders load 200 at a time. When there are more, a Load 200 more button appears at the foot of the table, and the footer reminds you that search and sort cover only the orders loaded so far. Narrow the period to search them all. When everything is loaded the footer reads Every order in this period.
Columns
| Column | Meaning |
|---|---|
| Date | When the order first posted. |
| Invoice | The SeroBooks invoice number, as a link. — when no invoice has been written yet; the row is then dimmed. |
| Amazon order | Amazon's order number, as a link to the Amazon order page. |
| Province | Ship-to province or state. An amber — means no province yet; hover it for the explanation. |
| Marketplace | Amazon.ca, Amazon.com and so on. |
| Channel | FBA (Amazon shipped it) or FBM (you shipped it). |
| Principal | Product charges before tax. |
| Tax | Tax collected on the order. |
| Refunded | Money refunded (amber when not zero). |
| Fees | What Amazon kept, shown negative (red). |
Sort by any column heading, search with Search this list…, and use Export for CSV, Excel or PDF of the rows on screen.
Opening an order or its invoice
- Double-click a row (or select it and press Enter) to open its invoice in the invoice window, just as the Invoices list does. The invoice carries a MARKETPLACE SETTLEMENT panel showing what Amazon actually paid for it.
- Click the Invoice number for the same.
- Click the Amazon order number to open the Amazon order page.
If there is no invoice yet you see: No invoice yet — Amazon has not settled this order. The invoice is created when the settlement arrives (usually within two weeks). Open the order itself to see everything known so far.
The Amazon order page
One order, all the way down to Amazon's own lines.
Header. Order number (click it to copy the number, for Seller Central or an email to Amazon support), then the date, marketplace, FBA (Amazon ships it) or FBM (you ship it), and the ship-to city, province and country. A status pill shows settled, partial refund, refunded or another status. Invoice number opens the invoice. An amber warning appears when the order has no ship-to province, because its invoice then has no provincial rate to apply.
The money. When the order has an invoice, the page shows the same MARKETPLACE SETTLEMENT panel as the invoice: product charges, the tax you file and the tax Amazon withheld, each fee, and the change to your seller balance. Before an invoice exists it shows Amazon's buckets instead: Principal, Tax collected, Amazon fees (deducted before deposit), Refunded (money went back), and, when not zero, Shipping, Gift wrap, Promotions and Tax Amazon remits.
Items table. What was in the box: SKU, Qty, Principal, Tax, Fees and Refunded per SKU. A broken-link icon beside a SKU means it is not mapped to a SeroBooks item, so the sale carries no cost of goods. Map it on Products.
Settlement lines table. Amazon's lines for the order, unmerged: Posted, Settlement, Type, What Amazon called it (in plain words; hover for Amazon's own code), Qty and Amount. Double-click a line (or select it and press Enter) to open the settlement it was paid in.
What an Amazon invoice looks like
When your company is set up to create invoices for Amazon orders:
- The customer is Amazon for the ship-to province (Amazon ON, Amazon BC, Amazon QC and so on), or Amazon US, Amazon Intl or Amazon Marketplace when there is no Canadian province. Amazon does not share the shopper, and one customer per order would swamp your customer list.
- The tax on each line is the amount Amazon charged, never a recalculated percentage, so the invoice always agrees with the settlement. The tax code comes from your own tax set-up for that province, so your return can show GST, HST, PST or QST separately. If Amazon's tax and your rate disagree by more than a rounding amount, the invoice is still written with Amazon's figure and an issue is raised.
- A refund becomes a credit memo, dated on the refund.
- Invoices are dated on the settlement date or the purchase date, and written at settlement or on the order day, as chosen under Amazon ▸ Settings.
- A settlement in a foreign currency does not create invoices; its revenue is booked through the settlement journal.
Depending on your company's set-up, Amazon invoices are either records you can open and print while the settlement journal carries the money, or they carry the revenue and tax themselves and the settlement clears them. Either way revenue is counted once.
Common problems
The Province column shows an amber dash. Amazon has not supplied the address yet. SeroBooks checks every ten minutes and can often work the province out from the tax charged. While it is missing, the invoice cannot be given a provincial rate; a settlement containing such orders may show waiting.
An order has no invoice. It has not settled yet, it is before your posting cutover, your company does not create invoices for Amazon orders, or it is a foreign-currency settlement.
I can't find an order a return refers to. Its sale settled before the settlements imported so far. See Returns.
Search finds nothing. Only loaded orders are searched. Choose Load 200 more or narrow the period.