All Collections
Inflation in Timeline Planning
Explaining the Tools in Timeline Planning
Unlock Transparency: Understanding Timeline Calculations with the CSV Feature
Unlock Transparency: Understanding Timeline Calculations with the CSV Feature

Everything you need to know about the CSV feature in Timeline Planning

Gonzalo Podgaezky Folguera avatar
Written by Gonzalo Podgaezky Folguera
Updated over a week ago

Summary

  • The CSV Export feature allows financial advisors to export detailed calculations used in the cashflow modeler and tax breakdown section.

  • This feature improves transparency, providing a deeper understanding of the underlying calculations in Timeline Planning.

  • This CSV file can be used in different client scenarios, such as:

    • Discussing investment outcomes, including end-of-year balance, total return, fee rate, contributions, and withdrawals.

    • Reviewing tax implications, including cumulative taxes, tax rates, and allowances.

  • This tool enables more comprehensive and informed financial discussions between advisors and clients.

Description

The key to effective financial planning is not just in crafting the perfect plan but also in communicating that plan effectively to your clients. The CSV export feature has been designed with this philosophy in mind.

This feature lets you take a closer look at the calculations used in the cashflow modeler and tax breakdown section and presents them to you in a CSV format. This format enables you to navigate the data more effectively.

Click here for more information on how to deal with CSV in Excel.

You can find the following information for each year in the median scenario in Nominal terms:

  • Account balance

  • Balance growth

  • Withdrawals gross

  • Taxable withdrawal

  • Income amount (gross)

  • Taxable amount

  • Inflation

  • LTA available

  • LTA taxes

  • Income tax brackets

Where to find it;

You can find it in the Cashflow chart by clicking on the 'Median Summary CSV.'


Now let's delve deeper into how you can use this feature in different scenarios:

Scenario 1: Discussing Investment Outcomes
Imagine having a client who wants a deeper understanding of their investment outcomes, trying to understand the performance of each investment account, including end-of-year balance, total return, fee rate, contributions, and withdrawals. With the CSV export feature, you can easily provide this data to form the basis for a comprehensive discussion about their investment strategies.

Scenario 2: Reviewing Tax Implications
In another instance, let's say your client is interested in the tax implications of their financial plan. This could include cumulative taxes, tax rates, and allowances. The CSV export feature gives you the power to export these calculations, making it easier to explain these crucial elements to your clients clearly and straightforwardly.

Conclusion

In conclusion, the CSV export feature in Timeline Planning is an excellent tool that fosters transparency in your client discussions and strengthens the trust your clients place in you. As you use this feature, you can make complex financial concepts easier for your clients to understand and help them make more informed decisions.

Did this answer your question?