How advisers collect client
expenditure data — and why
it breaks.

The spreadsheet ritual

The pattern is remarkably consistent across firms. At onboarding, the client receives an expenditure form — a spreadsheet, a fillable PDF, sometimes a page inside the fact-find portal — with anywhere from twenty to sixty categories. Mortgage or rent. Utilities. Groceries. Motoring. Holidays. "Other leisure." The client sits down one evening, weeks after the meeting where it was requested, and fills it in from memory.

Some entries are accurate: the mortgage payment, the council tax, the fixed direct debits a client can read from one bank statement. Then come the variable categories, and the numbers turn round. £400 groceries. £150 eating out. £100 "miscellaneous". Nobody knows their real figure for these, because nobody experiences their spending as categories — they experience it as hundreds of individual card taps that leave no aggregate impression.

The adviser receives the form, sense-checks the obvious gaps ("nothing for clothing?"), plugs the figures into the cashflow model, and the plan is built. A year later, at review, the client is asked what changed. They update three numbers and confirm the rest — which means the original guesses now carry a year of unearned credibility. By year five, the expenditure section of the plan is an artefact with only a loose relationship to the household it describes.

Why guesstimates break the model

Recall bias runs one direction. When people estimate spending from memory, the errors aren't random — they skew low, and they skew lowest exactly where spending is most discretionary. Small frequent purchases (coffee, lunches, subscriptions, taxis) are individually forgettable and collectively large. Irregular lumpy costs — car repairs, vet bills, the boiler, the wedding gift season — get smoothed out of a "typical month" that never actually occurs.

Cashflow models amplify the error. An expenditure line understated by a few hundred pounds a month looks trivial on the form. Compounded across a thirty-year projection, it changes the shape of the plan: the sustainable withdrawal rate, the retirement date, the surplus available for gifting or investment. The model's precision is real; the input's precision is theatre.

The professional risk sits with the firm. Suitability rests partly on an accurate picture of the client's circumstances. A file that documents expenditure as "client-confirmed" is defensible in form, but every adviser knows the difference between a client confirming a number and a client knowing it. When plans go wrong, "the client told us £400" is a thinner shield than a categorised, evidenced record.

It costs the relationship, too. The questionnaire is homework, and clients experience it as such. Chasing an unreturned expenditure form is nobody's favourite email to send. And the review meeting time spent re-collecting data is time not spent on the conversation the client values — what the numbers mean and what to do about them.

The halfway house: bank statement analysis

Some firms respond by requesting three months of bank statements and categorising them in-house — paraplanner time, a spreadsheet, sometimes a statement-scanning tool. This genuinely improves accuracy, and for one-off cases it works. As a firm-wide process it has two problems: it's slow (hours per client, multiplied by every review), and it samples a quarter of the year, so seasonal spending — holidays, Christmas, insurance renewals — lands in or out of the window by luck.

The Open Banking alternative

Open Banking changes the collection mechanics entirely. The client connects their accounts once, through their own bank's authentication, granting read-only access under the UK's Account Information Services framework. From that point, categorised expenditure accumulates continuously — twelve full months of it by the first annual review, with no forms, no statements, and no memory involved.

What good looks like in practice

The destination isn't "the adviser watches every transaction" — that serves nobody and clients wouldn't consent to it. The workable model is category-level: the client uses a consumer app that categorises their spending automatically, and grants their adviser access to the summary layer — housing, bills, groceries, transport, discretionary — with drill-down available when a figure needs interrogating together in a meeting. The adviser gets a defensible expenditure base; the client keeps ownership of the detail.

This is the shape earmarkIQ has built. The consumer app is live on iOS — Open Banking connections to 50+ UK banks, automatic categorisation, subscription and price-rise detection, property valuation inside net worth. The adviser platform backend on top is live too: clients grant consent at category or transaction level, advisers can recategorise to match how the firm models, and exports work with any cashflow modelling tool today. The adviser web dashboard is live.

FAQ