Skip to main content

Data: The Balance Adjustments report

How to Download & Understand the Balance Adjustments Report

Written by Faustina Mensah

The Balance Adjustments Report in Toggle tracks all changes to gift card balances over a selected time period. Whether a card has been redeemed, expired (breakage), reversed, sold, or topped up, this report keeps a detailed record.

You can download it as a CSV file and open it in Excel or similar programs to analyse the data.


How to download the Balance Adjustments report

  1. Log in to your Toggle account.

  2. Click Data in the sidebar.

  3. Select Balance Adjustments.

  4. Click the calendar icon and choose a date range (based on order creation date).

  5. Click Add to queue to generate the report.

  6. Once ready, hit the green download button to save the file.

What the report looks like

Once you open the CSV, each row represents a single balance adjustment. Use the Filter button in Excel to filter by adjustment type, card code, sales channel, or any other column.

Each row is one balance change. Filter by Line Item Type to see only redemptions, breakages, reversals, or sales.


Whatโ€™s in the Balance Adjustments Report?

This report tracks all balance changes on gift cards and experiences, including:

  • ๐Ÿ’ณ Redemption - When a customer uses their gift card to pay for something in your venue or online.

  • โŒ›Breakage โ€“ When a card expires and any remaining balance resets to ยฃ0. Also known as expiry breakage.

  • โ†ฉ๏ธReversal โ€“ When a balance change is undone.

  • ๐Ÿ›’Sale โ€“ When a card is purchased for the first time, or when an existing card balance is reloaded.


Key Data Fields Explained

๐Ÿชช Card & transaction identity

Card ID

Internal ID (not searchable on Toggle)

Line Item ID

A unique ID for each individual balance adjustment

Card Unique Code

The redemption code on the gift card โ€” useful for looking up a specific card quickly.

Transaction ID

The unique reference for the transaction that triggered the adjustment.

๐ŸŽ Product details

Product Name

The name of the gift card or experience that was sold or redeemed.

Experience Description

Shows sub-category details for Experience gift products

Unit

The venue or site where the card was sold, redeemed, or reversed.

โš ๏ธ Not seeing a location in the Unit column? This is usually because the site references haven't been fully configured on your EPOS system. Check with your EPOS provider to make sure each location has been set up with the correct site reference linked to Toggle and that's what allows the system to record where each redemption took place.

โš–๏ธ Adjustment details

Line Item Type

Indicates if the transaction was a sale, redemption, reversal, or breakage.

Value

The amount sold, redeemed, expired, or reversed in this adjustment.

Adjustment Date

The date and time the balance change occurred.

Discount Value

Any discount applied to this transaction.

Total Value

The overall order value associated with this adjustment.

Postage Price

The shipping cost, if a physical product was posted to the customer.

๐Ÿช Channel & fulfilment

Merchant

The payment provider or EPOS system where the sale or redemption occurred (e.g. Stripe, Zonal).

Sales Channel

How the gift card was sold: webshop, in-venue, or issued manually via the dashboard.

Fulfilment Method

How the card or product was delivered; digital email or physical post.

๐Ÿ‘ค Purchaser, recipient & notes

Purchaser Name

The name of the person who bought the gift card. Populated for webshop purchases only.

Purchaser Email

The buyer's email address.

Recipient Email

The email address the gift card was sent to, if registered.

User

The Toggle user who manually issued or redeemed the gift card, where applicable.

Notes

Any notes left at the time the card was manually issued or redeemed.


How Can You Use This Report?

  1. ๐Ÿ“Š Track Balance Changes โ€“ Monitor all adjustments made to gift card balances, including manual additions, refunds, and corrections.

  2. ๐Ÿงพ Reconcile Refunds & Returns โ€“ Verify that refunds or returns made to gift cards are accurately recorded.

  3. ๐Ÿ”Ž Audit Manual Adjustments โ€“ Check manual balance changes and ensure the integrity of your gift card system.

  4. ๐Ÿ”— Monitor Integrations โ€“ Cross-reference adjustments made by third-party systems with internal records.

  5. ๐Ÿ•ต๏ธ Investigate Discrepancies โ€“ Identify and trace any balance discrepancies back to specific adjustments.

  6. ๐Ÿ“ˆ Performance Analysis โ€“ Assess the frequency and types of adjustments to improve gift card management.


Other guides:


Any help or questions please get in touch on success@usetoggle.com

Did this answer your question?