Your Shopee PH tab shows 12 units. Your Lazada PH tab shows 12 units. A double order comes in at the same time. Neither tab updated. Now you are oversold, apologizing to a buyer, and manually editing two spreadsheets at midnight.
Excel inventory management works — until it doesn’t.
What Is an Inventory Management System in Excel?
An inventory management system in Excel is a spreadsheet-based method of tracking stock quantities, sales, purchases, and product data. For Philippine ecommerce sellers, it consists of linked sheets recording SKUs, current stock, incoming orders, and supplier data — updated manually after each transaction. It costs nothing beyond Microsoft Office or Google Sheets.
An inventory management system in Excel is a structured spreadsheet setup that records and tracks your product quantities through every stage of the sale cycle: stock received from suppliers, stock sold across channels, stock returned by customers, and stock currently on hand.
For small Philippine ecommerce operations — a single Shopee PH seller with under 100 SKUs and manageable daily order volumes — Excel handles the basics reliably. Microsoft Office and Google Sheets (familiar to most Philippine SME owners) provide formulas, conditional formatting, and pivot tables that replicate core inventory management functions at zero subscription cost.
A functional Excel inventory system uses three linked sheets: a Product Master for SKU data, a Stock Ledger recording every movement append-only, and a Dashboard calculating current stock using SUMIF formulas.
The structural limit is important to understand from the start: Excel is a calculation tool, not a connected platform. Every update requires manual input. There is no Shopee PH integration, no Lazada PH sync, no automatic deduction when an order arrives. This works when you are the only person managing inventory and every sale happens on one channel. Add a second channel and the update burden multiplies.
How Do You Set Up an Excel Inventory System for Ecommerce?
The recommended setup uses three linked sheets: a Product Master listing all SKUs and costs in PHP, a Stock Ledger recording every movement as a new row, and a Dashboard using SUMIF to calculate current stock. Philippine sellers should include a Supplier Lead Time column and a Low Stock Flag formula comparing current stock against each product’s reorder point.
The most common mistake in building an Excel inventory system is tracking stock by directly editing a single number in one column. That approach has no history, no audit trail, and no way to identify discrepancies between what the spreadsheet says and what is physically on your shelves.
The ledger model is more reliable: every stock change becomes a new row. Sales are negative. Purchases are positive. Your current stock is always a SUMIF formula summing the history — never a manually updated cell.
Here is the recommended column structure for each sheet:
Product Master Sheet:
| Column | What to Include |
|---|---|
| SKU ID | Unique code for each product variant |
| Product Name | Full product name as listed on Shopee PH |
| Category | Product type (Clothing, Electronics, Beauty) |
| Supplier | Supplier name or code |
| Purchase Price (PHP) | Unit cost in Philippine pesos |
| Selling Price (PHP) | Your listed price in PHP |
| Lead Time (Days) | Supplier delivery time in business days |
| Reorder Point | Minimum stock before you need to reorder |
Stock Ledger Sheet:
| Column | What to Include |
|---|---|
| Date | Transaction date |
| SKU ID | Links to Product Master via VLOOKUP |
| Movement Type | Sale / Purchase / Return / Adjustment |
| Quantity | Positive for stock in, negative for stock out |
| Channel | Shopee PH / Lazada PH / TikTok Shop / Walk-in |
| Reference | Order number or purchase order number |
| Notes | Reason for adjustments, return condition |
Keep the ledger append-only: add rows, never edit existing ones. This creates a reliable history useful for BIR compliance and supplier dispute resolution — a common issue for Philippine sellers managing multiple supplier relationships.
Which Excel Formulas Power an Inventory Tracking System?
Four formulas handle most inventory tracking in Excel: SUMIF calculates current stock from the ledger, VLOOKUP or XLOOKUP pulls product data across sheets, IF with comparison operators flags low stock automatically, and SUMIFS filters movements by channel or date range. XLOOKUP is available in Microsoft 365; use VLOOKUP on older versions of Excel.
Here are the formulas every Philippine seller using Excel for inventory should know:
| Formula | Purpose | Example |
|---|---|---|
SUMIF | Total all movements for a specific SKU | =SUMIF(Ledger[SKU],A2,Ledger[Qty]) gives current stock |
XLOOKUP | Pull product name or cost from master | =XLOOKUP(B2,ProductMaster[SKU],ProductMaster[Name]) |
VLOOKUP | Same as XLOOKUP (older Excel versions) | =VLOOKUP(B2,ProductMaster,2,FALSE) |
SUMIFS | Filter movements by channel and date | Shopee PH sales in June only |
IF | Flag low stock with reorder alert | =IF(CurrentStock<ReorderPoint,"Reorder","OK") |
COUNTIF | Count how many SKUs need restocking | Products currently below reorder point |
The IF low-stock flag in your dashboard is the closest Excel gets to an automated alert. When a product’s calculated stock falls below its reorder point in the Product Master, the flag column changes from “OK” to “Reorder” — visible at a glance if you use conditional formatting to colour the cell red.
Two common errors to avoid:
Typing numbers directly into dashboard cells. If your current stock cell contains =SUMIF(...) and someone overwrites it with 47, the formula is gone. Future movements no longer update that cell. The count will be permanently wrong until someone rebuilds it.
Skipping the Movement Type column. A purchase receipt and a return look identical in a ledger if both add positive quantity. Movement Type lets you filter returns separately, which matters when reporting shrinkage or reconciling with courier return records from J&T Express PH or Ninja Van PH.
Can Excel Sync Inventory Across Shopee PH and Lazada PH?
No. Excel has no API integration with Shopee PH, Lazada PH, TikTok Shop, or any Philippine marketplace. Every order requires a manual entry in your spreadsheet after you see it in your seller dashboard. During high-volume sale campaigns — 11.11, Mega Sales, or Shopee PH payday promotions — manual updates fall behind order velocity within minutes.
When an order arrives on Shopee PH, Excel does not know — you must manually update your spreadsheet. During 11.11 or 9.9 sales, orders arrive faster than manual updates can follow. Your Lazada PH listing still shows 8 units after you sold the last 3 on Shopee. A buyer purchases on Lazada. You are oversold. Your seller rating absorbs the penalty.
Running Shopee PH and Lazada PH simultaneously? Compare tools with verified multi-channel sync, pricing in PHP, and honest verdicts in our inventory management software comparison for Philippine sellers.
When Should Philippine Sellers Upgrade from Excel to Inventory Software?
The clearest upgrade signals are: two or more active sales channels running simultaneously, 100+ active SKUs, or 50+ orders per day — whichever comes first. At this threshold, the operational cost of manual spreadsheet maintenance outweighs the ₱1,500–5,000 per month cost of entry-level inventory software with automatic Shopee PH and Lazada PH sync.
Here is a direct comparison:
| Factor | Excel | Dedicated Inventory Software |
|---|---|---|
| Monthly cost | Free (MS Office or Google Sheets) | ₱0–5,000/month |
| Channel sync | Manual only | Automatic (2–15 min typically) |
| Overselling risk | High during peak hours | Near zero |
| Setup time | 1–3 hours | 1–5 days |
| Learning curve | Low (already familiar) | Moderate |
| BIR audit trail | Manual, error-prone | Built-in, timestamped |
| Multi-user access | Conflict-prone on shared files | Role-based, collision-free |
| Mobile use | Difficult for practical warehouse work | App-based, usable on warehouse floor |
| Variant tracking | Complex formulas required | Built-in SKU management |
| Suitable for | 1 channel, under 100 SKUs, under 30 orders/day | 2+ channels, growing SKU count |
The clearest signal that Excel is no longer sufficient: you have had at least one overselling incident caused by a channel update lag, or your team spends more than one hour per day just keeping the spreadsheet current.
For Philippine sellers at this stage, tools like Ginee, Jubelio, and Sellercraft offer Shopee PH and Lazada PH integrations at ₱0–5,000 per month. See our inventory management software comparison for a breakdown by seller stage.
What Are the Main Limits of an Excel Inventory System?
Beyond the lack of marketplace sync, Excel inventory systems face five recurring problems at scale: formula drift from accidental manual edits, version conflicts when multiple users share a file, no real mobile access for warehouse work, limited variant tracking for products with size and colour options, and no integration with Philippine couriers like J&T Express PH or Ninja Van PH.
Philippine sellers who continue using Excel past their operational threshold consistently encounter these issues:
1. Formula drift from accidental editing
When a team member manually types a number into a cell that contains a SUMIF formula, the formula disappears silently. The next time stock changes, that cell does not update. Your inventory count is now permanently wrong for that SKU — and nothing flags it until a stockout or an oversell makes it visible.
2. Version conflicts in shared files
If two team members update a Google Sheets file at the same time, the last save wins. Concurrent edits on the same row produce unpredictable results. A warehouse assistant logging a supplier delivery and a sales coordinator recording an order at the same moment can result in one entry being lost entirely.
3. No logistics integration
Dedicated inventory tools often integrate directly with J&T Express PH, Ninja Van PH, and Flash Express for label generation and shipment tracking. Excel does not connect to any courier API. Tracking return deliveries, undelivered parcels, and COD reconciliation all require separate manual records outside the inventory system.
4. No real mobile access for warehouse work
Warehouse staff in Philippine fulfillment centres rarely work at a desktop. Receiving deliveries or counting stock means writing numbers on paper and encoding them into Excel later — a gap where errors accumulate. Dedicated inventory tools offer mobile apps that let warehouse assistants log receipts or scan barcodes on the warehouse floor, updating counts immediately for all users.
5. Limited variant tracking for products with size and colour options
Philippine fashion and lifestyle sellers often carry products with multiple variants — a t-shirt in five sizes and four colours generates 20 SKUs from a single product. Managing this in Excel requires either separate rows for each variant combination (producing unwieldy sheets with hundreds of rows per product) or complex nested formulas that break when a team member adds a new size. Dedicated inventory tools treat variants as a native data structure: one parent product, multiple child SKUs, each with its own stock level.
Frequently Asked Questions
Is Excel good for inventory management in the Philippines?
Excel works for Philippine ecommerce sellers with a single sales channel, under 100 SKUs, and under 30 orders per day. Once you add Lazada PH or TikTok Shop beside Shopee PH, the lack of automatic channel sync creates overselling risk that dedicated tools like Ginee or Jubelio address from ₱0 to ₱1,500 per month.
How do I build a basic inventory tracking system in Excel?
Use three linked sheets: a Product Master listing SKUs, costs in PHP, and reorder points; a Stock Ledger recording every movement as a new row (never edit existing rows); and a Dashboard calculating current stock per SKU using SUMIF. Add an IF formula to flag items below their reorder point. This structure gives you an audit trail usable for BIR compliance and supplier dispute resolution.
How do I track inventory across Shopee PH and Lazada PH in Excel?
You add a Channel column to your Stock Ledger and record each sale against the correct platform. After each order on either channel, you manually deduct from your master stock count in the spreadsheet. The limitation is speed: during peak sale hours, manual updates fall behind real order volume, creating overselling risk on the slower-updated channel. Automatic sync requires dedicated inventory software like Ginee or Jubelio.