The **calculating taxes** It is a somewhat complicated but not impossible task, because although in general in all countries it is calculated in a similar way if we focus on **Mexico** To make the calculation there are several taxes that are all different and it is even a country whose fiscal program is always being modified.

For this reason it is important that you stay with the latest update to be able to make a good calculation including those that correspond to the import in Mexico, how the deduction is considered and there is nothing better than having an example of the Excel rif.

Then you should keep reading and pay attention to the following information:

## Ways to do the tax calculation

To do the **calculating taxes** considering the constant updates and new taxes that can cause problems when calculating taxes …

- You should always have the latest information with you so that you can make an exact calculation without errors.
- Although it is an operation that you can carry out yourself, many times it can lead to an error that you correct by resorting to a tax specialist or the collecting body.
- You should also know that although as a taxpayer it is customary to present your returns in a timely manner, there may be a delay in filing and you have time to regularize, as a 1.13% surcharge per month is established by law to which is added the inflation adjustment for that month.
- This percentage of surcharge for lateness is published by the Ministry of Finance and Public Credit of Mexico.
- 1.13% is the late payment surcharge from 2004 to 2017.
- 0.75% is the surcharge for the extension also from 2004 to 2017.
- The updating of the contributions and the payment of the surcharges correspond to the legal entities and individuals who do not make the payment for uses, products or contributions within the term established by the tax provisions.
- To calculate the update, a division is made between the INPC of the previous month to which the contributions will be paid and the INPC of the previous month that was not paid, then the amount owed is multiplied by the update factor.

### How to calculate taxes?

You already know important considerations about calculating taxes, but now you should know **how to calculate taxes**, then you will know it with a step by step:

**Step 1**: First of all, you must access the official site of the SAT: http://losimpuestos.com.mx/calcular-impuestos/

**Step 2**: The SAT provides you with a calculator to make the calculation easier for you, because immediately you will find the calculator for calculating VAT and ISR withholdings.

**Step 3**: In the blank fields you must enter the amount, the corresponding VAT%, the ISR withheld, the VAT withheld and you will get the result.

**Step 4**: The Secretariat of Disclosure and Editorial Development of the Faculty of Accounting and Administration manages the Tax Office and provides you with a calculator with which you can also calculate taxes.

With the calculator you can calculate the income tax for the retention of workers according to the income of a monthly, biweekly or weekly period.

- Login to
**http://consultoriofiscal.unam.mx/content.php?id_categoria=4** - Then you must indicate the income for the period, the lower limit, the excess of the lower limit, the percentage of the excess of the lower limit, the fixed tax rate, the determined income tax and the employment subsidy.

Then you will indicate if it is monthly, weekly or biweekly and click on Calculate.

**How to do the RIF Excel tax calculation?**

- To do the
**tax calculation rif Excel**You can be guided by the following example of course by opening a new Excel sheet: - In the Excel sheet you must consider the sales paid and invoiced.
- You will add the income to the public together with the invoiced and you will apply the factor with a division of the sales invoiced by the total sales.
- The factor is applicable to
**VAT paid**and you will get the**Creditable VAT**. - To calculate the income tax, you will accumulate the income for the two-month period with the deductions for the two-month period accumulated and you will subtract the deductions from the income to obtain profit or loss for that two-month period.
- You will apply the LISR table, article 96 to the utility, following this process: taxable base – lower limit = surplus.
- To the surplus you will apply the% according to the range = marginal tax + fixed fee = bimonthly ISR.
- From the result you will subtract 90% as a benefit for the RIF = bimonthly tax.

**Step 1**: Open a new Excel spreadsheet to calculate the RIF. In column A row 1 put Bimestres, use columns B, C, D, E, F, etc. for Income, Row 2 entering 1, 2, 3, 4, 5, 6, etc. as corresponds to the bimesters.

**Step 2**: Under Income, enter Deductions and enter the deductions below each corresponding income.

**Step 3**: Under Deductions, place Deductions for tax loss and enter the corresponding values according to the two-month period.

**Step 4**: Under Deductions for tax loss, place paid PTU and enter the values that correspond to each two-month period.

**Step 5**: Under PTU Paid, place Tax Profit / Loss and enter the values that correspond to each two-month period.

**Step 6**: Leave a blank row and in the next one place Lower limit and place the corresponding values below each two-month period.

**Step 7**: Below Lower Limit places Surplus and the corresponding values below each two-month period.

**Step 8**: Under Surplus, place Rate and the values that correspond to each two-month period.

**Step 9**: Under Rate, place Marginal Tax and the values below each two-month period.

**Step 10**: Under Marginal Tax, place Fixed Fee and the values under each corresponding two-month period.

**Step 11**: Under Fixed Fee, place ISR for the period and the corresponding values below each two-month period.

**Step 12**: Under ISR for the period, place% discount and place the corresponding percentages for each two-month period.

**Step 13**: Finally, place under% discount ISR in charge and you will obtain under each two-month column the value of ISR in charge.

**How to calculate the Mexican import taxes?**

For him **Mexico import tax calculation** keep the following in mind:

- When expressed in percentage terms (Ad valorem), you must multiply the taxable base by the tariff that is expressed in%, which can be from 3 to 75% or even exempt.
- When expressed in monetary terms ($), you must multiply the quantity of the units of measure, either the one marked by the tariff or the tariff by the specific tariff.
- Both terms can be combined in which case it will be mixed and you will multiply the taxable base by the tariff that is expressed in% and you will obtain Ad valorem as a result
- If you multiply the amount of the unit of measure that marks the tariff or the tariff by the specific tariff in $ you get in Specific term.

**What are the taxes paid in Mexico? **

You want to know **What are the taxes paid in Mexico?**, since there are 3 categories: municipal taxes, federal taxes and state taxes.

**What is the tax deduction? **

**What is the tax deduction?**Well, when you file your annual return you can deduct tuition and medical expenses as personal expenses, after which you reduce the tax base and your annual tax will have been reduced and the treasury can return a difference to you.