The Reconciliation Report provides a summary of gift card load and redemption activity by location for a selected month. Use it to reconcile monthly gift card performance, compare loaded versus redeemed amounts, and support accounting and financial reporting.
Filters
Filter | Description |
Month | Select the month to report on. |
Card Category | Filter by Generic or Converted cards. Defaults to all card categories. |
Location | Filter by one or more locations. Defaults to all locations. |
Click Apply filters to load results after making your selections.
Columns
Column | Description |
Location ID | The unique ID of the location. |
Location Name | The name of the location. |
Total Amount Loaded | The total dollar amount loaded onto cards at the location during the selected month. |
Total Amount Redeemed | The total dollar amount redeemed from cards at the location during the selected month. |
Net Amount | The total amount loaded minus the total amount redeemed. Positive values indicate more was loaded than redeemed; negative values indicate more was redeemed than loaded. |
A Totals row at the bottom of the table shows the combined values across all locations in the filtered results.
Common Use Cases
Monthly reconciliation Run the report for a given month to compare total loaded versus redeemed amounts across locations. Useful for month-end close and financial reporting.
Comparing loaded versus redeemed amounts Use the Total Amount Loaded and Total Amount Redeemed columns to see whether a location is generating more gift card liability than it's working down. A consistently positive Net Amount signals growing outstanding liability; a negative Net Amount means customers are redeeming faster than cards are being sold.
Location-level performance review Filter by a specific location to evaluate monthly gift card performance at that store, or run across all locations to compare.
Supporting accounting and financial reporting Export the monthly totals to CSV for use in month-end close, journal entries, or liability reporting. Pair with the Liability Detail Report for a complete view of outstanding balances alongside monthly activity.
Notes
Totals reflect all selected card categories before any holdbacks or fees.
This report may not match your monthly settlement transfer, which can differ based on card category exclusions, holdback percentages, and other adjustments applied to your account.
Positive Net Amount values indicate more value was loaded than redeemed at a location. Negative values indicate more was redeemed than loaded.
Card category filters allow you to isolate generic or converted card activity
Data is grouped by location for the selected month