How To Use My Debt Payoff Tracking Spreadsheet
HTML-код
- Опубликовано: 21 авг 2024
- #debtfreejourney #debtpayofftracker #googlesheets
It's here! My debt payoff tracking spreadsheet is now available for purchase on my Etsy shop!:
tidd.ly/3H6boXr
This video is an in depth tutorial on how to use my debt payoff tracking spreadsheet in google sheets. It is an instant download in my Etsy shop. I am so excited to finally share with you the spreadsheet that I have been using for the past year to help my husband and I stay organized and focused during our debt free journey. If you are watching because you purchased the spreadsheet, thanks so much! I hope you find it to be a valuable tool during your debt payoff journey!
At the time that I'm posting this video, my husband and I are working on paying off over $300,000 of debt, which consists of credit card debt, a car loan, and mostly student loans. I post monthly debt payoff updates so subscribe to my channel if you want to follow along with our debt payoff updates!
Here is my SoFi affiliate link if you want to refinance your debt, lower your interest rate, pay down your debt faster with me and get a $300 CREDIT towards your loan: www.sofi.com/s...
My favorite financial books:
The Simple Path to Wealth by JL Collins: amzn.to/2KggZPy
You are a Badass at Making Money by Jen Sincero: amzn.to/37YNgTa
Thanks for watching!
xo,
Lo
**This video is not financial or legal advice. This is just me sharing my own experience with my debt and finances.
FOLLOW ME ON INSTAGRAM! / laurensmoneymindset
For business inquires or questions: lomills1017@gmail.com
FTC: This video is not sponsored. Some affiliate links are used, from which I earn a commission. This helps support and improve my channel. If you would like to support me, thank you, otherwise please feel free to search anything mentioned in Google. Thanks so much!
Get my debt payoff tracking spreadsheet here!: tidd.ly/3H6boXr
Can this be converted to use on Excel?
I don't have debt but I love spreadsheets so much that I needed to watch this tutorial anyway 😂
Love it! You did a great job on the spreadsheet!
That means a lot! Thanks so much!! 🤗
You probably dont give a shit but if you're bored like me atm then you can stream all the new movies on instaflixxer. Have been binge watching with my girlfriend for the last months =)
@Christian Gibson yup, I've been using InstaFlixxer for since november myself =)
Will you be selling a budget/net worth spreadsheet? I LOVE the color/design choices you made with this one and would 100% buy a budget spreadsheet of yours. :)
Glad you like the colors and design! I am currently working on a net worth spreadsheet and have others in mind for the future as well.
Just what I needed thank you so much for this video will be purchasing the spreadsheet 😊
Thanks so much! Looking forward to getting our debt paid off together! 👏👏👏
I just purchased the spreadsheet. I am looking forward to using it to track my debts and how much I am paying them off. Thanks for this.
Awesome! Thanks for your purchase and I hope you love it!
@@laurensmoneymindset I do. So much that I purchased the monthly budget as well.
This is awesome! I love google sheets! I’m buying this! Thanks so much for setting this up!! Love the pic chart
Thanks so much! Hope you love it! 😄
Oh my goodness “I’m debt free!” I mean I am debt free a few months early, but I’m so happy! I’m on to BS3. I did pay off debt from smallest to largest, but they were both (visa and student loan) over 25K.
Congrats!! 🎉
Just bought it! Can’t wait to start using it!
Whoa you're a life saver!
I need this! Thank you.. going to purchase now!
Thanks for your purchase! Hope you love it!
Thank you for this! It's just what I needed!
Awesome! Good luck with your debt payoff!
Order the spread sheet today. THANK YOU
Thanks so much! Hope you love it!
I just bought a copy thank you 🙏
Hope you enjoy it!
Very good!
hi there lauren thanks for such a great video. Im having an issue in the payments and interest section. My payments show under month 1 and 2 but the interest doesn't calculate
Is there a place to enter the interest rate where it is calculated into the formula? I’m just wondering how it’s calculated in the interest paid box. I just bought the spreadsheet and I’m eager to get it started! Thank you for creating this.😊
Thanks so much for your purchase!! No, you don’t have to enter the interest rates. When you enter you balances at the beginning of each month, the spreadsheet calculates how much debt was paid off. Then, when you enter your payments you made throughout the month, it subtracts the difference between the payments made and the debt paid off, giving you the amount you paid in interest that month.
@@laurensmoneymindset Is the interest still going to be accurate for those times when extra payments are made? Thank you for making this available. I'm filling mine out now and was just curious
So I am curious how it accurately calculates the interest. How does it know if an extra payment was made? Or how much of the payment actually went to the the principal vs. interest?
When you put in your balance each month, it calculates the difference from the previous month, ie how much principal was paid off that month. Because you also enter your payments for the month, it also can calculate how much went to interest..total payments minus principal paid off = interest paid. Hope that helps!
Awesome job with this spreadsheet and video tutorial Lo! I’ve really been enjoying your videos and following along on your debt free journey. I saw that this spreadsheet is an instant download to google docs. Is there any way it can be downloaded to excel?
Thanks so much! I don’t have Excel so I can’t test it myself, but I asked a friend to try it and they said that if you open it in Google Sheets, then click “File” then “Download” and then “Microsoft Excel” then it opens and seems to work just fine! I like Google Sheets though because I can update and access my spreadsheet from my phone and my laptop. Plus I can share it with others (in my case my husband) so we can both update and review it.
Love your spreadsheet!! Do you have a link to purchase?
Thx! Here’s the link: www.etsy.com/listing/919076704/
Yay! I just bought a copy! Spreadsheets aren't my strong suit but I'm learning! My budget spreadsheet (from Frugal Fit Mom here on YT) is actually also on Google Sheets so I can stick to one simple platform and not deal with Excel or Numbers. I have one question before I start setting this one up. I'm in the process of changing banks and part of that is that the new bank is going to consolidate 3 of my debts which are at my old bank into one loan with a lower interest rate. Should I wait until I get my new loan and then start tracking my debt payoff? Or is there a way to start now and switch it over when I get my new one? Maybe 'pay off' the 3 old debts on the spreadsheet and add a new debt? Will that mess everything up? I'm not exactly sure when I'll be signing the new loan and I hate having to wait to start tracking. If you think of a way that I could do this, I'd love to hear it!
Thanks so much for your purchase! I think the simplest way to set it up, since you know that you will be consolidating 3 loans, is to treat them all as a single loan now on the spreadsheet. Just total the three loans and use the combined balance as the starting balance for that row and name it “Consolidation Loan” or something like that. That way when the refi is complete, you don’t have to make any changes!! So excited for you and good luck!
@@laurensmoneymindset Thanks, I hadn't thought of that option but I think it will be the simplest way to track while making the switch. Especially since I'm expecting the new loan to happen before the end of February... so really I'm just tweaking it for a month or two at the most.
How do you do step 6 on a tablet ?
Does it make sense to add a car loan if you are leasing? I ask because it's a fixed term with fixed payments. It will always be $xxx.xx every month for X months until the lease ends.
I don’t think so since you will have to return the car at the end so it’s more like a “rent” payment than a debt payment, if that makes sense
I wish this was an excel sheet not a google drive
I’ve had a few people purchase to use in excel and they haven’t had an issue. I just don’t have excel, so I can’t test it myself
how did you put the formula?
It’s already in the cell for the first month and you just copy it over for subsequent months
Ok, thanks! @@laurensmoneymindset
I'm in debt and you expect me to pay almost $20 to get speadsheets on finances??
$5.99 for this particular one, $14.99 for the bundle. Not sure if the prices changed, but honestly, it's worth it if it helps you get organized and paying off debt. It's the cost of a few fru-fru coffees.