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:
    • 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
  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 Sale Number, Staff Member, Date, Time, Sale Type, Terminal, Customer Number, Rounding, Total Discount, Amount Ex GST, GST, Amount Inc GST.
      As well as Stock Item details: 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 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
    • Sales types included on the report. Untick or tick the type of sale you wish to include. Notable sale types to tick include: Invoice Sales to see sales charged to customer accounts for payments later, Customer Payments or Subagent Payments to see payment transactions on accounts, and Duty Free / Tax Free sales to see those sales where the GST was intentionally excluded for normally GST Inclusive sales.
  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 different types of sales and Payment Type Totals shows totals for each payment type.

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.