Budgeting

Paying Bills Bi-Weekly Using a Budgeting Spreadsheet

The budget and savings plans created in this blog series work best when paying bills bi-weekly. We’ve already paid the bills for the first half of the month, now it’s time to pay them for the second half. This is the second part to the guide to paying bills bi-weekly using the budgeting spreadsheet. It covers paying the rest of the bills, using T-accounts to track expenses and creating a budget for the next month.

*This post was originally published on August 22, 2013 and updated on February 21, 2020.*

paying bills pt.2

*My husband Jesse, the builder of our budget, wrote this post. This is NOT professional advice.*

Paying Bills Bi-Weekly – The Second Part of the Month

Let’s get started! It’s been 2 weeks and J&J have been paid $1,375($700+$675) again. They check their bank balance and find that they have $2553.07. Time to do the bills! Let’s go ahead and enter the bank balance in E13. While we are doing that we will reset cells D2-E8 that we used last time we paid bills.paying bills bi-weekly

J&J also add their pay to their budget.paying bills bi-weekly

J&J reviewed their budget and, because they are paying bills bi-weekly, they see that they have paid all of their bills this month except for their rent. They also have to pay their credit card bill for gas, food, and other expenses for the second half of the month. J&J review their checkbook to see if all the checks that they have written have been cashed. They find that one check of $25 for trash removal was not cashed yet. Since they technically spent this money, but it hasn’t been taken out of the bank account yet, we need to subtract it from the bank balance. Go ahead and put it in the bills list, but don’t add it to the budget since it is already there from last month.paying bills bi-weekly

J&J go ahead and pay their rent of $900 and add it to their budget and summary.paying bills bi-weekly

paying bills bi-weekly

Paying Variable Bills

Next, J&J review their credit card statements. Their total bill was $719.11. If you remember from the last section, J&J’s credit card bill was around $400. So what happened?! After reviewing their statement they found they spent around:

Grocery:  $148
Entertainment: $ 78
Gas: $132

Our expenses are close to the first half of the month’s, so where did the other $361.11 come from? Well J&J decided to spend $42 of their savings on clothes. And the remaining $319.11 was spent on a car repair when their car needed to go into the shop.

J&J go ahead and pay their credit card bill for $719.11 and update their grocery, entertainment and gas spending on their budget.paying bills bi-weekly

To update the gas, entertainment and grocery spending I used a simple formula to add the first half of the month’s spending to the second half. For example, grocery was $155 last time we paid bills and $148 this time. So I used the formula “=155+148” in cell D18. I did the same for Gas “=125+132” and entertainment “=80+78”.paying bills bi-weekly

So J&J have paid all their bills and accounted for all the checks that they wrote. Their total remaining bank balance is $908.96. So we will put that in cells B7 and H4 with the date.paying bills bi-weekly

Balancing the Budget

Now we’ve paid all our bills but if you notice the cell B8 that shows us how much money we have to allocate to savings is negative by $241! This is because we need to account for the $42 we spent on clothes and the $319 car repair.

So let’s go to our savings tab and remove $42 from “Fun+Clothing” and since the car repair was an emergency, we will remove $319 from the “Emergency” fund. Remember, when we use the T accounts its “left in, right out.” Since we are removing $42 and $319 they will both be on the left.paying bills bi-weekly

paying bills bi-weekly

Now if we look at our summary, our clothing and emergency funds should be automatically reduced from our adjustments to the T accounts. Account for our spending changed our “money to allocate” from a negative $-241 to a positive $119.paying bills bi-weekly

Since they had such a large car repair, J&J decided to put the $119  that is left over back into their emergency fund.paying bills bi-weekly

Bills are paid for the month, and our savings are balanced out!paying bills bi-weekly

Create the Next Month’s Budget

Since the month is done, after paying bills bi-weekly, the last step we need to do is create the budget for next month. All we need to do is select Columns A through E and copy them.paying bills bi-weekly

Once copied, click on column A and click “insert copied cells.”paying bills bi-weekly

Next click on Column F and click “insert.”paying bills bi-weekly

Now just clear out the actual cells in Column D (don’t delete the formulas in the total rows) and rename the month to the next month.paying bills bi-weekly

That’s it! We are ready for the next month. Just rinse and repeat!

Now I know this example was simple, but all problems that come up are really this simple. With a little thought and planning, most situations are pretty easy to tackle. If this is your was your fist time using excel or a Google spreadsheet I’m sure it seemed a little difficult, but after a little practice it becomes easy.

I hope you’ve enjoyed seeing the way we implement paying bills bi-weekly. Like I said in the beginning this isn’t professional advice, but just an example of how we do it ourselves. There are literally hundreds of ways to handle your finances. The most important thing is finding the system that works for you! And if you are having trouble you shouldn’t hesitate to go see a professional. The only thing worse about being in a bad financial situation is doing nothing about it!

We really hope that you all have enjoyed our little budgeting series! If you want help, make sure you ask! 

Check out all of the posts in this series: Building A Budget, Saving Your Money and Paying the Bills Part I

2 Comments

  1. This is great!! I am a good ol’ excel spreadsheet girl myself. 🙂

  2. This is SUPER helpful, Ashley! Thanks for sharing everything! I use Mint.com for most of my day to day budgeting stuff, but things like car repairs are hard to know what to do with! This makes more sense!

Leave a Comment

Your email address will not be published. Required fields are marked *

*