Skip to main content

Voucher Balance Report

Written by Marie London

We're excited to bring you an expanded reporting experience. If you don't see the reporting features described below, don't worry—this updated reporting experience will become available to your account over time.

Overview

The Voucher Balance report helps you see all unredeemed vouchers as of a specific date, along with the outstanding liability value they represent. It gives you a live snapshot of active vouchers by client, location, and originating service, so you can see exactly what deferred revenue is still on the books.

Use this report to calculate your total outstanding voucher liability, review which clients still hold unredeemed vouchers, and support accounting reconciliation against deferred revenue records. It's especially useful for staying on top of liability by location and service category, so your records stay accurate and nothing falls through the cracks as vouchers age toward expiration.

Note: This report only shows active, unredeemed vouchers as of the selected date — vouchers that have been redeemed, expired, or voided won't appear, and Purchase Location reflects where the voucher was sold, not where it's redeemed. See the Report Caveats section below for how Outstanding Voucher Value is calculated.

What this report is best used for

Understand when and why to use this report through common use cases, descriptions, and example questions it can help answer in your day-to-day operations.

Use cases

Description

Example questions this report helps answer

Outstanding Voucher Liability Tracking

Identify all active vouchers with remaining balances to calculate the total outstanding liability that represents unredeemed value.

  • What is our total outstanding voucher balance this month?

  • How much liability does each location hold in unredeemed vouchers?

Client-Level Voucher Balance Review

Review clients who currently have vouchers with unredeemed value to support customer inquiries or redemption follow-ups.

  • Which clients still have active vouchers?

  • What is the remaining balance for each client?

Accounting and Reconciliation Support

Provide accounting teams with visibility into active vouchers that represent deferred revenue for reconciliation and reporting purposes.

  • How does the outstanding voucher liability compare to our deferred revenue entries?

  • Are there any expired vouchers still showing as active?

Prerequisites

Before using this report, make sure the following are in place. These directly impact whether you can access the report and how accurate the data will be.

  1. Permissions: You must have the appropriate Data & Reporting permissions enabled to see this report: Client Reporting > Client Redemptions & Balance

    • If you don’t see the report, check your permissions first - see Reporting Permissions for more information.

  2. Location and Access Scope: What you see in the report depends on your access:

    • You’ll only see data for assigned locations

    • Row-level access may further limit visible data

    • If it looks like data is missing, verify your location assignments and access settings.

  3. Required Setup: For the report to show meaningful data, vouchers must have been generated from a membership or package purchase.

Default report configuration

See how the report is structured when first opened. Learn what each field represents, how the data is organized, and which fields can be used to filter results.

Group By (default)

The default fields the report is grouped by when you first open it.

Field name

Definition

Example

Filter?

Purchase Location

Location where the voucher was purchased.

OH Cincinnati | Rookwood 168

Yes

Client ID (hidden in table, shown in exports)

Unique ID of the client who purchased the voucher.

bdf86a8b-f7c9-4204-9128-e64d160017ac

No

Client Name

Name of the client who purchased the voucher.

Sydney Kessler

Yes

Columns (default)

The default columns displayed when you first open the report.

Field name

Definition

Example

Filter?

Outstanding Voucher Value

The total deferred revenue value of active vouchers remaining unredeemed as of the selected date. Each voucher’s value is derived from the purchase value (typically package or membership price divided by included vouchers)

$174.00

No

Voucher Count

The number of active, unredeemed vouchers included in the current grouping as of the selected date.

2

No

Customizable fields

Explore the fields you can adjust to tailor the report to your needs. Each field includes a definition, example, and whether it can be used in filtering.

Field name

Definition

Example

Filter?

Purchase Location

Location where the voucher was purchased.

OH Cincinnati | Rookwood 168

Yes

Client ID

Unique Id of the client who purchased the voucher.

bdf86a8b-f7c9-4204-9128-e64d160017ac

No

Client name

Name of the client who purchased the voucher.

Sydney Kessler

Yes

Outstanding Voucher value

The total deferred revenue value of active vouchers remaining unredeemed as of the selected date. Each voucher’s value is derived from the purchase value (typically package or membership price divided by included vouchers)

$174.00

No

Voucher count

