Stock by Age Report

Grouped by supplier, this report will list departments, categories and stock, showing what is remaining on hand, from stock arrived during a period. It will give a quick overview of aged stock in the system.

Generating The Report

On the top menu bar of Retailer, click on Reports > Sales Reports > Fast Sellers Report >Stock By Age Report.  Set the options as described below, then click Print or Preview to generate the report.

Report Options:

1. Stock to Include: You can select a supplier, department and/or category to include, if you wish to narrow down a particular group of items, or you can select all suppliers and departments if you wish to include all stock
   
2. Show Stock Items: Shows individual stock items in the report and doesn’t only show the report based on supplier, department and categories
   
3. Show Department / Supplier Totals: Show totals for each department or supplier, as well as category totals.

Reading The Report

1. Supplier / Department / Category - Displays suppliers in alphabetical order and departments under the suppliers will be listed, if there is stock on hand in the department for that supplier.
2. Time Period Ranges:
   
1. Qty is how much stock on hand you have, from items arrived on that selected time period.
   
2. Cost shows you the total cost of those items arrived during that period.
   
3. % Total shows a percentage of how much of your total quantity arrived is arrived during that 3-month period. This is the same for the other month periods.
   

Stock Values on the Report are Tax Inclusive

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

• General Stock Listing Report

  We have a video guide on how to use the General Stock Listing Report - ? General Stock Listing Report The General Stock Listing Report lists selected stock items by department/category as of when the report is run. It is most commonly used for the ...

• 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 ...

• Supplier Stock Listing

  We have a video guide on how to use the Supplier Stock Listing Report - ? Supplier Stock Listing Report The Supplier Stock Listing Report lists selected stock items by department, category and supplier as of when the report is run. It is most ...

• Importing a Waterlyn Stock File

  This is the advice for importing a Waterlyn stock file. The stock file is embedded in this article. Do not try this with another stock file. The stock file included with this article has been tested. We know it works. The stock file attached here is ...

• Detailed Performance Report

  The Detailed Performance Report allows you to assess your stock's performance using key retail indicators like gross profit, return on investment, and stock turn. It can display totals for individual stock items, categories, or departments. It's also ...