Account Aging details
A list of all active accounts with their Invoice Balance, Credit Balance, and Account Balance as of the end of the accounting period
The Account Aging detail report provides a list of all active accounts with their Invoice Balance, Credit Balance, and Account Balance as of the end of the accounting period. By default, canceled accounts that have either a non-zero invoice balance or a credit balance as of the accounting period end date are included in the Account Aging detail report.
If you clear the Include negative invoices in Aging Bucket balances checkbox, canceled accounts that have a non-zero invoice balance, a negative invoice balance, or a credit balance as of the accounting period end date will be included in the Account Aging detail report. See Configure Aging Balance Settings for more information.
Download from the Zuora Application:
After running the trial balance, navigate to Accounts Receivable Aging and click [Download Aging Detail]. A dialog box is displayed. Select Account Aging and click ok.
Download Through a URL:
Use the following URL, where you replace {accounting period ID} with the ID of the accounting period for which you want to view Account Aging data:
www.zuora.com/apps/AccountingPeriods.dox?method=downloadAccountAgingDetail&id={accounting period ID}
To find the accounting period ID, navigate to Finance > Accounting Periods and click on the accounting period. On the accounting period page, copy the sequence of letters and numbers after id= at the end of the URL, for example, 8a8081ae4b9a132a014bfc6721861190.
Account Aging Report fields
The following table describes the fields that are included in the Account Aging detail report.
|
Field |
Description |
|---|---|
|
Currency |
Currency associated with the account. |
|
Home Currency |
Your home currency. |
|
Exchange Rate |
The exchange rate used to convert the transaction currency into your home currency. |
|
Exchange Rate Date |
The date used to determine the exchange rate. |
|
Account Name |
Name of the account. |
|
Account Number |
Number of the account. |
|
<Customer Account Segments> |
If you have configured any segments related to customer accounts, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields Supported by Segments for information about which customer account fields are supported on segments. |
|
Invoice Balance |
Sum of all outstanding invoice balances on the account. |
|
Credit Balance |
Credit balance on the account. |
|
Account Balance |
Total balance on the account. Can be positive or negative. The account balance is calculated as follows: |
|
Invoice Balance (Home Currency) |
Invoice balance in your home currency. |
|
Invoice Balance Currency Rounding |
The discrepancy caused by rounding the Invoice Balance during currency conversion. Accurate to nine decimal places. |
|
Credit Balance (Home Currency) |
Credit balance in your home currency. |
|
Credit Balance Currency Rounding |
The discrepancy caused by rounding the Credit Balance during currency conversion. Accurate to nine decimal places. |
|
Account Balance (Home Currency) |
Account balance in your home currency. |
|
Account Balance Currency Rounding |
The discrepancy caused by rounding the Account Balance during currency conversion. Accurate to nine decimal places. |
|
<Aging Buckets> |
One or more aging buckets. Can be the default buckets or custom buckets that you created. Outstanding invoice amounts are assigned to buckets based on the length of time the invoice is past due. |
|
Out of Bucket Invoice Balance |
Total balance of outstanding invoices that do not fall within any of the aging buckets. This column appears only if your aging bucket configuration allows invoice amounts to fall outside the aging bucket range. By default, this column does not appear. |
|
Negative Invoice Balance |
Total balance of negative invoices. This column appears only if you have cleared the Include negative invoices in Aging Bucket balances checkbox in Finance > Configure Aging Balance Settings. By default, this checkbox is selected. |
|
<Aging Buckets> (Home Currency) |
Each of the aging buckets is provided in your home currency. |
|
Out of Bucket Invoice Balance (Home Currency) |
Out of Bucket Invoice Balance (if present) in your home currency. |
|
Negative Invoice Balance (Home Currency) |
Negative Invoice Balance (if present) in your home currency. |
|
The following fields are only available if you enable the Invoice Settlement feature. Note:
The Invoice Settlement feature is generally available as of Zuora Billing Release 296 (March 2021). This feature includes Unapplied Payments, Credit and Debit Memos, and Invoice Item Settlement. If you want to have access to the feature, see Invoice Settlement Enablement and Checklist Guide for more information. After Invoice Settlement is enabled, the Invoice Item Adjustment feature will be deprecated for your tenant. | |
|
Debit Memo Balance |
Sum of all debit memo balances on the account. |
|
Unapplied Payment |
Sum of all unapplied payments. |
|
On-Account Credit Memo |
Sum of all on-account credit memo. |
|
Debit Memo Balance (Home Currency) |
Debit memo balance in your home currency. |
|
Debit Memo Balance Currency Rounding |
The discrepancy caused by rounding the Debit Memo Balance during currency conversion. Accurate to nine decimal places. |
|
Unapplied Payment (Home Currency) |
Unapplied payment balance in your home currency. |
|
Unapplied Payment Currency Rounding |
The discrepancy caused by rounding the Unapplied Payment Balance during currency conversion. Accurate to nine decimal places. |
|
On-Account Credit Memo (Home Currency) |
On-Account credit memo balance in your home currency. |
|
On-Account Credit Memo Currency Rounding |
The discrepancy caused by rounding the On-Account Credit Memo Balance during currency conversion. Accurate to nine decimal places. |