How do I export my transactions, expenses, and bills from OFX?

OFX's Export Data feature lets you download your Transactions, Expenses, and Bills data in a structured file format, ready for import into your accounting software. When exporting, you select your accounting provider, which determines the columns and data structure of the exported file — so your data is ready to import without manual reformatting.

Before you export data, ensure you have:

Permission to view and export financial data (typically available to account administrators or users with the relevant access rights).
The relevant data available in your account (Transactions, Expenses, or Bills).

Exporting Transactions

To export your transaction history, follow these steps:

Log into your OFX account and navigate to the Accounts section from the left-hand sidebar.
Select the currency account you wish to export, or choose All Accounts to export transactions across all wallets at once.
Click the Export button to open the export panel.
Displays the Export data - Transactions.
Select your accounting provider from the available options:
a. NetSuite — Exports an enriched 11-column format including Event, Transaction, Counterparty, Transaction ID, Linked Transaction ID, Account, Exchange Rate, Currency, Running Balance, Amount, and Date.
b. Microsoft Dynamics — Exports the same enriched 11-column format as NetSuite.
c. QuickBooks — Exports a simplified 3-column format (Date, Description, Amount). Note: The All Accounts batch export and the Running Balance, Account, and Exchange Rate columns are not available for QuickBooks.
d. Other — Exports the same enriched 11-column format as NetSuite. Use this option if your accounting software is not listed (including Xero).
Select a timeframe - Start Date, End Date
Export transactions for which account or currency? - Accounts or Currency: Exports transactions for a selected account or currency.
Select your preferred file format:
1. CSV — Available for all providers and all account selections, including All Accounts (batch export).
2. XLSX — Available for single account exports only. XLSX is not available when All Accounts is selected.
Click Export to download your file. If you selected All Accounts, the system will generate one CSV file per wallet, zip them into a single archive, and notify you when the file is ready (this may take a few minutes).

Exporting Expenses

To export your expense records, follow these steps:

Log into your OFX account and navigate to the Expenses section from the left-hand sidebar.
Click the Export button to open the export panel.
Displays Export data - Expenses.
Select your accounting provider from the available options:
a. NetSuite — Exports a flexible format with External ID, Vendor, Date, and additional dynamic columns based on your expense data (e.g. category, tax, amount).
b. Oracle — Exports the same format as NetSuite (External ID, Vendor, Date, plus dynamic columns). Note: Oracle is available for Expenses only — it is not available for Transactions or Bills.
c. Microsoft Dynamics — Exports a structured journal-entry format with detailed columns including journal references, ledger dimensions, exchange rate, approver information, tax groups, and line items.
d. QuickBooks — Exports a bill-style format with columns including BillNo, Supplier, BillDate, DueDate, Terms, Location, Memo, Account, LineDescription, LineAmount, LineTaxCode, and Currency. For expenses with multiple line items, a separate row is created for each line item.
e. Other — Exports a comprehensive format including ID, Supplier, Category, Date, Settlement date, Accounting status, Amount, User, Expense category, Currency, Receipt, Tax amount, Tax rate, Budget, CardHolderName, and line item details. Use this option if your accounting software is not listed (including Xero).
Select an expense type for export
1. All expense sources
2. Spend on OFX card
3. Uploaded expenses
Select a date type to filter on
1. Approved date, the date range when the expense was approved.
2. Transaction date, the date range when the expense transaction occurred.
Select expense statuses for export
1. Open and closed expenses
2. Open expenses only
3. Closed expenses only
4. Pending expense only
Select your date range for the export.
Select your preferred file format — CSV or XLSX.
Click Export to download your file. The system will zip expense files into a single archive, and notify you when the file is ready (this may take a few minutes).

Exporting Bills

To export your bills, follow these steps:

