How I Track My Finances | GOOGLE SPREADSHEETS, DEBT, SPENDING, NET WORTH, ONLINE INCOME

[@jennifertucker6528]

It is so refreshing to see a finance KZbinr with a lifestyle, income, and portfolio similar to mine. You are so relatable, and I really appreciate your videos.

[@PersonalFinancewithLeila]

That's awesome, thank you!! 😊

[@jmmccrary]

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.

[@PersonalFinancewithLeila]

Yes!! I love that it's on my phone too!

[@jasminemejia5302]

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!

[@PersonalFinancewithLeila]

Yay! Thanks Jasmine 😊

[@DearDebt]

I track our spending/net worth/savings balances all in excel. So much easier to stay organized!

[@PersonalFinancewithLeila]

It's so fun too 😂

[@HaVocHarMony]

“Most of the actions happens on my Google spreadsheets” love it 😂❤

[@EmilyDowgialo]

I love using google sheets to track! You’re so organized 😍 thank you for walking us through your system

[@PersonalFinancewithLeila]

Thank you for watching 😊

[@billcolton6373]

I've lost track on how many videos I've watched on KZbin 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

[@PersonalFinancewithLeila]

Awesome, thank you for letting me know that!! 😊

[@billcolton6373]

@@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

[@GenZFinance]

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!

[@PersonalFinancewithLeila]

Thank you!!

[@CaliWalli]

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.

[@PersonalFinancewithLeila]

I agree!!

[@jessmarie7082]

Yesss! Video on how YOU set up on Google Spreadsheet! Please and thank you!

[@PersonalFinancewithLeila]

For sure 😊 thank you!

[@SavannahAvianeda]

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?

[@iamjessv]

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. 😊

[@PersonalFinancewithLeila]

Good to know, thank you 😊

[@josmith2002]

❤❤❤❤🍎🍎😊😊Paper is a lot more work than updating using technology- I gotta learn😊

[@JaniVMD]

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!

[@PersonalFinancewithLeila]

Will do! 😊

[@HerCurlySole]

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.

[@memes4life231]

I thought i was organized your on another level😂

[@PersonalFinancewithLeila]

Lol it's not too crazy in my opinion! 😂

[@DjSerolmp]

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

[@jenniferalaquinez2704]

Love so much!!! So inspired!!

[@PersonalFinancewithLeila]

Thanks Jennifer!

[@Manish_1881]

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!

[@inea-fijourney22]

I track my finances veryy similar.

[@CFwarriorLeAnnL]

Can you show how you use Google Sheets?

[@PersonalFinancewithLeila]

I have a video on how to use it! If you search "Google Sheets" on my channel it should show up!

[@TheKrystolMethod]

Im going to download your sheet to see if it helps me, lol. Great video!

[@PersonalFinancewithLeila]

Yay! I think it's fun 😂 Let me know if there are any issues!

[@TheKrystolMethod]

@@PersonalFinancewithLeila Ok thanks!

[@nelibethgarcia25]

Do you keep track in any way your daily expenses? or just weekly/monthly?

[@rogerwillis7692]

I prefer your instructional spreadsheets. Maybe an Excel video, next??

[@PersonalFinancewithLeila]

Thank you! Unfortunately I don't use/have Excel!

[@gigi4874-w3w]

The hair is looking pretty.

[@PersonalFinancewithLeila]

Thank you! 😊

[@SummerSunset2207]

How did you formulate the exclude debt and savings line? Can you add that to your template?

[@PersonalFinancewithLeila]

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!

[@ronmark7336]

And can i quickly update my spreadsheet from my phone after i buy something like , Gas , food etc.??

[@maidarosimerigunzert7042]

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.

[@maidarosimerigunzert7042]

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.

[@PersonalFinancewithLeila]

Yes! I should have mentioned that is another reason why I love my spreadsheets in the video!

[@hyt1305]

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 😂

[@PersonalFinancewithLeila]

😂 I'm not sure how many tabs they'll let you have, I would assume it's unlimited!

[@MotivasiSukses-Ikigai]

A car is a liability :) I also don't count it as an asset

[@PersonalFinancewithLeila]

For sure!

[@LucyGriffithsdotcom]

Great video content, very informative...!

[@PersonalFinancewithLeila]

Thank you! 😊

[@angelanderson7577]

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?

[@PersonalFinancewithLeila]

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.

[@angelanderson7577]

@@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 🙂

[@marialesdiaz5130]

Is there a reason you're saving for the student loans rather than paying them off? is it better for your credit?

[@PersonalFinancewithLeila]

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!

[@Manelly]

Why did you decide for the Roth IRA, instead the traditional 401K!? Curious! 😇

[@CaliWalli]

Some jobs don't offer that, like people hired as an independent co tractor for example

[@inea-fijourney22]

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.

[@Manelly]

@@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!

[@inea-fijourney22]

@@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 😅

[@Manelly]

@@inea-fijourney22 Thank You!

[@adriancanning1783]

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.

[@PersonalFinancewithLeila]

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!

[@adriancanning1783]

@@PersonalFinancewithLeila Sorry but am having trouble seeing your email address.

[@adriancanning1783]

@@PersonalFinancewithLeila I emailed you just over a week ago, not had a reply yet.

[@PersonalFinancewithLeila]

@@adriancanning1783 hi Adrian I never received an email! I also checked my spam. Can you please re-send to [e-mail] ?

[@billpooni2294]

Spreadsheets

[@brickinvesting]

niceeeeeee

[@VideoEditor223]

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 KZbin 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