latam-payroll

n8n node for LATAM + Spain payroll calculations - Real AFPs, progressive ISR/IRPF, vacation, bonus, severance with 2024 data

Package Information

Downloads: 2 weeklyΒ /Β 73 monthly
Latest Version: 2.1.1
Author: Manuel Reyes Bravo

Documentation

n8n-nodes-latam-payroll

LATAM Payroll
n8n
Version
License

n8n node for Latin America and Spain payroll calculations with real 2024 data. 100% free, no credentials required.

πŸš€ What's New in v2.0.0?

  • βœ… Real AFPs/Pension funds with exact commission rates
  • βœ… Progressive ISR/IRPF/IR tables 2024 for all countries
  • βœ… Proportional days calculation (worked 15 of 30 days)
  • βœ… Non-taxable bonuses configurable
  • βœ… Real employer cost with employer contributions
  • βœ… Reverse calculation: "I want to pay X net, how much gross?"

🌎 Supported Countries

πŸ‡¨πŸ‡± Chile

Feature Detail
Real AFPs Modelo (0.58%), Uno (0.49%), Habitat (1.27%), PlanVital (1.16%), Capital (1.44%), Cuprum (1.44%), ProVida (1.45%)
Caps 81.6 UF AFP, 126.6 UF unemployment
Proportional days Calculation by days worked
Bonuses Meal, transportation, other non-taxable
Employer cost Includes 2.4% employer unemployment

πŸ‡²πŸ‡½ Mexico

Feature Detail
ISR 2024 11 progressive brackets (5% - 35%)
Employment subsidy 11 ranges per official table
UMA 2024 $108.57 daily / $3,300.14 monthly
Border zone Differentiated minimum wage
Bonuses Food vouchers (40% UMA exempt), transport

πŸ‡¦πŸ‡· Argentina

Feature Detail
Income tax 2024 9 progressive brackets (5% - 35%)
MNI $3,091,035 monthly exempt
Deductions $78,833 per child
Health insurance Configurable by agreement (default 3%)
Union dues Configurable (default 2%)

πŸ‡¨πŸ‡΄ Colombia

Feature Detail
Withholding tax 7 brackets per UVT ($47,065)
Transport allowance $162,000 if salary ≀ 2 SMMLV
Solidarity fund 1% if salary > 4 SMMLV
SMMLV 2024 $1,300,000
Employer cost 12% pension + 8.5% health + ARL + parafiscals

πŸ‡΅πŸ‡ͺ Peru

Feature Detail
Real AFPs Habitat (1.47%), Integra (1.55%), Prima (1.60%), Profuturo (1.69%)
ONP Public system 13%
5th category Exempt up to 7 UIT ($36,050)
Family allowance 10% RMV if has children
EsSalud 9% employer contribution

πŸ‡§πŸ‡· Brazil

Feature Detail
INSS 2024 4 progressive brackets (7.5% - 14%), cap R$908.85
IRRF 2024 5 brackets with deductions
Dependents R$189.59 deduction per dependent
Transport voucher 6% discount if opted
Employer cost FGTS 8% + charges ~20%

πŸ‡ͺπŸ‡¨ Ecuador

Feature Detail
IR 2024 10 progressive brackets
SBU 2024 $460
Reserve funds 8.33% monthly or accumulated
IESS employee 9.45%
IESS employer 11.15%

πŸ‡ͺπŸ‡Έ Spain

Feature Detail
IRPF 2024 6 progressive brackets (19% - 47%)
SS bases Min €1,323 / Max €4,720.50
Payments 12 or 14 payments configurable
Family minimum Reduction for children
SMI 2024 €1,134/month (14 payments)

πŸ“¦ Installation

In n8n (recommended)

  1. Go to Settings β†’ Community Nodes
  2. Click Install
  3. Type: n8n-nodes-latam-payroll
  4. Click Install

Via npm

npm install n8n-nodes-latam-payroll

πŸ“‹ Usage Examples

Calculate net salary Chile (with real AFP)

Country: Chile
Operation: Net Salary
Gross Salary: 1,500,000
AFP: AFP Modelo (10.58%)
Days worked: 22 of 30
Meal bonus: 50,000
β†’ Result: Proportional net + bonuses

Calculate gross from desired net (Mexico)

Country: Mexico
Operation: Gross from Net
Desired Net: 20,000
Border zone: No
β†’ Result: Required gross + real ISR + employer cost

Calculate Brazil payroll with benefits

Country: Brazil
Operation: Net Salary
Gross Salary: 5,000
Dependents: 2
Transport Voucher: Yes
Meal Voucher: 500
β†’ Result: Net + INSS + IRRF with deductions

βœ… Features

  • No credentials: Pure mathematical calculations
  • 2024 data: Updated tables and values
  • Real precision: AFPs, ISR, INSS with exact values
  • Bidirectional: Grossβ†’Net and Netβ†’Gross
  • Employer cost: Calculates total cost for employer
  • 100% free: Open source MIT

⚠️ Disclaimer

Calculations are referential based on 2024 legislation. For specific cases, consult with a human resources professional or accountant.

🀝 Contributing

Contributions are welcome. Please open an issue or pull request.

πŸ“„ License

MIT Β© Manuel Reyes Bravo

πŸ“ Changelog

v2.0.0 (2025-01)

  • 🌐 Full English translation for n8n marketplace
  • πŸ‡¨πŸ‡± Chile: 7 real AFPs with exact commissions
  • πŸ‡²πŸ‡½ Mexico: ISR 2024 + employment subsidy
  • πŸ‡¦πŸ‡· Argentina: Income tax + deductions
  • πŸ‡¨πŸ‡΄ Colombia: Withholding tax + UVT
  • πŸ‡΅πŸ‡ͺ Peru: 4 AFPs + ONP + 5th category
  • πŸ‡§πŸ‡· Brazil: Progressive INSS/IRRF + dependents
  • πŸ‡ͺπŸ‡¨ Ecuador: IR + reserve funds
  • πŸ‡ͺπŸ‡Έ Spain: Progressive IRPF + 12/14 payments
  • ✨ Proportional days in all countries
  • ✨ Configurable bonuses
  • ✨ Real employer cost

Discussion