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.

01

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
02

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
03

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
04

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
05

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
06

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

ABC123XYZIdentifies the original removal request

Shipment ID

FBA12345678Identifies the specific box or parcel

Tracking Number

JD012345678901234Carrier reference for delivery verification

Issue Type

Lost in TransitDetermines claim template and deadline

Shipped Date

2026-01-15Starting point for deadline calculation

Deadline Date

2026-03-30Last day to file (shipped date + claim window)

Days Remaining

12Urgency indicator for prioritisation

COG at Risk

£145.50Financial value of the items at stake

Status

Awaiting 15-day windowCurrent action state

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.

Lost in Transit

74 days from shipment creation

15-day minimum wait

Missing units template

Missing Units (Shortfall)

74 days from shipment creation

File as soon as confirmed

Split shipment template

Damaged in Transit

60 days from delivery

File as soon as received

Filing claims guide

Grading Dispute

60 days from delivery

File as soon as inspected

Deadline rules

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.

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 trial

Frequently asked questions

How long does weekly removal order reconciliation take?+
For most UK Amazon sellers, a weekly reconciliation takes 25 to 40 minutes depending on order volume. Sellers processing fewer than 20 removal orders per week typically finish in under 30 minutes. Using a tool like ReclaimHQ reduces this to around 15 minutes because import, tracking, and deadline calculation are automated.
Why is weekly reconciliation better than monthly?+
Amazon gives you 74 days from shipment creation to file a lost-in-transit claim. Monthly reconciliation consumes 30 of those days before you even notice a problem, leaving you with only 44 days to gather evidence, file, and handle denials. Weekly reconciliation catches issues within 7 days, giving you 67 days of runway.
Which reports do I need for the weekly checklist?+
Three sources: the Removal Order Detail report from Seller Central (your master reconciliation document), the Reimbursements report (to avoid duplicate filings), and your own goods-in records or 3PL intake log (the only source of truth for what actually arrived).
What should I do if I find an issue during reconciliation?+
Categorise the issue by claim type (lost in transit, missing units, damaged, grading dispute), check whether the minimum waiting period has passed, gather your evidence, use the appropriate claim template, and file a case in Seller Central. Record the case reference and follow up weekly until resolved.
Can I automate the weekly reconciliation process?+
Yes. ReclaimHQ imports your removal orders with one click via a Chrome extension, automatically tracks every shipment and item, calculates claim deadlines in real time, and flags at-risk items before they expire. The weekly checklist becomes a 15-minute review instead of a 40-minute manual process.

Stop leaving money on the table

14-day free trial. Import your first order in under 2 minutes.

Start free trial

10× money-back guarantee · From £24.99/month