Outstanding Earnings Report
The Outstanding Earnings report helps you understand how your loyalty balance changes over time. Depending on your program setup, this may represent points, store credit, or another loyalty balance type.
Use this report to review balance earned, spent, revoked, expired, refunded, and the net outstanding total for a selected date range. You can also export the data as a CSV when you need to share a detailed record with your finance or accounting team.
Where to find the report
From your Rivo dashboard, go to Analytics.
Open Loyalty.
Find the Outstanding Earnings Balance card.
Click through to view Rivo Outstanding Earnings Over Time.
The report opens with a breakdown chart and a detailed table for the selected date range.
How the report works
Outstanding Earnings measures loyalty balance movement during the selected date range. The report separates balance changes into five activity types:
Earned - Balance added to customers.
Spent - Balance customers used toward rewards or redemptions. This usually appears as a negative number because it reduces the outstanding balance.
Revoked - Balance removed from customers, such as from reversals or adjustments. This usually appears as a negative number.
Expired - Balance removed because it expired. This usually appears as a negative number.
Refunded - Balance returned to customers after a prior removal. This usually appears as a positive number.
The report total is the sum of those activity types:
Earned + Spent + Revoked + Expired + Refunded = Total
When you use Cumulative Balance, the report shows a running balance that includes prior balance before the selected start date.
Filters available
Date range
Use the date picker to choose the reporting period. The report includes activity from the start of the first selected day through the end of the last selected day, based on your store’s timezone.
Time grouping
Use the time grouping dropdown to choose how the on-screen rows and date-based CSV export are grouped:
Daily
Weekly
Monthly
For short reporting periods, daily grouping is usually easiest to audit. For longer periods, weekly or monthly grouping can make trends easier to read.
VIP tier
Use the VIP tier filter to view all customers or narrow the report to customers in a specific VIP tier.
This is useful when you want to compare balance liability across tiers, such as customers in your highest tier versus all other members.
Loyalty status
Use the loyalty status filter to view:
All Loyalty Statuses
Guests
Members
This helps separate activity for customers who have joined your loyalty program from guest customer activity.
View mode
The report has two view modes:
Net Activity - Shows the balance movement within each row’s time period. Use this when you want to see what changed during the selected date range.
Cumulative Balance - Shows a running balance over time. Use this when you want to see the outstanding balance as of each row in the report.
Earnings status
The report can use either:
All Earnings - Includes activity based on when the activity happened.
Approved Only - Limits results to activity with an approval date in the selected range.
Use Approved Only when your reporting process should only include approved activity. Use All Earnings when you want the broader operational view of all balance movement in the selected range.
Reading the table
The on-screen table shows one row per selected time period. For example, if you choose monthly grouping, each row represents a month.
In Net Activity view, the table columns are:
Day
Earned
Spent
Revoked
Expired
Refunded
Total Outstanding
In Cumulative Balance view, the activity columns are labeled as cumulative values, and the final column is Outstanding Balance.
Exporting the report
Click Export to open the export modal. Rivo emails the CSV export to you after processing.
Export by date
Choose Date when you want the CSV grouped over time. This export follows your selected date range, time grouping, VIP tier, loyalty status, view mode, and earnings status filters.
The date export includes:
Day
Earned
Spent
Revoked
Expired
Refunded
Total or Outstanding Balance, depending on the selected view mode
Use this export for month-end reporting, trend analysis, and balance movement summaries.
Export by customer
Choose Customer when you want one row per customer for the selected date range.
The customer export is not grouped by day, week, or month. It shows customer-level activity for the selected date range and earnings status.
The customer export includes:
Customer ID
Customer Email
Earned
Spent
Revoked
Expired
Refunded
Total
You can also select Include VIP Tier Name to add each customer’s current VIP tier to the CSV.
Customer exports are useful when you need a customer-level support audit, customer-level accounting backup, or a detailed record of which customers had balance activity during the selected period.
If you need VIP tier or loyalty status filters to affect the exported totals, use the date-grouped export. The customer-grouped export can include the current VIP tier as an extra column, but it is not narrowed by the VIP tier or loyalty status filters.
Why exports may take time
Large exports may take longer to arrive, especially when you export a long date range or choose customer-level grouping. If an export takes longer than expected, try a smaller date range first.
What to give your accountant
For accounting review, export the report using the same date range and settings your accountant expects. A clean handoff usually includes:
A date-grouped CSV for the reporting period, usually in Cumulative Balance view when they need the outstanding balance at period end.
A customer-grouped CSV if they need customer-level activity backup for the selected period.
The selected date range.
The selected view mode: Net Activity or Cumulative Balance.
The selected earnings status: All Earnings or Approved Only.
The selected time grouping for date-based exports.
Any applied VIP tier or loyalty status filters for date-grouped exports.
Whether your program balance is treated as points, store credit, or another loyalty balance type.
Your internal valuation policy for the balance, such as how your business values points or store credit for accounting purposes.
If you provide a customer-grouped CSV, note that it is customer-level activity for the selected period, not a point-in-time list of every customer with an outstanding balance.
Rivo provides loyalty program activity reporting to help you review and export your program data. Rivo does not provide tax, accounting, legal, or financial advice, and your business is responsible for deciding how loyalty balances should be valued, reported, and reconciled. Work with your accountant or finance advisor to confirm the right treatment for your business.
Best practices
Use the same date range and filters whenever you compare reports across periods.
Use Cumulative Balance for period-end outstanding balance checks.
Use Net Activity when reviewing what changed during a period.
Use Approved Only if your internal process only recognizes approved activity.
Export by Customer when you need customer-level backup or investigation detail.
Keep a note of your filters with each export so future reconciliations are easier to repeat.
FAQ
Why are Spent, Revoked, or Expired values negative?
These values reduce the customer’s available balance, so they usually appear as negative numbers.
Why is Refunded positive?
Refunded balance is returned to the customer, so it usually increases the outstanding balance.
Which export should I use for month-end reporting?
Use the date export when you need totals over time. Use the customer export when your accountant or finance team needs customer-level backup.
Does the report decide how much money my business owes?
No. The report shows loyalty balance activity from Rivo. Your business, accountant, or finance advisor should decide how to value and account for that balance.
Can I schedule this export automatically?
Not from the Analytics export modal today. Exports are requested one at a time and sent by email after processing.