Manual Excel tracking breaks at roughly 30 orders per day. Every Shopee PH sale requires a manual update, every weekend means reconciling what sold against what remains, and every formula error silently corrupts your count. A stock management system in Excel fixes that by turning your spreadsheet into a structured, repeatable process — without a monthly software subscription.
What Is a Stock Management System in Excel?
A stock management system in Excel is a structured workbook that tracks product quantities, records stock movements, and signals reorder points — all without dedicated software. For Philippine ecommerce sellers managing a single channel or a small SKU count, it handles the basics of inventory control at zero ongoing cost.
A stock management system in Excel is a purpose-built workbook — not a random tracking sheet — designed to maintain an accurate count of every product you carry. At minimum, it records three things: how much stock came in from suppliers, how much went out through fulfilled orders, and what is currently available to sell.
Done correctly, it answers the same core questions as paid inventory software:
- How many units do I have right now?
- Which products are running low?
- How much have I sold this week, this month?
The difference from informal spreadsheet tracking is structure. Each stock movement flows through a defined process — stock in, stock out, adjustments — so your count stays accurate instead of drifting every time something goes wrong.
For Philippine sellers managing a single Shopee PH store with under 100 SKUs, a well-built Excel stock system is a practical starting point before committing to a software subscription.
What Does a Stock Management System in Excel Track?
A functional Excel stock management system tracks inbound stock from suppliers, outbound fulfillment, manual adjustments, and current available quantity — organized across linked worksheet tabs. Philippine sellers typically add a reorder-level column to flag products before they run out.
A complete Excel stock management system covers at least four interconnected areas, each on its own worksheet tab:
Product master list Every SKU with a unique identifier, product name, unit of measure, and supplier reference. This is your reference sheet — all other tabs look up against it. Without a clean product list, every formula breaks when you rename a product or add a variant.
Stock-in records Every purchase order or supplier delivery logged by date, SKU, quantity received, and optionally unit cost. This is the inbound side of your stock ledger.
Stock-out records Every order fulfilled, logged by date, SKU, and quantity. For Shopee PH and Lazada PH sellers, this means exporting your completed orders from the seller center and pasting them into the sheet.
Current stock summary A tab that uses SUMIF formulas to compute current quantity per SKU: opening stock + stock in − stock out. This summary also flags products below a reorder threshold.
Optional: Adjustments tab Stock damaged during handling, miscounted units, samples given to buyers — these go in a separate adjustments tab so they don’t contaminate your sales data.
Here is a reference for how each worksheet tab connects to the others:
| Tab | Primary columns | Feeds into |
|---|---|---|
| Products | SKU, name, unit, supplier, reorder level | All tabs via VLOOKUP |
| Stock In | Date, SKU, quantity received, unit cost | Current Stock (SUMIF) |
| Stock Out | Date, SKU, quantity fulfilled | Current Stock (SUMIF) |
| Adjustments | Date, SKU, type, quantity, reason | Current Stock (SUMIF) |
| Current Stock | SKU, opening, in, out, adjustments, available | Dashboard / reorder flag |
The Current Stock tab is the one you check daily. Everything else feeds it.
How Do You Set Up an Excel Stock Management System?
Setting up a functional Excel stock system for a Philippine ecommerce business takes 2–4 hours for a small catalog. The process involves building five linked worksheet tabs, defining reorder levels per SKU, and establishing a daily update routine for stock-out entries.
Here is the setup process step by step:
Step 1: Build your product master list Create a “Products” tab. Columns: SKU code, product name, unit, supplier name, reorder level (the quantity that triggers a purchase order), and preferred order quantity. Assign consistent SKU codes to every item — variants like Size S and Size M need separate SKU codes, not the same one with a note.
Step 2: Create a Stock In tab Columns: date, SKU, product name (VLOOKUP from Products), quantity received, unit cost (optional). Every supplier delivery gets one row.
Step 3: Create a Stock Out tab Columns: date, SKU, product name (VLOOKUP), quantity fulfilled. Export completed orders from Shopee PH Seller Center or Lazada PH periodically and paste them here.
Step 4: Build the Current Stock summary Create a “Current Stock” tab. For each SKU: opening stock + SUMIF(Stock In, SKU, quantity) − SUMIF(Stock Out, SKU, quantity) − SUMIF(Adjustments, SKU, negative adjustments). Add a column that shows “Reorder” when current quantity falls below the reorder level set in your Products tab.
Step 5: Add the Adjustments tab Columns: date, SKU, type (damaged / miscounted / sample / other), quantity (positive = added, negative = removed), reason. Feed this into the Current Stock formula so adjustments are reflected automatically.
Microsoft’s Excel inventory template library includes a basic layout you can adapt to this structure without building from scratch.
Use a reorder point calculator to calculate the right reorder level for each product before filling in your Products tab. Guessing the reorder level leads to either overstocking or stockouts.
Where Does Excel Fall Short for Multi-Channel Sellers?
Excel handles single-channel stock control reasonably well up to roughly 100 SKUs and 30–50 daily orders. Beyond that, the absence of automatic sync, concurrent access, and a live API connection to Philippine marketplaces causes counts to drift and oversells to happen.
Excel is a spreadsheet, not a sync tool. Once you operate across two or more channels, it breaks in predictable ways:
No automatic sync with Shopee PH or Lazada PH Excel does not connect to Shopee PH or Lazada PH via API. Every sale requires a manual export-and-paste cycle. If you sell a unit at 11 PM and update the sheet the next morning, your stock count is wrong for those hours. This is how oversells happen.
No concurrent access Two people cannot reliably edit the same Excel file at the same time without overwriting each other. Operations that require both warehouse staff and an office manager tracking stock create version conflicts.
No passive audit trail Excel formulas compute from the data you enter. If a row gets deleted, a formula breaks, or data gets pasted in the wrong column, the count drifts silently. Recovering requires reviewing every row — time most sellers don’t have.
Formula complexity scales poorly A 50-SKU catalog is manageable. A 500-SKU catalog with variants, bundles, and multiple storage locations turns the workbook into a maintenance burden. Performance slows and formula errors become harder to trace.
For context on what a dedicated stock control system provides beyond Excel — specifically how real-time API sync across Shopee PH and Lazada PH works — that article walks through the mechanism in detail.
When Should You Move from Excel to Dedicated Software?
Most Philippine ecommerce sellers benefit from dedicated inventory software when they run two or more channels, process more than 30–50 daily orders, or have experienced an oversell incident from a delayed Excel update.
The transition point varies by seller, but these signals appear consistently:
- You’re running Shopee PH plus at least one other channel (Lazada PH, TikTok Shop PH, or your own website)
- Manual export-paste for stock-out entries is consuming an hour or more each day
- You’ve had at least one oversell incident that resulted in a cancelled order or a seller rating penalty
- Your catalog has grown beyond roughly 100 SKUs, or variants (color, size) have multiplied your row count significantly
- Two or more people need to update the stock count simultaneously
Before switching, calculate your safety stock levels — the buffer quantity that prevents stockouts during supplier delays. These numbers go directly into any software you configure.
For a comparison of inventory management software options available for Philippine sellers, that guide covers pricing and channel support for tools accessible in the local market.
The transition from Excel doesn’t need to be immediate. Most sellers run both in parallel for a month — cross-checking counts weekly — before fully switching over. The accurate baseline you build in Excel is the opening stock figure you load into any new software.
Keep Reading
- Stock Control System: Guide for Philippine Ecommerce Sellers
- Inventory Management System in Excel: Philippine Sellers Guide
- Inventory Tracking System in Excel: Philippine Sellers
- Inventory Management Software for Philippine Sellers
- Ecommerce Order Management System — Philippines
Frequently Asked Questions
Is Excel a good stock management system for a small Shopee PH seller? For a single-channel seller with under roughly 100 SKUs and fewer than around 30 orders per day, Excel is a workable starting point. It is free, familiar, and handles the basics of stock tracking. The limitations appear when you add a second channel or order volume grows past what manual updates can sustain.
Can I connect my Excel stock sheet to Shopee PH automatically? Not natively. Excel has no built-in API connection to Shopee PH. Syncing requires a manual export from Shopee Seller Center and pasting order data into your sheet. Some sellers use Microsoft Power Automate with third-party connectors, but these require technical setup and are not officially supported by Shopee PH.
What formulas do I need for an Excel stock management system? The core formula is: current stock = opening stock + SUMIF(Stock In range, SKU, quantity) − SUMIF(Stock Out range, SKU, quantity). VLOOKUP or XLOOKUP pulls product names and reorder levels from your master product list. Conditional formatting — highlighting cells red when stock falls below the reorder level — makes the summary tab readable without scanning every row.
How is an Excel stock system different from a stock control system? An Excel stock system is a manually maintained spreadsheet — you enter data and run formulas. A stock control system is software that connects directly to your sales channels, deducts stock automatically on every order, and pushes updated counts to all connected channels in near real time. Both give you an accurate count when working correctly; dedicated software maintains that accuracy without manual input.
What should I do when my Excel stock count is no longer accurate? Run a reconciliation: export your full order history from Shopee PH and Lazada PH for the relevant period, physically count your stock on hand, and compare the two. Once you have an accurate baseline, either tighten your Excel update routine or use that baseline to migrate into dedicated software. Recurring inaccuracies — where the count keeps drifting despite corrections — signal that the manual process cannot scale with your current order volume.