Supplier delivers 200 units. You update one Excel cell. An order comes in on Lazada PH. You forget to update the same cell. Now your Shopee PH listing shows 10 units you do not have.
An Excel inventory tracking system prevents this, as long as the spreadsheet stays current. Here is what it tracks, how Philippine sellers use it daily, and when it stops being enough.
What Is an Inventory Tracking System in Excel?
An inventory tracking system in Excel is a structured spreadsheet that records every stock movement (deliveries in, sales out, returns, adjustments) and calculates your current quantity on hand per SKU using formulas. For Philippine ecommerce sellers, it typically runs in Microsoft Excel or Google Sheets at no subscription cost, but requires a manual update after every transaction.
An inventory tracking system in Excel is not a single column of current stock numbers. Storing stock as a typed number you manually update has no history: if the number is wrong, there is no way to trace when it went wrong or why.
A tracking system records movements instead. Every delivery received, every order shipped, every return processed, every count correction made is logged as a new row. Your current quantity is calculated from those rows using a SUMIF formula, not stored as a typed number someone can accidentally overwrite.
This distinction matters for accuracy and for the audit trail Philippine sellers need when resolving supplier disputes or preparing documentation for Bureau of Internal Revenue (BIR) compliance.
What Does an Excel Inventory Tracking System Track?
An Excel inventory tracking system tracks four types of stock movements: purchases from suppliers (deliveries in), sales to buyers (orders out), returns from buyers (items back in), and adjustments (corrections after a physical count). Each row records the SKU, quantity, date, channel, and reference number to create a complete stock history.
Here is what each movement type covers in practice:
Incoming stock (purchases from suppliers). Every batch of product received from a supplier creates a new row. Record the SKU, quantity, purchase price in PHP, and actual delivery date. Comparing actual delivery dates against supplier lead times helps identify suppliers who consistently deliver late, a recurring issue for Philippine sellers sourcing from suppliers with variable schedules.
Outgoing stock (sales). Every confirmed, dispatched order reduces your available count. Philippine sellers on Shopee PH and Lazada PH typically export completed orders from their seller dashboards and encode them into the tracker once or twice a day.
Returns from buyers. Returned items enter as positive movements, but the Movement Type column separates them from supplier deliveries. This matters for condition assessment: a returned item may be unsellable and should go into a separate “damaged” count rather than back into available stock.
Adjustments (count corrections). After a physical stockcount, your spreadsheet total and your physical count often do not match. The difference is recorded as an adjustment row, with a note explaining the reason (damage, loss, miscounting). Tracking adjustments separately from sales and returns gives you a record of unexplained shrinkage over time.
Here is the minimum column structure for a tracking sheet:
| Column | What It Records |
|---|---|
| Date | Transaction date |
| SKU | Product identifier |
| Movement Type | Purchase / Sale / Return / Adjustment |
| Quantity | Positive for stock in, negative for stock out |
| Channel | Shopee PH / Lazada PH / TikTok Shop / Walk-in |
| Reference | Order number or supplier purchase order number |
| Notes | Return condition, adjustment reason, supplier name |
For detailed formula setup including the Product Master sheet and SUMIF dashboard, see our inventory management system in Excel guide for Philippine sellers.
How Do Philippine Sellers Use Excel for Day-to-Day Inventory Tracking?
The typical daily routine for a Philippine seller using Excel to track inventory is: export completed orders from Shopee PH and Lazada PH each morning, record each order in the tracker, log any supplier deliveries received, and check the dashboard for low-stock flags before starting a new selling day. At under 50 orders per day, this typically takes 15 to 45 minutes.
The practical daily workflow for a Philippine seller running one Shopee PH and one Lazada PH store:
- Export completed orders. Download your previous day’s shipped orders from the Shopee PH Seller Center and your Lazada PH account, or use your seller apps.
- Record each order. Enter each shipped order as a negative row in your tracking sheet, with the channel and order reference number.
- Log supplier deliveries. Record any deliveries received that day as positive rows, with the supplier name and delivery reference.
- Check for low-stock SKUs. Review your dashboard tab (or a low-stock flag column) for items approaching their reorder threshold. Place purchase orders for flagged items before the count reaches zero. A reorder point calculator helps set accurate thresholds.
- Process returns as they arrive. Log each returned item with its condition and whether it goes back to available stock or into a damaged category.
At under 50 orders per day on a single channel, this workflow is manageable for one person in under an hour. The system starts breaking down when order volume increases or when multiple channels require simultaneous manual updates.
What Are the Limits of Excel for Inventory Tracking in the Philippines?
An Excel inventory tracking system has four operational limits that create real risk at scale: no automatic marketplace sync with Shopee PH or Lazada PH, no safe concurrent multi-user access, no mobile-ready warehouse interface, and no courier integration with J&T PH or LBC. Each limit is manageable alone. Combined at higher order volumes, they make accurate manual tracking unreliable.
No automatic sync with Shopee PH or Lazada PH. Excel has no API connection to any Philippine marketplace. When an order arrives on Shopee PH, your spreadsheet does not update. You must see the notification, manually update the tracker, then manually update your Lazada PH listing count. During 11.11 or 9.9 campaign periods, this sequence falls behind order velocity within minutes, creating overselling risk on whichever channel you updated last.
No safe concurrent multi-user access. If two team members update the same Google Sheets file at the same time, the last save overwrites the other. A warehouse assistant logging a supplier delivery and a sales coordinator recording an order can result in one entry being silently lost. Dedicated inventory software uses record locking to prevent this.
No mobile-ready warehouse interface. Receiving deliveries or counting stock on the warehouse floor means writing numbers on paper and encoding them into a laptop later. This gap is where errors accumulate. Dedicated inventory tools offer mobile apps that let warehouse staff log receipts and scan barcodes in real time, with counts updating immediately across all users.
No courier integration. Tools like Ginee and Sellercraft integrate directly with J&T PH, LBC, and Ninja Van PH for shipment tracking and return management. Excel connects to nothing. Tracking undelivered COD parcels or reconciling courier returns requires separate manual records outside the tracking system.
When Should Philippine Sellers Move from Excel to Inventory Tracking Software?
The practical upgrade threshold is two or more active sales channels running simultaneously, or roughly 50 or more orders per day, whichever comes first. At this point, the daily manual effort and overselling risk from spreadsheet lag typically outweigh the cost of dedicated inventory software, which starts at approximately PHP 499 to 1,500 per month for tools with native Shopee PH and Lazada PH sync.
Here is a direct comparison to help with the decision:
| Factor | Excel Tracking System | Dedicated Inventory Software |
|---|---|---|
| Monthly cost | Free | Approximately PHP 499 to 5,000/month |
| Marketplace sync | Manual after each order | Automatic (typically 15 to 60 seconds) |
| Overselling prevention | Depends on manual update speed | Near-zero with real-time sync |
| Concurrent users | Conflict-prone on shared files | Role-based, collision-safe |
| Mobile warehouse access | Impractical | App-based |
| Courier integration (J&T PH, LBC) | None | Available on most paid tools |
| BIR audit trail | Manual, error-prone | Timestamped, built-in |
| Best for | Single channel, under 50 orders/day | Multi-channel or growing operations |
The clearest upgrade signal: you have had at least one overselling incident caused by a channel update lag, or your team spends more than an hour per day just keeping the tracking spreadsheet current.
For Philippine sellers at this threshold, the most commonly used tools based on seller community research are Ginee (free tier available, paid plans at approximately PHP 499 to 999 per month per Ginee’s published pricing) and Sellercraft (paid plans from approximately PHP 1,200 to 1,500 per month per Sellercraft’s published pricing). Both offer native Shopee PH and Lazada PH integration. Verify current pricing directly with each provider before committing.
Frequently Asked Questions
What is an inventory tracking system in Excel?
An inventory tracking system in Excel is a spreadsheet that records every stock movement as a separate row (purchases in, sales out, returns, adjustments) and calculates your current quantity on hand per SKU using formulas like SUMIF. It differs from a simple stock column by maintaining a full transaction history, which provides an audit trail for supplier disputes and BIR documentation.
How is an inventory tracking system different from an inventory management system in Excel?
Both terms are often used interchangeably. An inventory tracking system focuses on recording movements and calculating current quantities. An inventory management system typically adds cost tracking, reorder point formulas, multi-sheet linked dashboards, and supplier management. In practice, the distinction is one of scope and complexity. See our full guide to building an inventory management system in Excel for Philippine sellers for the complete three-sheet setup including formulas.
Can an Excel tracking system prevent overselling on Shopee PH and Lazada PH?
Not automatically. Excel has no API connection to Shopee PH or Lazada PH, so it cannot deduct stock in real time when an order arrives. A well-maintained tracking system gives you accurate counts to cross-check manually before accepting new orders, but preventing overselling automatically requires dedicated inventory software with native marketplace sync such as Ginee or Sellercraft.
How many SKUs can I realistically track in Excel?
A well-structured Excel tracking system can handle hundreds of SKUs without performance issues. The practical constraint is the manual update workload, not Excel’s capacity. Above roughly 100 SKUs and 30 to 50 orders per day, daily encoding typically takes more than an hour. At that point, the time cost of manual tracking generally exceeds what dedicated inventory software costs per month.
What is the best free alternative to Excel for inventory tracking in the Philippines?
Ginee offers a free tier with Shopee PH and Lazada PH sync, capped at 100 orders per month. It eliminates the manual update requirement and prevents overselling automatically. Google Sheets is the best free option if you want to stay in a spreadsheet environment, since it allows shared access and works on mobile, though it still requires manual updates after every transaction.