Streamline Your Logistics with Bills Template Google Sheets

Bills template google sheets for Logistics

hello and welcome back to my channel my name is Jessica Morehouse and this channel is about all things money and one thing that I love to talk about is budgeting and budgets and slowly I've been rolling out the new line of budget spreadsheets that are available on my shop page and for this video I'm going to show you how to use one of my most popular spreadsheets this is one for if you're in a couple and you do budgeting in the way where you don't combine all of your finances you've got some separate saving schools from each other you've got some separate fixed and variable expenses but then also you've got some joint saving schools and some joint expenses basically I kind of call it the separate and together method of budgeting this is kind of the way that me and my husband have been budgeting for years where you've got some independence from each other but also you kind of come together for some of those joint aspects of your financial life I'm going to show you how it works if you want to follow along all you have to do is download the spreadsheet I will include a link in the description so you can easily download it and get to budgeting but without further Ado let's get to the spreadsheet okay so the first thing you're going to want to do is click on the links that are in the email that you received once you purchase the spreadsheet so there's Google Sheets or Excel if you click on the link for Google Sheets you'll get to this page you just have to click on this button make a copy to copy it over to your Google Drive and there you go and for Excel you'll get to this page and you just have to download it by clicking on those three dots and this download button but for this example we're just going to focus on Google sheet so once you copy it over to your Google Drive you're going to get to this dashboard we're going to refer to that at the end you're actually going to want to start with this budget tab so the first thing you're going to want to do once you're on the budget tab is to write the names of who is in this couple that we are creating the budget for so there's person number one person number two for this example let's say we've got Robin and um Jeff then we are gonna I'm gonna walk you through all this but we're gonna basically put in all the income info for Robin and then her personal savings goals and expenses we're going to do the same thing for Jeff and then we are going to take a look at their joint personal spending so their joint saving schools and their joint expenses and uh before we get to that though as you can see I kind of break things down based off year month semi-monthly bi-weekly weekly if that is way too much data for you that's totally okay you can unclick any of the semi-monthly bi-weekly and weekly and just update it but this is just so you can kind of choose if you get paid bi-weekly and you want to see that then you can include that just to make it easy for you but for this example let's say we do get paid you know semi-monthly so I don't care about bi-weekly or weekly and if this pops up you just click on this check box don't show again for five minutes and go okay and click on weekly and then you just have to click on this button update tables now this is the first time we're using one of these scripts that are part of the spreadsheet so just go continue if it asks for authorization and click on your Google account don't and click allow and then click on update tables again to activate it and there you go it's gotten rid of it nice and clean and easy to uh see everything okay so let's start with Robin so as you can also see there's a button that says adjust number of jobs if Robin has multiple jobs she can click on that button and then another row will appear let me just show you let's say she has two jobs click OK it'll include a another row here and here and here and everything and everywhere it should be but for this example Robin's just gonna have the one job let's say her job is marketing coordinator her job type is full time income type is salaried and her yearly gross income so that is before any taxes or deductions are taken off or pay is seventy thousand dollars and net pay let's say it's about fifty thousand dollars now we know how much net income she has you know actually coming in this is her take-home pay and I like to do a pay yourself first kind of strategy when budgeting which means focus on saving first spend ending second so let's outline some of her personal goals so these are separate from her partner just for her and let's say one of them is uh travel maybe she wants to go on a solo trip or trip with friends she's saving up for her retirement and let's say also the holidays this is where you'll put in your account type where you're gonna put that money you can be a specific or general as you want but for example it could be like EQ Bank savings account number one because maybe she has a second account for her holidays and that's number two and retirement let's say she uh has an account with well simple invest and it's inside her rrsp and then you're gonna choose a percentage of her net income to allocate towards those saving schools so let's say and you can change these later uh let's say five percent ten percent five percent for now so she's saving it twenty percent of her net income for her saving schools spending eighty percent of her income on everything else everything else could mean her personal expenses her joint expenses or her joint saving schools and we'll get to that in a bit the last thing you're going to want to do is identify is this a short-term goal or a long-term goal so for the spreadsheet the definition of a short-term goal is are you going to spend this money within this year so she's going to go on a trip with her friends this year so that's a short-term goal and same holidays she's gonna use that money on that account to buy you know presents and go to holiday parties and things like that and retirement is a long-term goal we're not going to spend that money for a long time so that is not a short-term goal okay moving on uh so next we're going to identify what are some of her personal fixed and variable expenses a fixed expense is an expense in which the amount does not fluctuate it is the exact same amount every single month like most of our bills you know rent or you know a subscription things like that so let's say she has a few things maybe she has some subscriptions and her cell phone she puts everything on her you know MasterCard and she spends you know twenty dollars a month on subscriptions for herself and 80 bucks a month for her cell phone for variable expenses that could look like I mean you know take out for herself so buying herself lunch at work buy some books for herself we'll just put those two for now and she again puts everything on her credit card and maybe she's gonna give herself like 150 bucks a month for takeout and books maybe 50 bucks a month now let's do the exact same thing for Jeff now let's uh talk about their joint spending and also their saving schools so as you can see this is how you would properly split um who has to contribute how much based off their income so it only makes sense to split things 50 50 if you both earn exactly the same amount of income if someone earns less they shouldn't be contributing 50 that just wouldn't actually be equal instead you should be doing this and this automatically calculates who has to contribute what since Jeff earned significantly more he needs to contribute more of his net income for all of their joint spending and same with Robin G would be um contributing less because she earns less now we know that let's outline some of their um joint goals so maybe they have a joint emergency fund a joint travel fund they're going to go on a trip together and move their saving up for a home down payment they um have a joint bank account at Tangerine together travel let's say it's an EQ Bank joint account and home down payment maybe they're putting money into well simple invest and they have a taxable account they're investing for that goal now for an emergency fund it's totally up to you whether you want to label it a short-term saving school I mean sometimes you're going to touch it sometimes not um let's say for them you know they'll just put yes um it'll make sense uh further in this tutorial what why you have to actually label these short term or long-term travel obviously they're going to go on a trip this year home down payment they're saving up for years to come it would be a longer term goal they're contributing 500 per month emergencies um let's say 400 per month for travel and a thousand dollars per month for their home down payment and one thing I should actually mention in case you're wondering hey how do I customize these is there a way absolutely you can do this for the savings goals for fixed expenses variable expenses all you have to do is go to this tab spending by category and it'll have all of those kind of drop-downs listed here this is also a great way for you to keep track of what you're spending and what category for each month but I'll show you that a little bit later but you can of course you know change these but but I probably keep them the same because I mean I've done a lot of research and these are pretty pretty typical expenses that you or savings goals that you may encounter instead I would just tell you to maybe add a new row and then add a new item so for example let's go let's since we're in the joint area joint savings let's go add new row and let's say like you can be really specific it could be like trip to Mexico and then you just go sort table to alphabetize and then you can see trip to Mexico is right there so if I go back to that budget tab here and you can see trip to Mexico is right there so there you go now let's move on to fixed expenses so let's say they've got um rent maybe they got a pet pet insurance I don't know some subscriptions together okay great maybe they have a shared credit card they have a tangerine MasterCard together and for rent they're spending you know 2500 per month pet insurance 100 per month subscriptions maybe they have a variety 100 per month and lastly we've got variable expenses and so let's say we've got you know groceries and you know take out maybe household supplies and we're gonna just put everything on that same credit card 900 per month on groceries take out two hundred dollars household supplies a hundred dollars so let's see if any of these numbers work or if we have to change some things okay we're actually looking really good actually so that's that's promising so let me uh share how this all works this is totaling um Robin's share of the joint expenses and savings goals so if we just click on that it'll show you she is I'm contributing 41.67 of all the joint saving schools and expenses and that amounts to 29 000 whereas Jeff because he's earning more he contributes what is it about uh 58 and that actually looks like he's contributing about forty thousand six hundred dollars and um Robin is also spending about thirty six hundred dollars per year on just her own personal expenses and then Jeff is spending about 4 900 or almost 5 000 on his own personal expenses and just to remind you this these numbers do not include the amounts that they are individually putting into their own savings accounts for their own personal savings goals so uh we can take a look at these rows and this shows you is Robin spending more than is the amount she's spending over or under her net income no it is under that's why it is green and a positive number and is she spending more than she's budgeted for herself no she's actually under by seventy four hundred dollars so we can just remind ourselves of wait how much did she allocate for everything okay so she gave herself 80 of her net income to spend in total that is forty thousand dollars that she can spend on her personal expenses and her contribution of the joint savings goals and uh expenses as well because she's only spending thirty two thousand six hundred dollars that means that she is under budget so what she could probably do and what I'd probably suggest is save more of that money so maybe we can bump up her retirement savings to uh thirty percent let's see if that works okay so we've allocated a little bit too much money so let's go back and just tweak it say 25 instead okay we're just a hundred dollars over we're so close let's say 24.5 I'm sure that'll do it okay perfect so now this means that she is basically under budget by 150 per year um now you can of course fiddle with it if you're into zero-based budgeting but I'm totally fine with having a little buffer of 150 bucks similarly Jeff has a surplus he has like an extra 6 900 that he can do something maybe more productive with um so maybe he is going to up some of his savings goals to let's see if he does 30 oh too much okay so let's go to 25 percent and we're so close looks like it's going to be exactly how much Robin is spending so 24.5 wonderful okay great um so I'm happy with this everything is green and we can now move on to some of the spending tabs as you can see there's person number one this would be Robin's personal spending um and then this tab is for Jeff his personal spending and then this tab is for joint spending so the first thing I'm going to want to do is actually click on this button update savings table and as you can see is brought in her two personal um short-term goals travel and holidays so all three of these tabs work the exact same way um so I'm going to show you one and then I'm going to just put some examples in there so we can kind of take a look some of the uh dashboard tables there but it's very simple so all you have to do every single month is record your net income so this is again this is Robbins Robin would pop in here she would put in her net income these are different types of income types and if you want to change any of those customize those there's an income category section where you can just make a new row you know old school insert row or change any of these and they will get added there but let's say we're just gonna have her salary and she made about forty one hundred dollars in salary in January now why this is important to keep track is sometimes you earn a bonus sometimes you work overtime sometimes you have some extra money flowing in and so this is a great way to keep track of how much money is actually coming into your bank account okay so once that's all done then we're gonna track our different you know expenses in Saving School spending so saving School spending as weird as that sounds is simply if you ever make a purchase that is connected to your travel fund or your holiday fund so like maybe you're buying some people some Christmas gifts or some birthday gifts maybe you bought your your plane tickets to go on that trip with the you know your friends you would put that expense in here and the reason why I've uh kind of organized things like that because if you don't have this kind of other section then you'd probably put it in like variable spending and then it would look like you're overspending significantly and that just doesn't make sense because you're not overspending you're actually spending the money you've saved in advance for that purchase so that's why we have that section the easiest way to put in your spending is simply by downloading the transactions from your credit card your bank and then copying and pasting it over it and so to give you an example here is a credit card statement it would look like this this is a CSV file and then all you have to do is just you know eliminate some of the not helpful information then I'm going to delete any row that says you know a payment was made because that's not an expense that's just me paying off my credit card typically when you download one of these spreadsheets it'll have those expenses in negative numbers but for my spreadsheet we need positive numbers so here is a very easy fixed go equal sign a b s and then click on that number and then click enter and it gives you that positive number and then you can honestly just drag it and it'll copy over that formula I'm going to copy all of these and then I'm gonna just put them in variable spending and then I'll organize them after so I'm just gonna go add 10 rows to make some space for everybody and then I'm going to click on this cell and then I'm going to right click paste values only and let's go back to that spreadsheet and we want those amounts and we're going to copy and this do the same thing paste values only and then the only thing we have to do is uh type in the payment method so let's say this is the MasterCard and then you just categorize now as you can see and what I can see is uh some of these are actually from a trip that maybe Robin went also me um so let's say we're just going to cut some of these and move them on over to the saving School spending category or area here all right so that looks good to me and now I'm spotting some things that are definitely fixed expenses so I'm just going to cut this here paste here get rid of that one thing I should always remind you of if you're doing cutting and pasting like I just did guess what it just did it it also copied over the spending categories we want the savings goal category so we just take a blank cell like this that has the the proper categories and we just copy and then select the cells you want to replace and then paste and then it'll fix it right there okay perfect next I'm also just going to triple check that everything is totaling correctly sometimes again when you're doing lots of cutting and pasting it will get confused so yeah that looks about right it is grabbing not the right cells so I'm just going to delete this here and make sure it grabs the proper cells to total and you're correct and I think you're correct too okay great that looks good to me so as you can see if you go back up here um it'll show you the net income you earned you brought in is about forty one hundred dollars you spent about 106 on fixed expenses variable spending about 482 dollars and that is great because um first off you have spent significantly under how much income you brought in um but looks like you're over budget because you've only budgeted 100 for fixed expenses 200 for variable you budgeted 300 in total and you spent 589 dollars that means you're over budget which isn't the best so that just should be an indicator to cut back next month and do a little bit better it'll also show you your saving School spending here don't get too too uh wrapped up in this because often we don't spend the exact same amount every single month on it um so really it's more just the total at the end of the year that you're gonna want to pay attention to it's like you spend about twenty six hundred dollars on so saving School spending which is a bit more than the 416 that uh this kind of budget uh suggests but remember you have you know basically five thousand dollars in total to spend on travel and holidays combined um so you'll likely if you don't go over that five thousand dollars then everything will um break even and you'll be just fine so that is how you do spending you would replicate the exact same process for Jeff the other partner and for your joint spending and next you're gonna go this cash flow Tab and this is really just to keep everything nice and organized to make sure that you're not spending more than you're earning this is a great way to find out you know if you feel like you never have any money uh left over to put into savings this should be the indicator to show you why is that happening and typically it's because you're spending more than you're earning and so you know for example Robin she brought in about 4 100 in net income she spent uh 589 dollars um for her personal spending and about eleven hundred dollars in joint spending so that leaves are with uh twenty four hundred dollars and so that should be money that she's putting into her savings accounts for her savings goals she outlined in her budget and over here this just shows you what you uh or what Robin spent on her personal savings goals um and Joint saving School spending so that just keeps track of that as well so this is just like some handy tool if you want to see if you're spending more than you're earning and and where the problem areas are but my favorite tab actually out of this whole spreadsheet is the net worth tab I feel like if you create a budget you track your spending every single month and you track your net worth every month you're gonna be ahead of so many people when it comes to having a strong financial plan for yourself so it's very easy to track your net worth you just do it every single a month and it really just means writing down what your assets are and your liabilities are to see your progress now if you're starting this at the beginning of the year and you know what your net worth is as of either you know the end of December or you can choose to um note down things at the beginning of the month you can put down what your net worth was in say the end of December 2022 that's why you would put this information there if you have no idea you can just ignore that and you can start afresh for January January 1st what was your net worth I'm going to show you what that would look like so liquid assets as you can see here and also make sure to check out that net worth cheat sheet that was included in the email that you got with your budget spreadsheets but your liquid assets those are things like cash checking account balance savings account balance cashable JC short-term bonds things like that things that are easily convertible Into Cash basically that is what liquid means then you got your investment asset so what kind of Investments do you hold and here are some examples and personal assets that would be like your car that you drive your personal residence or your home things that you could sell potentially for cash and liabilities that's just a fancy word for debt short-term debts that could be like a credit card balance on a credit balance medical bill back taxes long-term liabilities could be your mortgage car loan student loan uh things that will take you a little bit longer to pay off let me just put in a few things here so now we've got all of their assets and liabilities outlined and their total assets uh equals seventy thousand dollars they're total liabilities or seventeen thousand dollars that means their net worth so assets minus liabilities is 53 000 now to show you how to track your progress I'm just going to show you what happened in the month of February for example and maybe I'll just uh change some of these numbers here they put a little bit more in their emergency fund maybe she put a little bit more Robin in her rrsp and same with Jeff and let's see their liabilities let's say they paid off their line of credit last month and there's a little bit uh less owing on their student loans they were able to increase their net worth to 60 500 if we go to the top here oh as you can see um they were able to increase their net worth from January to February by 14.15 you can ignore this because it looks like in December that they had a net worth of uh zero so if you don't want it to look like that you can literally just copy what you put for January that's what I'll just do for this example and then it'll kind of just uh equal zero but if you do this every single month this will give you that extra motivation to keep on tracking everything you know being good with your budget tracking your spending being mindful with your spending trying to earn more money and cut back because it's very exciting to see your net worth grow every single month especially if you do it for a whole year it's really cool to see what progress you made after 12 months okay so the last thing I want to show you is this dashboard right here so as you can see you choose the month that you want to see information for the months that we haven't filled any info in there it'll just be blank so you'll want to wait until a month has actually happened and you've tracked everything but you can see in January it will show you your combined income versus spending your net worth and this will become kind of interesting to see the graph as the year goes by here's some data for Robin specifically and for Jeff specifically so it'll show your savings goal spending your fixed and variable spending all that kind of stuff and also some joint information as well like I kind of showed you earlier if you go to spending my category area you can also take a look at you know each month to find out in what areas did you spend if you don't want to look at those graphs you just want to see some of the dollar amounts so that is it hopefully you found this tutorial helpful again if you want to download the spreadsheet link in the description and if you have any questions at all let me know in the comments or you could always email me directly at support jessicamorehouse.com