FBA Inventory report columns, explained
The surcharge math lives in a report you already have. The useful one is the FBA Inventory report (sometimes listed as Inventory Age). It is a tab-separated .txt file. The Manage Inventory export is a different file and does not have the age bands this guide describes.
How to download it
- In Seller Central go to Inventory → Inventory Planning → FBA Inventory and use Download.
- Some accounts also find it under Reports → Fulfillment as FBA Inventory or Inventory Age.
- You should get a .txt file. Open it in a spreadsheet if you want to look around, but you can also drop the original file into the SurchargeShield tool. CSV exports and renamed headers (for example “Inv Age 181 To 270 Days”) usually work too.
Age-band columns: inv-age-*
These columns count how many of that SKU's units currently fall in each age range, for example:
inv-age-0-to-90-daysinv-age-91-to-180-daysinv-age-181-to-270-daysinv-age-271-to-365-daysinv-age-365-plus-days(naming varies; some reports use365+or366-plus)
Some reports use finer bands (0–30, 31–60, 181–210, 181–330, and so on). The important limitation is the same: you see a band, not each unit's exact age. A unit in inv-age-181-to-270-days might be 181 days old or 270. Any projection to the next 15th has to assume how units are spread inside the band. SurchargeShield assumes an even spread, then ages every slice forward and takes expected sales off the oldest units first.
What Amazon expects to bill: quantity-to-be-charged-ais-* and estimated-ais-*
These columns, when present, are Amazon's own view of the current snapshot — not a projection to the next 15th.
quantity-to-be-charged-ais-181-210-days(and the matching bands) — units Amazon expects to charge in that tier.estimated-ais-181-210-days(and the matching bands) — Amazon's dollar estimate for that tier.
If your file includes them, they are the figure to compare against. The free SurchargeShield summary shows Amazon's current-snapshot estimate next to our projection to the next 15th, because those two numbers answer different questions. Ours includes units that will cross 181 (or 271) days between today and the snapshot, minus units likely to sell in that window.
Sell-through: units-shipped-t30 and units-shipped-t90
These are units shipped over the last 30 and 90 days. They are the simplest way to estimate a daily sales pace:
- daily pace from the last 30 days ≈
units-shipped-t30÷ 30 - daily pace from the last 90 days ≈
units-shipped-t90÷ 90
SurchargeShield averages the two when both exist. That pace is then applied first-in, first-out: projected sales between now and the 15th come off the oldest units. A SKU selling 2 units a day can clear 60 aged units in a 30-day window; a SKU selling 2 a month cannot.
This is an estimate. Recent promotions, stockouts, and seasonality all make the last 30 or 90 days a poor guide. If your 30-day pace is far below your 90-day pace, treat the forecast with more caution.
Other columns worth knowing
| Column (typical name) | Why it matters |
|---|---|
sku / fnsku / asin | Identifies the row. The tool keys off SKU. |
product-name | Shown on the draft action list and in the PDF/CSV. |
product-group | Used only to detect likely exemption from the 181–270 day bands (clothing, shoes, bags, jewelry, watches). If the group is missing or unusual, check that SKU yourself. |
item-volume and volume-unit-measurement | Most surcharge bands are priced per cubic foot. The tool converts cm³, m³, and in³ when the unit column is present. If volume is missing, any dollar figure depends on the default you type in. |
inventory-age-snapshot-date | The date the age bands were measured. The tool uses this as “today” for aging forward. If it is missing, it assumes the ages are as of today. |
units-shipped-t7 / t60 | Sometimes present; the projection uses t30 and t90 when available. |
recommended-action | Amazon's own flag, if present. It is shown for reference; the draft plan is computed separately. |
available / fulfillable quantity | Useful context, but the age-band quantities are what get aged and priced. |
What this file will not tell you
- The exact age of each unit, only the band it sits in.
- Future sales with certainty — only recent shipped units.
- Removal, disposal, or Liquidations fees. Those are separate rate cards. See remove vs. liquidate.
Sources and limits. Column names above are taken from FBA Inventory / Inventory Age exports sellers receive, and from the way those headers appear in Amazon Seller Forums discussions of the surcharge (for example the fee-summary thread 85f60e98). Header wording varies by account and by whether you open the file in Excel. SurchargeShield normalizes punctuation, case, and spacing, and accepts common aliases, but a custom export can still fail. If it does, the tool will say it could not find a SKU or age-band column.
SurchargeShield is an independent tool from Obra Ventures LLC. It is not affiliated with or endorsed by Amazon.