Streamline Your Finances with the Excel Bill Tracker for R&D

Excel bill tracker for R&D

hello and welcome to the full video tutorial of the monthly bill tracker spreadsheet in this video we're going to go through a deep dive of how to set up and use the spreadsheet to track your bills throughout the year starting in the top left we can see that you're able to enter in the current year that you're entering bills for as you edit this year it's going to automatically update all the formulas in the background so that it automatically uh calculates correctly for that year and what this is going to do is make this spreadsheet usable over and over for many years to come in the build type column you're able to select from a predefined list of bills that have already populated for you or if you have one that's not on the list you can enter that in as well in the due on column you're going to put the day of the month that those bills typically are due so they're typically due on the 5th the 20th the 25th whatever day of the month that may be and throughout the year as you receive those bills you're going to put in the dollar amount in the appropriate month and then make sure to check the box for whether or not you've already paid that bill for the current month of september now we can see it's september 11 today i've already entered received those bills and entered those in and you can notice some color coding so what's going to do is automatically color coded red if the bill is overdue so this one was due on the 5th it's currently the 11th it's going to automatically highlight that red and then if it's due within 10 days so this one's due on the 20th it's currently the 11th it's due within 10 days it's going to automatically color code that orange and if you have many bills that you're trying to stay on top of it's going to give you a quick visual look to see which bills you're laid on which are coming due soon it's going to help you out in that way and then if it's due further than 10 days out it's not going to color code it at all on the far right hand side you can see the yearly totals for each of those bill categories that you've entered it's going to calculate that up for you and if you take a look in the bottom left of the bill summary it's going to show you a couple of different metrics it's going to give you the total amount of bills that are currently due so we can see by summing these up that's 260 we have 260 dollars of bills that haven't been paid yet total bills do within 10 days which is that one in the middle that's highlighted orange for you 75 are due within 10 days and then 85 dollars of bills that highlighted red one are due are already overdue and you'll notice as you pay these off it's going to get rid of that color coding it's going to remove it from the table so then everything automatically updates for you and the same thing with the other bills it's going to get rid of that now we only have 100 dollars worth of bills due and now we can see we're all caught up and then we move on to the next month thank you for watching and feel free to reach out in the comments if you have any questions