FCCS Cash Flow Mapping Issue: GL Accounts with Multiple Movement Types
We load year‑to‑date (YTD) trial balance data into FCCS for consolidation purposes, and we are now looking into implementing cash flow reporting in FCCS. However, we have encountered a roadblock related to mapping cash flow movements.
We are currently mapping all cash flow movement dimension members to GL accounts in FCCS, but many of our GL accounts contain transactions that fall under multiple cash flow movements and categories. Since FCCS only receives ending balances from the GL system, we are unsure how to map these transactions to the appropriate cash flow movements.
For example, we have an account used to record activity for one of our equity‑method investments. Throughout the period, the balance changes due to several different types of transactions, as illustrated below: