Skip to main content

Update Accounting Codes

Zuora

Update Accounting Codes

The Update Accounting Codes mass action allows you to mass update accounting codes on transaction objects, such as invoice items. This reference describes the columns supported in the upload file and the columns added to the response file. See Mass Updater for more information.

When you have updated the accounting code of the following object types using the Update Accounting Codes mass action, the corresponding revenue schedules will also be updated:

  • Invoice Item
  • Invoice Item Adjustment
  • Credit Memo Item
  • Debit Memo Item

Upload File Columns 

The following table describes the columns supported in the upload file.

The Credit Memo Item and Debit Memo Item transaction types are only available if you enable the Invoice Settlement feature.

The Unapplied Payment Accounting Code and On-Account Accounting Code columns 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.

Column Required? Description

Group ID

Optional

ID of the group that the record belongs to. If a record with a Group ID fails, any subsequent records in that group will not be processed.

Type: string

Character limit: 255

Object Key

Required

ID or transaction number of the object whose accounting code you want to update.

The specified transaction must not be in a closed accounting period or included in a summary journal entry, otherwise, you will receive an error.

Type: string

Character limit: 32

Object Type

Required

Type of transaction object whose accounting code you want to update. Valid values are:

  • Credit Balance Adjustment
  • Invoice Adjustment (Deprecated on Production)
  • Invoice Item
  • Invoice Item Adjustment
  • Taxation Item
  • Payment
  • Product Rate Plan Charge
  • Refund
  • Revenue Schedule
  • Credit Memo Item
  • Debit Memo Item

Note: You can update the Credit Taxation item in the mass updater using the Taxation Item object type.

Type: enum

Deferred Revenue Accounting Code

Optional

Deferred revenue accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Invoice Adjustment (Deprecated on Production)
  • Invoice Item
  • Invoice Item Adjustment
  • Product Rate Plan Charge
  • Revenue Schedule
  • Credit Memo Item
  • Debit Memo Item

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Recognized Revenue Accounting Code

Optional

Recognized revenue accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Invoice Item
  • Invoice Item Adjustment
  • Product Rate Plan Charge
  • Revenue Schedule
  • Credit Memo Item
  • Debit Memo Item

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Sales Tax Payable Accounting Code

Optional

Sales tax payable accounting code that you want to associate with the object.

Applicable only if the Object Type is Taxation Item.

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Bank Account Accounting Code    

Optional

Bank account accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Payment
  • Refund
  • Credit Balance Adjustment

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Cash on Account Accounting Code

Optional

Cash on account accounting code that you want to associate with the object.

Applicable if the Object Type is Credit Balance Adjustment.

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Unapplied Payment Accounting Code Optional

Unapplied payment accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Payment
  • Refund

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

On-Account Accounting Code Optional

Bank account accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Credit Memo Item
  • Refund

The accounting code must be active in your Zuora chart of accounts.

If you don't want to update the accounting code, leave this field blank.

Type: string

Character limit: 100

Accounts Receivable Accounting Code Optional

Accounts Receivable accounting code that you want to associate with the object.

Applicable if the Object Type is one of the following:

  • Invoice Item
  • Debit Memo Item
  • Product Rate Plan Charge
  • The accounting code must be the type of “Accounts Receivable” in your Zuora chart of accounts.

Note: Updating Accounts Receivable (AR) Accounting Code using Mass Updater is only supported if you have the Invoice Item Settlement feature enabled.

Type: string

Character limit: 100

Response File Columns

The following table describes the columns added to the response file.

Column Description

Success

  • Returns Y if the record was successful.
  • Returns N if the record failed.
  • Remains blank if the record was not processed.

Error Message

Displays a brief description of the error if the record failed.