Client Wealth Report PDF Data Assurance

Mission Statement

Our client is an adviser to some of the world’s leading High Net Worth families and wealth creators. They combine complex investment information data from a number of systems and send to a specialist third-party firm who creates PDF outputs from their data to send to their clients.

This is a common approach, but does introduce a risk that the reports may not fully represent the data. To mitigate this risk, our client reviews each report since their business is based on top quality service. This costs the client a significant amount of time each month that they could use to service new clients.

We have automated this process matching the source data with the final report, saving a lot of time and providing confidence and comfort that clients always have the best and up to date information.

If you’re interested in how we did this in a very short period of time, read on- it’s simpler than it seems and will save a lot of time and stress for any organisation adopting this data driven automated approach.

Tools Used

Alteryx

- API Connector

- Extraction of tabular data

- Reconciliation against existing data

- Alteryx Server

Nanonets

- PDF Table Extraction

Detailed Solution

First, our client’s data is sent to a third party firm for PDF processing. Continuum integrated Nanonets into this process, by using Nanonets’ AI capabilities to extract tabular data from the incoming PDFs. This tabular data is automatically fed into Alteryx, where our first workflow autonomously classifies distinct datasets.

We then built a second workflow, which performs a reconciliation between the system data sent to the specialist third-party firm and the PDF reports produced for our client. These can then be used to improve the process and catch mistakes before sending reports.

All discrepancies are recorded in an Excel spreadsheet which is sent back to the client. This checks the accuracy of the PDF outputs and allows a greater degree of confidence in them. Additionally, employees can easily audit and correct any issues.

Overall, we helped to transform our client’s auditing processes. Our client saved several hours each week, allowing them to refocus resources on higher-value tasks.