The status of the books can be known using the Movement log option. It helps to generate the list of books issued or due along with their status for a particular date.
At the top of your dashboard, click the module access icon > Academics > Library > Movement Log to open the Book movement log page.
Select the movement type: Issue date or Due date.
Select a date.
Click the Search button.
Click the Export as CSV button to export the details as a CSV file.