Importing Withholding Tax Transactions Using CSV Import

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 the CSV import feature 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. When a withholding tax transaction is created or updated using CSV import or by a scheduled script, the transaction’s withholding tax is applied on individual line items.

Note:

Before you start the CSV import, you must make sure that withholding tax codes are already set up in NetSuite. For more information, see Setting Up Withholding Tax Codes. To post withholding tax on payments, you must use the user interface.

To add or update transactions with withholding tax:

Go to Setup > Import/Export > CSV Import Preferences.
Check the box to enable Run Server SuiteScript and Trigger Workflows.
Go to Setup > Import/Export > Import CSV Records and follow the steps in the Import Assistant.
In Step 1 (Scan & Upload CSV File):
1. In the Import Type field, select Transactions.
2. In the Record Type field, select an accrual record type (Vendor Bill or Invoice).
3. Make sure the appropriate character encoding format is selected.
4. Choose one file or multiple files to upload.
5. Select the file or files to upload.
6. Click Next.
In Step 2 (Import Options), choose the appropriate data handling option and click Next.
If you are importing multiple files, complete Step 3 (File Mapping) and click Next. If you are importing only one file, the system directs you to Step 4.
In Step 4 (Field Mapping):
1. Provide field mappings 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 unhide these custom columns so they can be mapped during CSV import. To show the custom columns, go to Customization > Lists, Records, & Fields > Transaction Column 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 (by Internal ID)
    - Withholding Tax Rate
    - Withholding Tax Base Amount
    - Withholding Tax Amount
  - Expenses sublist
    - Withholding Tax Code - Expense (by Internal ID)
    - 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
2. Click Next.
In Step 5, you can save your settings and run the import.

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 5% withholding tax. When you add the purchase transaction, the values for the withholding tax amounts will be displayed in the CSV template as follows:

Amount	Withholding Tax Rate	Withholding Tax Base	Withholding Tax Amount
1000.00	5%	1000.00	-50.00

Amount

Withholding Tax Rate

Withholding Tax Base

Withholding Tax Amount

1000.00

-50.00

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. When the sales transaction is entered, the values for the withholding tax amounts will be displayed in the CSV template 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

For more information about importing CSV files, read the following topics:

To add or update transactions with withholding tax:

Related Topics