Hello John,
Let me ask you a question:
With these considerable valuation differences, I wonder with which values in EUR the balances are shown without valuation.
The first USD account would have to show a credit balance, the second one as well and the GBP account would have to show a debit balance beyond good and bad.
If the assumption is correct, then I would also assume that these accounts have been running for a long time and have more or less always been valued with a difference account.
I see two possible solutions;
First, there is the possibility to bring the EURO balances of the bank accounts with the F-05 times to a reasonable level. The foreign currency remains, the EURO balance comes into a reasonable size.
You can do this every now and then, if the balances look strange.
For documentation purposes I would suggest in that case to store the used exchange rate in the annex of the document - also the calculation based on the current balance.
If the valuation can't be changed over as suggested below, then you can do it over and over again.
On the other hand, the question of how many valuations run over the accounts.
If only one balancing needs to be converted, I would suggest to have the valuation posted directly to the bank accounts (is something like a F-05, just machine) and not reverse that valuation for the balances.
Works even if there are multiple assessments - but then you would have to make sure that the assessment that posts directly to the account is executed and posted first, to avoid duplicate assessment of the original balances.
And I mean already post first and then start the following runs - not start valuation run 1 and shoot the second one right after. I've experienced that too - with correspondingly wrong results.
In any case, you have once quite a jump in euros, but after that it runs with the regular valuation again in a reasonable framework - with proposal two even permanently.
Greetings
Klaus
Let me ask you a question:
With these considerable valuation differences, I wonder with which values in EUR the balances are shown without valuation.
The first USD account would have to show a credit balance, the second one as well and the GBP account would have to show a debit balance beyond good and bad.
If the assumption is correct, then I would also assume that these accounts have been running for a long time and have more or less always been valued with a difference account.
I see two possible solutions;
First, there is the possibility to bring the EURO balances of the bank accounts with the F-05 times to a reasonable level. The foreign currency remains, the EURO balance comes into a reasonable size.
You can do this every now and then, if the balances look strange.
For documentation purposes I would suggest in that case to store the used exchange rate in the annex of the document - also the calculation based on the current balance.
If the valuation can't be changed over as suggested below, then you can do it over and over again.
On the other hand, the question of how many valuations run over the accounts.
If only one balancing needs to be converted, I would suggest to have the valuation posted directly to the bank accounts (is something like a F-05, just machine) and not reverse that valuation for the balances.
Works even if there are multiple assessments - but then you would have to make sure that the assessment that posts directly to the account is executed and posted first, to avoid duplicate assessment of the original balances.
And I mean already post first and then start the following runs - not start valuation run 1 and shoot the second one right after. I've experienced that too - with correspondingly wrong results.
In any case, you have once quite a jump in euros, but after that it runs with the regular valuation again in a reasonable framework - with proposal two even permanently.
Greetings
Klaus