We can utilise the inventory tracking feature in QuickBooks Online (QBO) Plus and Advanced, @danny51.
First, ensure that inventory tracking is enabled in your QBO settings for accurate stock management.
Here's how:
- Go to the Gear icon and select Account and settings.
- Choose the Sales tab.
- In the Products and services section, click the Pencil icon.
- Enable the option for Track stock quantity on hand.
- Select Save, then Done.

Once inventory tracking is on, you can add (the £120,000 worth of ) your stock as an inventory item following these steps:
- Go to the Gear icon and select Products & services.
- Click New to add a product or service.
- Select Stock as the product type.
- Fill in the required details, including a Name for the stock.
- For the Initial quantity on hand, enter the stock you have.
- For the Stock asset account, select Stock Asset. QuickBooks uses this account to track the value of your stock.
- Enter the Cost per item.

QuickBooks will automatically calculate the total stock value (£120,000) and create the necessary journal entry to show this asset on your Balance Sheet (B/L) report.
Follow these steps to run the report:
- Navigate to Reports from the left-hand menu.
- Search for or select the Balance Sheet report.
- Adjust the Report period to your desired date (for modern view) or click Run report (for classic view only).

For any additional questions or concerns, just select the Reply button.