Make a Sinking Fund Spreadsheet in Google Sheets and Excel

[@MrJamieGriffin]

Do you use sinking funds to help you save money? What are you saving for this year?

[@justin-cx7ni]

Great video. Yes. I use sinking funds instead of the cash envelope system for budgeting. I've opened up a free checking account with respective debit card for each sinking fund at my local Credit Union. I will use your spreadsheet to help me keep track.

[@MrJamieGriffin]

@@justin-cx7ni that’s amazing!!! So you have a separate debit card for each sinking fund? Qube money is also great for keeping your sinking funds and budget categories too with one debit card.

[@daniellem5175]

Thanks so much for the step by step. I was able to follow it and got my sinking funds spreadsheet set up!! THANK YOU!!♥

[@MrJamieGriffin]

@@daniellem5175 that’s amazing to hear! Glad to help and I hope saving just got a lot easier!

[@lamira32]

Thanks for sharing, I've been searching for a template to follow. Your guidance was simple and easy to follow, thanks again.

[@MrJamieGriffin]

Glad it was helpful!

[@nguyenhuunhattan1206]

Hey. It's really nice and helpful. Very concise and to the point. Keep it up, Jamie. You will be recognize soon

[@MrJamieGriffin]

Thank you! I’m glad it’s helpful! ❤

[@libbysworld7649]

Great idea. Thank you for sharing.

[@MrJamieGriffin]

You're welcome!

[@HomeschoolMamaJ]

This was so helpful, thank you!

[@MrJamieGriffin]

You’re welcome! Happy to help!

[@rpark89]

Thank you so much! This is just what I needed. Well done!

[@MrJamieGriffin]

You’re welcome! Glad it’s so helpful!

[@TheSwimmom1]

Shouldnt your account toal include your starting balances?

[@MrJamieGriffin]

It absolutely will if you include it in the formulas when you set up your spreadsheet. That way it will automatically calculate your totals including the starting balances.

[@gregedwards7895]

I know I’m just one viewer but, I can’t express how much I appreciated this video. This is really going to help my family get organized.

[@MrJamieGriffin]

You are so welcome! Glad it was helpful!

[@gregedwards7895]

@@MrJamieGriffin Do you know how to link bills/payment dates from a Cell on Excel/Google sheets to a calendar (either in excel or on the desktop). I made a bill payment tracker in excel, but I wish I could see it in a list calendar format or be alerted of it. Thanks

[@MrJamieGriffin]

@@gregedwards7895 I actually saw your previous comment and was just looking into how to do that. I made a note to try figure that out and make a video for it

[@gregedwards7895]

@@MrJamieGriffin that’s great. I’m setting your post notifications on right now!

[@sabrinasalem6674]

Thank you! Very easy to follow and will be helpful to achieve my goals.

[@MrJamieGriffin]

@@sabrinasalem6674 that’s awesome to hear! Happy to be able to help!

[@anisyuhadah]

the addition part is fine, but im quite confused on how i can track the subtraction when i use the funds

[@MrJamieGriffin]

@@anisyuhadah great question! For subtraction, you have to do some manual math to determine the net deposit for the sinking fund. So if your monthly deposit for your travel sinking fund is $100, and you spent $250 for a weekend getaway, you would type -$150 into the cell for that month. Then the formulas you have set up will automatically calculate your new total for the sinking fund.

[@onepieone]

It's similar to what I have already done, but I like the total account in savings part. I have them too but I just put in alongside my goals row which can get confusing... but then I'm the only one who has access to it anyway so it doesn't matter 😆I would like to point out that you did not add in the balance you have, so the total in savings accounts would then be short of the opening balance, unless you want to track the amount added for the year only.

[@MrJamieGriffin]

That’s a great point that I missed. Thanks for pointing that out. For anyone watching the video and reading this comment, please do add your current bank account balance in factor it into the formula for the Total in Savings.

[@JakeDenning]

Heck yeah. Thank you for taking the time to map this out. I would LOVE if you did other videos like this with Google Sheets.

[@MrJamieGriffin]

I love making google sheets tutorials. Are there any type of spreadsheet or budget tool you’d like to see me make?

[@gregedwards7895]

What about a bill pay tracker that automatically links to a calendar 📅?

[@metapixusion]

Love this! Thank you

[@MrJamieGriffin]

You’re welcome! Glad it’s helpful!