Basic Budgeting with Google Sheets | Luke Floyd | Skillshare

Playback Speed

  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Basic Budgeting with Google Sheets

teacher avatar Luke Floyd, Aspiring daily, to fail at failing.

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

11 Lessons (1h 22m)
    • 1. Welcome!

    • 2. Google Sheet Basics

    • 3. Pay Yourself First

    • 4. Income Chart

    • 5. 50/30/20 Rule

    • 6. Expenses Pt. 1

    • 7. Expenses Pt. 2

    • 8. Pie Charts 8

    • 9. Monthly Breakdown 9

    • 10. Monthly Totals 10

    • 11. Variable Expense Chart 11

  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.





About This Class

Welcome to my first Skillshare Class!

If you are looking to learn how to create your own budget, or if you are looking to learn some new google sheets skills then welcome aboard! 

I'm aware that some of you may just want the completed budget! That's fine as well! Go to the class project tab and you will find a link to the completed budget (but you should still stick around to learn how to use it)!

Together, we will learn how to

  • Create a new google sheet
  • The importance of budgeting
  • The 50/30/20 Rule
  • Why its important to pay yourself first
  • Creating charts, borders, and functions
  • Conditional formatting



If you are looking for a accounting class filled with accurate terminology I would recommend checking out some of the other classes on here. Everything I am going to teach you is based in personal research and experience that I feel could be beneficial for plenty of people!


Meet Your Teacher

Teacher Profile Image

Luke Floyd

Aspiring daily, to fail at failing.


Class Ratings

Expectations Met?
  • Exceeded!
  • Yes
  • Somewhat
  • Not really
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.


