Invoice Aging details
A list of invoices that have outstanding amounts as of the end of the accounting period
The Invoice Aging detail report provides a list of invoices that have outstanding amounts as of the end of the accounting period.
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 Invoice 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=downloadARAgingDetail&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.
Invoice Aging Report fields
The following table describes the fields that are included in the Invoice Aging detail report.
|
Field |
Description |
|---|---|
|
Currency |
Currency associated with the invoice. |
|
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. It is the end date of the current accounting period. |
|
Account Name |
Name of the account associated with the invoice. |
|
Account Number |
Number of the account associated with the invoice. |
|
<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 Number |
Number of the invoice. |
|
Invoice Date |
Date of the invoice. |
|
Invoice Amount |
Total amount of the invoice. |
|
Due Date |
Date when the invoice was due to be collected. |
|
Days Aging |
Number of days that the invoice is past due. This field can also contain negative numbers. For example, -5 means 5 days until an invoice is due. |
|
Aging Bucket |
Name of the aging bucket in which the invoice is located. An invoice can belong to only one aging bucket. |
|
Invoice Balance |
The balance as of the end date of the current accounting period. |
|
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. |
|
<Invoice Segments> |
If you have configured any segments for fields on the Invoice object, the segment names appear here as column headings. The segments are arranged in alphabetical order. See Fields Supported by Segments for information about which transaction fields are supported on segments. |
|
<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. |
|
<Aging Buckets> (Home Currency) |
Each of the aging buckets is provided in your home currency. |