Inventory Tracking Spreadsheet

VIEWS: 7,333 PAGES: 26

This Inventory Tracking Spreadsheet is designed to help businesses track the goods from the warehouse through distribution and sales. This basic template records the units received and units distributed, and the balance of the inventory is automatically calculated and shown on the top of the template. The user can include a date, purchase order number and item name and description. This spreadsheet can be customized to include additional tracking information.

More Info
									Business name                      Store Depot
                                 Month period                      April 30, 2010
                                 UNITS/STOCK IN THE WAREHOUSE           2,300



                        UNITS RECEIVED                                                UNITS DISTRIBUTED
Date                     PO #     Item name        Units              Date            INVOICE #   Item name   Units
Opening stock                                               200      April 12, 2010                                   200
       April 12, 2010     122345 computers                 1,000     April 12, 2010                                   500
       April 13, 2010                                      1,000     April 13, 2010                                   500
       April 14, 2010                                      1,000     April 14, 2010                                   500
       April 15, 2010                                      1,000     April 15, 2010                                   200
								
To top