Hi, I can see A/R aging report and I tried creating stock aging report on my own but unable to do it successfully. Any tips on how to create the aging report for stock?
Currently, you're unable to generate a Stock Aging Report in QuickBooks Desktop. You'll want to use QuickBooks Enterprise with Advanced Inventory to generate a report that has the most of the data you need. Then, export it to Excel and create a pivot table to design a customized Stock Aging report.
Click Edit on the upper menu, select Preferences.
Choose Items & Inventory.
Go to the Company Preferences.
Select Advanced Inventory Settings.
Tick the Use FIFO starting on the optionto turn on the FIFO inventory tracking feature.
From the Reports menu, select the FIFO Cost Lot History by Item report.
Export this report to excel by clicking the Excel button besides Email.