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

icon picker
Part IV

How to Coda with VAT - Part IV
Below the tables and functions as described in my blog.
⁠
How to Coda with VAT — Part IV
Giving a reduction over the total (VAT incl or excl).
huizer.medium.com
⁠
⁠

Giving a reduction over the total

⁠
⁠
-1000
⁠
→ TB_RedFixOnTotal
VAT Incl
⁠
⁠
EXAMPLE-4
0
Name
db vat
BasePrice
VAT percentage
EndPrice
VAT Distri
part in subset
ReducedBasePrice
VAT
1
€800.00 - 12%
1.3 - Belgium Lower VAT
€800.00
12%
€896.00
13.201%
1
€763.99
2
€800.00 - 0%
1.5 - Belgium Zero VAT
€800.00
0%
€800.00
13.201%
1
€667.99
3
€2,000.00 - 6%
1.4 - Belgium Reduced VAT
€2,000.00
6%
€2,120.00
42.244%
0.78125
€1,789.97
4
€900.00 - 21%
1.2 - Belgium Standard VAT
€900.00
21%
€1,089.00
31.353%
0.47368421052631576
€940.49
5
€500.00 - 6%
1.4 - Belgium Reduced VAT
€500.00
6%
€530.00
42.244%
0.1953125
€447.49
6
€1,000.00 - 21%
1.2 - Belgium Standard VAT
€1,000.00
21%
€1,210.00
31.353%
0.5263157894736842
€1,044.98
7
€60.00 - 6%
1.4 - Belgium Reduced VAT
€60.00
6%
€63.60
42.244%
0.0234375
€53.70
There are no rows in this table
€6,060.00
Sum
€6,708.60
Sum
€5,708.60
Sum
⁠
⁠
Lucky you! You got a reduction of -€1,000.00 on €6,708.60 VAT Incl
⁠
⁠
⁠
0% VAT over €667.99 → €0.00
6% VAT over €2,291.16 → €137.47
12% VAT over €763.99 → €91.68
21% VAT over €1,985.47 → €416.95
⁠
⁠






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.