1. Do you use a spreadsheet? Did you build it yourself? Did you buy one that was already done for you?
2. Do you use an accounting software (Quickbooks, Xero, Zoho, etc.)?
3. How do you like your current solution? Is it too complicated? Is it too overkill in terms of features for your needs?
4. What would make it better for you?
In the workshop, they recommended also using tracking tools like Mint to follow all your expenses, not just business, but also, personal.
I'd be curious to know how many other people track it all to the penny like this.
I use YNAB for budgeting. I like the ability to choose between the mobile app or website depending on what I need to do.
I've been using a spreadsheet for tracking my net worth over time. I copied the template from someone else and just update it on the 1st of every month.
> 2. Do you use an accounting software (Quickbooks, Xero, Zoho, etc.)?
The only software I use is Quicken. I have it download all of my balances for all of my accounts to simplify updating my net worth sheet.
> 3. How do you like your current solution? Is it too complicated? Is it too overkill in terms of features for your needs?
It feels great right now. When I first started creating a budget, I overcomplicated it. It took a while to figure out how to make it simple, but it feels natural and easy to use now.
> 4. What would make it better for you?
I wish there was another piece of software that helped with downloading balances and transactions. Quicken is pretty slow and bloated and pricey. I've tried Personal Capital, but I wasn't comfortable with having my balances stored there. Quicken seemed secure, trusted, and offline-ish enough for me.
Spreadsheets 1) Current accounts - Charge Cards, Rent due, utilities, bank accounts. I update every 2 weeks when I get paid. This has worked out well as it forces me to look at our primary accounts and I catch things before they become problems. My significant other, knows this and has caused a change of spending habits, all for the good. In my balances, I have a baseline adjustment so every year the first paycheck all my current accounts balance to zero, this way as the year goes on I can see where I am. It also keeps me from considering as a total how much I have saved over several years and then feel like I can spend it.
2) Yearly - sometimes more often, I do a spreadsheet of investments and retirement money. I also add in large assets like the value of my cars, although they are not worth much. I also re-balance my investments then, or at least start to decide what to change.
For myself - I hate spreadsheets and updating and categorising data. I have also tried a number of tools that will "attempt" to automagically present useful reports. But I've found that in 90% of cases - I'm well aware of what I spend on and how much I spend.
The data that really interests me personally is - savings, pensions, asset wroth tracking and scenario simulation. I find that looking at growth over the past 3,6,12 months motivates me to do even better or look for more efficient ways of organising my finances.
At the moment here's what I do:
- Following a guide like (UK Personal Investing Flowchart)[https://ukpersonal.finance/flowchart/] to judge where I am at and what my short/long term goals are.
- I have automated transfers at salary date (T+3 days to account for variations) to investments and savings.
- I do a monthly scan through of current and credit accounts to make sure nothing unusual occurs as well as monthly credit-rating check.
- For crypto investments I use (Delta)[https://delta.app/en]
- For Stocks and Shares I track current positions via Yahoo Finance.
- Lastly - every now and then I check-in to see how my Pension accounts are doing. So far I've gone through 4 different pension providers and tools - but none of them see to have good forecasting, scenario tools.
As a side topic recently got shown (Casual)[https://causal.app/] by a friend - I've been contemplating giving it a try.
This lets me at least compare values for each month easily. But of course my variable expenses are all under a CC card bill...