How are you with paying your bills? How about staying on a budget? Is this something that you struggle with? Why not take charge now and start your own budget planner? All it takes is a little bit of your time to set up and then you'll be saving time every time a bill comes in.
I'm all about efficiency and I'm sure you'll see that this spreadsheet will help save you time. I've set up a bill budget planner and I would like to walk you through, step by step on how I set this spreadsheet up and how I use it. Also, stay tuned to the end because I've put together an awesome bonus for you.
Spreadsheets can be an efficient way of budgeting.
When it comes to spreadsheets, I'm in love!!! In my mind they are the ultimate in organization and efficiency. Spreadsheets are my electronic BFF (just don't tell my besties this). The thing with spreadsheets is, you set them up once and they are ready to work for you as long as you need them. In this case, they do all of the math for you so you don't have to worry about those awful math errors.
I've tried putting together budgets on paper and that just never works for me. I've found that putting together a nice spreadsheet is the best way for me to stay on track. Budgets are not always on the top of my radar. Actually, it is usually the last thing I think about. Knowing that not thinking about the budget is not a good thing, I thought it was time to sit down and set up a functional budget. This spreadsheet took a lot longer than I had anticipated.
Setting up a bill pay schedule.
When it comes to spreadsheets, I want it completely formatted from the beginning so I don't have to think about it. What are the point of spreadsheets and schedules if they don't help you save time! Let me start walking you through the schedule and budget spreadsheet.
I started out putting together a bill pay schedule. As you can see from the image below, there is a space for the bill, amount due, received date (when you received it in the mail), due date, date paid, amount paid, paid, and payment method.
Setting up a fully formatted budget planner.
Next I started a full budget. From the image below (this is just a portion of what is actually included on this budget) you can see that there is a space for income and a different variety of expenses. There is a space for a "budgeted amount", and exact amount, and then the difference between the two. This way you can set up the budget month in advance and once it is time to add the actual amount in you can see how well you are sticking to your budget.
I like to do it the way because I like to see how I am doing year to year. I try to base my budget numbers off last years numbers.
Below is another screenshot of the monthly budget. This one is somewhat filled out, showing you how I formatted the spreadsheet.
Here is another view.
Now finally I put together a formatted yearly end budget. This keeps an eye on the spending. There's a space for each month and then I've added the income and total expenses for each month. As you can see below this one is blank.
Look what happens when I add data into June's budget sheet. All of the fields are formatted.
Now take a looks at what happens to the year end budget.
The year end spreadsheet does all of the work for you. It's more of a reference. As you put the data in, the year end budget will show you how well you are doing. then at the end (highlighted in green) is your saved or lost number.
Now, as promised, I've put together a bonus for you! By clicking the button below you can download this spreadsheet and start using it for your bills and budget. I've also included a video tutorial on how to use this spreadsheet. I go into more detail and show you with visuals. Please click the button below to get the video and spreadsheet!
Are you inspired to become organized forever with a Budget Planner?
I hope this will help you become more organized! What type of systems do you have in place to keep your bills and budget in order? I would love to hear all about it in the comments below. Thank you so much for taking time out of your day to read this. Your support really means a lot.