FreshBooks CSV Import and Export: Clients, Invoices, and Expenses

FreshBooks Speaks CSV for Freelancers and Small Firms

FreshBooks is popular with US and Canadian freelancers, agencies, and service businesses that still need CSV bridges for accountants, migrations, and bulk client updates. Exports are straightforward; imports are template-sensitive. A QuickBooks or Xero layout will not map cleanly without remapping columns.

Which FreshBooks CSV?

Export type determines columns.

Step-by-Step: Export for Your Accountant

Monthly handoff pattern.

• In FreshBooks, open Reports or the list view for clients/invoices/expenses.
• Set the date range to the accounting period (account timezone).
• Export CSV.
• Archive the raw file as client-period-freshbooks.csv.
• Open a working copy in the Online CSV Editor; drop totals footers if present.
• Normalize dates if the accountant uses a different locale.
• Convert to Excel if that is what the CPA requested.

Date,Merchant,Category,Amount,Currency,Tax Amount,Notes
2026-05-03,AWS,Software,42.18,USD,0.00,Hosting
2026-05-04,Adobe,Software,59.99,USD,0.00,Creative Cloud

Importing Clients and Expenses

Start from FreshBooks’ sample whenever the product offers one.

• Match header names exactly.
• Use one email per client row when email is the match key.
• Keep phone and postal/ZIP as text.
• Amount columns: plain decimals, no $.
• Tax columns: follow FreshBooks’ tax name/rate fields — do not invent codes from Xero.
• Pilot 5 rows before importing the full list.

US vs Canada: Dates and Sales Tax

FreshBooks spans both markets heavily.

• Confirm whether exported dates are YYYY-MM-DD or locale formatted.
• Canadian GST/HST/PST handling depends on how taxes were configured — CSV will not invent remittance logic.
• US sales tax similarly reflects invoice settings; exports help review, not file returns alone.
• When sharing files with UK contractors helping a US/CA business, convert dates to ISO to avoid MM/DD vs DD/MM swaps.

Invoices: Headers vs Line Items

Accountants often want line-level detail; owners want invoice totals.

• Know whether your export is one row per invoice or per line.
• Summing line rows without care double-counts if a total column is also present.
• Status (draft, sent, paid, overdue) should drive AR aging — filter drafts out of revenue.
• Payments exports explain cash; invoice exports explain billings — do not treat them as the same.

Migrating to or from QuickBooks / Xero

CSV is the usual bridge; map accounts deliberately.

• Export clients first; import to the destination CRM/ledger.
• Map FreshBooks categories to chart-of-accounts names.
• Bring open invoices in a controlled batch; reconcile AR.
• Convert specialty bank files via the Finance File Converter if bank history is part of the move.
• See QuickBooks CSV and Xero CSV guides for destination templates.

Excel Pitfalls

Same story as every accounting CSV.

• Long invoice numbers becoming scientific notation.
• ZIP codes losing leading zeros.
• Excel rewriting dates when a CA file meets a US Excel locale.
• Saving as the wrong CSV flavor (and breaking UTF-8 client names).

Common Mistakes

Close-period mistakes.

• Booking payments and invoice totals as two layers of revenue.
• Importing expenses with category names that do not exist in FreshBooks.
• Including draft invoices in sales totals.
• Merging multi-currency rows without a Currency column.
• Using a generic “accounting CSV” template that FreshBooks rejects.

Best Practices

Make FreshBooks CSV boring and repeatable.

• Fixed monthly export checklist: invoices, payments, expenses.
• Archive raw + cleaned files.
• Document tax and category mappings once.
• Pilot every new import type.
• Clean PII-aware client lists in the browser when contractors help.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Inspect FreshBooks exports in the Online CSV Editor, convert to Excel for CPAs, and normalize dates before cross-border sharing. Works on Windows, macOS, and Linux browsers.

Conclusion

FreshBooks CSV works when you pick the right export grain, protect IDs and ZIPs as text, and keep taxes/categories aligned with the product. Export deliberately, pilot imports, and never double-count invoices and payments.