Workflow · Stock and products · Opening soon

Amazon FBA inventory reconciliation

Compare what you shipped to Amazon with what it received and still holds. Flag shortage and damaged units so you can see what to claim.

Book a demo

Someone typed

“show every amazon fba inbound shipment from the inbound shipments file, compare shipped to received plus damaged, and show claimable units; status Agrees when they match, otherwise Shortage or Damaged”

The agent read it as

show every amazon fba inbound shipment from my FBA shipment contents file, compare shipped to received plus damaged from my FBA inventory adjustments, and show claimable units; status Agrees when they match, otherwise Shortage or Damaged

What the agent built

5 steps, each one an ordinary Mammoth step you can open and change.

File

FBA shipment contents

CSV export · 16 rows

File

FBA inventory adjustments

CSV export · 12 rows

Step

Normalize keys

Step 1

Step

Sum damaged units

Step 2

Step

Normalize keys

Step 3

Join

Bring damaged units

16 of 16 paired

Step

Calculate claim status

Step 5

Result

Inbound shipment claims

16 rows · 12 flagged

Schedule

Runs when you say

Proposed

File
FBA shipment contents
CSV export · 16 rows
File
FBA inventory adjustments
CSV export · 12 rows
Step
Normalize keys
Step 3
Step
Normalize keys
Step 1
Step
Sum damaged units
Step 2
Join
Bring damaged units
16 of 16 paired
Step
Calculate claim status
Step 5
Result
Inbound shipment claims
16 rows · 12 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 16 rows came out, and the join paired 16 of 16 rows.

Download FBA shipment contents sample (16 rows)Seller Central: Inventory > Shipments > Download shipment contents
Download FBA inventory adjustments sample (12 rows)Seller Central: Reports > Fulfillment > Inventory > FBA Inventory adjustments report

What you get back

The result of that run, the rows to look at first.

Inbound shipment claimsSample data16 rows

4 agrees10 damaged2 shortage

Shipment id	Shipment SKU	Shipment FNSKU	Quantity shipped	Quantity received	Damaged units	Claimable units	Status
FBA15A2K9X1	MAPL-TEA-12	X001A1TEA1	120	120	2	2	Damaged
FBA18B7Q4R2	PINE-CAB-06	X001A1CAB4	150	150	2	2	Damaged
FBA18B7Q4R2	ORCHID-SOAP-03	X001A1SOP5	90	88	1	1	Shortage
FBA18B7Q4R2	BRIX-LAMP-02	X001A1LMP6	40	40	1	1	Damaged
FBA21C3N8M5	EMBER-SOCK-05	X001A1SCK8	70	70	1	1	Damaged
FBA24D6P1H7	MAPL-TEA-12	X001A1TEA1	140	140	2	2	Damaged
FBA24D6P1H7	NOVA-MUG-01	X001A1MUG2	60	60	1	1	Damaged
FBA24D6P1H7	LUNA-BLANK-04	X001A1BLK3	100	99	0	1	Shortage
FBA27E9L4S3	ORCHID-SOAP-03	X001A1SOP5	75	75	1	1	Damaged
FBA27E9L4S3	BRIX-LAMP-02	X001A1LMP6	35	35	1	1	Damaged
FBA27E9L4S3	COVE-BOTT-01	X001A1BOT7	90	90	1	1	Damaged
FBA27E9L4S3	EMBER-SOCK-05	X001A1SCK8	50	50	1	1	Damaged

16 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you reconcile FBA inventory?

Export your FBA shipment contents and FBA inventory adjustments from Amazon Seller Central, then load both files. The workflow matches shipment rows, sums damaged units, and compares shipped units to received plus damaged units. Rows that do not match are marked Shortage or Damaged, and matching rows are marked Agrees.

How it works

How to use the Inbound shipment claims workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Inbound shipment claims: questions

Which export should you use?

Use the FBA shipment contents export for what you shipped, and the FBA inventory adjustments export for damaged units. If your export names differ, use the file that lists shipment lines and the file that lists inventory adjustments.

What happens to rows that do not match?

Rows that do not match are kept in the result. They are marked Shortage when received plus damaged is less than shipped, or Damaged when damaged units explain the difference.

How do you change the rules?

Edit the matching and calculation steps in words. You can change which columns are used as keys, which adjustment rows count as damaged, and how the status is decided.