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:

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

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?