You can use the standard options in Excel to design an inventory template and then add information on an ongoing basis. Open Excel and begin a new spreadsheet by clicking "File" and selecting "New." ...

How to Calculate Retail Shrinkage in Excel. In retail terms, shrinkage refers to a company's percent loss resulting from damage, product expiration and theft of unsold products.