Spreadsheet grid with highlighted cells and formula bar transitioning into a modern dashboard on a dark navy background
Strategy

Inventory Spreadsheet Templates (+ When to Quit)

ReplenishRadar Team
June 2, 2026Updated Oct 30, 20267 min read
Refreshed Oct 2026
ShareXLinkedIn
inventorystrategyworkflowcomparison

Key takeaway: Spreadsheets work for inventory management up to about 50 SKUs and one sales channel. Above 200 SKUs, they cause stockouts from stale data and broken formulas. If maintaining them eats real hours out of your week, every week, it's time to upgrade.

Picture running an entire business on a Google Sheet for two years. Not a bad spreadsheet, either: VLOOKUP formulas, conditional formatting for low stock alerts, a reorder calculator tab worth being proud of. It works. Until it does not.

Below, we cover three spreadsheet templates that actually work, the formulas behind them, and exactly where each one breaks down. Spreadsheets are a perfectly good tool for early-stage inventory management. The mistake is not starting with them. The mistake is staying with them too long.

What a Good Inventory Spreadsheet Needs

Bad inventory spreadsheets are just lists of products and quantities. Good ones calculate things for you. Here are the columns that matter:

Column What it does Formula or manual?
SKU Unique identifier Manual
Product name Human-readable Manual
Current stock Units on hand right now Manual (this is the problem)
Unit cost What you pay per unit Manual
Daily sales rate Average units sold per day Formula: last 30 days sales / 30
Days of supply How long until stockout Formula: current stock / daily rate
Lead time Days from PO to delivery Manual
Reorder point When to order Formula: daily rate x lead time
Safety stock Buffer for variability Formula (see below)
Status Order now / soon / OK Formula: IF logic

The daily sales rate is where most spreadsheets fall apart first. Someone has to update "last 30 days sales" regularly. If that number is stale, every downstream formula is wrong. Days of supply, reorder point, status alerts. All garbage.

Template 1: Simple Stock Tracker

This is the starter. Good for under 30 SKUs and one sales channel.

In column J, your reorder alert formula:

=IF(D2 <= H2, "ORDER NOW", IF(D2 <= H2 * 1.25, "ORDER SOON", "OK"))

Where D2 is current stock and H2 is your reorder point. The 1.25 multiplier gives you a warning zone before you actually hit the trigger.

For days of supply in column G:

=IF(F2 > 0, D2 / F2, "NO SALES")

This handles the division-by-zero case for products with no recent sales. Those are worth flagging for a different reason: they might be dead stock.

At 15 SKUs, this template is easy to keep current: update it every Monday morning with the weekend's sales, about 20 minutes, and it holds up fine for the rest of the week.

Template 2: Reorder Point Calculator

This one adds the math. Instead of manually setting reorder points, you calculate them from demand and lead time.

The reorder point formula in a spreadsheet:

=F2 * H2 + I2

Where F2 is average daily demand, H2 is lead time in days, and I2 is safety stock.

For safety stock, the proper formula is:

=1.65 * STDEV(range_of_daily_sales) * SQRT(H2)

The 1.65 is the Z-score for a 95% service level. If you want 99%, use 2.33. If 90% is fine for this SKU, use 1.28. Here is the lookup:

Service level Z-score What it means
90% 1.28 Stock out ~1 month per year
95% 1.65 Stock out ~2.6 weeks per year
97.5% 1.96 Stock out ~1.3 weeks per year
99% 2.33 Stock out ~3.6 days per year

A worked example: your product sells an average of 8 units/day with a standard deviation of 3, and your supplier delivers in 14 days. Reorder point = (8 x 14) + (1.65 x 3 x SQRT(14)) = 112 + 18.5 = 131 units. When your stock hits 131, place the order.

This template is solid. The problem is the STDEV formula. You need a column (or a separate sheet) tracking daily sales for each SKU over at least 30 days. At 50 SKUs, that is 1,500 data points per month. The spreadsheet gets heavy.

