The Balance Adjustments report is downloadable on your Toggle dashboard as a CSV file. You can open the report into a spreadsheet program such as Excel to view and edit the raw data.
Read on to find out more.
Where to find and download the Balance Adjustments report.
Here's the steps to find and download the Balance Adjustments report:
Log in to your Toggle account
Click on Data found on the sidebar
Click on Balance Adjustments
Click the blue calendar icon and select the date range to pull the data from*
Click Add to queue
Click the green download button when the export has completed its download
* This is based on the order creation date e.g. if you select January 1st 2022 - January 31st 2022 the data on the export will contain only the gift cards and products that were ordered within that date range.
What's on the Balance Adjustments report?
The Balance Adjustments report focuses on the historic adjustments of every gift card's balances over the period of time you choose for download, whether it's been redeemed, had breakage (expired and therefore reduced to £0), been reversed, or sold or topped up.
For example, if you pick your date range of January-March 2022 you'll see how any gift card during that time period has has its balance adjusted.
What headers are on the Balance Adjustments report and what do they mean?
Card ID | This is an internal ID and not searchable on the Toggle dashboard. |
Line Item ID | An internal unique ID for this "line item" which helps associate the main order. |
Product Name | The name of the product purchased. |
Experience Description | If the product purchased was an Experience gift and it had sub-categories, the sub-category will show here. |
Unit | The name of the site the product was redeemed, sold, or reversed in. |
Card Unique Code | The unique code used to redeem the gift card's balance. |
Line Item Type | Either redemption, sale, reversal, or breakage |
Value | The sale value of the gift card that was sold or redeemed, or that has expired (breakage) or been reversed. Or the sale value of a non-gift card product. |
Adjustment Date | The date the gift card or product had the sale, redemption, reversal, or breakage. |
Merchant | The name of the merchant that the sale or redemption was from. |
Order ID | A unique ID for the order that can be used to search on the 'Order ID' filter on the Purchases page on the dashboard. |
Sales Channel | The channel the gift card or product was sold from e.g. this could be one of your sites, on the Toggle dashboard (if issuing something free of charge), or via the webshop. |
Fulfilment Method | How the gift card or product was sent out e.g. via email or post |
Notes | These are notes left by the Toggle user issuing a free of charge gift card or manually redeeming a gift card on the Toggle dashboard. These notes are optional to make. |
User | The name of the user who issued a free of charge or manually redeemed a gift card. |
Transaction ID | This is an internal ID and not searchable on the Toggle dashboard. |
Merchant Transaction Reference | If a gift card or product was purchased on your webshop then the transaction reference is pulled through from your payment gateway connected to your Toggle account - you can use this to search the order on that payment gateway platform. |
Line Item Discounts | This is the discount applied for each order. |
Total Associated Transaction Value | This is the total value of the order e.g. if two £10 gift cards are purchased in an order this will be £20 |
Postage Price | If the physical gift card or product was sent by post then the postage charge applied at the webshop checkout shows here. |
Transaction Discount Value | If any discounts associated with this adjustment, they would show here. |
Reverse Line Item ID | If this adjustment reverses another balance adjustment line, the line item it has changed will show here. |
Reverse by Line Item ID | If this adjustment has been subsequently reversed by another line item, that will show here. |
Purchaser First Name | The first name of the purchaser - this will only show if the gift card or product was purchased on the webshop as this information is required to make the purchase. |
Purchaser Last Name | The last name of the purchaser - this will only show if the gift card or product was purchased on the webshop as this information is required to make the purchase. |
Purchaser Email | The email address of the purchaser - this will only show if the gift card or product was purchased on the webshop as this information is required to make the purchase. |
Recipient Email | If the recipient registers their gift card their email will be stored here. |
💡Tip: You can find cards that have had a breakage transaction applied to them over a date range by downloading the Balance Adjustments export and filtering down to a "Line Item Type" of "Breakage".
Similar support guides:
The Introduction to reporting and exports in Toggle (a video tutorial!)