How to Maintain Fabric, Trim and Accessory Record in an Excel Sheet?

SHARE:

Learn the method of inventory control in a garment factory. Download sample Excel template and learn how to prepare your own excel template for maintaining fabric, trims and accessory record.

Fabrics, trims and accessories are raw materials for a garment manufacturing business. In a garment factory the fabric and trim store is responsible maintaining inventory record. In this post I have shared one simple excel format for your reference. I have also explained how to make inventory tracking format in Excel sheet.

You purchase different types fabrics, trims and accessories items for your orders and you also keep inventory for these items. You should keep stock of inventories of raw materials in your store to keep the production on without any break. High level of inventory cost to company and fewer inventories may slow down the production rate. To maintain right inventory level, you should know how much inventory you have in your store of all type of items and how much inventory you are expecting to receive in your store and expected date of receiving those items.

As a store keeper, your main responsibility is to maintain minimum stock of all items (regular items) and controlling the inventory level by reordering.

How to control your inventory without purchasing an inventory management and control software (ERP)?

You need a tool to record all incoming materials, their volume and necessary information against each item. Spreadsheet like Excel sheet is one of the good options for them who don't have software for inventory management and control. Assuming that you still prefer excel sheet for inventory tracking. You can keep record of your inventories in a excel file and retrieve data whenever you need. For this you need to enter inventory record manually.

How to make an inventory tracking format in Excel Sheet

  1. Prepare an excel format for recording data for inventory purchase and inventory consumption
  2. In the excel template make columns for all necessary information that you need. 
  3. Update your file regularly. I would suggest you to update your inventory tracking file daily. 
  4. Use pivot table for viewing data against particular item. You can use various combinations for viewing data, like- inventory sourcing status of an order. 
inventory tracking
Inventory tracking template

1. Prepare your excel file for data recording.

When you will be preparing your excel format for factory inventory record, follow these points.
  • Add columns in the format for as much information as you need. See the image below. I have added x number of columns. 
  • Use data validation for fields those will be entered repeatedly. Like buyer name, item type, UOM. By doing this you can avoid typing same thing differently. Benefit of using data validation in your template, easier to data sorting while you view reports. 
  • Use formula for calculations wherever applicable. Like balance quantity of items and item wise amount. 
  • Add filter to the first row (header row)
  • Freeze pane as you need. In the sample template header row and 4 columns are freezed.
  • Secure your excel sheet and inventory tracking file. To stop misuse of the inventory tracking sheet you can secure the file by password and also you can protect specific rows and columns if you want.
  • You can set conditional formatting for highlighting certain cells, like low inventory level, pending purchase, and delay in sourcing. 
Also read: Fabric reconciliaion procedure

2. Identify columns (fields) for your record


  • First decide what all information you want to maintain record. Based on that add columns in the format.
  • If you prepare your format with unnecessary fields (columns) you have to fill all of them. Filling an excel sheet consume time. Like PO number, Style number, Buyer for the style, Item name, item type, item color, sourcing date, issue date, purchased quantity, issue quantity etc. See the following template for an example.
  • Your inventory format is ready for recording fabrics, trims and other items. 
  • Don’t think much about the format that you made. Later you can add additional columns if necessary. 

3. Data entry and inventory record updating:

  • Enter data in the excel sheet.
  • Most of the departments are dependent on you for raw materials. Merchandisers, factory owners, sampling department and production people need to know the inventory status of a particular item. You are responsible for proving them right status of the inventory. You can provide right information to them at the right time, only if your inventory record is updated. 
  • So update your inventory tracking file daily.
  • Don’t forget to cross check your data.
  • Delegate data entry job one of your subordinates, if you are busy with other things. When you delegate work to someone remember to providing them instruction what to do and how to do.

4. View reports

