Documentation

Scenario Defaults and Custom Funds Documentation

The Scenario Metrics tab, accessible from your profile page, is a powerful configuration hub that streamlines workflow and ensures consistency across all financial plans within an organization. This tab allows advisers to set organization-wide default values and maintain a comprehensive library of investment and KiwiSaver funds.

This configuration hub controls:

  • Default Scenario Values: Pre-configured values automatically applied to new scenarios
  • Toggle States: Control which input fields are visible in the planner interface
  • Custom Investment Funds: Organization-specific investment fund library with customized risk/return profiles
  • Custom KiwiSaver Funds: Organization-specific KiwiSaver fund library
  • Market KiwiSaver Funds: Integration with MorningStar database containing real NZ KiwiSaver fund data
  • Starred Funds: Curated selection of frequently-used market funds for quick access
  • Fee Structures: Organization-wide fee settings including tiered fee structures and advice fees

How Scenario Defaults Work

Application Priority

When creating new scenarios, values are applied in this priority order:

  1. Explicit Client Data: If specific client information is provided, it takes precedence
  2. Scenario Defaults: Pre-configured default values from this tab
  3. System Defaults: Hard-coded fallback values if no defaults are configured

Automatic Scenario Creation

The "Create Scenario Automatically" feature uses these defaults to quickly populate new financial plans:

  • Fields without client data use configured default values
  • Toggle states control which sections are visible
  • Reduces manual data entry for common assumptions
  • Ensures consistency across advisers within an organization

Manual Scenario Creation

Even when manually creating scenarios, defaults provide:

  • Suggested starting values for all inputs
  • Consistent economic assumptions (inflation rates, returns)
  • Pre-configured fund selections
  • Standardized planning methodologies

Permissions and Access Control

User-Level Permissions

Scenario Metrics (Individual User Settings):

  • Each user can configure their own default values
  • User-specific toggles for field visibility
  • Personal workflow preferences
  • Saved per user ID in scenario_metrics table

Organization Funds (Organization-Wide Settings):

  • Only organization owners can modify fund libraries
  • Shared across all users in the organization
  • Controls custom funds, starred market funds, and fee structures
  • Saved per organization ID in organization_funds table

Permission Levels

canEditScenarioMetrics:
  - Edit personal default values
  - Configure personal toggle states
  - All users have this permission for their own settings

canEditOrganizationFunds:
  - Add/edit/delete custom funds
  - Star/unstar market funds
  - Accept KiwiSaver data disclaimer
  - Configure organization-wide fee structures
  - Only organization owners have this permission

Default Scenario Values Configuration

Personal Tab Defaults

Include Partner:

  • Toggle: Controls visibility of partner-related fields
  • Default Value: Boolean (true/false)
  • Use Case: Organizations working primarily with couples vs. individuals

Income Tab Defaults

Include NZ Superannuation:

  • Toggle: Show/hide NZ Superannuation section
  • Default Value: Boolean (typically true for NZ clients)
  • Use Case: Disable for clients not eligible for NZ Superannuation

Income Inflation Rates:

  • Main Income Inflation: Default annual wage growth rate (typically 2-3%)
  • Partner Income Inflation: Separate inflation for partner's income
  • Additional Income Inflation: Inflation for supplementary income streams
  • Toggles: Control visibility of each inflation rate field
  • Use Case: Different inflation assumptions for different income types

Expense Tab Defaults

Second Expense Category:

  • Toggle: Show/hide second expense category
  • Default Value: Boolean (enables two expense categories)
  • Use Case: Separate essential vs. discretionary expenses

Expense Inflation Rates:

  • Expense 1 Inflation: Inflation for primary expense category
  • Expense 2 Inflation: Inflation for secondary expense category
  • Additional Expense Inflation: Inflation for one-off expenses
  • Use Case: Different inflation rates for different spending categories

Savings Tab Defaults

Cash Reserve:

  • Toggle: Show/hide cash reserve target field
  • Default Value: Numeric (e.g., $10,000)
  • Use Case: Standard emergency fund recommendation

Savings Allocation:

  • Toggle: Show/hide excess cashflow allocation to savings
  • Default Value: Percentage (e.g., 10%)
  • Use Case: Default savings rate for surplus income

Investment Tab Defaults

