Fill This Out
| IPS New Customer Data Sheet | | | | | | | | | | | | | |
|---|
| | | | | | | | | | | | | |
| Name | | Name | | | | | | | | | | | |
| Birthdate | | Birthdate | | | | | | | | | | | |
| Account Inception Date: | | Original Investment: | $100,000.00 | | | | | | | | | | |
| | | | | | | | | | | | | |
| Account Type (TQ or Non) | | Account # | | | | | | | | | | | |
| Bank Instructions | | | | | | | | | | | | | |
| PIP/Systematic? | | | | | | | | | | | | | |
| Reinvest Dividends, Cash Growth? | | | | | | | | | | | | | |
| Tax Withholding? | | | | | Next Meeting with Customer | | | | | Following meetings | | | |
| Auto RMD? | | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| Meeting Date: | 2024-06-10 00:00:00 | | | | Meeting Date: | | Current Value | $0.00 | | Meeting Date: | | Current Value | $0.00 |
| Dollar Cost Average? | No | Current Value | $100,000.00 | | Additions: | | Withdrawals: | | | Additions: | | Withdrawals: | |
| Taxable Cost Basis: | | | | | Sum of Actual Dollars: | $100,000.00 | Gain or Loss | $-100,000.00 | | Sum of Actual Dollars: | $100,000.00 | Gain or Loss | $-100,000.00 |
| | | | | Taxable Cost Basis: | | | | | Taxable Cost Basis: | | | |
| Initial Fund Allocation | | | | | | | | | | | | | |
| Fund Ticker | % Allocation | $ Amount | | | Current Fund Values | Should Be | Changes Needed | | | Current Fund Values | Should Be | Changes Needed | |
| BTMPX | 20.0% | $20,000.00 | | | | $0.00 | $0.00 | | | | $0.00 | $0.00 | |
| BDBPX | 20.0% | $20,000.00 | | | | $0.00 | $0.00 | | | | $0.00 | $0.00 | |
| BSPPX | 60.0% | $60,000.00 | | | | $0.00 | $0.00 | | | | $0.00 | $0.00 | |
| | $0.00 | | | | $0.00 | $0.00 | | | | $0.00 | $0.00 | |
| | $0.00 | | | | $0.00 | $0.00 | | | | $0.00 | $0.00 | |
| | $0.00 | | | | $0.00 | $0.00 | | | | $0.00 | $0.00 | |
| Totals | 100.0% | $100,000.00 | | | $0.00 | $0.00 | | | | $0.00 | $0.00 | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
Dave's Original
| IPS New Customer Data Sheet | | | | | | | Dates of Customer meetings - Additions/Withdrawals/Rebalancing | | | | | | | | |
|---|
| | | | | | | Enter current value plus/minus and additions/withdrawals | | | | | | | | |
| Name | | | Account Inception Date | 2024-04-11 00:00:00 | | 2025-04-11 00:00:00 | | | | | | | | | |
| Birthdate | | | | | | | | | | | | | | | |
| | | Original Investment | $147,000.00 | | Current Value | $168,500.00 | | | | | | | | |
| Name | | | Dollar Cost Average? | NO | | | | | | | | | | | |
| Birthdate | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | |
| Account Type (TQ or Non) | | | Additions | | | Additions | $12,000.00 | | | | | | | | |
| Account # | | | Withdrawals | | | | | | | | | | | | |
| | | Sum of Actual Dollars | | | Sum Invested | $159,000.00 | | | | | | | | |
| | | Taxable Cost Basis | | | Taxable Cost Basis | $163,212.00 | | | | | | | | |
| | | | | | | | | | | | | | | |
| | | Current Value | | | | | | | | | | | | |
| Bank Instructions | | | | | | | | | | | | | | | |
| | | Performance by Year | | | | | | | | | | | | |
| PIP/systematic | | | | | | | | | | | | | | | |
| WDs/Contributions | | | | | | | | | | | | | | | |
| | | Funds and % | | | Current | Should be | Changes Needed | | | | | | | |
| Divident/CG reinvest | | | MDBAX | 25.0% | $36,750.00 | $63,250.00 | $42,125.00 | $-21,125.00 | | | | | | | |
| Tax Withholding? | | | MDDVX | 25.0% | $36,750.00 | $50,000.00 | $42,125.00 | $-7,875.00 | | | | | | | |
| Auto RMD? | | | MDRFX | 35.0% | $51,450.00 | $40,250.00 | $58,975.00 | $18,725.00 | | | | | | | |
| | | BABDX | 15.0% | $22,050.00 | $15,000.00 | $25,275.00 | $10,275.00 | | | | | | | |
| | | | | | | | | | | | | | | |
| | | Totals | | $147,000.00 | $168,500.00 | $168,500.00 | | | | | | | | |
Lori's Copy
| IPS New Customer Data Sheet | | | Are the fields below color coded correctly? | yes | Manual | | Dates of Customer meetings - Additions/Withdrawals/Rebalancing | | | | | | | | |
|---|
| | | | | Locked | | Enter current value plus/minus and additions/withdrawals | | | | | | | | |
| Name | Lori Ivey | | Account Inception Date | 2024-03-31 00:00:00 | | Meeting Date: | | | Meeting Date: | | | | | | |
| Birthdate | | | | | | | | | | | | | | | |
| | | Original Investment | $107,685.00 | | Current Value | $168,500.00 | | Current Value | $188,000.00 | | | | | |
| Name | | | Dollar Cost Average? | Yes/No Field? | Yes - over what period of time? | | | | | | | | | | |
| Birthdate | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | |
| Account Type (TQ or Non) | Traditional IRA | | Additions | Is this freeform instructions and a manual field (like you would update the planned additions) | Yes | Additions | $12,000.00 | | Additions | $12,000.00 | | | | | |
| Account # | FA1140500 | | Withdrawals | | | | | | | | | | | | |
| | | Sum of Actual Dollars | Is this the sum of original investment + addtions - withdrawals? | Yes | Sum Invested | $119,685.00 | | Sum Invested | $180,500.00 | | | | | |
| | This section for annual appt revew | Taxable Cost Basis | This is a manual entry correct? If so, do you know where to find this number on their account? | Not on IPRO yet, but it will be available soon | Taxable Cost Basis | $107,685.00 | | Taxable Cost Basis | $163,212.00 | | | | | |
| | | | | | | | | | | | | | | |
| | | Current Value | What is this for? | Sum of adding Fund positions below | | | | | | | | | | |
| Bank Instructions | How will you use this info? | Just so I don't have to look it up in system | | | | | | | | | | | | | |
| | | Performance by Year | What is this for? | Annual rate of return | | | | | | | | | | |
| PIP/systematic | What does this mean? | Is customer contributin/withdrawing | | | | | | | | | | | | | |
| WDs/Contributions | Is this a freeform field of instructions for your reference (example: will contribute $500/month) | systematically. If so, how much? | | | | | | | | | | | | | |
| | | Funds and % | | | Current | Should be | Changes Needed | Current | Should be | Changes Needed | | | | |
| Divident/CG reinvest | Is this a Yes/No field? | Yes - there are 2 parts | AMRMX | 25.0% | $26,921.25 | $63,250.00 | $42,125.00 | $-21,125.00 | $63,250.00 | $7,919,500,000.00 | $7,919,436,750.00 | | | | |
| Tax Withholding? | Yes/No Field? | Yes - but what % would be nice to know if yes | AIVSX | 50.0% | $53,842.50 | $50,000.00 | $84,250.00 | $34,250.00 | $50,000.00 | $15,839,000,000.00 | $15,838,950,000.00 | | | | |
| Auto RMD? | Yes/No Field? | Yes, on what date would be great | CWGIX | 25.0% | $26,921.25 | $40,250.00 | $42,125.00 | $1,875.00 | $40,250.00 | $7,919,500,000.00 | $7,919,459,750.00 | | | | |
| | | Cash | 0.0% | $0.00 | $15,000.00 | $0.00 | $-15,000.00 | $15,000.00 | $0.00 | $-15,000.00 | | | | |
| | | | | | | | | | | | | | | |
| | | Totals | | $107,685.00 | $168,500.00 | $168,500.00 | | $168,500.00 | $31,678,000,000.00 | | | | | |