Knowledge Center

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

Accounts Receivable

This article describes the Accounts Receivable 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.

You can view Accounts Receivable information in the Balances tab for accounting periods with a start date on or after 01-01-2015. Accounting periods before this date will not have Accounts Receivable information.

After you have run a trial balance or closed an accounting period, you can view the Balances tab for information about your Accounts Receivable balance for that period. You can view your Accounts Receivable balance summary and download a separate detail report.

Navigate to Finance > Accounting Periods, select the Accounting Periods tab (top left), select the accounting period you want to view, and then select the Balances tab. Scroll down to the Accounts Receivable section.

Viewing Consolidated Balances or Balances for Individual Currencies

To view a consolidated Accounts Receivable 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.

Note that when you select the Consolidated View, foreign currency gain and loss information is also displayed in the Accounts Receivable section. For more information about the foreign currency exchange gains and losses balance and the downloadable reports, see Foreign Currency Gains and Losses.

Accounts Receivable

The following table describes the fields in the Accounts Receivable section of the Balances tab. 

Invoice Adjustment is deprecated on Production. Zuora recommends that you use the Invoice Item Adjustment to adjust invoices.

Field Description

Starting Accounts Receivable

Starting balance of your Accounts Receivable for this accounting period. Equal to the Ending Accounts Receivable balance of the previous accounting period.

Note that the Starting Accounts Receivable balance of this accounting period and the Ending Accounts Receivable balance of the previous accounting period might be different if the previous period has not yet been closed.

Invoices

Sum of amounts for posted invoices with invoice dates in this accounting period.

Payments

Click the plus sign (+) to the left of Payments to display additional fields.

Invoice Payments

Sum of payments customers have made against invoice amounts.

Overpayments

Sum of overpayments customers have made.

Subtotal Payments

Sum of invoice payments and overpayments for this accounting period. Calculated as follows:

Subtotal Payments = Invoice Payments + Overpayments

Refunds

Click the plus sign (+) to the left of Refunds to display additional fields.

Invoice Payment Refunds

Sum of refunds to customers for payments already made.

Credit Balance Refunds

Sum of refunds to customers from their credit balance.

Subtotal Refunds

Sum of all refunds for this accounting period. Calculated as follows:

Subtotal Refunds = Payment Refunds + Credit Balance Refunds

Adjustments

Click the plus sign (+) to the left of Adjustments to display additional fields.

Invoice Item Adjustments [Credit]

Sum of credit invoice item adjustments.

Invoice Item Adjustments [Charge]

Sum of charge invoice item adjustments.

Invoice Adjustments [Credit]

Sum of credit invoice adjustments.

Invoice Adjustments [Charge]

Sum of charge invoice adjustments.

Subtotal Adjustments

Sum of all adjustments for this accounting period. Calculated as follows:

Subtotal Adjustments = Invoice Item Adjustments (Charge) - Invoice Item Adjustments (Credit) + Invoice Adjustment (Charge) - Invoice Adjustment (Credit)

Subtotal Accounts Receivable Transactions

Only viewable in Consolidated View. Sum of all transactions that impact Accounts Receivable for this accounting period.

Subtotal Foreign Currency Exchange Gains / Losses

Only viewable in Consolidated View. Sum of the following:

  • Realized gains / losses
  • Unrealized gains / losses
  • Unrealized gains / losses reversal from last accounting period

The subtotal includes only invoice balances, not credit balances.

See Foreign Currency Gains and Losses for more information about the detailed Gain/Loss reports you can download.

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.

Total Gains / Losses Rounding Differences

Only viewable in Consolidated View. The discrepancy caused when rounding foreign currency gain and loss amounts. Accurate to nine decimal places.

Ending Accounts Receivable

Ending balance of your Accounts Receivable for this accounting period. The following section shows how the Ending Accounts Receivable balance is calculated.

 

How is the Ending Accounts Receivable Balance Calculated?

If you're viewing a single currency, the Accounts Receivable Ending Balance is calculated as follows: 

Ending Accounts Receivable = Starting Accounts Receivable + Transactions that impact Accounts Receivable in the accounting period

If you're viewing balances in Consolidated View, the Accounts Receivable Ending Balance is calculated as follows: 

Ending Accounts Receivable = Starting Accounts Receivable + Transactions that impact Accounts Receivable in the accounting period + Subtotal Foreign Currency Exchange Gains / Losses + Total Accounts Receivable Transaction Rounding Differences + Total Gains / Losses Rounding Differences

The Starting Accounts Receivable balance is rolled forward from the previous accounting period. That is, the Ending Accounts Receivable balance from one accounting period is the Starting Accounts Receivable balance for the next accounting period.

The transaction types that impact Accounts Receivable are listed in the following table. The table also shows whether each transaction type increases (+) or decreases (-) the Ending Accounts Receivable balance.

Transaction Type Impact on Ending Accounts Receivable Balance

Invoices (tax included)

+

