How To Track Your Debt Payments

October 25, 2017 Off By Jess

How To Track Your Debt Payments

This post may contain affiliate links.

I wrote about organizing debts and making payments on them, but I haven’t touched on how to track your debt. Tracking your debt payments is important to make sure that you have an accurate look at what you owe. I track my debts in a couple of different ways because each one serves a different purpose for me. Here are a few ideas of how you can track your debt payments!

Track Your Debt In Excel

First and foremost, I track my debts in two Excel spreadsheets.

General Information

I find it really important to have one spreadsheet that has the information for all of my debts. It’s nice to have one place that has all of my account numbers, company names, debt amounts, phone numbers, websites, and my usernames and passwords. I reference this frequently when I can’t remember what my login information is or when I want easy access to company contact information. I have it formatted as a table so that I can easily sort it alphabetically or by the total amount of the bill. This spreadsheet is just for information sake. I don’t update this spreadsheet when I make a payment, so this spreadsheet doesn’t reflect any current balances due.

Current Balances

On the same spreadsheet, I have a second tab where I have a copy of the general information table. I removed the company contact information and my login information. On this spreadsheet, I update my balance and have an extra column that includes the date of my last payment.

Debt Snowball

I have a second spreadsheet that is Dave Ramsey’s Debt Snowball spreadsheet. I still have hope that one day I will get started on his Financial Peace University and utilize this spreadsheet how it’s intended. For now, I keep it up to date with my balances for when I do start it.


Track Your Debt On Paper

In addition to tracking debts in Excel, I also track my debts in two ways inside my scary debt binder.

Postie Notes

On each debt bill in my Currently Paying and Paid in Full tabs is a lined postie note. The top of the postie has the name of the company, and then below that is a super simple list of each payment I’ve made. For debt bills in the Paid in Full tab, I wrote “PAID IN FULL” under the list of payments on the postie so that it’s extra clear that there’s nothing else owed.

Notebook

The other way I track my debts inside my scary debt binder is in a lined notebook. Each page has the name of the company, my account number, my total beginning balance, my payments made, and the remaining balance after each payment. My payments are listed by date and I use different colored pens for payments and balances. In green pen, I write the amount I paid, and in red pen, I write the remaining balance after the payment.

Call me crazy but there is something really satisfying about having a detailed notebook of my payments and remaining balances.

Summary

Here’s an overview of each method to break it down for you.

1. General Information (Excel)

2. General Information + Current Balances (Excel)

3. Payment Information (Binder – Postie)

4. Payment Information + Current Balances (Binder – Notebook)

These are the methods that work for me, but there are probably 800 different ways to track your debt. Out of all of my methods, the easiest and most straightforward is the one Excel spreadsheet that combines all of this information and has it easily accessible in one location.

Tracking is my favorite part of tackling my debt so far. I do a lot of tracking for work and being able to be in control of spreadsheets and lists just makes me a happy duck. I’ve started to get excited to make payments toward my debts because it means I get to update my spreadsheets and my lists!

Do you have a method for tracking your debts? I would love if you shared it in the comments!

Disclosure: This post may contain affiliate links, which means I may receive a commission if you click a link and purchase something that I have recommended, at no additional cost to you. I value your trust and only recommend brands and products that I truly love! Read my full disclosure policy here.

How To Track Your Payments On Your Debt