Import clients and their accounts from any spreadsheet with Pennee
Summary
-
Any spreadsheet: Pennee imports a CSV or Excel file of up to 8 MB, exported from your back office, a platform or your own records. You don't need a template.
-
Six kinds of data: Pennee brings in clients, investment accounts with their holdings, cash and savings accounts, income, property and other assets, and debts.
-
Clients you already have: Pennee recognises them by NI number, client reference and name. When it isn't sure, you choose before anything is imported.
-
Details kept up to date: An import updates a client's address, phone number, marital status and nationality. Their name stays as it is in Timeline, and their date of birth, gender, NI number and email address are only filled in when Timeline has none.
-
Keeping accounts up to date: Import a newer spreadsheet to update the accounts in it.
Description
1. What Pennee can import
Each import brings in one kind of data. Pennee reads these details:
Kind of data | What Pennee reads |
Clients |
|
Investment accounts |
|
Cash and savings accounts |
|
Income |
|
Property and other assets |
|
Debts |
|
Clients and investment accounts can come from the same sheet: Pennee brings in the clients and their accounts together.
If an account's model portfolio has the same name as one your firm already uses, Pennee links the account to it.
2. Before you start
-
One kind of data per import: If your file has several sheets, Pennee imports one sheet at a time and asks which one.
-
Clients: Each row needs the client's name, in one column or as first and last name. Separate first and last name columns give the best result. An NI number or client reference helps Pennee recognise clients you already have (section 4).
-
Investment accounts: Each account needs its account reference and a value: either the account's total value, or each fund's value. If your spreadsheet gives each fund's share of the account as a percentage, include the account's total value too. Each fund needs its ISIN.
-
Cash, income, property and debts: These are added to clients who are already in Timeline. Import the clients first, from a spreadsheet or another connection.
-
Mortgages: Import the property before the mortgage, so the mortgage can be linked to it.
3. Import a spreadsheet
-
On the Client list, open the menu for adding clients and click "Import Spreadsheet (AI)". Pennee opens. You can also ask Pennee to import a spreadsheet from anywhere in Timeline.
-
Upload your CSV or Excel file. If it has more than one sheet, choose the sheet to import.
-
Choose the kind of data in the sheet, then the platform or back office it comes from. If yours isn't in the list, choose "Other" and type its name.
-
Check the columns. Pennee shows which column it will read into each Timeline field, with example values. Correct any that are wrong. Pennee remembers your choices for your firm, and suggests them next time you import a sheet with the same columns.
-
Check the possible matches. Pennee shows a table of clients in the spreadsheet who might be clients you already have. For each one, choose the matching client, create a new client, or skip the row. If there aren't any to check, Pennee shows a preview of the first rows and what will happen to each instead.
-
Click "Approve & Import", or "Proceed" if there were no possible matches to check. Nothing is imported until you do.
When the import finishes, Pennee tells you how many clients it added and updated, and lists any rows it couldn't import, with the reason for each.
4. Clients you already have
Pennee checks each client's NI number, then their client reference, then their name. A match on NI number or client reference is used straight away. A client who only matches by name goes in the table of possible matches for you to check (step 5).
When a client you already have is in the spreadsheet:
-
Updated from the spreadsheet: address, phone number, marital status and nationality. The imported address becomes the client's main address, and any other addresses you have for them are kept.
-
Kept as it is in Timeline: the client's name.
-
Only filled in when empty: date of birth, gender, NI number and email address. If the spreadsheet's date of birth, NI number or email address is different from the one in Timeline, Timeline keeps its own and Pennee tells you.
For how this works across all of Timeline's connections, see How Timeline matches clients, and which data wins.
5. Updating accounts with a newer spreadsheet
Import a newer spreadsheet with the same accounts to update them.
Account | What a newer spreadsheet updates |
Investment accounts a spreadsheet brought in | Value and holdings, and the model portfolio if your spreadsheet names one |
Timeline MPS accounts | The balance only |
Accounts on the Timeline Platform | Nothing. They always show what the Timeline Platform holds |
Between imports, accounts from a spreadsheet stay as they were. If the platform is available as a platform link, link it to have the accounts updated every night: see Link your investment platforms.
6. When Pennee can't import a row
A row Pennee can't import doesn't stop the rest of the spreadsheet. Pennee lists each row it couldn't import, with what went wrong and what to do. Most fixes are a correction in the spreadsheet followed by a new import, or a merge of two clients in Timeline. For the full list of reasons, see How Timeline matches clients, and which data wins.
Conclusion
Moving to Timeline, or bringing in a platform Timeline doesn't connect to, no longer means typing each client and account in by hand. Export what you have, give it to Pennee, check the matches, and your clients arrive with their accounts, savings, income, property and debts.
FAQs
Is there a template for the spreadsheet?
No. Pennee reads your column headings and suggests which Timeline field each one fills, so you can import a file exactly as your back office or platform exports it. You check the columns before anything is imported (section 3, step 4).
Can I import an export from Intelliflo, Xplan or another back office?
Yes. Export your clients as a CSV or Excel file and import it with Pennee. If you use Intelliflo, you can also connect it to Timeline directly: see Connect Intelliflo and import your clients.
Will importing a spreadsheet create duplicate clients?
Pennee checks every client against the clients you already have, by NI number, client reference and name, and asks you about any it isn't sure of. Including NI numbers or client references in your spreadsheet gives Pennee the best chance of recognising existing clients. For how Timeline recognises clients across all its connections, see How Timeline matches clients, and which data wins.