Tax Code Import

Overview

The Tax Code Import process reads files from the ./Incoming/TaxCodes/ from SFTP.

These files are moved to the archive folder located at ./Archive/Incoming/TaxCodes/ before being processed in alphanumeric order.

You can also load tax codes and rates using the UI CSV file loader on your instance at ./tax_codes.

The Code column is the key column, and must be unique.

Note: Compliance users must also specify standard fields. For example, if specifying Tax Rate Percentage, you still have to specify the same value in Percentage.

Tax Code

Field NameRequired FieldUnique?Field TypeField DescriptionPossible Values
Country CodeYesYesstring(255)The country code where the tax code will be applied
Tax Rate PercentageYesNofloatTax Rate Percentage
Tax Rate Exempt?NoNoUsed to map the tax code to a tax rate and tax rate type. This determines if a tax code is for an exempt tax rate
Tax Rate Reverse Charge?NoNoUsed to map the tax code to a tax rate and tax rate type. This determines if a tax code is for a reverse charge tax rate
Tax Rate Customer Accounting?NoNoUsed to map the tax code to a tax rate and tax rate type. This determines if a tax code is for a customer accounting tax rate
Tax Rate DescriptionNoNostring(255)Used to map the tax code to a tax rate and tax rate type. This corresponds with the tax rate type's description
Tax Rate Out of Scope?NoNoUsed to map the tax code to a tax rate and tax rate type. This determines if a tax code is for an out of scope tax rate
Withholding Tax TypeNoNoWithholding Tax Type
Enterprise NameNoNoName of the enterprise that this tax code belongs to
Supplier NameNoNoUsed to map withholding taxes to a supplier
Code*YesYesstring(255)Tax Code Identifier
Percentage*YesNofloatTax Percentage Amount
DescriptionNoNostring(255)Tax Description
Enforce VAT RulesNoNoIf VAT rules are enforced
ActiveNoNobooleanDetermines if the tax code is enabled or disabled
Effective DateNoNodatetimeThe date when the tax code will become active
Is Withholding?NoNoIs Withholding?
Subtract from GrossNoNoWithhold from Supplier?
Is TCS?NoNoIs Tax Collected at Source?
Withholding Tax Amount OverwritableNoNobooleanWithholding Tax Amount Overwritable