Gabby, thank you so much for this video and this tracker! I’ve been on the hunt for a tracker that has all of this so I’m incredibly impressed and excited to use this tracker!!
Impeccable timing! Just started filling the tracker last night so i'll follow along to finish the set up! I appreciate your tracker for the spreadsheet illiterate such as myself 😂
Hi thank you for this video! What would you recommend doing if you pay some of your bills with credit cards and some with your checking. Ive listed them in my transaction tracker and allocated the bank accounts/credit accordingly. However I am struggling with the budget overview, I understand that the credit expenses doesn’t get subtracted from the total. And that the bills is subtracted. However since im using credit cards also for some bills won’t that throw off the numbers and add some bills twice? Not sure if this makes sense. I’m just a bit confused and not sure where to go from here. Any help would be greatly appreciated! Loving the template otherwise.
@@cozmiiika Yes, Thank you for your comment. Glad to know it isn’t just me. I was unsure if I was just missing something. Hopefully there is a solution!
@@AlexaSchirmer hi! Yeah I feel you, I pay some bills with credit and some with cash so I have this same thing. For budgeting purposes I don’t mind, it will say I have less than I do so I am happy to have the extra money. Plus with the account balances at the top I know where I stand. However if you want an accurate budget what you could do here is move some bills that are always on credit to the expenses section, so they aren’t double charged. I personally don’t bother and leave as is, total it’s a small percentage of my overalls bills on credit and I’m happy to have the extra money as a buffer. Or you could subtract off the bills on credit from the bills line in the budget overview where the totals are happening. Few ways around this.
@ Thank you ! Yes I was wondering because I can’t pay rent with my credit card 😂 . Loving the template btw I’ve downloaded so many over the years and this one feels revolutionary for my finances . 🫶🏻
Question - under debt set up - Where I have my mortgage, it says monthly payment. my payments are weekly. Any way to change that as some months i pay 5 times
@@dh1743 yes I would recommend setting up 5 mortgage payments in this case one for each potential one, then the monthly amount will be your weekly amount! I’d do like Mortgage 1, Mortgage 2 etc.
sorry if this is a dumb question 😅 but is there a way to change the color scheme? Just curious to know if I can make it my favorite colors or if I would have to do it manually? Thanks!
No such thing!! You can change the color scheme with the theme in google sheets, however there are a few colors used throughout that aren't from the theme since there are only a limited number in a theme. You can change most of them very easily, but there will be some manual effort still after to fully change them.
3:03 - do you then suggest that folks who use credit and debit interchangeably (not strict on one or the other) use the debit tracker? I think I'm misunderstanding still. Thanks!
It really depends, there are pros and cons to both if you are split down the middle. Credit version: budgeting assumptions are you spend on credit and won't deduct expenses, so if you have a bunch of regular cash spending I would try to account for that in the debit expenses line of the budget overview. Example if you spend around $500 a month on debit, then add $500 to the debit expenses line. Otherwise when you actually log expenses you can charge to either cash accounts or credit accounts. Debit version: Budgeting assumptions are all expenses are paid on debit and then are paying down a credit balance, so if $500 of your expenses are on credit, you could be double charging yourself once when you pay on credit and again when you pay down your credit balance. To avoid this you'd have to track how much you spend on credit, remove that from the expenses table and log in the credit expenses line of the budget overview table. I personally recommend the credit version, I have a few expenses on debit or cash every month and it all works out.
My only question is, I updated my income but I don’t know why on the monthly view oh the top tab it shows a total amount that’s not right. I’ve checked the input in the tracker but I can’t find what is wrong
Hi! I can hopefully help, is this the value at the very top of the monthly tab? That value reflects actual logged income in that month. Does that line up with the amount in the income table? You can send me a message on etsy and we can sort out what the problem is.
@@natalieshelswell3247 very similar! The savings account balances are new, along with more accounts with balances. New visuals, the net worth tracker is new, and the goal tabs are reformatted. But otherwise very similar, not necessary to get the new one if you don’t need these features.
Hi lovely, when I enter my budget amount for expenses in Jan tab, it doesn’t effect the “left to budget” so I found I have over budgeted and can’t get it to work 😢
@@Channyreads hi! Are you using the credit version? If so, I explain in the video but expenses for this month are not deducted from income ONLY credit card payments. So after budgeting add how much you expect to spend to the credit card budget so you can check if it all balances out (if you pay your cards in the same month). If you pay at the due date, then you’ll need to budget credit card pay to be what you spent last month. Hope that makes sense
@@Channyreads hi! Unfortunately no, there isn’t an easy way to add more. I try to consolidate some of the bills together, so maybe subscriptions instead of each individual one.
Gabby, thank you so much for this video and this tracker! I’ve been on the hunt for a tracker that has all of this so I’m incredibly impressed and excited to use this tracker!!
@@CourtneySherven thank you Courtney! I really appreciate it. I hope you enjoy 💕
Yay so excited!!! I can’t wait to watch this after work ❤
Found your channel recently and have been loving your videos! I'm a huge budget/finance and spreadsheet nerd, so this was fun to watch!
@@John.McConnell welcome!! So glad you’re enjoying hahah I’m a budget nerd too 🤓
Impeccable timing! Just started filling the tracker last night so i'll follow along to finish the set up!
I appreciate your tracker for the spreadsheet illiterate such as myself 😂
@@J.D.Chopin great to hear! Hope this video is helpful 😊
This made me so excited and gamified my finances. Thank you Gabby!!!!!
@@nicoleconstante9172 so glad!! That was my goal 💕
just what I needed! Thank you Gabby!
Hi thank you for this video! What would you recommend doing if you pay some of your bills with credit cards and some with your checking. Ive listed them in my transaction tracker and allocated the bank accounts/credit accordingly. However I am struggling with the budget overview, I understand that the credit expenses doesn’t get subtracted from the total. And that the bills is subtracted. However since im using credit cards also for some bills won’t that throw off the numbers and add some bills twice? Not sure if this makes sense. I’m just a bit confused and not sure where to go from here. Any help would be greatly appreciated! Loving the template otherwise.
This is my exact issue that I've been flagging. Thank you for elaborating on your question. Hope we can get support from
@@cozmiiika Yes, Thank you for your comment. Glad to know it isn’t just me. I was unsure if I was just missing something. Hopefully there is a solution!
@@AlexaSchirmer hi! Yeah I feel you, I pay some bills with credit and some with cash so I have this same thing. For budgeting purposes I don’t mind, it will say I have less than I do so I am happy to have the extra money. Plus with the account balances at the top I know where I stand. However if you want an accurate budget what you could do here is move some bills that are always on credit to the expenses section, so they aren’t double charged. I personally don’t bother and leave as is, total it’s a small percentage of my overalls bills on credit and I’m happy to have the extra money as a buffer. Or you could subtract off the bills on credit from the bills line in the budget overview where the totals are happening. Few ways around this.
@ Thank you ! Yes I was wondering because I can’t pay rent with my credit card 😂 . Loving the template btw I’ve downloaded so many over the years and this one feels revolutionary for my finances . 🫶🏻
Question - under debt set up - Where I have my mortgage, it says monthly payment. my payments are weekly. Any way to change that as some months i pay 5 times
@@dh1743 yes I would recommend setting up 5 mortgage payments in this case one for each potential one, then the monthly amount will be your weekly amount! I’d do like Mortgage 1, Mortgage 2 etc.
sorry if this is a dumb question 😅 but is there a way to change the color scheme? Just curious to know if I can make it my favorite colors or if I would have to do it manually? Thanks!
No such thing!! You can change the color scheme with the theme in google sheets, however there are a few colors used throughout that aren't from the theme since there are only a limited number in a theme. You can change most of them very easily, but there will be some manual effort still after to fully change them.
3:03 - do you then suggest that folks who use credit and debit interchangeably (not strict on one or the other) use the debit tracker? I think I'm misunderstanding still. Thanks!
It really depends, there are pros and cons to both if you are split down the middle.
Credit version: budgeting assumptions are you spend on credit and won't deduct expenses, so if you have a bunch of regular cash spending I would try to account for that in the debit expenses line of the budget overview. Example if you spend around $500 a month on debit, then add $500 to the debit expenses line. Otherwise when you actually log expenses you can charge to either cash accounts or credit accounts.
Debit version: Budgeting assumptions are all expenses are paid on debit and then are paying down a credit balance, so if $500 of your expenses are on credit, you could be double charging yourself once when you pay on credit and again when you pay down your credit balance. To avoid this you'd have to track how much you spend on credit, remove that from the expenses table and log in the credit expenses line of the budget overview table.
I personally recommend the credit version, I have a few expenses on debit or cash every month and it all works out.
34:29 I can’t find the values in the description box. I might just be missing them, but if anyone knows please let me know. 🤗
@@RedheadSorceress oh you are correct I am missing them! Let me add
@@GabbyPeterson17thank you. 🤩
My only question is, I updated my income but I don’t know why on the monthly view oh the top tab it shows a total amount that’s not right. I’ve checked the input in the tracker but I can’t find what is wrong
Hi! I can hopefully help, is this the value at the very top of the monthly tab? That value reflects actual logged income in that month. Does that line up with the amount in the income table? You can send me a message on etsy and we can sort out what the problem is.
Hi Gabby
how does this spreadsheet compare to the previous one you made?
@@natalieshelswell3247 very similar! The savings account balances are new, along with more accounts with balances. New visuals, the net worth tracker is new, and the goal tabs are reformatted. But otherwise very similar, not necessary to get the new one if you don’t need these features.
Hi lovely, when I enter my budget amount for expenses in Jan tab, it doesn’t effect the “left to budget” so I found I have over budgeted and can’t get it to work 😢
@@Channyreads hi! Are you using the credit version? If so, I explain in the video but expenses for this month are not deducted from income ONLY credit card payments. So after budgeting add how much you expect to spend to the credit card budget so you can check if it all balances out (if you pay your cards in the same month). If you pay at the due date, then you’ll need to budget credit card pay to be what you spent last month. Hope that makes sense
@ oh ok amazing thank you x
@@Channyreads Not a problem, let me know if that doesn't seem to fix it.
@@GabbyPeterson17is there also a way to have more lines for bills in the set up tab? Xx
@@Channyreads hi! Unfortunately no, there isn’t an easy way to add more. I try to consolidate some of the bills together, so maybe subscriptions instead of each individual one.
Hello gabby.