BTMS Philippines Reports
Debt Servicing Requirements Report
Overview
This report shows debt servicing requirements for the month, quarter, year at aggregate level or at donor or executing agency level by debt instrument type, based on the debt servicing requirements data. It provides different filters which help users to generate the report as per their requirements.
A screenshot of the Debt Servicing Requirements Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.
Users access Debt Servicing Requirements Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► BTMS Philippines Reports ► Debt Servicing Requirements Report.
Filters
The following table lists and describe all filter fields for the Debt Servicing Requirements Report in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.
| Field | Description |
|---|---|
| Report Type | It lists the report type for selecting as a report filter. |
Fiscal Year | It lists the fiscal year to select them as report filter. A value for this field is mandatory. The current fiscal year is set as a default filter. |
Fiscal Period From | The current fiscal period is set as the initial range by default. Based on the requirement user can select another fiscal period from the list. |
Fiscal Period To | The current fiscal period is set as the end range by default. Based on the requirement user can select another fiscal period from the list. |
Debt Type | It lists the debt type for selecting as a report filter for the report. |
Creditor Agency | It allows selecting the creditor agency using lookup feature as a report filter. |
| Executing Agency | It allows selecting the executing agency using lookup feature as a report filter. |
Visible Fields
The following table lists and describes all visible fields for the Debt Servicing Requirements Report, in their default order. Note that some fields depend on Filters selection. The language of the report depends on the configuration of the system.
| Field | Description |
|---|---|
| Code | Instrument ID. |
| Description | Description of the Debt Instrument. |
| Debt Instrument Type | The debt instrument type. |
| Maturity Date | The date of maturity. |
| Amount | The total amount as per the filter selection in instrument type. |
| Forecast Principal Expected Transaction Date | Expected transaction date for principal. |
| Forecast Principal Amount | Forecast principal amount. |
| Forecast Interest Expected Transaction Date | Expected transaction date for interest as per debt transaction forecast. |
| Forecast Interest Amount | Forecast interest amount depends on the debt transaction forecast filter selection. |
| Total Forecast | The total of forecast principal amount and forecast interest amount. |
| Actuals Principal Transaction Date | The actuals principal transaction date. |
| Actuals Principal Amount | The actual principal amount. |
| Actuals Interest Transaction Date | The actuals interest transaction date. |
| Actuals Interest Amount | The actuals interest amount. |
| Total Actuals | The total of actuals principal amount and actuals interest amount. |
| Total Forecast Principal Amount | The total forecast principal amount. |
| Total Forecast Interest Amount | The total forecast interest amount. |
| Grand Total Forecast | The total amount after adding the total forecast principal amount and total forecast interest amount. |
| Total Actuals Principal Amount | The total actuals principal amount. |
| Total Actuals Interest Amount | The actuals total interest amount. |
| Grand Total Actuals | The total amount after adding the total actuals principal and actuals total interest amount. |
Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Debt Servicing Requirements Report feature.
| Button Image | Description |
|---|---|
 | The pdf button allows users to generate the report in the pdf format. |
 | The Excel button allows users to generate the report in the excel format. This format is compatible with Microsoft Office 97-2003 or higher version. |
 | The Excel button allows users to generate the report in the excel format. This format is compatible with Microsoft Office 2003 or higher version software. |
 | This ODS button allows users to generate the report in ODS format. This format is compatible with spreadsheet software such as Microsoft Office, Open Office or Libre Office. |
 | This RTF button allows users to generate the report in RTF format. |
 | The Word button allows the users to generate the report in word format. This format is compatible with Microsoft Office 97-2003 or higher version. |
 | This ODT button allows users to generate the report in ODT format. This format is compatible with word processing software such as Microsoft Office, Open Office or Libre Office. |
 | Lookup allows user to select existing item from the list as a filter. |