Data Consolidation
Consolidating data from different sources and ledgers
One of the largest UK banking groups wanted to consolidate their varied sign-off activities and feeds into one single shared system. Using BCS integrity they achieved this goal, bringing consistency and transparency to their disparate processes and data sources.
Data sources and screen layouts
Our client had previously run a project to migrate as many business units as possible onto their preferred general ledger – SAP. However, for some business units, it proved either too complex or expensive to move the accounts across. This left our client working with several feeds of information, from sources such as Oracle Financials and other SAP implementations, as well as smaller sub-ledgers which needed to be loaded into BCS integrity via Excel.
By using BCS integrity’s flexible mapping tools and creating multiple data sources, the system was able to accommodate all of these formats without the need for additional development.
Our product’s Custom Fields and Account Views functionality meant that all additional business specific information could be captured in the feeds and communicated to the user using terminology and page layouts they were familiar with from their other systems, whilst maintaining common underlying data definitions across all feeds for reporting purposes.
Account sign-off and ledger linking
In addition to combining feeds and processes, our client also wanted to be able to trace general ledger balances through the system in order to see how the sub-ledger balances that constituted them had been signed off. To achieve this, BCS integrity enabled the sub-ledger accounts to be automatically linked to their general ledger counterparts during the feed upload, as part of the mapping process.
This gave the users responsible for signing off the general ledger account balances confidence that the process was being followed at the sub-ledger level, because they had access to a read only, ‘drilldown’ view of the supporting information, including comments or attachments. By linking the sign-off processes like this, general ledger users were also able to ‘pull through’ any breaks logged against the sub-ledger components and track them against the general ledger record as required.
Conclusion
BCS integrity has delivered a standardised system for capturing and reporting month end attestation data group wide, regardless of the accounts origin or type. Our product’s ledger linking functionality has also given our client an unparalleled level of transparency over previously incomparable data sources and processes, enabling them to complete the process more efficiently and with more confidence than ever before.