Aging report and snapshots

Use the Aging report to see which clients currently have unpaid finalized invoices and how long those balances have been outstanding. Export the current result when you need to work with it, or save daily or monthly snapshots when you need reliable dated copies for future reference.

Before you begin

You need permission to access invoices and accounts receivable. The Aging report is an operational view of current unpaid balances; it is not an accounting ledger.

Go to E-Commerce → Aging report.

1. Understand the live report

The report groups unpaid balances by the number of days since each invoice was finalized:

0–30 days
31–60 days
61–90 days
90+ days

The summary shows the number of clients and the total balance in each age range. The table groups the same balances by client and shows the number of matching invoices. Select a column heading to sort the table. Select a client row to open the Invoices page for that client.

Open the Aging report and access Aging snapshots

The live report uses the balances that exist now. To see what clients owed at the end of an earlier day, use Balances at a past date, described in step 5. Snapshots remain the most reliable way to preserve dated reports from now on.

2. Filter and export the current report

Use the invoice menu to show:

All invoices.
Invoices with or without a membership.
Invoices with or without a class.
Invoices with or without a booking, when bookings are enabled.

You can also search by client name, email, or mobile number and select a Ledger code. When a membership, class, or booking filter supports tags, select a tag to narrow the result further.

Use the page-size menu below the table to show 10, 25, 50, 100, or 200 clients per page. Select the Excel button to download the complete filtered result. The workbook includes every matching client, not only the visible page.

3. Save a snapshot now

Select Aging snapshots.
Select Save now.
Wait for the queued snapshot to finish, then select Refresh in the snapshot window.
Select Download beside a saved file.

Only one Aging report snapshot can be saved for an organization-local calendar date. A manual snapshot and an automatic snapshot use the same daily limit.

Download saved Aging report snapshots

Each row shows the report date, when the file was created, whether its source was Manual or Automated, and its size. Use the paginator and page-size menu below the table to review older files.

4. Schedule daily or monthly snapshots

In Aging snapshots, select Configure.
Turn on Create snapshots automatically.
Choose a Frequency:
- Daily creates one snapshot every day at the selected time.
- Monthly creates one snapshot on the selected day and time each month.
Select a Time. The time uses the organization timezone shown in the window and is available in 15-minute steps.
For Monthly snapshots, choose a Day of the month from 1 through 28 or Last day of the month.
Confirm the Next snapshot, then select Save.

Configure daily or monthly Aging report snapshots

Days 29 through 31 are replaced by Last day of the month so the schedule also works in shorter months. Changing the organization timezone recalculates the next occurrence.

5. View balances at a past date

Use Balances at a past date when you need what clients owed at the end of an earlier day, for example at your fiscal year-end, and no snapshot was saved for that date.

Select Balances at a past date.
Choose a Date before today. Balances are restated at the end of that day in the organization timezone.
Read the notes in the window, then select View restated balances.

The button turns yellow and shows the date, and a banner above the report states that you are viewing restated balances rather than current ones. The age ranges are calculated from that date. Filters, sorting, and the Excel export all use the restated balances; the exported file name ends with _restated. The date is kept in the page address, so a reload or a copied link opens the same view. The first calculation for a date can take several seconds. Use Refresh to recalculate it.

Select Change date to pick another date, or Return to current balances to go back to the live report.

Restated balances are a reconstruction. Activity Messenger starts from current balances and undoes the payments, refunds, credits, added or removed invoice items, and cancellations recorded after the chosen date. Keep these limits in mind:

A payment entered later counts from the day it was entered, even if it carries an earlier payment date.
An amount edited directly on an existing invoice item after the chosen date cannot be undone and appears with its current value.
Clients, tags, and product filters use current information. An invoice moved to another client appears under its current client.
When a saved snapshot exists for the date, the snapshot remains the record of what was reported that day.

What a snapshot contains

A snapshot is an Excel copy of the complete Aging report on its report date. It contains:

A Total balance sheet with the four age ranges and overall balance.
An Aging report sheet with the client-level balances and invoice counts.

Snapshots use the organization language at generation time. They do not preserve the live report’s membership, class, booking, client, tag, or ledger-code filters.

Snapshots begin after you enable them; earlier dates are not created automatically. Saved files are private, do not expire, and remain available if automatic snapshots are later disabled.

Example

An organization wants a daily record after staff finish processing payments.

Open Aging snapshots → Configure.
Enable automatic snapshots.
Select Daily and 11:45 PM in the organization timezone.
Save the schedule.
At month end, open Aging snapshots and download the files needed for reconciliation.

The live report continues to change as invoices are paid. Each downloaded snapshot preserves the report generated for its date.

Important notes

Aging starts on the invoice finalization date, not its payment due date.
Only finalized, non-cancelled invoices with a current unpaid balance appear.
An empty report means no invoices currently match the filters with a positive unpaid balance.
Balances at a past date are restated from current data; they are not a saved copy of what was reported that day.
Excel exports use all current filters; scheduled and manual snapshots use the complete report without those filters.
A queued snapshot may take a short time to appear. Use Refresh in the snapshot window.
Turning automatic snapshots off stops future scheduled files but does not delete existing ones.