The Detailed Takings Report is used to list all of the items sold during a specified date range for selected departments.
Generating the Report
- On the top menu bar of Retailer, click on Reports > Sales Reports > Takings Reports > Detailed Takings Report
- In Report Date Range:
- Select the Start Date - This will be the Start Date of the report
- Select the End Date -This will be the End Date of the report
- Tick the 'This Shift Only' box if you only wish to analyse the sales made in the current shift
- In Catalogue name:
- If you want to only display items sold from a specific catalogue tick the 'Select A Catalogue' box and choose the relevant catalogue. If not leave this blank.
- Options:
- Show Individual Stock Item Sales – Tick this box if you wish to see individual item sales in the generated report. This will allow you to be specific with what shows on the report. It allows you to see:
- Sell Price & GP/Date Last Arrived – This option chooses weather the report shows the sell price and gross profit or the date stock was last arrived.
- Quantity on Hand – This shows the amount of quantity currently in the system.
- Show Full Description – This shows the full description of the product rather then shortening it to fit the report.
- Cost Prices – This shows the cost price of the items on the report.
- Barcode/Supplier Stock Code/PLU – This chooses which data is shown respective to each item.
- Exclude Home Delivery & Subagent Orders – This option will stop home deliveries and Subagent orders from being shown on the report
- Itemise Instore/External Source - This option will separate external sales such as Webstore or Roam
- Exclude Agency – Excludes Agencies from being shown on the report (Eg. Lotto)
- Average Takings By Day - Show Average Unit Cost, Sell and Quantity Sold per day
- Show Department Categories - This will List Stock By Department and then by Category
- Show Serial Numbers – This will show serial numbers for products that have this setting enabled.
- Date Created/Date Completed – This chooses whether to display Laybys by the date they are created or the date they are completed.
- Show Individual Stock Item Sales – Tick this box if you wish to see individual item sales in the generated report. This will allow you to be specific with what shows on the report. It allows you to see:
- In select Departments:
- Select which departments to search. To select all departments click the All circle at the top, otherwise click Selected. If you want stock not in a category to be included in the report tick Include Stock not in a Category.
If you clicked Selected use the tick-boxes on the right to select which departments and categories to show in the report.
- Select which departments to search. To select all departments click the All circle at the top, otherwise click Selected. If you want stock not in a category to be included in the report tick Include Stock not in a Category.
- Click Preview or Print.
Reading the Report
The Detailed Takings Report has a total of sales for the period broken down by department.,
- Description – Lists selected departments and their respective categories
- No. Of Items – Shows how many items have been sold in each department/category
- Total Cost – Lists the total cost price of all items sold in each department/category
- Total Sales – Shows the total sale price of all items sold in each department/category
- Total GP – Lists the total amount of profit made from each department/category
- Total GP % - Shows the amount of profit made as a percentage of the sale price from each department/category
- The data at the bottom demonstrates totals for each respective column and includes information about GST and rounding.
Exporting the Report to Excel
- Once you have the settings correct, click Preview.
- Click Print in the top left corner
- Tick the box for Print to File, towards the bottom of the window.
- In Type:, select either Xlsx Data File or Xlsx Report File. The report file will include the graphics and layout of the report, while the data file will only include the data.
- In Where: click the ... symbol to select the location where the file will be saved.
- Click Print to generate the file