Utilize Excess Cashflow:

  • Toggle: Show/hide excess cashflow allocation feature
  • Default Value: Boolean (enable automatic allocation)
  • Use Case: Automatic investment of surplus cashflow

Default Investment Fund:

  • Fund ID: Reference to default fund (e.g., 'inv-3' for Balanced)
  • Fund Type: Fund name (e.g., "Balanced")
  • Annual Return: Expected return percentage (e.g., 5.5%)
  • Standard Deviation: Risk/volatility (e.g., 8.0%)
  • Income Portion: Taxable income percentage (e.g., 60%)
  • Use Case: Pre-select conservative/moderate/aggressive default strategy

KiwiSaver Tab Defaults

Employee Contribution Rate:

  • Toggle: Show/hide employee contribution field
  • Default Value: Percentage (e.g., 3%, 4%, 6%, 8%, 10%)
  • Use Case: Standard KiwiSaver contribution rate

Employer Contribution Rate:

  • Toggle: Show/hide employer contribution field
  • Default Value: Percentage (minimum 3% in NZ)
  • Use Case: Minimum employer contribution requirement

Consolidate KiwiSaver:

  • Toggle: Show/hide KiwiSaver consolidation feature
  • Default Value: Boolean (typically false initially)
  • Use Case: Standard retirement strategy for organization

Default KiwiSaver Fund:

  • Fund ID: Reference to default KiwiSaver fund
  • Fund Type: Fund name
  • Annual Return: Expected return
  • Standard Deviation: Risk level
  • Income Portion: Taxable portion
  • Fees: Management fees percentage
  • Advice Fees: Adviser fees if applicable
  • Use Case: Standard KiwiSaver fund recommendation

Property Tab Defaults

Rental Income:

  • Toggle: Show/hide rental income fields
  • Default Value: Numeric (typically 0 for owner-occupied)
  • Use Case: Default for investment vs. owner-occupied properties

Board Income:

  • Toggle: Show/hide board income (non-taxable in NZ)
  • Default Value: Numeric
  • Use Case: Clients with boarders or flatmates

Interest-Only Period:

  • Toggle: Show/hide interest-only options
  • Default Value: Boolean
  • Use Case: Investment property strategy

Property Inflation Rate:

  • Toggle: Show/hide property growth rate field
  • Default Value: Percentage (e.g., 2-4%)
  • Use Case: Regional property growth assumptions

Misc Tab Defaults

Display Settings:

  • Show Savings: Display savings fund on Net Wealth chart
  • Show Investment: Display investments on chart
  • Show KiwiSaver: Display KiwiSaver on chart
  • Show Monte Carlo: Display simulation range
  • Show Annotations: Enable chart annotations
  • Default Values: Boolean for each display option

Simulation Parameters:

  • Number of Simulations: Default Monte Carlo scenarios (e.g., 100-1000)
  • Confidence Interval: Statistical confidence (e.g., 80%, 90%, 95%)
  • Inflation Rate: Global inflation assumption (e.g., 2.5%)
  • Use Case: Standard simulation settings for organization

Auto-Save:

  • Toggle: Enable/disable automatic scenario saving
  • Default Value: Boolean (typically false)
  • Use Case: Organizations with frequent scenario modifications

Custom Investment Funds

Creating a Custom Investment Fund

  1. Navigate to "Investment Funds" section
  2. Click "Add Fund" button
  3. New fund appears in edit mode
  4. Configure fund parameters
  5. Click checkmark to save or X to cancel

Investment Fund Parameters

Name:

  • Custom identifier for the fund (e.g., "Global Tech Portfolio", "NZ Conservative")
  • Must be unique within fund library
  • Appears in fund selection dropdowns throughout planner

Type:

  • Always "investment" for investment funds
  • Distinguishes from KiwiSaver funds in database

Return (%):

  • Expected average annual rate of return after fees
  • Real or nominal depending on inflation settings
  • Examples:
    • Conservative: 3.5-4.5%
    • Balanced: 5-6%
    • Growth: 6.5-7.5%
    • Aggressive: 7.5-9%

Std Dev (%):

  • Standard deviation representing volatility/risk
  • Used in Monte Carlo simulation to model return variability
  • Higher value = wider range of potential outcomes
  • Typical Values:
    • Conservative: 4-6%
    • Balanced: 8-10%
    • Growth: 10-12%
    • Aggressive: 12-15%

