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

Importing bank transactions from a QFX, QBO, or OFX bank file export

In order to import transaction files from your bank, your 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 your bank. You will:

  • Log in to your bank.
  • Select the account from which you would like 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 your MoneyMinder Account.


Click on the Banking icon in the toolbar.


Next, click Import Transactions under the bank account you’d like to import into:


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



If you have linked your bank account to MoneyMinder you will select the button that says Import transactions from file instead:



The following message will appear letting you know the file was uploaded successfully:


Click the X to close this message.



Click the Import button next to each item you would like to import:



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



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

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


Click Save & Close.



NOTES:

  1. MoneyMinder recognizes duplicate transactions, saving you from accidentally importing duplicate entries. You can also hide your already imported transactions. And best of all, when you go to reconcile, imported transactions are pre-checked, saving you time.
  2. In order to import transactions into a bank account, you must first set up a budget.

Was this article helpful?

Related Articles

2 responses to “Importing bank transactions from a QFX, QBO, or OFX bank file export”

  1. 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?

    • 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.

Need Support?

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