Debt Guarantee Register preview
Debt Register sheet with columns for borrower, lender, type, original and current principal, interest rate, start and maturity dates, annual interest, guarantee type and amount, guarantor, security, days to maturity, exposure, status, and note. 1/3

About this debt guarantee register spreadsheet template

This Debt Guarantee Register template provides finance teams with a structured three-sheet workbook for tracking loans, guarantees, and credit exposure. The Debt Register sheet captures every facility with borrower, lender, type, original and current principal, interest rate, start and maturity dates, guarantee type and amount, guarantor, security, and calculated exposure fields. The Exposure Dashboard aggregates key metrics including total facilities, principal outstanding, guarantee exposure, and status breakdowns across active, due soon, high exposure, and matured categories.

The Lists sheet includes pre-built control rules with defined thresholds for monitoring outstanding debt balance, interest burden, guarantee exposure, days to maturity, and high exposure concentration. Each rule specifies the owner, threshold value, status trigger, and required action, making it easy to maintain governance over the debt portfolio. All sheets are fully editable in WPS Office, Microsoft Excel, or Google Sheets.

3 structured sheets

Debt Register, Exposure Dashboard, and control Lists for complete debt and guarantee management.

Built-in exposure dashboard

Aggregates principal, guarantee, and status metrics with automatic breakdowns by facility status.

Pre-configured control rules

Threshold-based monitoring for outstanding balance, interest burden, guarantee exposure, and maturity alerts.

Standard XLSX format

Works with WPS Office, Microsoft Excel, and Google Sheets for seamless editing and sharing.

Frequently asked questions
The Debt Guarantee Register template is designed for tracking corporate loans, guarantees, and credit exposure across multiple facilities. Customize the sample data, borrower details, lender information, and control thresholds in WPS Office for your own debt portfolio.
Use the native XLSX in WPS Office, Microsoft Excel, or Google Sheets. For Notion workflows, reuse the data structure and control rules in a Notion database; for branded financial reports, adapt the content in Adobe Express.
Download the template, open it in WPS Office, and replace the sample facility records, borrower and lender names, principal amounts, interest rates, dates, guarantee details, and control thresholds with your own debt portfolio data.
Yes. Select Download to get the editable XLSX file and open it in WPS Office or another compatible spreadsheet application.
Yes. Adapt it for corporate treasury management, credit risk monitoring, loan portfolio tracking, and financial compliance reporting. It is available for personal and commercial projects, subject to the applicable template license.