You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

I cannot reconcile the CTA calculation

in Financial Consolidation and Close 11 comments

Summary:

At a customer we have implemented CTA with historical amount override accounts. They are using YTD Average rate (might be of influence).
Now I'm trying to reconcile a CTA number within an entity but it doesn't seem to make any sense.

From May to August, we have no movements on this account in entity currency, there was no opening balance in JAN and the end rate only slightly differs between May and August (from 0.0869 to 0.0881, expecting an impact of 50k), but the CTA movement adds up to 847k.

What am I missing?

There was a movement of 41 million entity currency in May, with an amount override on the exact correct location and we've put zero's in the following periods for the amount override. Somehow it seems to double up the periodic amounts in FCCS_MVmts_FX_to_CTA. It is showing this effect on all historic accounts.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!