Import file from Money not recognised
Frederick Habbe
via web
I have only two file options to save files for export in MS Money:
Loose QIF
Strict QIF
I tried Loose QIF, but when trying to import the file into Moneydance, I get the following message:
Error reading file: java.io.IOException: Unexpected end of message while reading headers.
The file extension is .Ird
Support Staff 2 Posted by Ben Spencer on 02 Apr, 2010 01:55 PM
Hi Frederick
That is curious. The file extension for the file exported from MS Money should be .qif
Are you certain you are trying to import the correct file?
Loose QIF is the correct format.
Sincerely
Ben Spencer
3 Posted by Frederick Habbe on 02 Apr, 2010 02:09 PM
Thanks for the reply, Ben. I now selected the Quicken qif format and it worked. How can I get the categories to synchronise? At the moment all transactions have been imported under the first expense master category. Do I need to set up an identical category structure in Moneydance?
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 02 April 2010 14:58
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
4 Posted by Frederick Habbe on 02 Apr, 2010 02:09 PM
Hi Ben,
Another question: I have downloaded the UK version (if there is such a thing). But when trying to download the UK bank institutions only US ones appear. The bank connectivity was the main reason for me to opt for Moneydance.
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 02 April 2010 14:58
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Support Staff 5 Posted by Ben Spencer on 02 Apr, 2010 02:43 PM
With regard to getting Moneydance to use the categories in your QIF file you must set the source on the import window to "From another program" otherwise moneydance will use the default category for all imprted transactions.
There are essentially no banks in the UK that support direct connections to personal finance software. However you can probably download an OFX file from your banks website manually.
If this does not meet your needs let me know and I will authorize a refund.
Sincerely
Ben Spencer
6 Posted by Frederick Habbe on 02 Apr, 2010 06:38 PM
Hi Ben,
Thank you. The import has now worked fine. I will post the bank transactions manually. However, in MSMoney I was able to set up stock portfolios with an online connection so the stock values would always be updated automatically. I have not seen in option in Moneydance for this.
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 02 April 2010 15:46
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Support Staff 7 Posted by Ben Spencer on 03 Apr, 2010 03:09 PM
It is necessary to install a couple of free extensions in order to download security prices. Here is a link to an article describing the process:
http://help.infinitekind.com/faqs/frequently-asked-questions-2/how-...
Ben
8 Posted by Frederick Habbe on 04 Apr, 2010 08:05 AM
Hi Ben.
Thanks for the information. I have done this now, however, I was interested in viewing the total stock value of my portfolio and have it added to my net worth as it is done in MSMoney, showing on the left hand side list of accounts. Is this possible?
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 03 April 2010 16:11
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Support Staff 9 Posted by Ben Spencer on 04 Apr, 2010 04:40 PM
There is currently a bug that prevents the side bar balances on accounts from updating when the stock quote extension updates prices. Hopefully we will get this one fixed soon.
However the values on the home page are updated correctly and the new stock prices are included in the networth calculation on the home page.
Ben
10 Posted by Frederick Habbe on 05 Apr, 2010 08:09 AM
Thank you Ben,
When setting up a stock item, there is no field for the number of shares thus no total value on the home page display, only the current value of one share. Nothing is showing in the net worth calculation.
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 04 April 2010 17:42
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
11 Posted by Frederick Habbe on 05 Apr, 2010 11:05 AM
Hi Ben,
Some questions as to the reporting function. I ran an Expenses and Income (detailed) report. The window that popped up was very small and really unsuitable for viewing the report (see attachment Money1). This only happens if the report is generated through Tools > Graphs and Reports. When using the direct links on the left hand panel the reports display in a full window. But these reports always default to the date range "year to date".
Many figures did not match the posted ones. Some of the transactions posted in GBP (Pound Sterling) are showing correctly the correct values, however, those posted in Euros have been increased by roughly 12% which is the approximate exchange rate, but the Euro is lower in value. If at all, the amounts should have been reduced to reflect the equivalent GBP value. But there is no clear pattern. Many transactions posted in GBP are showing in Euros in the report. To be honest the report is utterly confusing and I don't know whether the final balance is actually correct (displayed in GPB).
I also ran a pie chart report which did not show detailed income and expenditure figures (see attachment Money2). This only happens if the report is generated through Tools > Graphs and Reports. When using the direct links on the left hand panel the reports display in a full window.
All very confusing, unfortunately.
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 04 April 2010 17:42
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Support Staff 12 Posted by Ben Spencer on 05 Apr, 2010 02:27 PM
Frederick
In order to increase the number of shares owned in an investment account you must enter a buy transaction for that security in the register of the investment account. Here is a link to an article that describes how to use investment accounts:
http://help.infinitekind.com/faqs/frequently-asked-questions-2/how-...
With regard to the problems you are having with the reports I am afraid that none of the screen shot you mention are attached. With regard to the window being too small you can always stretch the window to make it larger or maximize it.
With regard to multi currency detailed income and expense report, each line item will be displayed in the currency of the category not the currency of the account that the transaction was entered in. The sub totals and total at the bottom of the report will be converted in to the base currency.
Sincerely
Ben Spencer
13 Posted by Frederick Habbe on 05 Apr, 2010 04:44 PM
Hi Ben,
Thanks for bearing with me. The small windows issue is now solved. Would have been simpler if the square icon for full window had been in place. As to adding the number of shares, I have tried the link below but it didn't work.
As to the currency muddle, I must report that there is no recognisable pattern there at all. There are lot of transactions displayed in Euros despite the category being set up in GBP. The major problem is that the calculated amounts are quite simply wrong. For example, I posted an expense amount of €276 Euros. This shows up as £310.11 (Pounds). It should show as around £246. The report is not usable.
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 05 April 2010 15:29
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Support Staff 14 Posted by Ben Spencer on 05 Apr, 2010 05:13 PM
Frederick
I have not been able to reproduce the problem you are describing with multi currency income and expense reports. Would you be willing to provide a cut down demonstration data file including a couple of transaction that demonstrate the problem.
With regard to entering a buy transaction what exactly did not work? Were you able to enter a buy transaction?
Ben
15 Posted by Frederick Habbe on 05 Apr, 2010 05:55 PM
Hi Ben,
Attached a screen print of a section of the Income & Expenses report (Summary). The orange arrows point to categories that have been set up for Pound Sterling but are showing in Euros.
As to the shares problem, the link you sent does not explain how to add the number of shares in the portfolio. There is no field where a quantity can be added (unless I overlooked something.
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 05 April 2010 18:16
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Support Staff 16 Posted by Ben Spencer on 05 Apr, 2010 08:22 PM
Hi
The file that you attached is not a screenshot. It is a copy of the report in HTML. I am able to open the file in a browser however as it is not a screenshot I do not see the orange arrow you are speaking of. Perhaps you could make a cpoy of you Moneydance data file and remove most of the accounts and transactions except for a couple that demonstrate the problem and attach that. I am still not able to reproduce the issue you are describing.
To add shares to the portfolio you must enter a buy or buyXfr transaction in the register for the investment account.
Ben
17 Posted by Frederick Habbe on 06 Apr, 2010 05:46 PM
Hi Ben,
Sorry about the wrong attachment. I have now attached that screen print plus one more which should give you an idea of the problem. The file Moneydance shows sums in Euros although the accounts are set up in GBP and the postings were done in GBP.
I have also attached a screen print of the information on the home page relating to the shares. I have tried to find the options you mentioned but was unable to. Can you please list the steps for this procedure (adding the amount of shares).
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 05 April 2010 21:25
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Support Staff 18 Posted by Ben Spencer on 06 Apr, 2010 07:02 PM
With regard to the first report screen shot can you please look at the specific categories in question by selecting Tools->Edit categories select the category in question (e.g. Groceries ) and then click the edit button. You should then be able to see the currency of that specific category. Regardless of the currency of the account you entered the transaction in the report will be based on the currency of the category.
I am not sure what the report type is that you are showing me in the second report screen shot or what options you have used and am having a hard time diagnosing the problem with out being able to see the source data. Seeing the out put is not sufficient for diagnosing the problem in the case. Can you provide a cut down example data file that I can open to see the cause of the problem.
With regard to adding shares to an investment account:
In order to list you share holdings you must fist add the securities of interest to your investment account. For example if I have shares in Google I need to add the Google security to an investment account by clicking on the "Add Security" button in the security detail view. The click the new security button on the popup window and enter the securoty name. see screenshot1.
Once a security is added to an investment account it can be involved in transactions. These transaction are entered in the transaction register section of the investment account. In order to specify that you hold particular numbe rof a particular security you must create a "buy" or "buyXfr" transaction in you register. See screenshot2.
When you enter a "buy" transaction in the investment register the money for the buy comes from the cash balance on the investment account. You should set the initial balance on the investment account to the sum of you initial holdings such that you cash balance is zero after your initial buy transactions. Do this by select Account->"Edit Account" see screenshot3.
Ben
19 Posted by Frederick Habbe on 07 Apr, 2010 01:41 PM
Hi Ben, I have checked the categories as you suggested and found out that almost all GBP categories have been imported with Euro settings when I imported the data from MSMoney. This explains most of the problems but not why the Income postings (categories set up in Euro) have been converted by adding around 12 % in the report (detailed Income and Expenses). In the report they transactions should show the exact posted amounts. I have attached a back-up data file because I do not know how to save an example file. Please treat this one as confidential.
As to the categories with the wrong currency, I noticed that I can't change the currency at this stage. How can the problem be rectified?
As to the shares issue you did not enter the screen shots.
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 06 April 2010 20:05
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
20 Posted by Frederick Habbe on 07 Apr, 2010 01:45 PM
Now with the data file.
-----Original Message-----
From: Frederick Habbe
Sent: 07 April 2010 14:40
To: 'Infinite Kind Support'
Subject: RE: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Hi Ben, I have checked the categories as you suggested and found out that almost all GBP categories have been imported with Euro settings when I imported the data from MSMoney. This explains most of the problems but not why the Income postings (categories set up in Euro) have been converted by adding around 12 % in the report (detailed Income and Expenses). In the report they transactions should show the exact posted amounts. I have attached a back-up data file because I do not know how to save an example file. Please treat this one as confidential.
As to the categories with the wrong currency, I noticed that I can't change the currency at this stage. How can the problem be rectified?
As to the shares issue you did not enter the screen shots.
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 06 April 2010 20:05
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
21 Posted by Frederick Habbe on 09 Apr, 2010 08:26 AM
Hi Ben,
Can you please update me on your findings.
Regards
Frederick
-----Original Message-----
From: Frederick Habbe
Sent: 07 April 2010 14:42
To: '***@tenderapp.com'
Subject: FW: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Now with the data file.
-----Original Message-----
From: Frederick Habbe
Sent: 07 April 2010 14:40
To: 'Infinite Kind Support'
Subject: RE: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Hi Ben, I have checked the categories as you suggested and found out that almost all GBP categories have been imported with Euro settings when I imported the data from MSMoney. This explains most of the problems but not why the Income postings (categories set up in Euro) have been converted by adding around 12 % in the report (detailed Income and Expenses). In the report they transactions should show the exact posted amounts. I have attached a back-up data file because I do not know how to save an example file. Please treat this one as confidential.
As to the categories with the wrong currency, I noticed that I can't change the currency at this stage. How can the problem be rectified?
As to the shares issue you did not enter the screen shots.
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 06 April 2010 20:05
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
22 Posted by Frederick Habbe on 14 Apr, 2010 11:33 AM
Hi Ben,
I still have not received a response after sending the financial file.
Can you please give me your conclusions on your findings.
Regards
Frederick
-----Original Message-----
From: Frederick Habbe
Sent: 09 April 2010 09:17
To: '***@tenderapp.com'
Subject: FW: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Hi Ben,
Can you please update me on your findings.
Regards
Frederick
-----Original Message-----
From: Frederick Habbe
Sent: 07 April 2010 14:42
To: '***@tenderapp.com'
Subject: FW: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Now with the data file.
-----Original Message-----
From: Frederick Habbe
Sent: 07 April 2010 14:40
To: 'Infinite Kind Support'
Subject: RE: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Hi Ben, I have checked the categories as you suggested and found out that almost all GBP categories have been imported with Euro settings when I imported the data from MSMoney. This explains most of the problems but not why the Income postings (categories set up in Euro) have been converted by adding around 12 % in the report (detailed Income and Expenses). In the report they transactions should show the exact posted amounts. I have attached a back-up data file because I do not know how to save an example file. Please treat this one as confidential.
As to the categories with the wrong currency, I noticed that I can't change the currency at this stage. How can the problem be rectified?
As to the shares issue you did not enter the screen shots.
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 06 April 2010 20:05
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Support Staff 23 Posted by Ben Spencer on 14 Apr, 2010 07:09 PM
Hi Frederick
I am sorry to not have responded sooner.
I have not been able to find a problem with the report. Lets take "Tenerife Villa Rentals" as an example income account.
On 1/14/2010 there is a transaction entered in the bank account "Deutsche Bank" for 182GBP categorized as "Tenerife Villa Rentals"
See the first screen shot.
The account "Deutsche Bank" has its currency set to GBP. We can see that in the second screen shot. This means that the currency of the transactions entered in this account are in GBP. We can see that the exchange rate for this transaction is 1.123571. The reason why an exchange rate is shown is because the category being used "Tenerife Villa Rentals" is in EUR.
If we then look in the category itself we can see the transaction priced in euros at the given exchange rate see the 3rd screenshot. When we look at the transaction from this perspective the value is 204.49EUR.
I then ran a Detailed Income and Expense report (see the 4th screenshot) and we see that the report shows the transactions in the currency of the expense category 204.49EUR.
This all seems to be correct. Perhaps I am misunderstanding the problem. It seems as though you thought the transaction shown in the "Deutsche Bank" register was in EUR where as in fact "Deutsche Bank" is in GBP. Could that be the cause?
Sincerely
Ben Spencer
24 Posted by Frederick Habbe on 15 Apr, 2010 11:52 AM
Hi Ben,
Thank you for the information. I think the problem is that some of the banks are set up incorrectly. I am quite sure that I selected the correct currency when I set them up but now all bank accounts show GBP as their currencies.
Deutsche Bank and Commerzbank should have been set up in euros. I noticed that the currency can't be edited once set up. May be that the import from Money messed this up.
What can I do now?
Regards
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 14 April 2010 20:12
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
Support Staff 25 Posted by Ben Spencer on 15 Apr, 2010 03:51 PM
It is the case that a currency cannot be modified once an account contains transactions. Changing the currency would render the used exchange rates nonsensical.
I am afraid this means that you will need to import your data again. I would recommend deleting the incorrect accounts and then creating them with the correct currency and then import your transactions into them from the qif file.
I am sorry for the inconvenience.
Ben
26 Posted by Frederick Habbe on 15 Apr, 2010 04:30 PM
Thank you Ben,
This is unfortunate as I have made quite a few manual postings since importing from Money.
Anyway, that is my problem.
Thanks again.
Frederick
-----Original Message-----
From: Ben Spencer [mailto:***@tenderapp.com]
Sent: 15 April 2010 16:54
To: Frederick Habbe
Subject: Re: Import file from Money not recognised [Switching to Moneydance from Microsoft Money?]
27 Posted by Frederick Habbe on 31 Jul, 2010 04:07 PM
Dear Ben,
I have now been working with Moneydance for more than three months. Generally, posting varies transactions is okay, however, there are some serious issues with reporting and bank balances.
I have attached the latest back-up file plus a few screen prints and hope to be able to demonstrate the issues I am experiencing. I will list these below in no particular order and name them by the name of the screen print:
1. Eventim
There has been a single posting for €114.80 on June 30 in the Commerzbank Account (Euro Account). In the detailed income and expenditure report the amount is shown as 9643.20 (currency not shown). The summary for the category shows an amount in pounds.
2. Groceries
For reasons unbeknown to me several postings show up as pennies or cents in the detailed report, however, completely different, larger amounts were posted.
3. Dining Out
Same issue as the previous one
4. Pension Frederick
Two amounts of €662.90 were posted to this category on May 25 and June 20. In both cases these amounts show as 55683.60 (unknown currency) and the sub-total below is shown in pounds as 111,367.20 (bizarre).
5. F. Thomson
On May 15 I posted an amount of £535 on the Santander account in the Tenerife Villa rentals income category. In the report this amount is shown as €6.37.
6. Pension Credits
Again a lot of postings are not showing the real amount in the report.
I have not gone through all of the categories but I am sure there are more errors. As a result the report is useless.
I also need to display individual income and expenses categories by themselves and print them. I could not find such an option.
Another most annoying error is that bank account balances continue to go out of sync. The reason seems to be previous bank transfers between banks with different categories. What is weird is that the software seems to change the amounts although they were often posted months ago. I then need to spend a lot of time locating the posting and then correct it. When an transfer is posted between accounts with different currencies there must be an option to override the amount in receiving bank's account. This is because the automatically calculated conversion never matches the actual amount credited.
I hope you can help with this. Unfortunately, all the work done so far is of little use because of these serious errors.
Regards
Frederick Habbe
28 Posted by Frederick Habbe on 03 Aug, 2010 10:44 AM
Hi Ben, Can you please confirm that you received my email support query.
Regards
Frederick
-----Original Message-----
From: Frederick Habbe
Sent: 31 July 2010 18:06
To: 'Infinite Kind Support'
Subject: Serious Issues
Dear Ben,
I have now been working with Moneydance for more than three months. Generally, posting varies transactions is okay, however, there are some serious issues with reporting and bank balances.
I have attached the latest back-up file plus a few screen prints and hope to be able to demonstrate the issues I am experiencing. I will list these below in no particular order and name them by the name of the screen print:
1. Eventim
There has been a single posting for €114.80 on June 30 in the Commerzbank Account (Euro Account). In the detailed income and expenditure report the amount is shown as 9643.20 (currency not shown). The summary for the category shows an amount in pounds.
2. Groceries
For reasons unbeknown to me several postings show up as pennies or cents in the detailed report, however, completely different, larger amounts were posted.
3. Dining Out
Same issue as the previous one
4. Pension Frederick
Two amounts of €662.90 were posted to this category on May 25 and June 20. In both cases these amounts show as 55683.60 (unknown currency) and the sub-total below is shown in pounds as 111,367.20 (bizarre).
5. F. Thomson
On May 15 I posted an amount of £535 on the Santander account in the Tenerife Villa rentals income category. In the report this amount is shown as €6.37.
6. Pension Credits
Again a lot of postings are not showing the real amount in the report.
I have not gone through all of the categories but I am sure there are more errors. As a result the report is useless.
I also need to display individual income and expenses categories by themselves and print them. I could not find such an option.
Another most annoying error is that bank account balances continue to go out of sync. The reason seems to be previous bank transfers between banks with different categories. What is weird is that the software seems to change the amounts although they were often posted months ago. I then need to spend a lot of time locating the posting and then correct it. When an transfer is posted between accounts with different currencies there must be an option to override the amount in receiving bank's account. This is because the automatically calculated conversion never matches the actual amount credited.
I hope you can help with this. Unfortunately, all the work done so far is of little use because of these serious errors.
Regards
Frederick Habbe
29 Posted by Frederick Habbe on 03 Aug, 2010 01:25 PM
Hi Ben, I have attached the files relating to this issue in case zou did not get them via the email.
Regards
Frederick
30 Posted by Frederick Habbe on 13 Aug, 2010 01:31 PM
Dear Ben,
I have now been working with Moneydance for more than three months. Generally, posting varies transactions is okay, however, there are some serious issues with reporting and bank balances.
I have attached the latest back-up file plus a few screen prints and hope to be able to demonstrate the issues I am experiencing. I will list these below in no particular order and name them by the name of the screen print:
There has been a single posting for €114.80 on June 30 in the Commerzbank Account (Euro Account). In the detailed income and expenditure report the amount is shown as 9643.20 (currency not shown). The summary for the category shows an amount in pounds.
For reasons unbeknown to me several postings show up as pennies or cents in the detailed report, however, completely different, larger amounts were posted.
Same issue as the previous one
Two amounts of €662.90 were posted to this category on May 25 and June 20. In both cases these amounts show as 55683.60 (unknown currency) and the sub-total below is shown in pounds as 111,367.20 (bizarre).
On May 15 I posted an amount of £535 on the Santander account in the Tenerife Villa rentals income category. In the report this amount is shown as €6.37.
Again a lot of postings are not showing the real amount in the report.
I have not gone through all of the categories but I am sure there are more errors. As a result the report is useless.
I also need to display individual income and expenses categories by themselves and print them. I could not find such an option.
Another most annoying error is that bank account balances continue to go out of sync. The reason seems to be previous bank transfers between banks with different categories. What is weird is that the software seems to change the amounts although they were often posted months ago. I then need to spend a lot of time locating the posting and then correct it. When an transfer is posted between accounts with different currencies there must be an option to override the amount in receiving bank's account. This is because the automatically calculated conversion never matches the actual amount credited.
I hope you can help with this. Unfortunately, all the work done so far is of little use because of these serious errors.
Regards
Frederick Habbe
Support Staff 31 Posted by Ben Spencer on 13 Aug, 2010 07:19 PM
Hi Frederick
I am sorry it has take a while to get back to you. Your data set is quite complex and has taken some investigation.
The Eventim transaction is entered in Euros. The amount of the transaction is 114.80. The category for the transaction "Leisure & Entertainment: Cultural Event" is in British Pounds so there is an exchange rate. However in this case the exchange rate is clearly incorrect as it is 84! The GBP9643.20 comes from this incorrect exchange rate. Perhaps you inadvertently entered 84 instead of 0.84 for the exchange rate.
I see at least two other transactions in Commerzbank with an exchange rate of 84. These also need to be corrected.
Having looked at your other problem transactions I believe incorrect exchange rates entered when entering the transaction is the cause of these. Categories have their own currency just as accounts can. When you enter a transaction in an account that has a different currency from the category you are selecting you must enter an exchange rate.
The other part of this problem is in understanding the reports. Each line item in the detailed income and expense report is in the currency of the category not the currency of the account the transaction was entered in. The total for each category is also in the currency for that category. To know the currency for an individual line item in the detailed income and expense report look at the currency for the total on that category. The totals at the bottom of the report is converted into the base currency using the current exchange rate.
I encourage you to look at each of the categories you are having problems with and make sure that the correct exchange rate is being entered in the account for those transactions.
To print all of the transactions in a single income or expense category select Tools->Graphs and Reports. Select "Detailed income and expenses" report. Click the "Show: By Individual" link. This will list all of the categories. Click the "None" link to deselect them all. Then select the one that you want to have included in the report. See the attached screenshot for an example.
When entering a transfer between two accounts in different currencies and you want to enter the exact amount for the receiving account please following the instructions in the following article.
http://help.infinitekind.com/faqs/frequently-asked-questions-2/how-...
Sincerely
Ben Spencer