Which export format should you choose?
Match the file format to the application you use next.
Spreadsheets and reporting
Excel preserves typed values and formatting. CSV is useful for broad compatibility. Categorised Excel adds a category summary, while JSON is suited to data pipelines.
Accounting applications
Xero CSV uses signed amounts. QBO and QFX include institution and account identifiers; receiving software may restrict which institutions or file versions it accepts.
Treasury and ERP systems
MT940 and CAMT.053 represent structured statements. Confirm the expected format version with the receiving system and validate a test import before using production records.