Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

26 | Transaction Journal Data Explained

This article covers all the default views for Transaction Journal and different formulas used to generate the data in the report. The Transaction Journal is an overview of all of the Transactions processed through the Till/s. This contains information regarding the Workstation , Operator that processed the Transaction and the Products Sold.

This article covers all the default views for Transaction Journal and different formulas used to generate the data in the report.

The Transaction Journal is an overview of all of the Transactions processed through the Till/s.

This contains information regarding the Workstation, Operator that processed the Transaction and the Products Sold.

Prerequisites 
  • To access Transaction Journal Settings, the applicable Operator Privileges will need to be enabled 
    • Operator Maintenance 'Reporting' Tab
      • Sales Reports: "Allow Products reports" Flag
"_Standard" View
  • The Standard View of the Transaction Journal consists of the following data columns by default:

 

Column Heading

Data Description

Date/Time
  • This column displays the Date and Time of the Transaction
Trans ID
  • This column displays the Transaction ID
Transaction Type
  • This column displays the Type of Transaction
Till Name
  • This column displays the Name of the Till in which the transaction was processed
Operator
  • This column displays the Name of the Operator who processed the Transaction
Transaction Total
  • This column displays the Total Amount of Transaction
Product Name
  • This column displays the Name of the Products that were sold
Size
  • This column displays the Size of the Products sold
Unit Qty Sold
  • This column displays the total Quantity of Products sold
Nett
  • This column displays the Nett Total Earning from the Transaction
Payment Name
  • This column displays the Name of the Payment 
  • I.e., Cash, Card, EFTPOS etc.
Amount
  • This column displays the Total Amount Paid

"_Accounts and Table" View
  • The Accounts and Table View consists of the following data columns by default:

 

Column Heading

Data Description

Date/Time
  • This column displays the Date and Time of the Transaction
Trans ID
  • This column displays the Transaction ID
Transaction Type
  • This column displays the Type of Transaction
Till Name
  • This column displays the Name of the Till in which the transaction was processed
Account Number
  • This column displays the Account Number if the Transaction is Account based
Account ID
  • This column displays the Account ID if the Transaction is Account based
Table Number
  • This column displays the Table Number if the Transaction is Table based
Table ID
  • This column displays the Table ID if the Transaction is Table based
Previous Bal
  • This column displays the previous balance of the Account Holder
Transaction Total
  • This column displays the Total Amount of Transaction
Product Name
  • This column displays the Name of the Products that were sold
Size
  • This column displays the Size of the Products sold
Unit Qty Sold
  • This column displays the total Quantity of Products sold
Payment Name
  • This column displays the Name of the Payment 
  • I.e., Cash, Card, EFTPOS etc.
Amount
  • This column displays the Total Amount Paid

"_Discounts" View
  • The _Discounts View consists of the following data columns by default:

 

Column Heading

Data Description
Date/Time
  • This column displays the Date and Time of the Transaction
Trans. ID
  • This column displays the Transaction ID
Transaction Type
  • This column displays the Type of Transaction
Till Name
  • This column displays the Name of the Till in which the transaction was processed
Operator
  • This column displays the Name of the Operator who processed the Transaction
Transaction Total
  • This column displays the Total Amount of Transaction
Trans. Disc% Number
  • This column displays the Number of Transaction Discount percentage
Trans. Disc Percent
  • This column displays the total percentage discount given in the transaction
Trans Disc% Amount
  • This column displays the total discount amount given in the transaction
Trans. DiscAmt Number
  • This column displays the Number of Transaction Discount Amount
Product Name
  • This column displays the Name of the Products that were sold
Size
  • This column displays the Size of the Products sold
Unit Qty Sold
  • This column displays the total Quantity of Products sold
Gross
  • This column displays the Gross Sale from the transaction
Nett
  • This column displays the Nett Sale from the transaction
Discount Number 
  • This column displays the discounts added to the transaction
  • A single transaction can have multiple discounts imposed which is why there are more than one Discount Number columns
Discount Amount
  • This column displays the amount discounted for each Discount Number