Skip to main content

Accounts Receivable Aging

Zuora

Accounts Receivable Aging

This article describes the Accounts Receivable Aging data in the Balances tab of an accounting period. For information about the other sections in the Balances tab, see Accounting Period Balances.

An invoice is regarded as Aging if it is not paid in full by the end of the current accounting period. For example, an invoice date is 2/20/2018 with an amount of $100. A payment of $100 is applied to this invoice and the payment date is 3/20/2018. On the February accounting period, from the finance perspective, the invoice balance is still 100 because the payment has not been made in February. In this case, this invoice is regarded as Aging in February. On the March accounting period when the full payment is made, this invoice is not Aging and the invoice balance becomes 0.

Zuora Finance must be enabled on your tenant and you must have Zuora Finance Access permission to view the Accounting Period Balances tab.

After you have run a trial balance or closed an accounting period, you can view the Balances tab for information about your Accounts Receivable Aging balance for that period. You can view:

  • Accounts Receivable Aging Summary
  • Accounts Aging Details
  • Invoice Aging Details
  • Debit Memo Aging Details

To access the information, complete the following steps:

  1. Navigate to Finance > Accounting Periods.
  2. In the All Accounting Periods table, click the accounting period that you want to view. 
  3. Click the Balances tab and then scroll down to the Accounts Receivable Aging section.

Viewing Consolidated Balances or Balances for Individual Currencies

To view a consolidated Accounts Receivable Aging balance of all currencies converted into your home currency, select "Consolidated View" from the Currency drop-down menu.

You can also select individual currencies from the drop-down menu to view the balances for that currency only.

Accounts Receivable Aging Summary

The Accounts Receivable Aging summary provides a summary of all outstanding amounts as of the end of the accounting period.

The Accounts Receivable Aging summary contains the following fields.

Field Description

<Invoice Aging Buckets>

One or more aging buckets for outstanding invoice amounts. 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.
All outstanding invoice amounts and all debit memo amounts will fall within the aging buckets if you enable the Invoice Settlement feature.

You can configure aging buckets according to your business requirements.

Total Invoice Aging Balance

Sum of all outstanding invoice amounts that fall within the aging buckets.

Sum of all outstanding invoice amounts and all debit memo amounts that fall within the aging buckets if you enable the Invoice Settlement feature.

Total Out of Bucket Invoice Balance

Sum of outstanding invoice amounts 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 field does not appear.

Total Negative Invoice Balance

Sum of all negative invoices.

This column appears only if you have deselected the Include negative invoices in Aging Bucket balances checkbox in Finance Settings > Configure Aging Balance Settings. By default, this field does not appear.

Credit Balance

Sum of all credit balance amounts.

Payments/Refunds against Future Invoices

Sum of all payments and refunds made against invoices in future accounting periods.

Click the field name for more information about the payments and refunds impacting this accounting period.

This field does not appear if the value is zero.

Total Currency Conversion Rounding Differences

Only viewable in Consolidated View. The discrepancy caused by rounding transaction amounts during currency conversion. Accurate to nine decimal places.

Accounts Receivable Aging Total

Total accounts receivable aging balance, calculated as follows:

Accounts Receivable Aging Total = Total Invoice Aging Balance + Total Out of Bucket Invoice Balance - Total Negative Invoice Balance - Credit - Balance Payments/Refunds against Future Invoices

If you enable the Invoice Settlement feature, it is calculated as follows: 

Accounts Receivable Aging Total = Total Invoice Aging Balance + Total Out of Bucket Invoice Balance - Total Negative Invoice Balance - Credit Balance Payments/Refunds against Future Invoices + Total Currency Conversion Rounding Differences - Unapplied Payment Aging Balance - Unapplied Credit Memo Aging Balance 

Unapplied Payment Aging Balance

Sum of all unapplied payments amounts that fall within the aging buckets. 

This item appears only if you enable the Invoice Settlement feature.

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.

Unapplied Credit Memo Aging Balance

Sum of all unapplied credit memo amounts that fall within the aging buckets.

You can view Unapplied Credit Memo Aging Balance in the On-Account Credit Memo column of the Account Aging report. To download the Account Aging report see Account Aging Details.

This item appears only if you enable the Invoice Settlement feature.

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.

Account Aging Details

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 check box, 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:

Account Balance = Invoice Balance – Credit Balance

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 deselected 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. 

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.

Invoice Aging Details

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.

Debit Memo Aging Details 

The Debit Memo Aging detail report provides a list of debit memos 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 Debit Memo 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=view&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.

Debit Memo Aging Report Fields 

The following table describes the fields that are included in the Debit Memo Aging detail report.

Field Description

Currency

Currency associated with the debit memo.

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 associated with the debit memo.

Account Number

Number of the account associated with the debit memo. 

<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.

Debit Memo Number

Number of the debit memo. 

Debit Memo Date

Date of the debit memo.

Debit Memo Amount

Total amount of the debit memo. 

Due Date

Date when the debit memo was due to be collected. 

Days Aging

Number of days that the debit memo is past due. 

This field can also contain negative numbers. For example, -5 means 5 days until a debit memo is due.

Aging Bucket

Name of the aging bucket in which the debit memo is located. A debit memo can belong to only one aging bucket.

Debit Memo Balance

Current outstanding balance of the debit 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.

<Debit Memo Segments>

If you have configured any segments for fields on the Debit Memo 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 debit memo amounts are assigned to buckets based on the length of time the debit memo is past due.

<Aging Buckets> (Home Currency)

Each of the aging buckets is provided in your home currency.