Google Sheets Budget | Add a Savings Account | Personal Finance

Google Sheets Budget | Add a Savings Account | Personal Finance | Zero Based Budgeting

Рет қаралды 25,887

Күн бұрын

**MY #1 Selling Budget Template (NOT THE TEMPLATE IN THIS VIDEO)****
www.etsy.com/listing/1252378574/
This video, description
This video shows you how to add a savings account to your 1 Year Google Sheets Budget from my previous video “Budget Spreadsheet | Google Sheets Budget Template”.
Formulas:
=Query('Final Tracker'!A:E, "Select A, B, C, E, D Where C='Transfer to
Savings' OR C='Transfer to Checking'", 0)
=IF(C3="", "", Sum(F2+D3-E3))
*BEFORE YOU WATCH: ensure you watch the first video in the series…
Budget Spreadsheet | Google Sheets Budget Template | Personal Finance Tips
• Build Your Own Persona...
Other Resources:
Excel University (Simple Sheets):
www.simplesheets.co/a/2147491...
Pre-Built Spreadsheets (Simples Sheets)
www.simplesheets.co/a/45451/Z...
#Budgetspreadsheet #Personalfinance #Savemoney

Пікірлер: 81

@Medalea 2 жыл бұрын

Thank you so much for the budget sheet video. I use the sheet daily, and I finally have some oversight on my finances! Going to try out the savings account as well :)

@de6klompjes108 7 ай бұрын

I struggled a bit to much adding this 😂 but I figured it out so im pretty proud of myself and seeing the whole year ahead gives so much peace of mind.

@jdanpey 10 ай бұрын

Your system is SOOO helpful and allowed me to save big bucks from having to renew Quicken every year. Thank you!

@headsdownjumper 2 жыл бұрын

I’m glad you did this I was wanting to add savings and brokerage accounts to my version of your annual budget

@elizabethhills6460 2 жыл бұрын

Wish I would have discovered your channel sooner! Great video. Thank you for providing this amazing service!

@higheight 2 жыл бұрын

This is brilliant, thank you! In the process of getting mine set up for use - I think it'll be a great tool. Have you considered adding something whereby you could set a budget for the Other Expenses (such as a groceries budget for example), and track your actual spending against it? It should be possible to set some formatting to show when you've spent over a set amount, but being able to amend a budget dynamically would be a great addition to this.

@acemakerjay 2 жыл бұрын

I’ve learned a lot so far and have subscribed. Thank you!

@johnward5680 Жыл бұрын

I love this spreadsheet and your method of teaching. I have been building and using a spreadsheet of my own since 2020. But after seeing this, I've implemented a similar spreadsheet to use. I have of course included things I need like a schedule for direct deposits in the savings account and a minimum balance alert on my checking account, so I know how much I can spend. It is brand knew and requires further testing, since a lot of this is new to me, but it looks to be functioning correctly.

@edebrah 2 жыл бұрын

Love the google sheets videos! This is helpful, thank you!

@whyworksmarternotharder 2 жыл бұрын

Great! Thanks

@ChrissiesPurpleLibrary 2 жыл бұрын

Thank you so much! This was so easy to follow!

@cinnathweet3743 2 жыл бұрын

Great Google Sheets videos!!

@GermanLarez 2 жыл бұрын

Awesome content!

@Ellie-ir7mn 2 жыл бұрын

So helpful thankyou!

@phok3401 2 жыл бұрын

I've been enjoying your videos immensely. How do you track credit card purchases and integrate into your expense tracking?

@lesimmeublesvspinc8580 2 жыл бұрын

great vid

@jimtaylor5697 2 жыл бұрын

Love both these videos about how to set up your budget.. I know its a minor detail, but how can you add something as small as "interest" into your query w/o it getting added to your checking account?

@lacysrhr Жыл бұрын

Awesome

@monicawashington4802 Жыл бұрын

Great

@raymondgeorge4542 Жыл бұрын

This is brill.

@bizumasresha1125 2 жыл бұрын

finally the waiting is over lol thanks dude 🙏🏾

@whyworksmarternotharder 2 жыл бұрын

I appreciate your support! Glad these are working for you!

@Anthony_Culotta 9 ай бұрын

Great videos would like to see a tracker to implement credit card tracking as well.

@azizabduev4534 7 ай бұрын

Great teaching. I love it easy. Can you add credit card.?

@bucketlady 2 жыл бұрын

Hi! I really love your Google Sheets Budget Template! I was just wondering, if it is possible to add a sheet where you get an oversight of your expenses by categorie every month of the year? So you can see how you are doing? Thanks!

@joanna2469 2 жыл бұрын

Can you do a video on credit card accounts and payments?

@debravandriesen8988 2 жыл бұрын

