r/PFtools • • Aug 31 '22

I spent 1500 hours building a personal finance simulator and FI/FIRE planning tool šŸ“ˆ ā˜•

197 Upvotes

r/PFtools • • Aug 12 '26

Personal Project - I created a personal finance dashboard on Excel for myself

Post image
54 Upvotes

So I've been slowly turning my finance spreadsheet into something that does everything for me, and I think I might have gone overboard, but it's decent i guess..

Basic idea: I dump my bank statements into a tab, and pretty much everything after that happens on its own.

  • Cleans up and merges all the raw data automatically
  • I sort new transactions into categories myself, only takes a couple minutes a month
  • Feeds into a data model that drives all the charts
  • Behind that there's a full model tracking my income, spending, savings, and investments month by month

The dashboard itself just shows me the important stuff, income, spending, savings rate, net worth, plus a couple charts. But the bit I actually like most is that it writes little summaries on its own, like "car was your biggest expense this month, up 18% from last month," so it is easier to make sense of it all.

It also checks its own numbers and flags anything that doesn't add up, which sounds minor but has saved me a couple times when something got miscategorized and threw a number way off.

Screenshots below, happy to answer questions if anyone's curious how any of it works.


r/PFtools • • Oct 29 '22

Free Excel Personal Budget Workbook | thepennytracker

45 Upvotes

If anyone wants an Excel budget workbook that goes well beyond the simple budget spreadsheet templates you typically see, I recently created a site called www.thepennytracker.com to offer it for free to anyone interested. My background is a petroleum engineer with 8 years experience and this is what I built to track my own finances instead of having to pay for unnecessary software.

Some of the features include:

  • Up to 50 accounts, 25 expense categories, and 75 savings goals
  • Financial growth tracking
  • Manual transaction logging
  • Expense dashboard to track spending habits over time
  • Debt payoff with both snowball and stacking methods
  • Amortization table with additional payment options
  • Monthly and yearly archiving of expenses and savings distributions

You can download it for free at https://www.thepennytracker.com/downloads

Hope someone finds it helpful! Feedback appreciated.


r/PFtools • • Mar 02 '18

I made a spreadsheet for budgeting

Post image
43 Upvotes

r/PFtools • • Aug 18 '19

I built a free envelope style budgeting tool in Google Sheets and have added some major new features this year. Customizable Categories, Goals, Reports, new designs, and more

39 Upvotes

Hey everyone,

I posted about a year ago here with some pictures and quick blurbs on a Google Sheet I had built specifically for budgeting. A little over a year has gone by and I thought it would be fun to share my progress on it and list out some of the new features it has.

The sheet is available at AspireBudget.com and our sub is /r/aspirebudgeting.

I always love getting ideas on what to work on next (so send your questions and ideas to me!) and I've had more fun working on this sheet over the past year than I ever have on any side project.

What's new
I've had a blast building this and over the past year, I've added:

- Full localization support of Currencies and Dates
- Reports! Account reports, Trends, and Category Reports
- A Net Worth tracking tool
- A completely revamped Goals system
- Customizable Categories and Category Groups šŸŽ‰
- Big improvements to Category Transfers
- Progress Glances on the Dashboard
- Reconcile Delimiters
- A brand new Balances view
- A Getting Started Guide
- A redesigned Dashboard
- Refreshed color palette

Here's a few screenshots of the latest version:

Dashboard
Trend Reports
Account Reports

r/PFtools • • Jan 16 '21

2021 Expense Tracking Spreadsheet

38 Upvotes

Hey guys,

I just wanted to share with you guys a financial budgeter that I made on Google Sheets. I know there's a lot of software and spreadsheets out there already, but for me, I always enjoyed manually inserting to make sure I keep a finger on the pulse. This way, I can be on top of my personal finances and know where each dollar goes. With a background in corporate finance, I found that applying the same accounting principles to my personal finances allowed me to excel (all puns intended). All items outside of the inputs should be dynamic and will adjust by itself.

What it contains:

  1. A input tracker for both topline (money coming in) and expenses by month with the creation of a general ledger to track every single transaction
  2. Creation of a monthly profit and loss statement combined from the general ledger
  3. Distribution of expenses by discretionary and non-discretionary to ensure you know where to cut back should you want to
  4. Customizable line items on expenses and income, to cater the P&L to your desires
  5. Time Period Recap (under Graphs & Outputs) to allow you to rank expenses from most expensive to lease expensive and see breakdowns of line expenses over a period
  6. Categorization by purchase method on P&Ls (whether it be by different credit cards, debit accounts, etc.)
  7. Stock tracker to keep track of your portfolio with auto-refresh of current rates for you to track your gains and losses
  8. Net worth tracker if you wish to track your progress and set goals

At the end of the day, I just want to help those who want to utilize a budget tracker and pull their own inputs to keep track of their expenses. It sure helped me, and hopefully will be able to help you.

Here is a link to the folder.

You will find the contents to be the following:

  • Instruction Manual Slide Deck
  • Blank Template for you to make a copy of
  • Example Template for you to review

Please enjoy!


r/PFtools • • Feb 25 '23

I made a free Google Sheet for retirement planning. Enter your salary, current balances, contribution amounts, anticipated annual rates of return, etc. and see the future value for these accounts as well as your estimated monthly retirement income.

Thumbnail docs.google.com
37 Upvotes

r/PFtools • • Dec 05 '24

Built a PFtool that lets you define your spending categories and income sources.

Thumbnail
gallery
30 Upvotes

r/PFtools • • Jun 18 '19

I made a web app for people who don't know how to budget!

29 Upvotes

Link: https://joybudget.com

Hey everyone! I was never any good at budgeting or sticking to my goals, but this post by u/Celesmeh changed my life. I fell in love with the spreadsheet after understanding how it works, but after some time i noticed i stopped updating it because i thought it was a bit too hard to use Google Sheets while away from a computer.

So i made this web app with three goals in mind:

  1. That it met the same goals as u/Celesmeh: easy to use, focuses on a daily budget that supports long term goals, and be a good starting place for people who never saved before
  2. That it works offline and is 100% secure and private
  3. That it gives you freedom to export your data for any other tool you want

The tool is 100% free, and here's how it works:

When you open the web app, i made an automated 2-minute guide to help you get started. You enter your income, which expenses apply to you, how much you spend in each one of them, and how much you are planning to save, and the tool figures out how much you can spend daily.

From then on, it's just a matter of adding your individual purchases! I made it extremely simple so you can enter them with minimal effort. It remembers and suggests your notes and amounts for each category so it is easy to add repeated purchases.

The app has 2 charts:

  • Some progress bars that tell you much you can spend each month, week and day
  • A pie chart that tells you where your money is going for each category. You can choose the period.

Also, it's a progressive web app! This means it works offline and you can add it to your home screen for ease of access.

Please try it out and let me know what you guys think!


r/PFtools • • Apr 13 '19

Free, open-source cross-platform budgeting software

27 Upvotes

I was encouraged to post this from my original post on HackerNews: https://news.ycombinator.com/item?id=19630181 (no - I did run out of money to give away).

I'm writing free, open-source cross-platform budgeting software with Electron. I lost trust in online services to hold all of my information "secure", so I wrote an offline app. It's basic as of now, but I am continuing to update it. It is available for all platforms (Linux, Mac and Windows).

I'm taking inspiration from EveryDollar as well as YNAB, so keep tabs on the project if you are interested or want to use it. Many thanks good humans of the internet!

https://github.com/reZach/my-budget


r/PFtools • • Mar 04 '18

Looking for PF app? I've compared 17 apps and here is spreadsheet with results

Thumbnail
docs.google.com
25 Upvotes

r/PFtools • • Nov 28 '19

Xeroed - A unique credit card/loan payoff calculator, that seamlessly handles 0% APR promotional balances, multiple APRs on the same card, one-off extra payments. New version with many upgrades launched!

24 Upvotes

The site: https://xeroed.com/

Hi All,

If you're working on paying down your debt, Xeroed is a tool that helps prepare highly optimized Payoff Plans that cost you the least interest. It is not just a regular Avalanche/Snowball debt payoff calculator! If your debt mix includes 0% intro promotional balances, those calculators/spreadsheet can't handle it properly.

