Client Manager
Your client database — add clients once, the tool remembers everything from there.
0 clients
| Client | Provider | Policy | Currency | Last Value | Last Statement | Status | |
|---|---|---|---|---|---|---|---|
| No clients yet — click "Add Client" to get started | |||||||
New Statement
Select a client, upload their provider files, and generate the statement.
⚠ CIG FILE DATE RULE: Always download the valuation CSV dated the 1st of the following month — not the last day of the statement month.
FPI: Download on the 1st of each month for the previous month-end valuation.
FPI: Download on the 1st of each month for the previous month-end valuation.
1
Select ClientAutomatically filled from previous month's closing value
2
Upload Provider FilesValuation CSV Holdings, values, gains
Drop CIG valuation CSV
valuation_[policy]_[date]_GBP.csv
✓
Transaction CSV Fees & income
Drop CIG transaction CSV
transactions_[policy]_[date].csv
✓
FPI Valuation PDF Holdings, values, fees & income
Drop FPI Valuation PDF
ValuationReport_Bond-[plan]-[date].pdf
Download on the 1st of each month from the FPI portal
✓
FPI PDF contains everything — holdings, fees and transactions are all in one file. No separate transaction file needed.
Claude API will extract and parse the data automatically.
4
Generate StatementStatement History
All generated statements with closing values and key metrics.
| Client | Month | Provider | Closing Value | MoM Return | Generated |
|---|---|---|---|---|---|
| No statements generated yet | |||||
Settings
Your adviser details — used across all statements.
Adviser Details
Data Management
Export regularly to back up your client database to iCloud.
Database Manager
Manage fund factsheets and structured product records. Used for geographic exposure and SP tracker in statements.
Fund Factsheet Database
| Fund Name | ISIN | Currency | Type | Top Region | Last Updated |
|---|
Structured Products Database
| Product Name | ISIN | Issuer | Currency | Nominal | Coupon p.a. | Maturity |
|---|