Bank2OFX: Convert CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to OFX

Bank2OFX: Convert CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to OFX

Need to import transactions, but the format is not supported? Convert CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to OFX and import into Xero, QB Online, Xero, QB Online, Sage One, YNAB, AccountEdge, Banktivity, Ace Money. Create importable OFX files



What can I do with Bank2OFX (CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF to OFX Converter)?

Why should I trust Bank2OFX?

If I need any help with conversion, can you help me?

Can I try before purchasing?

Convert CSV, Excel, PDF, QFX, QBO, OFX, QIF to OFX and import into MS Money, Xero, Sage, and other accounting software

This tutorial shows how to convert a transactions file to OFX format. We will use Bank2OFX utility.

Step by step instructions for Windows

See below steps for the Windows version, followed by the Mac version.

Make sure you are using the latest version of Bank2OFX. Download it from the Bank2OFX download page. Start Bank2OFX and select a transactions file (it could be QBO file, OFX file, QFX file, QIF file or PDF file).

Bank2OFX Windows Step 1: select a pdf file

Review transactions before converting, check that dates are correct, have the correct year, deposits and withdrawals are in correct places.

Bank2OFX Windows Step 2: review transactions before converting

Try a different PDF Library if your PDF file is not parsed correctly by the selected library. The Parser provides two PDF Libraries for you to choose.

Bank2OFX Windows Step 3: PDF Library

Set the Account ID (number) and the Account Type. For multiple accounts, use a different Account ID for each account.

Bank2OFX Windows Step 4: Account ID, Account Type

Make sure to set Currency. And you can set Bank ID, Branch ID if your accounting software requires.

Bank2OFX Windows Step 5: currency

Choose the OFX Target to better work with your accounting software or use the "Regular OFX" option.

Bank2OFX Windows Step 6: Target

Click the 'Convert' button to create an OFX file.

Bank2OFX Windows Step 7: click Convert

Confirm the file name and location.

Bank2OFX Windows Step 8: file name and location, save

Import created OFX file into Xero

Click on 'Manage Account' and look for the link 'Import a Statement'. In your accounting software, look for "Upload a bank file" or similar links to upload created OFX file.

Bank2OFX Windows Step 9: import a bank statement in Xero

Click the 'Browse' button and select the OFX file.

Bank2OFX Windows Step 10: click Browse in Xero

Then click the 'Import' button.

Bank2OFX Windows Step 11: click Import in Xero

Once the transactions are imported, you can review, categorize them under the account.

Bank2OFX Windows Step 12: transactions are imported in Xero

Step by step instructions for macOS

Make sure you are using the latest version of Bank2OFX. Download it from the Bank2OFX download page. Start Bank2OFX and select a transactions file (it could be QBO file, OFX file, QFX file, QIF file or PDF file).

Bank2OFX Mac Step 1: select a pdf file

Review transactions before converting, check that dates are correct, have correct year, deposits and withdrawals are in correct places.

Bank2OFX Mac Step 2: review transactions before converting

Before creating OFX file set the Account ID (number) and the Account Type. For multiple accounts, use a different Account ID for each account.

Bank2OFX Mac Step 3: Account ID and Account Type

Make sure to set Currency. And you can set Bank ID, Branch ID if your accounting software requires.

Bank2OFX Mac Step 4: currency

Choose the OFX Target to better work with your accounting software or use the "Regular OFX" option.

Bank2OFX Mac Step 5: OFX Target

Click the 'Convert' button to create an OFX file.

Bank2OFX Mac Step 6: click Convert

Confirm the file name and location.

Bank2OFX Mac Step 7: confirm file name and location

Import created OFX file into Xero

Click on 'Manage Account' and look for the link 'Import a Statement'. In your accounting software, look for "Upload a bank file" or similar links to upload created OFX file.

Bank2OFX Mac Step 8: import a statement in Xero

Click the 'Browse' button and select the OFX file.

Bank2OFX Mac Step 9: click browse in Xero

Then click the 'Import' button.

Bank2OFX Mac Step 10: click import in Xero

Once the transactions are imported, you can review, categorize them under the account.

Bank2OFX Mac Step 11: transactions imported in Xero