What to Export Before Switching Financial Tools

You've decided to switch. Maybe your current tool is too expensive, too complicated, or just not doing what you need. Whatever the reason, the biggest thing standing between you and a better setup is the migration itself.

Good news: it's not as bad as you think. Most freelancers can complete a meaningful migration in a weekend. The key is knowing what actually matters, what you can leave behind, and what format to grab everything in.

Here's the practical guide.

The Essential Export List

Not everything in your current tool needs to come with you. Focus on what you'll actually need going forward and what you're legally required to keep.

Client List

Priority: High. This is the foundation. Export:

Client names and company names
Email addresses (billing contacts especially)
Mailing/billing addresses
Any notes or custom fields you've added
Payment terms if they vary by client

Most tools let you export clients as CSV. If yours doesn't, you can usually copy the data from a client list view. This is the one export where manual entry into a new system is actually reasonable -- if you have under 30 clients, it might take less time than debugging a CSV import.

Invoice History

Priority: High (for tax records). You need to keep records of all invoices for at least 3-7 years depending on your jurisdiction. Export:

All invoices as PDFs (your permanent record)
Invoice data as CSV if available (amounts, dates, client, status)
Payment dates and amounts received
Any credit notes or adjustments

Important: You don't necessarily need to import old invoices into a new system. You just need to be able to find them if the IRS, HMRC, or your accountant asks. A folder of PDFs organized by year is perfectly adequate.

Expense Records

Priority: High. Export:

All expense entries with dates, amounts, categories, and descriptions
Receipt images or attachments (download everything)
Vendor/payee information
Any tax categorization (business meals, travel, supplies, etc.)

Expense data is critical for tax deductions. If you lose your categorized expense history, you're either re-categorizing from bank statements or leaving deductions on the table.

Time Logs

Priority: Medium. If you bill hourly or need time data for project estimates:

All time entries with dates, hours, client/project, descriptions
Billing status (billed vs. unbilled)
Rate information at the time of entry

Time logs are less critical for tax purposes but very useful for your own reference -- especially if you use historical data to estimate future projects.

Outstanding Balances

Priority: Critical. Before you switch anything:

Document every unpaid invoice (client, amount, due date, how overdue)
Note any partial payments
Record any agreed payment plans

Do not switch your invoicing tool while you have significant outstanding balances unless the new tool can track them. You need a clear system for following up on money owed to you, and losing track during a migration is an expensive mistake.

File Formats: What to Ask For

CSV is universal. Almost every tool can export to CSV, and almost every tool can import from it. When in doubt, get the CSV.

Beyond that:

PDFs for any document you might need to reference (invoices, receipts, proposals)
JSON if you're technical and want the most complete data export
QBO/IIF formats only if you're moving to or from specific accounting software that uses them
Excel (.xlsx) works but CSV is more portable

Pro tip: Export everything as CSV even if you also get PDFs. CSV files are searchable, sortable, and importable. PDFs are great for reference but terrible for data migration.

What You'll Lose (and What You Won't)

Let's be honest about what survives a migration and what doesn't.

You'll keep:

Client contact information
Historical invoice amounts and dates
Expense records and categories
Time entry data
Any documents you export as PDFs

You'll likely lose:

Automation rules you've set up (recurring invoices, auto-reminders, categorization rules). You'll need to rebuild these.
Integrations with other tools. Bank feeds, payment processors, calendar syncs -- these need to be reconnected.
Activity history. When you sent an invoice, when the client opened it, reminder sequences. This metadata rarely transfers.
Custom templates. Invoice designs, proposal layouts, email templates. Screenshot them so you can recreate.
Report configurations. Custom dashboards or saved reports. Take screenshots.

None of these losses are devastating, but they represent setup time in the new tool. Budget for it.

The Minimum Viable Migration

If you're overwhelmed, here's the absolute minimum to switch safely:

Export all invoices as PDFs (tax records -- non-negotiable)
Export clients as CSV (you need this to send new invoices)
Document outstanding balances (so nothing falls through the cracks)
Download expense receipts (tax deduction backup)
Set a cutover date ("everything before March 1 lives in the old tool, everything after lives in the new one")

That's it. You don't need to import three years of time entries into the new system on day one. You need to be able to send your next invoice and not lose track of money owed to you.

Realistic Timeline: How Long a Switch Takes

For a solo freelancer with under 50 clients:

Day 1 (2-3 hours): Export everything from the old tool. Organize files.
Day 2 (2-3 hours): Set up the new tool. Import client list. Configure basic settings (payment methods, tax rates, templates).
Day 3 (1-2 hours): Import or manually enter outstanding balances. Send a test invoice. Verify everything looks right.
Week 2: Use the new tool for all new work. Keep the old tool accessible (read-only) for reference.
Month 2: Cancel the old subscription once you're confident nothing is missing.

Total active time: 5-8 hours. Most of that is waiting for exports and doing one-time setup.

The One Thing People Forget

Tell your clients. If your invoices will come from a new email address, a new domain, or look different, give clients a heads-up. A simple email -- "We've updated our invoicing system; your next invoice may look slightly different" -- prevents confusion and ensures payments don't get delayed because someone didn't recognize the sender.

Switching tools feels like a bigger deal than it is. The data that matters is portable. The setup that doesn't transfer is rebuild-able. And the cost of staying in a tool that isn't working is almost always higher than the cost of a weekend spent migrating.