Get your data into Timeline: where to start
Summary
-
Your client details: From Intelliflo, your investment platforms, a spreadsheet through Pennee, the client's FactFind, or by hand.
-
Their investment accounts: From your investment platforms, a spreadsheet through Pennee, the client's FactFind, or by hand. Timeline MPS and Timeline Platform accounts come in for you.
-
Cash, income, property and debts: From a spreadsheet through Pennee, the client's FactFind, or by hand in the Client record.
-
Where to start: Your back office first, then your investment platforms, then spreadsheets for anything left.
Description
1. Where each kind of data comes from
|
Kind of data |
Where it can come from |
See |
|
Client details: name and personal and contact details |
|
Section 2 |
|
Investment accounts, with holdings and balances |
|
|
|
|
For what each source brings, detail by detail, see What client data each connection brings into Timeline.
2. Choose your way in
All of these start from the Client list: click "Add new".
|
What you have |
What comes in |
How often it updates |
Where to start |
|
Intelliflo |
Each client's personal and contact details. No investment accounts |
Each time you import |
"Import multiple clients", then "Intelliflo". See Connect Intelliflo and import your clients |
|
An investment platform Timeline links to |
|
Every night |
"Import multiple clients", then the platform. See Link your investment platforms |
|
A spreadsheet, from any back office or platform |
|
Each time you import a spreadsheet |
"Import Spreadsheet (AI)". See Import clients and their accounts from any spreadsheet with Pennee |
|
A single client |
What you type in |
When you change it |
"Add individual client" |
3. If you use more than one
Start with your back office, then link your investment platforms, then import spreadsheets for platforms Timeline doesn't link to yet.
-
Why the back office first: An import only fills details that are empty in Timeline, so the first value in is the one kept. Your back office is usually the most up-to-date source for client details.
-
Then your platforms: Platform links find the clients you already have and add their accounts.
-
Clients you already have: Every route checks for them first, so you don't get duplicates. See How Timeline matches clients, and which data wins.
4. Already using Timeline MPS or the Timeline Platform?
-
Timeline MPS: If Timeline's investment team manages your MPS accounts, they already bring those clients and accounts in for you.
-
Timeline Platform: Accounts on the Timeline Platform are already in Timeline and update every day.
Conclusion
Most firms use more than one route: their back office for client details, platform links for what they hold, and spreadsheets or the FactFind for the rest. Start with the one that covers most of your clients, then fill the gaps.
FAQs
We use Xplan. Can we connect it?
Not directly. Export your clients from Xplan as a spreadsheet and import it with Pennee. See Import clients and their accounts from any spreadsheet with Pennee.
My platform isn't in the "Import multiple clients" list. What can I do?
If you see your platform in the Finio authorisation form, but it isn't in Timeline's list, you should still authorise this one on the same form too. We're regularly adding to the platforms that we offer, so by authorising, your data will be imported as soon Timeline adds that platform; see Link your investment platforms. If you need your data into Timeline sooner, you can export a spreadsheet from the platform and then upload it with Pennee; see Import clients and their accounts from any spreadsheet with Pennee.