How to automate annual review reports

How an advice firm can automate the preparation behind annual review reports, from documents in to a draft out, without handing over the advice or the sign-off.

By Roleplan 9 min read

The short answer

To automate annual review reports, map the sections your report always contains, decide where each figure comes from, and let software read the documents, file them to the right accounts, calculate returns and fill a draft in your template. Keep anything that is a judgement, such as suitability and recommendations, with the adviser, and have a person approve every report. Prove it on past reviews before you rely on it.

Why annual reviews are hard to automate

The simple review, with one provider, no changes and no withdrawals, is easy to template. Many firms already have something that handles it. The time goes on everything else: a switch part-way through the year, a top-up, drawdown, several providers, a family with linked accounts, or an offshore bond that reports a single growth figure.

Those reviews need someone to gather documents from several places, reconcile them, re-key holdings, work out performance around the cash flows, and then write and format the report. That is the work worth automating.

What to automate, and what not to

SectionAutomate?Why
Holdings and valuationsYesRead from platform and provider documents
PerformanceYesCalculated from valuations and cash flows
Cash flows and chargesYesFrom transaction histories and provider costs and charges statements
CommentaryDraft onlyWritten from the data, edited by a person
SuitabilityNoAdviser judgement
RecommendationsNoAdviser judgement

A note on complex cases

Build and test with your awkward reviews from the start. If the setup only works for single-provider, no-change clients, it will not save much time, because those were never the slow ones.

Step by step

  1. 01

    Write down what every report contains

    List the sections your annual review always has, such as summary, objectives, holdings, performance, charges, cash flows, recommendations and next steps. Note which are the same for every client and which change.

  2. 02

    Mark each section as data, drafting or judgement

    Data sections are filled from documents (holdings, valuations, transactions). Drafting sections are written from that data (performance commentary). Judgement sections stay with the adviser (suitability, recommendations). Only automate the first two.

  3. 03

    Decide where every figure comes from

    For each figure, name the source: platform valuation, transaction history, provider statement or fact find. Decide the rule when sources disagree, how a provider-reported figure is labelled, and the calculation method for returns (for example time-weighted or money-weighted), and state that method in the report.

  4. 04

    Standardise the document drop

    Agree one place where the paraplanner puts a client’s documents for the review, and a simple naming habit. Consistent inputs matter more than any software choice.

  5. 05

    Automate gathering, filing and calculation

    Have the system read each document, file it to the right account and account holder, identify holdings by ISIN or provider fund code, and calculate returns from valuations and cash flows rather than copying them off statements.

  6. 06

    Generate the draft in your template

    Fill the data sections and draft the commentary in your house style. Link every figure to its source and list anything that could not be found or verified.

  7. 07

    Keep sign-off with a person

    The paraplanner checks the flagged items and edits the draft. The adviser adds the judgement sections, and a named person, usually the adviser, approves. Log every change.

  8. 08

    Prove it on past reviews, then roll out

    Rebuild a set of reviews you have already signed off, simple and complex, and compare. Go live with one adviser first, once the results meet the bar you agreed.

Common mistakes

The draft shows where every figure came from, and what is left for the adviser.
  • Automating the easy no-change reviews and leaving the complex ones, where most of the time actually goes, untouched.
  • No rule for what happens when two documents give different figures for the same holding.
  • Copying growth figures off provider statements instead of calculating them.
  • Letting the system write the recommendation section.
  • Inconsistent document naming and storage, so the system cannot tell which file is the latest valuation.
  • Going live without testing against reviews you have already signed off.

Questions

Can annual review reports be fully automated?

The preparation can be largely automated: gathering documents, filing them, calculating returns and drafting in your template. The report should not reach a client without a person checking it, and suitability and recommendations stay with the adviser.

What software do advice firms use to automate reviews?

Some firms use the review reports built into their back-office or planning software, which tend to suit simple no-change reviews. Others use a custom build around their own template for complex cases. The right choice depends on how many of your reviews are simple.

How do you automate performance figures in a review report?

Calculate them from the client’s own valuations and cash flows for the review period, rather than copying a provider’s growth figure. Where only the provider’s figure exists, show it and label it as reported.

How long does it take to automate annual review reports?

It depends on your template and the number of platforms you use. Allow time to test against past reviews before going live: that step is what tells you the output is right.

Want your annual reviews drafted in your template and run for you?