Invoice Payments

-

Overpayment

-

Payment Refunds

+

Credit Balance Refunds

+

Invoice Item Adjustments (Credit)

-

Invoice Item Adjustments (Charge)

+

Invoice Adjustments (Credit)

-

Invoice Adjustments (Charge)

+

Accounts Receivable Detail Report

The Accounts Receivable detail report provides a list of transactions that impact your Accounts Receivable balance for the accounting period. You can download the report from the Zuora UI or through a URL.

How to Download the Report

Download From the Zuora UI:

After running the trial balance, navigate to Balances > Accounts Receivable and click [Download Detail].

Download AR Detail

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 Accounts Receivable data:

https://www.zuora.com/apps/AccountingPeriods.dox?method=downloadARDetail&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.

Fields in the Accounts Receivable Detail Report

The following table describes the fields that are included in the Accounts Receivable detail report.

Field Description

Customer Account Number

Customer account number associated with the transaction.

Customer Account Name

Customer account name associated with the transaction.

Customer Account Currency    

Currency of the customer account. Each customer account has only one currency.

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

Transaction Date

Date when the transaction occurred.

Transaction Type

Type of transaction, such as an invoice item or invoice item adjustment.

Transaction Subtype

Subtype of the transaction. See Transaction Subtypes for more information.

Transaction Number

Transaction number, such as INV-00000001 for an invoice item.

Transaction ID

Unique system ID for the transaction.

Transaction Amount

Amount of the transaction.

Transaction Amount (Home Currency)

Transaction amount in your home currency.

Transaction Amount Currency Rounding

The discrepancy caused by rounding the transaction amount during currency conversion. Accurate to nine decimal places.

Debit Accounting Code

Accounting code that was debited.

Debit Amount

Amount that was debited.

Debit Amount (Home Currency)

Debit amount in your home currency.

Debit Amount Currency Rounding

The discrepancy caused by rounding the debit amount during currency conversion. Accurate to nine decimal places.

Credit Accounting Code

Accounting code that was credited.

Credit Amount

Amount that was credited.

Credit Amount (Home Currency)

Credit amount in your home currency.

Credit Amount Currency Rounding

The discrepancy caused by rounding the credit amount during currency conversion. Accurate to nine decimal places.

Accounts Receivable Accounting Code

Accounting code for Accounts Receivable.

Accounts Receivable Accounting Code Balance Impact

Impact on the balance of your Accounts Receivable accounting code.

Accounts Receivable Accounting Code Balance Impact (Home Currency)

Accounts Receivable Accounting Code Balance Impact in your home currency.

Accounts Receivable Accounting Code Balance Impact Currency Rounding

The discrepancy caused by rounding the Accounts Receivable Accounting Code Balance Impact amount during currency conversion. Accurate to nine decimal places.

Credit Balance Accounting Code

Accounting code for Credit Balance.

Credit Balance Accounting Code Balance Impact

Impact on the balance of your Credit Balance accounting code.

Credit Balance Accounting Code Balance Impact (Home Currency)

Credit Balance Accounting Code Balance Impact in your home currency.

Credit Balance Accounting Code Balance Impact Currency Rounding

The discrepancy caused by rounding the Credit Balance Accounting Code Balance Impact amount during currency conversion. Accurate to nine decimal places.

Account Balance Impact

Impact on the balance of the customer account.

Account Balance Impact (Home Currency)

Account Balance Impact in your home currency.

Account Balance Impact Currency Rounding

The discrepancy caused by rounding the Account Balance Impact amount during currency conversion. Accurate to nine decimal places.

Transaction Service Period Start

The Transaction Service Period Start and End dates are based on the transaction type. For example, for an invoice item, the dates are based on the service start and end dates of that invoice item.

Transaction Service Period End

Associated Transaction Type

Type of the associated transaction. See Associated Transaction Types for more information.

Associated Transaction Subtype

Subtype of the associated transaction. See Transaction Subtypes for more information.

Associated Transaction ID

ID of the associated transaction.

<Transaction Segments>

If you have configured any segments related to transactions, the segment names appear here as column headings. The segments are arranged in alphabetical order.

See Fields Supported by Segments for information about which fields are supported on segments.

Product

Name of the product.

Product Rate Plan

Name of the product rate plan.

Product Rate Plan Charge

Name of the product rate plan charge.

<Product Segments>

If you have configured any segments related to products, the segment names appear here as column headings. The segments are arranged in alphabetical order.

See Fields Supported by Segments for information about which product fields are supported on segments.

Subscription Name

Name of the subscription.

Subscription Rate Plan Charge ID

ID of the subscription rate plan charge.

<Subscription Segments>

If you have configured any segments related to subscriptions, the segment names appear here as column headings. The segments are arranged in alphabetical order.

See Fields Supported by Segments for information about which subscription fields are supported on segments.

 

 

Last modified
00:45, 27 Mar 2017

Tags

Classifications

(not set)