The number of active, unredeemed vouchers included in the current grouping as of the selected date.

2

No

As of Date

The calendar date applied as a filter. All Voucher balances and metrics reflect their values as of the selected date.

2026-May-18

Yes

Primary location ID

The unique identifier of the primary location associated with the client.

d3043741-aaad-4085-8d67-7cc39f662452

No

Primary location name

The name of the primary location associated with the client

CO Denver | South Denver 029

Yes

Voucher ID

Unique identifier for the voucher.

43e56b97-0179-4cd1-ac87-ccc8170e9fca

Yes

Sold date

Date the voucher was issued.

2026-04-01 6:12:44

No

Voucher source

Source that generated the voucher.Possible values include: membership package promotion.

Membership

Yes

Order ID

Unique identifier for the order associated with the voucher purchase, if applicable.

964b8d9a-60f5-4166-bd85-48d18d3917a2

No

Order Number

Human-readable order number associated with the voucher purchase, if applicable.

3663017

No

Item Name

Name of the membership or package tied to the voucher.

Brazilian (V) Sugar Membership

Yes

Item Category

Category of the membership or package associated with the voucher.

Memberships

Yes

Service name

Name of the service linked to or redeemed by the voucher.

Brazilian (V) Wax Membership

Yes

Service category

Category of the service linked to or redeemed by the voucher.

Brazilian Area

Yes

Average Service list price

The standard price of the service associated with the voucher before discounts or adjustments.

$194.00

No

Voucher price adjustment

The difference between the service list price and the voucher’s value. This may be positive or negative and represents how the voucher adjusts the transaction.

5

No

Voucher expiration date

The calendar date when voucher was expired.

2026-Dec-31

Yes

Report Caveats

There are a few important caveats and limitations to be aware of when using this report. Use these details to better understand how the data behaves and how to interpret it correctly.

Caveats

Details and Impact

This report shows only active, unredeemed vouchers as of the selected date — resolved vouchers do not appear

The Voucher Balance report is a live snapshot of vouchers that are currently unredeemed as of the As of Date filter. Vouchers that have been fully redeemed, expired, or voided will not appear. Changing the As of Date shows what the outstanding balance looked like on that day — but only for vouchers that were active at that time. If a voucher was redeemed after the selected date, it will appear in historical snapshots but not in today's view.

Outstanding Voucher Value is derived from the membership or package sale price — not the service list price

Each voucher's value is calculated by dividing the original membership or package sale price across the voucher groups and individual vouchers included in that plan. For example, a $350 membership with two voucher groups of 4 and 5 vouchers produces values of $43.75 and $35.00 per voucher respectively. This value does not reflect the list price of the service the voucher can be used on. The Average Service List Price field is available separately for reference.

Purchase Location reflects where the voucher was granted — not where it was or will be redeemed

The Purchase Location field shows the location where the originating membership or package was sold. This is the location that holds the liability for the unredeemed voucher. When a client redeems the voucher at a different location, that redemption location is not visible in this report. Use the Voucher Activity report if you need to see both the purchase and redemption location for individual voucher events.

Use Case Example Configurations

Learn how to set up the report for specific scenarios with practical examples. Follow along to create views that answer common questions and support your workflows.

Use case

Description

How to configure the report

Outstanding Voucher Liability Tracking

Identify all active vouchers with remaining balances to calculate the total outstanding liability that represents unredeemed value.

  • Filters: As of Date = today (default); filter by Purchase Location to scope to a specific location; sort by Outstanding Voucher Value descending to surface highest liability first.

Client-Level Voucher Balance Review

Review clients who currently have vouchers with unredeemed value to support customer inquiries or redemption follow-ups.

  • Filters: As of Date = today; filter by Client Name to look up a specific client; add Order Number to Columns to cross-reference the originating order.

Accounting and Reconciliation Support

Provide accounting teams with visibility into active vouchers that represent deferred revenue for reconciliation and reporting purposes.

  • Group by: Purchase Location, Item Name.

  • Columns: Outstanding Voucher Value, Voucher Count, Average Service List Price.

  • Filters: As of Date = the reconciliation date you want to match; filter by Voucher Source to separate membership vs package liability; filter by Voucher Expiration Date to surface expiring vouchers.

Did this answer your question?