Wave Accounting CSV: Customers, Invoices, and Transactions

Wave Is Popular — Accountants Still Want CSV

Wave’s free accounting tooling is common among US and Canadian freelancers, side hustles, and micro-businesses. Exports help CPAs, migrations to QuickBooks/Xero, and bulk customer updates. Imports are template-driven: inventing columns or mixing FreshBooks layouts creates rejects and duplicates.

Which Wave CSV?

Match the export to the question.

Step-by-Step: Export for Your Bookkeeper

A simple monthly pack.

• In Wave, open the report or list you need.
• Set the date range to the accounting period.
• Export CSV.
• Name files wave-client-YYYY-MM-invoices.csv style.
• Preview in Online CSV Editor; drop summary footers.
• Normalize dates if your CPA uses a different locale.
• Convert to Excel when requested.

Date,Description,Account,Amount,Currency
2026-05-03,Stripe payout,Checking,1452.10,USD
2026-05-03,Software - Adobe,Expenses,-59.99,USD

Importing Customers and Transactions

Use Wave’s documented import path and sample when available.

• Match headers exactly.
• One email per customer when email is the key.
• Amounts: plain decimals without $.
• Keep account names consistent with Wave’s chart.
• Pilot 5–10 rows before full load.
• Reconcile account balances after import.

US vs Canada Notes

Wave spans both markets heavily.

• Sales tax / GST-HST depends on how taxes were configured in Wave — CSV reviews amounts, it does not file returns.
• Confirm date formatting when sharing with UK contractors helping a NA business — prefer ISO YYYY-MM-DD.
• Multi-currency: keep a Currency column; never sum CAD and USD raw.
• Bank CSV uploads (if used) still need signed amounts and clean dates — see bank statement guides.

Stripe/PayPal Deposits into Wave

Do not book payouts as sales twice.

• Invoices/sales capture revenue.
• Processor payouts are transfers into checking (net of fees).
• Import or categorize fees as expenses.
• See Stripe CSV and PayPal CSV guides for processor-side cleanup.

Migrating Wave → QuickBooks / Xero / FreshBooks

CSV is the usual bridge.

• Export customers first.
• Map Wave accounts/categories to the destination chart.
• Bring open invoices carefully; reconcile AR.
• Historical transactions in date batches beat one giant file.
• Read destination guides (QuickBooks, Xero, FreshBooks) for template rules.

Excel Pitfalls

Same accounting CSV traps.

• ZIP/postal codes losing leading zeros.
• Invoice numbers in scientific notation.
• Date swaps when CA files meet US Excel.
• UTF-8 names corrupted by legacy ANSI saves.

Common Mistakes

Close mistakes.

• Treating transfers as income.
• Including drafts in sales totals.
• Importing without matching category names.
• Merging multi-currency without splitting.
• Using a generic ledger CSV that Wave’s importer rejects.

Best Practices

Make Wave CSV handoffs boring.

• Monthly export checklist: invoices, expenses, transactions.
• Archive raw + cleaned files.
• Document tax and category mappings.
• Pilot every new import type.
• Clean client PII in-browser when freelancers help.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Inspect Wave exports in the Online CSV Editor, convert to Excel for CPAs, and normalize dates before sharing across US/CA teams on Windows, macOS, or Linux.

Conclusion

Wave CSV works when you pick the right export, protect identity fields as text, and keep revenue separate from bank transfers. Export deliberately, pilot imports, and map carefully when leaving Wave for another ledger.