Articles in this section

Tax codes template

The following table lists the fields in the tax codes template. All values input to the template are case sensitive. The maximum file size allowed is 20 MB.

Field Display Name isMandatory? Description Field data type Level Value Display Names
Active Yes

Indicates if the tax code is active or inactive.

If an active tax code becomes inactive:

  • It is removed from bills pending internal or payee approval/ invoice. The bills are sent back to AP so that a new tax code can be assigned.

  • Bills in a "Pending Payment" status or later remain unaffected.

  • It is removed from bills in any other status.

 List Header

  • Yes

  • No
Business posting group No

‘Business posting group’ is concatenated with ‘Product posting group’.

The concatenated value populates the External ID header (which must remain empty to be populated)

 String Header  
External ID Yes The tax code identifier in your accounting system/ ERP String Header  
Name Yes

The name of the tax code (e.g., VAT-UK).

If you change the name of an existing tax code, it is changed on all bills linked to the tax code.

Bill status is not affected.

 String Header  
Payer entities No

List of payer entities for which each Tax code should apply.

To apply the Tax code to all payer entities use '[]' (you can use the 'default when empty' capability for doing so).

 String Header  
Product posting group No

‘Business posting group’ is concatenated with ‘Product posting group’.

The concatenated value populates the External ID header (which must remain empty to be populated)

 String Header  
Rate Yes

The rate of the tax code (e.g., 20.0 for 20% tax)

If the rate of an existing tax code is changed:

  • Bills in a status earlier than "Pending Payment" are updated.

  • Bills in status "Pending Payment" or later remain unaffected.

 Decimal Header