Gift Card Report

The Gift Card Report provides detailed information on gift cards issued by the system. These gift cards are used when purchasing products in the Reservation System.

While the output generated in this report is identical to that of the report generated in Financial - Gift Card Management, this report is used only for reporting purposes while the report in the Gift Card Management module is also used for performing specific gift card actions (e.g. printing, activating a voided gift card).

Also, the Gift Card Management report can display only up to 1,000 gift cards while the Gift Card report can display an unlimited number of gift cards.

Output

This report has the following layouts:

CSV
DOCX
PDF
Text
XLSX

In addition, there is a Print option.

How to generate a report - see Reports.

Filters

The report has the following parameters which are shown on the left and enable you to filter the report output (Note that all parameters (except Card code and user-defined code) are mandatory for generating the report):

Parameter	Description
Purchased with Receipt	Choose whether receipt was issued for the gift card.
Issue Date	Choose the date range in which the gift card was issued.
Original Issue Date	Choose the date range in which the gift card was originally issued.
Expiration Date	Choose the date range in which the gift card expires.
Used Date	Choose the date range in which the gift card was redeemed.
Status	Choose the gift card status from the drop-down.
Value	Choose the amount or percent range of the gift card value.
Currency	Choose the gift card currency from the drop-down list.
User-defined Code	Choose part (first characters) or all of the user-defined code.
Type	Choose the type of gift card: Gift Card or Promo Code.

Example

The generated report displays the gift cards matching the parameters defined in the filter. Each row in the table represents a gift card.

The following fields are displayed in the generated report:

Field	Description
Curr.	This field shows the gift card currency. The total of each currency is displayed at the end of each currency group. If the definition selected is All, these totals will not include gift cards issued with a percentage.
Card Code	This field shows the system-generated card code. Only the last 4 digits of the code are displayed.
Issue Date	This field shows the date on which the gift card was issued.
Receipt	This field shows the number of the receipt issued for the gift card purchase (if receipt was issued in purchase process).
User defined code	This field shows the entire user-defined gift card code.
Original Issue Amount	This field shows the original value of the gift card when it was issued.
Status	This field shows the current gift card status.
Used Date	This field shows the date when the gift card was used. This column does not appear in Summary mode.
Used Amount	This field shows the amount of the gift card which was used. In Detailed mode, if the gift card was used multiple times, each amount used is displayed in a separate row. In Summary mode, this column displays the total amount used.
Left Amount	In Detailed mode, the field shows the remaining amount left on the gift card for each gift card and after each time it is used. An additional row is added each time the card is used, allowing you to track the gift card history. In Summary amount, this column displays the current amount left on the gift card - in a single row.
Expiration	This field shows the expiration date of the gift card.
From	This field shows the name displayed in the From field of the gift card.
T. File	This field shows the number of the travel file paid for with the gift card.
TRC	This field shows number of the receipt issued for the gift card payment.
Customer	This field shows the name of the first passenger in the travel file paid for with the gift card.
Total active	This field shows the total number of active gift cards.
Total used	This field shows the total number of gift cards used.