Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can We Stop Retyping Client Data Into Our Cash Flow Planning Tool?
Problems We Solve

How Can We Stop Retyping Client Data Into Our Cash Flow Planning Tool?

Financial planners retype income, assets and pensions from the back office into cash flow tools before every meeting. We build the data link and the checks.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Cash flow planning is only as current as its inputs, and at many firms those inputs are retyped from the back office, fact find and valuations before each meeting. We build a link that sends client details, holdings and valuations into your cash flow tool where it allows, flags which inputs have changed since the last plan, and records what was used. The assumptions and the planning stay with your planners.

Rebuilding the plan before every meeting

A planner has a review next week and wants to update the client's cash flow plan. They open Voyant, CashCalc or whichever tool the firm uses, and start updating: current pension values from the latest valuations, ISA balances, the new salary from the fact find update, the mortgage balance, a new regular saving. Some of this is in the back office. Some is in emails. All of it is typed in again.

Then they notice the plan still has last year's state pension figure and the client's partner's pension is missing entirely. More checking, more typing. The meeting prep takes most of a morning.

Why the tools do not talk

Cash flow tools and back office systems are often bought separately. Some have integrations, and those help, but they rarely carry everything across, and planners do not always trust what arrives, so they check by hand anyway.

There is also no simple record of what changed. When the planner opens the plan, they cannot easily see which inputs are out of date and which have not moved since last year.

  • Integrations that move some data but not all of it.
  • Valuations in the back office that are more recent than the plan.
  • Fact find updates that never reach the cash flow tool.
  • No record of which inputs changed between plans.
  • Each planner maintaining plans in their own way.

Couples and families make it harder again. The back office may hold each partner as a separate client, while the cash flow plan treats them as one household. Unless someone knows to look at both records, a pension belonging to one partner simply never reaches the joint plan.

The cost of stale inputs

InputCommon problem
Pension and investment valuesTaken from an old valuation
Income and expenditureNot updated after the fact find refresh
LiabilitiesMortgage balance from last year
Partner's holdingsMissing or entered separately
Regular contributionsChanged at review, not in the plan

Planner time is the obvious cost. The less obvious one is a plan presented with a figure the client knows is wrong, which makes them wonder about everything else on the screen.

  1. We map which inputs your cash flow tool needs and where each lives today: back office, fact find, valuations, or the planner's notes.
  2. Where the cash flow tool has an API or import, we send client data, holdings and current values across from your back office.
  3. Before a review, a comparison shows each input with its value in the plan, its latest value in your systems and the date of each.
  4. The planner accepts changes item by item, so nothing overwrites the plan silently.
  5. Inputs that could not be sent automatically are listed as a short manual checklist.
  6. A record is kept of which values were used in each version of the plan, and their sources.

We do not set growth rates, inflation, life expectancy or any other assumption. Those are your planners' choices, made in the tool as now.

What planners gain

Review prep starts with a list of what has changed rather than a blank check of everything. Accepting updates takes minutes. Partners' holdings and new plans stop going missing. And when someone asks which figures a plan was based on, the answer is recorded.

It also makes plans easier to hand over. When a planner is away or a client moves to a colleague, the plan carries a clear record of where each figure came from and when it was last updated, so the new planner is not left guessing whether the numbers can be trusted.

Does this sound familiar?

  • Planners retype values into the cash flow tool before reviews.
  • Your integration moves some data, but staff re-check everything.
  • Plans are presented with out of date figures.
  • You cannot easily see what changed since the last plan.
  • Partners' plans are handled separately and inconsistently.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Which cash flow tools can you connect to?

It depends on the tool's API or import options. We check yours before proposing anything, and plan manual steps where there is no route.

Will this change the plan automatically?

No. The planner sees each change and accepts it. Nothing overwrites the plan without their say.

Do you set assumptions?

No. Assumptions and planning choices stay entirely with your planners.

What affects the cost?

Which cash flow tool and back office you use, how much data needs to move, and how clean it is today.

Keep reading

More on Problems We Solve

Start here

Tell us where your advice firm's admin gets stuck

Describe the task, the back office system you use and where cases or clients stall. We will tell you what we would build and what we would leave alone. Advice and compliance decisions stay with your firm, and if a smaller change would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →