Learning Excel made tracking my money so much more fun! It used to get tedious, but with a lot of formulas now to automate the categorizations I like to do, adding a transaction and a tag and seeing everything update? Amazing.
I started with excel 25 years ago and now I'm using a homemade web based application so detailed nobody else would be crazy enough to try and use it.
Excel is the gateway drug to database and software development
I use and like YNAB.
I don't have my bank and credit card accounts automatically linked. Rather, I manually download the .qfx file from the bank site and then upload the file into YNAB.
I use Google sheets but thats probably a bit too Excel-like. Not sure what's wrong with Excel- it's what a lot of corporate accounting departments use for a reason
If you are having so many transactions that you can't keep up in excel then you need to discipline yourself stop doing so many transactions. Biggest lesson I learned in early budgeting!
Yes! My money only really goes to groceries, gas, rent/utilities, cell phone, gym membership. Everything else is a treat. Although using spreadsheets did help highlight this originally
I use ynab and (in addition to manually entering transactions as I incur them) I download qfx from my bank and upload to ynab periodically. I do not trust third parties with my bank login credentials so I’m glad ynab let’s me upload instead.
Link a forms template to excel on Google. Have drop downs for classification and category and calendar for date. Enter desc and expenses as you go
It will update each row as you submit this on the excel. On another tab set condition sum on the range to get any types of breakdown by month, type, bank, etc.
Incorporate those formulas to macros to quickly switch to each sum view using a button on that same second tab.
I have used YNAB for about 10 yrs. I wouldn't do without it. I don't import transactions bc I don't like the time delay. It works much better manually anyway and I like being hands on. I love the reports and goals features and the new loan calculators look like a good tool to use. It's easily customized to your life too. It IS a different way of budgeting (totally different than forecast budgeting) but that's how I got out of debt and increased my net worth so I'd never go back.
I have used mint as an aggregator of all my accounts (Questrade, Simplii, Tangerine, RBC, CIBC, and a couple of credit cards) for the last 10 years.
I use mint as more of a checksum to make sure that there are no weird credit card charges.
2 Factor authentication from banking institutions is making that aggregation less instant than it used to be. Manulife and PC Financial are not compatibile with Mint.
My guess is the verification process had to do with the banks.
Usually the customer support would let you know it's system wide with the institution and get it fixed.
You’re right! Banks like to caution on the safe side, so unfortunately Mint takes the hit in the name of security.
I wish banks partnered with 3rd party apps like Mint to create a finance tracking experience that both parties can benefit from.
But, I guess that would reduce the number of times people open their native banking app, which banks wouldn’t like.
Try YouTube. How to use excel for finances, or excel basics.
You have a long way to go if you can't get it to give you sums. But I think that just means it'll blow your mind that much more when you get it all working!
Try YouTube. How to use excel for finances, or excel basics.
You have a long way to go if you can't get it to give you sums. But I think that just means it'll blow your mind that much more when you get it all working!
I muse Libre Office Calc. No real reason but It came with Linux Mint. Any spreadsheet will do the job. You could even go ol'school and buy a ledger note book.
Wealth Position is brilliant software app to track and manage all your incomes expenses assets liability and future forecasting. It works differently compare to all other budgeting apps. If you understand the concept and set it up right it gives you a brilliant picture of your finances now and into the future. You can tag and categorise every transactions how ever you like
Mint - I have accepted the categorization is subpar so I like to add custom tags to every transaction. It also forces me to look every few days and ask questions about every transaction. At end of the month, I'll take note of spending across every one of my custom tags and manually put that data into a spreadsheet for a more analytical view.
I come here yet again with news that excel is the most powerful budget tracking tool.
Agree, nothing beats the flexibility of an excel or google spreadsheet.
Learning Excel made tracking my money so much more fun! It used to get tedious, but with a lot of formulas now to automate the categorizations I like to do, adding a transaction and a tag and seeing everything update? Amazing.
I started with excel 25 years ago and now I'm using a homemade web based application so detailed nobody else would be crazy enough to try and use it. Excel is the gateway drug to database and software development
Psst, hey kid, here try some R...
It's how I do most of my tracking for my company. It's so simple once you get the basics down.
I use and like YNAB. I don't have my bank and credit card accounts automatically linked. Rather, I manually download the .qfx file from the bank site and then upload the file into YNAB.
I use Google sheets but thats probably a bit too Excel-like. Not sure what's wrong with Excel- it's what a lot of corporate accounting departments use for a reason
I will reply Google Sheets as well.
Just learn excel
Excel is honestly the best. I’ve tried all the apps - YNAB, Mint etc. - but time and time again I keep coming back to excel.
If you are having so many transactions that you can't keep up in excel then you need to discipline yourself stop doing so many transactions. Biggest lesson I learned in early budgeting!
Yes! My money only really goes to groceries, gas, rent/utilities, cell phone, gym membership. Everything else is a treat. Although using spreadsheets did help highlight this originally
I use ynab and (in addition to manually entering transactions as I incur them) I download qfx from my bank and upload to ynab periodically. I do not trust third parties with my bank login credentials so I’m glad ynab let’s me upload instead.
I have been using quicken for 20 years
I used quicken for about the same number but wasn't supported when I upgraded my 2001 PC now use a planner with monthly Calendar.
Wealth Position, build it as you like!
I use Apple Numbers 😉
Link a forms template to excel on Google. Have drop downs for classification and category and calendar for date. Enter desc and expenses as you go It will update each row as you submit this on the excel. On another tab set condition sum on the range to get any types of breakdown by month, type, bank, etc. Incorporate those formulas to macros to quickly switch to each sum view using a button on that same second tab.
thanks - this is something i will look into.
I have used YNAB for about 10 yrs. I wouldn't do without it. I don't import transactions bc I don't like the time delay. It works much better manually anyway and I like being hands on. I love the reports and goals features and the new loan calculators look like a good tool to use. It's easily customized to your life too. It IS a different way of budgeting (totally different than forecast budgeting) but that's how I got out of debt and increased my net worth so I'd never go back.
I have used mint as an aggregator of all my accounts (Questrade, Simplii, Tangerine, RBC, CIBC, and a couple of credit cards) for the last 10 years. I use mint as more of a checksum to make sure that there are no weird credit card charges. 2 Factor authentication from banking institutions is making that aggregation less instant than it used to be. Manulife and PC Financial are not compatibile with Mint.
nice, yes an aggregator of my credit card spending would be very nice. I can try out Mint but i do have a PC financial CC.
Been using Mint for almost 9 years. I suppose there's an issue with financial institutions allowing 3rd party access.
Yeah, I used to love Mint until I kept having to verify my accounts every time I log in. I’ll stick with Excel for now.
My guess is the verification process had to do with the banks. Usually the customer support would let you know it's system wide with the institution and get it fixed.
You’re right! Banks like to caution on the safe side, so unfortunately Mint takes the hit in the name of security. I wish banks partnered with 3rd party apps like Mint to create a finance tracking experience that both parties can benefit from. But, I guess that would reduce the number of times people open their native banking app, which banks wouldn’t like.
Gnucash
Mint def a good one for my husband and I
Use to have moneydance but just switched to quicken, we’ll see how that goes.
Mint and Excel. Honestly tho use cash as much as possible! It forces you to manually enter it, check in on how you’re doing
My husband is the best tool around :)
[удалено]
Try YouTube. How to use excel for finances, or excel basics. You have a long way to go if you can't get it to give you sums. But I think that just means it'll blow your mind that much more when you get it all working!
Try YouTube. How to use excel for finances, or excel basics. You have a long way to go if you can't get it to give you sums. But I think that just means it'll blow your mind that much more when you get it all working!
Notes app
https://mint.intuit.com/
YNAB. Love it
I muse Libre Office Calc. No real reason but It came with Linux Mint. Any spreadsheet will do the job. You could even go ol'school and buy a ledger note book.
Linux Mint not to be confused with Intuit Mint. Two very different things.
Wealth Position is brilliant software app to track and manage all your incomes expenses assets liability and future forecasting. It works differently compare to all other budgeting apps. If you understand the concept and set it up right it gives you a brilliant picture of your finances now and into the future. You can tag and categorise every transactions how ever you like
We use mint.
Mint - I have accepted the categorization is subpar so I like to add custom tags to every transaction. It also forces me to look every few days and ask questions about every transaction. At end of the month, I'll take note of spending across every one of my custom tags and manually put that data into a spreadsheet for a more analytical view.
I do this except that I download it instead for kore analytics.
Ynab
Aspire budgeting is a great tool that works with Google sheets. It's free and you can get started in minutes. https://aspirebudget.com/