Importing Withholding Tax Transactions Using SOAP Web Services

Important:

This topic pertains to withholding tax in NetSuite accounts that do not have the SuiteTax feature enabled. If you are using a NetSuite account where the SuiteTax feature is enabled, go to Withholding Taxes in SuiteTax.

Withholding tax is no longer being updated for new features and reports in accounts that do not have the SuiteTax feature. All version upgrades of the Withholding Tax SuiteApp include fixes for reported issues only.

You can use SOAP web services in NetSuite to add or update transactions that have withholding tax. For more information about importing withholding tax transactions in NetSuite, see Importing Withholding Tax Transactions.

Note:

If you are using WSDL v2012_2 to import withholding tax transactions, use the custom field ID. If you are using WSDL v2013_2 onwards, use the internal ID of the customer field. For more information about WSDL versioning, see NetSuite Versioning and WSDL Versioning Overview.

The following SOAP web services operations are supported:

add
addList
update
updateList
upsert
upsertList
asyncAddList
asyncUpdateList
asyncUpsertList

For more information about SOAP web services, see SOAP Web Services Operations.

You must provide the values for the following fields in the Expense and Item sublists of transactions:

Note:

Withholding Tax columns for the Item sublist are hidden by default. You must show these custom columns so they can be mapped through SOAP web services. To show the custom columns, go to Customization > Lists, Records, & Fields > Transaction Line Fields. Edit the following item sublist fields for Withholding Tax. On the Display subtab, select Normal in the Display Type field.

Item sublist
- Withholding Tax Code
- Withholding Tax Rate
- Withholding Tax Base Amount
- Withholding Tax Amount
Expense sublist
- Withholding Tax Code - Expense
- Withholding Tax Rate - Expense
- Withholding Tax Base Amount - Expense
- Withholding Tax Amount – Expense
Expenses sublist
- Withholding Tax Code
- Withholding Tax Rate
- Withholding Tax Base Amount
- Withholding Tax Amount

When the withholding tax is posted for sales and purchase transactions, note the values of the amounts displayed in the Withholding Tax Base and Withholding Tax Amount columns. The values displayed will have a positive or negative numeric value to indicate the withholding tax deductions.

For purchase transactions, the Withholding Tax Amount column displays a negative numeric value.

Note:

This applies to both expense and item sublists.

For example, ABC LTD rented an office space for $1000.00. This is subject to 15% withholding tax. When you add the purchase transaction, the values for the withholding tax amounts should be entered in the SOAP request as follows:

Amount	Withholding Tax Rate	Withholding Tax Base	Withholding Tax Amount
1000.00	15%	1000.00	-150.00

Amount

Withholding Tax Rate

Withholding Tax Base

Withholding Tax Amount

1000.00

15%

1000.00

-150.00

The following is a sample SOAP request with the withholding tax amounts for the purchase transaction:

          <tranPurchases:itemList>
   <tranPurchases:item>
      <tranPurchases:item xsi:type="platformCore:RecordRef" internalId="4561"/>
      <tranPurchases:quantity>1</tranPurchases:quantity>
      <!-- Amount -->
      <tranPurchases:amount>1000.00</tranPurchases:amount>
      <tranPurchases:taxCode internalId="357"/>
      <tranPurchases:location xsi:type="platformCore:RecordRef" internalId="8"/>
      <tranPurchases:customFieldList>
         <!-- Apply WH Tax? Column -->
         <nsCore:customField xsi:type="nsCore:BooleanCustomFieldRef" scriptId="custcol_4601_witaxapplies">
            <nsCore:value>true</nsCore:value>
         </nsCore:customField>
         <!-- Withholding Tax Code Column -->
         <nsCore:customField xsi:type="nsCore:SelectCustomFieldRef" scriptId="custcol_4601_witaxcode">
            <nsCore:value internalId="2"/>
         </nsCore:customField>
         <!-- Withholding Tax Rate Column -->
         <nsCore:customField xsi:type="nsCore:DoubleCustomFieldRef" scriptId="custcol_4601_witaxrate">
            <nsCore:value>15.0</nsCore:value>
         </nsCore:customField>
         <!-- Withholding Tax Base Amount Column -->
         <nsCore:customField xsi:type="nsCore:DoubleCustomFieldRef" scriptId="custcol_4601_witaxbaseamount">
            <nsCore:value>1000.0</nsCore:value>
         </nsCore:customField>
         <!-- Withholding Tax Amount Column -->
         <nsCore:customField xsi:type="nsCore:DoubleCustomFieldRef" scriptId="custcol_4601_witaxamount">
            <nsCore:value>-150.0</nsCore:value>
         </nsCore:customField>
      </tranPurchases:customFieldList>
   </tranPurchases:item>
</tranPurchases:itemList>

For sales transactions, the Withholding Tax Base column displays a negative numeric value.

Note:

This applies only to item sublists.

For example, XYZ INC billed their customer for services rendered. The professional fee is $5000.00 and is subject to 10% withholding tax. The values for the withholding tax amounts of the sales transaction should be entered in the SOAP request as follows:

Amount	Withholding Tax Rate	Withholding Tax Base	Withholding Tax Amount
5000.00	10%	–5000.00	500.00

Amount

Withholding Tax Rate

Withholding Tax Base

Withholding Tax Amount

5000.00

10%

–5000.00

500.00

The following is a sample SOAP request with the withholding tax amounts for the sales transaction:

          <tranSales:itemList>
   <tranSales:item>
      <tranSales:item xsi:type="platformCore:RecordRef" internalId="4561"/>
      <tranSales:quantity>1</tranSales:quantity>
      <!-- Amount -->
      <tranSales:amount>5000.00</tranSales:amount>
      <tranSales:taxCode internalId="357"/>
      <tranSales:customFieldList>
         <!-- Apply WH Tax? Column -->
         <nsCore:customField xsi:type="nsCore:BooleanCustomFieldRef" scriptId="custcol_4601_witaxapplies">
            <nsCore:value>true</nsCore:value>
         </nsCore:customField>
         <!-- Withholding Tax Code Column -->
         <nsCore:customField xsi:type="nsCore:SelectCustomFieldRef" scriptId="custcol_4601_witaxcode">
            <nsCore:value internalId="2" />
         </nsCore:customField>
         <!-- Withholding Tax Rate Column -->
         <nsCore:customField xsi:type="nsCore:DoubleCustomFieldRef" scriptId="custcol_4601_witaxrate">
            <nsCore:value>10.0</nsCore:value>
         </nsCore:customField>
         <!-- Withholding Tax Base Amount Column -->
         <nsCore:customField xsi:type="nsCore:DoubleCustomFieldRef" scriptId="custcol_4601_witaxbaseamount">
            <nsCore:value>-5000.0</nsCore:value>
         </nsCore:customField>
         <!-- Withholding Tax Amount Column -->
         <nsCore:customField xsi:type="nsCore:DoubleCustomFieldRef" scriptId="custcol_4601_witaxamount">
            <nsCore:value>500.0</nsCore:value>
         </nsCore:customField>
      </tranSales:customFieldList>
   </tranSales:item>
</tranSales:itemList>

Related Topics