Template 3: ABC Analysis

ABC classification tells you where to focus. You do not need the same rigor on every SKU. This template sorts your catalog by revenue contribution.

The key formula: cumulative revenue percentage. Sort your SKUs by revenue (descending), then in the cumulative % column:

=SUM($G$2:G2) / SUM($G$2:$G$100)

Where column G is revenue per SKU. Then classify:

=IF(K2 <= 0.8, "A", IF(K2 <= 0.95, "B", "C"))

Top 80% of cumulative revenue = A items. Next 15% = B. Last 5% = C.

Running this often reveals a familiar pattern: 15-20% of your SKUs generate 80% of your revenue. If the top 20% and the bottom 50% have been getting equal attention, that bottom 50% deserves less safety stock, less frequent reorder checks, and honestly, some of it deserves to be cut.

Where Spreadsheets Break

Spreadsheets are not bad tools. They are good tools with hard limits. Here are the five walls you will likely hit, roughly in order:

Wall 1: Stale data. Someone has to update stock counts manually. At 30 SKUs, that is 20 minutes. At 200 SKUs across Shopify and Amazon, you are spending 2+ hours per week on data entry that is already outdated by the time you finish.

Wall 2: Multi-channel math. You sell on Shopify and Amazon. Your spreadsheet has one "current stock" column. But stock at FBA is not the same as stock in your warehouse. Now you need two columns, and your reorder logic needs to know which channel to replenish. The formulas triple in complexity.

Wall 3: No history. Spreadsheets show you right now. They do not track how your lead times have drifted, how your demand patterns have shifted, or whether your supplier's reliability has changed. You need that history for good safety stock calculations. Without it, you are guessing.

Wall 4: Collaboration breaks. Two people update the spreadsheet. One overwrites the other's changes. Google Sheets handles simultaneous editing better than Excel, but it does not handle conflicting inventory updates. Someone marks 50 units received while someone else is entering a sales adjustment. The numbers stop reconciling.

Wall 5: You stop trusting it. This is the real death of the spreadsheet. After the third time a formula was wrong because someone edited a cell they should not have touched, you start double-checking everything. The spreadsheet becomes a suggestion that you verify against Seller Central and Shopify Admin. At that point, you have two inventory systems and trust neither.

Wall 3 tends to show up first, then walls 1 and 5 together. The move from spreadsheets to software can come as early as 60 SKUs and two sales channels, not because the spreadsheet cannot technically hold the data, but because maintaining it starts costing more time than using it.

What Changes When You Switch

This is not a neutral post. We built ReplenishRadar, so there is an obvious bias here. The comparison below maps to the five walls above.

Every week a spreadsheet needs the same chores: stock counts, sales data, reorder calculations, PO tracking, lead time updates. We built ReplenishRadar to sync with Shopify and Amazon directly, so the stock counts update automatically. The reorder points recalculate when demand or lead times change. What is left is reviewing what the system flagged, not typing numbers into cells.

The bigger change is accuracy. A spreadsheet reorder point is only as good as whoever last updated the demand number, and that update tends to lag. Automated syncing closes that gap because the numbers are always current, not last-Monday current.

If you are under 50 SKUs on a single channel, keep the spreadsheet. Seriously. The templates above work. But if you have hit two or more of those five walls, the spreadsheet is costing more than it is saving. See how ReplenishRadar works, free inventory report included.

Related Reading:

Frequently Asked Questions

Get notified when it matters

Amazon and Shopify change the rules constantly. We'll email you when something affects your business.

Notification preferences

No spam. Unsubscribe anytime.

See what your inventory is really doing

Connect your store and see what is about to run out. No credit card is required to start the 14-day trial. Cancel any time.
Start Your 14-Day Free Trial
No credit card required14-day free trialCancel anytime

Doing $5M+ in revenue? Talk to our team