1. Welcome!: Hello, friends and welcome to personal budgeting with Google Sheets. My name is Luke. I've been using Google Sheets on and off for the past several years on I've been budgeting for about as long as that. I've had a lot of very candid conversations with friends recently about personal budgets and finances, and what I found is a lot of people were a lot like me, and in the sense that they had a vague idea of how much they were making, they also had a vague idea of how much they were spending. But they didn't have a way to really to really track that. Ah, personal budget should be documented. Way to track your income, your expenses and your savings. I feel like I found a really good way to do that with Google Sheets on. I'd like to show that to you today. Now, this class is gonna be a little bit of an introductory course into Google Sheets. I'm not gonna be showing you too much, just really what we're going to need for this class. There's some great tutorials I found on skill share that you can also go through that teach personal budgets and also teach Google sheets and excel. So if you've never used Google sheets or Excel, hopefully I'm gonna convey just enough information that you can use for the rest of the class. If you've never made a budget before, this is an introductory class for you as well. This will show you the basics of personal finances, how to track your income, how to track your expenses and then how to track your savings as well. So without further ado, let's get started. 2. Google Sheet Basics: So let's get started with a brief introduction into Google sheets. Now, if you've use Google sheet before you were, you've used Excel in any capacity. You could probably skip this tutorial unless you would like a refresher. I'm also assuming that you already have a Google account. If you do not, go ahead and make one for yourself now and get to the Google home page and we'll start from there. All right, so we're on the Google home page. If you're like me and you use Google sheets a lot, you'll see that it will pop up down here and you can go ahead and click on that. If not, what you're gonna want to do is navigate over here to the top right to your Google maps. You're gonna want to scroll down to documents, scroll all the way to the top left side of the screen, click on menu and then select sheets. And now we are in Google sheets up of the top. You'll see templates, and at the bottom you're going to see your most recent documents. Now you notice at the top you have two different budget options. You have annual budget monthly budget. I've tried both, Um, personally, I don't really care for the layout. In the look of them, we're gonna create one ourselves that I think is a little more intuitive. So to start a new document, click Blink, a new spreadsheet will open in the top left. You're going to see the document name currently titled Entitled Spreadsheet. You can click right on that name and edit it. We're going to change this to our budget. All right, So the document is titled Let's take a look at Google Sheets. First, all these little rectangles or card sells its in these cells that we will be adding all of our data and titles, the cells air sorted by lettered columns and numbered rows. So, for example, the uppermost left cell here is called a one, while the one below it would be a two and so on and so forth. To edit two cell simply select the one you want to change with your mouse or arrow keys on type, whatever your heart desires. So in this case, I'm gonna take function, and we're just gonna do a pretty rudimentary chart year, okay? And sell a two. I'm gonna type 100 and in South a three, we're gonna type 200. Just click off that once we have a few cells with data, you can do some interesting things. First, we can use functions to add, subtract, multiply or do whatever we would like with these numbers to do a function Select cell a four. So we're gonna select this one here at the bottom and type equals. This tells Google sheets that we are about to enter a function cell. A four in this case is going equal whatever we type next. So we would like to find the some of these two numbers so 100 plus 200 weaken type equals and then type some followed by parentheses. And then we can select these two cells by selecting one and holding announed shift to select the other one. Once we're happy with their function, we can push enter. You'll see that 100 plus 200 now equals 300. We could even change the value of the two above cells to change the value of the sums. Let's change. Sell a two year to 300 and you'll see that the sum now equals 500. We can also make other cells equal the values in other cells. So if I were to scroll over Teoh Row, I'm sorry column B and wrote to and I type equals and then I just select one of these cells were gonna select sell a two and then call center. You'll see that now equals 300. And then just to verify that this cell will equal this cell, no matter what, type 100 again and you'll see that sell a to now equals 100. And let's say that I'm not happy with this formula here on. I just want to go get rid of this, uh, dysfunction. I can select it, and I could push backspace to delete it. Let's say that actually, I really, really wanted that 100 there I can undo by holding down control on then hit Z on my keyboard, which will undo if you're on a Mac, could be Command Z. If I want to redo deleting instead of pushing to lead, I could also push command. Why those functions for undo and redo or up here? That's thes two eras. All right, so let's make our rudimentary chart Look pretty, and then we're gonna go over our toolbar. Eso first thing I want to do is select all of these, and I can select every cell by holding shift and clicking. I'm just gonna hover over this box until the hand tool arrives and I'm gonna click. And now I can drag myself to ever I would like them. I'm just gonna move him over here into column B and let's go over the toolbar. So you have undoing Redux. As I previously mentioned, you also print You also have pain format which were never going to use. I know some people who like it. I don't necessarily care for it. You have zoom so you could zoom in. You can zoom out. You have format as currency is a very quick way to format all of your numbers as currency. If you're doing it for accounting purposes, we're just gonna do that. You also have format as percent. Once it's format is percent. You can also increase or decrease decimal spaces. We're gonna undo all that to get back to how we had it before. You have more formats as well. That's the one that we're gonna be using, which is accounting. And in fact, since we're gonna be setting up this entire sheet as an accounting sheet, you can come all the way up to the furthest left rectangle in between the rows and columns and select it. And what that does is select every single cell. You can come over here to the 123 also known as more formats scroll down to accounting and click it. And now you'll see if I type even all the way in the center over here, it'll automatically format as accounting. You can change your text. So if you want, you could for some ungodly reason, it's like Pacific, Oh, to be your title or impact to be your title or Georgia to be your title. We're not gonna get too much into formatting. But let me just say that if you pick anything that is not Ariel Harry, you try and pick something fun. You're gonna confuse yourself very, very quickly, so I just stick with something plain, especially for a budget. You make that text bold. You can make that text italicize you can strike through. You can also change the color of your text. If you would like Teoh, you could even increase the size eso In this case, we're increasing up to 14 and I'm gonna change the text back to black. Now, let's say you want Teoh really make these cells pop. You can also change the background color by clicking Phil Uh, Phil Tool who? Which looks like a little paint bucket, and you can select any color you want. So I just picked a bright red so it really, really jumps out and also makes it very, very hard to read. I selected kind of like a yellowish color there on. Do you know, we're just gonna go back toe white because all of those sucked. All right, we can also merge. I'm going to skip ahead a little bit. Teoh this merge cells so that takes a couple of cells and emerges them together. So in this case, I won't emerge A and B. I'm selecting both cells once again. Amusing shift to select both of those and I'm going to click. Merge. You can center your text just like a candidate. A word document. So just by selecting your horizontal line tool here, you could do it left center or right. You can also increase the sizes of rows and columns. I know I'm kind of jumping back and forth here, but in order to show you what these next couple of tools do, I have toe increase and decrease the size of Rose s. I'm gonna drag this down and you'll see that my function title is at the bottom of the cell . Now, if I want to vertically align it, I can select this vertical line tool here and I can align this to be up at the top. I could line it to be in the center and I can align to be at the bottom. In this case, I want to be the center. And now this. A lot of space here in this row I can resize rose by just a double clicking in between the space on the two rows. You'll see it highlights blue double click and now the row is sized to whatever the largest , largest text iss, I guess if that makes sense. So like for example, if I were to type, it's just type function again here, and I were to drag out the row on Let's center this again with the vertical lying tool. You see, I have two different size fonts. If I were to double click on the road, it's still going to size it to the larger size. It'll never size it to the smaller size, and we don't need that. Someone pushed a week. All right, you also have text wrapping. So in the further Most left column, the A column. I'm just going to type a couple of random notes. Here's we're gonna call this birthday money. And next what? We're gonna type the best Christmas present ever exclamation point, and you'll see that the text gets cut off by the cell. Now, as I just taught you, you can come up here in between the two columns and double click, and that's automatically going to resize your column. But in this case, let's say we don't want to resize the column on. We just want this text to wrap conveniently enough. There is a text wrapping row eso. What I'm going to do is select he Earth. I'm sorry, a text wrapping tool. You're going to click text wrapping and you're going to select wrapped in the center. You'll see it didn't do anything. That's because we had our column resized. Now, if I click the column and drag it over, you will watch the text wrapped inside the cell. And now I can really move this column anywhere. I'd like it in. That text is automatically going to wrap. Keep in mind, though varied DoubleClick and size. It'll size it to what it thinks. The best format is for wrapping butts, no longer going to size it all the way out to here, for example, because it doesn't need to. The text wrapping tool basically renders this obsolete eso. We are not going toe. Actually, don't believe the text wrapped. Why not? Let's just drag this back. And you know what? I want to label this bottom roast. We call this total right now. Let's say we want to make this chart look pretty. You can highlight the entire chart and you have some border options. If you click on borders, have you all borders? You could do just center borders. The crosses you can dio just the horizontal borders. You could do the vertical borders. You could also do outside borders left top right and bottom or you can click this button right here, which is going to just be all outside borders. It also changed the border color and you can change the border style. We're going to ignore both of these. So go ahead and click on Borders and you will see that we have a very simple black border that shows up on the outside of our chart here. And let's say that we want to do a fill. So this chart really jumps out. You can highlight everything again. Come up here to your fill color. If you remember, this is how we change the color of cells and we're gonna go down to alternating collars and alternating colors. Makes this very, uh, stop basically pretty looking alternating color. Fill on all of the cells when it selected. You can change the colors and you can come in here and really change. Um, the details of the alternating colors. So personally, I like the preset. So we're gonna leave this blue, and we'll all We have a very, very simple chart where I can change any of the totals inside. It's automatically going to summit in the bottom. One thing I forgot to mention is with functions. There is an almost unlimited amount of functions that you can do, and Google sheets were primarily going to be focusing on some. We're also going to be doing a little bit with subtraction and division. But let's say I wanted the the top cell to be subtracted from the bottom self. I could do equals, and I can select up here. By the way, notice I'm doing everything in this function line right here instead of in the cell. That's also an option as well. So just keep that in mind. This correlates to this, and I want be to subtracting so 50 subtracting 100 and push enter. You'll see that the county, By the way, if you're not familiar with accounting format parentheses means negative numbers. Eso we're now $50 below zero. So negative $50 Um or, uh, and if I change this to 50 you'll see that now we're 1 50 so there's a couple different ways to do functions. You could manually do it, or you can Google in my recommendation is you just Google different Google cheap functions , and you will get a massive massive list of functions almost anything that your heart desires engineering, financial, etcetera, etcetera. But like I said in this course, we're just gonna focus on the basic ones. Now let's say we want to get rid of all this. You can highlight everything and pushed elite, but you'll notice that all the formatting remains the same. What we want to get rid of all that formatting. So when we start our budget, we don't have any of this in the way you can select the columns or if you'd like, you can select the Rose by just selecting the rose and holding shift or selecting the columns and holding shift right click and come down to delete columns. And we'll tell you which columns you'd like deleted, and the columns are now gone. So I should give you a pretty basic run through on Google sheets. In the next lesson, we're gonna get started with our budget 3. Pay Yourself First: so I don't want to get too philosophical with this course because I'm not a millionaire. I'm not massively rich. I'm not a business owner or anything like that. But I do know a couple things about making a personal budget, and one thing that I want to make very clear on this is probably the most important thing. And it's also going to sound very, very profound is when you're making a budget. The first thing you want to do is pay yourself first. Now you're probably saying yourself, Well, Luke, that's what getting paid means is basically paying yourself. You're exchanging your time for money, right? Well, paying yourself first is also kind of a philosophical concept when it comes to budgeting. Uh, and I mean it like this. Like, let's say you have a lot of expenses and you're worried about those expenses on a regular on a regular basis and moment you wake up. You're worried about all the bills that you have to pay it all the money you already owe to other people. Well, if the first thing you do when you get paid is you pay off all of those bills, you start creating released. What it did to me is it creates this mentality of I'm not going anywhere. All my money is just going to these people. So why don't I treat myself and you get this moment mentality of okay? I have to treat myself. And what it did for me is I started overspending because thats weird logic of Well, if I spend my money before I send it to someone else, that's still in a way, it's my money because at least I'm getting something. I want out of it. I'm going out and I'm buying electronico. I'm going out to dinner four nights a week. Eso the ob The idea of paying yourself first is taking whatever you make, no matter what it is, no matter your financial situation, what expenses you owe or anything. And you're setting a little bit of that aside in a nest egg. Now my recommendation is you do it 10% 10% of everything you make. Put it into an account that you don't touch that your sacred account. It's not when you get paid, you're seeing your wealth grow. Even if you have all these other expenses, you still have this one little spot where you're in control of your money. So in that vein, in the next lesson, I'm going to teach you how to make a very simple income chart. 4. Income Chart: So in the spirit of paying ourselves first, we're going to make an income box on. Also, in the interest of full disclosure, I want to make it very clear that I've already done this budget several times. So if you see me jumping around with the formatting and you're wondering, how did you come up with this formatting so quickly? I did not going off of a guide that I have over on my other monitor Here s O which, by the way, I'm going to just take the finished product. We're gonna put in the skill share class. So if you didn't fall around accurately and you just want the budget for yourself, you go pick that. But if, like I said before, if you're wondering, how did I come up with that design so quickly? That's why it's because I am cheating off of my past self so. But that said, Let's pay ourselves first, we're going to title this'll net income, and we're going to merge it, and we're going to increase the title to 14 and we're gonna center it. This, by the way, is how I'm going to be doing almost every chart, so we're going to start with the title. We're going to merge it. We're going to century. We're gonna increase it to 14 all right? And now everything in the left column is going to be, uh whatever our income name is or whatever, When a classifier income as and then the column on the right are, see, Column is going to be the values of that income. So if you're paid by weekly like I am so every two weeks, you have to pay checks on the title, this paycheck one underneath the paycheck to I want to leave some on. I want to leave some room for additional pay. So maybe you pick up a side gig or you got a side hustle. Or maybe you get birthday money, whatever you want to use this additional income for your going to title, this additional income, they were gonna do one more additional income. And as we did in the previous lesson, we're just going Teoh size this column by selecting and double clicking Teoh properly size that calm, all right. And then we're just gonna leave a couple of spaces here and at the very bottom of the title this total. I like my totals in capital letters just really jumps out, and we're going to create a function here to sum up all of our totals. So for now, what I'm going to do is type 1500 1500 we're gonna leave the additional income blink. All right. Now, when the total we're going to do a simple some function equals some and make sure you put that in capital letters, parentheses, and then you're gonna select every single cell in this column, hold shift to make sure that it's all selected, you'll see the total that it's adding up here. That's correct. 1500 plus 1500 equals 3000 and you're going to push enter. We now have a very simple function where if I were to add anything into the additional income, it will automatically add at the bottom. So let's make this chart look pretty. We're going to select the entire chart and doing outside border, and because money is green, we're going to make our income green. So we're going to select the paint bucket, go down to alternating colors and select the generic green one. Now you have a way when you're doing alternating colors to create a footer. So if you come over here in a four footer and select it, you'll see that you have a foot or show up. That's slightly darker color than your alternating colors, especially when you have it such a preset. I do not like the footer colors. I typically don't, especially for total boxes. I like doing them or of a generic gray eso. I'm going to select the paint bucket. I'm gonna put like a light gray there. Well, Stuart, a little bit darker, and I'm gonna do a title or not a title. I'm sorry. I'm gonna do a border around my total box. And so now we have net income. We have our paychecks and we have our total. So in the next lesson, we're gonna go over the 50 30 20 rule, 50% expenses, 30% discretionary and 20% savings 5. 50/30/20 Rule: So as I mentioned in the intro, our budget is based on the 50 30 20 rule, meaning no more than 50% of our income should be going to expenses. About 30% should be going to discretionary spending, and about 20% should be saved. We're going to make it sharp That is going to keep track of how close we are staying to this goal. Eso The first thing we want to do is bring our income chart down here because we want the 50 30 20 rule to be at the top. That way we know what we're shooting for. And I'm gonna set this down a little bit further just to keep it out of the way. Probably doesn't need to be that far, but for now, that should be fine. As I mentioned before, all my titles are going to be following basically the same rule here. 50 30 20 is the name of this title Untitled rule amorous. Uh uh. We're gonna merge it across five cells. So 12345 merge. We're gonna center it, increase it to 14 point fun. And now, for this chart, we're going to do a couple of subtitles Don't leave the 1st 1 blank. But the next women a type 50% savings, 30%. Just part of my spelling, by the way. Very. And 20 percent say I'm actually remembering this is not saving. This is expensive. Let's make sure this is expenses and we're gonna make sure that all of the calm their size , you can highlight multiple columns and size them on the left. Most column You're going to type gold, and I like it in capital letters because it is our goal in actual on those will both get our attention and then this right, most calm in our chart. We're going to type total and I like everything centered. So we're gonna highlight everything, all the subtitles and just center it there. All right, let's looking pretty good So far, eso What we're going to do is figure out what this 3000 in our income chart splits up to. If we do 50 30 and 20 so we're gonna do some basic functions again. So we're going to select the first cell underneath 50% expenses and push equal, and we're gonna select that 3000 you'll notice that this cell now equals C 18. That's very important to note. So if you're selecting equals in a different cell, it's always going to say the cell title in the value of that cell. So this is Cell C 18 and we're going to multiply it by 0.5. So to multiply that is the Star Key, which is right over eight. We're going to hold shift, push the Starkey and type 0.5 and push Enter. We're going to do the same thing for discretionary. So equals C 18 and I accidentally clicked out. You can get back in by double clicking and you'll see that it just shows the value of the of the cell, which is the cell equaling C 18. Multiply it by 180.3 and we're gonna do the same thing to the savings so equals. And if you wanted to, you could just type it Now see 18. We're going to multiply it by 0.2, and we want to make sure that all this totals out to 3000 were into equals and Justus we've done before. Type some. You'll notice that it already entered a suggestion, and I found most of the time the suggestions air correct. In this case it is again. It's going to take the sum of everything from C four all the way to e four, which is exactly what we want to click that we're gonna push, enter, and we now have the total equaling C 18. All right, I'm noticing that this did not get set to the accounting formats. So just to make sure that everything is set to accounting killing King that most left rectangle underneath the underneath the function bar coming over here and changing it to accounting and this has now been format to accounting. All right, let's make this look pretty gonna highlight everything doing outside border. Select the paint bucket tool alternating colors. And I like this one to be blue. All right, so now we have our 50 30 20 will, And our goal for our budget should be having no more than $1500 in expenses with $900 of basically play money. We're discretionary spending, if you will free money that you could spend at your leisure and then 20% going into savings that we're gonna do our best not to touch and just keep long term. All right, So for our next lesson, we're gonna get into everyone's favorite part, which is expenses. 6. Expenses Pt. 1: all right, so now we're at everyone's favorite part, which is expensive. I No, I'm saying that a little bit facetiously. But honestly, I found that the more open and honest I am with myself about expenses, the better my budget actually does. Now there's a couple different kinds of expenses on a couple. Different, I guess, times that they need to be paid. You have, of course, weekly daily, sometimes annual and monthly expenses. We're gonna break down our expenses in a monthly and show you how to do that on Google Sheets on. Then there's also constant invariable expenses. Now. Constant expenses are the expenses that you already know about, You know when they're coming and you know the exact amount every month. This would be things like, you know, Netflix, Who Lou and car payments, if you will. It's always the same amount unless you decide for whatever reason you want to pay more. Ah, variable expense are ones that you actually need to budget for right so variable expenses, things like gas and electricity. The price of that expense is determined solely on your usage, and it's subject to change, so we need to figure out what are averages per month, So weaken budget for it on. There's a couple of ways to do this. The way that I recommend is you should open up your bank statement whether you're online or you get a paper. Banks take a statement and go through in log with all your different variable expenses are and sort them eso. In my case, I took all of my gas payments for the last couple of months. I'd say, like two months or so two or three months on, I found the first off. I guess you could find the average fulfill up just to get an idea of how much you're paying for Philip, how many Phillips there are, and then what the total was. And I found that average total for each of those months. Eso with that in mind, let's ah, do that Google sheets. So first, let's find some empty cells. They could be anywhere cause we're gonna end up deleting this. I'm going to do mine all the way out here just because this way I can delete the columns instead of just pushing back space and reformatting everything. Um, and I'm gonna title this gas and let's say it's for June and I'm just going Teoh, take a couple of cells here and do a border around it so I don't get confused and we're going to center it. That might be a little overkill. You don't need to do that, but I like to do it because it's a little easier for me to read as I'm typing things. And now we're just gonna go through our gas expenses or a gas charges for June, an interim in underneath gas. So in this case, we have a Philip of 30 to 70 way another Philip of 29 68. I have a very, very economical car. We had another one of 40 let's say 40 37 and we had another fill up of $16 is just top off . All right, so that's everything that we have here for June. I'm going to select this entire church and copy it right next to Thea. Other chart and let's do our next Phillips for the month of July. So for July, we had a fillip of $28. We had another one of 1914 16 and then we had one for 45 My gas take magically group and we want to find the sums of each of these charges so equals. And we're going to do some and you're going to see that it automatically suggests that these above That's perfect. That's exactly what we want. Eso that comes out to $118 going to do the same thing for the month of July. Gonna do some It automatically recommends thesis cells above the functions. So we're gonna go ahead and click that and push Enter. So we have a charge of 1 18 and 10 wait. So let's find the average of both of these. And you might have already saw that there was a function that showed up when I was doing the sums for both of these columns for an average function and you would be correct. So we're gonna pick a random cell here. Let's pick this one Inter equals, and we're gonna start typing average and you're going to see there is an average function that shows up. Then it prompts us to select themselves. Now you have a couple ways of doing this. You consult, hold shift and you could select all of these whips. Want to get back in here? And you can select all of these cells in this row on, and that will work. Another thing that you could do is let's say you only want to get these two cells and only changed the values in these two. Uh, only get these two cells because you're gonna change the values in the rose later. You can hold control and control will allow you to select individual cells without selecting all of the cells in between. Like holding the shift key does. And then we're gonna push, enter, and you're going to see that our gas total comes out to 113. 38. Let's say I want to come in here to either of these columns and let's just change 30. For example, you'll see that our average is also going to change as well, and I want you to do that for all of your variable expenses. Eso We can figure out what we're going to do with our expense chart so we can create a budget. My recommendations. If you get a total like this, that's 1 13 just rounded upto 1 20 When we're doing our budget, it's better to err on the side of caution. That way you have a little extra money available rather than averaging lower risking that you're not gonna hold yourself to it. And you know you're not gonna have that that money available to pay that fee. So find the averages round up, and then once you figure out what all of your averages are for, like gas and electricity, then we can start our expense sheet. And in fact, let's put this up. We'll split the lessons up. We'll do our expense sheet in the next lessons, we'll delete that. 7. Expenses Pt. 2: All right, so let's make our expense chart. First thing I'm going to do is move this net income chart up. Just because I prefer toe have it a little closer to 50 30 20 rule and directly underneath net income, we almost directly, at least with one road space going to type expenses, merge and center the title and switch the title to 14 point fun and very similar to that, Actually, honestly, the expense charts gonna be the exact same his net income. So remember how to do that. You can jump ahead. If not, what we're gonna do is label everything on the left side, put all of our totals on the right side. So we're gonna label our first expense here. And I'm going off my cheat sheet. As I had mentioned before, we have a housing push. Enter car insurance, two shirts, gas. And now, uh, this is also a good way to list your expenses. You can just rapidly type out everything that you feel like you're you're paying for on a pretty regular basis. Anything that you want, a budget, even things like like clothing. If you're buying clothing any much every month and you feel like you're consistent about it . You could type that here as well. The point of this is to plant, right. So the more in depth your plan, the better prepared you're going to be. All right. So we've gotten to our first annual expense car registration now, car registration in the state that I'm in, we're paying for annually. It's pretty pricey. I would like to know how much I should be setting aside each month. So when this annual expense hits, I'm prepared for it. Eso We're gonna take the total, but first we're gonna push equals because we're going to This is a function we'll take the total, which is to 40 and we're going to divide it by 12 to simulate 12 months here. So it's $240 to divide. You're just going to a backslash type 12 and push enter. So for car registration, we should be setting aside $20 a month. So when that hits will be prepared, creative cloud is a set fee. I don't remember what it is off the top of my head. So please forgive me. Believe Amazon is still $120 a year so into 120. Divide that by 12. So we should be savage, setting aside $10 a month. Jim is $60 in groceries. We budgeted out to 300. That was us doing that function that I had showed you in the previous lesson and figuring out we spend about $300 a month in groceries, by the way, for grocery budgets. If you do not buy groceries, first off you should start on. And part of the reason is it's about half the cost released when I was calculating it for myself. It's about half the cost of what you pay to eat out. Eso. If you're eating out, you're spending $600. Divide that by two. That's three bucks, right, Or if you find that you're eating out at 708 $100 you could probably even get that lower. The cost of eating out depends on the location that you're reading out at its It's beating out. There's a lot of factors that go into it's the cost of the food. The service on the location is what you're paying for. When you're buying groceries, you're basically paying for the groceries in and of themselves. So it's like raw materials, right? So in its nature, it's going to be cheaper. You could date, basically, take whatever you're eating out. Budget is and divide. If I have to get your grocery amount or you could even divided by 1/3 you're just gonna need to experiment a little. All right, so we're gonna take our expense sheet in, like, before. We're gonna make this look pretty and actually, you know, put the total total and let's find this song and push into All right, so we have our expense chart here. We're gonna make it look pretty as we did with the previous charts. So we're gonna highlight everything and create an outside border. We're also going to select some alternating colors. By the way, you're going to see here that alternating colors this Tavis still open? This is for B two to F five, which is this one all the way up here. So if I were to change something in here, it changes this. It doesn't change that, so I mean, keep that in mind. If you see this doesn't always pertain to what you have selected at that time eso We're gonna select our chart. Select the paint bucket alternating colors And since this is expenses, it's terrifying. We're gonna make it red, and we'll just leave it this generic red and just like we did before, we're going to highlight the total, and we're going to make this gray with its own border. I know what's nice is the previous colors that you used will show up here underneath custom . We have our gray that we've been using previously. Here we select that you'll see that this gray is the same as this Great. Now we have expenses, we have our net income and we have our goals for the 50 30 20 rule. Now there's one other thing that I want to do with the expenses, because remember, we're going Bye bye weekly. I want to know exactly how much we should be setting aside per paycheck, and I apologize. I'm just remembering that we want to do this now, so I want to duplicate this total row, and I can either copy and paste it where I can select both cells, go down to the bottom right of the cell, click and drag, and Google sheets automatically. I assume it knows what you want to dio. So in this case, it just took the some function and put it here it the bottom. So it's adding all of this together in the column, which isn't what we want. Eso first, let's change the title and then we'll change the function going to say total for pay period And this one I'm going to wrap because I don't want to expand or call him too much. And we're gonna double clicking here to get to the function. And what we're going to do is delete that entire function is all we want is half of the total above, and we're going to type equals, select the total above and then just divide it by two. Backslash too, and we'll see that we owe $875 per pay period. And I want to make this look pretty again. So I want to get rid of this inside border, so I'm gonna highlight everything, take off all the borders and then redo the borders and you'll see it removes that center border. That's our expenses. We have a total and our total prepared a total per pay period. In the next lesson, I'm gonna show you how to do some pretty simple charts 8. Pie Charts 8: all right, So if you're anything like me on your more of a visual person pie charts really help you out to see your breakdown of your expenses. Sometimes looking at all this just gets a little it gets a little clustered, right? I'd like to know exactly how much of my money came from paycheck one versus how much of my money came from paycheck to, for example. I want to see aware the most where most of my expenses air coming from. For most people, it's gonna be your housing. But it might be surprising to find out that gas, for example, eyes costing him or than car insurance. But it's not always easy to sort through all this data. Eso What we can do is select the title of our chart, hold, shift and select all the other cells stopping right before you get to the total. And then you can come up to the top above the toolbar in the menu bar, click, insert and then select chart, and she eats is automatically going to create a chart for you. Based on the data that you provided in this case, it assumed that we want a pie chart, and it is absolutely correct. And we can see in this pie chart that we have paycheck to and pay check one split 50 50. But if I were to come over here and change this toe, let's say we only made $1000 on one paycheck. You'll see Paycheck to is much larger than paycheck one, and it breaks down. The percentage 40% of our income came from paycheck one, while 60% came from paycheck to I don't know if I explain this yet. The difference between that and coming gross income net income is your income after taxes, gross income is your income before taxes. So we're working with the net. All right, so we want to make this chart look pretty. The Reds a little intimidating. This is a net income sharp. We would like it to be a little more welcoming so you can select here on the top right side , receive these three dart three dots and select at a chart. That's a quick way to get to the menu. You could change all your tart your chart styles, but we're gonna come up here and click customize um, and we're going to select pie slices. This is where we can change our pie slice color. So I'm going to change of the first pie slice color for paycheck, one to a green, just a dark green here and then for paycheck to I'm going to change it to a slightly lighter green additional income gonna change, doing even lighter green. And then for the last hopes and for the last additional income could change it to the lightest green. So now, if I were to come in here and entered in some totals, you'll see that we have, uh, the entire chart looking green with our additional income showing up on the pie chart as well. Get rid of those because these are the only two that we're working with right now. But we can also title this chart. So let's get back into our chart editing menu. Select customize Go down to chart and access title. And we're going to title this chart, um, net income and you'll see that the title shows up here in the top left. Let's do the same thing now for expenses going to select the title, the expenses and slept all the way down to the line just before total in total pay period. Insert chart should automatically recommend us a pie chart, which it does, and we're gonna make this look a little bit more intimidating cause it's expenses. So in this case of the menu is already opened up here for charts. Since it's the chart that we have selected, we're going to come over here to pie chart pie slices and will change the color to a red. I don't really like this bright reds into a dark right here for housing, and we're going to car insurance. That's do a lighter red renter's insurance. Now we don't want this entire chart to be read, so we're gonna pick some other intimidating color. So it's do yellow for renter's insurance. I just picks a warmer colors for these, which, by the way, if anyone knows a quicker way to do this, I would love to hear it. I know that you can also go through in select themes. I never use themes. I've always just kind of done things custom myself. Eso Like I said, if anyone knows a better way to do it and I'm all years, I know there's a couple programs were used in the past. We just change the color of the entire chart at the same time, and it's really, really glorious. Eso I missed a couple collars here. I can click on this green directly, and I can change that color, so it'll automatically sort that for me. We're going to a bright orange and we'll select this one here, this blue and we're going to make this A. I don't think I've used that read yet. No, I have not. I did use it here. Make that the darkest red in the screen. Make that the greatest red. So the starts a little hard to read. We could make a little easier to read with border colors so we can select over here click menu at a church, come over to customize pie chart, and you can select border color underneath the pie chart menu and select black right? So it's a lot easier to read. Just by looking at this, I can see we spent 17.1% on groceries, 45% on housing, 5% on car insurance, etcetera, etcetera, but also resize these titles or thes charts by clicking on him and drag him out. Expenses tends to be the more complex chart. So what's actually moved the net income over here and the expenses up to the forefront. And let's remember to title our expense charts. We're gonna click this, make sure that the menu is open at it. Shirt customize, come down to chart and access titles and really type of titles, expenses. And we have our title in the top left. All right, so the next lesson I'm gonna show you how to do a monthly breakdown, which will show where to allocate your money and then after the monthly breakdown will enter in everything into our 50 30 20 rule. 9. Monthly Breakdown 9: All right, So we're gonna do a monthly breakdown. The Golden Monthly breakdown is to show you how much money you've saved. How much, discretionary you're free to spend each day. All right, so the goal of a monthly breakdown to show you how much you saved and how much discretionary you're free to spend each day, I'm going to make our still assuming you were paid by weekly. Of course, if read, edit this any way you'd like, but make sure you were holding true to the 50 30 20 rule, and I'll explain that a second step one, we're going to make a title ongoing. Title it monthly breakdown And just like we have with everything else, title it and we're going to merge this one across three cells century and increase the size to 14 point. All right, so in the left cell, we're actually gonna leave this blank in the centre, sell here. We're gonna type total, and in the right cell, we're going to type minus expenses and then in the, uh, underneath the subtitles, we're going to do our first function. So we want this to be titled. Whatever our payment is right. So we could simply type paycheck one, but I actually want to do equals and then select the cell that says paycheck one, which is B eight and push enter. And now, if I were to come up here and just title this pay, you'll see it will automatically change down here in B 36. But we want this titled Paycheck One again. All right. We want the total of paycheck one toe also be copied down here. So I just pushed, equals and then selected associate and pushed Enter. And I'm actually gonna undo that real quick. So I want to show you one more thing is I have paycheck one selected right in b 36. If you just click and drag that over, Google Sheets will automatically assume that you just want to copy everything in this real . So it'll copy everything for you, which is fantastic. And now we're going to subtract expenses. Now, remember, we ever total per pay period and this is our total for the for pay period. Assuming you're paid by bi weekly. Correct. So every two weeks, So we're going to subtract our expenses from this total surrounding equals. We're going to select our total here, which is 1500 minus. And then we're gonna select our total pay period and then push enter, which means my expenses were looking at 6 25 Now, let's get into saving. I do my savings where I take 10%. Remember, you're saving 20%. I take 10% of what I make and put in the long term savings, and I take 10% of when I make and put it into a short term savings. I do that first after I get paid. Right? So we're gonna tape titled this first box long term savings and underneath it were in a title short turn savings. And we're going to label these, actually, let's put 10% underneath that were put 10%. All right, so we want to find out how much we're left with after we take money and put it into our savings. So to find 10% of 1500 you are simply going to type enter select 1500 as we did before, with 50 30 20 rule, where you're going to multiply it by 10% which is quite one push enter its $150 we're gonna do the same thing one more time equals Select the 1500 multiply it by 15000.1 and push. Enter. And we want to take these totals and subtracted from the 6 25 so we can see how much is remaining. So we're going to Dio equals 6 25 and we're going to subtract this 1 50 for center. And now Google Feet should know what we're doing is we're just gonna click and drag this cell down. We'll double click here just to make sure it's doing what we want to do. It's taking d 37 subtracting it from C 38 leaving us with 3 25 which is all, which is exactly what we wanted to do. All right, so we want to see what this breaks down. Teoh. I mean, basic math will tell me that we're we're saving about $300 a month, but I'd like the total bar. Just I see it a little more visually, So we're gonna title this bottom row Total savings underneath that we're gonna title this'll road total discretionary and the last roll we're gonna type budget um, per day, and then we're going to tie. Subtitle that 14 days. So you get paid every two weeks and let's just wrap this bad boy, okay? So to find her total savings, we're going to dio equals and add together both of our savings. You need to do a some function, or in this case, I'm just gonna be lazy and hit. Sell 37 do a plus sign, and then do sell 30 uh, to sell 38 inter in total savings at 300. Our discretionary is this total right here. So this is all of the money that we have saved after or all the money that we have to play with after we have put our money in savings. And we've also allocated our money towards our expenses. So we're going to equals, and we're just going to select this row here, and our budget for 14 days is going to be our discretionary divided by 14. Right? So we're going to select eat where we're gonna type equals select 3 25 and then divided by 14. So we have $23 a day to work with in discretionary spending. We have a total discretionary spending for 14 days at 3 25 and then we have a total savings of 300. And last but not least, let's make this chart look pretty. So we're gonna highlight everything to an outside border. We're gonna come appear to alternating colors. Well, let's do this kind of like a lighter green color here. I prefer that one. Yeah, and then let's separate all of our totals from everything else, will do an outside border for this and will select that gray that we've been using. All right, so here's our monthly breakdown. Every paycheck, every paycheck will be subtracted, so we'll see what our total is minus expenses. We'll see how much is left after we take 10% out of a wall. Also, see how much 10% is so automatically calculate that it's 150. But let's say I were to come. Appearance changed to 1300 dramatically changing. Yes, it automatically changes. Is 230. We'll see what that breaks down to. We'll see what that breaks down to in terms of total savings in terms of total discretion and in terms of budget per day. So it won't duplicate this chart. One more time for pay check to you could really duplicate this chart as many times as you like, But in this case, we're just gonna duplicated for paycheck to and noticed that if I highlight all this and I drag it over, it will duplicate all the functions. But it doesn't duplicate the formatting, so I'm just going at least the alternating color. So when a copy it instead by pushing control. See, you can also come up here to edit and do copy control, See your command, see on a Mac control see? And they were gonna paste. And we now have our new monthly breakdown and you'll see that it didn't form at the exact way we wanted it to. What? This is telling me the fact that all of this is blank here. It tells me that the Google sheets is guessing the wrong rose. So, actually, if we click in here, we'll see that it wants to take the data from e eight e eight. It's like, over here. So we don't really want this coming from E A. We're gonna delete that we're going to select paycheck to instead and for the total road. We're going to select our total in Select the total for paycheck to I mean same thing if you want. Do that. You can also just click and drag at this point automatically duplicate notes. It's not subtracting expenses properly. It's probably doing the same thing, and it is guessing where expenses are coming from. Yes, it is. It's guessing that our expenses air coming from F 32 which were not so we're going to delete that and we're gonna select total per pay period and then push, Enter Right. So now the chart is working as it should. I noticed that there's an extra border that showed up here. We would highlight everything removed borders, and you'll see that we also removed the border on this side. That's fine. We're gonna highlight that cell. Just add a left border. So it's a breakdown for paycheck, one paycheck to If you work an hourly job, this'll is gonna be very, very helpful for you because not all your paychecks look the exact same. Especially when you're not salary right. So in this case will see you get one paycheck. That's 1989.37 and then another paycheck. That's 13.23 No 0.98 You'll get a breakdown for each of your different paychecks. So for paycheck one, for example, you have $51 a day to work with and then pay check to. You have 13 $13.16 toe work with Let's get this all back to 1500 so it looks nice and clean and just just for the heck of it. Let's do one more of these charts just for additional income, because there is something else that I would like to point out here, and we'll make sure that that has enough space. Perfect. So we're gonna do equals again. We're going to select one of these additional incomes, and we're just gonna click and drag this. Oh, versatile, automatically duplicate whoops. Clicking dragon over. Make sure that duplicates there. If you want to test that, we could just type a random number in, and it works perfectly. OK, let's do the same thing as before. We'll get rid of this border. Just add the border on the left side already, so something I want to point out SE or additional income is 1000 bucks. So you work to sidekick, Um, and let's remove the expenses. So that's what I want to point out is our expenses are already budgeted. So assuming that you're working your job on a pretty regular basis, assuming that you still have a job, right, your budget is based on you still working that job. Okay, so your expenses are coming out of your first paycheck. Your second half of your expenses are coming out of your second paycheck. That leaves your additional income here, um, without any expenses to pull from, because we've already pulled the expenses from paycheck one and paycheck to, which means that all of this is additional income, which is fantastic. Now it's up to you at this point on how you want to allocate that when I get any form of additional payment. Typically, what I do is I pop it immediately into saving, So I just changed my savings from 10% to let's say, if it's an additional income, we can change this to let's do 40% and we'll do this one as 40% as well. And you only need to change your multipliers here, Teoh equal 40% and will automatically do the rest of the calculations for you. So now we have additional discretionary of $14.29. We have $800 going into savings and a total of $200 discretionary. So you can really play that by ear, however much you want to put your, um, your discretionary away, Uh, where your additional income away. Or if additional income is something that you absolutely have to dio. Perhaps you move, you divide your expenses by three. So instead of doing total per pay period, you do a total per however many payments that you get for example, right, Or you could do it where you total out all of your expenses per month, and then you just do a final income sheet. So you just take this $4000 you subtract your expensive from that to get the remainder and then you do your monthly breakdown. If that makes sense, if anyone's curious on how to do that, I'd be happy to show him how to do that. But for now, we're going to stick with the sheet in the way that we have it, because We're already running a little long here. All right, So we want total all of this out and see what we are working with so we can get all of our data for the 50 30 20 rule. But that's something that we're gonna have to leave for the next lesson. 10. Monthly Totals 10: All right. So we're gonna make a total sheet for our monthly breakdown, as we have before, we're going to click over here in type total. And this time I'm gonna do it in capital letters and own breaking my own rule here. And you'll notice that the conditional formatting automatically copies. That is fantastic. We're gonna leave it exactly like that in the first cell below it. We're gonna type total monthly savings. And we're gonna space this properly. Leave this cell blank underneath that we're going to type total monthly discretionary. Space that out again. And in the last cell, we're gonna type total budget, okay? And we're going to space that as well and will make border on the outside of all of this just so that it looks pretty. All right, so we want to find the totals for everything that we have entered in down here. So for total month of savings, we're gonna do equals. And if you remember correctly, holding control will allow you to select individual cells. So for monthly savings, I'm going toe, hold control and select this 1st 300 Select the 2nd 300 Whoops. Forgot to do. Plus the 1st 300 plus hold control. Select the 2nd 300 plus. And then we're gonna select this blank cell here just so that the the the chart is rigged properly. Then we're gonna push, enter, and we'll see that we have monthly savings of $600. That is absolutely correct. We're into the same thing now for the discretionary equals. Select this 3 25 plus select the 2nd 3 25 plus And they were gonna select this last for additional payments and then for budget for 14 days. This is actually where it's going to get a little different because what we're doing with the total with the total budget per day, if you remember correctly, is we're taking whatever the discretionary was and dividing it by the amount that we need to divide it by. So if you're 14 days in between pay periods and you already subtract your expenses, that's how much you're taking. That's how much you're breaking up per day, right? But we need to find this number for 28 days now. If I were just to add these two together we get 46 2046 42 which does not work in terms of how much we can spend per day. We need to find out over 28 days what we were able to spend. So for total budget per day, you're gonna do equals and you're going to select the monthly discretionary directly above . And you're going to divide that by 28 days, however long you want to do it. If you want to do it by 30 days, you can do that as well. In fact, will do 30. We will do 30 days assuming 30 day months and we have a total budget for 30 days. You know what space? That total budget for 30 days is 2167. And now, if I were to come appear to this additional income and add that $1000 as I did before, you will see that our monthly discretionary has gone up because we haven't changed anything in terms of our savings plan for discretionary income are monthly savings is set at $800 now we have a total budget per day at 48. 33. So that tells me that all of this is working correctly. Eso We're going to go ahead and delete that free. Now. Now I want to take this a step further, and I want to be able to look at this chart and see when I'm in the green or when I'm in the red, both literally and figuratively on. There's actually a way to do that in sheets, and it's called conditional formatting. So the next lesson I'm going to give you a brief introduction on conditional formatting. All right, So conditional formatting. We want to plainly see when these numbers air over zero and when they're under zero. So, as we've been doing before, you're gonna select each of these cells that each of these cells underneath savings, discretionary, and per day, we're gonna hold control selected individually, you're gonna right click books since make sure we do that, hold control and right click and select conditional formatting, and you're going to see a new menu opens up here. This conditional formats gonna apply to this range. And here the format rules. The cell will change to this color if the cell is not empty. So that's pretty simple. I mean, the cells not empty, so it automatically changes degree. But we want it to turn green it only if the number is over zero. So we're going to select the format rules. And by the way, you could do custom formulas. And here is Well, that's very cool, but we won't focus on that To reflect format rules we're gonna go to greater than and then we're gonna type zero. I want to change the screen so it's a little bit more bold, so I'll just leave the default. But I'm gonna change the text to this darker green here, and we're going to make it bold and actually let's do and even darker green. So it really jumps out and then pushed. Done. All right, so if you come down here, you will see that our total automatically, or that this formatting is automatically changed. If I would change this to 100 for example, our paycheck one, you'll see that it goes back to the green than it was before. And we have the parentheses for the negative number. So there is some conditional formatting there. We're gonna make this a little more clear by doing the negative numbers next. But go ahead and select all those cells again. Same way holding control, right? Click and select Conditional formatting oftentimes to the menu for conditional formatting will stay up here as well. You can always just navigate over here if it's still open and you're gonna come over to the plus and select, add another rule and same thing. We don't care if the cell is empty or not. We want to know if it's a greater than or less than zero. So we're gonna dio, um, less than an type zero and we're gonna slicked select words says default and change it to read. We also want the text to be bold and a darker red as well. So when a select just kind of a dark red there and bold it out and select done how do we know if this works when I'm actually noticing that didn't select all the ranges we selected Que 38 and k 36. But we just like K 40. We can fix that by selecting our ranges again. Weaken! Delete this and we could hold control and select our rose against Okay, 38 k 36 and K 40 and click. Ok, how do we know if this worked well, let's come appear to pay. Check one and let's change it to $100. So if you made $100 in paycheck one and $1500 pay check to you found that you are under water for the month, you still put money into savings for some reason, at least according your savings chart. But your total monthly discretionary is negative $470 your total budget per day is 15.67 So not looking great there, champ. But that's OK, because that's not always going to be the case. Now let's say we delete that second paycheck, right? This total is still reflective on the entire month. OK, so don't always worry about this box. As long as this one is in the positive, you're okay. But let's say we want all of this to reflect positive and negative numbers as well. But we did the conditional formatting on that side. Well, you can select any of these conditional formatting rules. Select apply to range, and you can add another range. So I'm gonna hold control and select total savings, hold, shift and select all of the following rose. So everything from D 39 2 d 41 is added. I'm gonna click, add another range and do the same thing for the monthly breakdown. And I actually screwed that up by holding shift. Do the same thing for the monthly breakdown here, and we're going to select a G 39 hold shift and we're gonna do the last range. And you can also move this menu. We're going to select J 39 hold shift and select that range and select. Okay, so all of this is now highlighting green, which means that we're in the positive. So if you only injuring one paycheck, just focus on this on this column here. So let's do the same thing for the negative numbers. Just so we are being honest, you can select this so notice. By the way, when I selected this conditional formatting rule here, the conditional formatting rules only showed up for the conditional formatting that exists in that cell. So if I want to get this negative formatting that we had set up before, I need to click one of the cells that have it select looks actually get out of that. So to get back into the menu. Right? Click. Conditional formatting select the conditional formatting rule. And just like we did before, we're gonna add some ranges. So at another range shift had another range hold shift at another range. Old shift and push. Okay. All right. So we have some more data to work with. No. So everything. So now what's going to happen is when you get your paycheck, you're going to enter in your paycheck directly up here in the net income, and you're going to see a breakdown of all of your income. Uh uh, Yeah, your s a breakdown of all your income and exactly how you should be saving it. So the next lesson we're going to enter this into the 50 30 20 rule on, and then we'll start working with some variable expenses. All right. So you may have noticed that I have left up in the 50 30 20 rule are actual, um, row completely blank. And that's because we couldn't really get to this row. I mean, we could, but we couldn't really get to this row until we set up our monthly breakdown. So we're going to put this in now and see how we're doing. So first, let's figure out how much our expenses were gonna push equal and go down to our expenses chart. And we see that our total for the entire month 17. 17. $51,750. Push! Enter on that. Do the same thing for our 30% discretionary. Now, remember, our discretionary is down here in the monthly breakdown, There's our total monthly discretionary. We're gonna do equals trying to reconnect and push Enter What happened? So we're going to the same thing for the discretionary. Going to select the discretionary row push equals go all the way down a total monthly discretionary and push enter and we're gonna do the same thing with savings equals go all the way down a monthly savings which is in our breakdown and push Enter. And we want to make sure that these totals match You can actually click are some function that we set up here One of the earlier lessons. Click and drag, and we want to make sure the border stays at the bottom. So here's what our breakdown looks like. $1500 is what our goal is. Were at 17. 50. So we're a little above our goal. We have discretionary spending at $900. That's our goal. We only have 6 50 So we're actually not getting to spend as much as we would have liked to save. We would have liked to for the 50 30 20 rule. And our savings is that $600. Now you have a couple of options. You can either even this out, depending on how important discretionary spending is for you. Perhaps you you host a lot of friends precios a lot of parties, and those things are very, very important to you. You could always lower your savings in order to get to this 30% discretionary. But remember to always pay yourself first. You should always be saving something at some point, no matter what. But looking at this, we can see All right. Maybe our expenses are a little too high. What? Can we come in and cut? Perhaps you get a lower cell phone plan. I know there are plans that are offering $35 a month these days, so you can go down to $30 a month. Gas gas prices are slowly lowering. So maybe we don't need 100 $20 budget. Can we make do with $100 budget? Perhaps we could get a deal on Adobe Creative Cloud. I forgot I am a student or I just conveniently remembered now that I am a student, so it is only $10 a month for me. Or is something some ridiculous fee or our grocery budget? Maybe we lower it down to 50. Maybe there's a local gym or a gym that's in your apartment complexes free. You can just set that to zero, and I want paying a gym membership and you can see as we start lowering our expenses, our charts automatic would automatically updating. But I'm gonna done do all that because you want to get an actual a natural breakdown. So that's what the 50 30 20 roll looks like. Now. Don't be afraid to cut expenses that don't be afraid to cut expenses. And the benefits of doing a 50 30 20 rule chart and doing your expense chart is it really allows you to see what expenses are the most important to you. So, for me, the first time I did this I saw I was over paying for my cell phone. I was able to lower my cell phone plan, contacted my cell phone provider and say, What can you do for May for a lower cell phone plan? They revealed some interesting things about my data that helped me out a lot. Electricity. You could be using a lot less electricity, perhaps renter's insurance. Maybe get a better deal on renter's insurance or car insurance. Once you see your numbers, it will allow you to play around with your numbers and really start shopping some deals and better options for yourself. Now the last thing that we're going to do today is figure out what are variable expenses or actually are like what we're actually spending on variable expenses. 11. Variable Expense Chart 11: All right. So are variable expenses chart. Basically, the goal with this chart is it should be a spot where you can document kind of like how we did very early on our expenses, like each one of the individual charges and how they're doing compared to what we're budgeting. So as we've been doing all through this class, we're gonna type out a title, and we're gonna type a month. So currently it is December. So we have a variable expenses for the month of December. We're going to make these larger 14 points, make sure that their science properly and I'm gonna settle him. In this case, I'm not doing any merging. At least not at this point, actually. Let's just move this December over because I already know exactly feel like I know exactly how much we're gonna merge. And now for the subtitles. We're just going to type out date because you want a wog, uh, dates that you spent money on these expenses. We're gonna take gas, and I feel like tress city, and we're going to emerge this across all of those cells, and we're gonna drag December back over here. All right, so we're just gonna go down a couple of cells and we're gonna make a total box. You can put it underneath the date because we're not gonna total together dates or find the averages of dates or anything like that. So you you're fine putting the totals underneath your subtitle here and we're going to do equals some parentheses and going to select all of the rose above center. And we're just going to duplicate that for all three of these variable expense. Rose, Just drag this over and we contest this out real quick. Let's just 10 12 will do 15 and you'll see it automatically totals at the bottom. Now, let's make this turn pretty skylight. Everything border on the outside and let's make this yellow. So we're gonna do right click. Sorry. Not break with. We're gonna highlight everything. Come appear to paint bucket conditional formatting looks and we're gonna highlight everything. Gonna come up here to paint bucket and we're gonna select alternating colors and let's make this a yellow yellow really sticks out from everything else that we've done so far and we're going to push done. Now there is something that I forgot to put here. We're gonna do one more row, and I actually like this road to be separate for everything else. That's where I talked. Budgeted. Then we're gonna type actual, and we're going to type difference already. So now, for each of these rows for the budget in rows, we're just going to do equals, and we're gonna find whatever we listed in our expense chart here. So in the case of gas were budgeting $120 go ahead and push into their. In the case of electricity, we budgeted $60 were push equals in there and then for groceries, we budgeted $300 going to equals, Enter and put it there. And actually, what I'm realizing is the date doesn't exactly make sense for this chart unless you want to split up all of your different expenses. Um, so we can actually do that. Drag this over. It's kind of fun. Thing is, the more you use Google sheets you start seeing before you. You start seeing problems before you even reach the problem. So that's me. This is me seeing a problem that just rose. We're type date. Thanks. And let's make sure that the conditional formatting or the poultry in color is gonna work for everything. If we want to remove alternating colors, you can click check, remove alternating colors, select everything again. Paint bucket, alternating colors. Select that yellow that we liked and we'll do the no borders and then outside borders. And I want this bottom row to be separate from everything else. We're going to an outside border on that as well. All right, so we have a date rose for everything, and we also have rose for each of our expenses. We also have our budgeting expenses that automatically show up here for actual. We're just going to make that equal the totals above and then for the difference. We're gonna make a difference equal the budgeted minus the actual. So go ahead and do that equals oops. Undo that equals budgeted minus actual then equals budgeted minus actual Push, enter. And we want to do some conditional formatting for this as well, since we already set up conditional for matting up here, come up here and click right click, click on conditional formatting. And as we had done before, let's get back into that. Select the sell Quick conditional formatting. Um, select the values and then click apply to range. We're going to add another range. And I'm just gonna push control and select each of these different cells here. So we're gonna do that one. That one. We're gonna do that one. So we're doing C 58 e 58 in G 58 then we're pushing. Okay, so we're in the green for all of that right now. All right, So now let's do the negative numbers. So push done there. Same as before at another range. Select. Select it. Select and then push. OK, so what you should be able to do now any time you get a gas charge or any time you need to go buy gas entering your numbers here for your gas charges, you conveyed it. So this happened on 12 5 For example, this happened on 11. 17 and you can keep track of all of your variable expenses and see how you're doing versus the budget. Now, let's say I'm just gonna put a crazy number here for gas. Expensive. Say you bent on spent $200 in gas. Um, at this point, you are able to tell. All right, I went over budget on this one particular thing. Perhaps that's something that you would just in the in the future. Perhaps you adjust your expenses up here and you increase it that way. You're not. You're not in the negative. But this is a pretty simple way to track how you're doing versus room budget, and we'll go ahead and remove all these and what I am noticing, as I also forgot to do the great color here. So let's go ahead and select it that gray that we've been using and let's do it for this road as well. All right. And that is how to make a very simple personal budget and budget breakdown in Google sheets . I'm pretty new at doing this myself in terms of making budgets in Google sheets. Before I have been writing out, writing out everything by hand or going off my bank statement. I'm happy to help. I mean, using noodle sheets for a pretty long time now, so I can help anyway, I can. If you have any questions, please reach out. Like I said, I will do the best that I can on. Thank you so much for taking this class for being on skill share on Click on this link really means a lot. Um and we, uh, you know, look forward to helping you guys out next time.