Gift Certificate Usage Report

The Gift Certificate Usage Report provides a clear and concise overview of all gift certificate activity. It tracks their issuance, how they're used, and their current balances, helping you effectively monitor gift certificate programs and manage customer redemptions.

Navigation

Report Structure

This report is organized on a single tab, with each row representing a unique gift certificate and its associated activity details.

Columns

The report includes the following columns:

• Code: The unique identifier for each gift certificate.

• Original Balance: The initial value of the gift certificate when it was issued.

• Remaining Balance: The current balance available on the gift certificate.

• Expiration: The date on which the gift certificate expires (if applicable).

• Activity Description: A brief explanation of the activity (e.g., issuance, redemption, adjustment).

• Activity Date: The date when the activity associated with the gift certificate occurred.

• Activity Amount: The monetary value of the specific activity (e.g., the amount redeemed or adjusted).

Purpose and Usage

This report is a vital tool for managing your gift certificate programs:

• Track Usage: Monitor how gift certificates are being used, their remaining balances, and identify any certificates nearing their expiration date.

• Customer Service & Reconciliation: The Activity Description and Activity Amount columns provide detailed insights into when and how certificates are used, aiding both customer service inquiries and financial reconciliation efforts.

Running the Report

To run the report, you'll enter the time period for the report into the "From" and "To" fields (format MM/DD/YYYY) then click the "Generate Report" button.

Report Pickup

Upon running the report you may encounter the following message about navigating to the report pickup area to download the completed report:

Open

Downloading the Report from Report Pickup

Open

View of the Downloaded Report

The spreadsheet will contain the details regarding the purchase and usage of the generated gift certificates in your ULtraCart account:

Open