Use case
Extract payroll CFDI receipts to Excel, with validation
Turn Mexican payroll CFDI receipts (Nómina 1.2 complement) into a reconciliation-ready spreadsheet. Tablora reads the XML and the PDF, extracts every fiscal field and checks that net pay adds up.
For Payroll firms and accounting teams processing Mexican payroll receipts every pay period.
The problem today
Every payday, hundreds of payroll CFDI receipts arrive as XML and PDF, and hand-keying the UUID, RFC, CURP, earnings and deductions takes hours and invites errors. Verifying that net pay equals earnings minus deductions plus other payments becomes unworkable across many employees. A receipt that was never stamped, a missing social-security number (NSS) or income tax withheld at zero usually surfaces too late — after the payments went out or the journal entry was posted.
What Tablora extracts and validates
Every document is a row; every column, an instruction.
How it works
- 1
Upload the payroll CFDI receipts
Drag in the XML and PDF of each pay receipt. Every receipt becomes a row, and Tablora recognizes the Nómina 1.2 complement with no setup.
- 2
Define the columns as instructions
Use the payroll CFDI template or adjust the columns you need: UUID, employer and employee RFC, CURP, NSS, pay period, earnings, deductions, ISR withheld and net pay.
- 3
Review, validate and export
Tablora flags mismatches and missing data with citations and confidence levels. Review what's flagged and export to Excel or CSV to reconcile, pay out or post to your accounting system.
Validation layer
Not just extraction — validation
- Checks that net pay equals earnings minus deductions plus other payments, and reports the exact difference
- Detects missing UUIDs and unstamped receipts before payments go out
- Flags missing or malformed CURP or NSS
- Flags generic employee RFCs (XAXX010101000) or RFCs with the wrong length
- Alerts when ISR withheld is zero despite significant taxable earnings
- Detects the employment subsidy applied together with ISR withholding
Frequently asked questions
What is a Mexican payroll CFDI?
In Mexico, pay stubs are electronic invoices: a CFDI with the Nómina 1.2 complement, stamped by the SAT, that records the employee, the pay period, earnings, deductions, income tax withheld (ISR) and net pay in XML. The XML is the legal record; the PDF is just its printed representation.
How do I extract payroll CFDI receipts to Excel with Tablora?
Upload the receipts as XML and PDF; each receipt becomes a row and each column an extraction instruction. Tablora captures the UUID, employer and employee RFC, CURP, NSS, period, earnings, deductions, ISR withheld and net pay, and exports the sheet to Excel or CSV.
How does it validate that net pay is correct?
It compares net pay against total earnings minus deductions plus other payments and flags any mismatch with the exact difference. It also detects missing UUIDs, invalid CURP or NSS, generic RFCs and zero ISR withholding — each finding with its citation.
Can I export to my accounting or payroll system?
Yes. Export the sheet to Excel or CSV for reconciliation and payout, and integrate with systems like CONTPAQi, SAP or QuickBooks to load the validated data.
Turn these documents into a spreadsheet
Upload your files, review with citations and confidence, and export to Excel or CSV.
Start for free