Sales Reports
      Back to home
      1. INTERNAL - Bepoz Help Guides
      2. End-User | Reporting, Data Analysis & Security
      3. Sales Reports

      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