Investment Reports
On Lending Summary Report
Overview
The main purpose is to list the actual Investment of sub-type On Lending and it's details.
Navigation
General Ledger ► Sub Ledgers ► Investment Register ► Investment Reports ► On Lending Summary Report
On Lending Summary Report Filter Fields
Fields | Description |
Vendor | Filter by Vendor code. This attribute implemented as look-up. |
Fiscal year | Year part of the creation date of the actual investments |
Share Holding Summary Report
Overview
Summary report on Share holding from Investment Register is extracted from through this screen by selecting the Investment Type as filtering criteria.
Navigation
General Ledger ► Sub Ledger ► Investment Register ► Investment Reports ► Share Holding Summary Report
Share Holding Summary Report screen Fields
Field | Description |
Investment Type | Type of Investment is selected from drop down box for filtering records. |
Vendor | Vendor Code |
Fiscal Period | Fiscal period of the report. Single Selection |
As at | Current system date |
SriLanka Reports
Debt Payment Forecast Report
Overview
This report retrieves information on all debt instruments that have been securities or loans. The report contains the Treasury bond, treasury bills, rupee loan, SLDB, and FCBU details breakup in domestic and foreign currencies. In addition, these also provide important information requires in the formulation of fiscal policy, such as forecasts of drawdown and debt servicing liabilities and debt implications of different fiscal and deficit financing policies.
A screenshot of the Debt Payment Forecast 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 Payment Forecast Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Investment Register ► Investment Reports ► SriLanka Reports ► Debt Payment Forecast Report.
Filters
The following table describes all filter fields for the Debt Payment Forecast 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.
| Filter | 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 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. |
| Type | It allows users to select the report type from the list. A value for this field is mandatory. |
Visible Field
The following table lists and describe all visible fields for the Debt Payment Forecast 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 Headers | It shows the report headers i.e. country logo, report time, report date, report name, etc. |
| Treasury Bond (FV) Capital | This shows the domestic debit amount for treasury bond capital transactions. |
| Treasury Bond (FV) Interest | This shows the domestic debit amount for treasury bond interest transactions. |
| Treasury Bills Capital | This shows the domestic debit amount for treasury bond capital transactions. |
| Treasury Bills Interest | This shows the domestic debit amount for treasury bond interest transactions. |
| Rupee Loan Capital | This shows domestic debit amount for treasury bond capital transactions. |
| Rupee Loan Interest | This shows domestic debit amount for treasury bond interest transactions. |
| SLDB Capital | This shows domestic debit amount for treasury bond capital transactions. |
| SLDB Interest | This shows domestic debit amount for treasury bond interest transactions. |
| FCBU Capital | This shows domestic debit amount for treasury bond capital transactions. |
| FCBU Interest | This shows domestic debit amount for treasury bond interest transactions. |
| ISB Capital | This shows domestic debit amount for treasury bond capital transactions. |
| ISB Interest | This shows domestic debit amount for treasury bond interest transactions. |
| Project Program Loans Capital | This shows domestic debit amount for treasury bond capital transactions. |
| Project Program Loans Interest | This shows domestic debit amount for treasury bond interest transactions. |
| Term Loan Capital | This shows domestic debit amount for treasury bond capital transactions. |
| Term Loan Interest | This shows domestic debit amount for treasury bond interest transactions. |
| Total Capital | It is the total amount of all capital transactions. |
| Total Interest | It is the total amount of all Interest transactions. |
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 Payment Forecast 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. |
Debt Stock Report
Overview
This report retrieves information on all debt instruments that have been securities or loans. Users can generate the report in different available formats that are PDF, Word, Excel, RTF, ODS, ODT, etc.
A screenshot of the Debt Stock 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 Stock Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Investment Register ► Investment Reports ► Sri Lanka Reports ► Debt Stock Report.
Filters
The following table lists describe all filters fields for the Debt Stock 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 lists the fiscal year to select as report filter. The current fiscal year is set as default value. |
Fiscal Period | It lists the fiscal period to select as report filter. The current fiscal period is set as default value. |
Visible Field
The following table lists and describes all visible fields for the Debt Stock 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.
| Fields | Description |
|---|---|
| Opening Balance Rupee Loan Face Value | The calculated opening balance rupee loan face value amount from general ledger where coding block object code is 42103003. |
| Opening Treasury Bills Book Value | The calculated opening treasury bills book value amount from general ledger where coding block object code is 14102001. |
| Opening Treasury Bills Face Value | The calculated opening treasury bills face value amount from general ledger where coding block object code is 42103001. |
| Opening Treasury Bonds Book Value | The calculated opening treasury bonds book value amount from general ledger where coding block object code is 14102002. |
| Opening Treasury Bonds Face Value | The calculated opening treasury bonds face value amount from general ledger where coding block object code is 14102002. |
| Opening SLDB | The calculated opening SLDB amount from general ledger where coding block object code is 42103004. |
| Opening FCBU | The calculated opening FCBU amount from general ledger where coding block object code is 42104002. |
| Opening Project and Program Loans | It shows the calculated opening project and program loan amount from general ledger where coding block object code has item 42202. |
| Opening Term Loan | It shows the calculated opening term loan amount from general ledger where coding block object code has item 42201. |
| Opening ISB | It shows the calculated opening ISB amount from general ledger where coding block object code has item 42203. |
| Add: Borrowings | It is report label for borrowings. |
| Month Name Borrows | It shows all month's name of the selected fiscal year. |
| Borrowing Rupee Loan Face Value | It shows the total borrowing rupee loan face value amount from approved journal voucher line items where coding block object code is 42103003. |
| Borrowing Treasury Bills Book Value | It shows the calculated balance amount month wise in report from approved journal voucher line items where coding block object code is 14102001. |
| Borrowing Treasury Bills Face Value | It shows month wise total domestic credit amount in borrowing treasury bills face value from approved journal voucher line items where coding block object code is 42103001. |
| Borrowing Treasury Bonds Book Value | It shows the month wise calculated amount in borrowing treasury bonds book value from approved journal voucher line items where coding block object code is 14102002. |
| Borrowing Treasury Bonds Face Value | It shows month wise total domestic credit amount in borrowing treasury bonds face value from approved journal voucher line items where coding block object code is 14102002. |
| Borrowing SLDB | It shows month wise total domestic credit amount in borrowing SLDB from approved journal voucher line items where coding block object code is 42103004. |
| Borrowing FCBU | It shows month wise total domestic credit amount in borrowing FCBU from approved journal voucher line items where coding block object code is 42104002. |
| Borrowing Project and Program Loans | It shows month wise total domestic credit amount in borrowing project and program loans from approved journal voucher line items where coding block object code is 42202. |
| Borrowing Term Loan | It shows month wise total domestic credit amount in borrowing term loan from approved journal voucher line items where coding block object code is 42201. |
| Borrowing ISB | It shows month wise total domestic credit amount in borrowing ISB from approved journal voucher line items where coding block object code is 42203. |
| Total Borrowing Rupee Loan Face Value | It shows the summation amount of all months borrowing rupee loan face values. |
| Total Borrowing Treasury Bills Book Value | It shows the summation amount of all months borrowing treasury bills book value. |
| Total Borrowing Treasury Bills Face Value | It shows the summation amount of all months borrowing treasury bills face value. |
| Total Borrowing Treasury Bonds Book Value | It shows the summation amount of all months borrowing treasury bond book value. |
| Total Borrowing Treasury Bonds Face Value | It shows the summation amount of all months borrowing treasury bond face value. |
| Total Borrowing SLDB | It shows the summation amount of all months borrowing SLDB. |
| Total Borrowing FCBU | It shows the summation amount of all months borrowing FCBU. |
| Total Borrowing Project and Program Loans | It shows the summation of all months for borrowing project and program loans. |
| Total Borrowing Term Loan | It shows the summation of all months for borrowing term loan. |
| Total Borrowing ISB | It shows the summation of all months for borrowing ISB. |
| Less: Repayments (Capital) | It is report label for repayments. |
| Month Name Repayments | It shows all months name for the selected fiscal year. |
| Repayments Rupee Loan Face Value | It shows month wise total domestic debit amount in repayment rupee loan face value from approved journal voucher line items where coding block object code is 42103003. |
| Repayments Treasury Bills Book Value | It shows month wise balance amount in repayment treasury bills book value from approved journal voucher line items where coding block object code is 23301001. |
| Repayments Treasury Bills Face Value | It shows month wise balance amount in repayment treasury bills face value from approved journal voucher line items where coding block object code is 42103001. |
| Repayments Treasury Bonds Book Value | It shows month wise balance amount in repayment treasury bonds book value from approved journal voucher line items where coding block object code is 23301002. |
| Repayments Treasury Bonds Face Value | It shows month wise balance amount in repayment treasury bonds face value from approved journal voucher line items where coding block object code is 42103002. |
| Repayments SLDB | It shows month wise balance amount in repayment SLDB from approved journal voucher line items where coding block object code is 42103004. |
| Repayments FCBU | It shows month wise balance amount in repayment FCBU from approved journal voucher line items where coding block object code is 42103004. |
| Repayments Project and Program Loans | It shows month wise balance amount in repayment project and program loan from approved journal voucher line items where coding block has item 42202. |
| Repayments Term Loan | It shows month wise balance amount in repayment term loan from approved journal voucher line items where coding block has item 42201. |
| Repayments ISB | It shows month wise balance amount in repayment term loan from approved journal voucher line items where coding block has item 42203. |
| Total Repayments | It is report label for total repayment. |
| Total Repayments Rupee Loan Face Value | Summation of repayments rupee loan face value amount for all months. |
| Total Repayments Treasury Bills Book Value | Summation of repayments treasury bill book value amount for all months. |
| Total Repayments Treasury Bills Face Value | Summation of repayments treasury bill face value amount for all months. |
| Total Repayments Treasury Bonds Book Value | Summation of repayments treasury bonds book value amount for all months. |
| Total Repayments Treasury Bonds Face Value | Summation of repayments treasury bonds face value amount for all months. |
| Total Repayments SLDB | Summation of repayments SLDB amount for all months. |
| Total Repayments FCBU | Summation of repayments FCBU amount for all months. |
| Total Repayments Project and Program Loans | Summation of repayments project and program Loans amount for all months. |
| Total Repayments Term Loan | Summation of repayments term Loans amount for all months. |
| Total Repayments ISB | Summation of repayments ISB amount for all months. |
| Ending Balance Rupee Loan Face Value | It shows the calculated amount for ending balance rupee loan face value. |
| Ending Balance Treasury Bills Book Value | It shows the calculated amount for ending balance treasury bills book value. |
| Ending Balance Treasury Bills Face Value | It shows the calculated amount for ending balance treasury bills face value. |
| Ending Balance Treasury Bonds Book Value | It shows the calculated ending balance treasury bonds book value. |
| Ending Balance Treasury Bonds Face Value | It shows the calculated amount for ending balance treasury bonds face value. |
| Ending Balance SLDB | It shows the calculated ending balance SLDB. |
| Ending Balance FCBU | It shows the calculated ending balance FCBU. |
| Ending Balance Project and Program Loans | It shows the calculated ending balance project and program loans. |
| Ending Balance Term Loan | It shows the calculated amount for ending balance term loan. |
| Ending Balance ISB | It shows the calculated amount for ending balance ISB. |
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 Stock 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. |