From Excel to ERP: A Migration Guide Without Drama

If you run your invoicing on Excel, you are not alone. Between 60% and 85% of freelancers and SMEs in Spain manage their finances with spreadsheets, Word documents, or even paper. It works until it does not: a gap in your numbering, an invoice you cannot find, a quarter that does not add up.

Migrating to an ERP sounds like a big project. It is not. This guide walks you through the entire process, from preparing your data to issuing your first invoice in the new system. No drama, no consultants, no lost data.

Why Excel stops working

Excel is an extraordinary tool. But it is not an invoicing system. And the difference matters when:

Your volume grows. 10 invoices a month in Excel are manageable. 50 are a nightmare of copy-paste, broken formulas, and files that weigh 15 MB.

The tax office asks for something. If you receive an enquiry, you need to find every invoice for a specific quarter, with complete tax data, in minutes. With Excel, that can take hours.

You make mistakes. Manual invoicing is the leading cause of tax errors among freelancers. A miscalculated VAT, a missing withholding, a duplicate invoice number. Excel does not warn you.

Verifactu arrives. Electronic invoicing will be mandatory in Spain. Excel cannot generate electronic invoices or communicate with the AEAT. When Verifactu takes effect, you will have to migrate regardless.

Before migrating: prepare your data

The migration is only as good as the data you import. Spend an hour preparing your spreadsheets before touching the ERP.

1. Client list

Create a sheet with all your active clients. Minimum data per client:

• Full name or company name
• Tax ID (NIF/CIF)
• Complete address
• Contact email
• Usual payment terms (30 days, upon receipt, etc.)

If you have clients scattered across multiple sheets or folders, now is the time to consolidate. One CSV file with all clients.

2. Product or service catalog

If you always invoice the same items (consulting hours, web design, monthly maintenance), create a list:

• Service/product name
• Unit price before tax
• Applicable VAT rate (21%, 10%, 4%, exempt)
• Unit of measurement (hour, unit, project)

3. Current year invoices

Export your invoices for the current year. At minimum you need:

• Invoice number
• Issue date
• Client (name + tax ID)
• Taxable base
• VAT
• Income tax withholding (if applicable)
• Total
• Status (paid/pending)

4. Current numbering

Note your last issued invoice number. The ERP will continue from there. If your last number is 2026-023, the ERP will start at 2026-024.

Step by step: migration in 5 phases

Phase 1: Create account and configure tax profile (10 min)

Create your ERP account. Configure:

• Your business/freelancer details (name, tax ID, address)
• Tax classification
• VAT regime
• Income tax withholding (if applicable)
• Invoice logo
• Invoice series and starting number

This configuration is done once and applies to all future invoices. If your tax situation changes, you update it here.

Phase 2: Import clients (10 min)

Upload the client CSV you prepared. The ERP will auto-map columns. Check that tax IDs are correct and there are no duplicates.

If you have few clients (under 20), creating them manually may be faster. For more than 20, CSV saves time.

Phase 3: Import products/services (5 min)

If you have a defined catalog, import products with prices and VAT rates. If you invoice custom services each time, you can skip this step and create line items on the fly.

Phase 4: Import invoice history (15 min)

This step is optional but recommended. Importing current-year invoices lets you:

• Have your complete invoicing history in one place
• See real data on the financial dashboard from day one
• Include pre-migration data in quarterly VAT calculations

If you skip the history import, nothing terrible happens. The reports for your first ERP quarter will simply reflect only invoices issued after the migration.

Phase 5: Issue your first invoice (2 min)

Create a test invoice. Verify that:

• Numbering continues correctly
• Tax details are correct (tax ID, address, VAT)
• Income tax withholding appears if it should
• The PDF looks good
• The send-by-email function works

If everything checks out, you are invoicing with an ERP. That is it.

The 3 most common migration mistakes

Running both systems in parallel. The biggest mistake is continuing to use Excel "just in case" after migrating. If you invoice in both places, you end up with duplicate numbering, inconsistent data, and double the work. Pick a cutoff date and from that point on, ERP only.

Not verifying numbering. Before issuing the first invoice in the ERP, confirm the next number is correct. A gap or duplicate in numbering is one of the first things the tax office checks.

Importing dirty data. If your Excel has duplicate clients, incorrect tax IDs, or invoices with incomplete data, those problems get imported into the ERP. Clean your data before migrating, not after.

What you gain by migrating

The difference between invoicing with Excel and invoicing with an ERP is noticeable from day one:

Time. An invoice that takes 10 minutes in Excel (looking up client data, copying a template, calculating VAT, generating a PDF, sending an email) takes 2 minutes in an ERP. With 30 invoices a month, you recover more than 4 hours monthly.

Zero errors. VAT is calculated automatically. Numbering has no gaps. Client data is auto-filled. Income tax withholding is applied when appropriate. There is no room for human error in calculations.

Visibility. You open the dashboard and see how much you have invoiced, how much you are owed, how much you owe the tax office this quarter. With Excel, that information requires cross-referencing multiple sheets and hoping the formulas are correct.

Compliance. When Verifactu arrives, your ERP will generate electronic invoices and communicate with the AEAT without you having to do anything additional. With Excel, that day will be a serious problem.

Migrating to Frihet

Frihet is designed to make migration from Excel as fast as possible. CSV import for clients, products, and invoices. Guided tax configuration. A dashboard that shows real data from minute one.

The free plan gives you 10 invoices per month with no time limit. Enough to migrate, test with your real workflow, and decide if it works for you before paying anything.

If you have been telling yourself for years that "someday" you will stop using Excel, that day can be today. Half an hour of preparation, half an hour of setup, and your next invoice comes from a system that does not depend on you remembering to update a cell.