• Go to Stock > Stock Valuation. 

• A 'Stock Valuation' window will appear.

• The user will feed date as per the requirement.

• Also In 'Stock status' the user will select 'Whole'.

• The user will click on 'Accept'.

• A 'Closing Stock' window will be appear.

• Now the user will press 'Alt+P' key to export report in excel format.

• Now the user will select 'Export to File'.

• An 'Export to file' window will appear in which user needs to enter the path where the file needs to be exported.

• Then click on 'Excel'.

• Now the user can view that the file has been exported to the mentioned path.

After following the above steps, the user can view that the stock valuation will be exported in Excel format.