We have a video guide on how to use the Detailed Takings Report - 🎬 Detailed Takings Report

Generating the Report

1. On the top menu bar of Retailer, click on Reports > Sales Reports > Takings Reports > Detailed Takings Report
2. In Report Date Range:
   
   • Start Date - This will be the Start Date of the report
   • End Date -This will be the End Date of the report
   • This Shift Only - enable this option if you only wish to analyse the sales made in the current shift
3.  In Catalogue name:
   
   • Select A Catalogue - tick the box If you want to only display items sold from a specific catalogue and choose the relevant catalogue. If not, leave this blank.
4. 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 whether 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 than 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. This applies to Newsagencies only
     
   • Itemise Instore/External Source - This option will separate external sales such as Webstore or Roam
   • Exclude Agency – Excludes Agency departments from being shown on the report if enabled on the deparment (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 – Displays serial numbers for products with this setting enabled.
     
   • Estimate GP on Zero cost items - This will use your product's department or category's Retail Markup % to estimate your gross profit on products sold at $0 cost.
     
5. Treat Laybys as Sales on
   
1. Date Created - Items on Laybys will display on the report when the layby is created
   
2. Date Completed – Items on Laybys will display on the report when the layby is fully paid.
   
6. In Select Departments on the right-hand side:
   
   • Choose between Select All and Selected. Click between these options will tick and untick all Departments and Categories
   • Click the arrow > to the left of each Department to expand the Categories under that Department
     
   • Tick the Selected column to include the Department or Category
     
   • Ticking a Department will automatically tick Categories for that Department
     
   • Include Stock not in a Category - Tick this option to include Stock Items that have a Department set but no Category.
   • An easy way to exclude a certain Department or Category is to click 'Select All' then untick the Department(s) to exclude
     
7. Use the Tag box to filter the Report to only include Stock Items with any of the selected Tags:
   
   • To add a Tag, type the Tag Name into the box next to 'Tag', then press Enter or click the plus + button
   • To select multiple Tags, click the 3 dots button. You can then select any Tag from the 'All Tags' box
8. Click Preview or Print.
   

Reading the Report

The Detailed Takings Report has a total of sales for the period broken down by department.,

1. Description – Lists selected departments and their respective categories
2. No. Of Items – Shows how many items have been sold in each department/category
3. Total Cost – Lists the total cost price of all items sold in each department/category
4. Total Sales – Shows the total sale price of all items sold in each department/category
5. Total GP – Lists the total amount of profit made from each department/category
6. Total GP % - Shows the amount of profit made as a percentage of the sale price from each department/category
7. The data at the bottom demonstrates totals for each respective column and includes information about GST and rounding.