Happy Business Starts Here

Highlighted
Zuora Support

Mass upload Chart of Accounts

User reported that they have around 600 accounting codes that don’t exist in the Zuora, Chart of Accounts. 
Do you have a way to mass load them if we provided the list?






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Zuora Support

Re: Mass upload Chart of Accounts

Currently, we were unable to mass upload Chart of Accounts through Zuora UI, the only way to add the chart of accounts through UI is manually creating them.

This can be achieved through API. 

REQUEST:

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns2="http://object.api.zuora.com/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:api="http://api.zuora.com/" xmlns:ns1="http://api.zuora.com/">
    <SOAP-ENV:Header>
          <ns1:SessionHeader>
                <ns1:session></ns1:session>
          </ns1:SessionHeader>
          <ns1:QueryOptions>
                <ns1:batchSize></ns1:batchSize>
          </ns1:QueryOptions>
    </SOAP-ENV:Header>
    <SOAP-ENV:Body>
<ns1:create>
  <api:zObjects xmlns:ns381="http://object.api.zuora.com/" xsi:type="ns381:AccountingCode">
  ​  <ns381:Name>012456789012345</ns381:Name>
    <ns381:Type>OtherLiabilities</ns381:Type>
    <ns381:GLAccountNumber>123</ns381:GLAccountNumber>
    <ns381:GLAccountName>123GLName</ns381:GLAccountName>
    <ns381:Notes>AnyNote</ns381:Notes>
  </api:zObjects>
<api:zObjects xmlns:ns381="http://object.api.zuora.com/" xsi:type="ns381:AccountingCode">
  ​  <ns381:Name>012</ns381:Name>
    <ns381:Type>OtherLiabilities</ns381:Type>
    <ns381:GLAccountNumber>456</ns381:GLAccountNumber>
    <ns381:GLAccountName>12GLName</ns381:GLAccountName>
    <ns381:Notes>AnyNote</ns381:Notes>
  </api:zObjects>
</ns1:create></SOAP-ENV:Body>
</SOAP-ENV:Envelope>


RESPONSE:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <soapenv:Body>
          <ns1:createResponse xmlns:ns1="http://api.zuora.com/">
                <ns1:result>
                      <ns1:Id>2c92c0f86bd12f2a016bd296629c23f4</ns1:Id>
                      <ns1:Success>true</ns1:Success>
                </ns1:result>
                <ns1:result>
                      <ns1:Id>2c92c0f86bd12f2a016bd29662aa23f5</ns1:Id>
                      <ns1:Success>true</ns1:Success>
                </ns1:result>
          </ns1:createResponse>
    </soapenv:Body>
</soapenv:Envelope>




Please refer the supportive knowledge center article:
https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/AccountingCo... 







If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √