How I Track My Finances | GOOGLE SPREADSHEETS, DEBT, SPENDING, NET WORTH, ONLINE INCOME
HTML-код
- Опубликовано: 11 мар 2021
- Monthly and Yearly Tracker: docs.google.com/spreadsheets/...
You will only be able to VIEW this spreadsheet. To use it, go to File, Make a Copy, and Save. You will then be able to edit your own!
How I Manage My Money: • How I Manage My Money ...
#FinanceTrackers #GoogleSpreadsheets
Financial Coaching: debtoverit.com/coaching/
Get on my Money Monday List: www.subscribepage.com/p5f3y9
Money Blog: www.DebtOverIt.com
Follow me on Twitter: / debtoverit
Support me: www.buymeacoffee.com/leilak
__________________________________________________________________________
ACCOUNT BONUSES
Marcus by Goldman Sachs HYS Account: www.marcus.com/share/LEI-VSR-...
Earn 0.20% higher than the stated APY for 3 months (currently will be 0.7%)
Chase Freedom Flex:
referyourchasecard.com/18/AM3...
Earn $200 after spending $500 in first 3 months
5% cash back on groceries for 1 year
No annual fee
CapitalOne Venture One: capital.one/2J8kqHJ
20,000 miles after spending $500 in first 3 months
1.25 miles per $1 spent
No annual fee
MAKE MONEY
--Rakuten (earn $20): www.rakuten.com/r/LEILA426?ee...
--IBotta: ibotta.com/r/85zng
--Fetch app: Use my code EJH9Y for 2,000 points
INVEST & EARN MONEY
--M1 Finance (Get $10 after investing $100): m1.finance/2RLUe15v_lkd
--WeBull (Get 2 free stocks after depositing $100): act.webull.com/k/53Ugkqm2IDZf...
--Robin Hood (Get a free stock!): join.robinhood.com/leilak15
____________________________________________________________________
MY LIFESTYLE CHANNEL: / livinglikeleila
GOAL ACHIEVEMENT COURSE: livinglikeleila.teachable.com...
SELF-DISCIPLINE COURSE: livinglikeleila.teachable.com...
CHECK OUT MY BLOG:
www.livinglikeleila.com
MY ETSY SHOP: www.etsy.com/shop/LivinglikeL...
I N S T A G R A M : / livinglikeleila
Camera I use (Canon EOS M50): amzn.to/2KpcE9k
Microphone I use: amzn.to/2KI43zU
Business inquiries: contact@debtoverit.com
Song:
Marshmallow (Prod. by Lukrembo)
*The links above may be affiliate links. This just means that if you make a purchase through one of the links, I make a small commission at no extra cost to you. I appreciate the support!
DISCLAIMER: I am not an expert or a financial advisor. I simply love talking about finances and want to share my journey to financial freedom and help others along the way!
It is so refreshing to see a finance RUclipsr with a lifestyle, income, and portfolio similar to mine. You are so relatable, and I really appreciate your videos.
That's awesome, thank you!! 😊
I am using google sheets as well to track my finances. Like Personal Finance, I had used Mint and its also having challenges with some downloading for some of my accounts. This is one of the reasons i went over to tracking it myself. One thing i started doing that has really made it better is using a google form to add my expenses as they occur. I can quickly update my spreadsheet from my phone after buying something like, gas, food, etc. Taking the receipt and entering it using the google form. I setup a icon on my first page of my phone that goes right to the form. This has really made me much more aware of what i'm spending and its fun to see if i can do better month to month on my total expenses.
Yes!! I love that it's on my phone too!
I love using google sheets to track! You’re so organized 😍 thank you for walking us through your system
Thank you for watching 😊
love seeing how others use home made spreadsheets to track their money! I love doing it for myself so I appreciate all the detail, Leila!
Thank you!!
Your trackers have changed the way I view my finances! So helpful, once you see how much you have and spend it puts everything into perspective! Will be using the annual one now! Thank you!
Yay! Thanks Jasmine 😊
“Most of the actions happens on my Google spreadsheets” love it 😂❤
I track our spending/net worth/savings balances all in excel. So much easier to stay organized!
It's so fun too 😂
Love so much!!! So inspired!!
Thanks Jennifer!
OMG YES to that tutorial! I have a fee spreadsheets that work for me but I want to make it/them better and some of the ones you showed here would be super cool adds to mine!
Will do! 😊
Yesss! Video on how YOU set up on Google Spreadsheet! Please and thank you!
For sure 😊 thank you!
Just like my computer, my clothes and food, I also don't track my car and house in my net-worth. I think of them as life-tools, not a financial asset. If anything, they are more of a liability sometimes. Thanks for the video.
I agree!!
I've lost track on how many videos I've watched on RUclips to create a decent budget on my excel, I'm not a big fan of google sheets, I've been using excel for quite a while now so it's my preferred spreadsheet program. So my point is that your spreadsheet for budget tracking is by far the best one I've found to date. I'm gonna start using it, but I'm gonna tweak it some to fit me. Thank you
Awesome, thank you for letting me know that!! 😊
@@PersonalFinancewithLeila Your welcome, I've already done a few tweaks and still working on it, trying to work on March, and when I get that completed have to do Jan and Feb
Yes!! I love a good spreadsheet! Thank you so much for this. I am a google sheets/excel nerd. I am like you, slightly obsessed lol. I do enjoy pen and paper, but I love how simple and neat the spreadsheets make everything look! I would love to see your monthly budgets and/or reviews in the spreadsheets. 😊
Good to know, thank you 😊
❤❤❤❤🍎🍎😊😊Paper is a lot more work than updating using technology- I gotta learn😊
I love your tutorials, thank you for charing. Do you have a video on what formula to use to calculate how much interest your paying off per month?
Im going to download your sheet to see if it helps me, lol. Great video!
Yay!
I think it's fun 😂 Let me know if there are any issues!
@@PersonalFinancewithLeila Ok thanks!
Great video content, very informative...!
Thank you! 😊
I thought i was organized your on another level😂
Lol it's not too crazy in my opinion! 😂
I track my finances veryy similar.
ive looked at alot of your videos and i was wonderings if its possible to create a google doc of some sort and input an online bill lets say light bill. then provide the username and password to where when the bill is available it will update in google doc for all your online bills? just how prisim works but in a google doc format where you can edit it
Hi. I don't see this debt tracker template included with your links. I would love to have this to help me track my debt.
Do you keep track in any way your daily expenses? or just weekly/monthly?
I have 1 Question for you- How do you track credit card debt? I mean- We use credit cards to buy groceries and utilities and pay off them in full the next month. Any suggestion on, how to keep track of credit card debt along with car loan, student loan and mortgage payment? Thank you!
The hair is looking pretty.
Thank you! 😊
I prefer your instructional spreadsheets. Maybe an Excel video, next??
Thank you! Unfortunately I don't use/have Excel!
niceeeeeee
This is so cool! I want to do something like this but the only thing is, I want to know how many years can I go before it’ll stop me from adding more 😂
😂 I'm not sure how many tabs they'll let you have, I would assume it's unlimited!
How did you formulate the exclude debt and savings line? Can you add that to your template?
I can't add it to the template because not everyone has the same amount of debt/loans and some people may want it in different spots!
But I use =(Total spent-debt 1-debt 2-savings 1-savings 2, etc)
Does that make sense? You would click the cells for each one!
Can you show how you use Google Sheets?
I have a video on how to use it! If you search "Google Sheets" on my channel it should show up!
A car is a liability :) I also don't count it as an asset
For sure!
Are you paid weekly, biweekly or monthly (from your regular job)? Also, do you manually calculate all your categories to enter into your spreadsheet each month?
I am paid once a month, on the last business day of the month!
I'm not sure what you mean by your question exactly, but my categories stay about the same every month and I copy and paste usually for the following month. Then I fill in what I know and/or expect each expense to be.
@@PersonalFinancewithLeila I'm sorry my question was not clear. Like for variable spending catorgies, groceries, household, out to eat, etc. Do you track where/how much you spend in that category, in a notebook or spreadsheet? In the video, you showed for groceries that you were just inputting the totals each time you bought something at the grocery store (to make a sum for total spent). Do you do that for all variable spending? I would be glad to share with you my spreadsheet I made and use for my budgeting. I could customize it for a monthly income. Theres a "transactions" tab where you enter your purchases, which includes drop down menus for spending categories,how you paid, and if you used sinking funds-to take it out of that category too. And then in another tab in the spreadsheet it automatically pulls the data from the transactions tab and you can see how much you spent in each category. I really enjoy budgeting, and when I started there were no tools for people with weekly incomes, so I created my own "tool" and I really enjoy it. But people budget differently, so if what you are doing works for you that's great 🙂
And can i quickly update my spreadsheet from my phone after i buy something like , Gas , food etc.??
Yes Ron , you can quickly update your spreadsheet from your phone after buying something like that and other bills etc. All you need to do is to take the receipt and enter it just using the google form. You will setup a icon on your first page of your phone that goes right to the form.
By doing that it will really make you much more aware of what you are spending and its fun when you try to see if you can do better month to month on your total expenses.
Yes! I should have mentioned that is another reason why I love my spreadsheets in the video!
Is there a reason you're saving for the student loans rather than paying them off? is it better for your credit?
I'm making more money by saving them! I keep the money in my high yield savings account so I earn interest every month. It's not huge but it's still more money!
I need to design a spreadsheet for someone on benefits who has monthly bills and debts plus two saving accounts that he pays £2 a month into - any advice please.
You should be able to use my template! Feel free to email me (email in description) if you want to send over more details and I can try to help!
@@PersonalFinancewithLeila Sorry but am having trouble seeing your email address.
@@PersonalFinancewithLeila I emailed you just over a week ago, not had a reply yet.
@@adriancanning1783 hi Adrian I never received an email! I also checked my spam. Can you please re-send to contact@debtoverit.com ?
Why did you decide for the Roth IRA, instead the traditional 401K!? Curious! 😇
Some jobs don't offer that, like people hired as an independent co tractor for example
In a Roth IRA, you invest with money you have already paid taxes on. But that money will grow until retirement, and all the gains are tax free. Because you already paid taxes now. So It is better in theory to pay taxes on $6,000 now, than pay taxes on $50,000 30 years from now.
@@inea-fijourney22 That’s was I want to know! I have already the traditional 401k, But I would like to buy house with them! I don’t know is it a good idea! Eventually I’m going to change to a Roth IRA!
@@Manelly It depends on your specific situation. Youll have to sit with someone to analize your situation looking at all the facts. I think Leila does one on one coaching but Im uncertain if she goes this deep. Check it out.
Personally I view my situation a bit different, Im a CPA - who let lifestyle creep add years to my working life. But Ive turn my ship around and should be able to retire early, hopefully by 40! You had a great question. I will definitely add it to my list of topics for the CPA content channel. This one is my personal situation channel 😅
@@inea-fijourney22 Thank You!
Good morning mam!!!....
Recently I came across your video, your content is amazing and can do wonders in future. By profession I am a gfx artist and editor . if u approve I can make RUclips videos and edits for u. And together we can take your channel to different heights. If u want to see my portfolio please reply .
Thank you