Spain Renta Season:
HR's Payslip Data Checklist Before June 30
The bottleneck in Spanish annual tax compliance is not the arithmetic of IRPF withholding. Payroll software — A3, Sage NominaPlus, NominaSol — calculates that correctly. The bottleneck is the data bridge: the one that connects twelve months of individual payslip (nómina) PDFs to one Modelo 190 in January, and from that Modelo 190 back out to forty employee certificates (certificado de retenciones) in April. Most HR departments and gestorías (payroll bureaus) build that bridge with copy-paste. Every June, when employees file their declaración de la renta, the cracks show up as AEAT discrepancy notices. This article maps the data chain, identifies the seven verification points that catch discrepancies before employees do, and lays out a system that makes next January's Modelo 190 a reconciliation step rather than a reconstruction project.
Key Takeaways
- Your quarterly aggregate looked flawless while individual rows underneath it were already wrong.
- An employee's frozen tax refund in June is your first signal the Modelo 190 data broke in January.
- Monthly extraction with ImageToTable.ai turns your January Modelo 190 from a multi-day reconstruction into a five-minute verification.
Why the June 30 Deadline Starts in January
The declaración de la renta campaign for the 2025 tax year opened on April 8, 2026 and closes on June 30, 2026 — June 25 for taxpayers paying by direct debit (domiciliación bancaria), per the AEAT official calendar. Employees log into Renta WEB, review their borrador (draft return), and either confirm or correct it. The data pre-filled in that borrador — employment income, IRPF withholding, Seguridad Social contribution bases — was submitted to the AEAT by the employer four months earlier, in the Modelo 190. If the Modelo 190 contained an error, the employee's borrador carries that error forward. The employee discovers it in May or June. HR gets the call.
The Modelo 190 is the annual informational summary of all IRPF withholdings on employment income (rendimientos del trabajo, Clave A) that were declared quarterly through the Modelo 111. Every employer that withholds IRPF from employee salaries must file it — not just large companies, but any autónomo with a single employee, any gestoría managing payroll for a client. The filing window is January 1 through January 31 (extended to February 2, 2026 per the AEAT). Unlike the quarterly Modelo 111 — which reports only aggregate withholding amounts — the Modelo 190 breaks out data per employee (perceptor): total annual compensation, total annual IRPF retained, contribution bases, and perception key.
This is the structural reason the June crisis begins in January. The Modelo 111 asks for one number: total IRPF paid across all employees that quarter. The Modelo 190 asks for forty individual records — one per employee — each of which must reconcile with twelve months of individual payslip data. An HR department that verified Modelo 111 totals by comparing them to the payroll software's quarterly summary had no mechanism to verify per-employee accuracy. The aggregate checked out. The individual rows did not. By the time an employee's borrador flags the discrepancy in May, the Modelo 190 has been filed for four months and the correction pathway requires a declaración complementaria (supplementary filing) — a process that, depending on the nature of the error, can take weeks while the employee's Renta filing deadline approaches.
If you need a detailed field-by-field map of the Spanish payslip before diving into the reconciliation workflow, our payslip extraction guide covers every mandatory field from encabezado (header) through bases de cotización. This article focuses on what comes after extraction: the verification pipeline that turns extraction output into audit-proof Modelo 190 support.
The Data Chain: 12 Nóminas, 4 Modelo 111s, 1 Modelo 190, 40 Certificates
To understand why manual verification breaks down at scale, trace the full data path. A forty-employee company running monthly payroll produces 480 individual payslip PDFs per year — twelve per employee. Each PDF contains roughly sixteen mandatory fields under Orden ESS/2098/2014: base salary, complementos (supplements), overtime, five Seguridad Social employee deductions (contingencias comunes at 4.70%, desempleo at 1.55%–1.60%, formación profesional at 0.10%, FOGASA, and since 2023, MEI at 0.15%), IRPF withholding at the employee's individual rate, employer's aportación empresarial, and contribution bases. Multiply by twelve months. Multiply by forty employees.
From these 480 PDFs, four data outputs must be produced:
| Output | Recipient | Granularity | Deadline |
|---|---|---|---|
| Modelo 111 (quarterly) | AEAT | Aggregate — total IRPF across all employees | April 20 / July 20 / Oct 20 / Jan 20 |
| Modelo 190 (annual) | AEAT | Per employee — individual IRPF, compensation, bases | January 31 (extended Feb 2, 2026) |
| Certificado de retenciones | Each employee | Per employee — individual compensation + IRPF summary | Before Renta campaign starts (early April) |
| Sistema RED / RNT transmission | TGSS | Per employee — contribution bases, days, contract type | Penultimate day of each month |
The key insight most compliance guides miss: Modelo 190 and the certificado de retenciones share the same data source but serve different audiences. The Modelo 190 feeds into the AEAT's cross-check system. The certificate feeds into the employee's Renta filing. They must agree to the cent (€0.01). A single payslip misread — entering an IRPF withholding of €342.15 instead of €432.15 — propagates into the Modelo 190, then into the employee's AEAT fiscal data, then into the borrador. The employee compares the borrador against their certificado de retenciones (which the employer issued from the same data). The discrepancy becomes visible. HR gets the email. The AEAT's automated cross-check between Modelo 190 totals and Modelo 111 quarterly aggregates runs in parallel: if the four quarterly sums don't equal the annual per-employee breakout, a requerimiento (inquiry) is issued to the employer.
For a broader view of how quarterly filing obligations interact with payslip data across different Spanish tax models, see our analysis of Spain's quarterly IVA filing with Modelo 303 — the data aggregation pattern is structurally similar, though the tax base differs.
At two minutes per payslip for a manual lookup of IRPF withholding, total devengado, and contribution bases — accounting for the visual scan to locate fields that shift position between A3, Sage, and NominaSol PDF layouts — a forty-employee company burns roughly sixteen hours per year on data transfer alone. And that is before anyone attempts the 1+1+1+1 = 4 cross-check between Modelo 111 quarterly totals and Modelo 190. This is where Custom Column Extraction changes the arithmetic: instead of reading each PDF visually to locate specific fields, you define the column names you want — "IRPF Withholding," "Total Devengado," "CC Employee Contribution," "Aportación Empresarial" — and the AI reads every payslip by what each field means, not where it sits on the page. One column definition. Forty employees. Twelve months. One consolidated spreadsheet. The sixteen hours collapse to minutes. Batch processing forty payslips into one payroll summary table covers the mechanics in detail; the point here is what that consolidated spreadsheet unlocks for Modelo 190 verification.
The Seven-Point Verification Checklist Before Employees File
This checklist assumes you have extracted all payslip data into a single spreadsheet with one row per employee per month. Each verification point below identifies what to check and what a mismatch signals.
Verify per-employee annual IRPF total against Modelo 190 Clave A
Sum each employee's IRPF withholding across all twelve months. Compare to the Modelo 190 per-record amount for that NIF. A mismatch signals a data entry error in at least one month — often a single-digit transposition (342.15 typed as 432.15). If the per-employee totals match but the aggregate Modelo 190 total differs from the sum of four Modelo 111 quarterly totals, an employee may have been omitted from one of the quarterly filings.
Reconcile total annual compensation (total devengado) against Modelo 190 bases
Sum each employee's total devengado (gross earnings) across all twelve payslips. The Modelo 190 reports percepciones íntegras (gross compensation) — the two must match. A mismatch of exactly one month's salary means a month was missed. A mismatch smaller than one month's salary with no clear pattern often traces to an extra payment (paga extra) recorded in a different period than the payslip because of prorating — cross-check against the devengos block's pagas extras prorrateadas field.
Validate every employee NIF against the AEAT format specification
A NIF with a transposed digit is the single most common Modelo 190 rejection error. Spanish NIF format: 8 digits + 1 check letter for individuals; 1 letter + 7 digits + 1 check character for legal entities. The Modelo 190 web form rejects invalid NIFs, but a valid NIF that belongs to a different employee — swapped between two rows — passes validation and creates a data traceability problem that the AEAT's cross-check will flag when the actual employee's borrador shows zero income from your company. Verify each NIF against your employee database, not against the payslip PDF alone.
Check total Modelo 190 IRPF sum equals sum of four Modelo 111 quarterly totals
This is the "1+1+1+1 = 4" arithmetic validation the AEAT runs automatically. Sum the IRPF totals from your four quarterly Modelo 111 declarations. Compare to the total IRPF on the Modelo 190 cover sheet (Hoja 1). If they differ, do not file the Modelo 190 until you identify the source. Common causes: an employee was included in a Modelo 111 quarter but omitted from the annual breakdown, or vice versa. Correction requires a Modelo 111 complementaria before the Modelo 190 can be filed with matching data — never attempt to "correct" the discrepancy by adjusting the Modelo 190 alone.
Confirm contribution bases match what was transmitted via Sistema RED
The Modelo 190 includes fields for bases de cotización (contribution bases) that must match the per-worker data transmitted monthly to the TGSS through Sistema RED. While the TGSS cross-check is on the Social Security side and the AEAT cross-check is on the tax side, a mismatch between what was declared to TGSS (RNT) and what appears on the Modelo 190 can surface during a joint inspection (actuación conjunta de la Inspección de Trabajo y la AEAT). Cross-check total annual contribution bases per employee against the sum of monthly RED transmissions.
Generate and verify each certificado de retenciones against the same source data
Under Article 108.3 of the Reglamento del IRPF (Real Decreto 439/2007), every employer must issue an annual withholding certificate to each employee before the Renta campaign begins. No official form is mandated, but it must include: employer NIF and name, employee NIF and name, total annual compensation, total IRPF retained, and the tax year. These values must match — to the cent — both the per-employee Modelo 190 record and the employee's own payslip totals. A single certificate issued with incorrect IRPF data creates a cascading problem: the employee files Renta using the certificate as their reference, the AEAT cross-checks against the Modelo 190, and if the two disagree, the employee's devolución (refund) is frozen. Failing to issue certificates carries a €150 penalty per missing certificate under the Reglamento General del régimen sancionador tributario.
Flag employees with mid-year changes in personal circumstances
An employee's IRPF withholding rate is not a flat percentage — it is individually calculated based on estimated annual income, family situation, and degree of disability communicated via Modelo 145. If an employee married, had a child, or registered a disability during the year and updated their Modelo 145, the IRPF rate changed mid-year. The annual total IRPF on the Modelo 190 will not be a clean 12 × monthly amount — it will step at the month the change took effect. If your verification spreadsheet is built by multiplying one month's IRPF × 12, every employee who updated their Modelo 145 will appear to have a discrepancy. Flag these employees and verify month-by-month against the payslip for each rate period.
When to delegate vs. when to automate. A gestoría managing payroll for ten client companies faces this seven-point checklist multiplied by ten. Each client may use a different payroll software — A3 for one, Sage NominaPlus for another, NominaSol for a third — producing PDFs with the same sixteen mandatory fields in three different positions. Custom Column Extraction reads all three layouts against the same column definitions because it reads field meaning rather than field position. Define the columns once. Upload all clients' payslip PDFs. One spreadsheet per client. Seven checks per client. The extraction handles the layout variation; the checklist handles the verification.
When an Employee Finds a Discrepancy: The 24-Hour Response
An employee emails: "My borrador shows €3,420 in IRPF withholding but my last payslip says I paid €4,100. Which one is right?" The tendency is to open the December payslip PDF, find the IRPF field, and reply. That answers one month. The discrepancy might be in March, not December — the employee compared the wrong payslip. Here is the correct response sequence:
Pull the employee's full-year payslip data from your reconciliation spreadsheet
If you built the spreadsheet during the Modelo 190 preparation, this takes thirty seconds. If you did not — and are now opening twelve individual PDFs to manually sum IRPF across twelve months — the employee will wait. For a company processing batch payroll consolidation, having a full-year per-employee table already built means any discrepancy inquiry can be answered in minutes.
Identify whether the discrepancy is isolated or systemic
Compare the employee's total annual IRPF from your spreadsheet against your Modelo 190 filing, the Modelo 111 quarterly aggregates, and the certificado de retenciones you issued. If the spreadsheet agrees with Modelo 190 and the certificate — but the borrador does not — the error is on the AEAT side (unusual but possible: a data loading error between Modelo 190 submission and borrador generation). If the spreadsheet agrees with the payslips but disagrees with Modelo 190, the error was in your January filing. If the spreadsheet disagrees with the payslips, your extraction had an error — likely from a month where the PDF was a scan rather than a digitally generated document, or from a payroll software layout change that confused template-based extraction.
If the Modelo 190 is wrong, file a complementaria — and notify all affected employees
A Modelo 190 error affecting one employee rarely affects only one. If employee A's IRPF was mis-entered, check whether the same error propagated to employees B through F. The Modelo 190 declaración complementaria corrects the AEAT record. Simultaneously, issue corrected certificados de retenciones to all affected employees with a brief explanation: "The original certificate overstated your IRPF withholding by €X. Use the corrected certificate for your Renta filing. The AEAT record is being updated." Employees who have already filed will need to submit a declaración rectificativa. Employees who have not yet filed avoid the problem entirely — which is why getting the certificate out early, and verified, matters.
Next Year: A Reconciliation System Instead of a January Scramble
The structural fix is building a data extraction pipeline that runs monthly — not annually — so that by January, the Modelo 190 is a reconciliation check, not a reconstruction project. The approach:
- Monthly extraction. After each payroll cycle, upload the month's payslip PDFs and extract the verification columns: Employee NIF, Total Devengado, IRPF Withholding, CC Employee Contribution, Aportación Empresarial, and Contribution Base. This takes under a minute for forty payslips when names and NIFs are included as extraction columns so the output is self-identifying.
- Quarterly cross-check. When filing each Modelo 111, compare the quarterly IRPF total from the extraction spreadsheet to the Modelo 111 amount. A mismatch caught in April is a ten-minute correction. The same mismatch caught in January — after three more quarters of errors have accumulated — is a forensic exercise.
- Annual roll-up. In January, the twelve monthly sheets already exist. Merge them. Pivot by employee. The Modelo 190 per-employee breakout is already built. The seven-point checklist above becomes a five-minute verification, not a multi-day data entry sprint. The certificados de retenciones — forty individual documents, each pulling the same two numbers (total compensation, total IRPF) per employee — are generated from a mail merge against the same spreadsheet.
- Cross-payroll-system resilience. If your company changed payroll providers during the year — migrating from Sage to PayFit, or if a gestoría client switched from A3 to NominaSol — the monthly extraction approach isolates the format change to the month it occurred. January through June payslips are extracted from one layout. July through December from another. The AI reads both against the same column definitions because it reads by field meaning, not position. The annual roll-up is unaffected by the provider switch.
This approach also handles the Collection Link scenario for gestorías: instead of chasing forty client companies for their payslip PDFs each January, generate a shareable link (per the Collection Link feature — a URL that lets external parties upload documents directly into your processing queue without registering) and send it to each client in December. They upload their year's PDFs. The extraction runs. You verify. The model works for one gestoría managing fifty client companies as cleanly as it does for one HR department managing forty internal employees.
Files are processed securely and not stored.
FAQ: Spanish Renta Payslip Data Preparation
What happens if my Modelo 190 doesn't match the four Modelo 111 quarterly totals?
The AEAT's automated validation flags the discrepancy during Modelo 190 processing. You will receive a requerimiento (inquiry notice) asking for clarification. The resolution path: identify which quarter's Modelo 111 is inconsistent with the per-employee annual data, file a Modelo 111 complementaria for that quarter, and then file a Modelo 190 complementaria with corrected per-employee data. The three filings must be consistent. Never adjust the Modelo 190 alone — the quarterly totals remain on record and the discrepancy will resurface.
Do I need to issue a certificado de retenciones to an employee who left the company in February?
Yes. Any person who received employment income subject to IRPF withholding during the tax year — even for a single month — is entitled to a certificate covering the period they were employed. The certificate should show the actual compensation paid and IRPF retained during their months of employment, not a projected full-year amount.
Can I extract data from scanned payslip PDFs, not just digitally generated ones?
Yes. ImageToTable.ai's extraction works on scanned documents, phone photos of printed payslips, and digitally generated PDFs. The AI reads the visual content of the page — not the underlying PDF text layer — so a scanned nómina and a digitally generated one are equivalent inputs. For payslips received as paper printouts from employees who need a duplicate certificate, this means you can photograph the document and extract the data without re-entering it manually. The accuracy for printed payslip tables is up to 99%.
What is the penalty for missing the Modelo 190 deadline?
The Modelo 190 is an informational declaration — no payment is associated with it. However, late filing carries a penalty of €20 per omitted or incorrect data record (or set of records), which can escalate significantly for a company with dozens of employees. If the AEAT issues a formal requerimiento before you file, the penalty framework shifts from the standard late-filing scale to the more consequential sanction regime for non-compliance with an information request.
How do I handle an employee who worked in two different autonomous communities during the year?
The Modelo 190 includes a field for the province (provincia) associated with each perceptor. If an employee changed work locations — for example, transferred from your Madrid office to your Barcelona office mid-year — you may need to report them under the province where they were assigned at year-end, or under the province of the establishment where they primarily worked. The Modelo 190 instructions specify provincia assignment rules; consult the annual AEAT guidance (Orden HAC) for the filing year, as these rules occasionally change.
The One Thing to Fix Before June 30
Every June, the same email arrives in HR inboxes across Spain: an employee's borrador shows a discrepancy and the deadline is three weeks away. The email triggers a scramble — open twelve PDFs, manually sum the IRPF field, compare against the certificate, compare against the Modelo 190, identify the month where a €100 transposition created a €1,200 annual mismatch, file corrections, reissue certificates. By the time it is resolved, three more employees have emailed. The root cause is not the complexity of Spanish tax law. It is the data pipeline — a pipeline that for most companies, gestorías, and HR departments still runs on opening PDFs and typing numbers into a spreadsheet, one field at a time, forty times over, twelve months deep.
If there is one thing to fix this year before the June 30 deadline closes: build the per-employee reconciliation spreadsheet now — while there is still time to catch discrepancies before employees file. Next year, build it monthly so January is a verification, not a reconstruction. Test the extraction on a sample payslip. The difference between a payroll department that faces Renta season with a per-employee spreadsheet and one that faces it with a folder of PDFs is the difference between answering employee emails in two minutes or two hours.