Accounting codes upload file columns
The columns supported in the upload file
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:
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:
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:
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:
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:
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:
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:
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 |
|
Non Revenue Write Off Accounting Code |
Optional |
Non-revenue impacting write off accounting code that you want to associate with the object. Note: This accounting code only can be updated for Credit Memo Item transaction type. This field is available only if you have enabled the enhanced write-off permission for your tenant. Contact Zuora Global Support to enable this permission. Type: string Character limit: 100 |
Use Discount Specific Accounting Code | Optional | This flag determines whether to use the specific accounting code for the given Discount Charge. This field is applicable only when the Object Type is Product Rate Plan Charge and the charge is a discount charge. If you don't want to update this flag, leave this field blank. Type: string Character limit: 100 |
Adjustment Liability Accounting Code | Optional | Accounting code for adjustment liability. Note: Available in all tenants, but only applicable if RevPro Integration is enabled. Type: string Character limit: 100 |
Adjustment Revenue Accounting Code | Optional | Accounting code for adjustment revenue. Note: Available in all tenants, but only applicable if RevPro Integration is enabled. Type: string Character limit: 100 |
Contract Asset Accounting Code | Optional | Accounting code for contract asset. Note: Available in all tenants, but only applicable if RevPro Integration is enabled. Type: string Character limit: 100 |
Contract Liability Accounting Code | Optional | Accounting code for contract liability. Note: Available in all tenants, but only applicable if RevPro Integration is enabled. Type: string Character limit: 100 |
Contract Recognized Revenue Accounting Code | Optional | Accounting code for contract recognized revenue. Note: Available in all tenants, but only applicable if RevPro Integration is enabled. Type: string Character limit: 100 |
Unbilled Receivables Accounting Code | Optional | Accounting code for unbilled receivables. Note: Available in all tenants, but only applicable if RevPro Integration is enabled. Type: string Character limit: 100 |
For Multi-Org enabled tenants, to prevent the mass updater from erroring out while updating a transaction item from UI, use the mass updater API along with an org header to update the accounting code on the transaction item: Zuora-Working-Org:{organizationId}