Income Portion (%):

  • Percentage of return considered taxable income (vs. capital gains)
  • Critical for accurate tax calculations
  • Guidelines:
    • 90%: Mostly bonds and cash (Conservative)
    • 60%: Mixed allocation (Balanced)
    • 40%: Equity-heavy (Growth)
    • 20%: Very equity-heavy (Aggressive)

Fees (%):

  • Annual management fees as percentage of assets
  • Can be simple flat fee or tiered structure
  • Flat Fee Example: 0.85% on entire balance
  • Tiered Fee Structure: See Advanced Fee Structures section

Advice Fees (%):

  • Adviser fees charged to client
  • Separate from management fees
  • Can be flat or tiered
  • Use Case: Transparent fee disclosure to clients

Color:

  • Custom color for visual identification in charts
  • Helps distinguish funds in multi-fund portfolios
  • Click color picker to select custom color

Fund Categories

While not required, funds typically fall into these categories:

  • Cash: Minimal risk, minimal return (1-2%)
  • Conservative: Low risk, low return (3.5-4.5%)
  • Moderate: Below-average risk (4.5-5.5%)
  • Balanced: Average risk/return (5.5-6.5%)
  • Growth: Above-average risk (6.5-7.5%)
  • Aggressive: High risk, high return (7.5%+)

How Custom Investment Funds Are Used

Investment Modal:

  • Appears in "Fund Type" dropdown when configuring investment periods
  • Each investment fund can have multiple periods with different fund selections
  • Allows lifecycle investing (aggressive → balanced → conservative)

Scenario Creation:

  • Default fund pre-selected based on configured defaults
  • Reduces setup time for new scenarios
  • Ensures consistent methodology across organization

Example Investment Fund Configuration:

Name: "NZ Growth Equities"
Type: Investment
Return: 7.2%
Std Dev: 11.5%
Income Portion: 35%
Fees: 0.75%
Advice Fee: 0.50%
Color: #66B2FF
Use Case: NZ-focused growth portfolio for 30-50 age range

Custom KiwiSaver Funds

Creating a Custom KiwiSaver Fund

  1. Navigate to "KiwiSaver Funds" section
  2. Click "Add Fund" button
  3. Configure fund parameters (same as investment funds)
  4. Type is automatically set to "kiwisaver"
  5. Save changes

KiwiSaver-Specific Considerations

PIE Taxation:

  • All KiwiSaver returns taxed at PIE rates (10.5%, 17.5%, 28%)
  • Maximum 28% tax rate regardless of income
  • Income Portion determines what percentage of return is taxable
  • Calculate PIE tax: Taxable Return × PIE Rate

Contribution Tracking:

  • Funds track employee and employer contributions separately
  • ESCT tax calculated on employer contributions
  • Returns calculated on combined balance

Consolidation:

  • KiwiSaver funds can consolidate into investment funds at specified age
  • Typically age 65 (NZ Superannuation eligibility)
  • Entire balance transferred to investment funds per allocation percentages

Example KiwiSaver Fund Configuration:**

Name: "Conservative KiwiSaver"
Type: KiwiSaver
Return: 4.0%
Std Dev: 5.0%
Income Portion: 85%
Fees: 0.65%
Advice Fee: 0.25%
Color: #E5F5E0
Use Case: Near-retirement KiwiSaver members (ages 60-65)

Market KiwiSaver Funds (MorningStar Integration)

Overview

The system integrates with a MorningStar database containing historical performance data for real NZ KiwiSaver funds from major providers.

KiwiSaver Data Disclaimer

Before accessing market fund data, organization owners must accept the MorningStar data disclaimer:

Disclaimer Requirements:

  • Only organization owners can accept
  • Acceptance is permanent for organization (cannot be revoked without database access)
  • Tracks acceptance timestamp and user ID
  • Required before starring or using market funds

Disclaimer Process:

  1. Organization owner clicks "Accept KiwiSaver Data Disclaimer"
  2. Disclaimer modal displays terms and conditions
  3. Owner accepts disclaimer
  4. Must click "Save Settings" to persist acceptance
  5. Market fund data becomes available

