Skip to main content

Accounting Period Summary - Cash

Zuora

Accounting Period Summary - Cash

This article shows you how to view Cash data in the Summary tab of an accounting period. For information about the other sections in the Summary tab, see Accounting Period Summary.

Zuora Finance must be enabled on your tenant and you must have Zuora Finance Access permission to view this data.

After you have run a trial balance or closed an accounting period, you can view Billings data as of the end of the accounting period.

Navigate to Finance > Accounting Periods, select the accounting period you want to view, and then select the Summary tab. Scroll down to the Cash section.

Cash Field Definitions and Usage

The Cash category includes the items that impact your cash balance in this accounting period, including Payments, Refunds, and Credit Balance Adjustments (Overpayment and Credit Balance Refund).

Payments Summary

Category Description
Payments

This section summarizes all the payments and shows the total amount by accounting code. The accounting code is by payment method, and represents the offsetting account to AR. In this case, it is typically the cash account.

The Payments information includes credit balance overpayment. If it is a credit balance overpayment, you can specify the accounting code in the Zuora Payments Configure Accounting Codes setting.

Zuora recommends that you use different accounting codes for overpayments and payments to an invoice. If they use the same accounting code, Zuora will group those amounts together in the Payments summary.

How do I use this data? 

Use this data to create summary journal entries in your accounting system that debit the cash account specified by the accounting code, and credit the AR. 

How is this added to an accounting period?

Payments to credit balances are added to accounting periods based on the payment date.

Refunds Summary

Category Description
Refunds

This section summarizes all of the refunds and shows you a total amount by accounting code. 

It includes the credit memo refunds if you enable the Advanced AR 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.

You can specify the accounting code in the Zuora Payments Payment Methods setting. You can set the accounting code is by payment method, and it represents the offsetting account to AR. In this case, it is typically the cash account.

Zuora recommends that you use different accounting codes for cash refunds and credit balance refunds. If they use the same accounting code, Zuora will group those amounts together in the Refunds summary.

How do I use this data?

Use this data to create summary journal entries that debit the AR account and credit the cash account represented by the accounting code. 

How is this added to an accounting period?

Refunds are added to accounting periods based on the refund date.

Credit Balance

This section includes all data that affects your overall credit balance, including Overpayments, Transferred to Credit Balance, Applied from Credit Balance, and Credit Balance Refunds. 

Note that the Credit Balance section is only available if you enable the Credit Balance feature. The Credit Balance feature is in Limited Availability. If you wish to have access to the feature, submit a request at Zuora Global Support.

Category Description
Overpayments

This section summarizes all of the credit balance adjustments of the type overpayment and shows the total amount by accounting code. You can specify the accounting code in the Zuora Payments Configure Accounting Codes setting.

The accounting code is the offsetting account to customer cash on account, which in this case is a cash account.

How do I use this data?

Use this data to create summary journal entries that debit the cash account and credit the customer cash on account (liability account).

How is this added to an accounting period?

Overpayments from credit balances are added to accounting periods based on the credit balance adjustment date.

Transferred to Credit Balance

This section summarizes all of the credit balance adjustments of the type transfer to credit balance and shows the total amount by accounting code. 

You can specify the accounting code in the Zuora Payments Configure Accounting Codes setting. Typically, the accounting code is the offsetting account to AR, which in this case is a "customer cash on account" liability account.

How do I use this data?

Use this data to create summary journal entries that debit AR and credit the customer cash on account (liability account). 

How is this added to an accounting period?

Transferred to credit balances are added to accounting periods based on the credit balance adjustment date.

Applied from Credit Balance

This section summarizes all of the credit balance adjustments of the type apply credit balance and shows the total amount by accounting code.

You can specify the accounting code in the Zuora Payments Configure Accounting Codes setting. Typically, the accounting code is the offsetting account to AR, which in this case is a "customer cash on account" liability account.

How do I use this data?

Use this data to create summary journal entries that debit the customer cash on account (liability account) and credit AR.

How is this added to an accounting period?

Applied from credit balances are added to accounting periods based on the credit balance adjustment date.

Credit Balance Refunds

This section summarizes all of the refunds of the type credit balance refund and shows the total amount by accounting code.

You can specify the accounting code in the Zuora Payments Configure Accounting Codes setting. The accounting code is the offsetting account to customer cash on account, which in this case is a cash account.

How do I use this data?

Use this data to create summary journal entries that debit the customer cash on account (liability account) and credit a cash account.

How is this added to an accounting period?

Credit balance refunds are added to accounting periods based on the credit balance adjustment date.