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.
- Holdings and valuations
- Performance over the period
- Cash flows, top-ups, withdrawals
- Charges
- Commentary first draft
- Suitability
- Recommendations
- Edits to the commentary
- Final approval
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
| Section | Automate? | Why |
|---|---|---|
| Holdings and valuations | Yes | Read from platform and provider documents |
| Performance | Yes | Calculated from valuations and cash flows |
| Cash flows and charges | Yes | From transaction histories and provider costs and charges statements |
| Commentary | Draft only | Written from the data, edited by a person |
| Suitability | No | Adviser judgement |
| Recommendations | No | Adviser 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.
Related guides
Step by step
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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
- Platform valuation vs statementTwo figures for one holdingConflict
- Growth after the top-upCalculated from valuations and cash flowsCalculated
- Offshore bondProvider’s own growth figureFrom statement
- Recommendations sectionLeft for the adviserAdviser
- 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.