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.

v7 FreeBalance Help

FreeBalance Accountability Suite

Search

User login

Languages