Thank you for the budget sheet. How would you add interest made on savings into your savings account sheet?

@daniellataa7255 2 жыл бұрын

Hi. I really appreciate your tutorials, it lets me to keep track on my budget. I have jut one issue. Is there any option to add spendings from my savings account, that are not included in final tracker? I needed to transfer savings to checking, and my bank is charging it, and i knot how to store it in my budget tracker.

@AnthonyMeyers-v4o 16 күн бұрын

This is a great tool to use. If i have multiple income streams and would like to understand when certain funds are put into categories, then the bill gets paid, how can i utilise this chart and graphs to visualise this?

@cyclepete694 2 жыл бұрын

Hi, this looks pretty awesome. I hit a road block though when trying to add the data from from a bank csv download rather than typing all the data in manually. When I import, I get the date and description to feed through but the amounts don't.! Any thoughts please?

@johntakacs7037 Жыл бұрын

Thank you for the template. This is something I needed to do for years. Is there a way to add in my credit cards so I can track the transaction by category?

@gilwoode Жыл бұрын

I don’t know I’m doing wrong. I keep getting #N/A once I hit enter. Before I hit enter I get Query completed with an open output the arrow is pointing right in front of the first C=‘Transfer to Savings.. I’ve started over several times and I can’t figure it out. Does the error have something to do with my main spreadsheet because it works perfect.

@thunderingbuffalorios3954 Жыл бұрын

Ever find out how to fix it? I'm having the same issue.

@user-pk2ex8zr3r Жыл бұрын

Can you do a video that would show the interest made on a savings account or on a Roth IRA as you deposit money each month or week?

@TheMattRedstone Жыл бұрын

I really appreciate these videos. I'm looking forward to implementing this budget into my life I have one question. How would you put a credit card page on, or does that complicate things unnecessarily? I was just thinking it would be nice to track the running total, while syncing the payments made with the rest of the program. Edit: apparently I should've read the comments, cause I'm not the first to bring this up

@johnward5680 Жыл бұрын

I believe trying to track a credit card balance would as you say complicate things unnecessarily. Use card statements and focus on paying more than minimum.

@maximus4691 Жыл бұрын

What do I do for expenses like groceries, gas, spending, etc that vary each month. Do I just put it in the other expense tab and constantly update it through each purchase? I guess I’m also confused on how I can track how much I’m set to have by the end of the year, do I create a set budget for myself to give me an estimated number and then not got over that

@danac2491 2 ай бұрын

Do you have a step up version of this to include a savings allocation?

@kqxx 2 жыл бұрын

Thank you! I'm always looking ways to improve my budget sheet [EDITED] I'm currently using google sheets. Do you by any chance have a tutorial on creating a simple overview chart to showcase an overview spending categories for each month?

@whyworksmarternotharder 2 жыл бұрын

I would watch my data studio budget video!!

@antonlindberg7117 2 жыл бұрын

Thanks for the addition. My only concern right now is when I'm lacking data to go on.. Is it possible to start from a clean state and let the upcoming incomes/debits act as a starting point for next month?

@michellemurphy6300 Жыл бұрын

Same question here.

@michellemurphy6300 Жыл бұрын

How do you create sheets for multiple savings accounts? I have 3 and I followed this tutorial, but now all 3 are under one savings page.

@cullanlee3797 5 ай бұрын

Would this process of adding savings work on the “Budget Smarter_Extended version template?( paid version) Or is there another video somewhere for that?

@Drizz1717 Жыл бұрын

What if I use Vaults in my savings account, to park my money, before I transfer it back to checking account to spend money?

@rhoshe9629 Жыл бұрын

Everything is working perfectly with the exception of my Transfer to Checking in my Other Expenses sheet not showing up on my Savings one, could you help please!?

@vegardbrueckmann4754 9 ай бұрын

Is it possible to setup several accounts using this method? How would I go about this?

@kathleengalo8959 Жыл бұрын

Thank you so much for your videos. I really, really love the budget tracker and I am trying to add the savings with this video. I had no issues with the budget tracker formulas, but when I use this one, I get the error "QUERY only takes 3 arguments" and it says I am trying to use 7. Any insight into what I might be doing wrong?

@whyworksmarternotharder Жыл бұрын

Hmmm. Can you paste the formulas?

@kathleengalo8959 Жыл бұрын

@@whyworksmarternotharder I must have had a typo somewhere - I followed your directions again and typed REALLY carefully and managed to get it to work! User error I am sure. :)

@Armiller713 2 жыл бұрын

Hi! I just watched your other tutorial (part one) and am finishing up with this one right now. I had put in a fixed expense for transfer to savings, which is what you had done in part one. Is there a way to get that to go to the "Savings Account" tab, or do I have to refile/log all of the savings from "Fixed Expenses" all under "Other Expenses" for this to work? I get my fixed amount taken out for each paycheck so it makes more sense for me there instead of in "Other Expenses." Thank you!

