Info
We have a video guide on how to use the Sales Transaction Log - ðŸŽ¬ Sales Transaction Log

The Sales Transaction Log can be used to show all your previous transactions for the date range specified, which can be further separated based on transaction type, staff member, terminal used and payment type.

Generating the Report

  1. On the top menu bar of Retailer, click on Reports > Sales Reports > Sales Transaction Log
  2. 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
  3. Summary details:
    • Summarise Sales - Shows the Sale Number, Staff Member, Date, Time, Sale Type, Terminal, Customer Number, Rounding, Total Discount, Amount Ex GST, GST and Amount Inc GST
    • Show Details Of Sales - Shows the following addition Stock Item details with every sale: Supplier Stock Code, Barcode, Quantity Sold, Discount, Amount Ex GST, GST and Amount Inc GST per item. 
  4. Discount details:
    • Show All Sales - Shows all sales with and without discounts.
    • Discounted Sales Only - Shows all sales with discounts only.
    • Non Discounted Sales Only- Shows all without discounts only.
  5. Options:
    • Terminals - select the POS machine you want to run the report on or select all terminals.
    • Staff - choose a selected staff member to run a report on their sales or select All Staff.
    • Only Show Sales that do not Add Up - Will only display sales where the items in the sale do not match the total of the sale. If ticking this, it is best to untick some of the transaction types on the right, as otherwise all transactions where no items are purchased (eg. Customer Payments) will also appear on the report.
    • Only Show Negative Sales - Will only display credits and other sales where money was returned to the customer (eg. Lotto Payouts).
    • Show Serial Numbers - Displays the serial numbers of stock sold in sales.
  6. Payment Type Settings:
    • Show Payment Type Per Sale - Shows the payment type used per transaction and the amount
    • Show All Payment Types - Will list all sales with all payment types
    • Only Show Selected Payment Types - allows you to select individual or multiple payment types by double clicking on the payment type in the Selected Payment Types list so the report only includes sales with those selected payment types
  7. Select Transaction Types to Include:
    • Normal Sale - sales paid up front
    • Invoice Sale - sales charged to accounts
    • Duty Free / Tax Free Sales - sales where the GST was intentionally excluded for normally GST Inclusive sales.
    • Layby Sales - newly created Layby Sales
    • Customer Payments - Customer Account, Layby or Proforma Payments
    • Subagent Payments - Subagent Account Payments, applies to Newsagencies only
    • No Sales - transactions where cash was added or removed from a till
    • Balance Adjustments - manual adjustments made to a customers account balance. 
    • Subagent Orders - Subagent Charges and Credits, applies to Newsagencies only
    • Orders and Surcharges - Customer Orders for Newspapers, Magazines Putaways or Deliveries, applies to Newsagencies Only
    • Delivery Misses - Credits for deliveries that didn't occur for Newspapers or Magazines, applies to Newsagencies Only
    • Delivery Fees - Delivery charges for Newspapers or Magazines, applies to Newsagencies Only
  8. Click Preview or Print.

Reading the Report

  • Stamp - this is the sale number recorded within Retailer
  • Staff -  if Retailer has been configured for staff to enter their initials for sales, this column would have staff initials
  • Date - identifies the particular data within the period
  • Time - time that the sale was processed
  • Sale Type - what kind of transaction this sale was (e.g. sale, invoice, order charge, delivery fee)
  • Terminal - this shows what computer the sale/transaction was done on
  • Cust - shows the customer number for the affected customer account
  • Rounding - how much the original sale was rounded up or down by (e.g. $12.99 > $13, 1c profit)
  • Discount - total discount applied on a sale
  • Amount Ex GST - how much the sale was without GST
  • GST - how much GST is included in the sale
  • Amount Inc GST - how much the sale was with GST

If Show Details of Sales was enabled, the following detail about the stock item appears under each transaction

  • Staff - The staff members initials for that sale/stock item
  • Circled A or L or M - indicates whether the item sold was a Kit item with an (A), Linked item with a (L) or Manufactured Good item with a (M). 
  • PLU - The stock items PLU
  • Barcode - the stock items Barcode
  • Quantity - the quantity of the sold stock item
  • Description - the stock items description
  • Discount - the per unit discount value
  • Amount Ex GST - the items sale price without GST
  • GST - the items GST value in the sale
  • Amount Inc GST - the items sale price with GST
On the last page, you will have the Sales Summary and Payment Type Totals.
The Sales Summary shows you the totals for each of the different types of sales.
The Payment Type Totals section shows a breakdown of your different Pay Types.
​

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.