- #SIMPLE DEBIT CREDIT EXCEL SPREADSHEET TEMPLATE HOW TO#
- #SIMPLE DEBIT CREDIT EXCEL SPREADSHEET TEMPLATE DOWNLOAD#
The starting balance for the debt, or the highest balance ever Leave blank if there is no limit of this sort. The debt's annual percentage rate (APR) you're charged.
The spreadsheet is set up this way, with user-created standardized categories, so that sorting and calculations are easier to implement on later worksheets.Įnter the remaining columns as follows: RATE: Clicking cells in the TYPE column will open a drop-down menu from which you can select each debt's TYPE, like so: Refer back to the TYPES you entered on the "Debt Types & Income" worksheet, and use those. In the second column, classify each debt with a TYPE. In the first column, give each of your debts a name that's meaningful to you. Delete all the figures that are already there, as they're examples only. Space shouldn't be an issue (one would hope!), so just start the dirty work. You'll see a lot of white space here - enough to enter up to forty (40) separate debts and the details relating to each. The next worksheet page, titled "Debt Listing," is where you list ALL of your debts. Once that's done, you're finished with the "Debt Types & Income" worksheet page. Enter your gross (pre-tax) annual income, your net (after-tax) annual income, your gross monthly income, and your net monthly income in their respective cells. If you're not sure of your household's exact income figures, then estimates will work fine.
Just write over them with your own data.) (The figures that are already there are for example only. In the next section, labeled HOUSEHOLD INCOME, you'll need to enter your income data in the four white spaces provided. Examples of other debt types would include: Keep your TYPES as general in nature as are the five that are already included. However, if you're like most families and have other (more!) types of debt, just enter these other types in the remaining white spaces. You can't override these five primary types, so if there's a type or two that you don't have, simply ignore them. In the section labeled DEBT TYPES, you'll see a total of 15 spaces, 5 of which already include the types of debt most families have. The worksheet will look similar to the image at the right. Your next step is clicking on and opening the "Debt Types & Income" worksheet tab.
#SIMPLE DEBIT CREDIT EXCEL SPREADSHEET TEMPLATE HOW TO#
If you're not sure how to do this, just visit my instructional page at: You'll want to start off by opening the DebtTracker spreadsheet (obviously!) and enabling macros in your version of Excel. The DebtTracker spreadsheet contains seven worksheets in total, but uses three main sheets to do its thing: There's one clear truth to apply here: If you don't know your enemy, you'll not only never defeat him - you wouldn't even know it if you did.įill out and use the DebtTracker, and your enemy steps out into the light. Which leads to an expected obstacle: They've never tallied up their liabilities to see what they're really up against. So very many people have never overcome the fear and/or denial that inevitably accompanies significant debt.
and combines all the numbers and accounts to make that debt crystal-clear. It takes away the "abstractness" of personal debt. When I sit down with friends and family and attempt to draw up reasonable debt-reduction plans, the DebtTracker is the very first spreadsheet I utilize. You can figure out your Credit Card Utilization percentage, your Debt-to-Income ratios, and various other financial metrics. You can get an idea of just how long it will take to pay off each debt. You can easily sort your debts in a large variety of ways: by type, by current balance, by interest rate, and more. With the DebtTracker, you can see all your debts laid out in front of you in one place.
#SIMPLE DEBIT CREDIT EXCEL SPREADSHEET TEMPLATE DOWNLOAD#
Get your copy of the DebtTracker from the download link below. I created (and recently renovated!) the DebtTracker mainly for those folks who are just now embarking on a debt-paydown journey - or who are, at the very least, now taking debt reduction seriously. But the fact that so many people are downloading it means that I can invest a bit of time making it better. It has, I suppose, something of a catchy and intriguing name. The most downloaded of all my Excel spreadsheets, by far, has been the DebtTracker. If you've spent much time at my web site, you'll know that I offer quite a few Excel financial spreadsheets to the public. Yes, you can track your debts, and have fun doing it.
0 kommentar(er)
