Problem downloading qif file

Sending your feedback. Incorrect account balances If transactions in your account appear up to date, but the balances are incorrect - it's most likely the QIF file did not include an initial balance transfer as the first transaction for the account. To correct this, you can set the initial balance on your accounts in Moneydance manually. Foreign currency transfers with incorrect rates Unfortunately QIF files do not contain any currency or exchange rate information.

Moneydance is using the current rate on all foreign currency transfers. Incorrect transaction dates The QIF file can store the dates in one of 3 different formats.

You may need to repeat using each of the date formats until your data imports correctly. Imported categories names include 'xxxx' These were hidden categories that your software was using behind the scenes for various reasons depending on the software you were using and have been included in the QIF export file. Incorrect categories - If the categories have imported incorrectly, or all transactions have been assigned to the same category - It's most likely that your settings were slightly incorrect when you imported the QIF file.

Duplicated transfers - If transfers have been duplicated, you'll need to ensure that the dates are the same on both sides of the transfer. Some software supports different dates on the other side of transfers. You'll need to split up the file if it contains more than 1, bank transactions.

Xero recognises duplicate transactions already imported in other QIF files, and excludes them during import. Save each file with. For example, you might name your file Jan13bankstatement. Use the Date Format field to select the correct format. Use Next to view the next statement line, changing the date format if you need to.

Then click Save. Ask our community of customers, accountants and bookkeepers. Raise a case with our support team. Skip to main content. Sign up. Javascript is required to use the form above. Click here to use our alternative subscription form. OFX has had a good run, but more and more banks seem to be pulling the plug on this technology.

Log in to your account and navigate to the area where your bank allows you to download transaction history. If neither of those is available, choose the CSV format. Be aware that Banktivity cannot import investment data from CSV files.