Tips + Tricks

Keeping Track of Paying Bills: Free Template

I’ve always been the one in the relationship in charge of our financials. It suits my Type A personality (aka, I’d rather do it myself than let someone else do it).

With the new year coming up, I know a lot of people try to get themselves more organized and ready for what the year will bring them. Unfortunately, we still will have to continue paying the same old bills!!! I’ve been using this Excel spreadsheet for YEARS to keep track of all our bills, credit cards, student loans, car loans, etc.

It’s broken down into three sections:

  • Joint accounts (rent, cable, joint credit cards, etc.)
  • My personal bills (Student loan, my own credit card)
  • Chris’ bills (his own credit card)

It shows the usual amounts that each bill is, the payment type (manually/online/auto payment), the due date, available credit for credit cards and their balances.Then it goes month by month. When I pay a bill I like to add a comment to the Date Paid cell and enter the payment confirmation number.

capture

At the bottom of the sheet there is an area to insert your monthly income. There are formulas that will show how much money you’ll have left over after your bills are paid.

The second tab of the spreadsheet is used for usernames and passwords. I also like to use it to store my vehicle information and any other information I need to remember whole paying my bills. I think this goes without saying, but as a disclaimer you should password protect your document if you’re going to keep super important information in there!

I’m attaching an editable spreadsheet for you to download and use however you’d like! I think it’s a good starting point for anyone looking for a way to streamline and organize their financials.

If you have any questions or are having trouble downloading the spreadsheet, please leave a comment or shoot me an email: hello@oliverxpiper.com

Also, if you have any suggestions for improvements, I’m all ears! I update my spreadsheet each year and make edits based on my current needs.

Enjoy! xx, Christine

template_bill_tracker

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s