This tutorial shows how to convert a CSV file from your bank or credit card statement to OFX format and import into Quickbooks Online and Xero. We will use CSV2OFX 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 CSV2OFX. Download it from the CSV2OFX download page. Start CSV2OFX and select a CSV file.

Review transactions before converting, reassign columns if needed. Make sure expenses are negative and deposits are positive.

Set the Account ID (number) and the Account Type.

Also check Currency, End balance, Bank ID and Branch ID.

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

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

Confirm the file name and location.

Import created OFX file into Quickbooks Online

Now the OFX file is created, let's switch to Quickbooks Online and import created OFX file. Look for the 'Banking' and click on it. Click the 'Upload transactions manually' button. In your accounting software, look for 'File Upload, 'Import a statement', 'Upload a bank file' or similar links to upload created OFX file.

Once the transactions are imported, you can review, categorize them under the account and add to the register.

Payee name did not assign because this is Vendor Record that you have to select in Quickbooks. This is not actual Payee from the OFX file.

Import created OFX file into Xero

Look for the link 'Import a bank statement to get started' and click on it.

In this case, the OFX format is recommended. You can also do QFX, QBO, QIF, CSV formats.

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

Then click the 'Import' button.

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

Step by step instructions for macOS

Make sure you are using the latest version of CSV2OFX. Download it from the CSV2OFX download page. Start CSV2OFX and select a CSV file.

Review transactions before converting, reassign columns if needed. Make sure expenses are negative and deposits are positive. Check that dates are correct, have a correct year, amount, payee name, memo, check number is assigned.

Before creating OFX file set the Account ID (number) and the Account Type.

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

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

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

Confirm the file name and location.

Import created OFX file into Quickbooks Online

Now the OFX file is created, let's switch to Quickbooks Online and import created OFX file. Look for the 'Banking' and click on it.

And then select the account you want to import your data into.

Click the 'File Upload' button. In your accounting software, look for 'Import a statement', 'Upload a bank file' or similar links to upload created OFX file.

Then click the 'Browse' button and select the created OFX file. And click 'Next'.

Then select an account in Quickbooks to import and click 'Next'.

Once the transactions are imported, you can review, categorize them under the account and add to the register.

Payee name did not assign because this is Vendor Record that you have to select in Quickbooks. This is not actual Payee from the OFX file.

Import created OFX file into Xero

Click on 'Manage Account' and look for the link 'Import a Statement'.

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

Then click the 'Import' button.

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