Should I exclude or ddd VAT for COGS?
Overall there are two options:
1) Add VAT on Top of Manual COGS:
This option would use the COGS VAT percentage to add additional VAT on top of the COGS total.
The calculation would be:
" Multiply the net amount by 1 + VAT percentage (i.e. multiply by 1.15 if VAT is 15%) and you'll get the gross amount. Or multiply by VAT percentage to get the VAT value."
2) Exclude VAT from Manual COGS:
This option would exclude the use of the COGS VAT percentage to remove VAT from the COGS total.
The exact calculation would be:
"VAT calculation formula for VAT exclusion is the following: to calculate VAT having the gross amount you should divide the gross amount by 1 + VAT percentage (i.e. if it is 15%, then you should divide by 1.15), then subtract the gross amount, multiply by -1 and round to the closest value (including eurocents). The last two operations are not mandatory since you see the VAT value even before you do them."