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.

FieldDescription
Fiscal YearIt 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 PeriodIt 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.
CommentAllows 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.

FieldDescription
Loan Repayments - DomesticIt is a report label.
Loan Repayments - Domestic CodesIt 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 TotalEmpty space, manually filled after generating the report.
Loan Repayments - Domestic Balance ProvisionEmpty space, manually filled after generating the report.
Loan Repayments - ForeignThis is kept as a row lable for the report.
Loan Repayments - Foreign CodesIt 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 ExpenditureThis is kept as a row lable for the report.
Total Capital Expenditure Annual ProvisionIt shows the total annual previous capital expenditures.
Total Capital Expenditure Up To Previos MonthIt shows the total capital expenditures up to the previous month.
Total Capital Expenditure Up To This MonthIt shows the total capital expenditures up to current month.
Total Capital Expenditure - TotalIt shows the total expenditure up to the previous month and total expenditure up to the current month.
Total Capital Expenditure - Balance ProvisionIt shows the total capital expenditures balance.
Interest Payment on Domestic LoansThis is kept as a row lable for the report.
Interest Payment on Domestic Loans - CodesIt 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 TotalEmpty space, manually filled after generating the report.
Interest Payment on Domestic Loans Balance ProvisionEmpty space, manually filled after generating the report.
Interest Payment on Foreign LoansThis is kept as a row lable for the report.
Interest Payment on Foreign Loans - CodesThe 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 TotalEmpty space, manually filled after generating the report.
Interest Payment on Foreign Loans Balance ProvisionEmpty space, manually filled after generating the report.
Total Interest PaymentThis is kept as a row lable for the report.
Discount AmortizationThis is kept as a row lable for the report.
Discount Amortization - CodesThe 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 TotalEmpty space, manually filled after generating the report.
Discount Amortization Balance PositionEmpty space, manually filled after generating the report.
Loan Flotation ExpenditureThis is kept as a row lable for the report.
Loan Flotation Expenditure - CodesThe 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 TotalEmpty space, manually filled after generating the report.
Loan Flotation Expenditure Balance ProvisionEmpty space, manually filled after generating the report.
Total Recurrent ExpendituresThis is kept as a row lable for the report.
Total Recurrent Expenditures Annual ProvisionIt 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 MonthIt is sum of all interest payment, discount amortization and loan flotation expenditure up to previous month.
Total Recurrent Expenditures Up to This MonthIt is sum of all interest payment, discount amortization and loan flotation expenditure up to this month.
Total Recurrent Expenditures TotalIt is the sum of the total recurrent expenditures up to previous month and total recurrent expenditures this month.
Total Recurrent Expenditures Balance ProvisionIt is the total balance amount of recurrent expenditure provision.
Total Debt Service PaymentsThis is kept as row lable for the report.
Total Debt Service Payments Annual Annual ProvisionIt is sum of total capital expenditure annual provision and total recurrent expenditures annual provision.
Total Debt Service Payments Up to Previous MonthIt 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 MonthIt is sum of the total capital expenditure up to this month and total recurrent expenditures up to this month.
Total Debt Service Payments TotalIt is sum of the total capital expenditure and total recurrent expenditures total.
Total Debt Service Payments Balance ProvisionIt 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 ImageDescription
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.