Start paying off your debt with the ultimate debt payoff tracker dashboard.
TABS:
1. Guide-Read Me
2. Setup
3. Debt Dashboard
4. Monthly Dashboard
5. Transaction Tracker
FEATURES:
Currency Setting: Change the default currency using a dropdown menu for the entire template.
Start Date Entry: Set a start date in the setup tab, which automatically updates across all sheets for reusability.
Debt Tracker & Payment Calculator: Enter debt details like balance, due date, interest rate, and minimum payment, with automatic sorting based on your chosen payment strategy.
Transactions Tracker: Log all debt payments, supporting multiple transactions with automatic updates.
Debt Overview & Payment Schedule: Automatically sorted debt schedule showing payment amounts, due dates, and updated balances based on chosen strategy.
Debt Payment Strategies: Offers three payment strategies:
Debt Snowball: Focuses on paying off the smallest debts first.
Debt Avalanche: Prioritizes debts with the highest interest rates.
Minimum Payment: Allows you to make only minimum payments.
Debt Payment Summary: Automatically generated summary of due dates, amounts, and payment tracking checkboxes.
Extra Payments Handling: Syncs with transactions tracker to handle extra payments, automatically adjusting future payments.
Monthly Dashboard: Visual overview of debt progress with a dropdown to switch between months for easy tracking and comparison.
★ What you need:
You can easily access this spreadsheet with a free Google account. If you already have for example a Gmail account, you can use the same login details to access this spreadsheet.