The Balance Adjustments CSV file can be found on the Data section on your Toggle account.
This file contains information on the adjustments to a gift card - e.g. whether it's been redeemed, had breakage, been reversed, or sold.
Your accounts team might find this report particularly useful, as this represents each transaction that took place in a given date range.
What headers/ info are on the Balance Adjustments CSV file?
Line Item ID
Toggle Card Unique Number
Line Item Type
Adjustment Date (UTC format)
Merchant Transaction Reference
Total Associated Transaction Value
Transaction Discount Value
Reverse Line Item ID
Reverse by Line Item ID
What does each header mean?
Card ID: An internal unique ID for this card and a way to search out a card on your Toggle account
Line Item ID: An internal unique ID for this "line item" which helps associate
Gift Name: The name of the gift
Experience Description: Any description of an experience gift that was bought
Unit: The site this balance adjustment took place in.
Toggle Card Unique Number: The 19 digit unique number used to redeem the gift card
Line Item Type: e.g. Sale, Redemption, Breakage etc
Value: The value of the balance adjustment. Negative adjustment types (e.g. redemptions show as negative values)
Adjustment Date: The date and time of the adjustment.
Merchant: Who created the adjustment e.g. Stripe, Trust Payments or your EPOS.
Order ID: If this adjustment relates back to an order, the order ID would be shown here.
Sales Channel: The type of sales channel associated with this adjustment e.g. B2B, Web shop
Fulfilment Method: If this adjustment relates to a fulfilment, the type of fulfilment would be shown here.
Notes: If any manually added notes for this adjustment, they would show here
User: If tracked, the user who made this adjustment
Transaction ID: If this adjustment relates to money that has exchanged hands (e.g. sale of a card) the transaction relating to this adjustment would show here.
Merchant Transaction Value: If this adjustment relates to money that has exchanged hands (e.g. sale of a card) the transaction value would show here.
Postage Price: If any postage relates to this adjustment, it would show here
Transaction Discount Value: If any discounts associated with this adjustment, tthey would show here
Reverse Line Item ID: If this adjustment reverses another balance adjustment line, the line item it has changed will show here.
Reversed by Line: If this adjustment has been subsequently reversed by another line item, that will show here.