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.