Add VAT to a net price
Multiply the taxable base by the rate and add the tax. On COP 100,000 at 19%, VAT is COP 19,000 and the total is COP 119,000; at 5%, VAT is COP 5,000 and the total is COP 105,000.
VAT = Base × Rate | Total = Base + VAT
FREE TOOL
Calculate sales tax in Colombian pesos and separate the taxable base, VAT, and total.
Amount in Colombian pesos (COP).
Choose the statutory rate for the good, service, and transaction.
Enter an amount to see the taxable base, VAT, and total.
Indicate whether you start from the taxable base or a final price. Then choose the statutory rate for the good or service.
Use the taxable base to add VAT or the amount paid to extract it.
19% is general. 5% and 0% apply only to goods and services defined by the Tax Code.
The calculator separates the taxable base, VAT, and total in COP.
Multiply the taxable base by the rate and add the tax. On COP 100,000 at 19%, VAT is COP 19,000 and the total is COP 119,000; at 5%, VAT is COP 5,000 and the total is COP 105,000.
VAT = Base × Rate | Total = Base + VAT
Divide the total by 1.19 for the general rate or 1.05 for the reduced rate. The difference is included VAT.
Base = Total ÷ (1 + Rate) | VAT = Total − Base
VAT in Colombia is calculated on the taxable base (Tax Code article 447), not on the final total. Subtracting 19% directly from COP 119,000 gives COP 96,390 instead of the true COP 100,000 base. Dividing by 1.19 recovers the exact base and shows that included tax represents 15.97% of the total price (19 ÷ 119), or 4.76% at the 5% rate.
Common COP examples for pre-tax quotes or checking included VAT on invoices and retail prices.
| Rate | Taxable base | VAT | Total incl. VAT | VAT share of total |
|---|---|---|---|---|
| 19% | COP 10,000 | COP 1,900 | COP 11,900 | 15.97% |
| 19% | COP 50,000 | COP 9,500 | COP 59,500 | 15.97% |
| 19% | COP 100,000 | COP 19,000 | COP 119,000 | 15.97% |
| 19% | COP 500,000 | COP 95,000 | COP 595,000 | 15.97% |
| 19% | COP 1,000,000 | COP 190,000 | COP 1,190,000 | 15.97% |
| 5% | COP 50,000 | COP 2,500 | COP 52,500 | 4.76% |
| 5% | COP 100,000 | COP 5,000 | COP 105,000 | 4.76% |
| 5% | COP 500,000 | COP 25,000 | COP 525,000 | 4.76% |
The general rate is 19%. The Tax Code contains specific lists for 5%, zero-rated exempt goods, and excluded transactions that do not trigger VAT.
19%
Applies to taxable goods and services without a special rate, exemption, or exclusion under the law.
Example: ordinary sales of clothing, accessories, appliances, or taxable professional services.
5%
Only applies to expressly listed goods and services, such as roasted coffee, sugar, wheat flour, pasta, prepaid healthcare, and agricultural insurance.
Example: COP 50,000 base of roasted coffee adds COP 2,500 VAT for a COP 52,500 total.
0%
Exempt goods are taxed at 0% (such as fresh meat, eggs, milk, books, and exports) and allow producers or exporters to credit or request a refund for input VAT paid on costs.
Example: an exempt export bills COP 0 VAT while keeping input tax credit rights under the law.
National consumption tax (restaurants and bars), ReteIVA, income tax withholding (retención en la fuente), and municipal ICA are not included. They use different taxable events, responsible parties, and bases.
When quoting, issuing e-invoices, or settling supplier payments in Colombia, five practical rules determine the real net payout and tax return figures.
For the buyer, neither adds VAT at checkout, but for the seller the difference is critical. Exempt goods (Tax Code arts. 477 and 481) carry a 0% rate and make the seller a VAT-responsible taxpayer entitled to credit or refund input VAT on purchases. Excluded goods and services (arts. 424 and 476, such as education, healthcare, public transit, and fresh produce) do not trigger VAT, so input VAT on costs becomes an expense.
Practical difference: sellers of only excluded goods do not collect or file VAT; producers of exempt goods file returns to recover VAT paid on inputs.
This calculator separates taxable base, VAT, and invoiced total before withholdings. When the buyer is a withholding agent and thresholds apply, two distinct withholdings can reduce the payout: ReteIVA (generally 15% of the VAT amount under Tax Code art. 437-1, or 100% in special cases such as foreign services under art. 437-2) and income tax withholding (calculated on the pre-VAT taxable base depending on purchases, services, or fees).
Example on COP 1,000,000 base + COP 190,000 VAT (COP 1,190,000 total): 15% ReteIVA on the tax equals COP 28,500 (190,000 × 15%). With a 2.5% purchase withholding on the base (COP 25,000), net payment to the supplier is COP 1,190,000 − COP 28,500 − COP 25,000 = COP 1,136,500.
Under Tax Code article 447, the taxable base covers the full transaction value plus freight, shipping, installation, insurance, commissions, and financing fees charged to the buyer, even if billed separately. Under article 454, unconditional on-invoice trade discounts reduce the taxable base before calculating VAT; conditional discounts (such as early-payment discounts) do not reduce the base at invoicing.
Example: on a COP 1,000,000 sale with an unconditional 10% invoice discount (COP 100,000), 19% VAT applies to COP 900,000 (COP 171,000 VAT), not COP 1,000,000.
Article 26 of Law 1480 of 2011 (Consumer Statute) requires retail prices displayed to consumers in stores, menus, or online shops to include all taxes. When issuing a DIAN electronic invoice (Tax Code art. 617 and technical rules), the taxable base, rate, and VAT amount must be itemized separately so VAT-responsible buyers can claim input VAT credits.
Store example: if an item is listed at COP 119,000 to the public, use Extract VAT to record COP 100,000 base and COP 19,000 VAT on the invoice.
Colombian pesos operate without cents in everyday billing; when extracting VAT from a total, the tool rounds the base to whole pesos and derives VAT by difference so both add up exactly to the total. Decree 1625 of 2016 (art. 1.3.1.1.1) also allows rounding charged VAT to the nearest COP 10. Non-responsible sellers do not charge or itemize VAT, while responsible taxpayers file bimonthly or every four months depending on prior-year revenue.
Peso rounding example: on COP 10,000 with 19% VAT included, 10,000 ÷ 1.19 gives COP 8,403 base and COP 1,597 VAT, summing to COP 10,000.
The general rate is 19% (Tax Code article 468). The 5% reduced rate and 0% exempt treatment only apply when a good or service is expressly listed in articles 468-1, 468-3, 477, or 481.
Those listed in Tax Code articles 468-1 and 468-3, including roasted coffee, sugar, wheat flour, pasta, chocolate, certain agricultural goods, electric vehicles, and prepaid healthcare.
At 19%, divide the total by 1.19; at 5%, divide by 1.05. Subtract the resulting base from the final price to find the included VAT.
Because 19% is calculated on the taxable base, not the total. Subtracting 19% from COP 119,000 yields COP 96,390, whereas the true base is COP 100,000 (119,000 ÷ 1.19). Always divide by 1 plus the rate.
In a price with 19% VAT included, the tax equals 15.97% of the total (19 ÷ 119). At the 5% rate, included VAT represents 4.76% of the final price (5 ÷ 105).
No. An exempt good is taxed at 0% and allows producers or exporters to credit or refund input VAT; an excluded good does not trigger VAT, so the seller absorbs input VAT as a cost.
ReteIVA is calculated on the VAT amount, not the taxable base. Generally it equals 15% of VAT (Tax Code art. 437-1): on COP 190,000 VAT, ReteIVA is COP 28,500 and reduces the supplier payout.
VAT is the sales tax (19% or 5% on the base); ReteIVA is a withholding applied to that VAT (typically 15% of the tax); and retención en la fuente is an advance income tax withholding calculated on the pre-VAT taxable base.
Yes: under Colombia's Consumer Statute, prices displayed to end consumers must include all taxes. On a DIAN electronic invoice, however, the system must itemize the taxable base, rate, and VAT separately.
VAT-responsible taxpayers file bimonthly or every four months depending on prior-year gross income, offsetting output VAT collected on sales against creditable input VAT paid on valid purchases.
This calculator is for guidance. The applicable rate may depend on the good, service, taxpayer, and tax treatment. Check your case with DIAN or a professional before issuing an invoice or filing a return.
By Carla PalmieriUpdated
Your store and operations, together.Everything you need to sell online, in one place.