Knowledge Center

Knowledge Center > Finance > Accounting Periods > View Accounting Period Balances > Accounts Receivable Aging

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.

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

Navigate to Finance > Accounting Periods, select the Accounting Periods tab (top left), select the accounting period you want to view, and then select the Summary tab. 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.

AR Aging Balance

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.

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.

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

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. The detail report also includes any canceled accounts that have an invoice balance or credit balance as of the accounting period end date.

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.

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

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.

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

Current outstanding balance of the invoice. 

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.

Last modified
22:10, 15 Mar 2017

Tags

Classifications

(not set)