AnsweredAssumed Answered

Revenue and Actual Revenue not matching in Cost Plan (multi currency issue?)

Question asked by JoostBreggeman76041091 on Mar 22, 2016
Latest reply on Apr 16, 2016 by JoostBreggeman76041091

In our projects we use expense transactions to track fixed costs or e.g. travel and expense costs. we also want to forecast this using the cost plan. The cost plan is now showing inaccurate data comparing Actual Revenue with Forecast revenue.

 

What we do is the following:

  1. We create a task and add an expense resource with a cost rate in the matrix of 1 euro
  2. The task has an ETC of the value of the expense
  3. When book actuals we create this via an expense transaction

 

Then after cost plan update it looks like this - see March 2016:

* revenue = 2290

* actuals = 2140

This is what seems to happen:

 

·         Actual revenue is calculated as USD 2140 (which is correct as the exchange rate between USD and EUR = 1.07 à 2000 x 1.07 = 2140)

 

·         Revenue is calculated as USD 2290 USD which is not correct. But it seems that Clarity is calculating again from Actuals to Revenue by multiplying 1.07 (2140 x 1.07 = 2290 USD)

 

Any idea why this is going wrong?

 

Thanks

 

Joost

 

Expense transaction in billing currency (EURO) is calculated wrongly in Cost plan to home currency (USD). For example:

·         Actual revenue is calculated as USD 2140 (which is correct as the exchange rate between USD and EUR = 1.07 à 2000 x 1.07 = 2140)

·         Revenue is calculated as USD 2290 USD which is not correct. But it seems that Clarity is calculating again from Actuals to Revenue by multiplying 1.07 (2140 x 1.07 = 2290 USD)

Outcomes