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

      27 | Till Balance Data Explained

      This article explains the Till Balance Reports and the different sections included in the report. A Till Balance Report allows Operators to balance the Expected Total amounts in the System with the Actual Total amounts counted in the Till. This report shows any kind of monetary transaction which occurred in the given time period and reports all the adjustments that have been made in the system.

       

      This article explains the Till Balance Reports and the different sections included in the report.

       

       

         

        A Till Balance Report allows Operators to balance the Expected Total amounts in the System with the Actual Total amounts counted in the Till.

        This report shows any kind of monetary transaction which occurred in the given time period and reports all the adjustments that have been made in the system.

        With Bepoz, the Till Balance Report can be easily accessed through the BackOffice in the Sales Report section.

        Prerequisites
        • To access Till Balance Data Settings, the applicable Operator Privileges will need to be enabled 
          • Operator Maintenance 'Reporting' Tab
            • Sales Reports: "Allow Cash Reports" Flag
        Till Balance Report Main Sections
        • Till Balance Report displays information about various Transactions that occurred via the Till/s
        • This report is further grouped into different sections which are mentioned below
        Till Balance Header
        • Till Balance Header section as the name suggests appears at the very top of the Till Balance Report
          • This information is retrieved from the Receipt Printer Format of the applicable Workstation
        • The Till Balance Header is configured in the Printer Format Setup and then teh Printer Format is assigned to the Receipt Printer in Workstation Maintenance

         

        Balance Info Section
        • This is the first section of the Till Balance Report which shows the total of all the Monetary Transactions processed during the reporting period
        • The Balance Info includes the following fields:

         

        Field Name

        Data Description
        Gross Sales
        • The Gross Sales includes the Total Sales occurred in the Till without any deductions
          • This section only includes the Total Sales that have occurred i.e. Sum of all the Sales
        • In the example, there are different types of transactions being deducted from Gross Sales such as Discounts, Points Redeemed etc. 
          • These are the amounts to be deducted to get the actual amount generated from the Till
        Nett Total
        • Nett Total displays the Total Amount accumulated after all the transaction based expenses have been deducted
        • The amounts that have been adjusted are some of the extra charges or extra fee imposed by the business
        Drawer Total
        • This section displays the total amount generated from a transaction that should exist in the drawer
        • The additional Renewal Fee is the fee for Account renewals

         

        Payment Details Section

         

        Field Name

        Data Description
        Payment Details
        • This section displays the payment details from different mediums the business used
        • These mediums can be Cash, EFTPOS, Foreign Currencies etc.
        Drawer Difference
        • Drawer Difference shows the difference between the amount generated in the system and the amount counted
        • Based on the Drawer Difference, operators can check if their Till is Under or Over the required amount

         

        Account Details Section
        • This section displays the summary of Account Based Transaction Turnover
        • The Charges columns displayed the total amount that has been charged to account members for dining, member renewal fees etc
        • The Payments columns display the Payments made by the account members
        •  If the Account Members are also subjected to the promotional points system, this section displays the Points Earned, Spent and Redeemed by Account Members in different rows

         

        Misc Details
        • This section displays other Miscellaneous Details related to the transaction
        • Some of the details can be Cancelled Sales, No Sales, Staff Training Cost, Returns and Refunds etc.
        • These details are displayed in the Till Balance Report based on the BackOffice configuration and do not necessarily occur in every system

         

        Tax Details Section
        • The Tax Details usually displayed the amount from two types of transactions
        • The GST Free Sales refers to the sales that did not have Tax Included
        • The GST Sales refers to the sales in which Tax amount was added

        • The sections in the Till Balance Report does not only limit to the displayed sections
        • Operators are allowed to add more details and edit the displayed details from the BackOffice > Workstation Maintenance to suit their preferences
        Additional Sections Sort Types, Sort Groups, Product Types & Type Groups
        • Operators can also configure additional details to be displayed in the Till Balance Report according to their preferences
        • In the given example, the amount generated from Product Sort, Sort Groups, Types, and Type Groups have been displayed

        • These details are not mandatory for every Till Balance Report and can be Added and Removed from the report using BackOffice
        • To edit the Detail Settings, go to Workstation Maintenance from Venue, Stores & Tills
        • Click on the Flags / Other Tab and tick the flags On / Off from the Reporting section

        Tips Payout 
        • Similarly, enabling the Show Tips Payout flag in the Reporting section will add Tip Details section  in the Till Balance Report


        • Tips Card displays all the Tips amount paid from Card
        • Tips Cash displays all the Tips amount paid in Cash