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

      21 | Period Summary Data Explained

      This article will cover an overview on Period Summaries with the the addition of relevant configurations and data features that can be made. For ease of readability, the Period Summary Report is divided into six categories: Stock Summary; Account Summary; Sales Summary; Discount Totals; Banking Summary; and Product TypeGroup Sales. This article is broken down into sections for each of the aforementioned categories and details the formulas used to obtain the data in each.

      This article will cover an overview on Period Summaries with the the addition of relevant configurations and data features that can be made.

       

       

         

        For ease of readability, the Period Summary Report is divided into six categories: Stock Summary; Account Summary; Sales Summary; Discount Totals; Banking Summary; and Product TypeGroup Sales.

        This article is broken down into sections for each of the aforementioned categories and details the formulas used to obtain the data in each.

        Prerequisites 
        • To access Period Summary Settings, the applicable Operator Privileges will need to be enabled 
          • Operator Maintenance 'Reporting' Tab
            • Sales Reports: "Allow Cash Reports" Flag
        Period Summary Report Overview & Breakdown

        Stock Summary Section
        • This section displays the Stock Movements in the given time period and the value of Stock Movements
        • The Stock Summary section of the Period Summary Report consists of the following fields:

         

        Field Name

        Data Description/Formula
        Opening Stock
        • This is the Opening Balance of the system when the Stocktake started
        • I.e., the Closing amount of the previous Stocktake
        Purchases
        • This shows the Total Purchases made during the given time
        Transfers In
        • This is the total Product Transfers Received during the given period
        • The value of Stock Transfers can be generated from Stock Control > Stock Transfer
        Transfers Out
        • This is the total Products Transferred Out during the given period
        • The value of Stock Transfers can be generated from Stock Control > Stock Transfer
        Stock Sold
        • This is the total amount of Stocks Sold in the given period
        Stock Adjustments
        • This column shows any adjustments made in the stock quantity for the given time period
        • The value of Stock Transfers can be generated from Stock Control > Stock Adjust
        StockTake Variance
        • This column shows any difference reported during the Stock movement for  the given time period 
        • I.e., StockTake Variance = Stock Value in the System- Counted Stock Value
        Nett Stock Movement
        • This column shows value the stock movements i.e. Transfer Ins, Transfer Outs, Purchases and Sales of stock during the reporting period
        Closing Stock
        • This is the Closing Balance of the system after all the adjustments

         

        Sales Summary Section
        • The Sales Summary section displays the sales history of the business including the Cost Variances and Adjusted Sales
        • The Sales Summary displays the Sales information for the given period of time:

         

        Field Name

        Data Description/Formula
        Gross Sales
        • This is the Value of Total Sales occurred in the given time period
        Pricing Variance
        • This is the Difference in Prices of the product from the previous stocktake
        • I.e., Pricing Variance = Product Price during the last Stocktake - Current Product Prices
        Nett Total
        • This is the Total Sales after deducting Discounts and/ or Returns
        • I.e., Nett Total = Gross Total - Discounts
        Nett Sales Ex
        • This is the Nett total Sales excluding Tax
        • I.e., Nett Sales Ex = Gross Sales - Returns
        Taxfree Sales
        • This is the sales for which no tax amount was charged
        • I.e., Taxfree Sales = Total Sales - Taxed Sales
        Inclusive Taxes
        • This is the tax included in the cost of products sold
        • I.e., Inclusive Taxes = Total Sales - Taxfree Sales
        Cost of Sales
        • This is the Cost value of sold products
        Profit
        • This is the profit earned in the given time period
        • I.e., Nett  Sales - Cost of Goods
        Cost of Variances
        • This is the difference between Actual Cost and Budgeted Cost of sales
        Cost of Sales Adjusted
        • This is the Cost Value of Adjusted Sales
        Profit Adjusted
        • This is the value of  Profit amount after the Cost of Sales has been adjusted

         

        Banking Summary Section
        • This section displays the different types of Payment mediums used by the business and the total value of the Transactions processed from each of the mediums
        • This section includes the following options:

        • The Payment mediums seen in this example may differ depending on System configurations
         

        Field Name

        Data Description
        Cash
        • This is the total amount of Cash calculated to be in the Till
        EFTPOS
        • This is the EFTPOS Payment made to the Transactions
        MasterCard
        • This is the amount paid from Mastercards
        Visa
        • This is the amount paid from Visa Cards

        AMEX
        • This is the amount paid from American Express Cards
        Others...
        • This is the amount paid from other mediums (Cards or cash accepted)
        • E.g., International Cards or Foreign Currencies as configured in BackOffice
        Drawer Tot
        • This is the Total Amount calculated of all Payments
        Rounding
        • This is the Rounding Amount used to avoid decimal points or complexity

         

        • The transaction media in the Banking Summary is not limited to the given list
        • Additional external systems' payments can be added according to the Organization's business preferences
          • This can be done from the Global Settings component in BackOffice

        Account Summary Section
        • The Account Summary section displays the total turnover and payments made from Account transactions along with the details about the Points system
        • This section displays the information regarding different Account holders in the System's database:

         

        Field Name

        Data Description
        Turnover
        • This is the Total Turnover accumulated from Account based transactions
        Charges
        • This is the Value of Total Charges or Additional Cost imposed upon the Account Members
        Payments
        • This is the total payments made by the account members
        Cleared
        • This is the Total Value Lost by the Account Members when the operators reset the account
        Balance Movement
        • This is the balance movement from the account holder's account
        Opening Points
        • This is the points collected by members at the beginning of the given time
        Points Earned
        • This is the points earned by the members
        Points Redeemed
        • This is the value of points redeemed by the members
        POints Expired
        • This is the value of expired points earned by the user
        Points Movement
        • This is the points movement occurred during the given time period
        Closing Points
        • This is the total closing points at the end of account summary reports
        Discount Totals Section
        • The Discount Totals section displays the Total Value of all the Discounts given during the reporting period along with the total value of each discount type
        • This section consists of the following fields:

         

        Field Name

        Data Description/Formula
        Till Discount
        • This is the Total Value of Discounts given from the Till or Workstation
        Account Discount
        • This is the Total Value of Discounts given to the Account Holders
        Price Number Disc
        • This is the Total sum of all the Price Number Discounts given to customers
        Promotion
        • This is the value of Total Promotional Discounts given
        Table Promo Items
        • This is the value of Total Table Promotion Items served onto the tables
        Points Redeem
        • This is the value of Total Earned Points redeemed by the customers to get Discounts
        Package Discount
        • This is the Total Value of Package Discounts given to customers
        Condiment Zero Price
        • This is the Total Value of condiments  price added on the transaction
        Pricing Variance
        • This is the difference in pricing occurred due to the discount
        • I.e., Discounted Price = Actual Price - Discount Amount and then Pricing Variance  = Actual Price - Discounted Price
        Product TypeGroup Sales Section
        • This section displays all the Product TypesGroups and the revenue generated from each of the TypeGroups
        • The TypeGroups listed will differ from this example depending on the System's configured Product Type Groups which can be found in Global Settings

        • This section displays all the Product TypeGroups that have been added to the system along with the Quantity Sold and the Value of Sales
          • The Qty column displays the Total Quantity of Product Type Groups sold in the Given period
          • The Sales column displays the Total Sales occurred for the product in the given period
        • Organizations can create up to 8 Product Type Groups and 30 Product Types with the Bepoz system; these Type Groups and Types can be easily added and edited from Global Settings > Sorts & Types Tab