- On the top menu bar of Retailer, click on Reports > Stock Reports > Write-Off Report
- Date Range - Select a start date and end date for the report to cover
Select Reasons
- Select All - All write-offs appear on the report regardless of reason
- Selected - Tick the reasons you wish to appear on the report
Select Departments Tab:
- Select All - Shows stock from all departments/categories.
- Selected - Tick the departments you want included in the report. By clicking the arrow next to a department, you can expand its categories and further narrow down the included stock by category.
- Include stock not in a Category - Tick this box to include stock from the selected departments that has not been assigned a category
Select Suppliers Tab:
- Select All - Shows stock from all suppliers
- Selected - Tick the suppliers you want included in the report.
- Stock Tags - Select a tag from the drop down box and click the + symbol to add a tag. The report will only include stock that has one of the selected tags. To search for a specific tag, hit the ... symbol to bring up the tag searcher. You can remove a tag by hovering over it and then clicking the x symbol. If you do not select any tags, all stock will be included.
Order By - Change the sorting order of items on the report
- Date - Order by date stock was written off.
- Write Off Reason - Order by reason for write off.
- Show Serial Numbers - Report will display the serial numbers of written off stock.
- Show Notes (Landscape Only) - Shows notes you may have added when writing off stock. Automatically rotates the report to landscape layout when ticked.
Click Preview or Print to generate the report.
Reading the Report
- Date - Date stock was written off
- Staff ID - Staff initials entered when stock was written off
- Stock Description - The name of the stock item
- Barcode - Barcode of the stock item
- Reason - The reason chosen for writing off the stock
- Quantity - Number off that item written off
- GST Credit - The total GST on the cost price of the items
- Cost Inc. - Cost price of items written off including GST
The totals of all stock written off during the given date range are displayed at the bottom of the report.
Exporting the Report
You can export the report to either a PDF document or Excel spreadsheet by using the Preview button and following the below steps:
- PDF - Click on the red PDF button at the top of the report and choose your save destination.
- Excel spreadsheet - Click on the Print button at the top left. Tick 'Print to File' and select 'Xlsx Data File'. Click on the three dots button to choose your save destination. Click OK to save the file.