Full asset & pension solution
Overview
Easily create an internal bulk valuation report of current assets and pensions for your client bank that generates in Excel format.
The report displays the current value along with total contributions and total withdrawals as well as displaying client adviser, entity status, policy status, held in trust or in a platform wrapper.
As always, though, we are open to feedback if anything needs to be clarified or included.
What is it?
- A bulk valuation of assets and pensions with total contributions and total withdrawals
- Generates as Excel format
- Runs against a list of clients (bulk reporting)
- Reports on the current position
- Reports on client and partner values
- Combines assets and pensions in one report
- Does not duplicate data for jointly owned assets
- Reports on SIPP wrapper values
- Does not report on assets held in SIPP wrappers
- Does not report on platform wrap totals
- Does not report on defined benefit pensions
- Intended for internal reporting purposes
Key benefits
- Eliminates the need to run separate Xports (one for assets and one for pensions
- Consolidates asset and pension data
- Consolidates data from your client and partner records
- No need to convert from CSV to Excel format
- No need to remove duplicates from the output
- No need to enter dates, reports on current position
Content
Valuations
The data is taken from each policy recorded in the Financial Details fields in Client Focus:
Current value Assets - the Current Value is displayed
Pensions - the Fund Value is displayed
Total contributions - the value is taken from the Contributions tab, Total Contribution to Date Calculated
Total withdrawals - the value is taken from the Withdrawals tab, Total Withdrawal to Date Calculated
Generate
The report is designed to be generated against a list of clients:
- Filter or search on a list of clients
- Select Reports in the left menu
- Select Merge report
- Select the Full Asset & Pension template
- Execute
The Excel report will be sent to your Notification icon.
This report is not intended to be run on a single client basis.
Excel output
The following fields are generated for the relevant policy types (based on status) for client, partner and joint, sorted alphabetically by owner name:
- Owner
- Entity ID
- Entity status
- Adviser
- Type
- Product
- Policy description
- Provider
- Policy number
- Policy status
- In trust
- Start date
- Total contributions
- Total withdrawals
- Current value
- In a platform wrap
Excluded from this report
- Policies with status other than those listed above are excluded.
Troubleshooting / FAQs
-
How are contributions and withdrawals I’ve recorded in Xplan reflected in this report?
Contributions and withdrawals are taken from the details recorded in the Contributions and Withdrawals tabs within the plan record.
