NOTE For general information on using imports, see Imports FAQ.
The following tables lists the format for importing a VAT class in VAT Class Import.
|
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
|
A |
1 |
Country Code |
10 |
Character |
Yes |
Enter a valid country code for the VAT class code. You can only enter a country if VAT is enabled for the country. For information on setting up country codes, see Country Maintenance. |
|
B |
2 |
VAT Class Code |
30 |
Character |
Yes |
Enter a VAT class code. |
|
C |
3 |
VAT Class Name |
30 |
Character |
Yes |
Enter a name for the VAT class. |
|
D |
4 |
Description |
60 |
Character |
No |
Enter a description of the VAT class. |
|
E |
5 |
Active |
3 |
Yes/No |
No |
Enter No if the VAT class is inactive. If this field is blank, it defaults to Yes. |
|
F |
6 |
VAT Exempt Reason Code |
20 |
Character |
No |
Enter a VAT exempt reason code associated with the VAT class code. For information on setting up VAT exempt reason codes, see VAT Exempt Reason Maintenance. |
|
G |
7 |
VAT Rate |
12 |
>,>>>,>>9.99 |
Yes |
Enter a taxation rate percentage for the VAT class code. |
|
H |
8 |
Effective Date |
10 |
99/99/9999 |
No |
Enter the first date for which to use the entered VAT rate. If a VAT rate was previously set up for the VAT class, it will expire the day before this date. |
|
I |
9 |
Input VAT Clearing |
29 |
Character |
No |
Enter all or part of the input VAT clearing general ledger account to use when resolving the account from the VAT class. For more information on input VAT clearing accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the VAT class. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
|
J |
10 |
Input VAT |
29 |
Character |
No |
Enter all or part of the input VAT general ledger account to use when resolving the account from the VAT class. For more information on input VAT accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the VAT class. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
|
K |
11 |
Input VAT Write-off |
29 |
Character |
No |
Enter all or part of the input VAT write-off general ledger account to use when resolving the account from the VAT class. For more information on input VAT write-off accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the VAT class. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
|
L |
12 |
Input VAT Pending |
29 |
Character |
No |
Enter all or part of the input VAT pending general ledger account to use when resolving the account from the VAT class. For more information on input VAT pending accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the VAT class. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
|
M |
13 |
Output VAT |
29 |
Character |
No |
Enter all or part of the output VAT general ledger account to use when resolving the account from the VAT class. For more information on output VAT accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the VAT class. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
|
N |
14 |
Output VAT Variance |
29 |
Character |
No |
Enter all or part of the output VAT variance general ledger account to use when resolving the account from the VAT class. For more information on output VAT variance accounts, see VAT Account Resolution. Note You can enter asterisks (*) for account elements you do not want to resolve from the VAT class. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks. |
|
O |
15 |
Default Input VAT Class |
3 |
Yes/No |
No |
Enter Yes if the VAT class code is the default input VAT class code for the country. You can only enter Yes for this field if you enter Yes for the Active field (position 5). If this field is blank, it default to No. |
|
P |
16 |
Default Output VAT Class |
3 |
Yes/No |
No |
Enter Yes if the VAT class code is the default output VAT class code for the country. You can only enter Yes for this field if you enter Yes for the Active field (position 5). If this field is blank, it default to No. |
Before using this import, the following must be set up:
countries