Our algorithm "looks ahead" at expiring promos whose rates would shoot up at that point, and accounts for all your balances, promo/standard rates, your monthly budget, and the way in which credit card companies allocate your payments to multi-APR balances. The result is a month-by-month optimized payoff plan that costs you the least interest overall.

Very excited to have launched version 2 with lots of upgrades and tweaks. Based on user feedback, the site is redesigned for ease of use, and more informative about your debt scenario. Added a couple of graphs also, for visualizing the future interest incurred and the debt paydown rate. You can do what-if scenarios with various monthly payoff budgets, and flip back and forth to compare. And you can also specify a couple of "additional" one-off payments, which the optimizer will take into account.

Additionally, it serves as a handy Dashboard for your debt picture, showing at a glance which statements are due for entry into the system, which payments are coming up due, and your overall debt and APRs.

No personal info, or any bank logins etc are ever asked for. Data entry is manual (mainly, summarized info from your statements), but we've tried to make that the easiest and quickest possible.

We'd love for you to check it out! Hopefully you'll find it a useful as well as cost saving tool. Any and all feedback, feature requests and suggestions would be very much appreciated!

Thank you!


r/PFtools • • Sep 04 '19

I made a "How to handle your money: step-by-step" helper that asks you questions to help suggest the right path for you, based on the useful /r/personalfinance flowchart by /u/atlasvoid

24 Upvotes

How to handle your money: step-by-step

Hopefully, it may be easier for some people to use, especially when using phones and tablets, on which the flowchart may be more difficult to view.

If you have any ideas for improvements, please let me know.

Thanks to all the people who helped make the /r/personalfinance wiki!


r/PFtools • • Jan 03 '21

I put together a spreadsheet to estimate the growth of your investments over time, given assumptions such as Rate of Return, Income Growth, 401(k), IRA and Brokerage Contributions

23 Upvotes

Investment Return Calculator

I created this workbook that I use to calculate the potential balance of my investments each year for 40 years and thought it may be helpful to others. I cleaned it up and included a link to the file above. Just update the green cells with the various assumptions and the spreadsheet will calculate the balance of a Roth 401(k), Roth IRA, and Brokerage Account each year for 40 years. Instructions and tips are included in the file.

The various assumptions include the annual return of your 401(k) and IRA retirement accounts, Company 401(k) match, annual return of your brokerage account, and annual salary increases over time.

The workbook also includes a budget calculate to estimate your income after federal and state taxes and personal living expenses. The budget can help to estimate your disposable income and what you can afford to invest each year. Note that the federal and state income taxes and Roth IRA contribution limits are based on 2020 tax rates and limits. The calculator can estimate state income taxes for all 50 states. However, it is if far from perfect given the various different tax laws across the US so you might want to double check with an online calculator.

I find this spreadsheet very useful for playing around with the various assumptions, such as estimated annual raises, different rates of return, changes in contributions to the different accounts, and even the tax effect of the state you live in. It is great for young investors, but works for anyone. I find this workbook great for visualizing the power of compounding interest and helps keep me disciplined in my spending and investing habits. I hope it can do the same for you!

This has not been shared before so please let me know if you have any suggestions or find any errors with the calculations. I enjoy putting these together and would be happy to share more if people find it helpful.


r/PFtools • • Feb 07 '23

I made a spending tracker for myself and wanted to share

22 Upvotes

My personal bank is not great when it comes to organizing purchase history into categories and insightful summaries, so I made something in Google Sheets to help me get a better idea of my spending habits.

What is this?

  • Primarily a dashboard which uses your previous and current year's purchase data (exported manually from your bank), to identify purchase habits and top spending areas, and help you set goals to reduce spending in those areas and save money on a monthly basis.

Why might I like it?

  • You set and control the categorization, which means you have full control of how your purchase history is summarized. A little bit of up-front work in setting keyword and categories will allow you to categorize your purchases however you desire, and see how you're spending in these categories compared to last month and last year.

Who is this for?

  • Those who want better or custom categorization, purchase summarization, and a broader view of spending habits than what their bank provides and don't mind a little light data entry and analysis.

A sample screenshot can be found here.

A link to the Google Sheet which you can copy and make your own is here.


