Debt Service Payment Report
Overview
This report retrieves information about all the loan instruments that have securities or loans. It displays data from the annual provision, expenditure and balance provision, etc. It allows users to create reports based on their requirements.
A screenshot of the Debt Service Payment 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 Service Payment Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► SriLanka Reports ► Debt Service Payment Report.
Filters
The following table lists describe all visible fields for the Debt Service Payment 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 |
|---|---|
| Fiscal Year | It shows a list of the fiscal years that allow users to select it as a report filter. The current fiscal year is set as a default report filter. |
| Fiscal Period | It shows a list of the fiscal period that allow users to select it as a report filter. The current fiscal period is set as a default report filter. |
| Comment | Allows users to add a custom comment to the generated report. |
Visible Field
The following table lists and describe all visible fields for the Debt Service Payment 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 |
|---|---|
| Loan Repayments - Domestic | It is a report label. |
| Loan Repayments - Domestic Codes | It shows the item coding block for the loan repayment. |
| Loan Repayments - Domestic (Annual Provision) | It shows the current budget for the loan repayment. |
| Loan Repayments - Domestic (Expenditure Up to Previous Month) | It shows the expenditure loan repayment up to the previous month. |
| Loan Repayments - Domestic (Expenditure Up to This Month) | It shows the expenditure loan repayment up to this month. |
| Loan Repayments - Domestic Total | Empty space, manually filled after generating the report. |
| Loan Repayments - Domestic Balance Provision | Empty space, manually filled after generating the report. |
| Loan Repayments - Foreign | This is kept as a row lable for the report. |
| Loan Repayments - Foreign Codes | It shows the item coding block for the loan repayment. |
| Loan Repayments - Foreign (Annual Provision) | It shows the current budget for the loan repayment. |
| Loan Repayments - Foreign (Expenditure Up to Previous Month) | It shows the expenditure loan repayment up to the previous month. |
| Loan Repayments - Foreign (Expenditure Up to This Month) | It shows the expenditure loan repayment up to this month. |
| Total Capital Expenditure | This is kept as a row lable for the report. |
| Total Capital Expenditure Annual Provision | It shows the total annual previous capital expenditures. |
| Total Capital Expenditure Up To Previos Month | It shows the total capital expenditures up to the previous month. |
| Total Capital Expenditure Up To This Month | It shows the total capital expenditures up to current month. |
| Total Capital Expenditure - Total | It shows the total expenditure up to the previous month and total expenditure up to the current month. |
| Total Capital Expenditure - Balance Provision | It shows the total capital expenditures balance. |
| Interest Payment on Domestic Loans | This is kept as a row lable for the report. |
| Interest Payment on Domestic Loans - Codes | It shows the interest payment on domestic loan. |
| Interest Payment on Domestic Loans (Annual Provision) | The current budget for interest payment on domestic loans. |
| Interest Payment on Domestic Loans (Expenditure Up to Previous Month) | It shows the interest payment on domestic loans up to the previous month expenditure. |
| Interest Payment on Domestic Loans (Expenditure Up to This Month) | It shows the interest payment on domestic loans up to this month expenditure. |
| Interest Payment on Domestic Loans Total | Empty space, manually filled after generating the report. |
| Interest Payment on Domestic Loans Balance Provision | Empty space, manually filled after generating the report. |
| Interest Payment on Foreign Loans | This is kept as a row lable for the report. |
| Interest Payment on Foreign Loans - Codes | The interest payment on foreign loans code. |
| Interest Payment on Foreign Loans (Annual Provision) | The current budget for interest payment on foreign loans. |
| Interest Payment on Foreign Loans (Expenditure Up to Previous Month) | The interest payment on foreign loans it includes expenditure upto the previous month. |
| Interest Payment on Foreign Loans (Expenditure Up to This Month) | The interest payment on foreign loans it includes expenditure upto this month. |
| Interest Payment on Foreign Loans Total | Empty space, manually filled after generating the report. |
| Interest Payment on Foreign Loans Balance Provision | Empty space, manually filled after generating the report. |
| Total Interest Payment | This is kept as a row lable for the report. |
| Discount Amortization | This is kept as a row lable for the report. |
| Discount Amortization - Codes | The amortization discount code for item code 21603. |
| Discount Amortization (Annual Provision) | The current budget for discount amortization. |
| Discount Amortization (Expenditure Up to Previous Month) | Sum of the discount amortization up to the previous month expenditure. |
| Discount Amortization (Expenditure Up to This Month) | Sum of the discount amortization up to this month expenditure. |
| Discount Amortization Total | Empty space, manually filled after generating the report. |
| Discount Amortization Balance Position | Empty space, manually filled after generating the report. |
| Loan Flotation Expenditure | This is kept as a row lable for the report. |
| Loan Flotation Expenditure - Codes | The loan flotation expenditure code for item code 21701. |
| Loan Flotation Expenditure (Annual Provision) | The current budget for loan flotation expenditure. |
| Loan Flotation Expenditure (Expenditure Up to Previous Month) | The loan flotation expenditure up to the previous month. |
| Loan Flotation Expenditure (Expenditure Up to This Month) | The loan flotation expenditure up to this month. |
| Loan Flotation Expenditure Total | Empty space, manually filled after generating the report. |
| Loan Flotation Expenditure Balance Provision | Empty space, manually filled after generating the report. |
| Total Recurrent Expenditures | This is kept as a row lable for the report. |
| Total Recurrent Expenditures Annual Provision | It is the sum of the interest payment on domestic loans (expenditure up to previous month), interest payment on foreign loans (expenditure up to previous month), discount amortization (expenditure up to previous month) and loan flotation expenditure upto previous month. |
| Total Recurrent Expenditures Up to Previous Month | It is sum of all interest payment, discount amortization and loan flotation expenditure up to previous month. |
| Total Recurrent Expenditures Up to This Month | It is sum of all interest payment, discount amortization and loan flotation expenditure up to this month. |
| Total Recurrent Expenditures Total | It is the sum of the total recurrent expenditures up to previous month and total recurrent expenditures this month. |
| Total Recurrent Expenditures Balance Provision | It is the total balance amount of recurrent expenditure provision. |
| Total Debt Service Payments | This is kept as row lable for the report. |
| Total Debt Service Payments Annual Annual Provision | It is sum of total capital expenditure annual provision and total recurrent expenditures annual provision. |
| Total Debt Service Payments Up to Previous Month | It is sum of the total capital expenditure up to previous month and total recurrent expenditures up to previous month. |
| Total Debt Service Payments Up to This Month | It is sum of the total capital expenditure up to this month and total recurrent expenditures up to this month. |
| Total Debt Service Payments Total | It is sum of the total capital expenditure and total recurrent expenditures total. |
| Total Debt Service Payments Balance Provision | It is total debt service pament balance provison of all expenditures. |
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 Service Payment 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 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. |
 | 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. |