Wish there is an option to easily setup maintain ledger posting along with offsets accounts when calculating annual inflation due to liabilities annual average ledger main accounts and annual average assets debit accounts factor and amounts multiplied by INPC factors.

Wish there is an option to easily calculate Mexico anual tax adjustment due to inflation INPC indicators and as of result of ledger main account average balances.

1. Average annual balance of credits or liabilities
ONLY if the average annual balance is greater then the debt debit annual factor, then the originated result WILL BE a annual tax deductible inflation.

2. Average annual balance of debits or assets.

ADJUSTMENT CALCULATION
(INPC Last month of the fiscal period/INPC of last month)

Annual adjustment for inflation deductible-juste anual por inflacion deducible: Average balance of annual credits or liabilities - minus average annual balance of debts or assets).

Annual adjustment for inflation liabilities: Ajuste anual por inflación acumulable=Average balance of annual debts

AJUSTE ANUAL POR INFLACION ACUMULABLE:
Si el saldo promedio anual de las deudas es mayor que el saldo promedio anual de los créditos. La diferencia entre ambos se deberá multiplicar por el factor de ajuste anual y el resultado se considerará Ajuste Anual por Inflación Acumulable.

AJUSTE ANUAL POR INFLACION DEDUCIBLE
Si el saldo promedio anual de las deudas es menor que el saldo promedio anual de los créditos. La diferencia entre ambos se deberá multiplicar por el factor de ajuste anual y el resultado se considerará Ajuste Anual por Inflación Deducible.

REFERENCE:
Articulo 45 y 46 LISR
Articulo 44
Articulo 18
Fracc. II Art 44 LISR

EXAMPLE:
CREDITS LEDGER MAIN ACCOUNTS:
January:
February:
March:
April:
May:
June:
July:
August:
September:
October:
November:
December:
Total: 438,000

DEBTS LEDGER MAIN ACCOUNTS:
January:
February:
March:
April:
May:
June:
July:
August:
September:
October:
November:
December:
Total: 357,000

Annual average credit balances: 438,000/12=36,500
Annual average debt balance: 357,000/12=29,750
Adjustment factor: (INPC 130.813/INPC 122.515)-1= 0.0677

Annual average deductible inflation: (36,500-29,750) * 0.0677 INPC factor of adjustment = $456.97 deduction for inflation amount.