User guide on how to use the debt consolidation excel template.
Disclaimer: Any logos, trademarks, or brand names displayed in this workbook are used solely for identification and compatibility purposes. Ownership of these trademarks remains with their respective owners. This version is compatible with Microsoft 365. Includes tables, power pivot and formula.
Before You Begin
Before entering your information, gather the following to make setup faster and improve the accuracy of your dashboard.
• Latest billing statements
• Loan contracts or payment schedules
• Credit card statements (E.g. Security Bank, Bank of the Philippine Islands, Bank of Commerce, and others)
• Outstanding balances
• Monthly payment amounts
Step 1. Download and Open the Workbook
Open the template – Debt Consolidation Excel Template using Microsoft Excel 365. Enable editing if prompted.
Step 2. Enter Your Debt Information.
The fields below apply to both the Free and Premium versions. The difference is how the information is entered and processed. Complete one row for each debt using the following fields:
1. Transaction Status/Type – Select the type of financial obligation whether it is Ammortization, Regular Charges, Current Bill, and All, or another applicable type.
2. Credit Institution – Enter the name of the bank, lending company, or person you borrowed from.
3. Description – Provide a short description of the debt (e.g., BPI Credit Card, Pag-IBIG Housing Loan, Motorcycle Loan).
4. Count / Terms – Enter the current payment number and total loan term (e.g., 1 of 36, 12 of 60).
5. Month – Enter the month the payment applies to.
6. Amount Due – Enter the scheduled payment amount for the month.
7. Amount Paid – Enter the amount you actually paid.
8. Payment Status – Indicate whether the payment is Paid, Partially Paid, or Unpaid.
9. Date of Transaction – Enter the payment or due date.
10. Year – Enter the corresponding year.
11. Category / Use Type – Classify the debt (e.g., Credit Card, Housing Loan, Personal Loan, Business Loan, Vehicle Loan, Educational Loan, Family Borrowing, Others).
FREE Version
Enter one record for each debt every month. For example, if you have a 36-month loan, you’ll add one row for each monthly payment as you update your records.
Premium Version
Enter each debt only once. Simply provide the loan details, start date, end date, or repayment term, and the workbook will automatically generate the monthly payment schedule and update your dashboards saving time and reducing manual data entry.
Step 3. Repeat for All Debts
Include all active financial obligations such as credit cards, housing loans, personal loans, vehicle loans, and money borrowed from family or friends.
Step 4. Refresh the Workbook (if applicable)
Go to Data > Refresh All after adding or updating your records.
This updates your reports, summaries, and charts using the latest information you’ve entered.
Step 5. Review Your Monthly Debt Preview
See how much your household needs to allocate for debt payments each month.
Step 6. Review Your Annual Debt Commitment
Understand your estimated debt payments for the entire year to help with long-term budgeting.
Step 7. Check Your Decision Board
Use the charts and summaries to understand your current financial commitments at a glance.
Step 8. Review Your Financial Decision Board and Update Regularly
Update your records whenever you make a payment, add a new loan, or close an existing debt to keep your dashboard accurate. Your dashboard automatically summarizes your financial information to help you answer questions such as:
• How much do I need to pay this month?
• Which debt costs me the most?
• When will my debts end?
• Am I financially prepared for retirement?
Step 9. Upgrade When You’re Ready
Need more insights? The Premium Version includes Debt Analysis, Retirement Fund Projection, Emergency Fund Tracker, Lifetime Updates, and additional financial decision board to help you plan beyond your current debt.
Step 10. Unlock More Financial Insights
Upgrade to the Premium Version to access:
• Debt Analysis Dashboard
• Retirement Fund Projection
• Emergency Fund Tracker
• Financial Health Score
• Lifetime Updates
• Email Support
Tip: Update your workbook at least once a month, preferably after paying your bills or receiving your salary. Consistent updates lead to more accurate financial insights and better household decisions.
Financial freedom isn’t achieved overnight. It’s built through consistent habits and informed decisions.
FREE DOWNLOAD. Click Debt Consolidation Excel Template
By Libot Tayo with Lily
A Personal Note
This workbook wasn’t created for clients first, it was created for my own family. My husband and I wanted a better way to understand our finances without relying on multiple statements and spreadsheets. We needed a clear picture of our debt, monthly obligations, and long-term goals in one place.
Building this dashboard gave us more than organized numbers. It gave us clarity, encouraged more meaningful financial conversations, and helped us make decisions with greater confidence.
Every family’s financial journey is different. My hope is that this workbook becomes a practical tool that helps you make informed decisions, reduce financial stress, and work steadily toward your own goals.
Love,
Jelly Lopez-Cawili
@LibotTayoWithLily
🌐 libottayo.com
📧 jalopez@libottayo.com
More Financial Dashboard Systems
The Debt Consolidation Decision Board is part of a growing collection of Excel-based financial tools designed to help Filipino families organize their finances and make better financial decisions.
Find more helpful files here.
Links for Exploration
• About Me – What is this website about?
• Downloadable Tools by Lily
Let’s Connect
💼 LinkedIn: View my profile
📩 Email: jalopez@libottayo.com
🎥 Tutorials & Excel Systems: Excel Now PH (YouTube)
📖 Mom Life & Updates: Libot Tayo by Lily (Facebook)
💼 Consulting & Systems Support: Magayon Management Consultancy Services
Your subscription could not be saved. Please try again.
Your subscription has been successful.
