I know an alternative process to generate the inventory information, proactiveaqbbw. We'll have to export the report to Excel and manually enter the opening and closing inventory from there.
At this time, there are no native reports that will display the beginning inventory and closing inventory. You'll have to manually track, calculate, and enter the value into the reports to include it.
Explore these links to view the list of reports you can use to get the information, including the method to calculate the beginning and ending inventory:
When you have the information handy, follow these steps to export it to Excel:
- Open the report you're working on, click the Export icon, and select Export to Excel.
- Save the file where you can easily locate it.
- Next, open it and manually add the opening and closing inventory.
For your other concern, run a Transaction List by Customer report to know the usage of products. Here's how:
- Go to the Reports menu on the left panel and type Transaction List by Customer in the Search field.
- Click the Switch to classic view button and set the date range in the Report period drop-down.
- Tap the Customize button to tailor the data.
- Press the Run report button to apply the changes.
Refer to this guide for more details about setting the report's view: Customise reports in QuickBooks Online using modern view.
Refer to these resources for insights on dealing with inventory discrepancies and the implications of inventory on financial statements:
Drop a comment below if you need further assistance navigating around the product, or have additional questions about running inventory reports. We're always ready to lend a helping hand.
