HubBuyCN: Automate Your Customs Calculations with the HubBuyCN Spreadsheet

Importing products from China to Brazil can be a lucrative venture, but the complexity of calculating customs duties (II), import tax (IPI), state tax (ICMS), and other fees like PIS/COFINS often leads to costly surprises. These unexpected charges can erase profit margins and disrupt your business finances. Manually calculating these fees is time-consuming and prone to error.

That's where the HubBuyCN Spreadsheet

The Problem: The "Tax Surprise" at Brazilian Customs

Without accurate pre-calculation, you only discover the total cost when the goods are already cleared, and payment is required to release them. The main fees include:

Import Duty (II):
Industrialized Products Tax (IPI):
Merchandise and Service Circulation Tax (ICMS):
PIS/COFINS-Importação:

These taxes are cumulative, meaning each is applied on top of the previous one, making manual calculation complex.

The Solution: Automatic Formulas for Clear Predictions

The HubBuyCN Spreadsheet eliminates guesswork by building the official Brazilian tax calculation logic into its formulas. Here’s how it works:

Key Automated Formulas in the Spreadsheet

Product Cost & CIF Value:= (FOB_Price + Shipping_Cost + Insurance)

Import Duty (II) Calculation:= CIF_Value * II_Rate

IPI Calculation:= (CIF_Value + II_Amount) * IPI_Rate

PIS/COFINS Calculation:= CIF_Value * PIS_Rate = CIF_Value * COFINS_Rate

ICMS Calculation (The Critical Formula):= (CIF_Value + II_Amount + IPI_Amount + PIS_Amount + COFINS_Amount + Other_Charges) / (1 - ICMS_Rate) * ICMS_Rate This formula ensures the tax is included correctly in the final cost base.

Total Landed Cost:total cost per itemtotal cost per order.
= CIF_Value + II_Amount + IPI_Amount + PIS_Amount + COFINS_Amount + ICMS_Amount

Benefits of Using the Automated HubBuyCN Spreadsheet

No More Surprises:before
Save Time:
Informed Decision-Making:
Professional Budgeting:
Reduced Risk:

How to Implement It in Your Business

Obtain the Correct NCM Code:
Input Your Variables:
Apply the Tax Rates:
Let the Formulas Work:
Analyze and Decide:

Conclusion

The HubBuyCN Spreadsheet
Disclaimer: While the HubBuyCN Spreadsheet is designed for accuracy based on public tax laws, tax rates and regulations can change. Always consult with a local customs broker or tax consultant for critical decisions.

Ready to find your next haul?
Open the Spreadsheet