Oracle

FCCS Account Types and Translation

Data chip

In HFM we are used to assigning Account Type = Balance for Balance Sheet Accounts and Account Type = Flow for P&L Accounts. Balance Accounts are translated using Ending Rates while Flow Accounts are translated using Average Rates.

In FCCS, we assign Account Type = Flow both for Balance Sheet and P&L Accounts. Since data are periodic, this allows the calculation of Changes due to Foreign Exchange for Balance Sheet Accounts. These Changes due to Foreign Exchange are added to the translated Average Rate to come up with the Closing balance at Ending Rates.

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

We assign Account Type = Balance for some supplemental accounts like Backlog because we intend to translate the values directly at Ending Rates. To directly translate Backlog at Ending rates, the default translation method needs to be modified to use Year to Date translation method.

The Default Translation Methods is located at:

Application> Consolidation>Translated>Translation Overrides>Manage Defaults.

Change the Balance Account Translation Method from Periodic to Year To Date.

About the Author

I have a bachelor's degree in Accounting, MBA, and CPA. I have 6 years experience in HFM/FDMEE involving manufacturing, service, and marketing industries.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories