Sri Lanka Reports
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. |
Guarantee Ceiling Report
Overview
This report shows status of the guarantees issued by the government as of the current date.
A screenshot of the Guarantee Ceiling 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 Guarantee Ceiling Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantee Ceiling Information Report.
Visible Fields
The following table lists and describes all visible fields for the Guarantee Ceiling Report, in their default order. The language of the report depends on the configuration of the system.
| Field | Description |
|---|---|
| Report Date | The current system date. |
| Report Time | The current system date. |
| User Code | Information of the user who has generates the report. |
| Current Date | The current date, up to when the report is generated. |
| Guarantee Ceiling | It shows the guarantee ceiling amount. |
| Guarantees Issues Previous Fiscal Year | It is the sum of the previous fiscal year domestic guarantee issued amount. |
| Guarantees Issues Current Fiscal Year | It is the sum of the current fiscal year domestic guarantee issued amount. |
| Letter of Comfort Issued | It is the sum of domestic guarantee issued amount for the instrument. |
| Total of Guarantees Issued & Letter of Comfort Issued | It is the grand total amount of all letter of comfort issued, previous year and current year guarantees issued. |
| Balance Available | It shows the calculated balance amount. |
| Guarantees Approved - To be Issued | It shows the creditor agency with project name. |
| Foreign Amount | It displays the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency. |
| Domestic Amount | The domestic amount. |
| Total Sum | The total sum of domestic amount. |
| Guarantees Approved - Tranches to be Issued | It shows the creditor agency with project name. |
| Foreign Amount | It shows the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency. |
| Domestic Amount | The domestic amount. |
| Total Sum | The total sum of domestic amount. |
| Treasury Guarantees - Pending Cabinet Approval | It shows the creditor agency with project name, where cabinet decision on status is pending. |
| Foreign Amount | It display the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency. |
| Domestic Amount | The domestic amount. |
| Total Sum | The total sum of domestic amount. |
| Sovereign Guarantees - Pending Cabinet Approval | It shows the creditor agency with project name, where cabinet decision on status is pending. |
| Foreign Amount | It shows the foreign amount, it uses the current exchange rate to convert the foreign currency to domestic currency. |
| Domestic Amount | The domestic amount. |
| Total Sum | The total sum of domestic amount. |
| Reserved Balance | The grand total amount. |
| Total Guarantees Issued & Reserved | The sum of the reserved balance and total of guarantees issued & letter of comfort issued. |
| Balance Available for New Issues | The available balance amount for new issues. |
| Percentage of Total Guarantees Issued & Reserved | Percentage of total guarantees issued and reserved. |
| CBSL Exchange Rates as at (Current Date) | All the exchange rates used to convert the external guarantees from foreign currency to domestic currency. |
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 Guarantee Ceiling 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. |
Guarantee Type Report
Overview
The report shows the total guarantee issued by debt types and the issued amount as a % of the total guarantees issued.
A screenshot of the Guarantees Type Report feature is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to the parameter, rendering control configuration and installed the revision.
Users access the report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees Type Report.
Filters
The following table lists and describes all filter for the Guarantees Type Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.
| Field | Description |
|---|---|
| Creditor Agency | It refers to the creditor agencies of the Debt Instrument. Users may select creditor agency to filter the report. |
| Status | It is a mandatory field. It refers the status open or close of the guarantees. |
| Issue Date | Refers to the issue date of the guarantees. |
| Expiry Date | Refers to the expiry date of the guarantees. |
Visible Fields
A sample of the Guarantee Type Report output is available here. The following table lists and describes all visible fields for the Guarantees Type 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 |
|---|---|
| No. | Indicates serial numbers. |
| Name of Institution | Creditor Agency names of the guarantees. |
| Treasury Guarantees | Amount for the domestic guarantees issued. |
| Sovereign Guarantees | Amount for the foreign guarantees issued. |
| Total (Column) | This is a calculated field, shows sum of domestic and foreign guarantees. |
| Issued % | Ths is percentage of total guarantees issues for the institution over the total gurantees issued. |
| Total (Row) | This is calculated field, shows the sum of columns. |
| CBSL Exchange Rates as at (Current Date) | This show a table with all the exchange rates used to convert the external guarantees from foreign currency to domestic currency. |
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 Guarantees Type Report.
| Button Image | Description |
|---|---|
 | This button allows users to generate the report as PDF. |
 | This button allows users to generate the report as MS Excel. |
 | This button allows users to generate the report as MS Excel (XLSX format). |
 | This button allows users to generate the report as RTF. |
 | This button allows users to generate the report as MS Word. |
 | This button allows users to generate the report in ODT format. |
 | This button allows users to generate the report in ODS format. |
