Why Most FBA Sellers Are Still Doing This Wrong
Most sellers I see trying to track FBA shipments end up with a mess of spreadsheets that break every time Amazon updates their report format. I spent about eighteen months wrestling with this before I stopped fighting it and built something that actually works. The core problem isn't complexity. It's that Amazon's reports keep shifting and nobody documents what to do when they do. Here's what I ended up settling on, and I've been running it across three different FBA accounts now without losing my mind: Set up a Google Sheet with these columns: Shipment ID, SKU, Quantity Sent, Quantity Received, Warehouse Location, Expected Delivery Date, Actual Delivery Date, Discrepancies, Images Filed. That's it. Start simple. You don't need a database. You need a sheet that survives an Amazon report format change without requiring you to rebuild it.
The trick nobody talks about is linking your inbound placement reports directly to the sheet using the importrange function. Amazon drops inbound shipment reconciliation reports weekly. Pull them into your master log automatically. When I found this out it cut my weekly reconciliation time from roughly three hours down to maybe twenty minutes. That's not a small gap. I keep a separate tab for receiving discrepancies with a dropdown for the issue type: short shipment, damaged goods, wrong item, or missing labels. I also have a column that flags whether the issue was submitted to Amazon within the 48-hour window. This one column has saved me roughly four figures over the past year. Amazon only reimburses for discrepancies reported within that window, and most sellers I talk to aren't tracking the deadline.
Where This Actually Breaks Down
The system fails if you ignore it for more than two weeks. The data stays clean but your awareness goes stale and you start stacking undisputed shipments. I learned this the hard way when I took a two-week vacation and came back to six unreconciled inbound shipments with three short-ship cases outside the filing window. That cost me about $890 I could have recovered. The workaround is setting a calendar reminder for Friday afternoons that just says "logbook." Five minutes of filling gaps each week prevents the domino effect. Another limitation: this approach assumes you're shipping fewer than about 400 SKUs per month. Once you hit that volume the manual entry starts eating into real work time. At that point I'd recommend looking into API-based tools like Sellbrite or Helium 10's inventory module instead of keeping this manual. The DIY method is honest about where it ends.
Get the Full Details
Getting Started
I built my current version from scratch but if you want something closer to what I use I maintain a shareable template at this link. I update it whenever Amazon changes their report structure, usually within a few days. The file includes the importrange formulas pre-wired for your Seller Central data, along with a troubleshooting tab that documents every report format change I've encountered since January 2024. Before you spend any time customizing it, run through your last ten inbound shipments and see if your current method catches every short-shipment case. If you're missing more than one or two out of ten, the bottleneck isn't your spreadsheet formula. It's your workflow. Fix the check-in rhythm first. Then build the tool on top of that.