Disclaimer Content:

  • Data sourced from MorningStar database
  • Historical performance not indicative of future results
  • Adviser responsibility to verify fund suitability
  • No guarantee of accuracy or completeness
  • Liability limitations

Time Period Selection

Market funds can display returns for different historical periods:

Available Periods:

  • 1 Year: Recent short-term performance
  • 3 Years: Medium-term trend
  • 5 Years: Standard for long-term planning (default)
  • 10 Years: Long-term historical average

Period Selector:

  • Dropdown at top of Market Funds section
  • Changing period updates all fund return values
  • Funds without data for selected period show fallback data with warning

Data Availability:

  • Not all funds have data for all periods (especially 10-year)
  • System falls back to longest available period with notation
  • Warning icon displayed for funds with missing data
  • Tooltip explains data limitation

Market Fund Structure

Each market fund contains:

Provider Information:

  • Provider: Fund provider (e.g., "ANZ", "ASB", "Simplicity")
  • Fund Name: Full official fund name
  • Category: CASH, CONSERVATIVE, MODERATE, BALANCED, GROWTH, AGGRESSIVE

Performance Data:

  • Return: Historical average for selected time period
  • Fees: Current management fees from MorningStar data
  • Growth Assets %: Equity allocation percentage
  • Income Portion: Calculated as (100 - Growth Assets %)

Auto-Assigned Values:

  • Std Dev: Based on category (e.g., BALANCED = 8%, GROWTH = 10%)
  • Color: Category-based color coding
  • Advice Fee: Defaults to 0% (can be overridden with bulk setting)

Category Standard Deviations

CASH:         2.0%  (minimal volatility)
CONSERVATIVE: 4.0%  (low volatility)
MODERATE:     6.0%  (below-average volatility)
BALANCED:     8.0%  (average volatility)
GROWTH:       10.0% (above-average volatility)
AGGRESSIVE:   12.0% (high volatility)

Starring Market Funds

Organizations can "star" frequently-used market funds for quick access:

Starring Process:

  1. Browse market funds in Market Funds section
  2. Find desired fund
  3. Click star icon (⭐) to star/unstar
  4. Starred funds appear at top of fund lists
  5. Changes save immediately to database

Starred Fund Benefits:

  • Quick access to commonly-recommended funds
  • Appears in fund selection dropdowns
  • Reduced scrolling through 100+ market funds
  • Organization-specific curation

Permissions:

  • Only organization owners can star/unstar funds
  • Starred funds shared across all users in organization
  • Individual users cannot star funds (organization-wide setting)

Use Case Example:

Organization specializes in Simplicity and Milford funds:
- Star: Simplicity Conservative KiwiSaver
- Star: Simplicity Balanced KiwiSaver
- Star: Simplicity Growth KiwiSaver
- Star: Milford Active Growth Fund
- Star: Milford Conservative Fund

Result: These 5 funds appear at top of all KiwiSaver fund selectors

Market Fund Overrides

While market fund base data cannot be edited, organizations can override fee structures:

Bulk Advice Fee Setting:

  • Input field at top of Market Funds section
  • Enter advice fee percentage (e.g., 0.50%)
  • Click "Apply to All Market Funds"
  • Adds advice fee to all starred market funds
  • Does not affect management fees (from MorningStar data)

Individual Fund Overrides: Organizations can override for specific funds:

  • Advice fees
  • Tiered fee structures
  • Saved per fund in market_fund_overrides array

Advanced Fee Structures

Flat Fee Structure

Simple percentage fee applied to entire balance:

Fee: 0.85% per annum
Balance: $500,000
Annual Fee = $500,000 × 0.85% = $4,250

Tiered Fee Structure

Different fee rates for different balance tiers:

Example Tiered Structure:

Tier 1: 0-$100,000 @ 1.00%
Tier 2: $100,001-$500,000 @ 0.75%
Tier 3: $500,001+ @ 0.50%

Balance: $600,000
Calculation:
  Tier 1: $100,000 × 1.00% = $1,000
  Tier 2: $400,000 × 0.75% = $3,000
  Tier 3: $100,000 × 0.50% = $500
  Total Fee: $4,500

