To get a closing stock report on a timely basis or any custom date. Go to Main menu, under more click on Reports. On left hand side select all reports and then search for closing stock report.
Every report has a filter option. To get a specific custom range report, choose end date only for opening stock, choose start date and end date for both received goods and issued goods and lastly, choose end date only for closing stock.
You can export any report by clicking on drop down button located next to edit that gives in a csv format excel sheet and also an option to add a report to dashboard.
Hope this is helpful!!