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:
- 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.
- In order to import transactions into a bank account, a budget must be set up.
Connect your Venmo account to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Connect your Stripe Account to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Set up a MoneyMinder Store free. Just pay 0.4% /transaction*
Connect your Bank, Square and PayPal accounts to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Connect your Bank, Paypal and Square accounts to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Connect your Bank, Paypal and Square accounts to MoneyMinder PRO to directly download transactions, saving you time and effort. You just review the transactions to ensure they are properly categorized and fill out any required fields.
Join It is a membership management service that helps businesses and nonprofits effectively sell, track, and grow their membership.
2 Comments
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.