Currency translation - BS month end closing rate, IS average rate

[PetarK]

Hi everyone,

Noted that these q's are quite often asked, however could not connect all dots to solve my case (probably as I'm quite new with PBI).

I have few tables - "G/L data" with transactions data (different dates during the month), "fx rates"  with period, currency, spot and average rate (all dated month end), mappings (mappings to get g/l data to form I need, including classification Balance Sheet - BS and Income Statement - IS).

Challenge I'm facing is how to translate BS items (many dates during the month) at spot rate (month end defined) and income statement with average rate (month end defined)? 

Would really appreciate your help !!!

Thanks!

Petar

[PetarK]

Hi Stephen,

Thanks for your question.

Its accounting stuff...basically as we had cash (balance sheet/BS item) in January of x amount, need to have the same (cumulative figure) in the forthcoming period (using a new fx rate), however for revenue (IS) items, I do not need cumulative amount but only that month figure.

Best regards,

Petar

[Anonymous]

Hi @PetarK ,

Why does g3 of Cash(BS) appear in January, February and March, while g4 of Revenue(IS) appears only in April and g5 in May?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.