A seller using Fulfillment by Amazon has stock in three places at once: on hand at home or in a warehouse, inbound on its way to Amazon, and sellable at Amazon. An FBA inventory spreadsheet puts those three in a row for each SKU, beside what the SKU sells a day. From that it works out days of cover at Amazon, compares it with how long a restock takes, and says whether to send more and how many. Running out at Amazon costs sales while stock sits at home. Sending too much ties up units you may need elsewhere and pays for storage. The sheet is for seeing both a few weeks ahead. Below is an example with five products, the two sums, and the file.
The short version
- Three stock figures for each SKU: here, inbound, at Amazon.
- Days of cover = sellable units ÷ units sold a day.
- Send more when cover, counting what's inbound, is under your restock time plus a safety margin.
- Units to send = (restock time + target days) × daily sales − what's there and inbound.
- You can't send what you haven't made. Check the on-hand column before you promise yourself a shipment.
- TaroStack doesn't connect to Amazon. It keeps your own stock, lots and production right. More below.
An example
A made-up food brand, counted on a Friday. Restocking takes 12 days from packing a box to units being sellable.
| SKU | Here | Inbound | At Amazon | Sold a day | Days of cover | Send more? | Units to send |
|---|---|---|---|---|---|---|---|
| Maple Pecan Granola | 96 | 0 | 58 | 3.2 | 18 | SEND | 124 |
| Honey Nut Granola | 60 | 72 | 14 | 2.4 | 6 | OK | |
| Sencha, 2 oz tin | 34 | 0 | 122 | 1.1 | 111 | OK | |
| BBQ Rub, 5 oz | 260 | 0 | 31 | 4.5 | 7 | SEND | 226 |
| Strawberry Jam, 8 oz | 12 | 0 | 9 | 0.9 | 10 | SEND | 42 |
The two sums
When to send. This seller's rule: send when cover, counting inbound, is under the 12-day restock time plus 14 safety days, 26 in all.
| SKU | Sellable + inbound | ÷ sold a day | Cover | Under 26? |
|---|---|---|---|---|
| Maple Pecan Granola | 58 | 3.2 | 18 days | Yes: send |
| Honey Nut Granola | 86 | 2.4 | 36 days | No: a shipment is already on its way |
Honey Nut shows six days at Amazon and still says OK, because 72 units are in transit. Without the inbound column you'd send a second shipment in a panic.
How many. Enough to cover the restock time and reach the target cover, here 45 days, after it lands:
(12 + 45) × 3.2 = 182 units needed, less the 58 already there = 124 to send.
Then look left
The sheet says send 124 Maple Pecan. The on-hand column says 96. So the real plan is: send 96 now, and make a batch.
| SKU | Units to send | On hand here | What to do |
|---|---|---|---|
| Maple Pecan Granola | 124 | 96 | Send 96; make a batch this week |
| BBQ Rub | 226 | 260 | Send 226 |
| Strawberry Jam | 42 | 12 | Make a batch before anything ships |
The jam is the warning. Ten days of cover at Amazon, twelve units at home, and a batch takes a day to make and the shipment twelve to land. It will run out. The sheet's job is to show that on a Friday three weeks earlier.
And the tea, at 111 days of cover, is the opposite problem: about 60 tins more than the target, sitting at Amazon when they could have been on your own site.
Dates and lots
For anything with a best-by, the last column matters: the best-by of the oldest lot you have at Amazon. Marketplaces set their own rules for dated products, including how much shelf life has to remain, so read the current rules in your seller account and keep them in mind when you choose which lot to send. Send the lot with the longest date to the place it will sit longest.
Write down which lot went in which shipment. If a lot ever has a problem, "units from MP-1106 are at Amazon" is something you'll need to know the same day. A sheet for dated stock in general is in inventory list with expiration dates.
This spreadsheet doesn't connect to Amazon and doesn't know its fees, limits or rules, which change. Take the three stock figures and the daily sales from your own account's reports each week. The thinking behind safety stock is in how much inventory to keep on hand, and whether a product can afford marketplace fees at all in food pricing calculator.
Get the spreadsheet
Download the Amazon FBA inventory spreadsheet. Two sheets and a read-me: the stock sheet, where total, days of cover, the send flag and units to send work themselves out, and a Limits sheet for your safety days and target cover. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
"On hand here" is a number you type. For a brand that also sells at markets, to shops and on its own site, that number moves every day, and the 96 bags of granola the sheet is counting on may already be promised to a co-op. The FBA sheet is only as good as the count behind its first column, and that count is the hard part.
How TaroStack does it
TaroStack doesn't connect to Amazon. What it does is keep the first column, and everything behind it, true.
One count of what you hold. Stock by item, lot and place, updated as you make, ship and count.
A shipment to Amazon is an order. Record it and the units come off your stock from the lots you chose, so you know which lots are there.
"What could I make right now" says whether the batch the sheet is asking for can be made from the ingredients on hand.
Dates on every lot. The soonest to expire is picked first by default, and you can choose a longer-dated lot for a shipment that will sit.
The recall report lists every customer a lot went to, the Amazon shipment among them.
| The job | FBA sheet alone | With TaroStack |
|---|---|---|
| On hand here | Typed, weekly | Current |
| Which lots are at Amazon | A note | The shipment's order, by lot |
| Can I make the batch it wants? | Check the pantry | What could I make right now |
| A lot has a problem | Which shipment was that? | The recall report |
Units at Amazon and daily sales still come from your Amazon reports, typed into the sheet. Stock, lots and recipes are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
