AR Aging report in Reporting module
Learn about generating the AR Aging report in Reporting module.
The AR Aging - Time Based feature enables you to generate the AR Aging report in the Reporting module as of a specific “As of Date” within the current accounting period. When you select a date from the As of date dropdown filter, the reports will calculate aging a point in time snapshot as of the selected date.
The report uses daily AR balance snapshots. In the current accounting period, available daily snapshots appear in the As of Date filter. For prior periods, only period-end snapshots are retained.
This gives you operational, day‑to‑day insight into current receivables, rather than being limited to historical accounting periods or the Trial Balance-only experience.
The feature supports the following reporting dates:
The end date of previous accounting periods
Any date within the current accounting period up to today, as long as snapshot data exists for that date
For past closed accounting periods, only period-end snapshots are retained. For the current accounting period, daily snapshots are retained while the period is open. Daily snapshots from prior periods are deleted except for period-end dates.
Supported transaction coverage
The AR aging snapshot design supports seven AR transaction types:
Invoice Item
Debit Memo Item
Credit Memo Item
Invoice Tax
Debit Memo Tax
Credit Memo Tax
Unapplied Payment
This allows the report to provide a consolidated, transaction item-level AR aging view in Reporting.
Key considerations
Here are key considerations for the AR Aging report in Reporting module:
Only daily data for the current accounting period is retained, while period-end snapshots are preserved for past periods. Daily data from previous periods (except for period-end dates) will be deleted.
The report is designed for daily point-in-time visibility, not real-time recalculation. The daily job generates the current day snapshot and refreshes the previous period-end snapshot. It does not continuously recompute prior daily snapshots within the current period.
If a tenant uses custom FX rates, it is important to upload the FX rates in time. Otherwise, the data will remain unavailable until the missing FX rate issue is resolved.
The “As of Date” will not appear in the filter dropdown if the data for that date is not available.
Possible reasons may include:
The date is later than the tenant’s current date.
The scheduled job has not yet been completed.
The required FX rate is missing.
The date falls within a previous accounting period and is not a period-end date.
The date corresponds to an earlier accounting period end date, and the data has not yet been migrated. If data for any previous accounting period end date needs to be migrated, contact Zuora Support.