Do Autónomos Need a Bookkeeping Spreadsheet? Spain's Invoice and Expense Records Explained

Many new autónomos in Spain ask the same question:

Is there a required bookkeeping format for invoices and expenses, or can I just use my own Excel?

The short answer is: you can usually use your own spreadsheet, but it should not be random. Hacienda expects your records to contain the information needed to check your income, expenses, IVA and quarterly tax filings.

AEAT also publishes official electronic formats for IVA and IRPF record books. These formats are especially useful if Hacienda asks for your books or if you want to import records into AEAT services such as Pre303, Renta WEB or Modelo 130.

First: bookkeeping is not just for your gestor

Some freelancers think bookkeeping only matters if they have a gestoría. That is a mistake.

Your bookkeeping is the bridge between your real activity and your tax forms. The same records usually help you prepare:

• your quarterly income tax prepayment, Modelo 130;
• your quarterly VAT return, Modelo 303;
• your annual income tax return;
• responses to document requests from Hacienda;
• proof of income for banks, visas or mortgages.

If your records are messy, every tax quarter becomes stressful. If they are clean, quarterly filing becomes much more predictable.

If you are not sure which quarterly forms apply to you, start with our guides on how to file Modelo 130 yourself and how to file Modelo 303 yourself.

Does AEAT Require an Official Excel Template?

For everyday bookkeeping, many small autónomos use their own Excel or Google Sheets file. There is not one single daily spreadsheet that every freelancer must use in exactly the same visual layout.

But AEAT does publish official electronic formats for record books. AEAT explains that these formats can be used to attend requirements, prepare economic activity sections in Renta WEB, prepare Modelo 303 through Pre303 and prepare Modelo 130.

In practical terms, this means your private spreadsheet can be simple, but it should be structured enough to produce the information Hacienda expects.

What are the main record books for autónomos?

The exact books depend on your activity and tax situation, but most freelancers should understand the following categories.

1. Issued invoices

This is your sales record. It includes invoices you issue to clients.

For many autónomos, this is the most important book because it supports your declared income, Modelo 130 and the output VAT shown in Modelo 303.

2. Received invoices and expenses

This is your expense record. It includes supplier invoices and deductible business expenses.

This book matters because not every payment from your bank account is automatically deductible. You usually need proper supporting evidence, especially if you want to deduct VAT.

For a deeper explanation, see our guide on which business expenses are safest to deduct as an autónomo.

3. Investment goods

Some assets are not just ordinary small expenses. A laptop, camera, professional equipment or other larger asset may need more careful treatment, especially if depreciation or business-use percentages are involved.

If you buy work equipment, also read our guide on deducting laptops, phones and AI tools as an autónomo.

4. Intra-EU operations

If you work with EU clients or suppliers, you may need to track intra-EU operations separately. This is especially relevant for reverse charge, EU VAT numbers and some cross-border services.

If you invoice foreign clients, see our guide on how to invoice a client outside Spain as an autónomo.

Recommended columns for issued invoices

A practical sales spreadsheet for an autónomo should usually include columns like these:

Recommended columns for expenses

For expenses, the most useful spreadsheet is not just a list of payments. It should help you understand whether an expense is deductible and whether the VAT is recoverable.

Can you organize invoices your own way?

Yes, but your system should be understandable to someone else. The goal is not artistic freedom. The goal is to make your records easy to verify.

Avoid folder names like:

Stuff / Taxes / Important / Maybe deductible

A cleaner structure is:

2026 ├── Q1 │ ├── Sales │ └── Expenses ├── Q2 │ ├── Sales │ └── Expenses

Another good option is to name every file with a date, invoice number and supplier or client:

2026-03-18_INV-2026-014_ClientName.pdf

Invoice numbering: keep it simple

A common beginner mistake is changing the invoice sequence too often or creating gaps without explanation.

A simple yearly sequence is usually easier to manage:

2026-001 2026-002 2026-003

Or:

INV-2026-001 INV-2026-002 INV-2026-003

The important thing is consistency. If an invoice is cancelled, keep a record of what happened instead of silently deleting it.

What happens if Hacienda asks for your records?

A Hacienda review is not always dramatic. Sometimes the tax office simply asks for supporting documents after a return is filed.

For example, after filing Modelo 303, Hacienda may ask for invoices, expense documents and explanations for VAT deductions. If this happens, your spreadsheet and document folders become very important.

We explain this process in more detail in our guide on what to do if Hacienda requests documents for Modelo 303.

How AEAT's official formats fit into this

AEAT's electronic formats are useful because they show the kind of structured information the tax office expects. They are not just a random Excel design.

AEAT publishes formats for IVA and IRPF books, including issued invoices, received invoices, sales and income, purchases and expenses, and investment goods.

For many small freelancers, the practical approach is:

1. Use a simple spreadsheet during the year.
2. Keep PDF invoices and receipts in organized folders.
3. Make sure your columns can map to AEAT-style records.
4. If required, export or prepare the information in the format Hacienda requests.

Common bookkeeping mistakes

• Only keeping bank statements instead of invoices.
• Saving screenshots instead of proper PDF invoices.
• Mixing personal and business expenses without notes.
• Forgetting foreign platform income.
• Not separating taxable base, IVA and total.
• Using inconsistent invoice numbers.
• Not tracking expenses by quarter.
• Claiming VAT without a proper invoice.

If you receive money through platforms or payment apps, remember that income still needs to be reviewed. You may also want to read our guides on whether Hacienda can see your Upwork income through DAC7 and whether Hacienda can see Bizum payments.

Do you need a gestoría if you only have a few invoices?

Some autónomos are perfectly happy paying a gestoría every month. Others only issue one or two invoices and prefer to understand the numbers themselves.

The key question is not only "Do I need a gestor?" but also "Are my records clean enough to prepare the quarterly forms?"

We discuss this in more detail in our guide on whether you really need a gestoría for 1–2 invoices per month.

Free bookkeeping spreadsheet for autónomos

To make this easier, we created a practical bookkeeping spreadsheet for autónomos in Spain.

It is designed around the same logic used in Spanish tax records: issued invoices, received invoices, investment goods, intra-EU operations and quarterly summaries.

Related guides

• Quarterly Tax Filing Checklist for Autónomos in Spain
• How to File Modelo 130 Yourself in Spain
• How to File Modelo 303 Yourself in Spain
• Which Business Expenses Are Safest to Deduct as an Autónomo?
• Hacienda Requested Documents for Modelo 303
• How to Invoice a Client Outside Spain as an Autónomo

Final thoughts

Spain does not require every small autónomo to use expensive accounting software. But it does expect you to keep clear, complete and understandable records.

Your spreadsheet should answer basic questions quickly: what did you invoice, what did you spend, what VAT did you charge, what VAT did you deduct, and which documents support those numbers?

If your bookkeeping can answer those questions, tax filing and Hacienda reviews become much easier.