Weekly reconciliation guide
Weekly Removal Order Reconciliation SOP (UK): The 30-Minute Checklist
Thirty minutes a week is all it takes to catch every missing shipment, flag every at-risk claim, and file before Amazon’s deadline window closes. Here is the exact SOP that stops money slipping through the cracks.
Why weekly beats monthly (deadline safety)
The maths on removal order claim windows is unforgiving. Amazon gives you 74 days from shipment creation to file a lost-in-transit claim. That sounds generous until you account for the 15-day minimum waiting period, the time it takes to gather evidence, and the reality that Amazon agents regularly reject first attempts.
If you reconcile monthly, a shipment dispatched on the 1st of the month will not land on your desk until the 30th. That is 30 days consumed before you even know there is a problem. Subtract the 15-day waiting period and you have already used 45 of your 74 days doing nothing. That leaves 29 days to notice the discrepancy, photograph evidence, draft the claim, file it, wait for Amazon’s response, handle a denial, and escalate if necessary. Most sellers cannot do all of that in 29 days, especially when they are juggling dozens of shipments.
Weekly reconciliation changes the equation entirely. The longest any shipment can sit unreviewed is 7 days. A shipment dispatched on Monday is flagged by the following Monday at the latest. That gives you 67 days of runway instead of 44. More importantly, you catch issues while tracking data is still fresh, carrier records are still accessible, and Amazon’s systems still have the relevant case metadata readily available.
There is a compounding effect too. Monthly reconciliation means you face a backlog of 30 days’ worth of shipments in a single session. The task feels overwhelming, corners get cut, and marginal claims get skipped. Weekly reconciliation keeps the volume manageable. Five to fifteen shipments per session is far easier to process thoroughly than fifty to a hundred.
Monthly reconciliation
- 30 days before you spot a problem
- Only 44 days left to file and follow up
- 50–100 shipments to review at once
- Marginal claims get skipped under time pressure
Weekly reconciliation
- 7 days maximum before you spot a problem
- 67 days of runway to file and follow up
- 5–15 shipments to review per session
- Every claim gets proper attention
What you do every week (the checklist)
Six steps, thirty minutes. Run this every Monday morning before anything else. Consistency is what separates sellers who recover money from those who leave it behind.
Export your Seller Central reports
3 min- Download Removal Order Detail report (last 14 days)
- Download Reimbursements report (last 14 days)
- Pull your goods-in log or 3PL intake records for the same period
Reconcile receipts against shipped quantities
10 min- For each completed shipment, compare shipped vs received quantity
- Flag any shipment where received is less than shipped
- Note any shipments you have not received at all
- Mark shipments that arrived with damaged items
Check tracking and proof of delivery
5 min- Verify carrier tracking for shipments dispatched 7+ days ago
- Flag shipments with no tracking movement for 15+ days
- Check proof of delivery for all delivered shipments
- Note any shipments with missing or unsatisfactory POD
Build your at-risk list
5 min- List every shipment with a discrepancy (use the structure below)
- Calculate the deadline date for each issue
- Prioritise by nearest deadline first
- Cross-reference Reimbursements report to exclude already-reimbursed items
File claims for anything approaching deadline
5 min- Open a Seller Central case for each at-risk item
- Use the appropriate claim template (lost, missing, damaged, grading)
- Attach evidence: tracking screenshots, goods-in records, photos
- Record the case reference number in your tracker
Follow up on open cases
2 min- Chase any open case older than 7 days with no response
- Send a follow-up chaser at day 14 and day 21
- Escalate stalled claims to a supervisor or the FBA Reimbursement Team
- Update outcomes: Won, Lost, Ongoing
Quick-reference checklist (copy/paste)
[ ] Export Removal Order Detail + Reimbursements (last 14 days)
[ ] Reconcile received quantities against shipped quantities
[ ] Check tracking on all shipments dispatched 7+ days ago
[ ] Build at-risk list (order ID, shipment ID, deadline, status)
[ ] File claims for any items within 14 days of deadline
[ ] Chase open cases older than 7 days
What to export (reports and time window)
You need three data sources every week. Two come from Seller Central and one comes from your own warehouse or 3PL. Here is what to pull and why the 14-day window matters.
Removal Order Detail
Last 14 days
Every removal order, shipment, and item Amazon processed. Shows order status, shipped quantities, tracking numbers, and completion status. This is your master reconciliation document.
Reimbursements Report
Last 14 days
Shows what Amazon has already reimbursed. Cross-reference case IDs against your open claims to avoid filing duplicates and to verify payment amounts.
Goods-In Records
Last 14 days
Your own intake log or 3PL receipt records. The only source of truth for what actually arrived at your door. Without this, reconciliation is impossible.
The 14-day window is deliberate. A 7-day report would miss shipments dispatched on the boundary day of your previous session. Fourteen days gives you a full overlap with last week’s export, which means nothing falls through a gap between sessions. Any shipment that appeared in last week’s report and still has an issue will appear again this week, keeping it on your radar until it is resolved.
For your first session, pull a wider window. Ninety days of Removal Order Detail data will surface any older shipments that may already be approaching their claim deadline. After the initial catch-up, the 14-day rolling window is all you need. See the Removal Order Detail report guide for a detailed walkthrough of every column in the export.
On the Reimbursements report, filter to the same 14-day period. You are looking for case IDs that match your open claims. If Amazon has already reimbursed a shipment, you do not need to file again. Skipping this cross-reference is the most common cause of duplicate filings, which wastes time and can flag your account for excessive case volume.
How to create an at-risk list (by claim type)
The at-risk list is the output of your weekly reconciliation. It tells you exactly which shipments need action, what kind of claim to file, and how much time you have left.
Every discrepancy you find during reconciliation goes onto the at-risk list. This is not a spreadsheet you file and forget. It is a living document that carries forward from week to week until every item is either resolved, claimed, or confirmed as a non-issue. The structure below captures everything you need to make a filing decision.
At-risk list fields
Removal Order ID
Shipment ID
Tracking Number
Issue Type
Shipped Date
Deadline Date
Days Remaining
COG at Risk
Status
Sort the list by days remaining, with the most urgent at the top. Anything under 14 days needs immediate attention. Anything under 7 days is an emergency. If you are unsure how many days you have left, use the claim deadline calculator to check instantly. When you see items approaching deadline, check the claim type to determine which template and evidence pack to use.
Missing Units (Shortfall)
74 days from shipment creation
File as soon as confirmed
Split shipment template →What to do when you find an issue
Finding the discrepancy is only half the job. Filing correctly the first time is what determines whether you get paid. Here is the sequence for turning a flagged item into a successful claim.
The first question is whether the minimum waiting period has passed. For lost-in-transit claims, Amazon requires 15 days from the last confirmed tracking movement. Filing before this point will result in an automatic rejection with a “too early” response. If you are still inside the waiting period, add the item to your at-risk list with the status “Awaiting 15-day window” and revisit it next week.
Once the waiting period has passed, gather your evidence. The strength of your evidence pack is the single biggest factor in claim success. A weak filing gets denied. A strong filing with tracking data, goods-in records, and photographs gets approved. See the evidence pack guide for the full list of what to include for each claim type.
Choose the right template for your claim type. Each scenario requires different information and a different tone. A lost-in-transit claim needs tracking evidence and date calculations. A missing units claim needs goods-in records and quantity comparisons. A damaged claim needs photographs and condition descriptions. Using a generic message for all claim types is the fastest way to get denied.
Missing units from a delivered shipment
For when the box arrived but the count is wrong.
Split shipment with missing cartons
For when one box of a multi-box shipment never arrived.
Follow-up chaser for stalled cases
Day 7, 14, and 21 chaser cadence for unresolved claims.
After filing, record the case reference number on your at-risk list and set the status to “Filed.” If you do not hear back within 7 days, send a follow-up chaser referencing the original case ID. At 14 days, escalate by requesting a supervisor review. The follow-up chaser template gives you the exact wording for each stage of the escalation ladder.
The most important habit is closing the loop. Every item on your at-risk list should end with a final status: Won (reimbursed), Lost (denied after escalation), or Resolved (item was found or issue was a false positive). If you leave items in an ambiguous state, your at-risk list grows unmanageable within weeks.
Automate your weekly reconciliation
ReclaimHQ imports your removal orders with one click, tracks every shipment, calculates claim deadlines in real time, and flags at-risk items before they expire. The weekly SOP becomes a 15-minute review instead of a 40-minute manual process.
Start free trialFrequently asked questions
How long does weekly removal order reconciliation take?+
Why is weekly reconciliation better than monthly?+
Which reports do I need for the weekly checklist?+
What should I do if I find an issue during reconciliation?+
Can I automate the weekly reconciliation process?+
Related guides
Pillar guide
Amazon FBA Removal Orders (UK) →
How removal orders work, the order/shipment/item structure, and reconciliation fundamentals.
Deadline reference
FBA Reimbursement Deadlines (2026) →
UK claim windows, the 15-day minimum wait, and timing rules by claim type.
Evidence guide
Building an Evidence Pack →
What to include for each claim type: tracking, photos, goods-in records, and more.
Reference
Removal Order Statuses Explained →
What each Amazon order status means and when to take action.
Stop leaving money on the table
14-day free trial. Import your first order in under 2 minutes.
Start free trial10× money-back guarantee · From £24.99/month