Stored Value Balance Summary Report

Bryan

Stored Value Summary – Report Guide

Stored Value Summary

Report Guide for Users

What this report shows, how to run it, and how to read the results.

What this report is for

The Stored Value Summary report tracks the prepaid value your guests hold on their accounts — money that has been loaded onto guest accounts (like a house gift card or account wallet) and can be spent later. It shows how much stored value was sold, how much was used, and how much is still sitting on accounts.

That last figure — the outstanding balance — matters because it’s money you owe your guests: value they’ve paid for but haven’t spent yet. This report is the go-to place to see that liability and the activity behind it.

Stored value in one line: money loaded onto a guest account now, to be spent later. Sold = value added; Used = value spent; Outstanding = value still on accounts.

How to run the report

Set the date range and choose how you want to view the information.

Setting	What it does
Start Date / End Date	The period you want to look at.
View By	Chooses which view you see: Summary, Details, Usage, or Sales (explained below).

The four views

The “View By” choice changes what the report shows:

View	What it shows
Summary	The big-picture roll-up — stored value sold, used, and comped/discounted, plus the total outstanding balance for the period.
Details	The individual transactions and guest-account balances behind the summary.
Usage	Where stored value was spent — the redemptions, item by item.
Sales	Where stored value was sold / loaded — the money added to accounts.

Key figures you’ll see

Figure	What it means
Stored Value Sold	Value loaded onto guest accounts during the period.
Stored Value Used	Value guests spent from their accounts during the period.
Stored Value Comp/Discount	Value added as a comp or discount rather than paid for.
Total Outstanding Balances	The total value still sitting on guest accounts — the money you owe guests.
Computed Balance vs Actual Balance	A reconciliation check. Computed is what the activity says the balance should be; Actual is what the system currently shows. They should match.
Account Value / Allocated Value / Total Value	The value held on a guest account — overall, the portion set aside for a specific purpose, and the combined total.

In the detailed views, each row also shows guest and transaction information such as Guest Name, Guest Account Name, Payment Date/Time, Payment Type, Product Name, Payment Amount, and the Transaction and Order IDs. Amounts are shown as currency, and negative numbers appear in parentheses, for example ($50.00).

How to use it, step by step

Set your Start Date and End Date.
Start with the Summary view for the overall picture: sold, used, and outstanding.
Switch to Sales to see what was loaded, or Usage to see what was spent.
Use Details to trace a specific guest account or transaction.
Check that Computed Balance and Actual Balance agree — a difference is worth investigating.

Good to know

Outstanding stored value is a liability — it’s money guests have paid that they can still spend, so it’s important for accurate books.
If Computed and Actual balances don’t match, use the Details view to find where the difference comes from.
The outstanding balance is shown as of the End Date, so changing the date range changes the balance you see.
Comped or discounted stored value is tracked separately from value guests paid for, so you can tell the two apart.

Quick read: Summary for the totals, Sales and Usage for the activity, Details to trace a specific account. Outstanding balance is what you still owe guests.