Tax Rate Import

Overview

The Tax Rate Import process reads files from the ./Incoming/TaxRates/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/TaxRates/ before being processed in alpha-numeric order.

Keys

  • Tax Rate Id
  • Country Code
  • Tax Rate Type
  • Percentage

Validations

You can update any field if you specify Tax Rate Id. If there is no Tax Rate Id, then Coupa uses the combination of Country Code, Tax Rate Type and Percentage to look up an existing record.

Tax Rate

Field NameRequired FieldUnique?Field TypeField DescriptionPossible Values
Country CodeYesNoThe country code where the tax rate will be applied
Tax Rate TypeYesNoThe type of Tax Rate (ex: VAT, GST)
PercentageYesNodecimal(30,6)Tax Percentage Amount
Tax Rate IDNoNointegerInternal ID of tax rate.
ActiveNoNobooleanDetermines if the tax rate is enabled or disabled
ExemptNoYesbooleanDetermines if the tax rate is exempt or not
Reverse ChargeNoYesbooleanDetermines tax rate is reverse charge or not
Customer AccountingNoNobooleanDetermines if the tax rate is customer accounting
Out of ScopeNoNobooleanDetermines tax rate is out of scope or not
Tax Rate DescriptionNoNostring(255)Tax Rate Description
Effective DateNoNodatetimeThe date when the tax rate will become active
Expiration DateNoNodatetimeThe date when the tax rate will expire