Amazon Shipment Reconciliation Checklist: A Weekly Routine for Sellers

Fifteen minutes a week keeps every Amazon shipment accounted for. Here is the checklist.

Use this checklist every week to reconcile your shipments on Amazon.

Monday: download

  • โ˜ All Orders report โ€” last 90 days
  • โ˜ Date Range payment report โ€” last 90 days
  • โ˜ Returns Reconciliation report โ€” last 90 days (do not save it in Excel)
  • โ˜ Replacements report
  • โ˜ Your received-returns list from the warehouse

Match

  • โ˜ Every shipped order has a payment line โ†’ otherwise it is an outstanding order
  • โ˜ Every refund has a return marked Returned to Seller / POD Completed or received by you
  • โ˜ Replacement pairs judged together
  • โ˜ SAFE-T credits and reimbursements removed from the claim list

Act

  • โ˜ File claims whose window is open now
  • โ˜ Paste SAFE-T IDs into your tracker
  • โ˜ Check last week's claims for credits
  • โ˜ Re-file claims rejected as "too early" once the window opens

Review

  • โ˜ Amounts deferred for more than 21 days
  • โ˜ Loss-making SKUs this month

Too much for a spreadsheet? Upload the same reports once a week and the shipment reconciliation is done for you โ€” details in the Amazon reconciliation complete guide.