2015年8月4日星期二

Printable Bill Tracker Sheet and Excel File


Oh it's Monday. Around here Monday's are my nitty gritty let's get down to business work day. I do bills, catch up on ETSY shop stuff from the weekend and try to start fresh from whatever happened the week before.

Speaking of bills and business I'm sharing the excel file I use for my bills today. I have been using the same excel file to do our bills for years and it has been a saving grace. I plug in the numbers and I can easily have our bills planned out for as long as I want. I know when we will have extra cash flow or things will be tight. My husband's paycheck is always the same every two weeks. If he has overtime or holiday pay it comes as a separate check which I don't count into our bills making it extra unaccounted for money. I can easily add in payments from my blog or shop and the equations are already set so the excel sheet does the math for me. I am constantly telling my family that this is the best way to plan ahead so I am happy to share it in hopes it will help someone else out too!

Keep track of money coming in and out with a free bill tracker printable and editable excel file. http://www.poofycheeks.com


I have the excel file which you just have to plug the numbers into or for anyone who isn't savvy with Excel I have a blank PDF you can fill out with a pencil. Below shows how to fill it out weather you use the excel file or the printable. At the top put the payment dates and below that put an average check amount next to income (in the yellow box). When Mike and I both worked 40 hour a week jobs I would use an average check amount minus $50 to give a little cushion if something happened. Then in the rows underneath income add your bills in by doing the bill due date, name of the bill and the amount of the bill. If you are using the excel sheet the numbers will all start to populate themselves. Remember you only change the numbers in the yellow column!! If you are using the printable you will have to use the old subtraction method to take the income minus each bill and put the subtotal in the far right white column of the box. After your first bill take the far right number minus the next bill and so on until you are done. The final number will be your 'leftover money'.

Keep track of money coming in and out with a free bill tracker printable and editable excel file. http://www.poofycheeks.com

没有评论:

发表评论