Configuring Tiered Fees:

  1. Edit fund
  2. Click "Enable Tiered Fees" checkbox
  3. Click "Add Tier" to add tier
  4. For each tier, enter:
    • From Amount: Starting balance for tier (e.g., $0)
    • To Amount: Ending balance for tier (e.g., $100,000)
    • Fee %: Percentage for this tier (e.g., 1.00%)
  5. Tiers must be sequential with no gaps
  6. Final tier can have unlimited upper bound (enter large number)

Tiered Advice Fees

Separate tiered structure for adviser fees:

  • Same configuration as tiered management fees
  • Calculated independently
  • Added to management fees for total cost

Example Combined Fees:

Management Fees (Tiered):
  $0-$250,000: 0.80%
  $250,001+: 0.60%

Advice Fees (Tiered):
  $0-$250,000: 0.50%
  $250,001+: 0.30%

Balance: $400,000
Management Fees:
  $250,000 × 0.80% = $2,000
  $150,000 × 0.60% = $900
  Subtotal: $2,900

Advice Fees:
  $250,000 × 0.50% = $1,250
  $150,000 × 0.30% = $450
  Subtotal: $1,700

Total Annual Fees: $4,600 (1.15% effective rate)

Fee Structure Best Practices

  • Transparency: Always show total fees to clients
  • Competitiveness: Compare to market averages
  • Value Tiers: Larger balances should have lower percentage fees
  • Simplicity: Don't over-complicate with too many tiers
  • Consistency: Use similar structures across fund types

Saving and Persistence

Save Button Behavior

Clicking "Save Settings" persists:

User-Specific Data (scenario_metrics table):

  • Toggle states for all categories
  • Default values for all categories
  • Personal workflow preferences

Organization-Wide Data (organization_funds table):

  • Custom investment funds library
  • Custom KiwiSaver funds library
  • Starred market funds
  • Market fund fee overrides
  • KiwiSaver data disclaimer acceptance

Save Process

  1. Click "Save Settings" button
  2. System shows "Saving..." spinner
  3. User data saved to scenario_metrics
  4. Organization data saved to organization_funds
  5. Success toast displayed
  6. Settings immediately available to all users in organization

Auto-Loading

Settings automatically load when:

  • User navigates to Scenario Metrics tab
  • User logs in
  • Page is refreshed
  • Scenario is created (loads defaults)

Conflict Resolution

If conflicts occur during save:

  • User-specific settings always win for that user
  • Organization settings require owner permission
  • Error toast shown if permission denied
  • No partial saves (all or nothing)

Using Custom and Market Funds in Scenarios

Investment Period Configuration

When configuring investment periods in Investment Modal:

Fund Type Dropdown Shows:

  1. Standard Categories: Conservative, Moderate, Balanced, Growth, Aggressive
  2. Custom Funds: All organization custom investment funds
  3. Custom (Manual): Enter all values manually

Selection Process:

  1. Choose fund from dropdown
  2. Return, Std Dev, Income Portion auto-populate
  3. Fees and Advice Fees auto-populate
  4. Can override auto-populated values if needed
  5. Values persist for that period

KiwiSaver Period Configuration

When configuring KiwiSaver periods in KiwiSaver Modal:

Fund Type Dropdown Shows:

  1. Standard Categories: Conservative, Moderate, Balanced, Growth, Aggressive
  2. Custom KiwiSaver Funds: Organization custom KiwiSaver funds
  3. Starred Market Funds: ⭐ Starred real KiwiSaver funds
  4. Custom (Manual): Enter all values manually

Market Fund Selection:

  • Starred funds appear with ⭐ icon
  • Hover shows provider and category
  • Return based on selected time period
  • Fees from MorningStar data + organization advice fees
  • Income Portion calculated from Growth Assets %

Multiple Period Strategy

Funds can be used in lifecycle strategies:

Example Ages 30-65:

Period 1 (Ages 30-45):
  Fund: "Custom Aggressive Growth"
  Return: 7.5%, Std Dev: 12%, Income Portion: 20%

Period 2 (Ages 45-55):
  Fund: "Custom Balanced Growth"
  Return: 6.0%, Std Dev: 8%, Income Portion: 60%

Period 3 (Ages 55-65):
  Fund: "⭐ Simplicity Conservative KiwiSaver"
  Return: 4.2%, Std Dev: 4%, Income Portion: 85%

Common Use Cases