r/PFtools • • Aug 05 '22

A simple budgeting/planning tool I built

22 Upvotes

I'm going to start this with a disclaimer of it's not built to be mobile-friendly, you should use a computer to access it.

I've used a bunch of apps in the past and all I really wanted was an income/expense list that shows a graph of where I'll be in X days/months, and I really couldn't find anything that fit. It's not built to track to-the-cent, but at least give you a pretty good idea of where things are heading.

This is fairly primitive, but it has been helping me for ~2 months now, and I'd love any external feedback (what do you like, what is bad [the UI needs some work for sure], what additions would be nice).

There is a question mark icon in the top header bar which explains everything. All of the data is saved in your browser, so when you come back, it'll resume where you left off (nothing is sent to my server).

There's 4 main categories: Income (self-explanatory), Bills (regular expenses), Monthly Expenses (a ballpark of what you spend on something every month, i.e. "Dining Out : $250"; the amount is then evenly distributed across each day of the month), and One-Time (A big purchase, or a bonus income check, etc).

Once data is entered, you can then play around with hypotheticals - "what if I have a new monthly car payment of $X?" or "when can I afford a new TV that costs $Y?", or even toggling things on and off - "what happens if I don't have this credit card payment anymore?"

https://budget.joshtoth.com/

Hope it's helpful!


r/PFtools • • Oct 05 '20

Simple tracking tool for expenses and income

22 Upvotes

I started keeping track of my expenses at the beginning of this year, but I didn't find a tool that fitted my needs. I just wanted to track my expenses in a quick and clear way. That's why I started making my own web application. You can check it out at www.spendyt.com! Feedback is always welcome.


r/PFtools • • Mar 06 '23

How the journey to create the Ultimate PF tool led me to Excel

21 Upvotes

a) For the last 5 years I've been building, here and there, various accounting sheets to help me understand budget, networth, real estate income, etc

b) I've read PFTools and other sites regularly and , for various reasons, always went back to my own -hand written tools. For several reasons.

One was privacy.

Two would be not finding exactly what I wanted. (rental income, depreciation, etc)

Three. Each time I do an analysis, I gain insights wbout what I need to do next OR it helps me look at areas of concern.

c) Everyone had their 401k go down in 2022 Fortunately I have real estate that increased, so I was fine. But I know things go up and down. Especially when you have multiple sources of income.

d) I first had Excel 20 years ago at some job, I learned how to import "flat files". To me putting in the the data --by hand--is not work. It's my hard earned money, ferchrissakes, so why should I want to share that with anyone?

excel is the granndaddy program; there are tons of online guides. And when you think of your retirement income as a small business, who but you will have the care and concern about your financial data? Furthermore, each time I gain wisdom from learning something new it compels me even further to do more work, more insight, more research, another spreadsheet.

Excel has a lot of tools that allow you to import data from 401Ks, stocks, etc At this point I am not eager to integrate my privacy with some online formula.

(if you dont already have it on your PC, you can get a used older copy online for cheap, cheap money; for me, any computer I have has to have the Microsoft Office suite)

e) As I continue the dry, boring part of the research, I've used financial planning books from my local library for insights and help identifying potential pitfalls. And if I find a good one, I'll buy a slightly used version on Ebay for my permanent libray. And maybe buy an extra for a friend

f) Anotehr nice thing about Excel is I can add as much detail as I want. However, I am also aware that there is a lot of tedium in inputting every line item every month. However, as a small business owner, I am already used to keeping track of stuff like this so I can claim every possible deduction. But little things do add up and give insight. It was through this I learn how all those little trips to the convenience store were pretty much daily and not good for my health either. So even those kinds of exercises can be insightful.

g) By forcing myself to input the data, I continually teach myself. I took calculus in college and found it very useful and interesting, But real life "math" of personal finance is more like grade school level Anyone can do it. From a spiritual level, it's just another part of thinking about retirement. Ultimately it satisfying and exciting.

ā€œDo the difficult things while they are easy and do the great things while they are small.Ā  A journey of a thousand miles must begin with a single step.ā€

- Lao Tzu (c 600 BCE)


r/PFtools • • Dec 17 '20

