Master Goal Tracking Report Tips
Having all of your clients’ goals on one spreadsheet is a powerful tool that allows your team to focus upon all the upcoming client goals in chronological sequence.
Establishing a simple tool for your entire Deliverables Team to be alert to upcoming goal dates across your entire community of clients.
Imagine having 100 Ideal Clients, each with a Financial Road Map® containing an average of four goals, with each Road Map being updated three times per year. Obviously that works out to 400 client goals, requiring your Deliverables Team to survey 100 Financial Road Maps® , a cumbersome task.
Creating a Master Goal Tracking spreadsheet is a centralized and simplified method of tracking each client's Financial Road Map.
The key pieces of information (columns) to be tracked on a Master Goal Tracking spreadsheet are:
- Client name
- Name of goal
- Amount of goal
- Dollar amount (assume current dollars unless otherwise noted)
- Frequency (example $9,000 per month, $14,000 per year, or $184,000 once)
- Date of goal
- Month
- Day
- Year
This tool will be routinely utilized by your Deliverables Team Members for a variety of purposes; here are the top three:
- Checklist to ensure clients have clear funding instructions for those goals about to occur
- Ensure no goals pass without acknowledgment to the client
- Ensure no goals have been overlooked
TIP: Print out this updated report for every Deliverables Team Member at each Deliverables Team Round-Table to keep everyone "on the same page."
Master Goal Tracking Management
This report should be updated often at any reasonable frequency (usually monthly) and may be assigned to any of a number of Deliverables Team Members:
- Financial Planning Subject Matter Expert
- Administrative Manager
- Tax Subject Matter Expert
TIP: Tax Subject Matter Expert is less often assigned, but since many goal dates trigger taxable events, we have seen this work well)
A simple spreadsheet detailing all the goals from every client's Financial Road Map® allows for more heightened awareness, can support a documented process to contact clients before every goal date, and alerts Deliverables Team Members to the need for more detailed planning well in advance of the goal date. This report is a focusing tool for Deliverables Team Members to provide more thorough, assiduous, and timely planning for each goal.
Login to Module 8 to download the Master Goal Tracking Report Template.




