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

Implementing FCCS for banking customers

in Financial Consolidation and Close 1 comment

Loading daily average and ending balance in FCCS.

Hi There,

Has anyone implemented FCCS for a banking customer ? For banking industry, daily ending and average balances are critical to consolidate and report. I see challenges if we need to load average balances and calculate the ending balances.

Some thoughts on how to handle them, please provide feedbacks/inputs..

Ending balances
Create Day1 to Day31 in Data source dimension and load periodic data based on the day. Load all the data to "FCCS_Net Income" member in movement dimension assuming OOB cashflow calculation is not required.

With above approach, lets assume we are in Feb month. The opening balance for a day wont match with the closing balance of prior day because FCCS would handle it the way its mentioned below..

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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