Log into your OFX account and navigate to the Bills section from the left-hand sidebar.
Click the Export button to open the export panel.
Displays the Export data - Bills.
Select your accounting provider from the available options:
a. QuickBooks — Exports a bill-style format with columns including BillNo, Supplier, BillDate, DueDate, Memo, Account, LineDescription, LineAmount, LineTaxCode, and Currency. For bills with multiple line items, a separate row is created per line item.
b. Microsoft Dynamics — Exports a structured journal-entry format with detailed columns including journal references, ledger dimensions, exchange rate, approver information, tax groups, and line items. For bills with multiple line items, a row is created per line item plus a summary total row.
c. Other — Exports a comprehensive format including ID, Supplier, Invoice number, Invoice date, Due date, Planned payment date, Amount, Currency, Status, Accounting status, Tax type, Tax rate, Tax amount, Account code, Xero tracking categories, Budget, Notes, and line items. When Xero is connected, additional Xero-specific fields are populated automatically.
Select your date filter type:
a. Created date — Filter bills by the date they were created in OFX.
b. Pay date — Filter bills by the date they were paid.
c. Planned payment date — Filter bills by their planned payment date.
Select your date range.
Select bill events to show on this report, below are the Bill statuses.
1. Draft
2. Awaiting payment
3. Needs Approval
4. Payment processing
5. Paid
Select your preferred file format — CSV, XLSX. or Zip file with the bills attached documents (pdf).
Click Export to download your file.

Why is this important

Exporting your financial data from OFX helps you keep your accounting records up to date and reduces manual data entry. By selecting the right accounting provider when exporting, your data is structured in the exact format your software expects — saving you time and minimising errors during reconciliation.

Key benefits include:

Faster reconciliation — Export data in a format that maps directly to your accounting software, whether that's NetSuite, Microsoft Dynamics, QuickBooks, Xero (via Other), or another system.
Flexible file formats — Choose between CSV and XLSX to suit your workflow.
Batch export for Transactions — Export all your currency accounts at once with the All Accounts option (available for NetSuite and Other providers).
Date filter options for Bills — Filter by created date, pay date, or planned payment date to export exactly the records you need.
Multi-line item support — For Expenses and Bills with multiple line items, each line item is exported as a separate row, giving you full visibility of your costs.

Provider and Feature Summary

Feature	NetSuite	Oracle	Microsoft Dynamics	QuickBooks	Other
AVAILABILITY
Available for Transactions	✅	❌	✅	✅	✅
Available for Expenses	✅	✅	✅	✅	✅
Available for Bills	❌	❌	✅	✅	✅
FILE FORMATS
CSV	✅	✅	✅	✅	✅
XLSX (single account / record)	✅	✅	✅	✅	✅
ZIP with PDF attachments (Bills only)	❌	❌	❌	❌	✅
TRANSACTIONS
Column format	11-col enriched	N/A	11-col enriched	3-col simplified	11-col enriched
Running Balance column	✅	N/A	✅	❌	✅
Exchange Rate column	✅	N/A	✅	❌	✅
Account column	✅	N/A	✅	❌	✅
Batch export — All Accounts (CSV only)	✅	N/A	❌	❌	✅
EXPENSES
Budget field	✅	✅	Not mapped	Not mapped	✅
Exchange Rate	❌	❌	✅	❌	❌
Approver Info	❌	❌	✅	❌	❌
Receipt field	❌	❌	❌	❌	✅
Cardholder Name	❌	❌	❌	❌	✅
Line items (multi-row)	✅	✅	✅	✅	✅
BILLS
Planned Payment Date	N/A	N/A	❌	❌	✅
Exchange Rate	N/A	N/A	✅	❌	❌
Approver Info	N/A	N/A	✅	❌	❌
Xero Tracking Categories	N/A	N/A	❌	❌	✅
Budget	N/A	N/A	❌	❌	✅
Notes	N/A	N/A	❌	❌	✅
Bill Status	N/A	N/A	✅ (`Approved`)	❌	✅
Line items (multi-row + summary row)	N/A	N/A	✅	✅	✅

Export Column Reference — By Data Type

The following tables summarise which columns are included in each provider's export file. Use these as a quick reference when troubleshooting missing fields or mapping issues.

Transactions — Column Reference by Provider

Transactions exports support NetSuite, Microsoft Dynamics, QuickBooks, and Other. Oracle is not available for Transactions.

Format A — Enriched 11-Column Format (NetSuite, Microsoft Dynamics, Other)

	Column	Description
