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.
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