How to Calculate Costs, Taxes and Import Taxes

Excel Spreadsheets

We all know the difficulties of importing products in Brazil. Not enough unfavorable exchange in many cases, there are still several taxes and import taxes that can make the product arrive here often costing its initial value. This is not to mention the possible delays and losses in the customs process.

As there are many numbers and data to be computed and the variation that this can generate in the final result of the operation is great, we have developed a import cost sheet to assist him at that time. Below, I will demonstrate its operation and structure.

1) Exchange Rate Quotes for the Day

Of course, when it comes to import, one of the costs that will influence its total value is the exchange rate of the day. In the spreadsheet, you can register up to 5 currencies against the Real.

How to Calculate 1 Costs, Taxes and Import Taxes

In this way, you can register the values ​​of the products in local currency and the spreadsheet will automatically convert to the actual value of the merchandise, national and international freight, packaging costs and insurance.

2) Product Description

In this tab, you will enter the name of the merchandise, its NCM (Mercosur Common Nomenclature), the description of the NCM, its unit of measurement, quantity and weight.

How to Calculate 2 Costs, Taxes and Import Taxes

One question that may arise is how to define the Mercosur Common Nomenclature code (NCM), a rule adopted by MERCOSUR member countries since 1995. This code can be posted to the invoice of the merchandise, in accounting books and other documents.

This code has 8 digits, of which the first six represent the SH classification (International classification method, means Harmonized Commodity Description and Coding System) and the other two represent Mercosur specifications.

This is the structure used: 00 00 .00 .00

  • 2 first digits - Chapter: characteristics of the goods
  • 4 first digits - Position: feature scrolling
  • 6 first digits - Subposition: feature splitting
  • Digit 7 - Item: Product classification.
  • Digit 8 - Subitem: description of the goods.

Let's see an example for code 3917.40.90 that includes PVC siphons, light boxes, siphon boxes and a series of other goods

  • Chapter 39: Plastics and articles thereof
  • 3917: Tubes, pipes and hoses, and fittings therefor (for example, joints, elbows, flanges)
  • Subheading 3917.40: Accessories
  • 3917.40.90 Subitem: Other

Knowing this classification is extremely important, because doing this registration in the wrong way can generate problems in identifying the merchandise, change the rate charged. When these cases are identified, your merchandise may even be held at customs or returned to the country of origin.

3) Import Taxes, Costs and Taxes

Here the magic happens. In this tab, you will register the original value of the market, the cost of packaging, internal freight, international freight, insurance and possible additions. All in the currency you think is best.

You will then apply the taxes and duties as the Import Tax (II according to your NCM), Industrialized Product Tax (IPI), PIS, COFINS, SISCOMEX and ICMS. With this data, the worksheet will give you the Customs value and the Total Import Cost

How to Calculate 3 Costs, Taxes and Import Taxes

During this process of establishing the rates and taxes that affect the amounts established so far may raise doubts about the basis of calculation that should be used. Our worksheet already does this automatically, but to help you, I'll list the necessary calculations here:

  • Importation Tax (II) - aliquot varies from 0% to 35% according to the defined NCM and should be levied on the customs value
  • Tax on Industrialized Products (IPI) - to know the rate it is worth consulting the TIPI (Invalidity Table of the IP Tax) - in any way the calculation basis for this tax is the customs value added of the Import Tax
  • PIS and COFINS - as a general rule, we have the rates of 2,1% for the PIS Import and the 9,65% for the COFINS Import relative to the customs value of the merchandise. There are exceptions and, in case of doubt, it is worth consulting the IRS
  • ICMS - The tax on the circulation of goods and services is a state tax, so it will vary according to the destination state of the merchandise. Its calculation base is the (Customs value + II + IPI + PIS + COFINS + Siscomex fee + expenses incurred up to the time of customs clearance) ÷ (1 - ICMS tax rate)

If this worksheet has interested you, make sure to download the free demo version of the product direct on your page: Import Costs Worksheet.


Excel Spreadsheets


  1. Hi Gabriel, in theory does it work, but it is worth doing a test of the demo version to be sure

  2. Good morning,
    Does this sheet count for a company that fits into the presumed profit? or tel any difference?

    I await the reply, thank you


Please, write your comment
Please enter your name