Guarantees Issued Bank Wise Report
Overview
This report generates the list of guarantees issued by the general treasury. It provides different filter option to generate the report.
A screenshot of the Guarantees Issued Bank Wise 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 Guarantees Issued Bank Wise Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees Issued Bank Wise Report.
Filters
The following table lists and describe all filter fields for the Guarantees Issued Bank Wise 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 |
|---|---|
| Financial Institution | It allows users to select the financial institution as a filter by using the lookup feature. |
| Status | It lists the status and allows users to select it as report filter. |
| From Issuance Date | The date picker allows users to put the 'issuance date from' as a filter for the report. |
| To Expire Date | The date picker allows users to put the 'to expire date' as a filter for the report. |
| Comment | Users can enter a relevent comment, added to the generated report. |
| Sort By | It provide sorting filter for the report. |
Visible Fields
The following table lists and describes all visible fields for the Guarantees Issued Bank Wise 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 |
|---|---|
| S.No | Sequence number. |
| Name of the Bank or Institution | Name of the bank/institution receiving the guarantee. |
| Name of Institution | Name of the financial institute. |
| Rs. Mn. | Guarantee issued domestic amount in millions. |
| Total per Name of the Bank or Institution | Total amount grouped as per the name of the bank or institution. |
| Grand Total Rs. Mn. | Sum of the Rs. Mn. |
| Grand Total | Grand total 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 Guarantees by SOE 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. |
 | The Lookup tool allows users to browse and select existing items. |
 | Allow to select a calendar date. |
Guarantees Summary Report
Overview
The report shows the total guarantee issued to institutions or creditor agencies by banks or financial institutions.
A screenshot of the Guarantees Summary Report feature is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to the parameter, rendering control configuration and installed the revision.
Users access the report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees Summary Report.
Filters
The following table lists and describes all filter for the Guarantees Summary Report, in their default order. Note that some filters depend on system parameters and rendering control to be visible and/or editable to users. Filter names are subject to change through language label configuration.
| Field | Description |
|---|---|
| Creditor Agency | It refers to the creditor agencies of the Debt Instrument. Users may select creditor agency to filter the report. |
| Status | It is a mandatory field. It refers the status open or close of the guarantees. |
| Issue Date | Refers to the issue date of the guarantees. |
| Expiry Date | Refers to the expiry date of the guarantees. |
| Comment | Allows users to add a custom comment to the generated report. |
Visible Fields
A sample of the Guarantees Summary Report output is available here. The following table lists and describes all visible fields for the Guarantees Summary 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 |
|---|---|
| No. | Indicates serial numbers. |
| Name of Institution | Creditor Agency names of the guarantees. |
| Name of the Bank or Financial Institution | This refers to the financial institutions or banks that issues the guarantees. |
| Total (Column) | This is a calculated field, displaying the sum of all the bank or financial institutions for the Creditor agency. |
| Total (Row) | This is a calculated field, displaying the sum of all the creditor agencies for the bank or financial institution. |
| CBSL Exchange Rates as at (Current Date) | This show a table with all the exchange rates used to convert the external guarantees from foreign currency to domestic currency. |
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 Guarantees Summary Report.
| Button Image | Description |
|---|---|
| This button allows users to generate the report as PDF. |
| This button allows users to generate the report as MS Excel. |
| This button allows users to generate the report as MS Excel (XLSX format). |
| This button allows users to generate the report as RTF. |
| This button allows users to generate the report as MS Word. |
| This button allows users to generate the report in ODT format. |
| This button allows users to generate the report in ODS format. |
Guarantees by SOE Report
Overview
This report retrieves information on all debt instruments that have been guarantees. It provides different filters which help users generate the report as per their requirements.
A screenshot of the Guarantees by SOE 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 Guarantees by SOE Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► Sri Lanka Reports ► Guarantees by SOE Report.
Filters
The following table lists and describe all filter fields for the Guarantees by SOE 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 |
|---|---|
| Creditor Agency | It allows users to select the creditor agency using the lookup feature. |
| Status | It lists and allows users to select the guarantee status from the list as filter. A value for this field is mandatory. Open status is set as default value. |
| Issue Date | It allows to enter the guarantees issue date using the date picker. |
| Expiry Date | It allows to enter the guarantees expiry date using the date picker. |
| Comment | Users can enter a comment for the report. |
| Sort By | It provide sorting filter for the report. |
Visible Fields
The following table lists and describes all visible fields for the Guarantees by SOE 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 |
|---|---|
| Report Date | The current system date appears on the report. |
| Report Time | The current system time appears on the report. |
| User Code | The user code who generates the report. |
| Issue Date | The issue date. |
| Fiscal Year | Fiscal year from filter criteria. |
| Sequence Number | Sequential row number. |
| Creditor Agency (SOE) | The creditor agency name. |
| Name of Bank/Institution | The name of the bank/institution associated with the creditor agency. |
| Rs. Mn. | Sum of guarantee issued amount in millions. |
| Total Rs. Mn. | Sum of guarantee issued amount in millions. It is grouped by creditors agency. |
| Total Rs. Mn. Amount | It is sum of all Rs. Mn. |
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 Guarantees by SOE 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. |