Wealth Management

IOOF - APRA Reporting

Download the case study

Client

IOOF

Problem

Prepare and submit returns to APRA as part of their regulatory requirements on a quarterly and annual basis.

Solution

IOOF chose SolveXia to automate the preparation of XBRL data to be submitted to APRA. By automatically converting their Excel workpapers into APRA-ready XBRL documents.

About IOOF


IOOF has been helping Australians secure their financial independence for over 170 years. Founded in 1846, IOOF has grown to become a leading provider of quality financial advice, product sand services. The company has over 1,000,000 member accounts and A$202 billion* in funds under management and administration. IOOF believes that success only comes from caring about people, providing outstanding service and consistent performance. This focus on excellence and consistency is echoed throughout the company, which is why IOOF chose SolveXia to optimise and automate the preparation of their APRA returns.

*(As of 1st May 2020)

The Challenge

The Fund Statutory Reporting team at IOOF needs to prepare and submit returns to Australia’s Prudential Regulation Authority (APRA) as part of their regulatory requirements. Completed on a quarterly and annual basis, the reporting is an essential part of IOOF’s reporting cycle. It ensures the company can comply with regulations whilst also providing credibility and confidence to the market and IOOF’s customers.

The process of preparing and lodging APRA Returns into APRA’s lodgement portal system “Direct to APRA” (D2A) was very manual for IOOF. It relied heavily on staff to prepare financial data in Excel and then copy and paste this data into the appropriate returns, a common practice across APRA regulated entities.

IOOF needs to submit data for more than 50 different forms. The process was time-consuming and reliant on a few key staff members. There was also the risk of human error associated with manual data entry into D2A. Furthermore, in 2021 APRA is replacing D2A with a new system called DCS. IOOF anticipates that DCS will significantly increase the amount of manual effort needed to populate and submit returns. With the submission process already requiring more than 10 days of effort each year (and growing with APRA demanding more forms and more detailed reporting), IOOF determined that a solution was critical to avoiding additional compliance costs and error risk.

SolveXia has greatly assisted our company reduce the time and effort involved in preparing and lodging our Quarterly and Annual APRA Returns

Paul Tsironis at IOOF Head of Fund Statutory Reporting  

Solution

IOOF chose SolveXia to automate the preparation of XBRL data to be submitted to APRA. By automatically converting their Excel work papers into APRA-ready XBRL documents, staff can easily upload the returns into APRA’s D2A software. This solution saves significant amounts of time and mitigates the risk of errors associated with manual data entry.

As a first step, SolveXia delivered and demonstrated a Proof-of-Concept to the team at IOOF to determine the feasibility of automating this task. This step was vital as it provided the team with a fast and cost-effective way to assess the technology without committing to the entire project.

The next step was to design a fully automated solution. This involved the creation of two key process capabilities. First, SolveXia created a dedicated Excel-to-XBRL converter module. The module provides pre-tagged Excel template forms which take data from existing Excel work papers and map these to the APRA forms.

Key Results and Outcomes

The Fund Statutory Reporting team at IOOF is now able to prepare their APRA submissions in minutes instead of days. Staff no longer need to spend their time performing the mundane task of copying and pasting or rekeying data into the APRA forms. Instead, their time can be reallocated to analysis and to improve the quality of IOOF’s processes and data.

IOOF has mitigated key risks such as human error and is less dependent on the knowledge of key staff in relation to the submission of returns. Furthermore, the company has helped avoid significantly higher compliance costs that would otherwise have been the case when APRA launches its new reporting tool or adds new forms.

Also, IOOF implemented this solution at the height of the COVID-19 lockdown, with staff forced to work remotely. The project met key milestones to go live in time for the quarterly submissions. By leveraging a secure cloud technology like SolveXia, IOOF was able to show the true value of using disruptive new digital technologies to improve outcomes for their company, staff and regulators.

Key Metrics

  • 20 days of time saved each year.
  • Working PoC delivered within 4 calendar weeks.
  • Phase 1 or production solution delivered in 2 months.

Download the Full Case Study

More from SolveXia

5 Tips For Better Data Quality

The objective of any BI or Analytics initiative is to equip your company with better decision-making capabilities. Find out how here.

Read more »

5 ways Finance gains intelligence through automation

Download our free eBook to learn the 5 important ways that Finance departments can raise their game through automation

Read more »

Reach Out and Start Automating Today

Try it Free