Write-Off Report

Write-Off Report

The write-off report produces a list of stock that has been written off during a given date-range.
Info
Click HERE for more information on writing off stock.

Generating the Report

  1. On the top menu bar of Retailer, click on Reports > Stock Reports > Write-Off Report
  2. Date Range - Select a start date and end date for the report to cover
  3. 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
  4. 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
  5. Select Suppliers Tab:
    • Select All  - Shows stock from all suppliers
    • Selected - Tick the suppliers you want included in the report.
  6. 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.
  7. 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.
  8. Show Serial Numbers - Report will display the serial numbers of written off stock.
  9. 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

  1. Date - Date stock was written off
  2. Staff ID - Staff initials entered when stock was written off
  3. Stock Description - The name of the stock item
  4. Barcode - Barcode of the stock item
  5. Reason - The reason chosen for writing off the stock
  6. Quantity - Number off that item written off
  7. GST Credit - The total GST on the cost price of the items
  8. 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:

  1. PDF - Click on the red PDF button at the top of the report and choose your save destination.
  2. 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.


    • Related Articles

    • Write Off Stock

      We have a video guide on how to write off stock in Retailer - ? Writing Off Stock Often you need to use stock from your store in the office or behind the counter (eg. sticky tape, paper for the printer, etc). The Write-Off Stock functionality of ...

    • Supplier Sales Analysis Report

      The Supplier Sales Analysis Report is used to list all items sold during a specified date range for selected Suppliers. You can choose multiple Suppliers, therefore allowing you to compare the sales totals by Supplier. You can also choose different ...

    • Sales by Month Report

      This report shows the sales totals for each month in the past year ending with the selected month/date. The report can be grouped three different ways, and can display cost and sell prices together with sale numbers. Generating the Report From the ...

    • Staff Comparison Report

      The purpose of this report is to compare the sales performance of staff members within a specified date range. For this report to be effective, you must be using staff initials when ending sales. Generating the Report On the top menu bar of Retailer, ...

    • Monthly Takings Report

      The Monthly Takings Report lists departments and their breakdown of each sale type per month for the date range specified, up to 12 months individually or 5 months if GST breakdown is included. The report is not suitable if looking at figures for ...