Create Your Perfect Google Docs Bill Template for Finance Effortlessly

Google docs bill template for Finance

this video will feature a tutorial on the bill calendar template from budget babe templates this tutorial will be on the Excel version but a Google Sheets version is also available and I will call out where there are any differences in the Google Sheets version along the way the bill calendar is a version of a monthly or annual calendar that focuses on Bill and debt payments unlike a simple or monthly template which includes savings and expense categories the focus here will be on making sure you make Bill and debt payments on time there will also be a place to record income on the calendar template has four tabs this first tab is the instructions tab which will link you to step-by-step instructions all the instructions will be covered within this video next is the setup tab where you'll see in setup your bills debts subscriptions and other monthly payments the next tab is the annual dashboard which provides a real-time summary of your spending to date it'll automatically update to show you how you spend how you're spending Trends month to month as well as summaries about your spending by subcategory and then last there are 12 tabs for the smart calendar one for each month each month of your smart calendar will help you keep track of your bill and debt payments all your obligations will automatically populate based on your inputs in the setup Tab and you'll also be able to mark each one as paid and enter payment information we'll go through each of these tabs in detail now the only thing I want to point out on the instructions tab is the fonts this file will work best with the fonts in which it was designed if you are using the Excel version of this template and your version of excel does not have the two font types called Laura and nunito you'll want to those for the file to work as designed those are available by clicking on the embedded files in the instructions tab or by locating the file fonts within your Etsy purchase either on your Etsy account or in your email all you need to do is to double click the file and then you're going to click open and right here on the top of the pop-up these files are free for you to use and if you're using the Google Sheets version you'll automatically have access to those font types without downloading them next thing we're going to move to is the setup tab so the first thing that you're going to notice within the Excel version is that you're only going to be able to click on and change certain cells of the sheet this is to make sure no accidental changes are made to the cells that do calculations on the Google Sheets version a warning will pop up if you attempt to change this change a cell that should not be changed any cell that is shaded or colored on any sheet should not be modified you'll see here that the default currency is the dollar if you'd like to change the currency you'd simply enter your preferred currency symbol and that change will automatically carry through the spreadsheet I'm based in the US so I'm going to keep this as the dollar for now next you're going to select what day of the week you want your calendar to start Sunday is the most common in the US but Monday is also an option and you just click the drop down button if you wanted to click Monday next you're going to select the Year by entering the year for your calendar this calendar will work for any year and is reusable so you do not need to start at the beginning of the year you'll just pick up with whatever month you want to begin next we're going to begin entering our obligations the first is bills you can enter up to 20 bills subcategories we're going to start here with this bills number one cell some of the more common examples of bills are rent or mortgage insurance internet cell phone Etc for each bill we're going to enter the due day of the month only not the full date when you enter a day for January the rest of the year will Auto default to the same day so I'll show you how that works now I'm going to put in mortgage and we're going to say my mortgage is due on the fifth when I hit 5 for January you can see that the rest of the months change to the fifth automatically if your due date changes every month you can modify that by just going over whatever month the due date would change and entering a new number so let's say I know that for some reason my mortgage in May is due on the 6th not in the 5th I can go in and just type a 6 right over that and on the calendar within the tab of May it'll change that date just for May if you have a bill that is only paid in certain months you can also delete the due dates from the months it is not due so I'm going to go through now and just enter four simple bills for this example the next one is going to be cell phone we're going to say my cell phone is due on the first the next is utilities we're going to say utilities is due on the 10th and then last is internet and we're going to say that my internet is due on the 15th okay now we're going to repeat this process for up to 15 debt subcategories the most common examples of debts are car loans student loans personal loans or credit cards where you're carrying a balance that you want to pay down you would not enter here a credit card where you are consistently paying it off month over month unless you just want to track the due date of that credit card so the first one here I'm going to enter a student loan we're going to say my student loan is due on the second next is car loan you're going to say my car loan is due on the 16th personal loan I'm gonna say that is due on the 28th and then lastly Citi credit card and we're going to say that payment is due on the 25th okay next we're going to enter up to 15 subscriptions the most common examples here are entertainment subscriptions like Netflix Disney plus clothing subscriptions pet subscriptions or food box subscriptions I'm just going to enter two examples here I'm going to say Netflix and that is due on the third and then we're going to say bark box and that is due on the 17th and then finally you have room for up to 10 other subcategories starting with other number one down here now this can be overflow from the three other categories or it can be something truly different from those um an example of that can be a monthly quarterly biannual or an annual obligation that are less common or less frequent like property tax or membership free fees so the example I'm going to do here is I'm going to say I have a quarterly property tax I need to pay and it is usually due on the 30th of the month but it is only due every three months so I'm going to go through and delete February and March I'm going to delete May in June then August and September and November and December and that way it's only going to show up in the months in which it's due you can see here that I've got another example automatic automatically loaded in template for other number two but I don't have any other obligations so to make sure that this other example that's pre-loaded doesn't populate in my calendar I'm going to go ahead and delete that other obligation now my setup is all complete and I can go ahead and um and move into my monthly tabs before I do that just a couple of notes and reminders first all obligations must have different names for the template to work properly even if you have two separate due dates for a single obligation they still must be different so for example if you have two house payments in a month you can name them mortgage one and mortgage two and that would work but if you entered them both as mortgage the file doesn't know which to populate and so you won't see your obligation show up on the calendar that's a really common kind of error that folks have seen the second note is if you have an obligation that begins after you have completed setup you can either come back to the setup tab to add it or there'll be a place to add extra bills and debts to each month in the monthly tabs and I'll show you how that works once we get to the monthly tab so I'm going to go to the annual dashboard and I'm just going to stop here briefly just to orient you to it this tab is completely autumn so you will not need to enter anything to get started once you start entering actuals on the monthly tabs this will start to populate the annual dashboard will show you insights about how you spend across categories including monthly Trends and averages you'll also see some Dynamic insights about your top um subcategories when you scroll down here now you'll notice that it looks like there's board up here each monthly tab I've provided an example of a paid bill I'll pop over to January to show you that now so you can see right here this example I've already pre-loaded as paid and I've entered an amount as one hundred dollars again just to show you how this works you can see that this example is flowing back to the annual dashboard for all of the months because it's automatically pre-loaded for all of the months now once you start entering your data that will go away because you'll just write on top of it or if you'd like you can clear those examples off of each tab so if I just clear the amount here and clear the little paid check and go back to the annual dashboard now that's been removed for January so as I mentioned before you can start this template at any time and the template is reusable for several years you'll simply just go back to your purchase and download a fresh copy for the new year since it's June I'm actually going to go through and I think that I will start my template in July so most of the features of your monthly Tabs are automatic and they're going to carry over from the inputs from your setup tab the calendar will begin on either Sunday or Monday based on your choice and the year you entered on the setup tab will also automatically be entered here automatically all your subcategories and due dates that you set up to automatically flow to the monthly Tabs are now reflected in this all obligations list the all obligations list is organized by due date and it includes an option for you to Mark the items as paid by selecting the check mark symbol again you can see the one here is automatically populated just as an example but you can clear that out and then once you're ready to mark it as paid and you've paid it you can click paid and you can enter amount so we can say that it's already the first of July and I have paid 95 dollars for my cell phone bill once you've paid a bill you enter that amount into the amount column and then that amount will flow over to the annual dashboard so I'm going to do another one just so you can see what that looks like we'll say I've gone through the second I've paid my student loan that was three hundred dollars and I've gone through and paid my Netflix and that was 19. now if I go back to the annual dashboard you can see that for the month of July those bills debts and subscriptions have started to load in um in the information up top and then you can also see my subcategory details have started to populate with my actual bills debt subscriptions as well so now I'm going to go back to July there are three optional features on the monthly tabs that I also want to point out the first optional feature is at the top left of the tab under paydays you have the option to add up to five paydays if you want them to be reflected on the calendar to do this you'll simply enter the day of your paydays and again this is just going to be the day not the full date and they're automatically going to appear on the calculator again I've pre-loaded a couple examples here so you'll want to go in and change these at these or delete them if they aren't relevant to you so in this example I'm going to say that I'm a bi-weekly paid employee and that my paydays fall on Fridays and so my first payday would be on the 7th and my second payday would be on the 21st and you can see now that those paydays show up on my calendar in a different color so I know that they are paydays once um I am paid I can mark it as received by clicking a check and then clicking an amount and let's say that I expected 2500 and got twenty five hundred dollars for that payday now within paydays and obligations any time that you mark something with a check mark on the calendar you're going to see that that item gets grayed out and crossed out and that's just another visual reminder to remind you that that obligation or payday is now fulfilled all right the second optional feature can be found under the calendar and it's the option to add additional bills and debts um that you did not add in the setup tab that are specific to a month or something that has come up since you set up the setup tab this area is best used for unexpected bills or debts that come due during the month or after you've already set up the budget so common example here is receiving a medical bill that was perhaps unexpected so all you need to do to add that to each tab is is name it and then add the day it is due and again this is just the day of the month that it is due so here I'm going to say that I had a medical bill that was unexpected and I'm going to say that the due date is the fifth now if I go back up to obligations you can see that my medical bill has been populated within this list again in order of the due date and then if I look on my calendar you can see that the medical bill has also shown up on my calendar the last optional feature in the calendar is for you to record monthly goals and to Do's think about this as a notes section so it's completely optional for you to use you can Mark those to Do's just by listening them here and then once they're complete you can choose a little check mark to mark them as complete and that's it this is a pretty straightforward template if your needs are really focused on Bill and debt payments and this template works well with a debt snowball calculator if you're on a journey to becoming debt free and need help understanding which debts you should be paying first that tutorial as well as tutorials on my other templates are available on this channel thank you so much and happy budgeting