Case 1: Boutique Advisory Firm Setup

Scenario: Small firm with specialized investment philosophy

Configuration:

  1. Create 5 custom investment funds matching firm's model portfolios:

    • "Firm Conservative 2024" (3.5% return, 5% std dev)
    • "Firm Moderate 2024" (4.8% return, 7% std dev)
    • "Firm Balanced 2024" (6.0% return, 9% std dev)
    • "Firm Growth 2024" (7.2% return: 11% std dev)
    • "Firm Aggressive 2024" (8.5% return, 14% std dev)
  2. Set default investment fund to "Firm Balanced 2024"

  3. Configure default inflation rate to 2.5%

  4. Set default simulations to 200, confidence to 90%

  5. Star 10 commonly-recommended KiwiSaver funds for clients

Result:

  • All new scenarios use firm's model portfolios
  • Consistent assumptions across all advisers
  • Quick fund selection from curated list
  • Brand consistency in client presentations

Case 2: Large Multi-Adviser Practice

Scenario: 15 advisers with varying methodologies

Configuration:

  1. Accept KiwiSaver data disclaimer (owner only)

  2. Star 20 most commonly recommended market funds

  3. Each adviser sets personal defaults:

    • Conservative adviser: defaults to conservative funds, 95% confidence
    • Moderate adviser: defaults to balanced funds, 90% confidence
    • Aggressive adviser: defaults to growth funds, 80% confidence
  4. Organization creates 3 tiered fee structures:

    • Standard Tier: 1.00% (0-$250k), 0.75% ($250k-$1M), 0.50% ($1M+)
    • Premium Tier: 0.75% (0-$500k), 0.50% ($500k+)
    • Ultra-High Net Worth: 0.50% flat
  5. Apply bulk 0.40% advice fee to all market funds

Result:

  • Advisers maintain individual preferences
  • Organization controls fund library and fees
  • Consistent fee structures across firm
  • Access to real market data for client discussions

Case 3: Automated Client Onboarding

Scenario: High-volume practice using automated scenario generation

Configuration:

  1. Set comprehensive defaults for all tabs:

    • Income: 3% inflation, include superannuation
    • Expenses: 2.5% inflation, two expense categories
    • Savings: $15,000 cash reserve, 15% savings rate
    • Investment: "Moderate" fund default, utilize excess cashflow
    • KiwiSaver: 4% employee, 3% employer, balanced fund
    • Property: 3.5% growth rate, enable rental income fields
  2. Enable most toggles for comprehensive planning

  3. Set simulations to 100 for fast processing

  4. Configure auto-save to false (manual saves for review)

Result:

  • New scenarios pre-populated with sensible defaults
  • Reduces data entry from 15 minutes to 2 minutes
  • Consistent base assumptions across 100s of clients
  • Advisers focus on customization rather than setup

Best Practices for Financial Advisers

Setting Realistic Default Returns

Conservative Approach:

  • Use historical averages minus 0.5-1% for conservatism
  • Account for fees when setting return expectations
  • Higher income portions for conservative funds (more bonds)

Examples:

Conservative Fund:
  Historical: 4.5% pre-fee
  After fees: 4.5% - 0.85% = 3.65%
  Conservative estimate: 3.5%
  Income Portion: 85% (mostly bonds)

Growth Fund:
  Historical: 7.5% pre-fee
  After fees: 7.5% - 1.00% = 6.5%
  Conservative estimate: 6.5%
  Income Portion: 30% (mostly equities)

Standard Deviation Guidelines

Match std dev to historical volatility:

  • Use 10-20 year historical standard deviation if available
  • Conservative estimate: Use higher std dev for uncertainty
  • Correlation: Higher return funds should have higher std dev

Toggle Strategy

Enable All by Default:

  • Gives advisers full flexibility
  • Individual advisers can override as needed
  • Comprehensive planning vs. simplified

Selective Enabling:

  • Disable rarely-used features (e.g., board income)
  • Streamlines interface for less experienced advisers
  • Reduces client confusion

Recommendation:

  • Enable all toggles initially
  • Disable based on actual usage patterns
  • Survey advisers for preferences

Fund Library Curation

Minimum Recommended Funds:

  • 5 custom investment funds (one per category)
  • 5 custom KiwiSaver funds (one per category)
  • 10-20 starred market funds

