The following content was translated using AI and reviewed by our team. Please note that some images are still being updated.

Usage

The cut-off date report displays all sold items and categorizes them as redeemed or unredeemed. This makes the total value of unredeemed items immediately visible. Additionally, the sales and redemption periods can be filtered independently. More details can be found in the full explanation.

• Recommended use: The cut-off date report is ideal for year-end closing and for quickly identifying outstanding vouchers/tickets.
• Not recommended for: Ongoing control of cash registers or users (use the journal instead), year-over-year comparisons (use the annual statistics), or billing with external partners (use the partner settlement feature). The cut-off date report always uses gross values (taxes—if maintained in the system—are displayed in the journal).

Automatically filtered view. Statistics are automatically filtered based on user permissions. Depending on system setup, your user account may only be able to view your own sales or redemptions. However, at least one system admin can always access all system data.

Settings overview

1. Default period: When opened, the report displays all vouchers sold since system launch and their redemptions up to the current date. If legacy vouchers were imported, they are included as well, starting with the first imported sale.
2. Sales period: The report can be restricted to items sold within a specific date range. Sales and their redemptions outside this range are excluded.
3. Redemption period: This can be defined independently of the sales period. The basis remains the sales in the selected sales period, but only redemptions within the selected redemption period are shown. Redemptions outside of it are listed under “of which unredeemed”.
4. Export: The view can be exported as a PDF or Excel file. In Excel format, individual voucher codes are also visible (depending on data volume).
5. Filters: Various filters are available, covering many special use cases.

Item display overview

1. Sales: These are the items sold during the selected period (includes imported vouchers if their sale date is within the selected range). This column serves as the basis for the analysis.
2. Redeemed: Displays the value of items from column 1 that were redeemed during the selected redemption period.
3. Unredeemed: Shows the difference between "sold" and "redeemed". Important: "Unredeemed" does not necessarily mean "still open". Items may have been redeemed outside the selected redemption period.
4. Special cases: The unredeemed column also includes items that are not meant to be redeemed (e.g., physical products). These are also listed as "unredeemed".
5. Total of unredeemed values: Should not be interpreted as the total of still redeemable items. To determine redeemable items, follow the detailed guide.

Cancellations

Unredeemed vouchers can be canceled. Canceled vouchers never appear in the "redeemed" column, but always in the "unredeemed" column.

Cancellations are recorded in the statistics as correction entries with a negative sales value at the time the cancellation occurred. You can define how cancellations should be considered in the filter settings of the report.

• "Incl. Sales & Cancellation Entries": Default setting. All entries (sales and cancellations) within the selected sales period are included. A sale and its cancellation cancel each other out if both occur within the selected period.
• "Excl. Cancellation Entries": All cancellation entries are excluded, so that only actual sales are shown without subtracting cancellations.
• "Excl. Canceled Sales & Cancellation Entries": All cancellation entries and all sales entries of canceled vouchers are excluded. Only vouchers that were not canceled at any time (within or outside the selected period) remain.
  Note: This value may vary depending on the report’s generation time, as new cancellations can retroactively affect the data.

Product types

Without filtering, all sold items are included. This means non-redeemable items (e.g., physical products) are also listed if they were sold during the selected sales period. The typical goal of this report is to show unredeemed items that can still be redeemed. To exclude non-redeemable types, select "All Vouchers" under the "Item type" filter.