What we do
Tools
Industries
Department
How we workLet's talk →
Home/FreshBooks/FreshBooks Import From QuickBooks, Two Routes
FreshBooks + QuickBooks

FreshBooks Import From QuickBooks: Your Lists by CSV, Your Invoice History Through Easy Switch

You've exported your customer list from QuickBooks and you're looking at FreshBooks, wondering where it goes. Clients, items, vendors and expenses can all come in as CSV files you map yourself. Past invoices aren't on that list. For those, FreshBooks offers Easy Switch, where a migration partner moves client details, expenses and invoices out of QuickBooks for you.

What moves, and how

Clients: a CSV import you map column by column.

Clients More Actions Import Clients

Items, vendors, expenses and bank transactions for reconciliation: CSV imports too. Expenses can also arrive from a connected bank or card account, which pulls in between 30 and 365 days of activity.

Taxes and other income: fill in FreshBooks' example CSV files and send them to FreshBooks Support, who do that import for you.

Invoices and history: not on the self-serve list. Easy Switch is FreshBooks' route for them. It's included on some Select plans and discounted on Plus, Premium and other Select plans; ask through Talk to a Specialist on the Select plan page.

Easy Switch or your own CSV files

Easy Switch

A migration partner moves it

  • Covers client details, expenses and invoices from QuickBooks.
  • Brings invoices, which the self-serve CSV import can't.
  • Cost depends on your plan: included on some Select plans, discounted on the rest.
CSV import

You map each list yourself

  • Clients, items, vendors, expenses and bank transactions.
  • Nothing to book. You can run it the day you sign up.
  • No invoice history, so past invoices stay in QuickBooks or in an export you keep.

If old invoices need to live in FreshBooks, ask about Easy Switch before importing anything by hand. If you only need clients and items to start invoicing, the CSV import is enough.

Bringing QuickBooks customers into FreshBooks as clients

  1. 1

    Export the customer list from QuickBooks

    In QuickBooks Online, the Export icon above the customer list gives you a spreadsheet of every customer. To choose the columns, run the Customer Contact List report and export that instead. Our QuickBooks customer list export page has the clicks for Online and Desktop.

    Watch for: sub-customers and projects. QuickBooks lists them as rows of their own, and FreshBooks would turn each one into a separate client.

  2. 2

    Trim the file and save it as CSV

    Delete the rows you don't want in FreshBooks, such as inactive customers and repeats, then save as CSV.

    Watch for: duplicates. FreshBooks imports every row, even a client that already exists, so the file has to be clean before it goes in.

  3. 3

    Start the client import

    Clients More Actions Import Clients

    Upload the file. FreshBooks lists the columns it found, each with a dropdown of FreshBooks fields.

  4. 4

    Match each column to a FreshBooks field

    Pick a field for every column you want to keep. A column you leave unmatched doesn't come across, so decide now what you can live without.

    Watch for: your plan's client limit. Importing more clients than the plan allows brings up an upgrade prompt, and the fix is a shorter file or a different plan.

  5. 5

    Do items, vendors and expenses one at a time

    Each list has its own CSV import. Check a handful of records after each one before you start the next, while a mistake is still easy to spot.

When QuickBooks and FreshBooks both stay

Some businesses aren't switching at all. One team invoices clients in FreshBooks while the company's books stay in QuickBooks, often because the accountant works there. FreshBooks' import tools are made for a one-time move, so nothing in them keeps the two current afterwards.

Zapier has apps for both, which covers a simple one-way step such as creating a QuickBooks customer when a FreshBooks client is added. Invoices and payments that have to match on both sides, taxes and partial payments included, are where n-frames builds the sync against both APIs, so nobody re-enters an invoice in the second system. What the FreshBooks side allows is on our FreshBooks API page.

Imported QuickBooks clients that need a second pass

The same client twice

How you'll know: A client appears twice, often once under the company name and once under a contact's name.

Fix: FreshBooks doesn't filter duplicates on import. Remove the extra record before anyone invoices from it, and dedupe the next file before it goes in.

Jobs that turned into clients

How you'll know: Rows like 'Smith: kitchen remodel' now sit in FreshBooks as clients of their own.

Fix: Decide whether each job is a client or a FreshBooks project under one client, and tidy the extras before invoices build up against them.

Custom fields that never arrived

How you'll know: Columns you relied on in QuickBooks are nowhere in FreshBooks.

Fix: A column only imports if it matches a FreshBooks field. Map what matters to a field that exists, and keep the rest in the export you saved.

Balances that disappeared

How you'll know: Clients owed you money in QuickBooks and show nothing owing in FreshBooks.

Fix: A client import brings the contact, not what they owe. Recreate open invoices in FreshBooks or move them through Easy Switch, then check each client against QuickBooks' A/R aging report.

Moving QuickBooks data into FreshBooks: common questions

Can I import QuickBooks data directly into FreshBooks?

Not with one click from inside FreshBooks. You export each list from QuickBooks, save it as CSV and import it into FreshBooks, mapping the columns as you go. To have invoices and expenses moved for you, FreshBooks' Easy Switch service does it through a migration partner.

Does FreshBooks integrate with QuickBooks for an ongoing sync?

FreshBooks has no QuickBooks sync of its own. Its import tools move data once. With both running side by side, a Zapier step handles simple one-way cases, and anything two-way, such as invoices and payments matching in both, is a custom integration built against both APIs.

What data gets lost when migrating from QuickBooks to FreshBooks?

With a do-it-yourself CSV import, the usual losses are custom fields with no matching FreshBooks field, invoice history, since the CSV imports don't take invoices, and each client's open balance. Current clients, items, vendors and expenses come across cleanly when the columns are mapped with care. Keep your QuickBooks exports for whatever you leave behind.

Who maps a messy QuickBooks export to FreshBooks' fields?

That's migration work n-frames takes on when a straight import would lose too much. We map each QuickBooks column to FreshBooks' structure before the import runs, including the custom fields and categories QuickBooks arranges differently, so the history you bring over survives the move. For a business keeping both, n-frames builds the API sync instead.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.