Skip to content
Gallery
Doc 02 | How to Coda with VAT?
How to Coda with VAT?
Databases
Share
Explore
How to Coda with VAT?

icon picker
Part VII

How to Coda with VAT - Part VII
⁠
Loading
huizer.medium.com
⁠
⁠
To obtain a proper VAT Tariff you check a few variables to catch 90% of your issues. What you do not catch are the product based exceptions.
Get the client country to understand
client country is EU member state
client country is (not) the same as the suppliers country
client is
@Business
⁠
or
@Residential
⁠
when
@Residential
⁠
and EU member state, apply the VAT tarif of the home country
when
@Business
⁠
, EU member state and the country is not the same as the home country, shift VAT (0%)
when
@Business
⁠
and client country is the same as the supplier country, apply the country VAT tarif (like
@Residential
⁠
).

Example-7
VAT perc
DB Products
DB Providers
DB Clients
EU Memberstate
Client Country
Client Type
Residential - EU
VAT Type
6%
Belgium
Belgium
Residential
6%
Reduced VAT
21%
Belgium
Belgium
Business
[  ]
Standard VAT
0%
The Netherlands
The Netherlands
Residential
0%
Zero VAT
9%
The Netherlands
The Netherlands
Business
[  ]
Reduced VAT
19.6%
France
France
Residential
19.6%
Standard VAT
19.6%
France
France
Residential
Reduced VAT
21%
United States and Canada
Residential
[  ]
Standard VAT
0%
United States and Canada
Business
[  ]
Standard VAT
There are no rows in this table
⁠

⁠
SwitchIf(
thisRow.[Client Country].[EU Memberstate].IsBlank() andthisRow.[Client Type].Contains(Business),
[DB VAT].Filter(ClientCountry.Contains( thisRow.[DB Providers].Country)).Sort().Last().[VAT percentage],
thisRow.[Client Country].[EU Memberstate].IsBlank() andthisRow.[Client Type].Contains(Residential),
[DB VAT].Filter(ClientCountry.Contains(thisRow.[DB Providers].Country) and thisRow.[DB Products].[VAT Type].Contains([VAT Type])).[VAT percentage],
thisRow.[Client Type].Contains(Residential) Or thisRow.[Client Country].Contains(thisRow.[DB Providers].Country),[DB VAT].Filter(ClientCountry.Contains(thisRow.[DB Clients].countries) and [VAT Type].Contains(thisRow.[DB Products].[VAT Type]) and thisRow.[EU Memberstate].IsNotBlank()).[VAT percentage],
[DB VAT].Filter(ClientCountry.Contains(thisRow.[DB Clients].countries) and thisRow.[EU Memberstate].IsNotBlank() and thisRow.[Client Type].Contains(Business)).[VAT percentage].Sort().First()).IfBlank([DB VAT].Filter(ClientCountry.Contains(thisRow.[DB Clients].countries) and [VAT Type].Contains(thisRow.[DB Products].[VAT Type]) and thisRow.[Client Type].Contains(Residential) and
thisRow.[Client Country].[EU Memberstate].IsNotBlank()).[VAT percentage].
IfBlank([DB VAT].Filter(ClientCountry.Contains(thisRow.[DB Clients].countries)).Sort().First().[VAT percentage]))


Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.