To keep things simple, it is recommended to use Microsoft Excel or Google Sheets. The spreadsheet format is excellent for organizing data into labelled rows and columns. The initial audit's spreadsheet can be found in this LibGuide, under the tab titled Initial Audit Spreadsheet.
Directly import your created list of books and authors in the collection into the spreadsheet and place in the first two columns. Create the other columns to the right of your materials based on your determined key figures and identifiers. Create more than one spreadsheet in your save Excel file if you are auditing more than one collection.