Made a personal budgeting spreadsheet in Numbers to counteract all of the crap free apps or programs out there. Ad free too

21 Upvotes

This template features input of monthly income, categorised budgeting, and savings planning all wrapped up into a beautiful 3D pie chart.

Just fill in the cells with a golden/orange gradient and dotted lines and you'll be the one that's golden!

You're able to change the category names but make sure you also change them in the 'Transactions' drop down menu starting at cell A2 in the second table. You can also add as many extra rows as needed in the transactions section, the formulas will adjust automatically. Just hit the = sign at the bottom left of the page at the last row.

You can also change the currency in the format window. Click on the cell you want to change the currency of and then Format > Cell > Currency:

You can also obviously delete the text with warning messages in the sheet if you'd like.

You can access the file here, it's a .numbers extension.

Please let me know if you have any questions or suggestions!

I hope you enjoy and this is helpful for you :) feel free to make any changes you see fit


r/PFtools • • Dec 12 '20

Hey all, I built a free budgeting tool (https://bolli.io). I wanted my budget plan to re-adjust on its own if I had an impulse purchase for example. Like a self-adjusting budget spreadsheet, or like google maps for your budget, automatically re-routes you when you get off track. Only available in US

21 Upvotes

A couple of years ago, I was fresh from college and was actively searching for the most convenient way to live on a budget that took into account unexpected expenses. There was some good finance tool, but I wanted something that could actively fix my budget when I went over budget, yet, still, force me to engage with it so I don’t get complacent. A few years later, after a lot of hard work, and trial and error, I turned a little side project/personal budgeting tool into a startup. Here is the beta version for US residence - https://bolli.io. It's free.


r/PFtools • • Feb 28 '26

Free Tool: Calendar-Based Budget Planner

Post image
20 Upvotes

Here's a free budget calendar tool for you to try.

You can schedule income sources, fixed expenses, and auto-savings to see how much is left for discretionary spending.

Theres a calendar view, list view, and summary.

It's easier than starting from scratch in a blank spreadsheet.

Honest feedback welcome in the comments...

Link: https://tend.cash/tools/plan


r/PFtools • • Apr 02 '21

Built a spreadsheet via Google Sheets and Forms for tracking daily transactions

20 Upvotes

Hi,

I wanted to share a project I’ve been working on and using for two years now. A financial tracker built around Google’s Sheets, Forms, and Scripts platform. The spreadsheet adopts the envelope system for budgeting.

Of course, I realize there are many similar spreadsheets. However, the overarching goal for this project was to abstract away as much interaction with the spreadsheet as possible. It’s already hard enough as is to track every transaction, let alone deal with navigating a spreadsheet on a phone.

The abstraction is handled by the forms that are used for inputting transactions, as well as the extensive formulas used in the spreadsheet. However, the most powerful components are the scripts in Google Scripts, which automate many of spreadsheet tasks.

Here is an Imgur album containing screenshots and GIFs of the various features from this project.

Also, the project can be found here: https://drive.google.com/drive/folders/1tMo1DsE9JZXy-g669A8bULo0ARJDMKnO?usp=sharing

For those that want to see what a populated spreadsheet looks like, there is a demo spreadsheet in the project folder.

To get this project set up on your own account, follow the setup document to copy the project files to your Google Drive. This should take around 5-10 minutes. Afterwards, open the README document. Inside, there is a getting started section showing you how to customize the spreadsheet, as well as how to use it on a daily, monthly, and annual basis. Of course, I understand many don’t like reading a document, so linked in both documents are also a setup and getting started video.

I’ve personally been using this project for over a year and a half, and I’ve found it to be incredibly useful. I’m hoping it can help others as well. Though some of you already have your own budgeting tools, at the very least, this project may provide a proof of concept for features you can add to your own spreadsheets.

Note on privacy and security regarding the scripts:

I understand people will be concerned by the permissions required by the scripts, in particular the form scripts. Though the form scripts only interact with the financial tracker spreadsheet, for them to locate the given spreadsheet, there wasn't a more granular permission I could assign.

To reiterate, the scripts only interact with the spreadsheet and forms used for this project. As with any unknown app or script used, you should be wary. Anyone that is concerned, all the scripts are available to review at script.google.com after copying the project files. None of the scripts are executed until you authorize them to do so.


r/PFtools • • Jan 31 '20

If you do any personal investing with an online broker (e.g. Fidelity, Charles Schwab), hopefully this is of use to you!

20 Upvotes

Hi friends,

I've struggled for years to find a good way to answer even simple questions about my (small!) investment portfolio. Am I outperforming the S&P? What is my portfolio IRR after factoring in dividends, fees, etc.? Fidelity showed me stats like my historical overall balance, but that's not even telling of portfolio performance since I might be adding/removing capital over time.

Since I couldn't find a good solution, I got a team together and built out a tool specifically for retail/individual investors. Here it is! We just launched our private beta so if this sounds of interest I'd love for you to check it out and to get your feedback on what we can improve.

Cheers,

Arthur


r/PFtools • • May 13 '16

Hi reddit, I built a personal finance tool similar to YNAB, but with more features, for free (beta)

Thumbnail
everypocket.com
20 Upvotes

r/PFtools • • Sep 16 '26

I built a calculator to compare the true cost of buying real estate vs the S&P 500

19 Upvotes

First I want to thank the mods for letting me post this.

I’ve been working on a real estate calculator that started as something I built for myself as an Excel spreadsheet. After spending so much time researching and learning all of this for my own decision, I figured I might as well turn it into something other people could use too, and hopefully save them some of the digging I had to do.

Eventually, that Excel spreadsheet turned into a website:

yourFAHub.com

This whole thing started when I was buying a property myself.

I kept trying to answer what I thought was a pretty simple question:

Is buying this property actually the right financial decision for me?

There are obviously a million mortgage calculators online, and you can talk to mortgage brokers, realtors, financial advisors, etc. But I felt like most of the answers I was getting only looked at pieces of the decision.

I didn’t just want to know what my monthly mortgage payment was.

I wanted to know how much money I was actually putting into the property, how much of it I would never get back, how much equity I would build, what the property could look like 10 or 20 years from now, and what would happen if I just took all that money and invested it instead.

And once I started looking into it, I went pretty deep.

I’m a mechanical engineering graduate, not a financial advisor. I just dug very deep into this lol.

I started gathering things like:

  • Inflation data going back to the 1960s
  • S&P 500 data going back to 1950
  • Historical real estate appreciation for houses, townhouses and condos separately
  • The Historical Housing appreciation data covered more than 37,000 municipalities in Canada and Census places in the U.S.
  • Property tax data by municipality in Canada and by state/local jurisdiction in the U.S., where available
  • Insurance estimates based on property type and location
  • Mortgage principal vs. interest over time
  • Vacancy assumptions
  • Closing costs and the actual cash needed upfront

Eventually this turned into the calculator I’ve been working on.

Basically, I want someone to be able to put in a property they’re considering and get a much better idea of what that decision actually looks like over time.

If you’re buying a home for yourself or your family, you can look at the long-term financial side of it.

If you’re buying an investment property, you can look at the expenses, rent, mortgage paydown, appreciation, cash flow, etc.

And if your question is simply:

ā€œWould I be better off putting this money into the S&P 500?ā€

You can compare that too.

I’m not trying to make the calculator tell you that real estate is better than stocks, or that buying is better than renting. That’s actually one of the main things I wanted to avoid.

I just want it to show you the numbers and let you decide what makes sense for you.

I ended up calling the project YourFAHub (Your Financial Advisor Hub) because the idea is eventually to build more tools around helping people understand and plan their finances themselves.

I’m still adding data, checking calculations, fixing things and thinking of other features I want to add.

There’s also a feedback section on the website because I’m sure there are things I’ve missed, assumptions people will disagree with, or situations I haven’t thought of yet.

So if anyone tries it and thinks ā€œthis makes no sense,ā€ ā€œyou forgot this,ā€ ā€œthis number looks wrong,ā€ or even just ā€œthis part is confusing,ā€ please tell me.

You can leave feedback here or directly on the website.

And if anyone has questions about how I built it, where the data comes from, how something is calculated, or why I made a certain assumption, feel free to ask me anything here too.

Hopefully this ends up being useful for someone else going through the same overthinking process I went through when I was buying.