I use excel too (well technically open office Calc).
this post was submitted on 14 Jul 2023
23 points (100.0% liked)
FIRE (Financial Independence Retire Early)
1106 readers
1 users here now
Welcome!
FIRE is a lifestyle movement with the goal of gaining financial independence and retiring early.
Flow Charts:
Personal Income Spending Flow Chart (US)
Personal Income Spending Flow Chart (Canada)
Personal Income Spending Flow Chart (Australia)
Personal Finance Flow Chart (Ireland)
Useful Links:
Mr. Money Moustache - a frugal lifestyle blog
Related Communities:
founded 1 year ago
MODERATORS
I use Google Sheets primarily. For more day to day tracking (since I don't like waiting for the end of the month), I use the account tracker in Fidelity to see my investments.
Back in the day when I first started working I used Excel, but it was a total pain in the butt.
For the last 10 years I've used YNAB (You Need A Budget), it was a single purchase back then and I still have it on Steam and on my phone. Works great, doesn't cost me a thing, keeps track of every cent (as long as I spend around 20 minutes a month to put all transactions in).
Unfortunately YNAB switched to subscription only, so it's a bit difficult to recommend :-/
I can still recommend the pre-subscription YNAB. It used to still be available on their website but that's gone now, too. Supposedly you can still download it through the Wayback Machine. https://web.archive.org/web/20190122064610/https://classic.youneedabudget.com/
However you want to obtain YNAB 4, it's going to be a trial but it's really simple to extend that trial by however long you want. To my knowledge there's no difference between the trial and the paid version.
Here I'm talking about YNAB 4.3.857 but this trial date editing probably works on any version of 4.
- Install on your computer. Launch YNAB4 for the first time. Click Start Trial.
- Close YNAB
- Using notepad, open the file %APPDATA%\com.ynab.YNAB4.LiveCaptive\Local Store.lic
- Change the date to be 10 years in the future
- Re-open YNAB4. Go to Help->Purchase or Activate YNAB
You now have 3686 days to enjoy using YNAB4
Money Manager on Android, with PC manager to be able to export to excel and with dashboard.
5 years worth of data. It's so much useful
I have a couple of spreadsheets but primarily I just use empower because Iβm lazy and it (mostly) works. Iβve got six years of history in it and the zoom out is good for a dopamine hit.
For any fans of open-source software out there, I use beancount which I've found to be perfect for my needs. I didn't know much about double-entry bookkeeping when I started using it, but the documentation was very extensive and I learned a lot in the process of picking it up.
There are a whole collection of plugins and other resources which fit into the tool which help too, like fava which can generate webpages like this based off your data. Beancount is not the only plain text accounting tool, you can find lots of examples here.
Mint.
I use Excel, and Empower (formerly Personal Capital). I also still have Mint, but don't use it that much.
PC stopped syncing with chase for me and multiple support tickets got me nowhere so Iβm back to mint but would love any other options.
Would love a net worth tracker designed for FIRE that works with plaid. Doesnβt need anything too fancy. Just numbers over time and transactions.
I use Excel. Apps generally seem to be focused on tracking spending, and are less useful for modeling future changes. If I want to look at my actual spending in more detail I can use the banks apps for that, the spreadsheet is more future focused.
I have been working on the spreadsheet for years with gradual improvements all the time, and it is exactly customised to my needs. So I can calculate my pay (which is variable and based on a ludicrously complicated structure), allocate the money based on a mix of set and percentage figures, model the impact of future changes such as increases in power costs or getting another pet, and estimate at any time how much I have accrued for utility bills not yet received.
I use Tiller to track my transactions, and a separate sheet for my projections. It seems to work pretty well.
I used to use spreadsheets for budgeting but recently switched to selfhosting Actual.
For FIRE numbers (investments, spending, etc.), I built my own site that tracks everything:
Neat β do you manually input data or do you have some kind of scraping set up to feed it? Why a custom site vs pure spreadsheets?
I have it automating as much as I can - fund prices, crypto holdings and prices. Technically, anything it's doing can be done in a spreadsheet, but some of the more complicated stuff (like accessing other sites) is significantly easier and more stable here.
Also does some cool things like the blurring when I want to share a screenshot, calculating what part of my spending is covered by my assets, tracking historical data, etc. Pie charts where I can exclude data points with a click. Includes/excludes data points based on settings.
view more: next βΊ