Balance and currency question
Hi
When importing the QIF file from Homebank, I have noticed that the posts seem OK but the balances are wrong.
Can you help with this?
Also, my basic currency is Euro but one account is in Swedish Krona but I am unable to change this.
Can you help with that too, please?
Thanks.
Eva
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
1 Posted by dwg on 14 Jan, 2025 09:18 PM
QIF imports only contain transactions, so If a balance is wrong it could mean missing transactions or the initial balance has been set wrongly or not set.
You can install and use the Toolbox extension to change the currency of an account, it will not change or recalculate any transactions just change the currency indicator.
Support Staff 2 Posted by Maddy on 15 Jan, 2025 01:11 PM
Hi Eva,
Thank you for contacting Moneydance support.
You could try importing the QIF file again by following the steps below:
Ideally you'll export one QIF file that contains all of your account data. Use the option to export 'all accounts' within one QIF file if this is available within the software you're using.
If not, you should export one QIF file for each account in your file.
Make sure you export any closed or inactive accounts containing transfers to your open accounts. You may need to re-open these accounts before exporting.
If you're using Moneydance for the first time, when you open the program, you'll see the Welcome window. Choose “Create a new account set” and setup a new data file.
If you have opened Moneydance previously, you can create a new data file by choosing File --> New --> Create a New File. Then follow the prompts to enter a name and currency for your new file.
When viewing your new data file, choose File --> Import. Then navigate to and select the QIF file.
You'll be asked which account you want to import your data into. If you have data for multiple accounts within one QIF file, you can pick any account.
Below this, Moneydance will automatically try to determine the date format and decimal character used within the QIF file.
If you want to check this, open the QIF file with a text based program like NotePad or TextEdit. This will allow you to check which date format and decimal character are being used.
Choose 'Import' and wait a moment while your accounts and data are imported into Moneydance.
If it appears some of your accounts are missing from the left side bar, press the '+' button at the bottom of the side bar. Choose 'Advanced'. You should see the missing accounts in the panel on the left - highlight the account name and press 'Add' to move the accounts into the panel on the right. When you're done press OK and these accounts should then be available for selection from within the side bar.
Some QIF files don’t include an 'Initial Balance' for your accounts (sometimes referred to as a beginning balance or a starting balance). If this is the case, you'll see all transactions have imported but the account balance will show a discrepancy.
To fix this, select the account and choose Account --> Edit Account. In this window, you can enter an amount into the 'Initial Balance' field.
For investment accounts, QIF file don’t always carry security prices other than buy/sell prices, so investment account balances may be wrong until you update with the current security prices.
Reminders are not included in QIF files as the QIF file format has no ability to include reminder data.
It may be worth referring you to this article of the Knowledge Base on Possible Problems After QIF Import.
Side note: Generally, if you require changing currencies in an specific account, you can follow the instruction below:
Navigate to "Extensions->Manage Extensions" and install the "Toolbox" v.1066.
Launch the "Toolbox" and select Update Mode
Navigate to Menu:Currency and Security Tools
In the resulting window, under "Update Functions" you should select:
"Fix: Force Change Accounts/Categories [& Securities] FROM Currency TO Currency
"Proceed" to select the relevant account/s.
Finally you should restart Moneydance to retain the changes.
I hope this information is helpful. Please let us know if you have further questions or need more assistance.
--
Maddy, Infinite Kind Support