To exclude VAT use the following: to estimate VAT gross amount, divide the gross amount by 1+ VAT percentage, then deduct the gross amount, multiply by -1, and round it off to the closest value.