1. Home
  2. Knowledge Base
  3. Banking
  4. Account integration / Importing transactions
  5. How to Import bank transactions from a QFX, QBO, or OFX bank file export

How to Import bank transactions from a QFX, QBO, or OFX bank file export

Watch Video

In order to import transaction files from the bank, the bank must offer transaction export data downloads in QFX, QBO, or OFX format.

Account Integration must be activated to use this feature. Please email [email protected] or call (866) 346-4300 to request activation.


All banks are different, so the steps for downloading transaction files will look different depending on the bank.

  • Log in to the bank.
  • Select the account from which to import transactions.
  • Find the option to export transaction files.
  • Select one of the three types supported: QFX, QBO, or OFX.
  • Export the file to your computer.

Next, log in to MoneyMinder.


Click the Banking icon in the toolbar.


Click the Actions dropdown to the right of the bank account.


Choose Import Transactions from the dropdown:


Click the Import transactions from file instead button:


Drag & drop the export file from the bank to the area that says, Drop an exported QFX, QBO, or QFX file here or click to choose a file:


The following message will appear if the file was uploaded successfully:


Click the X to close this message.



Click the Import button next to each item to import:



Or click the Hide/Show button to hide it from the list:



Check that all required fields are completed. The Paid to data may populate in the Memo or Details fields and can be copy/pasted into the Paid to field if needed.

Note that banks do not collect the Paid to name, nor would it know the correct Category to select. This information will likely need to be manually entered.


Click Save & Close.



NOTES:

  1. MoneyMinder recognizes duplicate transactions, so that duplicate entries don’t get imported. Already imported transactions can be hidden from the import screen. And best of all, when reconciling, imported transactions are pre-checked, saving time.
  2. In order to import transactions into a bank account, a budget must be set up.


Back to the top

Was this article helpful?

Related Articles

2 Comments

  1. Janet Voyles

    How can I match an imported bank transaction to something I already entered? For instance I never checks as they are written and then when I import them it creates a duplicate entry and I have to delete my first one. Is there a way to match to an entry?

    1. Cyndi Meuchel

      Hi Janet,

      Great question! MoneyMinder does not automatically match a duplicate, but it does indicate duplicates. On your import screen, if you have a duplicate, you can use the ‘eyeball’ and hide those imports.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Need Support?

Can't find the answer you're looking for?
Contact Support