QuickBooks Point of Sale Software is the Coolest business solution I have ever come across as far as Sales and Inventory Management is concerned. Unfortunately, it does not track Inventory Expiration. This lacking feature has been a thing of concern to many businesses (especially, those sale perishable products) that are in dire need of this feature.
The steps below highlights how you can use Quickbooks Point of Sale to Record Inventory Expiration, as well as track them. Unbelievable Right?
Let's Find Out!
Open QuickBooks POS.
Click on Reports > Items > Items List
Double Click on any Item on the list to Edit Item. Click on the Custom Tab
Click on Define Field and type the desired field needed for Inventory Expiry Dates
Enter a new item and set the Expiry Date in the Additional Information Box
Reports > Items > Items List
Export to Excel, Go to Conditional Formating > Highlight Cells Rules > More Rules > Use Formula to Determine which Cells to Format.
Enter this Formula in Format Values where Formula is true:
=Today()+12*7> T7 (Assuming you Need Info on Products Expiring in 3 months and The Expiry Date Cell is T7).
All Inventory highlighted in Red are Expiring in 3 Months. You Can Keep Editing the Formula to Suit your Business Needs.