How to Extract Freelancer Invoice (Factura de Autónomo)
Data to Excel
Every quarter, a self-employed professional in Spain faces the same two-sided accounting problem: invoices they issued to clients (with IRPF withholding and IVA added) and invoices they received from suppliers (with input IVA to reclaim). Both sides feed the same tax forms — Modelo 303 for VAT and Modelo 130 for income tax — and both sides need their data in a spreadsheet before the quarterly deadline. With over 3.4 million autónomos registered in the RETA system as of late 2025 — the highest level since 2002 — this routine plays out millions of times every quarter. This article walks through extracting data from both issued and received freelancer invoices (facturas de autónomo) into Excel, so the numbers that land in your quarterly filings come from a single reconciled spreadsheet rather than a stack of paper.
Key Takeaways
- You spend over two hours every quarter manually typing invoice data into a spreadsheet — and you think the problem is your speed.
- You're not slow. The IRPF line on an autónomo invoice is a subtraction from the total, not an addition, and mixing issued and received IVA in one column produces numbers the Agencia Tributaria will reject automatically.
- Your role at deadline isn't data entry — it's reviewing a reconciled spreadsheet from ImageToTable.ai where every row auto-flags whether Base + IVA − IRPF equals Total and every figure maps to a Modelo 303 box.
The Autónomo's Dual Invoicing Reality
An autónomo in Spain operates on both sides of the invoice equation. At the end of each month, you issue invoices to your clients: base imponible plus 21% IVA, minus 15% IRPF withholding if the client is a Spanish business. And alongside those, you collect invoices from your own suppliers: the coworking space, the software subscriptions, the gestoría, the phone plan. Both stacks are data sources for your quarterly tax filings. Both carry fields — IVA rates, IRPF percentages, taxable bases — that need to land in the right boxes of Modelo 303 and Modelo 130.
Under Real Decreto 1619/2012, the Spanish invoicing regulation, a full invoice (factura completa) must carry twelve mandatory data fields: invoice number and series, issue date, service date (if different), issuer and recipient NIF and fiscal address, a detailed description of goods or services, taxable base (base imponible), IVA rate and amount, IRPF withholding (if applicable), and total amount. An autónomo deals with this schema from both directions — as the issuer field and as the recipient field. Getting twelve fields out of one invoice is manageable. Getting twelve fields out of forty invoices, across both sides of the ledger, before the Modelo 303 deadline on the 20th — that is the quarterly bottleneck the extraction workflow solves.
The stakes are not abstract. Filing Modelo 303 late triggers penalties starting at 1% of the tax owed for the first month and escalating to 15% plus interest after twelve months. An autónomo who files quarterly for a full year handles roughly four deadlines, two tax forms, and potentially hundreds of data points extracted from dozens of invoices. Missing one field or one decimal point means the return does not reconcile, and the Agencia Tributaria's cross-referencing system flags the discrepancy automatically.
Understanding Autónomo Invoice Tax Fields: IVA, IRPF, and the Reconciliation Trap
Two tax lines on a Spanish freelancer invoice (factura de autónomo) determine whether your quarterly filings add up — and they work in opposite directions.
IVA (Impuesto sobre el Valor Añadido) is value-added tax, charged at 21% for most professional services under Ley 37/1992 (LIVA). As an autónomo, you collect IVA from your Spanish clients and remit it to the AEAT quarterly via Modelo 303. On the expense side, you pay IVA to your suppliers and reclaim it as input VAT (IVA soportado) on the same form. The net is what you pay or carry forward. A standard issue invoice from a freelance consultant would look like this:
Issued invoice — standard autónomo service:
Base Imponible: €1,000.00
IVA (21%): +€210.00
IRPF (15%): −€150.00
Total a Cobrar: €1,060.00
The IRPF line is the one that trips up extraction tools and spreadsheets alike. IRPF (Impuesto sobre la Renta de las Personas Físicas) is income tax withheld at source — the client deducts a percentage from your invoice and pays it directly to the AEAT on your behalf via Modelo 111. Under Artículo 101 de la Ley del IRPF, the withholding rate is 15% for established professionals and 7% for new autónomos during their first three calendar years. The 7% reduced rate applies from the year of registration through the following two years, and your clients must be notified with a formal certificate. If you invoice a private individual, a non-Spanish client, or operate as an S.L. company, IRPF withholding does not apply.
The reconciliation trap is this: Total = Base Imponible + IVA − IRPF. On the €1,000 invoice above, the total is €1,060, not €1,210. A template-based tool that adds every monetary line as a positive value produces €1,360. An extraction that treats IRPF as a discount rather than a tax line produces a figure that will not match the client's bank transfer. At ten invoices per month, an IRPF misread compounds into a €1,500 monthly discrepancy in your books.
The most common extraction error on a freelancer invoice (factura de autónomo) is reading IRPF as a positive amount. An extraction that understands the IRPF line as a subtraction — not a discount, not a line item to ignore — produces totals that reconcile with your bank account on the first pass.
Why Manual Entry Breaks Down at Quarterly Tax Prep Time
Spain's autónomo tax calendar revolves around quarterly deadlines. Modelo 303 (quarterly VAT) and Modelo 130 (quarterly IRPF advance) are both due between the 1st and 20th of April, July, October, and January. Modelo 390, the annual VAT summary, is due by January 30th. Modelo 347, for transactions exceeding €3,005.06 with a single third party, follows in February. Every one of these forms draws data from your invoices: issued and received.
The data extraction problem surfaces at the volume most autónomos operate at. A solo freelancer with five monthly clients issues five invoices per month and receives ten to fifteen expense invoices (software, office, gestor, transport, marketing, professional services). At fifteen invoices per month and three minutes of manual data entry per invoice, the quarterly tax prep alone consumes two hours and fifteen minutes — just to type numbers from PDFs and paper invoices into a spreadsheet. That does not include the time spent cross-checking IRPF amounts, verifying IVA rates, tracing missing fields, or reconciling totals against bank statements.
Nearly 80% of Spain's 3.4 million autónomos operate with no employees. There is no AP clerk, no accounting team, no assistant to hand the stack of invoices to. The extraction step falls on the autónomo directly — or on the gestor, who typically charges €50 to €100 per month to do it for you. A 2024 national autónomo survey (ENA) found that 97.1% of self-employed professionals feel government policies do not support them, and the top three obstacles were the taxation system, bureaucratic burden, and high Social Security contributions. The quarterly data-prep grind sits at the intersection of all three.
For a broader cost comparison of how manual entry compares to automated extraction across Spanish-speaking markets, see Spanish-speaking markets document extraction on a budget and the manual processing cost analysis for Spanish SMEs.
Step-by-Step: Extracting Freelancer Invoice (Factura de Autónomo) Data into One Spreadsheet
The extraction workflow below handles both issued and received invoices in a single pass. The approach uses semantic AI extraction — the tool reads each invoice by understanding what fields mean rather than where they sit on the page. This matters because freelancer invoices (facturas de autónomo) come from different designers, different software (Holded, Quipu, Xolo, Billin, or plain Word templates), and different screen resolutions when photographed. Positional extraction breaks when the NIF moves from the top-right corner to a footer block. Semantic extraction does not.
Upload all invoices in one batch
Drop all your issued and received invoices — PDFs, scanned paper, photos taken with your phone — into the upload area. Mix formats, mix suppliers, mix your own issued invoices with the ones you received. The tool accepts PDFs, JPGs, PNGs, and web screenshots. No need to pre-sort by type or source: the extraction step handles both sides of the ledger in the same processing run.
Define your extraction columns
Type the column names matching the fields you need for your tax prep: "Número de Factura," "Fecha," "Razón Social Emisor," "NIF Emisor," "Base Imponible," "IVA (%)," "Cuota IVA," "IRPF (%)," "Retención IRPF," "Importe Total." For reconciliation, add a computed column: "Reconciliation (OK if Base Imponible + Cuota IVA − Retención IRPF = Importe Total, otherwise DIFF)." This column auto-flags any invoice where the totals do not reconcile, so you spot-check those first. The column names you type become the headers of your output spreadsheet.
Process, review, and flag reconciliation gaps
Click process. The AI reads every invoice, identifies each field by its semantic meaning across varied layouts, and fills the output table. The reconciliation column immediately highlights any row where the IRPF subtraction or IVA breakdown does not add up. Review those flagged rows first — they usually indicate either a missing IRPF field, a scanned invoice where the withholding line was cut off, or a rectificativa (corrective invoice) that needs separate treatment. Processing takes 5–10 seconds per page.
Export to Excel and map to Modelo 303 and 130
Download the complete dataset as an XLSX file. Each row is one invoice; each column is one field. Your issued invoices show positive IVA (IVA repercutido) and negative IRPF withholding. Your received invoices show input IVA (IVA soportado) and no IRPF withholding. From here, the spreadsheet feeds directly into your quarterly filing preparation: sum IVA repercutido for Modelo 303 Box 01, IVA soportado for Box 28, and net IRPF for Modelo 130 calculations. The next section covers the mapping in detail.
Files are processed securely and not stored.
Handling Both Sides — Issued and Received Invoices in One Workflow
The extraction workflow above works the same way on both sides of the autónomo's ledger, but the output data serves different purposes. Understanding the split before you extract avoids merging the two into a meaningless lump.
| Invoice Direction | What You Extract | What It Feeds | Key Field to Watch |
|---|---|---|---|
| Issued (you → client) | Base Imponible, IVA rate, Cuota IVA, IRPF rate, Retención IRPF, Total | Modelo 303 Box 01 (IVA repercutido/accrued), Modelo 130 net income calculation | IRPF withholding: 15% or 7%? Is the client a Spanish business or an individual? |
| Received (supplier → you) | Base Imponible, IVA rate, Cuota IVA, NIF Emisor, Razón Social, Total | Modelo 303 Box 28 (IVA soportado/input), expense tracking, Modelo 347 if threshold met | IVA rate: is the supplier applying 21%, 10%, or 4%? Is the invoice exempt? |
The single biggest mistake autónomos make when extracting both sides into one spreadsheet is failing to tag the direction. Add a column labeled "Direction" with values "Issued" or "Received." Without this column, a PivotTable summing all IVA will mix your collected IVA (which you owe to the AEAT) with your paid IVA (which you reclaim), producing a meaningless net figure. With the tag, two simple formulas give you the totals you need: SUMIF(Direction,"Issued",[Cuota IVA]) for Modelo 303 Box 01 and SUMIF(Direction,"Received",[Cuota IVA]) for Box 28.
For autónomos who also deal with delivery notes (albaranes) alongside invoices — common in trade, construction, and logistics — the same extraction approach applies. See how to extract data from Spanish delivery notes (albaranes) into Excel for that document type.
From Spreadsheet to Modelo 303 and 130 — How Extracted Data Maps to Tax Forms
Once your invoices are in a spreadsheet with the correct fields populated, the quarterly tax filing preparation becomes a matter of summing the right columns. Here is the mapping from extracted data to the key boxes on Modelo 303 (quarterly VAT return) and Modelo 130 (quarterly IRPF installment):
| Modelo / Box | What to Enter | Source in Your Spreadsheet |
|---|---|---|
| 303 Box 01 | IVA repercutido (accrued VAT) — by rate: 21%, 10%, 4% | SUMIF(Direction,"Issued",[Cuota IVA]) — broken down per IVA rate |
| 303 Box 28 | IVA soportado (input VAT) — trade purchases, expenses | SUMIF(Direction,"Received",[Cuota IVA]) |
| 303 Box 30 | IVA soportado — investment goods | Separate tag if you have capital purchases (equipment, vehicle) |
| 303 Box 64 | Result (IVA a ingresar or a compensar) | Box 01 − Box 28. If negative, carry forward or request refund in Q4 |
| 130 Box 03 | Net income for the quarter | SUM(Base Imponible) − SUM(Received expenses) |
Modelo 303 requires IVA reported by rate category. The spreadsheet approach handles this naturally if you extract each IVA rate into its own column. For example, a received invoice from a food supplier with both 21% and 10% items would produce two rows of IVA data in your extraction output. Summing the 21% column and the 10% column separately gives you the exact figures for Boxes 02-03 and 12-13 of Modelo 303. For a deep dive into the multi-rate IVA problem on Spanish invoices, see how to extract data from Spanish invoices (facturas) into Excel.
The IRPF withholding data extracted from your issued invoices serves a different purpose. The amounts your clients withheld and paid via Modelo 111 appear as prepayments on your annual income tax return (the Renta). In your quarterly spreadsheet, the IRPF column is a running tally that tells you how much has already been paid toward your year-end tax bill. When Modelo 130 Box 03 asks for your quarterly net income, you enter the figure before IRPF withholding — the withholding is subtracted later on the same form (Box 04) as an offset.
The data extraction step does not replace the gestor. It replaces the two hours you spend typing numbers from paper invoices into a spreadsheet before sending that spreadsheet to the gestor. The value proposition is not "fire your accountant" — it is "send a clean, reconciled Excel file instead of a shoebox."
Invoicing Software, Excel, and the Coming Verifactu Shift
Most Spanish autónomos issue invoices through local cloud platforms: Holded, Quipu, Xolo, Billin, FacturaDirecta, or Frihet. These tools calculate IVA and IRPF automatically, maintain sequential numbering without gaps, and generate PDFs. They are designed for the issue side of the equation. The receive side — the invoices your suppliers send you — does not enter these platforms' data model. Your suppliers use different tools, different templates, different formats. Some send PDFs, some send photos of paper invoices, some send plain email text. The extraction gap lives between their output format and your tax spreadsheet.
Spain's Verifactu regulation (Real Decreto 1007/2023) will eventually require all invoicing software to be certified and capable of sending cryptographically hashed records to the AEAT in real time. From mid-2026 through 2027, Excel and Word templates for issuing invoices will no longer be compliant. But Verifactu changes the issue side, not the receive side. Even when every autónomo's own invoices are digitally traceable, the supplier invoices that land in your inbox will still come as PDFs, scans, and screenshots for years. The extraction step that turns those received invoices into rows in a spreadsheet remains necessary regardless of what happens on the issuance side.
FAQ
What is the difference between an autónomo invoice and a standard Spanish company invoice?
An autónomo invoice (factura de autónomo) is issued by an individual professional registered under RETA, not a company (S.L. or S.A.). Structurally it follows the same mandatory field requirements under Real Decreto 1619/2012. The key difference is the IRPF withholding: when an autónomo invoices a Spanish business for professional services, a 15% (or 7% for new professionals) IRPF retention is deducted from the total. Company-to-company invoices do not carry IRPF. For extraction, this means autónomo invoices require an additional column for the IRPF field and a reconciliation check that company invoices do not need.
Does the extraction handle invoices with both 21% and 10% IVA rates on the same page?
Yes. Many autónomos receive supplier invoices where different items carry different IVA rates — for example, a restaurant meal receipt might have 10% IVA on food and 21% on alcohol. The extraction reads each rate line independently and populates the corresponding column. If you define separate columns for each rate (e.g. "Base Imponible 21%," "Cuota IVA 21%," "Base Imponible 10%," "Cuota IVA 10%"), the AI places the correct values in the correct columns regardless of the order or layout on the page.
What about expense receipts (tickets) that are not full facturas?
Simplified invoices (facturas simplificadas), the Spanish term for what most people call receipts or tickets, are valid for amounts up to €400 (€3,000 in hospitality, transport, and certain retail contexts). They do not require the recipient's NIF or full address, and the IVA breakdown is less granular. The extraction tool reads whatever data is present on the page. If the simplified invoice shows a total with IVA included (IVA incluido) rather than a separate base and tax amount, the AI extracts the total and you calculate the IVA portion manually in your spreadsheet (Total / 1.21 for 21% rate, for example).
Can I extract data from invoices in languages other than Spanish?
Yes. The extraction tool reads the visual layer of the document. Whether the invoice is in Spanish, Catalan, Galician, or English, the AI identifies fields by their semantic role rather than the language of the label. An invoice heading "Factura" and one heading "Invoice" both produce the same structured data in your spreadsheet.
How does the extraction handle IRPF when the percentage changes mid-year?
The IRPF reduction from 7% to 15% happens at the start of the fourth calendar year after registration, not mid-year. If an autónomo registered in September 2023, the 7% rate applies for 2023, 2024, and 2025, and switches to 15% on January 1, 2026. The extraction reads whatever percentage appears on the invoice. If a client applies the wrong rate, the extracted data will reflect that, and the discrepancy becomes visible in your reconciliation column. You then request a corrective invoice (factura rectificativa) from the client.
Does this replace the need for a gestor?
No. The extraction workflow produces a clean spreadsheet of invoice data — it does not file tax returns, interpret complex deductions, or provide legal advice. For most autónomos, especially those with cross-border clients, intra-EU transactions, or property deductions, a gestor remains essential. What the extraction workflow replaces is the manual data entry the gestor would otherwise bill you for — or that you would do yourself before handing the spreadsheet off. A clean, reconciled extraction output means the gestor spends their time on tax strategy, not data entry.
The Quarterly Tax Prep the Autónomo Calendar Actually Needs
Every autónomo in Spain faces the same rhythm: four quarterly deadlines, two tax forms per quarter, two stacks of invoices per quarter. The invoicing software handles the issue side — calculating IVA, deducting IRPF, generating compliant PDFs. The supplier invoices that come back the other way have no such software behind them. They arrive in whatever format the supplier chose, with whatever layout their template produces. Getting the data out of those invoices and into the same spreadsheet as your own issued records is the step no invoicing platform covers.
Semantic extraction closes that gap by reading invoices the way a person reads them: identifying fields by what they mean rather than where they sit. The output is a single spreadsheet where your issued invoices and received invoices sit side by side, each row reconciled, each column feeding the correct box on the correct tax form. The quarterly deadline on the 20th does not move. But the two hours of manual data entry that precedes it can become five minutes of review.