Data Upload and Export in QuickBooks, Xero and Wave

CLOUD ACCOUNTING KNOWLEDGE SERIES

Data Upload and Export in QuickBooks, Xero and Wave

A practical guide to moving accounting data into and out of cloud accounting software

Every cloud accounting engagement eventually comes down to one question: how does data move between systems? Whether the firm is migrating a client from a spreadsheet, reconciling a bank feed, or preparing management reports for a board, the same two operations recur — uploading data into the software, and exporting data out of it. This guide sets out both processes for the three platforms most commonly encountered in practice: QuickBooks Online, Xero and Wave.

1. Upload vs. Export: The Core Distinction

The distinction is simple, but it is the foundation for everything that follows.

Excel / CSV file  →  Map columns  →  QuickBooks Online  →  Accounting records

Worked Example — Upload

A simple bank transaction file:

Once imported, these two lines are added to the ledger as posted transactions — ready for categorisation and reconciliation.

Worked Example — Export

A Profit and Loss report exported for a client review:

QuickBooks Online → Profit and Loss Report → Export → Profit_Loss_September_2026.xlsx

2. File Formats Used in Cloud Accounting

Beyond CSV, accounting software supports a range of file formats depending on the data being moved and the systems involved.

For a practitioner building fluency across platforms, the priority order is: XLSX for preparation, CSV for import and export, PDF for reports and statements, OFX/QBO for bank feeds, and JSON for API-driven and AI-assisted automation.

3. Uploading Data by Platform

3.1  QuickBooks Online

Commonly imported data: customers, suppliers/vendors, chart of accounts, products and services, invoices, bills, journal entries and bank transactions. Standard format: CSV or Excel, depending on the data type.

Prepare data → Format CSV/Excel → Settings → Import → Select data → Upload → Map columns → Review → Import

Example journal-style import:

3.2  Xero

Commonly imported data: chart of accounts, contacts, invoices, bills, bank statements/transactions, items and journal entries. Supported formats: CSV, Excel, and bank statement formats accepted by Xero.

Prepare file → Xero → Import → Select data → Upload → Match/map columns → Check → Import

Example bank transaction file:

3.3  Wave

Wave supports importing certain accounting information — particularly bank transactions and customer/vendor-related data — subject to its current import functionality.

Prepare CSV → Wave → Banking/Accounting → Import → Upload → Map columns → Review → Import

4. Exporting Data by Platform

4.1  QuickBooks Online

Settings ⚙ → Export Data → Select data → Export to Excel/CSV

Commonly exported: Profit and Loss, Balance Sheet, Trial Balance, General Ledger, Journal Entries, Customers, Vendors, Invoices, Bills, Chart of Accounts, Products and Services, tax information, and bank transactions/reports.

4.2  Xero

Accounting/Reports → Select report → Export → Excel/CSV/PDF

Commonly exported: Profit and Loss, Balance Sheet, Trial Balance, General Ledger, Account Transactions, Invoices, Bills, Contacts, Chart of Accounts, bank transactions, and tax/VAT reports.

4.3  Wave

Accounting/Reports → Select report → Export/Download

Depending on the report or data type, Wave can typically export: Profit and Loss, Balance Sheet, General Ledger, account transactions, invoices, customers, payments, and related accounting information.

Export Formats at a Glance

One caution worth carrying into every migration engagement: exporting a report is not the same as exporting the entire company database. Migration work is normally built from specific lists and transactions, exported, cleaned and mapped, and only then imported into the new system — not from a single wholesale export.

5. A Practical Migration Workflow

For engagements that move a client from an old system — or from spreadsheets — into QuickBooks, Xero or Wave, the following sequence keeps the work controlled and auditable:

1. Export or extract the source data (old system, bank, or spreadsheet).
2. Clean the data in Excel: remove duplicates, standardise dates, correct account names.
3. Map each data type to the destination platform’s required CSV template.
4. Upload in a logical order — Chart of Accounts and Contacts first, then opening balances, then transactions.
5. Review imported records against the source before proceeding further.
6. Reconcile bank feeds and ledger balances.
7. Generate reports and export them for client sign-off and record-keeping.

Source data → CSV/Excel → Clean and map → Upload → Review → Reconcile → Report → Export

6. Key Takeaways

• Upload moves data into the software; export takes data out — the direction is the entire distinction.
• CSV and Excel cover most day-to-day needs; PDF is for finished reports and statements; OFX/QBO/QFX are bank-specific; JSON supports API and automation work.
• QuickBooks, Xero and Wave each require their own CSV template for each data type — customers, bank transactions and journal entries are never interchangeable across platforms.
• Exporting a single report is not equivalent to exporting the full company database — plan migrations around specific lists and transactions.
• A disciplined workflow — clean, map, upload, review, reconcile, report, export — keeps every migration or reporting engagement auditable.

Ismail and Associates  provides chartered accountancy, tax, VAT, audit and corporate advisory services, with dedicated expertise across cloud accounting platforms including QuickBooks Online, Xero, Wave, Zoro