Import a QFX file into Xero

Modified on Fri, Jul 2, 2021 at 5:17 PM

Xero is Online accounting system and it can import QFX files

This tutorial shows how to import a QFX file into Xero. To import a QFX file, login into Xero. Click on 'Accounting' - 'Bank accounts'. 

Then look for the account you want to import your transactions into and click 'Manage Account' - 'Import a statement'. 

Click the 'Browse' button. 

And select a QFX file. You can download it from your Online banking. Bank often provides QFX files, they also called Quicken files. If your Bank doesn't provide or provides different formats, let's say PDF format or QFX format, you can use Bank2QFX converter from ProperSoft and convert that file to the QFX format first and then import into Xero. IMPORTANT: Bank2QFX is now replaced with the Transactions app, which converts from more formats and converts to more formats. 

Then click 'Import'. 

And now your transactions are imported. You have to match them to Vendor records or Payee inside your system. And you have to select expense/income accounts. 

And then you click 'Add details' to actually add transactions to the register. 

Let's say you realized, that it is an incorrect imported QFX file or something wrong with a file, or you don't want those transactions to be here. So, click on 'Bank statements'. 

Then select all the accounts. 

And click 'Delete'. 

So, this way you delete all those transactions you just imported. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article