Financial Consolidation Model

Problem Statement: The current Intercompany Matrix Report is not loading with more number of legal entities. Recommendation: Change/ Create a new report layout with Legal Entity and Partner Entity in rows, IC Account/ Consolidation rules in column...

Challenge: - Users has to cpature additional data set in historic LC using cutom paste view, beyond financial statements in LC

Posting Journal improvement: - Response time for the posting journal report is too high - Better data validation to upload journal - Carry forward jounarls- in Lucanet only values and link to original journal to drill down

In the report of "Scope of Consolidation" -> Tab "Scope", currently all the Partner Entities are shown for the setting, regardless of which Scope is selected. If there are many Partner Entities in System, the list will be very long and difficul...

Buttons in "Posting Journal Entry" move to the top instead of having them at bottom. Because if there are many JEs to be posted, the user need to scroll all the way to the bottom, but the step before of selecting All JEs is at the top. Sometimes t...

current design, the Journal Entry list has to be uploaded in Report Designer, and then be loaded to Model by going back to Report, entering the file name and click on load Journal Entry. it's not user freindly. Sometimes due to User Right Restrict...

Create Data Validation on Consolidation Method (N, E, P, F)

What it is: Consolidate both Legal and Segment Consolidation ledger together/ with the same Consolidation logic and Store information in same ledger/ cube rather than multiple. Customer Challenge: Data reconciliation is complex while having multip...

Challenge: User has to copy journals to reflect the journals to multiple scopes Detail: The system currently designed to post journals to a particular scope by considering different accounting standards (IFRS, US GAAP) and currencies for different...

Challenge: Manual effort to reclassify accounts and no single place to view all the investments Detail: Period1: Investor originally invested 200K to Investee (Subsidiary). Period2: Investee booked 15K as current period retained earnings. Period2:...