DEV Community

SourceDock
SourceDock

Posted on Edited on Originally published at sourcedock.io

Amazon Inventory Reconciliation, Step by Step

Three counts should match for every product you send to Amazon. One is the units you shipped. One is the units Amazon says it got. The last is the units Amazon holds today, after sales and returns. Amazon inventory reconciliation is a long name for a plain habit. You check that the counts match. When they do not, you find out why.

What is Amazon inventory reconciliation?

Amazon inventory reconciliation means checking your product counts against Amazon's. Inventory is the products you have for sale. To reconcile is to make two sets of numbers agree. You start with what you bought and shipped. You follow each unit until it sells. Any gap is a mistake to fix or money Amazon owes you.

The name covers two jobs. People often mix them up.

The first job is checking one shipment. Did Amazon get what you sent?

The second job is checking your products over time. Can every unit that went into the warehouse still be found?

A full check does both.

Why do your counts and Amazon's drift apart?

Counts drift for a few plain reasons. Amazon counts a shipment short. A unit gets lost or broken in the warehouse. A buyer gets a refund and never sends the item back. An order from your supplier never shows up. And now and then the mistake is yours, like a wrong number typed on a purchase.

None of this is strange. It does not mean your account is in trouble. It is what happens when many units pass through many hands.

Small gaps are cheap to fix when they are new. They get costly when you leave them. The time you have to claim a loss does not last forever.

How do you reconcile an inbound FBA shipment?

An inbound shipment is a box of products on its way to Amazon. Check it once Amazon has finished counting it. Compare the units you shipped with the units Amazon got, product by product. If Amazon's count is lower, check your own packing notes first. Then report the gap to Amazon with proof of what you sent.

Here is a made-up shipment. You send 60 board games in three boxes. Two weeks later, Amazon shows 54.

First, make sure 60 went into the boxes. Three things can prove it.

  • The bill from your supplier
  • Your packing list
  • The shipping company's record of how much each box weighed

Give Amazon time to finish counting before you call it a shortage. More units can show up after the first ones. Once the count is done, move fast. Amazon only takes shipment claims for a set time. Seller Central is Amazon's website for sellers, and it shows the deadline for each shipment.

How do you reconcile inventory after it is checked in?

Once Amazon has your products, the math changes. Start with the units Amazon got. Take away the units sold. Add the units buyers sent back. Take away any units you had removed. That is the count Amazon should hold. Compare it with the count Amazon shows. A lower number means units were lost or broken.

Go back to the board games. Amazon got 54. Thirty have sold. Two came back in good shape. None were removed.

Amazon should hold 54 minus 30 plus 2. That is 26.

Say Amazon shows 24. Two units are missing. Next, check if Amazon already paid you for them. If it did, you are square. If it did not, those two units are a claim. A claim is a request for Amazon to pay you back.

Returns need their own check. A refund should be followed by a return. Sometimes the buyer gets the money and nothing comes back. Sometimes the item comes back broken and it was not your fault. In both cases, Amazon may owe you.

How often should you reconcile Amazon inventory?

Once a month is a good pace. Also check each shipment when Amazon finishes counting it. The exact day matters less than doing it every time. Amazon's deadlines start on the day of the loss. A gap you find this month can still be claimed. A gap you find a year later may be too old.

A monthly check helps your bookkeeping too. Your books list what your products are worth at the end of each month. That number should match the units you can count. Check the units every month and your accountant can trust it.

What does it take to do this in a spreadsheet?

A spreadsheet needs four sets of data side by side. You need your purchases, with units and costs. You need your shipments, with units sent and units Amazon got. You need Amazon's record of what happened to each unit. And you need what Amazon already paid you back. Then you line them up for each product.

It works. It also takes real time every month.

The hard part is joining the data. One product comes in several shipments. It sells over many months. Its returns and losses sit in different reports. Each report has its own dates and its own product codes. One bad formula can show a gap that is not real. It can also hide one that is.

That is where software helps. A reconciliation tool compares three counts for every product: what you sent to Amazon, what Amazon received, and what Amazon holds now. When they do not add up, it shows you the gap.

What gaps does reconciliation software find?

A good tool sorts what it finds into kinds like these.

  • Missing from shipment. You sent more than Amazon got.
  • Amazon can't find it. Units were checked in, then lost track of.
  • Return issue. A refund with no return, or a broken return.
  • Never arrived. Units from an order that has not come after 14 days.
  • Add costs. Products with no buy cost yet.

The last two are about your own purchases. They are easy to forget.

Say an order from a supplier never comes. That is money spent on nothing, unless you chase it.

A product with no cost has its own problem. It cannot show a real profit. It also cannot back up a claim that depends on what you paid.

Each gap comes with its fix. Some fixes are on your side, like a corrected count or a write-off. A write-off means you take a lost unit off your books. A gap Amazon owes you for turns into a claim. You file that claim yourself in Seller Central.

What do you do once you find a gap?

Decide which of three things it is. If your own record was wrong, fix it. If the unit is gone and nobody owes you for it, write it off. If Amazon lost or broke the unit and has not paid, send a claim with your proof. Then watch the claim until it is paid or turned down.

Good proof makes claims go faster. Keep three things for every shipment.

  • The supplier's bill
  • Proof the boxes were delivered
  • Your packing details

Store them by date so you can find them later.

Write-offs matter as much as claims. A unit that is gone should not stay in your count. Take it out, and you see what the buy truly cost.

Questions sellers ask

Is inventory reconciliation the same as filing reimbursement claims?

No. Reconciliation is the check that finds the gaps. A reimbursement is money Amazon pays you back for a loss. A claim is how you ask for it. Only some gaps end in a claim. Others end as a fixed count or a write-off. Check first, and every claim starts from a count you can prove.

Which Amazon reports do you need to reconcile by hand?

You need four. One shows the details of each shipment. One lists what came in, sold, came back or was lost for each product. One lists returns. One lists what Amazon has paid you back. Amazon renames its reports now and then. The current ones are in the reports part of Seller Central.

How long should you wait before reporting a short shipment?

Wait until Amazon has finished counting the shipment. The count can keep going up for a while. After that, do not wait. The shipment page in Seller Central shows when you can ask Amazon to check, and the last day you can ask.

Originally published on the SourceDock blog. This post was written with the help of AI tools.

Top comments (0)