The Balance Adjustments export is downloadable on your Toggle dashboard as a CSV file. You can open the export 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 export.


Here's the steps to find and download the Cards export:

  1. Log in to your Toggle account

  2. Click on Data found on the sidebar

  3. Click on Balance Adjustments

  4. Click the blue calendar icon and select the date range to pull the data from*

  5. Click Add to queue

  6. 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 export?

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 are on the Balance Adjustments export 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

Total Associated Transaction Value

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!)

Toggle exports explained


If you require any help with the Balance Adjustments export please get in touch with our support team at success@usetoggle.com.

Did this answer your question?