1	Event	Type of transaction (e.g. Payment, Conversion, Card Payment)
2	Transaction	Description of the transaction
3	Counterparty	Name of the counterparty
4	Transaction ID	Unique transaction identifier
5	Linked Transaction ID	ID of any linked/related transaction
6	Account	Wallet/account the transaction belongs to
7	Exchange Rate	FX rate applied (where applicable)
8	Currency	Transaction currency
9	Running Balance	Wallet balance after this transaction
10	Amount	Amount added or subtracted
11	Date	Transaction date (company timezone)

Format B — Simplified 3-Column Format (QuickBooks only)

	Column	Description
1	Date	Transaction date
2	Description	Transaction description
3	Amount	Transaction amount

⚠️ QuickBooks note: Running Balance, Account, and Exchange Rate columns are not included. Batch export (All Accounts) is also not available for QuickBooks.

Transactions — Provider Feature Comparison

Feature	NetSuite	MS Dynamics	QuickBooks	Other
Column format	11-col enriched	11-col enriched	3-col simplified	11-col enriched
Running Balance	✅	✅	❌	✅
Exchange Rate	✅	✅	❌	✅
Account column	✅	✅	❌	✅
Batch export (All Accounts)	✅	❌	❌	✅
XLSX (single account)	✅	✅	✅	✅

Expenses — Column Reference by Provider

Expenses exports support NetSuite, Oracle, Microsoft Dynamics, QuickBooks, and Other.
Oracle is exclusively available for Expenses — it is not available for Transactions or Bills.

Column	NetSuite	Oracle	MS Dynamics	QuickBooks	Other
External ID / ID	✅	✅	—	—	✅
Vendor / Supplier	✅	✅	—	✅	✅
Date / TransDate	✅	✅	✅	✅	✅
Amount	(dynamic)	(dynamic)	Debit/Credit cols	LineAmount	✅
Currency	(dynamic)	(dynamic)	CurrencyCode	✅	✅
Tax	(dynamic)	(dynamic)	TaxGroup / TaxItemGroup	LineTaxCode	Tax amount + Tax rate
Exchange Rate	—	—	ExchRate	—	—
Journal / Ledger fields	—	—	✅ Full journal	—	—
Approver Info	—	—	✅	—	—
Budget	(dynamic)	(dynamic)	⚠️ Not mapped	⚠️ Not mapped	✅
Receipt attached?	—	—	—	—	✅
Cardholder Name	—	—	—	—	✅
Line items (multi-row)	(dynamic)	(dynamic)	✅ per row	✅ per row	✅

Known limitation: The Budget field is not currently mapped in QuickBooks and Microsoft Dynamics expense exports. Use the Other format if Budget data is required.
NetSuite & Oracle use a flexible dynamic schema — additional columns are appended based on your expense data (e.g. custom categories, tax fields).
Microsoft Dynamics uses a structured journal-entry format (26 columns) designed for direct import into Dynamics 365 Finance & Operations.

Bills — Column Reference by Provider

Bills exports support QuickBooks, Microsoft Dynamics, and Other only.
NetSuite and Oracle are not available for Bills export.

Column	QuickBooks	MS Dynamics	Other
Bill / Invoice Reference	BillNo	Invoice	Invoice number
Supplier	✅	—	✅
Invoice Date	BillDate	TransDate / DocumentDate	Invoice date
Due Date	✅	Due	✅
Planned Payment Date	—	—	✅
Amount	LineAmount	Debit / Credit cols	✅
Currency	✅	CurrencyCode	✅
Tax	LineTaxCode	TaxGroup / TaxItemGroup	Tax type + Tax rate + Tax amount
Account Code	Account	LedgerDimension	✅
Exchange Rate	—	ExchRate	—
Journal / Ledger fields	—	✅ Full journal	—
Approver Info	—	✅	—
Xero Tracking Categories	—	—	✅ (when Xero connected)
Budget	—	—	✅
Notes	—	—	✅
Bill Status	—	Approved field	✅
Line items (multi-row)	✅ per row	✅ per row + summary row	✅

NetSuite / Oracle not supported for Bills. If you need NetSuite-compatible output for bills, use the Other format and reformat manually.
Xero users: When Xero is connected, the Other format is automatically enriched with Xero-specific fields including Tracking Categories (up to 2) and Account Codes.
Microsoft Dynamics adds a summary total row per bill in addition to individual line item rows.