how to organize your bills on a spreadsheet

I recently had to add two monthly bills to my list of bills I already had because I went back to school. savings accounts) to balance this out as best as possible. Use the bills that don’t have a due date (i.e. If your monthly bills total $2000, then you will want to pay as close to $1000 worth of bills on the 15th and $1000 worth on the 1st. Figure out what your monthly dollar amount needed for bills is and divide it by 2. This will give each bill at least a week to get to you through the mail.Ĥ. And on the 1st of the month you would pay the bills due from the 7th -21st. I recommend the 2 days you when you get paid (if you receive a regular bi-monthly check).Īssuming the days you get paid are the 1st and 15th – you would then take all of your bills due the 22nd through the 6th and pay these on the 15th. Decide on 2 days per month that you will pay your bills If there is not a due date just leave it blank.Ģ. Next to each one write the day that it is due. And of course, if you want to save even more time, use your bank’s online bill pay.Ĥ Steps to Manage your Bills 1. Rather than sporadically paying them as they come in or checking a pile on your desk every few days, you should be able to designate 2 days a month to pay your bills. Why not implement the same type of planning to the paying of your bills? It requires a grocery list and a bit of foresight, but it saves you hours throughout the week by NOT having to go back to pick up missed items. Most credit card companies charge something like $40 each time it is late as well as jacking up your interest rate to 25%.Īnyone who has ever forgotten to get something from the grocery store realizes that it requires a lot less time to buy everything one day than having to go get something as you need it. It goes without saying that paying bills late (especially for credit cards) is terribly expensive. Back in those days when I lived in financial chaos, I didn’t have a system in place to help me remember to pay my bills.įor me this was just like playing roulette with my bills – I remembered to pay them sometimes and sometimes I would forget. My hunch is that most late-fees occur for that same reason.

How to organize your bills on a spreadsheet