<\/p>\n
Anyone in the fabric business knows: inventory is money sitting idle in the warehouse. But there is a type of inventory more dangerous stock sitting too long without anyone knowing<\/strong>. Fabric rolls imported at the start of last season, sitting in a corner shelf, hidden by new stock. By the time it is discovered, the color has<\/p>\n This is a common problem in most small fabric warehouses \u2014 yet few track it systematically. This article shares what many small fabric warehouses face when they don't tracking fabric inventory with Excel<\/strong>, and how to fix it with just a structured file.<\/p>\n<\/div>\n Reality of small-scale fabric businesses<\/p>\n In this article<\/strong><\/p>\n Inventory age<\/strong> (inventory aging) is the number of days from when goods entered the warehouse to the present. Unlike stock quantity \u2014 which tells you how much<\/em> \u2014 inventory age tells you how long stock has been how long it has been sitting<\/em>.<\/p>\n Most small fabric warehouse owners only track quantity: \"5 rolls of cotton left\", \"out of ka<\/p>\n For fabric, time is a silent enemy:<\/p>\n “A fabric warehouse doesn't lose money because of slow sales \u2014 it loses money because no one knows which stock needs to be sold first.”<\/p>\n<\/blockquote>\n The answer isn't carelessness. It's because the way most small fabric warehouses operate lacks an automatic alert mechanism.<\/p>\n Every time new stock arrives, fabric rolls are placed on the outside of the shelf, on top of the stack. Old stock gets pushed to the inside, to the bottom. Everyone grabs from the outside for convenience \u2014 and old stock just sits there. This is the phenomenon of natural LIFO<\/strong> (Last In, First Out) \u2014 the complete opposite of the FIFO (First In, First Out) principle that every standard warehouse system follows.<\/p>\n Most small warehouses don't label import dates on each roll. The notebook says “imported 20 rolls of kate fabric on Jan 15” \u2014 but 3 months later, looking at the shelf, no one can tell which roll was imported on Jan 15 and which on Mar 20. Everything blends into one line: “kate fabric \u2014 12 rolls remaining”.<\/p>\n End-of-month inventory: count rolls, reconcile with the ledger. If quantities match, done. No one checks when was this roll imported<\/em>. Result: the report states “50 rolls in stock, valued at 30 million VND” \u2014 but perhaps 10 of those rolls have been in stock for over 6 months and are only truly worth 3 million VND instead of 6 million VND.<\/p>\n A familiar scenario<\/p>\n A customer comes asking for 5m of beige cold fabric. You check the book: \"8m left\". Go to the warehouse \u2014 search and search but can not<\/p>\n<\/div>\n Many warehouse owners think losing a few hundred thousand VND on one slow-moving fabric roll is “no big deal”. But when you add it up month by month, year by year, the total is anything but small.<\/p>\n Direct losses<\/strong><\/p>\n Indirect losses<\/strong><\/p>\n “A small fabric warehouse doesn't need to be big to lose money. It just needs to not know which stock is dying.”<\/p>\n<\/blockquote>\n No need for inventory management software costing millions of VND per month. A properly structured Excel file is enough to solve stock aging issues for inventory with fewer than 50 fabric SKUs. Prerequisite: the file must include formulas that automatically calculate inventory age<\/strong> from import date to present, and format colors by threshold<\/strong> so you can tell at a glance which rolls need priority.<\/p>\n A minimum tracking system needs 3 components:<\/p>\n Each row records: date, fabric SKU, import\/export quantity, supplier, shelf location. This is the “source of truth” \u2014 all other numbers are calculated from this table. No need to be complex, just needs to be consistent<\/strong>: record immediately when it happens, don't wait until the end of the week to update.<\/p>\n Automatically calculate days in stock for each fabric code. Use conditional formatting to change colors: green (under 30 days),<\/p>\n Each shelf has a limit. When total quantity on a shelf exceeds 80% capacity, the file automatically alerts you. This helps you know before new stock arrives that the warehouse is already overloaded \u2014 avoiding the situation of “goods arrived but nowhere to put them”.<\/p>\n No need to overhaul your entire workflow. Just add one layer of structure to your current process:<\/p>\n Step 1: Download the file and enter your existing fabric SKU list.<\/strong> List all fabric codes in stock, specifying shelf location and entry date (estimate if not precisely remembered). This is the baseline \u2014 the starting point for everything to become progressively more accurate.<\/p>\n Step 2: Spend one session doing a physical inventory count.<\/strong> Walk through each shelf, compare actual quantities with entered data. Correct any discrepancies. From this step forward, every import\/export is recorded in the file \u2014 data updates automatically.<\/p>\n Step 3: Check the dashboard for 5 minutes each week.<\/strong> Check if any fabric SKUs have moved to the yellow zone (30\u201390 days) \u2014 prioritize selling those first. Check if any SKUs are in the red zone (over 180 days) \u2014 plan for clearance. Just 5 minutes per week, but it can save millions of VND each quarter.<\/p>\n When should I upgrade?<\/strong> Fabric Inventory Lite is suitable for warehouses with under 50 fabric SKUs and 1\u20132 managers. When your warehouse grows to 50\u2013100 SKUs, needs detailed monthly import\/export reports, or batch management \u2014 that's when you upgrade to Fabric Inventory Comprehensive<\/a> (499,000 VND). All existing data is preserved, only features are added.<\/p>\n<\/div>\n Yes \u2014 because with 15\u201320 SKUs, you can still have 3\u20135 items sitting too long without knowing. With a small warehouse, the file is even simpler and quicker to set up \u2014 just 1\u20132 hours.<\/p>\n<\/details>\n A notebook can record quantities, but it cannot automatically calculate inventory age, alert you when stock is old, or show the big picture of your warehouse. Excel does what notebooks cannot.<\/p>\n<\/details>\n Yes \u2014 it works on Excel mobile or Google Sheets. Enter data right at the warehouse, no need to sit at a computer.<\/p>\n<\/details>\n Up to you. The file supports both units. What matters is consistency: pick 1 main unit and stick with it.<\/p>\n<\/details>\n Fabric Inventory Lite focuses on shelf capacity and aging inventory \u2014 6 sheets, no VBA. Fabric Inventory Comprehensive also includes: full inventory in\/out tracking, monthly reports, batch management, and 100+ automated formulas. Start with Lite for free, upgrade when needed.<\/p>\n<\/details>\n\n
\n\n
\nInventory aging \u2014 the metric most warehouse owners overlook<\/h2>\n
\n\n
\n \nStorage time<\/th>\n Fabric condition<\/th>\n Remaining value<\/th>\n<\/tr>\n<\/thead>\n \n Under 30 days<\/strong><\/td>\n Like new, sells at original price<\/td>\n 100%<\/td>\n<\/tr>\n \n 30 \u2013 90 days<\/strong><\/td>\n Still good, prioritize selling<\/td>\n 90\u2013100%<\/td>\n<\/tr>\n \n 90 \u2013 180 days<\/strong><\/td>\n May fade, may crease<\/td>\n 60\u201380%<\/td>\n<\/tr>\n \n Over 180 days<\/strong><\/td>\n Visibly deteriorated, hard to sell<\/td>\n 30\u201350%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n \n
\nWhy does stock sit so long without anyone noticing?<\/h2>\n
1. New stock hides old stock<\/h3>\n
2. No import date on fabric rolls<\/h3>\n
3. Inventory checks only count quantities<\/h3>\n
\nThe real cost of not tracking<\/h2>\n
\n
\n
\n
\nStructured Excel \u2014 a just-enough solution for small inventory<\/h2>\n
Import-export data table<\/h3>\n
Inventory age dashboard<\/h3>\n
Capacity Alerts<\/h3>\n
\n\n
\n \nCriteria<\/th>\n Notebook \/ scattered Excel files<\/th>\n Structured Excel (Fabric Inventory Lite)<\/th>\n<\/tr>\n<\/thead>\n \n Know how much is in stock<\/strong><\/td>\n Yes (if inventory is checked regularly)<\/td>\n Yes \u2014 automatic<\/td>\n<\/tr>\n \n Know how long items have been stored<\/strong><\/td>\n No<\/td>\n Yes \u2014 calculated from import date<\/td>\n<\/tr>\n \n Old stock alert<\/strong><\/td>\n No<\/td>\n Yes \u2014 automatic color change<\/td>\n<\/tr>\n \n Know which shelf is full<\/strong><\/td>\n Must check in person<\/td>\n Yes \u2014 capacity alerts<\/td>\n<\/tr>\n \n Inventory Check Time<\/strong><\/td>\n 1\u20132 days\/month<\/td>\n 30 min\/month (reconciliation)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n3 steps to start today<\/h2>\n
\nFrequently Asked Questions<\/h2>\n
My warehouse only has 15\u201320 fabric SKUs, do I need this file?<\/summary>\n
I keep very detailed notebooks, why do I still need Excel?<\/summary>\n
Does the file work on a phone?<\/summary>\n
Is fabric imported by roll or by meter?<\/summary>\n
What’s the difference from “Fabric Inventory Comprehensive”?<\/summary>\n
\n