Analysis inventory consumption and purchase details

  • Check stock of inventory
  • After few days of data entry you will have lot of data in the inventory tracking sheet. Finding particular information would be a tough job. 
  • You can see desired data (information) on the same sheet (table) by filtering data in desired columns.
  • Pivot template is another option for doing data analysis and viewing report for the desired information. Prepare pivot table for common report types.
  • You can also do post shipment inventory data analysis. 
Click on the following link to download the sample inventory tracking sheet. The sample inventory tracking sheet is just for your reference to prepare your own file.


Note: There are some limitations of using excel sheet for inventory record. So if you can afford an ERP, better you go for one. Use secured database.

Some of disadvantages of using excel sheet:
  • There might be chance of making errors while entering data manually.
  • Repeat entry of same information.
  • Limitation in data analysis and report viewing
  • Lot of manual data entry work
Download this template and modify it as per your factory need. You you have any question you are welcome to write me.

[post_ads_2]

COMMENTS

You may also like

Name

5S,3,Activewear,1,Apparel ERP,1,apparel industry,56,apparel news,33,Apparel Production,31,Apparel Software,17,Bamboo Fabric,1,Bangladesh,1,Blogs,1,Books,31,Business Guides,9,Buyer,1,Buying House,4,CAD/CAM,1,Calculation & Formula,1,career,34,Change Management,1,Clothing,2,Clothing Brand,3,Compliance,3,Consumption,4,Costing,7,Cutting,18,Denim,3,Directory,3,Dyeing,1,eCommerce,2,Education,5,Event & Fair,14,Fabric,73,Fashion,5,Fashion Business,38,Fashion Design,3,Fashion Show,1,Fiber,1,Finishing,10,Garment Exporters,1,Garmenting,2,Gartex,1,GSM,1,Guest Post,8,Human Resource,2,Industrial Engineering,211,Infographic,5,Knitting,3,Kurti,1,Lean,27,Line layout,3,Machines,30,Manufacturing,51,Merchandising,105,MIS,23,MISC,20,Operation bulletin,14,Operator,1,Operator Training,1,Performance rating,1,PLM,3,Printing & Embroidery,11,Problem Solving,1,Production Planning,27,Project Report,1,QNA,121,Quality,61,Quality manual,2,Quality system,14,Research project,1,Resources,43,Retailing,4,Salary & Wages,7,Sampling,22,Scheduling,3,Sourcing,8,Spec Sheet,9,Sportswear,3,Stitching,3,Store,2,Stretch fabric,1,Student corner,1,sustainable clothing,7,T-shirt,3,Tailor,1,Tailoring Shop,2,Technology,58,Texprocess,1,Textile processing,11,Textile testing,23,Textiles,42,Threads,1,Towel,1,Trims & Accessories,15,videos,11,Waste,1,Work Study,38,Yoga wear,1,
ltr
item
Online Clothing Study: How to Maintain Fabric, Trim and Accessory Record in an Excel Sheet?
How to Maintain Fabric, Trim and Accessory Record in an Excel Sheet?
Learn the method of inventory control in a garment factory. Download sample Excel template and learn how to prepare your own excel template for maintaining fabric, trims and accessory record.
https://3.bp.blogspot.com/-g2itc5vK_jo/WHi-TDWgsKI/AAAAAAAAEKs/i2lelbzgCwsqWqSyVonU_y2xqvXKwE6TQCK4B/s640/invert-tracking-template-garment-factory-store.png
https://3.bp.blogspot.com/-g2itc5vK_jo/WHi-TDWgsKI/AAAAAAAAEKs/i2lelbzgCwsqWqSyVonU_y2xqvXKwE6TQCK4B/s72-c/invert-tracking-template-garment-factory-store.png
Online Clothing Study
http://www.onlineclothingstudy.com/2017/01/how-to-maintain-fabric-trim-and.html
http://www.onlineclothingstudy.com/
http://www.onlineclothingstudy.com/
http://www.onlineclothingstudy.com/2017/01/how-to-maintain-fabric-trim-and.html
true
6551124471002606808
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy