MX Payroll

Local Dev Friday, Feb 20

person

Process Payroll Data

Upload Mexican payroll exports to generate NetSuite journal entries

Upload

Process

Results

warning

Fiscal calendar not loaded

Import the fiscal calendar before processing payroll.

cloud_upload

Upload Payroll File

cloud_upload

Drop Payroll File Here

.xlsx or .xls files

settings Calculation Method

Excel JE Method (Recommended) Uses pre-calculated USD columns. INDEM employees are separated into their own JE section.

Spec-Based Method Reads raw MXN columns and converts to USD. All employees in main JE, INDEM as additional line.

Test Method Reads raw MXN columns only. Looks up departments from employee roster. Supports both processed and raw provider files (auto-detected). Requires exchange rate input.

calendar_month NRF Day Split

Enter the prior month's leftover days to auto-calculate the split, or override manually.

Prior Leftover Days

Leave blank to auto-calculate from NRF chain. Override only if needed.

Calendar Days

Main Days

Provision Days

Provision = Calendar Days − Main Days. Leave blank to auto-calculate from the fiscal calendar.

NRF Period Weeks Reference

Jan: 5 Feb: 4 Mar: 4 Apr: 5 May: 4 Jun: 4 Jul: 5 Aug: 4 Sep: 4 Oct: 5 Nov: 4 Dec: 4

info

Formula: Allocation = (Monthly Payroll / Calendar Days) x Days in Period

1. Main JE — Covers the main days in the primary period
2. Provision JE — Covers remaining days that spill into the next period (if any)