@whyworksmarternotharder 2 жыл бұрын

Fixed expenses will work just as good

@Armiller713 2 жыл бұрын

@@whyworksmarternotharder But is there a way to get my fixed expenses for my savings account to go to the Savings Account tab on the bottom to add to the running total for my Savings Account balance? Because right now it’s just taking from the other expenses tab.

@johnward5680 Жыл бұрын

@@Armiller713 You need to add fixed expenses to the query function on the savings account tab.

@lewiswitcher6992 2 жыл бұрын

This is great! But I had a question on how if you could track multiple savings accounts? Would you just create another tab for another savings and follow the same process on this one?

@adrnpz Жыл бұрын

Have this question as well! What was your solution?

@michellemurphy6300 Жыл бұрын

Same!

@jonatanpalmvig6771 6 ай бұрын

=QUERY('Final Tracker'!A:E; "SELECT A, B, C, E, D WHERE C='Transfer To Savings' OR C='Transfer To Checking'"; 0) Remember to mach "Transfer To Savings" and "Transfer To Checking" that was put in the sheet called Lists.

@jamessolomon3467 2 жыл бұрын

I have an excel/sheets question. I'm working on a budget. I have a checkbox in Cell A1. B1 contains a number, 100. In a 3rd cell (B15) I have a sum of all my numbers, lets say they equal 1000. I want to be able to check the checkbox in A1 and it takes B15's total and subtracts the number in B1 automatically changing it to 900. Bonus points if you can get it to change to a color once checked. Can that be done? I know conditional formatting can change the color, but I'm not sure how to write the formula for the subtraction function and then link it to the color change.

@whyworksmarternotharder 2 жыл бұрын

I would say check out my IFs formula video and then set conditional formatting after that. Check boxes work off of a True/false context.

@jonmc6573 3 ай бұрын

But savings accounts accrue interest... where does the interest go?

@gerridbarnes5205 2 жыл бұрын

I'm kind of late to the game here, but when trying to add into the formula for multiple savings accounts, any transfer to checking from any of the savings accounts sheets is showing up on all three of them. Any tips on how to avoid this?

@brettstewart1550 2 жыл бұрын

I have made the categories more descriptive i.e. 'Savings to Checking' and using those in the formulas to avoid this kind of problem

@hasole9669 Жыл бұрын

Has anyone worked out how to add interest to the savings account?

@jeffbulnes2449 2 жыл бұрын

Thanks man, I don't mean to throw you off, but wha is I have multiple savings account?

@whyworksmarternotharder 2 жыл бұрын

Have those options in your drop down list. And then have two sheets (one for each savings account). Then set up a formula with ‘transfer to savings 1’ and ‘transfer to savings 2’

@haileymaurer122 Жыл бұрын

The first spreadsheet from the previous video worked perfectly. I have checked spelling, cases, selections over and over again, and the formula just does not work.

@NicPollard-Ingram Жыл бұрын

Having trouble with the first query, all spelling is ok, keeps giving N/A empty output message. Any one got any clues or have had this issue.?

@NicPollard-Ingram Жыл бұрын

=Query('Final Tracker'!A:E, "Select A, B, C, E, D Where C='Transfer To Savings' OR C='Transfer To Checking'",0)

@darrongreer9134 2 жыл бұрын

SORRY I CANT GET IT TO WORK , TELL ME THE" FORMULA PAUSED " I'M IN THE UK

@bhavneshparikh8283 2 жыл бұрын

How can download this file?

@whyworksmarternotharder 2 жыл бұрын

Same answer as last time…

@bhavneshparikh8283 2 жыл бұрын

@@whyworksmarternotharder I know that same anser pl provide link for sample data

@fineone1987 2 жыл бұрын

i'm having issues with the 1st Query. when i place the code in i get "#N/A Query completed with an empty output" can you please help =QUERY('Final Tracker'!A:E, "Select A, B, C, E, D Where C='Transfer To Savings' OR C='Transfer To Checking'", 0)

@whyworksmarternotharder 2 жыл бұрын

Check for spelling and case sensitive

@fineone1987 2 жыл бұрын

@@whyworksmarternotharder IDK what i missed but it works now! Thank you again!

@fineone1987 2 жыл бұрын

@@whyworksmarternotharder thanks again for all your help! Would you be able to do another tutorial for the budget report graph, since I updated the Google sheet the graph says "Data sheet configuration error"

@IamXochipilli 2 жыл бұрын

@@fineone1987 How did you fix it? I keep getting the same issues

@nataliepauley2741 2 жыл бұрын

@@IamXochipilli check case sensitivity for "To" instead of "to"