Skip to main content

Understanding the Adjustments report

Track gift card activations, redemptions, top-ups, expiries, and calculate total liability at any point in time.

Robbie Morris avatar
Written by Robbie Morris
Updated today

The Wrapped Adjustments report displays gift card adjustments (e.g., activation, redemption, expiry, top-up) that occurred within the selected date range.

To locate the Adjustments report, navigate to Reports > Adjustments from the Wrapped dashboard, as shown below.

The Adjustments report includes a summary report containing the following fields:

  • sales_channel – The name of the sales channel where the gift card adjustment occurred (e.g., Wrapped WebStore, Lightspeed Retail X-Series, Shopify).

  • sales_channel_id – The unique identifier assigned to the sales channel, used for internal tracking and reporting purposes.

  • site_name – The specific store or website location associated with the adjustment, helpful for multi-location reporting.

  • num_activated – The total number of gift cards that were activated during the selected date range.

  • adjustments_total – The total monetary value of all gift card adjustments (activation, redemption, top-up, expiry, etc.) within the selected period.

  • activation – The total value of gift cards activated during the reporting period.

  • redemption – The total value of gift cards that were redeemed during the selected date range.

  • topup – The total value added to existing gift cards during the reporting period.

  • other_adjustment – Any adjustments that do not fall into activation, redemption, top-up, or expiry categories (e.g., manual corrections, refunds).

  • expired – The total value of gift cards that reached their expiry date during the selected period.

Tip: To view total liability at a specific point in time, leave the start date filter blank and use the adjustments_total value. This will capture the total liability from the date your gift card program commenced with Wrapped.

For more detailed insights, the adjustment report below the summary allows you to view each gift card’s adjustment type, along with any associated notes and customer details.

How to calculate a point-in-time liability

  1. Leave the Start Date filter blank and set the End Date filter to the date immediately following the desired point in time.

For example, to obtain the liability as of July 31st, 2025, set the End Date filter to be August 1st, 2025, as shown below.

2. In the Adjustments summary report read the value in the adjustments_total column, as shown.

In this example, $91,722.46 represents the total liability for all gift cards as at July 31st, 2025.

Did this answer your question?