Sending VAT and currency information with exchange rate

2014-10-21
Example: Sending VAT and currency information with exchange
rate.
Contents
1.
2.
3.
4.
Example description ............................................................................................ 1
Information to exchange. ..................................................................................... 2
EDIFACT ............................................................................................................. 4
Summary EDIFACT ............................................................................................. 7
1. Example description
The example below shows how the invoice is completed under the following
conditions:




The invoice is raised in Euros.
The seller’s bookkeeping currency is Swedish Crowns.
Part of the invoice relates to goods with a VAT rate of 12% (food rate VAT)
- Total net amount = 100 (Euro)
Part of the invoice relates to goods with a VAT rate of 25 % (standard rate
VAT)
- Total net amount = 200 (Euro)
Example: Sending VAT and currency information with exchange rate.
1
2014-10-21
2. Information to exchange.
This part of the example shows the information to be exchanged according to GS1
Sweden’s business document specifications for invoice, that is:





ADS 6.1.6 (ESAP 6)
ADS 20.1.6 (ESAP 20)
ADS 9.2.1 (ESAP 9.2)
ADS 9.1.1 (ESAP 9.1)
ADS 26.1.1 (Transport flow)
Only terms and values that are relevant for the example are shown in the table.
Term-id
Term name
Example Comments
INVOICE HEADER
CURRENCY CALCULATION
T0283
Rate of exchange
9.23
Exchange rate as of 2014-10-21.
T0204
Currency, code
EUR
Code from ISO 4217
T0286
VAT currency
SEK
Code from ISO 4217
INVOICE SUMMARY
SUMMARY, VALUE-ADDED TAX (for food)
T0194
Tax type code
VAT
T0195
Tax rate
12
12%
T0197
Tax category
M
Food
T0180
Taxable amount
100
Currency is Euros, according to T2204 in the invoice header.
T2022
Total tax amount
12
Currency is Euros, according to T2204 in the invoice header.
VALUE-ADDED TAX CURRENCY
T0194
Tax type code
VAT
T0195
Tax rate
12
12%
T0197
Tax category
M
Food
Example: Sending VAT and currency information with exchange rate.
2
2014-10-21
T0284
Value added tax currency,
110.76
Currency is Swedish Crowns, according to T0286 in the
invoice header.
amount
VAT amount in bookkeeping currency: T2022xT0283
12 euro x 9.23=110.76
SUMMARY, VALUE-ADDED TAX (for standard rate VAT)
T0194
Tax type code
VAT
T0195
Tax rate
25
25%
T0197
Tax category
S
Standard
T0180
Taxable amount
200
Currency is Euros, according to T2204 in the invoice header.
T2022
Total tax amount
50
Currency is Euros, according to T2204 in the invoice header.
VALUE-ADDED TAX CURRENCY
T0194
Tax type code
VAT
T0195
Tax rate
25
25%
T0197
Tax category
S
Standard
T0284
VAT amount in VAT currency 461.5
Currency is Swedish Crowns, according to T0286 in the
invoice header.
VAT amount in bookkeeping currency: T2022xT0283
50 euro x 9.23=461.5
Example: Sending VAT and currency information with exchange rate.
3
2014-10-21
3. EDIFACT
This part of the example shows how the information is represented in EDIFACTsyntax, i.e. how the VAT and currency information with exchange rate is transferred
in the various EDIFACT segments.
Only those parts that are relevant to the example are shown.
Invoice header
SG7
CUX
C504
6347
6345
6343
C504
6347
6345
6343
5402
Invoicing currency
Invoicing currency
Currency details qualifier
Currency, coded
Currency qualifier
VAT currency
Currency details qualifier
Currency, coded
Currency qualifier
C
M
C
M
C
C
C
M
C
C
Rate of exchange
C n..12
R
an..3
an..3
an..3
an..3
an..3
an..3
R
R
R
R
R
2
Reference currency
4
Invoicing currency
3
Target currency
T0204 Currency, code
T0286 VAT currency
10E
Currency for value added tax
purposes (EAN Code)
T0283 Rate of exchange
EDIFACT string: CUX+2:EUR:4+3:SEK:10E+9.23'
Invoice summary
Information regarding food (VAT rate 12%):
SG50
TAX
5283
C241
5153
C533
5289
5286
C243
5279
1131
3055
5278
5305
Summary, value-added tax
Duty/tax/fee function qualifier
Duty/tax/fee type
Duty/tax/fee type, coded
Duty/tax/fee account detail
Duty/tax/fee account identification
Duty/tax/fee assessment basis
Duty/tax/fee detail
Duty/tax/fee rate identification
Code list qualifier
Code list responsible agency, coded
Duty/tax/fee rate
Duty/tax/fee category, coded
C
M
M
C
C
C
M
C
C
C
C
C
C
C
R
an..3
an..3
7
Tax
R
R
N
T0194 Tax type code
an..6
an..15 N
an..7
an..3
an..3
an..17
an..3
N
N
N
R
R
T0195 Tax rate
T0197 Tax category
EDIFACT string: TAX+7+VAT+++:::12+M'
SG50
MOA
C516
5025
5004
Taxable amount
Monetary amount
Monetary amount type qualifier
Monetary amount
C
C
M
M an..3
C n..18
R
R
125
Taxable amount
R
T0180 Taxable amount
EDIFACT string: MOA+125:100'
SG50
MOA
C516
5025
5004
Total tax amount
Monetary amount
Monetary amount type qualifier
Monetary amount
C
C
M
M an..3
C n..18
R
124
Tax amount
R
T2022 Total tax amount
EDIFACT string: MOA+124:12'
Example: Sending VAT and currency information with exchange rate.
4
2014-10-21
SG50
TAX
5283
C241
5153
C533
5289
5286
C243
5279
1131
3055
5278
5305
Value-added tax currency
Duty/tax/fee function qualifier
Duty/tax/fee type
Duty/tax/fee type, coded
Duty/tax/fee account detail
Duty/tax/fee account identification
Duty/tax/fee assessment basis
Duty/tax/fee detail
Duty/tax/fee rate identification
Code list qualifier
Code list responsible agency, coded
Duty/tax/fee rate
Duty/tax/fee category, coded
C
M
M
C
C
C
M
C
C
C
C
C
C
C
an..3
an..3
7
Tax
R
R
N
T0194 Tax type code
an..6
an..15 N
R
an..7 N
an..3 N
an..3 N
an..17 R
an..3 R
T0195 Tax rate
T0197 Tax category
EDIFACT string: TAX+7+VAT+++:::12+M'
SG50
MOA
C516
5025
5004
Value-added tax currency, amount
Monetary amount
Monetary amount type qualifier
Monetary amount
C
C
M
M an..3
C n..18
150
Value added tax
R
T0284 Value added tax currency, amount
EDIFACT string: MOA+150: 110.76'
Invoice summary
Information regarding standard VAT (VAT rate 25%):
SG50
TAX
5283
C241
5153
C533
5289
5286
C243
5279
1131
3055
5278
5305
Summary, value-added tax
Duty/tax/fee function qualifier
Duty/tax/fee type
Duty/tax/fee type, coded
Duty/tax/fee account detail
Duty/tax/fee account identification
Duty/tax/fee assessment basis
Duty/tax/fee detail
Duty/tax/fee rate identification
Code list qualifier
Code list responsible agency, coded
Duty/tax/fee rate
Duty/tax/fee category, coded
C
M
M
C
C
C
M
C
C
C
C
C
C
C
an..3
an..3
7
Tax
R
R
N
T0194 Tax type code
an..6
an..15 N
R
an..7 N
an..3 N
an..3 N
an..17 R
an..3 R
T0195 Tax rate
T0197 Tax category
EDIFACT string: TAX+7+VAT+++:::25+S'
SG50
MOA
C516
5025
5004
Taxable amount
Monetary amount
Monetary amount type qualifier
Monetary amount
C
C
M
M an..3
C n..18
R
R
125
Taxable amount
R
T0180 Taxable amount
EDIFACT string: MOA+125:200'
SG50
MOA
C516
5025
5004
Total tax amount
Monetary amount
Monetary amount type qualifier
Monetary amount
C
C
M
M an..3
C n..18
R
124
Tax amount
R
T2022 Total tax amount
EDIFACT string: MOA+124:50'
Example: Sending VAT and currency information with exchange rate.
5
2014-10-21
SG50
TAX
5283
C241
5153
C533
5289
5286
C243
5279
1131
3055
5278
5305
C
M
M
C
C
C
M
C
C
C
C
C
C
C
Value-added tax currency
Duty/tax/fee function qualifier
Duty/tax/fee type
Duty/tax/fee type, coded
Duty/tax/fee account detail
Duty/tax/fee account identification
Duty/tax/fee assessment basis
Duty/tax/fee detail
Duty/tax/fee rate identification
Code list qualifier
Code list responsible agency, coded
Duty/tax/fee rate
Duty/tax/fee category, coded
an..3
an..3
7
Tax
R
R
N
T0194 Tax type code
an..6
an..15 N
R
an..7 N
an..3 N
an..3 N
an..17 R
an..3 R
T0195 Tax rate
T0197 Tax category
EDIFACT string: TAX+7+VAT+++:::25+S'
SG50
MOA
C516
5025
5004
Value added tax currency, amount
Monetary amount
Monetary amount type qualifier
Monetary amount
C
C
M
M an..3
C n..18
150
Value added tax
R
T0284 Value added tax currency, amount
EDIFACT string: MOA+150: 461.5'
Example: Sending VAT and currency information with exchange rate.
6
2014-10-21
4. Summary EDIFACT
A summary of the EDIFACT strings are shown below.
UNB……….
UNH…………
….
….
NAD…
NAD…
….
….
CUX+2:EUR:4+3:SEK:10E+9.23'
….
LIN…….
LIN…….
….
UNS+S’
….
….
TAX+7+VAT+++:::12+M’
MOA+125:100'
MOA+124:12'
TAX+7+VAT+++:::12+M'
MOA+150: 110.76'
TAX+7+VAT+++:::25+S'
MOA+125:200'
MOA+124:50'
TAX+7+VAT+++:::25+S'
MOA+150: 461.5'
….
….
UNT
UNZ
Example: Sending VAT and currency information with exchange rate.
7

Download Report