Your outstanding active balance sits on the overview dashboard. Hover over any point on the chart to see the figure for that day.
You'll find your total outstanding balance on the overview dashboard. Your bookkeepers might know it better as your total gift card liability.
What this number means
This is the total value of gift cards currently out in the wild, the ones your customers could still redeem today.
It includes every credit ever added to a card and excludes everything that's already been redeemed. Think of it like a bank balance: all the money in, minus all the money out.
đ§ Hover over the chart on the overview dashboard to see what the outstanding balance was on any day in the past.
The figure is calculated and cached once a day, so it's accurate up to midnight yesterday. Today's activity won't show until tomorrow.
How to calculate this number yourself
If you would like to see a breakdown of how this number is calculated, you can do this yourself in a spreadsheet program such as Excel.
1 - Download the balance adjustments on your account from the data section of your dashboard. Select the date range of the full lifetime of your account with Toggle up until yesterday, as this number is calculated across the full lifetime of your account.
2 - Toggle splits very large exports into multiple CSV files, so you may need to manually import them one at a time in Excel to join them back together.
3 - This CSV shows every adjustment for every card, including reversals, credits, debits, expiry etc. Take a look at the data in Excel and you'll see a column for value.
4 - Sum the value column. The total of this column will match the total Outstanding Active Balance number on your overview dashboard screen.
Why does the outstanding balance not match the total sales number on the overview dashboard?
The outstanding balance accounts for redemptions, breakages and reversals as well as sales. Total sales only reflects money coming in, so the two numbers are answering different questions.
Figure | Includes sales | Includes redemptions | Includes breakage & reversals |
Outstanding active balance | Yes | Yes | Yes |
Total sales | Yes | No | No |
â ď¸ If your outstanding balance looks lower than expected, check for recent breakage or reversals before assuming something's wrong. Both reduce the balance without appearing in your sales figures.