



AEGIS embarked on transforming its finance operations to align with its digitisation and data-centric strategy. This case study explores the integration of the Phinsys platform, enhancing AEGIS' operational efficiency and supporting sustained growth.
AEGIS chose the Phinsys platform to achieve end-to-end automation in finance, aligning with their Target Operating Model. The proof of concept demonstrated the platform's effectiveness and promoted stakeholder buy-in. AEGIS integrated Phinsys into their broader data program, focusing on end-to-end data management and automation.
Key products in scope:
An enterprise data warehouse and close management tool that enhances data integrity, produces regulatory reports, automates financial close processing, and accelerates financial processes.
A rules-based calculation and allocation engine automating premium ceded premium allocation, IBNR calculation, expense allocation, and business forecasting.
An accounting rules engine that ensures the integrity of financial accounts, manages accounting journals, and supports different time zones and multiple ledgers.
A regulatory and bordereau reporting and reconciliation system that manages and validates bordereau uploads, creates new reporting formats for evolving regulatory requirements, and delivers real-time output of system-to-system reconciliations.
A reporting data layer, offering granularity for business performance analysis, and facilitating the transition from management to statutory to reconciled regulatory data submission.
AEGIS transitioned seamlessly from manual, Excel-based processes to an automated operating model, marking a pivotal step in their digital journey.
Phinsys streamlined financial processes, automating key functions like financial close processing, premium allocation, IBNR calculation, and regulatory reporting, significantly increasing the control envionment and enhancing overall operational efficiency.
The implementation aligned with AEGIS' strategic objectives, establishing transparent, auditable, and controlled financial operations, contributing to strategic agility.
Phinsys addressed specific reporting needs, including UK GAAP statutory reporting and Lloyd's reporting, offering drill-down, rounding, validation, and casting functionalities for adaptive reporting compliance.
The eradication of manual processes and the establishment of a single, consolidated source of financial data, heightening operational efficiencies, strengthening financial controls and positioning AEGIS for sustained growth.
AEGIS' collaboration with Phinsys has not only streamlined finance but has also aligned with the organisation's core focus on data and digitalisation. As AEGIS continues its journey of transformation, the integration of Phinsys stands as a testament to their commitment to staying competitive and innovative in the market.
Digitisation is critical to the way we want to do business and modernising our accounting and finance operations sits at the heart of our transformation strategy. To realise our vision, we needed the right partner to provide robust, future-proof solutions that will replace manual processing and deliver the necessary data quality and governance controls. The Phinsys suite will deliver financial information and analytics on a platform that supports our growth ambitions
Apollo is an innovative integrated insurance group dedicated to providing high quality products and services to clients, brokers, and capital partners at Lloyd’s.
In 2015, Apollo partnered with Phinsys on its journey to build an advanced in-house finance function using the Phinsys product suite. Since this collaboration, challenges such as data quality and manual processes have been successfully addressed and overcome.
The establishment of its own managing agency and transition from being a third party managed syndicate highlighted challenges such as multiple data sources and the development of new internal systems.
Apollo needed a unified data system to consolidate data previously stored in spreadsheets and the underwriting system (Xuber) and enhance overall data integrity.
Apollo implemented the Phinsys suite aligning with their operational model, enhancing data consistency across the organisation and supporting decision-making with high-quality management information.
The solution facilitated the integration of additional syndicates and has supported growth since.
Key products in scope:
An enterprise data warehouse and close management tool that enhances data integrity, produces regulatory reports, automates financial close processing, and accelerates financial processes.
A rules-based calculation and allocation engine automating premium ceded premium allocation, IBNR calculation, expense allocation, and business forecasting.
An accounting rules engine that ensures the integrity of financial accounts, manages accounting journals, and supports different time zones and multiple ledgers.
A regulatory and bordereau reporting and reconciliation system that manages and validates bordereau uploads, creates new reporting formats for evolving regulatory requirements, and delivers real-time output of system-to-system reconciliations.
A reporting data layer, offering granularity for business performance analysis, and facilitating the transition from management to statutory to reconciled regulatory data submission.
This involved a systematic approach to integrate Tandem with existing underwriting systems, configuring Rapport for precise financial operations, and deploying Postbox, Comply, and Inform to streamline accounting, regulatory compliance, and data visualisation.
Creation of a single, robust data model supporting syndicate and managed syndicate reporting.
Fast and accurate mapping of all data sources into a single model for simplified ongoing management and reporting.
Enhanced management information accessibility with granular detail for informed business decisions.
Implementation of consistent and accurate finance close processes, reducing operating costs.
Consolidated reporting across the entire portfolio, including Lloyd’s Solvency II Pillar 3 and UK GAAP.
Automatic calculation and allocation of premiums, IBNR, and ceded. Automatic posting of accounting entries and reconciliation across the portfolio and to a single ledger.
Apollo Group's deployment of Phinsys products not only addressed immediate operational challenges but has supported the business in its strategic development. With a state-of-the-art finance function, Apollo has efficiently managed multiple syndicates and made informed decisions for long-term success.
Since we started working with Phinsys we’ve been able to create a function that delivers accurate and timely data for our management, finance and actuarial teams. We’re building an increased capability to scale our business without introducing manually intensive processes and increasing our operating expenses.”
Hamilton Insurance Group, Ltd. (“Hamilton”; “the Company”) (NYSE: HG), a global specialty insurance and reinsurance company headquartered in Bermuda, is committed to using cutting-edge technology and data analytics to create enhanced underwriting and investment value for its stakeholders. This case study details Hamilton’s strategic move to implement the Phinsys platform of products, which proved instrumental in streamlining the Company’s finance systems and processes, enhancing its finance function's operations, and expediting the delivery of timely, accurate and reconciled data from source underwriting system through to the financial general ledger, across Hamilton’s full network of office locations.
Following a transformative acquisition in August 2019, Hamilton needed to replace and renew all of existing source underwriting systems, data warehouses and finance systems that were becoming obsolete and unable to meet the evolving requirements of the organisation.
Disparate systems and data sources initially resulted in excessive manual data reconciliation processes, immediately post the acquisition, that were time-consuming.
Hamilton required a solution that could support both the local regulatory and Hamilton’s statutory and management reporting across the entire organisation, including its Lloyd's syndicates and international offices. This also needed to be achieved within the trajectory of Hamilton becoming a public company, and hence, the need for a more timely financial close and to be fully SOX compliant.
Hamilton's journey to transform its financial operations began with a proof of concept (“POC”) that demonstrated how Phinsys products could enhance the Company’s financial reporting environment. This POC introduced the capabilities and functionality of Tandem, Rapport, Comply, PostBox and Inform products as the foundation for a potential implementation project.
The successful POC led to a full-scale implementation involving the migration from or integration with source systems for multiple Hamilton entities.
Key Products in Scope:
An enterprise data warehouse and close management tool that enhances data integrity, produces regulatory reports, automates financial close processing, and accelerates financial processes.
A rules-based calculation and allocation engine automating premium recognition (written and earned), ceded premium allocation, IBNR calculation, expense allocation, and business forecasting.
An accounting rules engine that ensures the integrity of financial accounts, manages accounting journals, and supports different time zones and multiple ledgers.
A regulatory and bordereau reporting and reconciliation system that manages and validates bordereau uploads, creates new reporting formats for evolving regulatory requirements, and delivers real-time output of system-to-system reconciliations.
A reporting data layer, offering granularity for business performance analysis, and facilitating the transition from management to statutory to reconciled regulatory data submission.
The implementation process included an alignment of Phinsys products to Hamilton's methodologies, analysis workshops attended by Hamilton business and IT stakeholders, configuration work, systems testing, user acceptance testing, and a smooth transition to operational usage. Hamilton also received support, change service, transition guides, user training, and product user guides.
Manual processes that combined multiple data sources have been eliminated, and bordereau feeds are now automated.
A consolidated enterprise data warehouse has reduced closing cycle time, significantly enhanced the data analysis capability and improved overall data granularity and quality.
The organisation is now closing in on its vision of having "one source" of data and delivering all the expected efficiencies and enhanced financial controls.
Hamilton's transformation journey with Phinsys products has not only streamlined its finance and accounting processes but has also positioned the Company for greater efficiency, data analysis, and regulatory compliance. Following the project, Hamilton have subsequently implemented the Inform module to consolidate data from various entities into a single model for group reporting, providing enhanced data visualisation and performance analysis capabilities.
By implementing Phinsys finance and accounting solutions, Hamilton has been able to sunset multiple legacy systems whilst integrating the recently acquired businesses into a single target operating model with a more streamlined financial close process.
Established in March 2020, Premia Managing Agency has been focused on creating a state-of-the-art business environment underpinned by superior data systems and analytics. This case study explores the strategic collaboration between Premia and Phinsys, highlighting how their combined efforts in managing Lloyd's transactions through the implementation of Tandem, Rapport, and Inform have significantly advanced Premia’s operational capabilities and strategic objectives.
The need to streamline onboarding processes for new transactions while evolving and maintaining a scalable and efficient day-to-day operation.
Ensuring consistency in the technology estate to minimise technical debt and simplify the technology landscape.
Handling nuances and challenges associated with bespoke data migrations during mergers and acquisitions.
Phinsys provides data migration expertise and proprietary data management tools for integrating books of business from Arch/Barbican and Canopius/AmTrust.
Development of a scalable and repeatable data model and ecosystem designed to onboard clients quickly, ensuring economies of scale.
An enterprise data warehouse and close management tool that enhances data integrity, produces regulatory reports, automates financial close processing, and accelerates financial processes.
A rules-based calculation and allocation engine automating premium ceded premium allocation, IBNR calculation, expense allocation, and business forecasting.
This partnership involved a collaborative approach with stakeholders from Phinsys, Premia, Everis, and the teams from Barbican/AmTrust. Key initiatives included seamless data migration, integration with Eclipse and XLPro systems, and robust implementation of Phinsys products.
The streamlined onboarding process and the scalable data model have resulted in efficient, scalable, and easily integrated day-to-day operations.
The adoption of Phinsys products reduced the quarterly close process from weeks to days, improving data scope and granularity.
Premia's focus on building a robust and scalable platform ensures consistency and supports expansion beyond the Lloyd’s market, reinforcing Premia’s growth trajectory.
Premia Managing Agency’s engagement with Phinsys has crucially optimized data operations, facilitated efficient onboarding, and maintained consistency across technologies. Looking forward, Premia's ongoing collaboration with Phinsys will continue to play a vital role in their strategy to enhance operational efficiency, leverage new technologies, and maintain a competitive edge in the market.
The ability for us to efficiently absorb incoming portfolios within predictable timeframes is critical to the way we do business. The implementation of Phinsys products supports our continued drive for scalable operational excellence.
Pillar Capital, an investment advisor specialising in Insurance-Linked Securities (ILS), aimed to enhance efficiency by replacing manual spreadsheet processes with an automated database system. This case study examines how automating data consolidation and reporting improved operational effectiveness and facilitated the onboarding of new investments.
Pillar Capital relied heavily on manual spreadsheet processes to manage their financial data, resulting in inefficiencies and increased risks of errors.
As the spreadsheets grew, they became unwieldy and unstable, hindering productivity and data accuracy.
Users had to manually copy and paste financial values across spreadsheets, a process prone to human errors and delays.
Pillar Capital needed a solution that consolidated calculations in one central place and provided an audit trail for data inputs and executions.
Integration with their source system, PROS, was crucial for seamless data management.
Pillar adopted the Phinsys suite, which included automated data feeds, manual Excel inputs, double-entry accounting, and an automatic reconciliation process to ensure data integrity and reporting accuracy.
A rules-based calculation and allocation engine automating premium ceded premium allocation, IBNR calculation, expense allocation, and business forecasting.
An accounting rules engine that ensures the integrity of financial accounts, manages accounting journals, and supports different time zones and multiple ledgers.
A reporting data layer and visualisation dashboard displaying data progression, offering granularity for business performance understanding, and facilitating a seamless transition from management to statutory to reconciled regulatory data submission.
Consolidated financial data from over 750 Excel worksheets into a central database enhancing accessibility and reducing errors.
Consolidation of data across all funds, enabled analysis and reporting on separate or combined fund performance.
Reduced manual data handling, allowing the finance team to focus on strategic analysis and reporting.
Simplified integration was evident when two new funds were introduced during the project demonstrating the system’s adaptability and elimination of extensive configuration.
Reduced manual data handling, allowing the finance team to focus on strategic analysis and reporting.
Multi-level data could be analysed, from individual contacts to fund performance, improving decision making.
Pillar Capital’s shift from manual spreadsheets to an automated system significantly advanced data management, reporting efficiency, and the integration of new investments. The central database streamlined processes, minimised errors, and enhanced the finance team’s analytical capabilities, boosting overall operational effectiveness.
As our funds under management continued to grow last year, using complex spreadsheets to calculate and report on key finance data quickly became unsustainable. With minimal configuration, Phinsys systems have brought our finance data into a single location, automated previously manual processes, and enabled rapid, detailed analysis, audit and financial reporting on a per-fund or combined basis. All of this means we can quickly and efficiently onboard new funds as we scale our business further.















































We’ve been able to create a single source of truth and standardise the processes for our financial and actuarial insurance accounting. Fast, accurate automation has reduced manual processing, eliminating the need to increase headcount and reduced operating costs across the entire group.