Open a transactions file in Excel

Transaction files in QBO, QFX, OFX, QIF, MT940/SAT format are great for processing, but not so great for review like CSV or Excel files. Use the ProperConvert app to open, review such files and convert them to a conventional table format like CSV or Excel.

Supported Account types

Bank (Checking/Savings/Credit Line)
Credit Card
Investment

QBO/QFX/OFX Format

QBO/QFX/OFX files are offered in online banking to download transaction details. OFX files provide the date, amount, payee/payer, memo, check number, investment details for investment transactions. OFX files are also called "Microsoft Money" files.

Quicken Interchange Format (QIF)

QIF files are Quicken Interchange Format files containing details about transactions:

Downloaded from your bank, credit card company, investment broker
Created as an export file by Quicken
Created as an export file by some personal finance software

MT940/SAT Format

These files are provided by many banks to download transactions for your accounts. Files are not readable when are opened in Notepad or directly in Excel.

How to open, review and convert transaction files

Download and install the ProperConvert app
Start the app and locate an QBO/QFX/OFX file
Click on the CSV tab on the right sidebar
Review transactions
Click Convert to save a CSV file and then open it in Excel (or other spreadsheet application) or click Copy to clipboard and then switch to Excel and click Paste there

Example how to convert a QFX file to CSV with QFX2CSV app

Here is a short video (1 min) showing the whole process of converting a QFX file to CSV format with QFX2CSV (replaced by the ProperConvert app):