HomeHelpAccountingExporting Accounting Data

Exporting Accounting Data

Export transactions to Sage, CSV, QIF, IIF or OFX, plus the journal entry, chart of accounts, VAT and audit log exports.

AccountantFinance ManagerSuper AdminLast reviewed 03 Aug 2026

Was this article helpful?

Related Articles

Chart of Accounts

Auto-seeded standard chart, the five account types and 1xxx-6xxx numbering, adding accounts, and the delete/deactivate rule.

Journal Entries

Balanced entries, approval controls, linked-source limits, retained reversals and how journals affect financial reports.

Bank Reconciliation

Review matched and unmatched bank items, mark a reconciliation complete and have a Finance Manager approve it.

Previous

Multi-Currency and Exchange Rates

Next

Audit Trail and System Monitoring

Several screens can push accounting data out of TravelFlow — for your accountant, for another package, or for a spreadsheet check. This article covers where each export lives and what it produces.

Exporting Transactions

Go to Accounting > Transactions > Data Import and open the Export tab. Choose a format, optionally set a from and to date, then click Export Transactions. Six formats are offered:

  • Sage Pastel — for Sage 50cloud Pastel (South Africa).
  • Sage Cloud — for Sage Business Cloud.
  • CSV — Excel compatible.
  • QIF — Quicken.
  • IIF — QuickBooks.
  • OFX — the bank statement interchange format.

The download is named for you and the number of records exported is reported when it completes. Leaving the dates blank exports everything available.

Exporting Journal Entries

On Accounting > Transactions > Ledger, the Export button downloads the entries currently showing as CSV, one row per line item, with date, entry number, reference, description, account code, account name, debit, credit and status. Filter the list first — the export follows your filters.

Exporting the Chart of Accounts

On Accounting > Transactions > Chart of Accounts, use Export Chart of Accounts in the Quick Actions panel. It downloads a CSV of code, name, type and balance, dated in the file name.

Other Exports

  • VAT — Accounting > Compliance > VAT offers Export, a VAT201 text file and a SARS eFiling CSV.
  • Financial reports — the Generate button on each card in Accounting > Financial > Reports downloads a PDF for the four financial statements and a text file for the rest.
  • Audit trail — Export Log on Accounting > Compliance > Audit Trail downloads the loaded entries as CSV.
Tip: Exports contain customer names, amounts and bank references. Send them through a channel your organisation approves for financial data, and delete local copies once your accountant confirms receipt.