The Gift Card Pool Report contains information regarding gift card activity within the pool and at specific locations. A locations pool report will show the net amount to transfer into or out of the pool based on the locations liability.
For more information, please see our Gift Card Pooling Concepts documentation
- A positive net transfer amount indicates that the pool account owes the restaurant location, usually in cases where the restaurant location has experienced higher redemptions of gift cards than sales of gift cards.
- A negative net transfer amount indicates that the restaurant owes the pool account, usually in cases where the restaurant has seen higher sales of gift cards than redemptions of gift cards.
- Under the “Analytics” tab, select “Gift Card Pool Report”.
- If you have more than one Merchant, select the one whose Gift Cards you’d like to view.
- Select the locations you’d like to view. For a full report, keep “All Stores” selected.
- Select the date range (Start date and End date) you’d like to view a report for. It’s up to you how often you’d like to do these transfers; often, they are done monthly.
- Click “Apply to report” to generate your summary.
- Next to each part of the summary, you will be able to “Download Detail” to view a full list of Gift Card transactions. (Of course, there will be more than a $0 if your customers are actively using Gift Cards).
The columns on this spreadsheet are:
- Date of Transaction (At Location) – The date that the gift card transaction occurred on the location’s POS
- Card Number
- Merchant
- Location - the location where the activity occurred
-
Type of Gift Card – could be a physical “in-store” gift card or the digital gift card through the app or admin portal comp, which is actions taken via the portal by an admin.
- Purchase - Initial purchase of a gift card
- Reverse Purchase - Removal of a gift card purchase
- Purchase Email e-card - Initial purchase of a Gift Card to be sent via email
- Reverse Purchase Email e-card - Removal of a Gift Card to be sent via email
- Add Value - Add additional value to an existing card
- Redeem - A purchase made using a gift card
- Amount – This is the amount of the transaction on the gift card. For example, if the card is loaded with $50, this column will read as “$50”. If someone spent $10 of the gift card, this column would read “-$10”.
- Transfer Amount – This is the amount of money that should be transferred into or out of the Pool Account as a result of the transaction. It will be the same numerical amount as the “Amount” column, but opposite in terms of whether the money is added or subtracted. For a gift card loaded with $50, this column will read “-$50”, because $50 is now owed from the location account to the Pool account. If someone spent $10 of the gift card, this column will read “$10” because the Pool account now owes the location account $10.