The Money Mustache Community

Learning, Sharing, and Teaching => Ask a Mustachian => Topic started by: themagicman on April 22, 2017, 06:30:58 AM

Title: Need feature ideas/feedback. Building a financial spreadsheet template
Post by: themagicman on April 22, 2017, 06:30:58 AM
As a side project, I am going to be building a financial spreadsheet template. My goal would be to make this spreadsheet customizable to an individuals situation and should be easy to use. I was hoping that some people in the community would help me with some features that they would like to see in a spreadsheet. What is mint/personal capital/your own spreadsheet/YNAB not providing you that you wish was a feature?

The more I learn about excel to more I realized that anything is possible in it so please do not think there are any impossible/stupid suggestions!

Also, I would love to post the template throughout the development here for further tips about format/layout/features as I start to create it.

Any suggestions are helpful! Thanks!



Some things I was already planning on including:

Imputing one transaction updates everywhere (Monthly/yearly spending track, NW, Account Balance)
Import transactions from Mint/Personal Cap
All customizable
Tons of graphs/charts projects
FIRE Date tracker
Tax tracker/projector
Reconciliation portion to make sure you are in balance with your accounts
Month over month/year over year reports
Title: Re: Need feature ideas/feedback. Building a financial spreadsheet template
Post by: themagicman on April 22, 2017, 06:12:14 PM
Also, would you all rather see it in Excel of in Google sheets? I would be able to do more in Excel but sheets would be more accessible. Thanks!
Title: Re: Need feature ideas/feedback. Building a financial spreadsheet template
Post by: Grogounet on April 23, 2017, 04:22:02 AM
Have a look at madfientist calculator, "flexible retirment planner" and the ultimate retirement calc from Todd Tresider. I believe a combination of the 3 is what would solve all issues :-)
Title: Re: Need feature ideas/feedback. Building a financial spreadsheet template
Post by: themagicman on April 23, 2017, 02:11:51 PM
Have a look at madfientist calculator, "flexible retirment planner" and the ultimate retirement calc from Todd Tresider. I believe a combination of the 3 is what would solve all issues :-)

Thank you! I will check both of those out and try to incorporate something similar!
Title: Re: Need feature ideas/feedback. Building a financial spreadsheet template
Post by: CowboyAndIndian on April 23, 2017, 04:20:09 PM
Have you seen the "One Sheet to rule them all"??

https://forum.mrmoneymustache.com/share-your-badassity/one-sheet-to-rule-them-all/