Naming Conventions:

  • Include year for annual review: "Balanced 2024"
  • Include provider for clarity: "Simplicity Growth"
  • Avoid ambiguous names: "Fund 1", "Portfolio A"

Annual Review:

  • Review fund returns and update assumptions
  • Archive old funds (rename with "Archived" prefix)
  • Create new fund versions for new year
  • Communicate changes to all advisers

Fee Transparency

Client-Facing Approach:

  • Always show total fees (management + advice)
  • Use tiered fees to reward larger balances
  • Document fee justification in notes
  • Compare to industry averages

Calculation Example for Client:

Your Investment: $500,000
Management Fee: 0.75% = $3,750/year
Advice Fee: 0.50% = $2,500/year
Total Fees: 1.25% = $6,250/year
Monthly Cost: $521

Comparison:
  Industry Average: 1.40% = $7,000/year
  Your Savings: $750/year

Troubleshooting

Problem: Changes Not Saving

Solution:

  • Check permissions (organization owner for funds)
  • Verify internet connection
  • Check browser console for errors
  • Try refreshing page and re-entering changes
  • Contact system administrator if persistent

Problem: Market Funds Not Appearing

Potential Causes:

  1. KiwiSaver data disclaimer not accepted
    • Solution: Organization owner must accept disclaimer
  2. No funds starred
    • Solution: Star at least one fund and save
  3. Time period has no data for fund
    • Solution: Change time period selector

Problem: Custom Fund Not Appearing in Scenarios

Solution:

  • Ensure fund was saved (click checkmark)
  • Refresh scenario page
  • Check fund type matches (investment vs. kiwisaver)
  • Verify not accidentally deleted

Problem: Fee Calculations Incorrect

Common Issues:

  1. Tiered fees with gaps
    • Solution: Ensure sequential tiers with no gaps
  2. Mixing flat and tiered fees
    • Solution: Choose one fee structure type
  3. Advice fees not included
    • Solution: Verify advice fee fields populated

Problem: Defaults Not Applying to New Scenarios

Solution:

  • Verify defaults saved (click "Save Settings")
  • Check user ID matches (logged in as correct user)
  • Clear browser cache and reload
  • Check database for saved values

Migration and Data Management

Updating Existing Funds

When updating fund parameters:

  1. Edit fund values in Scenario Metrics
  2. Save changes
  3. Existing scenarios keep old values (not retroactive)
  4. New scenarios and new periods use updated values

Archiving Old Funds

To archive without deleting:

  1. Edit fund name: prefix with "ARCHIVED -"
  2. Fund remains in database
  3. Scenarios using it remain functional
  4. Not offered for new scenarios (alphabetically sorted last)

Exporting Fund Library

Currently no export feature, but data accessible via:

  • Direct database query
  • API endpoint (if implemented)
  • Contact system administrator

Importing Fund Library

For bulk import or migration:

  • Prepare CSV with fund parameters
  • Contact system administrator for bulk import
  • Requires database access

Advanced Configuration

Custom Economic Scenarios

Create multiple fund sets for different economic outlooks:

Scenario 1: Base Case (2.5% inflation)

Fund Library Prefix: "Base -"
Balanced Fund: 6.0% return

Scenario 2: High Inflation (4% inflation)

Fund Library Prefix: "High Inflation -"
Balanced Fund: 8.0% nominal return (4% real)

Scenario 3: Low Growth (1% inflation)

Fund Library Prefix: "Low Growth -"
Balanced Fund: 4.0% nominal return (3% real)

Multi-Currency Support

For international clients:

  • Create separate fund sets per currency
  • Prefix with currency: "USD - Balanced"
  • Use appropriate inflation rates per country
  • Note: System primarily designed for NZD

Fee Modeling for Different Client Tiers

Create fund variations for fee structures:

Retail Clients:

Fund: "Balanced - Retail"
Management Fee: 1.20%
Advice Fee: 0.75%
Total: 1.95%

High Net Worth:

Fund: "Balanced - HNW"
Management Fee: 0.80%
Advice Fee: 0.50%
Total: 1.30%

Ultra-HNW:

Fund: "Balanced - UHNW"
Management Fee: 0.50%
Advice Fee: 0.25%
Total: 0.75%