Skip to main content

Report - POS Transaction Day Summary

Introduction

The POS Transaction Day Summary report is a powerful tool for understanding your daily sales performance at the Point of Sale (POS). It provides a detailed breakdown of all transactions within a specified period, grouped by day and payment type. This report offers key insights into sales volumes, tax amounts, discounts, and the popularity of different payment methods.

Its main purpose is to help you reconcile daily earnings, monitor cash flow, and analyze sales trends at a granular level. By summarizing complex transaction data into an easy-to-read format, it simplifies daily financial management and accounting tasks.

This report is ideal for Club Managers, Financial Controllers, and Accounting Staff who need a clear and accurate overview of daily POS activities to ensure financial accuracy and operational efficiency.

Before You Start

To view this report, you must have the correct system permissions assigned to your employee role. If you cannot see the report, please contact your system administrator.

How to Assign Permissions:

  1. Navigate to PGM -> Clubs -> System Permissions.
  2. Select the Employee Role you wish to grant access to (e.g., 'Club Manager').
  3. A list of available reports and system functions will appear. To find the report quickly, use the search bar at the top and type "POS Transaction Day Summary".
  4. Alternatively, you can browse through the available categories. This report is likely located in the 'Sale' or 'Finances' categories.
  5. Check the box next to the report name to grant access.
  6. Click Save.

How to Generate the Report

Follow these steps to locate and run the report:

  1. Navigate to PGM -> Reports -> All.
  2. The "All Reports" screen will display a list of available reports.
  3. Use the search bar at the top of the page and type "POS Transaction Day Summary" to find the report instantly.
  4. You can also filter by category. This report is typically found under the 'Sale' or 'Finances' categories. Note that some financial reports may be located in the 'Custom' category.
  5. Once you find the report, click on its name to open the filter options.

Understanding the Filters

Before running the report, you will need to set the following filters to specify the data you want to see.

  • Club: Select the club you want to run the report for. You can also choose "All Clubs" to see data from every location you have access to.
  • Date Since: This is the start date for the report. For example, to see sales from the beginning of the month, select the 1st of the month.
  • Date Until: This is the end date for the report. The report will include all data up to, but not including, this date. For example, to see data for a single day (e.g., September 15th), set Date Since to 'September 15th' and Date Until to 'September 16th'.
  • Payment Type: Use this optional filter to see transactions for a single payment method. For example, select "Cash" to only view cash transactions. Leave it blank to include all payment types.
  • Transaction Source: This filter lets you choose the origin of the transactions.
    • Fiscal (Default): Shows standard, fiscalized sales made through the POS terminal.
    • Web: Shows only sales made online.
    • NoFiscal: Shows non-fiscal transactions, such as internal records or online payments not processed through a fiscal printer.
    • All: Includes all transactions from every source.
  • POS Station: Filter the report for a specific cash register or POS terminal. The default value of '0' includes all POS stations.
  • Transaction Status: This filter allows you to include or exclude deleted transactions.
    • NotDeleted (Default): Only shows active, valid transactions.
    • Deleted: Shows only transactions that have been marked as deleted.
    • All: Includes both active and deleted transactions.

Report Output

The report is divided into two main sections: a detailed Daily Summary and a high-level Payment Type Summary.

Daily Summary

This section provides a detailed list of all sales, broken down by club, date, and payment type.

  • ClubName: The name of the club where the transaction took place.
  • Date: The date of the transactions in this row.
  • PaymentType: The method used for payment (e.g., Cash, Card, Bank Transfer).

    If/Then Logic: The system displays the most detailed payment name available. For example, if a custom payment method like "Corporate Vouchers" is used, it will be displayed here instead of a generic name. Sometimes, you may see a prefix like "No fiscal - " which indicates the transaction was not processed through a fiscal printer.

  • Netto: The total value of sales for that day and payment type, before taxes (VAT) are added.
  • VAT: The total amount of Value Added Tax (tax) collected for those sales.
  • Brutto: The total gross value of sales (Netto + VAT). This is the final amount the customer paid.
  • Discount: The total value of all discounts applied to sales in this row.

    How it's calculated: This is the difference between the original price of the items and the final price paid. For example, if an item's regular price is $100 and it was sold for $80, the discount is $20.

  • BruttoWithDiscount: The total gross value of the items before any discounts were applied. This helps you see the original value of the goods sold.
  • Quantity: The total number of individual items sold.
  • KP: The total amount from special "KP" documents. These are typically internal fiscal documents used to register cash being paid into the cash drawer.
  • KW: The total amount from special "KW" documents. These are typically internal fiscal documents used to register cash being paid out of the cash drawer.
Payment Type Summary

This section provides a summary of all transactions from the report, grouped together by payment type. This is useful for seeing which payment methods are most popular over the entire selected period.

  • PaymentType: The method of payment (e.g., Cash, Card).
  • Netto: The grand total net amount for this payment type across the entire date range.
  • VAT: The grand total VAT amount for this payment type.
  • Brutto: The grand total gross amount for this payment type.
  • Discount: The grand total of all discounts applied for this payment type.
  • BruttoWithDiscount: The grand total gross amount before discounts for this payment type.
  • Quantity: The grand total number of items sold using this payment type.

Hints

  • Date Range Selection: Remember that the Date Until filter is exclusive. To report on a full day, you must set the Date Until to the following day.
  • Reconciling Cash: The KP and KW columns are primarily used for accounting purposes to track cash movements that are not related to product sales. They help explain discrepancies when reconciling the cash drawer.
  • Comprehensive View: For a complete audit of all transactions, set the Transaction Source and Transaction Status filters to 'All'. However, for standard daily sales reporting, the default settings ('Fiscal' and 'NotDeleted') are usually best.

Related articles