General Ledger
The General Ledger module is part of the Financial Core of the GRP.
It serves as the central repository for all transactions that have been entered in the GRP, whether they are expenses, revenues, purchasing accruals, or others. Every transaction entered is posted to the General Ledger, allowing to create periodic financial statements to see the financial status up to a given date. In addition, this module also serves as an adjustment mechanism, allowing to redistribute costs among accounts and to correct any posting errors.
Accounts Payable Previous Years
Overview
This entity is will use to control the payable accounts previous years.
Navigation
General Ledger ► Accounts Payable Previous Years
Accounts Payable Previous Years Screen Fields
Fields | Description |
Code | Automatically generated by the system, and is increased based on a sequence |
Institution | Contains the name of the Institution. |
Vendor | Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity. |
Support Document | Unique code that identifies the document type |
Currency | Indicates the transaction currency for the Accounts Payable. |
Class & Sub Class | Lookup button that shows GLT Class Name, GLT Subclass Name, GLT Detail Name, GLT Name to choose a single one GLT. |
Active | Indicate if the RAPY is active or not. Default = True |
Supporting Document Date | Date of No. document that supports the original Transaction |
Supporting Document Due Date | Date of Expiration of the No. document that supports the original Transaction |
Exchange Rate | Exchange rate, Control Currency. |
Total Opening Amount Domestic | System will automatically display the sum of the attribute “Amount (Domestic)” from Accounts Payable Previous Years Details |
Total Opening Amount Foreign | System will automatically display the sum of the attribute “Amount (Foreign)” from Accounts Payable Previous Years Details |
Total Discount Amount Domestic | System will automatically display the sum of the attribute “Discount Amount (Domestic)” from Accounts Payable Previous Years Details |
Total Discount Amount Foreign | System will automatically display the sum of the attribute “Discount Amount (Foreign)” from Accounts Payable Previous Years Details |
Total Penalty Amount Domestic | System will automatically display the sum of the attribute “Discount Amount (Domestic)” from Accounts Payable Previous Years Details |
Total Penalty Amount Foreign | System will automatically display the sum of the attribute “Penalty Amount (Domestic)” from Accounts Payable Previous Years Details |
Total Interest Amount Domestic | System will automatically display the sum of the attribute “Interest Amount (Domestic)” from Accounts Payable Previous Years Details |
Total Interest Amount Foreign | System will automatically display the sum of the attribute “Interest Amount (Foreign)” from Accounts Payable Previous Years Details |
Total Pay Amount Domestic | Read only. Calculated from Accounts Payable Previous Years Details |
Total Pay Amount Foreign | Read only. Calculated from Accounts Payable Previous Years Details |
Total Differential Exchange Profit Domestic | System will automatically display the sum of the attribute “Differential Exchange Amount (Foreign)” from Accounts Payable Previous Years Details |
Total Differential Exchange Profit Amount (Foreign Currency) | System will automatically display the sum of the attribute “Differential Exchange Amount (Foreign)” from Accounts Payable Previous Years Details |
Total Differential Exchange Missed Domestic | System will automatically display the sum of the attribute “Exchange Amount (Foreign)” from Accounts Payable Previous Years Details |
Total Differential Exchange Missed Foreign | System will automatically display the sum of the attribute “Differential Exchange Amount (Foreign)” from Accounts Payable Previous Years Details |
Domestic Balance | Read Only |
Foreign Balance | Read Only |
Total Elimination Domestic | Pay Amount (Foreign) from Accounts Payable Previous Years Details |
Total Elimination Foreign | Pay Amount (Foreign) from Accounts Payable Previous Years Details |
Total Incorporation Domestic | Pay Amount (Foreign) from Accounts Payable Previous Years Details |
Total Incorporation Foreign | Pay Amount (Foreign) from Accounts Payable Previous Years Details |
Origin | Read Only |
Description | Description of the registered account, It contains all the description of the record of the account will be conducting, Localized field. |
Attachment Tab
Attachment Tab Screen Fields
Fields | Description |
Id | Unique identifier. |
Title | Title of the Journal Voucher. |
Description | Short description of the Journal Voucher. |
Attachment Classification | Classification of the Attachment. |
Date Time | Displays the date and time automatically when the file was attached. |
Date | Date of the last operation performed on the attachment document. |
User | Last user who uploaded or updated the document. Visible for the user. Automatically assigned by the system. |
Closing Accounting Year
Floating Debt Recognition
Overview
Allows users to find all unpaid debt from the prior fiscal year and move it to the current fiscal year to be paid. This process is executable only once per year.
Navigation
General Ledger ► Closing Accounting Year ► Floating Debt Recognition
Floating Debt Recognition Screen Field
| Fields | Description |
| Fiscal Year | System provides a list of Fiscal Years in descendant order (current fiscal year on top). Users select from which fiscal year process needs to work on. If users do not select fiscal year, system shows a message 'Please select fiscal year to process'. |
Redistribution GL Opening Balance
Overview
This feature shows the Redistribution Of General Ledger Opening Balances.
Navigation
General Ledger ► Closing Accounting Year ► Redistribution GL Opening Balance
Redistribution GL Opening Balance Screen Fields
| Fields | Description |
| Prior Fiscal Year | Allows user to select fiscal year from drop down list. |
| Currency | Show only active currencies. |
| Workflow Status | Calculated read only field. Depending on the workflow configuration setting, the basic Stages are: Created, Approval Requested, Approved, Cancelled, Finalized. |
| Origin | Close Domain: possible values are MANUAL, DATA IMPORT |
| Coding Block | Financial coding block from COA set for budget execution or accounting Level. Full coding block is required. |
| Sub Ledger Type | If coding block has a subledger type associated in the subledger, system sets this attribute with that Subledger Type, users cannot change it. |
| Sub Ledger Institution Code | Allows users to select Sub Ledger Institution Code from the look up functionality. |
| Current Domestic Closing Balance | This field is read only and the value comes from reading the corresponding GL |
| Current Foreign Closing Balance | This field is read only and the value comes from reading the corresponding GL |
| Total Redistributed Amount Dc | This field is read only and updated only by the move of the opening blances process |
| Total Redistributed Amount Fc | This field is read only and updated only by the move of the opening blances process |
| Redistribution GL Opening Balance Details | Collection of 1 or more details which are include to redistribute the Opening Balance |
Redistribution Of General Ledger Opening Balances Detail
Overview
This tab is the Collection of 1 to N fields which will be include to redistribute the Opening Balance.
Redistribution Of General Ledger Opening Balances Detail Screen Fields
| Fields | Description |
| Coding Block | Financial coding block where COA budget execution = true or Accounting Level = True. Full line of coding is required. |
| Sub Ledger Type | If Coding Block has a Subledger Type associated in the Subledger Entity, the system will set this attribute with that Subledger Type, and the user cannot be change it. |
| Sub Ledger Institution Code | Allow user to select Sub Ledger Institution Code from look up button. |
| Redistributed Percentage | User can enter Decimal value. |
| Current Domestic Redistributed Balance | Calculated field. |
| Current Foreign Redistributed Balance | Calculated field. |
| Redistributed Amount Dc | This field is read only and updated only by the move of the opening blances process |
| Redistributed Amount Fc | This field is read only and updated only by the move of the opening blances process |
Settlement and Closing of Revenues and Expenditures
Overview
This process is used to close all the revenues and expenditures accounts, and obtain the result of the fiscal year from the accounting point of view.
Navigation
General Ledger ► Closing Accounting Year ► Settlement and Closing of Revenues and Expenditures
Settlement and Closing of Revenues and Expenditures Screen Field
| Fields | Description |
| Fiscal Year | Shows a list with all the Fiscal Year with Open status. |
Consolidation Of Financial Statements and Accounting Institutions
Consolidated Balance Sheet Nicaragua Format
Overview
The Consolidated Balance Sheet Report provides a complete financial statement. It helps users to analyse the entire financial position of all the institutions from the non-financial public sector, up to a certain fiscal period. It is useful to understand from the accounting point of view, the status of the entire institutions from the non-financial public sector, thru the assets, liabilities, and equity. This report obtains information from the consolidation of the financial statement and accounting institution process.
A screenshot of the Consolidated Balance Sheet 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 Consolidated Balance Sheet Report from within the menu through this navigation path: General Ledger ► Consolidation Of Financial Statements and Accounting Institutions ► Consolidated Balance Sheet Nicaragua Format.
Filters
The following table lists and describe all filter fields for the Consolidated Balance Sheet Report, in their default order. Note that some fields depend on the 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 lists the fiscal year to select them as report filter. A value for this field is mandatory. The current fiscal year is set as a default filter. |
| Fiscal Period | It lists the fiscal year to select them as report filter. A value for this field is mandatory. The current fiscal period is set as a default filter. |
| Comment | Allows users to add a custom comment to the generated report. |
| Coding Block Filter Type | It lists the coding block filter type to select them as a report filter. A value for this field is not mandatory. |
| Segment | It lists the segment to select them as a report filter. A value for this field is not mandatory. |
| Concept | It lists the concept to select them as a report filter. A value for this field is not mandatory. |
Visible Field
The following table lists and describe all visible fields for the Borrowings Summary 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 |
|---|---|
| Structure | It prints the structure of the account plan. |
| Central Administration | It only prints central administration coding blocks values. |
| Decentralized Administration | It includes the value from the elements:
|
| Total Central Government | This column contains the total values of the central and decentralized administration. |
| Total Other Autonomous Institutions of the State | This column contains the value from the other autonomous organs of the state coding block element. |
| Total Regional Governments | This column contains the values of autonomous regional governments or indigenous territorial governments coding block elements. |
| Total Local Governments | This column contains the value of municipal government coding block elements. |
| Total Government | This column is the sum of columns total other autonomous institutions of the state, total regional governments and total local governments. |
| Total Non-Financial Public Institutions | This column only includes the value from the national financial public companies or municipal non-financial public companies element-coding block. |
| Total Non-Financial Public Sector | This column keeps the sum of the total government and total non-financial public institutions. |
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 Consolidated Balance Sheet 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. |
 | Lookup Button allows the user to search the coding block. |
GL Consolidation Master
Overview
Obtain and publish the execution of the budget, represents the situation financial budgetary consolidation of the entire Non-Financial Public Sector from the Accounting point of view.
Navigation
General Ledger ► Consolidation Of Financial Statements and Accounting Institutions ► Consolidation Master
Consolidation Master Screen Fields
Fields | Description |
Code | Consecutive unique number, automatically generated and assigned by the system. |
Fiscal Year | Default value is Actual Fiscal Year. |
Fiscal Period | Only shows Fiscal Periods with Status ‘CLOSED’, related to previously selected fiscal year. |
Workflow Status | The Workflow Process Status of the Consolidation Master automatically generated and updated. |
Consolidation Type | Allows to select consolidation type from drop down list. |
| Sector Element | Look up button associated with the sector element. |
Organization Element | Look up button associated with the organization element. |
Created By | User who created the record. |
Created Date | Date and time of creation of the consoldation record. |
Approved By | User who approved the Cutoff Validations. |
Approved Date | Date and time in which the Consolidation Master turns to ‘Approved’ Status. |
| Consolidation Details | Collection of Consolidation Details, it is optional to add destails. |
Consolidation Details Tab
Overview
Collection of Consolidation Details.
Consolidation Details Tab Screen Fields
Fields | Description |
Serial Number | Consecutive unique number, automatically generated and assigned by the system. |
CoA Group | COA where the group belongs. |
Coding Block | Full Coding Block from COA Group |
Detail Status | Allows to select Detail status from drop down list. |
Current Amount | Hide By Default |
Current Amount Modified | Hide By Default |
Accrued Amount | Hide By Default |
Accrued Amount Modified | Hide By Default |
Initial Balance | Initial balance of Consolidation |
Debit Amount | Debit amount of the Consolidation |
Credit Amount | Credit amount of the Consolidation |
Reconciliation of Reciprocal Transactions
Overview
The goal of this process is identify and eliminate transactions that are equivalent (reciprocal) between two or more institutions from the same group, for example, one budget transfer from Institution A (expenditure) to institution B (Income) is consider equivalent and candidate to be conciliated and eliminated, because it is not a real expense and is not considered a real income.
Navigation
General Ledger ► Consolidation Of Financial Statements and Accounting Institutions ► Reconciliation of Reciprocal Transactions
Reconciliation of Reciprocal Transactions Screen Fields
| Fields | Description |
| Fiscal Year | Allows users to select fiscal year from drop down list. |
| Fiscal Period From | Mandatory field, allows to select the starting range of fiscal periods. |
| Fiscal Period To | Mandatory field allows to select the ending range of fiscal periods. |
| Consolidation Type | Allows user to select consolidation type from drop down list. |
| Status | Allows users to select the status of Reconciliation of Reciprocal Transactions from the drop down list. Possibe values are 'Active', 'Deleted', 'Reconciled'. |
Differential Exchange Other Account
Overview
The purpose of this process is to update the balances of the accounting structure, (selected accounts diferents of external debts) and present the financial statements and analytical accounting reports reconciled with equivalent balances in national currency and adjusted according to the applicable rules.
Navigation
General Ledger ► Differential Exchange Other Account
Differential Exchange Other Account Screen Fields
Fields | Description |
Id | Unique Id Auto generated based on the Parameter |
Workflow Status | The Workflow Process Status of the Exchange Difference Other Balance Accounts automatically generated and updated. |
Origin | Default=’Manual’ |
Active | Default value is TRUE. If this false Foreign Other Accounts Exchange Differential is DEACTIVED |
Fiscal Year | Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True) |
Fiscal Period | Fiscal Period of Default current period |
Created By | Populated automatically by the system, when the document is requested. |
Created Date | Populated automatically by the system in time of application for registration. |
Approved By | Populated automatically by the system, when the document is approved. |
Approved Date | Populated automatically by the system in time of approved for registration. |
Language | Country specific language |
Description | Short description of the account |
Foreign Debt Exchange Differential
Overview
The purpose of this process is to update the balances of the accounting structure, (debt accounts) and present the financial statements and analytical accounting reports reconciled with equivalent balances in national currency and adjusted according to the applicable rules.
Navigation
General Ledger ► Foreign Debt Exchange Differential
Foreign Debt Exchange Differential Screen Fields
Fields | Description |
Id | Unique Id Auto generated based on the Parameter |
Workflow Status | The Workflow Process Status of the Foreign Debt Exchange Differential automatically generated and updated. |
Active | Default value is TRUE. If this false Foreign Debt Exchange Differencial is DEACTIVED |
Fiscal Year | Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True) |
Fiscal Period | Fiscal Period of Default current period |
Reason | This attribute save the reason of the process |
Object Code | Object Code of the COA |
UACS | This is a String parameter and specifies the short name of Element for Object Code of the COA |
Sub Ledger Type | Allows to select Sub Ledger Type from dropdown list |
Sub Ledger Code | If Sub-Ledger Type is 'Debt Instrument' then Ref: Debt Instrument. If Sub-Ledger Type is 'Loan Register' then Ref: Loan entity |
Credit Debit | Allows to select Credit Debit from dropdown list |
Balance Amount | Total of Balance to the date entered |
Origin | Default=’Manual’ |
Created By | Populated automatically by the system, when the document is requested. |
Created Date | Populated automatically by the system in time of application for registration. |
Approved By | Populated automatically by the system, when the document is approved. |
Approved Date | Populated automatically by the system in time of approved for registration |
Foreign Balance | Total of Balance to the date entered |
Batch Number | The Number of the batch that belongs. |
Institution | Associated with the accounting office. |
Receivable Account Previous Years
Overview
This entity is used to define a receivable account for a specific vendor. This account will be unique per combination of vendor and specific account type based on the account receivable concept element assigned to the corresponding accounting office. Access to this entity will be subjected to regular functional class security and will be assigned a workflow.
Navigation
General Ledger ► Receivable Account Previous Years
Receivable Account Previous Years Screen Fields
Fields | Description |
Id | Automatically generated by the system, and is increased based on a sequence |
Workflow Status | The Workflow Process Status of the Receivable Account Previous Years automatically generated and updated. |
Institution | Contains the name of the Institution. |
Vendor | Vendor Code. A hyperlink to be provided to drill down to the Vendor screen, a new window to be opened to display the attributes from the Vendor entity. |
Document Type | Unique code that identifies the document type |
Currency | Indicates the transaction currency for the Receivable Account. |
Exchange Rate | The exchange rate for the chosen currency. |
General Ledger Function Class | Lookup button that shows GLT Class Name, GLT Subclass Name, GLT Detail Name, GLT Name to choose a single one GLT. |
Active | Indicate if the RAPY is active or not. Default = True |
Supporting Document No | No. document that supports the transaction |
Supporting Document Date | Date of No. document that supports the original Transaction |
Supporting Document Due Date | Date of Expiration of the No. document that supports the original Transaction |
Opening Total Domestic | System will automatically display the sum of the attribute “Amount (Domestic)” from Receivables Accounts Details Previous Years Details |
Opening Total Foreign | System will automatically display the sum of the attribute “Amount (Foreign)” from Receivables Accounts Details Previous Years Details |
Total Discount Domestic | System will automatically display the sum of the attribute “Discount Amount (Domestic)” from Receivables Accounts Details Previous Years Details |
Total Discount Foreign | System will automatically display the sum of the attribute “Discount Amount (Foreign)” from Receivables Accounts Details Previous Years Details |
Total Penalty Domestic | System will automatically display the sum of the attribute “Discount Amount (Domestic)” from Receivables Accounts Details Previous Years Details |
Total Penalty Foreign | System will automatically display the sum of the attribute “Penalty Amount (Domestic)” from Receivables Accounts Details Previous Years Details |
Total Interest Domestic | System will automatically display the sum of the attribute “Interest Amount (Domestic)” from Receivables Accounts Details Previous Years Details |
Total Interest Foreign | System will automatically display the sum of the attribute “Interest Amount (Foreign)” from Receivables Accounts Details Previous Years Details |
Total Differential Exchange Profit Domestic | System will automatically display the sum of the attribute “Differential Exchange Amount (Foreign)” from Receivables Accounts Details Previous Years Details |
Total Differential Exchange Profit Amount (Foreign Currency) | System will automatically display the sum of the attribute “Differential Exchange Amount (Foreign)” from Receivables Accounts Details Previous Years Details |
Total Differential Exchange Missed Domestic | System will automatically display the sum of the attribute “Exchange Amount (Foreign)” from Receivables Accounts Details Previous Years Details |
Total Differential Exchange Missed Foreign | System will automatically display the sum of the attribute “Differential Exchange Amount (Foreign)” from Receivables Accounts Details Previous Years Details |
Total Receivable Domestic | System will automatically display the sum of the attribute “Pay Amount (Domestic)” from Receivables Accounts Details Previous Years Details |
Total Receivable Foreign | System will automatically display the sum of the attribute “Pay Amount (Foreign)” from Receivables Accounts Details Previous Years Details |
Balance Domestic | Read Only |
Balance Foreign | Read Only |
Elimination Domestic | Pay Amount (Foreign) from Receivables Accounts Details Previous Years Details |
Elimination Foreign | Pay Amount (Foreign) from Receivables Accounts Details Previous Years Details |
Incorporation Domestic | Pay Amount (Foreign) from Receivables Accounts Details Previous Years Details |
Incorporation Foreign | Pay Amount (Foreign) from Receivables Accounts Details Previous Years Details |
Origin | Read Only |
Description | Description of the registered account, It contains all the description of the record of the account will be conducting, Localized field. |
Attachment Tab
Attachment Tab Screen Fields
Fields | Description |
Id | Automatically generated by the system, and is increased based on a sequence |
Title | Title of the Journal Voucher. |
Description: | Short description of the Journal Voucher. |
Attachment Classification | Classification of the Attachment. |
Date Time | Displays the date and time automatically when the file was attached. |
Date | Date of the last operation performed on the attachment document. |
User | Last user who uploaded or updated the document. Visible for the user. Automatically assigned by the system. |
Statement Of Changes In Equity
Support Entities
Variation
Overview
Entity that contains the header data of the calculation process, depending on the level that is required for the analysis of variations in the accounts.
Navigation
General Ledger ► Statement of Changes in Equity ► Support Entities ►Variation
Variation Screen Fields
Fields | Description |
Id | Internal reference number. |
Fiscal Year | Initial fiscal year, the period of analysis for process variations in statements of changes. |
Fiscal Period | Fiscal Period of the voucher, Default current period |
UACS | Financial coding block where COA budget execution = true or Accounting Level = True. Full line of coding is required Unique for each Fiscal Year |
Accounting Level | Allows to select Accounting Level from drop down list. |
Opening Domestic Debit Balance | Opening Domestic Debit Balance for the Fiscal Year |
Opening Domestic Credit Balance | Opening Domestic Credit Balance for the Fiscal Year |
Actual YTD Domestic Debit | Actual YTD corresponds to the final date selected |
Actual YTD Domestic Credit | Actual YTD corresponds to the final date selected |
Variation Amount | Calculated/Updated Display Only Field |
Variation Classification
Overview
Sub Ledgers are used to breakdown the General Ledger into control oriented units. A defined GL Coding Block (or part of it) is linked to the Sub Ledger in the FreeBalance Accountability Suite. If the GL Parameter Sub Ledger Control is enabled, the system prevents the use of any GL Code or part of GL Code without specifying the linked Sub-ledger code such as Customer, Vendor or Bank Account amounts.
Navigation
General Ledger ► Statement of Changes in Equity ► Support Entities ►Variation Classification
Variation Classification Screen Fields
Fields | Description |
Code | Automatically generated by the system, and is increased based on a sequence |
Active | Default value is True. If its false, this classification no longer active |
Origin | Default is Manual |
Description | Short description about classification. |
Variation Detail
Overview
Data entity containing the details of the transactions that were identified for the calculation of accounting variation.
Navigation
General Ledger ► Statement of Changes in Equity ► Support Entities ► Variation Detail
Variation Detail Screen Fields
Fields | Description |
Id | Internal reference number. |
Variation | Parent ref to Variation Entity |
Source Document | Number of JV transaction with which you registered |
UACS | Coding Block Information |
Debit Amount | Original amount of Debit registered with JV, If the operation is to Credit default value = 0 |
Credit Amount | Original amount of Debit registered with JV, If the operation is to Debit default value = 0 |
Transaction Date | Date Approve Transaction |
Variation Classification | The Classification saved by the user in the Manual Process of Classification of the Accounts |
Sub Ledgers
Accountable Advances
Accountable Advances
Overview
This entity describes the list of accountable advances given by the Organization. It keeps track of the outstanding balance of the advance by tracking all payments (debits) and recoveries (credits).
Navigation
General Ledger ► Sub Ledgers ► Accountable Advances► Accountable Advance
Accountable Advances Screen Fields
Fields | Description |
Code | Unique identification code. System generated or manually entered by the user depending on the system parameter. |
Workflow Status | The Workflow Process Status of the voucher automatically generated and updated. |
Currency | Indicates the transaction currency for the Advance. |
Exchange Rate | The exchange rate for the chosen currency. |
Advance Type | Indicates the Advance Type for the Accountable Advance. |
Coding Block | Coding Block for the Accountable Advance. |
Accounting Office | Accounting Office Code By default use current employee institution |
Purchase Order | Only enabled if Advance Type is linked to Purchase Order and will allow the user to select respective Purchase Order. |
PO Advance Limit Percentage | Only enabled if Purchase Order is selected. This field is to define advance limit, means the percentage of the PO Total Amount that can be provided as an Advance to the Supplier. |
Advance Status | Indicates if the Advance is Open and transactions can be posted against it, or it is closed and no transactions ca be posted against it. |
Holder | Refers to the Vendor to whom the advance will be issued. |
Domestic Advance Limit Amount | This is to define the maximum limit of money to be advanced. If the advance is linked to a PO, this amount must be less than the PO amount. |
Pay Advance In Single Installement | If Advance Type is True, then this attribute is true and is disabled (user cannot change). If Advance Type is False, then this attribute is enabled (user can change it), default value is False. |
Domestic Paid Amount | This is the running total of the amount that has been advance to the holder. System calculated, sum of GL debit entries against the sub-ledger. |
Domestic Recovered Amount | This is the running total of the recovered amount of the advance. System calculated, sum of GL credit entries against the sub-ledger. |
Domestic OutStanding Balance Amount | Calculated/Updated Display Only Field |
Created By | System will automatically populate this attribute. |
Creation Date | The Accountable Advance created on. This is auto populated by the system. |
Approved By | System will automatically populate this attribute. |
Approved Date | Timestamp of approval |
Language | The language used to enter the description. |
Name | Name of the Advance. |
Description | Description for the advance. |
Advance Transaction Schedule Tab
Advance Transaction Schedule Tab Screen Fields
Fields | Description |
Sequence Number | Sequential number of the Advance Schedule. |
Transaction Type | Indicates the type of the transaction. Possible values are Payment and Recovery. |
Forecast Transaction Date | Non-mandatory. To define the expected transaction date. |
Forecast Transaction Amount Domestic | This is the expected transaction amount in domestic currency. |
Forecast Transaction Amount Foreign | This is the expected transaction amount. Enabled if Accountable Advance currency = Foreign. |
Actual Transaction Date | Indicates the actual transaction date. This is auto populated by the system from the processes. |
Actual Transaction Amount Domestic | Indicates the actual transaction domestic amount. This is auto populated by the system from the processes. |
Actual Transaction Amount Foreign | Indicates the actual transaction foreign amount. Applicable when the Accountable Advance is in foreign currency. This is auto populated by the system from the processes. |
Is Executed | This is auto populated by the system from the processes. |
Advance Type
Overview
This Entity defines the types of advances available for the Advance Register. The advance type entity will be used to describe the different types of advances available in the system.
Navigation
General Ledger ► Sub Ledgers ► Accountable Advances► Advance Type
Advance Type screen Fields and Tab
Fields | Description |
ID | System generated unique identification code. |
Active | This field defines if the Advance Type is active and can be used. |
Is Linked to PO | Default is False. If Advance Type is linked to PO, the system will request a PO number when the Advance is posted. |
Is Standing Advance | If True the Advance Limit will be validated against the net amount of payments minus recoveries |
Advances To Be Process In Single Payment | Default is False. If True the Advance Limit will be validated against the net amount of payments minus recoveries |
Name | Indicates the name of the Advance Type. |
Description | Long description of the Advance Type. |
Advance Offsetting Accounts | Only available if Is Linked to PO is False. List of expressions representing a set of Coding Blocks that can be used to post recoveries of Accountable Advances of this type. |
Advance Type offset Accounts Tab
Advance Type offset Accounts Tab Screen Fields
Fields | Description |
Serial Number | Unique identifier. |
Rule Expression | user can enter different type of rules: List of values, wildcards and range of values. |
Description | Short description of the Advance Type |
Reports
Sri Lanka Reports
Stores and Commercial Advances Detail Report
Overview
This report shows the original amount for advance, required recovery and balance. Users can use report filters to generate the report as per their requirement.
A screenshot of the Stores and Commercial Advances Detail Report 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 the installed revision.
Users access Stores and Commercial Advances Detail Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Accountable Advances ► Reports ► Sri Lanka Reports ► Stores and Commercial Advances Detail Report.
Filters
The following table lists and describe all filter fields for the Stores and Commercial Advances Detail 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 years and allows users to select a fiscal year as a report filter. The current fiscal year is set as the default value. It is a mandatory field. |
| Period From | It lists the fiscal periods and allows users to select a fiscal period as a report filter. It is a mandatory field. |
| Period To | It lists the fiscal periods and allows users to select a fiscal period as a report filter. It is a mandatory field. |
| Workflow Status | It lists the workflow status and allows users to select it as a report filter. The values are restricted to:
|
| Advance Status | It lists and allows users to select the advance status from the list as a report filter. It has two value open and close. |
| Holder Name | It allows to browse and select the holder name using the lookup button. |
| Accounting Office | It allows to browse and select the accounting office using the lookup button. |
Visible Fields
A sample of the report is available here.The following table lists and describes all visible fields for the Stores and Commercial Advances Detail Report, in their default order. Note that some fields depend on Filters selection and the language of the report depends on the configuration of the system.
| Field | Description |
|---|---|
| Accountable Advance | |
| Code | Based on the filter criteria the accountable advance id shows in the report. |
| Holder Name | The account holder name to whom the advance has been issued. |
| Workflow | Workflow stage of the accountable advance. |
| Status | The advance status either open or close. |
| Amount | Domestic advance limit amount. |
| Advance Payments | |
| Voucher Date | Date of the voucher. |
| Advance Payments | Advance amount payment detail. |
| Status | The advance payment status. |
| Amount | The total domestic amount from expense voucher. |
| Total expenses against advances | |
| Voucher Date | Voucher date. |
| Total Expense against Advances | The total expense against the advance. |
| Amount | The total domestic credit amount. |
| Unutilized Advance Amount | The actual unutilized advance amount. |
Buttons
The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Stores And Commercial Advances Detail 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. |
Travel And Fuel Advances Details Report
Overview
It allows users to generate the detail report of the travel and fuel advance. Users can use report filters to generate the report as per their requirements.
A screenshot of the Travel And Fuel Advances Details Report 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 the installed revision.
Users access Travel And Fuel Advances Details Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Accountable Advances ► Reports ► Sri Lanka Reports ► Travel And Fuel Advances Details Report.
Filters
The following table lists and describe all filter fields for the Travel And Fuel Advances Details 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 years and allows users to select a fiscal year as a report filter. |
| From Date | The date picker allows users to pick the initial date range for the report as a filter. |
| To Date | The date picker allows users to pick final date of the range as report filter. it should be within the selected fiscal year and greater than from date. |
| Advance Type | It lists the advance type and allows users to select it as a report filter. The type should be travel advance & fuel advance. |
| Workflow Status | Lists the workflow status of the advance and allows users to select it as report filter.The values are restricted to:
|
| Advance Status | It lists and allows users to select the advance status from the list as a report filter. It has two value open and close. |
| Holder Name | It allows to browse and select the holder name using the lookup button. |
| Accounting Office | It allows to browse and select the accounting office using the lookup button. |
Visible Fields
A sample of the report is available here.The following table lists and describes all visible fields for the Travel And Fuel Advances Details Report in their default order. Note that some fields depend on Filters selection and the language of the report depends on the configuration of the system.
| Field | Description |
|---|---|
| Accountable Advance | |
| Code | Based on the filter criteria the accountable advance id shows in the report. |
| Holder Name | The account holder name to whom the advance has been issued. |
| Workflow | Workflow stage of the accountable advance. |
| Status | The advance status either open or close. |
| Amount | Domestic advance limit amount. |
| Advance Payment | |
| Voucher Date | Date of the voucher. |
| Advance Payments | Advance payment amount detail. |
| Status | The advance payment status. |
| Amount | The total domestic amount from expense voucher. |
| Total expenses against advances | |
| Voucher Date | It fetches voucher date. |
| Total Expense Against Advances | Total expense occurred against the allotted advance. |
| Amount | Total domestic debit amount. |
| Settlement of Advances | |
| Voucher Date | The date of the voucher. |
| Settlement of Advances | The calculated settlement amount of advance. |
| Status | The status of the advance settlement. |
| Amount | Total domestic credit amount. |
| Advance To Be Recovered | Grand total amount after calculation. |
Buttons
The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Travel And Fuel Advances Details 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. |
 | Allows user to select a date. |
Debt Register
BTMS Philippines Reports
Debt Servicing Requirements Report
Overview
This report shows debt servicing requirements for the month, quarter, year at aggregate level or at donor or executing agency level by debt instrument type, based on the debt servicing requirements data. It provides different filters which help users to generate the report as per their requirements.
A screenshot of the Debt Servicing Requirements 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 Servicing Requirements Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Debt Register ► BTMS Philippines Reports ► Debt Servicing Requirements Report.
Filters
The following table lists and describe all filter fields for the Debt Servicing Requirements 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 |
|---|---|
| Report Type | It lists the report type for selecting as a report filter. |
Fiscal Year | It lists the fiscal year to select them as report filter. A value for this field is mandatory. The current fiscal year is set as a default 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. |
Debt Type | It lists the debt type for selecting as a report filter for the report. |
Creditor Agency | It allows selecting the creditor agency using lookup feature as a report filter. |
| Executing Agency | It allows selecting the executing agency using lookup feature as a report filter. |
Visible Fields
The following table lists and describes all visible fields for the Debt Servicing Requirements 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 |
|---|---|
| Code | Instrument ID. |
| Description | Description of the Debt Instrument. |
| Debt Instrument Type | The debt instrument type. |
| Maturity Date | The date of maturity. |
| Amount | The total amount as per the filter selection in instrument type. |
| Forecast Principal Expected Transaction Date | Expected transaction date for principal. |
| Forecast Principal Amount | Forecast principal amount. |
| Forecast Interest Expected Transaction Date | Expected transaction date for interest as per debt transaction forecast. |
| Forecast Interest Amount | Forecast interest amount depends on the debt transaction forecast filter selection. |
| Total Forecast | The total of forecast principal amount and forecast interest amount. |
| Actuals Principal Transaction Date | The actuals principal transaction date. |
| Actuals Principal Amount | The actual principal amount. |
| Actuals Interest Transaction Date | The actuals interest transaction date. |
| Actuals Interest Amount | The actuals interest amount. |
| Total Actuals | The total of actuals principal amount and actuals interest amount. |
| Total Forecast Principal Amount | The total forecast principal amount. |
| Total Forecast Interest Amount | The total forecast interest amount. |
| Grand Total Forecast | The total amount after adding the total forecast principal amount and total forecast interest amount. |
| Total Actuals Principal Amount | The total actuals principal amount. |
| Total Actuals Interest Amount | The actuals total interest amount. |
| Grand Total Actuals | The total amount after adding the total actuals principal and actuals total interest 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 Debt Servicing Requirements 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. |
| Lookup allows user to select existing item from the list as a filter. |
Debt Instrument
Overview
This entity stores the register of debt instruments.
Navigation
General Ledger ► Sub Ledgers ► Debt Register ► Debt Instrument
Debt Instrument Screen Fields
Fields | Description |
Code | Unique Identification code of the Debt Instrument. |
Instrument Type | Refers to the instrument type entity in order to classify the debt instrument. |
Currency | Currency of the Debt Instrument. |
Debt Instrument Status | Indicates if the Advance is Open and transactions can be posted against it or it is closed and no transactions ca be posted against it. Default is Open. |
Maturity Date | Indicates the Instrument maturity date. |
Creation Date | Indicates the Instrument creation date. System populated current system date. |
Instrument Issuance Date | Issuance date of the debt instrument. |
Terms Of Bond | Calculated/Display only amount |
Exchange Rate | The exchange rate for the chosen currency. |
Principal Coding Block | Debt Instrument principal coding block. |
Principal Coding Block Cash Inflow Account | Only FULL Coding Block allowed |
Principal Coding Block Cash Outflow Account | Only FULL Coding Block allowed |
Interest Coding Block | Debt Instrument principal coding block. |
Creditor Agency | Associated with vendor |
Interest Rate | Rate of interest applies to the instrument. |
Principal Domestic Opening Balance | Principal Opening Balance of the Debt Instrument in domestic currency. |
Principal Foreign Opening Balance | Principal Opening Balance of the Debt Instrument in foreign currency. Applicable only when the instrument is in foreign currency. |
Principal Domestic Transaction Balance | This is a system calculated display only field. Shows the principal transaction balance. |
Principal Foreign Transaction Balance | This is a system calculated display only field. Shows the principal transaction balance in foreign currency. |
Principal Outstanding Domestic Balance | This is a system calculated display only field. Shows the outstanding principal amount of the instrument. |
Principal Outstanding Foreign Balance | This is a system calculated display only field. Shows the outstanding principal amount of the instrument if it is in foreign currency. |
Language | Country specific language used to register the description. |
Name | Name of the Debt Instrument |
Description | Description of the Debt Instrument. |
Created By | System will automatically populate this attribute. |
Debt Transaction Forecast Tab | Collection of 0 to N forecasts for the debt instrument. |
Debt Transaction Actual Tab | Collection of 0 to N transaction actuals. This is a display only tab, automatically populated by the system through process. |
Attachment Tab
Attachment Tab Screen Fields
Fields | Description |
Id | Consecutive number auto generated by the system. It will be unique within the system. |
Language | The system will suggest the default language; however the user can change such language. It represents the language of the document. |
Title | Title of the document |
Description | User defined. Description of the Attachment. |
Attachment | Complete reference to the file attached |
Date Time | Date and Time of the last operation performed on the attachment document. Visible for the user. Automatically assigned by the system. |
Date | It will be used as a reference for Reports and Forms |
User | Last user who uploaded or updated the document. Visible for the user. Automatically assigned by the system. |
Debt Transaction Forecast Tab
Debt Transaction Forecast Tab Screen Fields
Fields | Description |
Id | Refers to Debt Instrument code. |
Serial Number | Auto generated item serial number starts with 1 for every new Debt Instrument. |
Type of Transaction | Type of transaction. Possible values are Principal/Interest. Default is Principal. |
Expected Transaction Date | Expected date for the transaction. |
Currency | Currency of the Debt Instrument |
Exchange Rate | Shows the latest active exchange rate for the selected currency. |
Domestic Debit Amount | Transaction Debit Amount in domestic currency. |
Foreign Debit Amount | Transaction Debit Amount in foreign currency. |
Domestic Credit Amount | Transaction Credit Amount in domestic currency. |
Foreign Credit Amount | Transaction Credit in foreign currency. |
Generate Journal Entries For Debt Securities
Overview
This feature allows users to generate interest accrual or amortization of premium/discount for debt securities.
Navigation
General Ledger ► Sub Ledgers ► Debt Register ► Generate Journal Entries For Debt Securities
Generate Journal Entries For Debt Securities Screen Fields
| Fields | Description |
| Fiscal Year | Default value is current fiscal year, applicable fiscal years where status of fiscal year must be Open and fiscal year is open for budget execution are presented. |
| Fiscal Period | Default value is current fiscal period .Only fiscal periods with status Open are available. |
| Debt Instrument | Optional attribute to run the process for a single debt instrument. Only open instrument with category “Securities” or “Zero Coupon Securities” are displayed. |
| Generate JV For Interest Accrual | Default is ‘Null’. If it is 'True' then it will consider only 'REGULAR_SECURITY','ZERO_COUPON_SECURITY' as Debt Instrument Category |
| Generate JV For Amortization Of Premium Or Discount | Default is ‘Null’. If it is 'True' it will consider only 'REGULAR_SECURITY' as Debt Instrument Category. |
Guarantee Annual Ceiling
Overview
This entity should have a normal CRUD and should be subject to Audit Trail.
Navigation
General Ledger ► Sub Ledgers ► Debt Register ► Guarantee Annual Ceiling
Guarantee Annual Ceiling Screen Fields
Fields | Description |
Code | Unique identifier. System generated |
Active | Default is True |
Fiscal Year | Fiscal Year of the Annual Ceiling |
Ceiling Amount | Default Zero |
Reserved Amount | Display only, dummy field. Calculated amount, Default Zero |
Approved Amount | Display only, dummy field. Calculated amount, Default Zero |
Unreserved Ceiling Amount | Display only, dummy field. Calculated amount, Default Zero |
Issued Amount | Display only, dummy field. Calculated amount, Default Zero |
Language | Country specific language |
Description | Full description of the Annual Ceiling. |
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. |
Recurrent Expenditure On Borrowings Report
Sector Wise Guarantees Issued And Reserved Report
Support Entities
Debt Instrument Type
Overview
This entity lists all the different types of debt instruments.
Navigation
General Ledger ► Sub Ledgers ► Debt Register ► Support Entities ► Debt Instrument Type
Debt Instrument Type Screen Fields
Fields | Description |
Code | Unique Identification code of the Debt Instrument Type. |
Active | Indicates if the Instrument Type is “active” True = Active, False = Inactive. |
Debt Type | Defines the Type of Debt. Possible values are, External and Domestic. Default is External. |
Type of Financial Operation Type | Indicates the financial operation type for the instrument type. Possible Values are Loan, Regular Security, Zero Coupon Security and Guarantee. |
Currency | Indicates the Currency of the Instrument Type. Default is domestic currency. |
Name | Name of the Instrument Type. |
Description | Description of the Instrument Type. |
Generic Sub Ledgers
Generic Sub Ledger Register
Overview
This entity stores all entries in the generic subledger. A subledger item must first exist in this table before it can be used in any transaction.
Navigation
General Ledger ► Sub Ledgers ► Generic Sub Ledgers ► Generic Sub Ledger Register
Generic Sub Ledger Register Screen Fields
Fields | Description |
Code | Unique Identification code of the Generic SubLedger Type. |
Active | Indicates if the Generic Sub Ledger is “active” True = Active, False = Inactive. |
Domestic Debit Transaction Balance | Calculated/Updated Display Only Field Default is Zero |
Domestic Credit Transaction Balance | Calculated/Updated Display Only Field Default is Zero |
Created By | System will automatically populate this attribute. |
Created Date | Timestamp at creation date-time |
Last Updated User | System will automatically populate this attribute when this record is updated |
Last Updated Date | Timestamp at update |
Language | Country specific language used to register the description. |
Name | Name of the Generic Sub Ledger. |
Description | Description of the Generic Sub Ledger |
Beneficiary | Refers to the Beneficiary/Vendor for the Sub Ledger. |
Generic Sub Ledger Type | Indicates the Generic Sub Ledger Type for the Generic Sub Ledger. |
Generic Subledger Transaction Forecast Tab | Contains the information about Sub Ledger Transaction forecast. |
Generic Subledger Transaction Actuals Tab | This is a read only tab; the information will be populated from processes. |
Generic Subledger Transaction Forecast Tab
Generic Subledger Transaction Forecast Tab Screen Fields
Fields | Description |
Sequence | Sequential number of the Generic Subledger Transaction Forecast. |
Expected Transaction Date | To define the expected transaction date. |
Currency | Read-only, calculated attribute. |
Exchange Rate | Will show the latest active exchange rate for the selected currency, users can change the rate if allowed in the Currency parameters, otherwise this field will be ‘Display only’ and updated only by the system when the currency is selected. |
Domestic Debit Amount | Transaction Debit Amount in domestic currency. |
Foreign Credit Amount | Transaction Credit in foreign currency |
Generic SubLedger Type
Overview
This entity keeps track of all generic subledger types.
Navigation
General Ledger ► Sub Ledgers ► Generic Sub Ledgers ► Generic SubLedger Type
Generic SubLedger Type Screen Fields
Fields | Description |
Code | Unique Identification code of the Generic SubLedger Type. |
Active | Indicates if the Generic SubLedger Type is active and used. Default is true. |
Is Activate Sub Type | If true the Sub Type get activated. |
Is Use Vendor | Indicates if Generic SubLedger Type will use Vendor. |
Name | Name of the Generic SubLedger Type. |
Description | Description of the Generic SubLedger Type. |
Sub Type | To define sub types for the Generic SubLedger Type. |
SubType Tab
SubType Tab Screen Fields
Fields | Description |
Language | Country specific language used for Sub Type information. |
Name | Name of the Sub Type. |
Description | Description of the Sub Type. |
Active | Indicates if the subtype is “active” True = Active, False = Inactive. |
Investment Register
Investment
Overview
Main entity Investment, that stores information of the Government's investments.
Navigation
General Ledger ► Sub Ledgers ► Investment Register ► Investment
Investment screen Fields and Tabs
Field | Description |
|---|---|
Code | Unique identifier. Setup parameter to determine if entered by user or system generated. When system generated, it will be left-padded with zeros. |
Investment Type | Reference to the investment type entity in order to classify the entered investments. |
Investment Status | To indicate if the Advance is Open and transactions can be posted against it or it is closed and no transactions ca be posted against it |
Origin | Allows to select origin from the drop down list |
Principal Coding Block | Only FULL Coding Block allowed |
Return On Investment Coding Block | The Object element should be in Sub-Ledger Entity and linked to the Investment Register |
Issuing Agency | Agency who issues the investment |
Purchased/Issuance Date | Date when the investment was issued. Default is System Date |
Currency | Currency that is used for the investment. |
Estimated Investment Amount Domestic | Default is Zero. Disabled if Currency is NOT Domestic Currency |
Estimated Investment Amount Foreign | Default is Zero. Disabled if Currency is Domestic Currency |
Number Of Shares Sold | Calculated/Updated Display Only Field |
Principal Domestic Opening Balance | Calculated/Updated Display Only Field. Default is NULL. |
Principal Domestic Transaction Balance | Calculated/Updated Display Only Field. Default is zero |
Principal Domestic Outstanding Balance | Calculated/Updated Display Only Field. Default is zero |
Principal Foreign Opening Balance | Calculated/Updated Display Only Field. Default is NULL. |
Principal Foreign Transaction Balance | Calculated/Updated Display Only Field. Default is zero |
Principal Foreign Outstanding Balance | Calculated/Updated Display Only Field. Default is zero |
Domestic Total ROI To Date | Calculated/Updated Display Only Field. Default is zero |
Foreign Total ROITo Date | Calculated/Updated Display Only Field. Default is zero |
Created By | System will automatically populate this attribute. |
Created Date | Timestamp at creation date-time. |
Last Updated User | System will automatically populate this attribute when this record is updated |
Last Updated Date | Timestamp at update |
Name | Name given to the investment |
Description | Description of the investment |
Attachment Tab | Collection of 0 to many attachments. Use a tab for this attribute. |
Investment Transaction Forecast Tab | Defines the forecast transaction for the investment. Collection of 0 to many. Use a tab for this attribute. |
Forecast Transaction
Overview
This entity stores the different transactions associated with investments..
Forecast Transaction screen Fields
Name | Description |
|---|---|
Investment Transaction type | Reference to the transaction type entity. Dropdown list. List only the transactions types. |
Fiscal year | Current Fiscal Year for Budget Execution |
Fiscal Period | Current Fiscal Period for Budget Execution |
Description | Transaction description. |
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. |
On Lending Comparison Report
Share Holding Details Report
Support Entities
Investment Type
Overview
This entity holds the investment types.
Navigation
General Ledger ► Sub Ledgers ► Investment Register ► Support Entities ► Investment Type
Investment Type screen Fields and Tabs
Field | Description |
|---|---|
Code | Unique identifier. |
Name | Abbreviation of the investment type name. Localized field. |
Description | Full description of the investment type. Localized field. |
Active | Indicates if the investment type is “active” for registry. |
Investment Category | Indicates the Investment substitute type which can be On Lending or Shares. |
Loan/Advance Register
Borrower
Overview
This entity stores the distinct type of borrowers for a better classification.
Navigation
General Ledger ► Sub Ledgers ► Loan/Advance Register ► Borrower
Borrower Screen Fields
Fields | Description |
Code | Unique identifier. System generated. |
Is On Freebalance Payroll | False (Default) |
Borrower Type | Classification of the borrower according type. |
Workflow Status | Workflow status of the Borrower |
Associated Institution | Institution of the Associated borrower |
Borrower Status | It's a read-only field that will be manipulated through the workflow. |
Generic Borrower
Overview
This entity will store information for those persons outside FB Payroll that could be applicable to obtain a Loan.
Navigation
General Ledger ► Sub Ledgers ► Loan/Advance Register ► Generic Borrower
Generic Borrower Screen Fields
Fields | Description |
Code | Unique identifier. System generated. |
First Name | First name of the borrower |
Last Name | Last name of the borrower |
Employee Code | Employee code of the generic borrower. |
Personal Identification Number | Unique person Identifier |
Date Of Birth | Generic borrower date of birth. |
Place Of Birth | Generic borrower Place of Birth |
Gender | Generic borrower Gender |
Associated Institution Code | Institution code associated with Generic borrower |
Designation | Designation of the borrower |
Vacated Date | Vacated date of the borrower |
Loan
Overview
This feature stores the general header information related to Loans.
Navigation
General Ledger ► Sub Ledgers ► Loan/Advance Register ► Loan
Loan Screen Fields
| Fields | Description |
| Code | Manual or automatically generated, depending on paramater configuration, unique identifier. |
| Workflow Status | The workflow process status of the Loan, automatically generated and updated. |
| Loan Type | Reference to Loan Type, in order to classify the entered loans. Drop down list to select loan type. |
| Borrower | The employee or entity acting as the borrower, look up functionality is available to select borrower. |
| Language | Allows to select country specific language to apply for Purpose attribute. |
| Purpose | Purpose, terms and references of the current loan. |
| Annual Interest Rate | Interest rate applicable on the current loan. |
| Total Principal Amount | The total principal amount of the current loan. |
| Start Date | Start date of loan. |
| Number of Repayments | Quantity of repayments to cancel the loan. |
| Expected End Date | End date of loan. Calculated by the system, this is a read-only field. |
| Special Conditions | Special conditions of the current loan. |
| Outstanding Balance | Outstanding balance of the loan, not editable. Calculated and updated from transactions of the loan. Initial value = 0 |
| Total Principal Paid Amount | Total principal amount paid. Visible, not editable. Calculated and updated from transactions of the loan. Initial value = 0 |
| Total Interest Paid Amount | Total interest paid amount. Visible, not editable. Calculated and updated from transactions of the loan. Initial value = 0 |
| Type of Scheduled Repayment Calculation | Used to validate the type of the calculation method for the payment schedule. Read-only, not editable field, value is taken from Loan type. |
| Created By | Read-only field, filled with logged in user automatically by the system |
| Creation Date | Read-only. System date, automatically filled in the system. |
| Approved By | Read-only. Automatically filled by the system with user that approves record. |
| Approval Date | Read-only field displays ystem date of approval of the record. |
| Principal Account | Principal Account of the Loan Type. |
| Interest Account | Interest Account of the Loan Type. |
| Others Account | Others Account of the Loan Type |
| Transaction Schedule | This contains the transactions schedule for the current loan. It is automatically generated and updated by the system. |
Loan Type
Overview
This entity stores the distinct type of Loans.
Navigation
General Ledger ► Sub Ledgers ► Loan/Advance Register ► Loan Type
Loan Type Screen Fields
Fields | Description |
Code | Unique identifier. |
Active | Indicates if the loan type is “active” for registry of cases True = Active, False = Inactive. |
Is Default Loan Type? | Indicates if the case type is the default type when creating a new instrument type entry. |
Number Of Repayments | The total number of repayments for the actual type of loan |
Deduction | Related deduction code for those employees on the payroll. |
Calculation Method | Equal instalment (Default) |
Language | Country specific language |
Name | Abbreviation of the loan type name. |
Description | Full description of the loan type. |
Principal Account | System will list the sub-ledgers with status Active = True and of type = 'Loan Register'. |
Interest Account | System will list the sub-ledgers with status Active = True and of type = 'Loan Register'. |
Others Account | System will list the sub-ledgers with status Active = True and of type = 'Loan Register'. |
Support Entities
Sub Ledger
Overview
This Entity defines the object code element that are linked to Sub-ledger in the system. If the GL Parameter 'Sub-ledger Control' is Yes, then the system will not allow using any GL Coding Block which contains an object code element that is defined in this table without specifying the linked Sub-ledger code such as Customer, Vendor or Bank Account.
Navigation
General Ledger ► Support Entities ► Sub Ledger
Sub Ledger Screen Fields
| Fields | Description |
| Id | “Calculated/Updated Display Only Field” Auto-Generated Serial Number starts with 1. |
| Active | Determines whether this Portal Permission is active or not. |
| Type | Sub Ledger types. |
| Object Code | Users can enter the object code of a coding block that belongs to CoA group where budget execution is true. System will present a look up button to the concept of the mentioned element, so then user can select it from there. |
| Generic SubLedger Type | Defines Subledger Type if Subledger Type selected is “Generic Subledger” |
Concept Accounting Account Relationship
Overview
This feature allows users to select diferents COA object Segment accounts, and create a relationship to other accounting features.
Navigation
General Ledger ► Support Entities ► Concept Accounting Account Relationship
Concept Accounting Account Relationship Screen Fields
| Fields | Description |
| Id | Auto generated by system, unique identifier. |
| Fiscal Year | Allows users to select fiscal year from drop down. |
| Code Chart Of Accounts | Allows users to select segments of the coding block from drop down. |
| Element | Allows users to select Accounting Element from look up functionality. |
| General Ledger Template Status | Automatically generated and updated based on the workflow process status. |
| Active | Default value is TRUE. If it is false, the record cannot be changed. |
| Origin | Read only. Possible values:'DATA_IMPORT', 'MANUAL', default value: 'MANUAL'. |
| State of Changes in Equity | Allows users to select Accounting Level for State of Changes in Equity from drop down. |
| Cash Flow Statement | Allows users to select Cash Flow Statement from drop down. |
| Debt Exchange Differential | Allows users to select Debt Exchange Differential from drop down. |
| Other Accountants Exchange Differential | Allows users to select Other Accountants Exchange Differential from drop down. |
General Ledger
Overview
This entity to capture the opening and YTD balance of each G/L Coding Block for each Fiscal Year. The balance gets updated upon the approval or auto generating of Journal Vouchers. If a specific G/L Coding Block is not available when a JV is posted, the system will automatically create it in the table. It is important to notice if General Parameter Sub Ledger=TRUE then system will take into account that information when creating a record in this entity.
Navigation
General Ledger ► Support Entities ► General Ledger
General Ledger Screen Fields and Tab:
| Fields | Description |
| Fiscal Year | Fiscal Year of the General Ledger, Default value is current FY. |
| Currency | Currency of the G/L account. |
| Opening Balance Debit (Domestic) | Opening Domestic Debit Balance for the Fiscal Year. |
| Opening Balance Debit (Foreign) | Opening Foreign Debit Balance for the Fiscal Year. If currency is Domestic, this value has zero. |
| Opening Balance Credit (Domestic) | Opening Domestic Credit Balance for the Fiscal Year |
| Opening Balance Credit (Foreign) | Opening Foreign Credit Balance for the Fiscal Year. If currency is Domestic, this value has zero. |
| Actual YTD Debit (Domestic) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Domestic amount posted against the Coding Block during the Fiscal Year if the total amount is Debit. |
| Actual YTD Debit (Foreign) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Foreign amount posted against the Coding Block during the Fiscal Year if the total amount is Debit. If currency is Domestic, this value has zero. |
| Actual YTD Credit (Domestic) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Domestic amount posted against the Coding Block during the Fiscal Year if the total amount is Credit. |
| Actual YTD Credit (Foreign) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Foreign amount posted against the Coding Block during the Fiscal Year if the total amount is Credit. If currency is Domestic, this value has zero. |
| Items | General ledger items. |
| Sub-Ledger Institution Code | It is associated with the institution |
| Attachment | Size |
|---|---|
| General ledger navigation.JPG | 9.6 KB |
| General ledger.jpg | 109.08 KB |
General Ledger Items
General Ledger Item Screen Fields
| Fields | Description |
| Coding Block | Coding block of the General ledger item. |
| Sub Ledger Type | Sub ledger type of the general ledger item . |
| Opening Balance Debit (Domestic) | Opening Domestic Debit Balance for the Fiscal Year. |
| Opening Balance Debit (Foreign) | Opening Foreign Debit Balance for the Fiscal Year. If currency is Domestic, this value has zero. |
| Opening Balance Credit (Domestic) | Opening Domestic Credit Balance for the Fiscal Year. |
| Opening Balance Credit (Foreign) | Opening Foreign Credit Balance for the Fiscal Year If currency is Domestic, this value has zero. |
| Actual YTD Debit (Domestic) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Domestic amount posted against the Coding Block during the Fiscal Year if the total amount is Debit. |
| Actual YTD Debit (Foreign) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Foreign amount posted against the Coding Block during the Fiscal Year if the total amount is Debit. If currency is Domestic, this value has zero. |
| Actual YTD Credit (Domestic) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Domestic amount posted against the Coding Block during the Fiscal Year if the total amount is Credit. |
| Actual YTD Credit (Foreign) | “Calculated/Updated Display Only Field” will be updated by the system when a Journal Voucher is approved to capture the total Foreign amount posted against the Coding Block during the Fiscal Year if the total amount is Credit. If currency is Domestic, this value has zero. |
| General Ledger Period | Collection of zero to many general ledger periods. When users are only entering opening balances, there might not be GL period’s transactions yet. |
| Attachment | Size |
|---|---|
| General ledger navigation.JPG | 9.6 KB |
| General ledger item.jpg | 119.3 KB |
General Ledger Account Mapping For Public Debt
Overview
The purpose of this web service is to create a Journal Voucher for adjustments of balances for the LG Accounts that belong to Public Debt and apply for exchange differential. The Web Service will receive a set of data from Public Debt System. With this data, the system should be able to complete the information required to insert a new Journal Voucher and its detail transactions
Navigation
General Ledger ► Support Entities ► General Ledger Account Mapping For Public Debt
General Ledger Account Mapping For Public Debt Screen Fields
Fields | Description |
Debt Type | Allows to select ‘Internal’ or ‘External’ type from dropdown list |
Instrument Type | Allows to select Instrument type from dropdown list |
Term Type | Allows to select Term type from dropdown list |
Debt Status | Allows to select Debt Status from dropdown list |
Creditor Type | Allows to select Creditor type from dropdown list |
Portion | True/False, Default will be true. |
Sector | Numeric Code representing sector to which creditor belongs to |
GL Account | A code representing GL accounts for Public Debt. |
Origin | Default will be manual |
General Ledger Template
Overview
This entity contains the list of accounting classes. These classes identify the different ledger accounts for the accountable transactions.
Navigation
General Ledger ► Support Entities ► General Ledger Template
General Ledger Template Screen Fields
Fields | Description |
Code | Unique ID that identifies a General Ledger Template. Consecutive unique number automatically generated by the system. |
General Ledger Template Status | The Workflow Process Status of the General Ledger Template automatically generated and updated. |
Fiscal Year | Fiscal Year of the Disbursement Request Voucher. |
Class | Associated with the General Ledger Template Class |
Sub Class | Read Only until Class is selected |
Detail | Read Only until Class and Subclass are selected |
Language | Allows to select country specific language. |
Name | Short name that identifies type Class, Subclass and Detail of transaction. |
Description | Complete description of the GLT. |
Active | Indicate if the General Ledger Template is active or not. Default = True |
Source | Basic Stages are ‘Journal Voucher’, ‘Expense Voucher’, ‘Reveneu Voucher’, Default = ‘Expense Voucher’ |
Is Accounts Payable Previous Years | True/False Default False |
Is Accounts Receivable Previous Years | True/False Default False |
Origin | Values: "DATA_IMPORT", "MANUAL", Default value: "MANUAL" |
Created By | User who created the General Ledger Template. Populated automatically by the system. |
Created Date | Date and time of creation the General Ledger Template. Default current system date and time. Populated automatically by the system at creation time of the record. |
Approved By | User who approved the General Ledger Template. Populated automatically by the system, when the document is approved. |
Approved Date | Date and time in which the General Ledger Template document turns to ‘Approved’ Status Default current system date and time. Populated automatically by the system in time of approved for registration. |
Use for Opening a Receivable Account? | True/False Default False |
Use for Opening an Account Payable? | True/False Default False |
Allow to Add Coding Blocks | True/False Default False |
Fields
Fields Tab Screen Fields
Fields | Description |
Sequence Number | Unique Id it will be created automatically |
Accounting Item | It is associated with Accounting item elements |
Coding Block | Full Coding Block of the Account. |
Credit Debit | Allows to select Debit/Credit from the dropdown list |
General Ledger Template Class
Overview
Entity that has the list of classes, subclasses and details of GLT in hierarchical design.
Navigation
General Ledger ► Support Entities ► General Ledger Template Class
General Ledger Template Class Screen Fields
Fields | Description |
Application Id | Item unique ID, can be either “Calculated/Updated Read Only Field” system generated automatic. |
Type | Allows to select values: ‘Class’, ‘Subclass’, ‘Detail’ |
Language | Country specific language. |
Name | Short name that identifies the register transaction. |
Description | Complete description of the register transaction. |
Active | To indicate if the transfer type is active or restrictive. Default value is ‘true’ |
Origin | Allows to select values: ‘MANUAL’, ‘DATA_IMPORT’. Default is ‘MANUAL’ |
General Ledger Template Class Parent | If the transaction Type is Class this will NULL. If the transaction Type is Subclass this will show the list of Active transaction type Class. If the transaction Type is Detail this will show the list of Active transaction type Subclass. |
Transaction Analysis
Overview
This defines the type of Transaction in Journal voucher. While entering a Journal Voucher this defines the purpose of the entry or the reason of posting the entry
Navigation
General Ledger ► Support Entities ► Transaction Analysis
Transaction Analysis Screen Fields
| Fields | Description |
| Code | Code of the transaction analysis. |
| Active | True by default. If user switches this to False, then system will not allow to select this record in future transactions. |
| Abbreviation | Short Description of the Transaction Analysis. |
| Description | Details Description of the Transaction Analysis. |
| Attachment | Size |
|---|---|
| Transaction Analysis.JPG | 34.08 KB |
| Transaction analysis navigation.JPG | 10.01 KB |
Journal Entry Voucher
Objective:
A journal voucher is a multi-purpose accounting mechanism that is used to:
· Record and track general ledger-related transactions posted into the system.
· Correct posting errors.
· Redistribute costs from one or more accounts to several other accounts.
Every time a transaction is created in the system, the system automatically creates a corresponding journal voucher for control purposes. Since the system employs the double entry accounting principle, each journal voucher will contain the proper debit and credit amounts.
Navigation:
General Ledger ► Journal Entry Voucher
Journal Entry Voucher Screen Fields and Tabs
Fields | Description |
Voucher ID | Unique identification code, manually entered by users or automatically generated based on system parameters. |
Workflow Process Status | Workflow process status is user defined status of the workflow. |
Fiscal Year | Fiscal Year of the voucher, Default current FY (where 'Current Fiscal Year for Budget Execution' is True) |
Fiscal Period | Fiscal Period of the voucher, Default is Current Fiscal Period. |
Voucher Date | The date the voucher is created, defaults to current system date. |
Workflow Process Status | The Workflow Process Status of the voucher automatically generated and updated. |
Accounting Office | Accounting Office ID, If the Institution that the creating user (employee) belongs to is defined as Accounting Office, then default equals the user's Institution Code. |
No. Supporting Document | No. document that supports the transaction. |
Payment Location | The location for payment, if applicable. |
Posting Status | The Posting Status of the voucher, this field is automatically updated when the voucher is either saved or temp saved. |
Temp # | The Serial Number automatically generated when the voucher is Temp Saved. |
Not Posted Reason | Users will select a reason for not posting the voucher when voucher is Temp Saved, the field should be cleared automatically when the voucher is completely saved. |
Is Template? | To indicate if the Purchase Order can be used as template for recurring Purchase Orders Default is False. |
Language | Language use to enter description. |
Description | Descrip[tion of the journal voucher. |
Template Name | To enter the template name that can be used for retrieval. |
Batch Number | “Read Only Field” shows the Batch Number for imported PO’s |
Currency | To allow the user to select the Currency of the Purchase Order. Default is Domestic Currency. If the general parameter 'System Accepts Multi-currency Transactions' is False, then this field will be disabled and it's value is Domestic Currency. |
Exchange Rate | This field Will show the latest active exchange rate for the selected currency which is linked to Expenditures , users can change the rate if allowed in the Currency parameters, otherwise this field will be ‘Display only’ and updated only by the system when the currency is selected. Default is 1 (because default currency is Domestic). If the general parameter 'System Accepts Multi-currency Transactions' is False, then this field will be disabled . |
Recurs on Next Period? | An indicator to automatically duplicate the JV next period and Temp Save it upon period closing. Default is False. |
Voucher Type | “Read Only Field” |
Journal Voucher Assets Liabilities | The Liabilities of the Journal Voucher, to be applied when the voucher is manually created. |
Reference Number | Id of the source document. |
Notice Number | User generated number of the Notice document. |
Is Automatically Generated? | Indicates if the JV was Automatically Generated by the system. |
Debit (Domestic) | “Calculated/Updated Display Only Field” |
Debit (Foreign) | “Calculated/Updated Display Only Field” |
Credit (Domestic) | “Calculated/Updated Display Only Field” |
Credit (Foreign) | “Calculated/Updated Display Only Field” |
Created By | Populated automatically by the system at creation time of the record. |
Created On | Populated automatically by the system at creation time of the record. |
Approved By | Populated automatically by the system when corresponding workflow reaches its last Approval stage. |
Approved On | Populated automatically by the system when corresponding workflow reaches its last Approval stage. |
Item Tab | Journal Voucher Item of this Journal Voucher. |
Attachment Tab | Reference to the attachment with the content in question. This field can be observed in Insert mode. |
| Attachment | Size |
|---|---|
| Journal voucher.jpg | 176.7 KB |
| Journal voucher navigation.JPG | 9.09 KB |
Journal Entry Voucher Item
Journal Entry Voucher Item Screen Fields:
Fields | Description |
Serial Number | Auto generated item serial number starts with 1 for each Journal Voucher. |
UACS | The Coding Block of the Journal Voucher Item. |
Sub Ledger Institution Code | The system will provide a lookup to pick one Accounting Office Code |
Sub Ledger Type | Read Only for the user, when general parameter that sub ledger is in use is TRUE. If applicable (object code of the coding block is related with a sub ledger type, then system will select the type from this options and will enforce value of Sub ledger Code). |
Commitment | This field allow users to link the JV item to a commitment item. |
Commitment Item | This attribute will be updated automatically when the user selects the commitment. |
Close Remaining Amount of Commitment Item | Default value is False. Disabled when there is no commitment or the related commitment will be automatically closed because all the amount will be used with this transaction. If this is true, system should close the commitment by de-commiting the remaining funds. |
Obligation | To allow the users to link the JV item to an Obligation item. |
Obligation Item | This attribute will be updated automatically when users selects the Obligation. |
Close Remaining Amount of Obligation Item | Default value is False. Disabled when there is no Obligation or the related Obligation will be automatically closed because all the amount will be used with this transaction. If this is true, system should close the obligation by de-obligating the remaining funds. |
Description | A description of the Line item. |
Debit (Domestic) | Line item domestic Debit amount. |
Debit (Foreign) | Line item foreign Debit amount. |
Credit (Domestic) | Line item domestic Credit amount. |
Credit (Foreign) | Line item foreign Credit amount. |
Reconciliation Transaction Type Reference | The reference of the transaction type reconciled. |
Reconciled | “Calculated/Updated Display Only Field” To indicate if the current transaction is reconciled with a matching transaction in the Bank Statement. Default is False. |
Reconciliation Serial Number | “Calculated/Updated Display Only Field” Auto-generated serial number will be updated when the current transaction is reconciled with a matching transaction in the Bank Statement, the matching Bank Statement transactions will be updated with the same serial number. |
Reconciliation Date | “Calculated/Updated Display Only Field” Date when the record was reconciled. |
Reconciliation Type | “Calculated/Updated Display Only Field” Indicated if the reconciliation process was performed manual or automatically, possible values: MANUAL AUTOMATIC |
Cheque Series | “Calculated/Updated Display Only Field” Will be updated when a payment is approved |
Cheque/Deposit Number | “Calculated/Updated Display Only Field” Depends on attribute Reconciliation Transaction Type Reference. |
Cheque/Deposit Date | “Calculated/Updated Display Only Field” Depends on attribute Reconciliation Transacation Type reference. |
Transaction Number | “Calculated/Updated Display Only Field” Primary Code identifying the transactions. Corresponds to the Check Number or Deposit Number, Will be updated when a payment or Receipt Voucher is approved. |
Is Normal Rollup Applied | If this attribute is FALSE, then system will not do the normal roll up of this coding block, in other words, system will not hit budget controls. |
Attachments
Attachments Tab screen Fields:
| Fields | Description |
| Id | Unique Identification code for the attachment. |
| Attachment Classification | Classification of the Attachment. |
| Title | Title for the attachment. |
| Description | Description of the attachment. |
| Attachment | File to be attached by clicking on "Choose File" icon. |
| Date Time | Date and Time of file attachment is recorded in this field by the system. |
| User | User attaching the file is recorded in this field by the system. |
Account Inquiry
Overview
The Account Inquiry function is used to display all Journal Voucher transactions posted against specific General Ledger Coding Block within a specific period.
Please notice that system must show foreign currency information only if general parameter 'Accept Multi-Currency Transactions' is TRUE, otherwise, system should hide such fields/columns.
In the criteria form,Users will select the Fiscal Year, GL Coding Block and the range of period required.
Navigation
General Ledger ► Account Inquiry
Account Inquiry screen fields
| Fields | Description |
| Fiscal Year | Fiscal Year of the transactions to be displayed, default current fiscal year. |
| From Period | Starting Fiscal Period of the transactions to be displayed. Default is First Fiscal Period. |
| To Period | Ending Fiscal Period of the transactions to be displayed. Default is current fiscal period. |
| Coding Block | Full Coding Block, COA Group with attribute 'Budget Execution' = True or 'Accounting Level' = True. |
| Currency | Allow the user to select the Voucher Currency. Default is Domestic Currency. If the general parameter 'System Accepts Multi-currency Transactions' is False, then this field will be disabled and it's value is Domestic Currency. |
| Subledger Type | Object code of the coding block is related with a subledger type |
| Subledger Institution Code | Institution code at level definied in Institution Type Level for the second Sub-Ledger |
Reports
Account Analysis Detail Summary Report
Overview
This report provides aggregated summary level general ledger account information, based on the information of the dates when JV where posted and depending on user defined selection criteria.
Navigation
General Ledger ► Reports ► Account Analysis Detail Summary Report
Account Analysis Detail Summary Report Filter Fields
Field | Description |
|---|---|
Fiscal Year | This parameter is mandatory and shows the current fiscal year by default. The user have the option to select another fiscal year. |
Period | User enters the Fiscal Period From and To range (for example, Period From: Period 1, Period To: Period 2). This parameter is mandatory and it shows by default the current fiscal period, for Period From and Period To. |
Journal Voucher Date From | Select From date from the date picker |
Journal Voucher Date To | Select To date from the date picker |
Group By | The items that the user is available to group the data on are the same options listed above. |
Group By: Sub Ledger (Vendor, Bank Account Customer) | Sub Ledger code, select from Journal Voucher Item. |
Group By: Period | This group is by default true. |
Comment | Optional parameter |
Display In Domestic Currency | Option to display amounts in Domestic, Foreign, or Both currencies. If Domestic currency is selected, only the amounts in Domestic currency are displayed. If Foreign currency is selected, only the amounts in Foreign currency are displayed. If Both currencies are displayed, the amounts in both currencies are displayed. |
Include Opening Balance | Parameter to indicate if the opening balance for the first period of the date range selected is included in the report or not. Default is Yes: the opening balance for the first period (is based on the range of dates) is included. If set to No, the opening balance line is not shown in the report. |
Suppress Balance | Parameter Suppress Balance, Default is No: The balance should be shown. if YES: The balance is not shown. |
Differential Exchange Other Account Report
Overview
The purpose of this process is to update the balances of the accounting structure, (selected accounts diferents of external debts) and present the financial statements and analytical accounting reports reconciled with equivalent balances in national currency and adjusted according to the applicable rules.
Navigation
General Ledger ► Reports ► Differential Exchange Other Account Report
Field | Description |
|---|---|
Fiscal Year | Current Fiscal Year |
Fiscal Period | Current Fiscal Period |
Comment | Optional parameter |
Foreign Debt Exchange Differential Report
Overview
Establish the differences between the financial reporting and debt balances. To define the accounting entries to be made.
Navigation
General Ledger ► Reports ► Foreign Debt Exchange Differential Report
Foreign Debt Exchange Differential Report Screen Fields
Field | Description |
|---|---|
Fiscal Year | Current Fiscal Year |
Fiscal Period | Current Fiscal Period |
Comment | Optional parameter |
Nicaragua Reports
Account Analysis Detail Report
Overview
The purpose of the "Account Analysis Report - Detail" report is to display the Journal Voucher data for Nicaragua Government especific requirements.
The user is able to group the Journal Voucher data for a number of criteria, displaying sub-totals if required. The grouping options are based on the different groups of the GL code.
Navigation
General Ledger ► Reports ► Nicaragua Reports ► Account Analysis Detail Report
Account Analysis Detail Report Screen Fields
Fields | Description |
Fiscal Year | Shows the current fiscal year by default. User may change this value. |
Fiscal Period From | User types Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Fiscal Period To | User types Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Journal Voucher From Date | Date range of the JV |
JV Date To | Date range of the JV |
Sub Ledger Type | Allows to select Sub Ledger Type from the dropdown list |
Origin | Optional parameter. Possible values are: "Manual", "Expense Voucher", "Payment", "Void Cheque", "Invoice", "and Receipt Voucher". "Debit Note", "Credit Note", "Goods Receipt Note", "Goods Return Note", "Goods Receipt Accrual Reversal", "Payroll", "Assets", "Inventory", "Bank Deposit", "Fiscal Period Closure", "Other", or "All". |
JV Classification | Optional Parameter to select a specific JV Classification. If not specifiied, all should be displayed. |
Journal Voucher | Allows to select the JEV from the lookup field. |
Accounting Office | System will display Institution Application ID and also Name. |
Reconciled Indicator | Optional parameter. The reconciled indicator is a boolean indicator to indicate if the transaction is reconciled with a matching transaction in the Bank Statement. |
Display Cheque Information | If the user switches this to FALSE, then system will not show columns for cheque information (Cheque No, Cheque Series and Cheque Date) and will enlarge columns: Description, Sub ledger Code-Name, debits and credits and Journal Voucher number to make better use of the working area. |
Currency | Currency Name |
Cheque Series | Should filter information in case a value is entered. Optional Parameter |
Comment | Optional parameter |
Cheque Or Deposit Number | Should filter information in case a value is entered. Optional Parameter |
Cheque Or Deposit Date | Should filter information in case a value is entered. Optional Parameter |
Hierarchy Rollups UACS Elements | The Hierarchical Elements Restriction that may be selected as filter criteria for the report. The Coding Block restriction that may be selected as filter criteria for the report. |
Accounts Payable Nicaragua Format Report
Overview
This report provides an up-to-date listing of all debts that your organization owes to its vendors. Similar to the Cash Requirements Report, this information gives you a better understanding of how much cash will be absorbed in future payments.
The system gives you the choice of producing summary or detailed Accounts Payable reports.
The output will display a list of expense vouchers to be paid, sorted mainly by vendor, and voucher’s payment due date.
Navigation
General Ledger ► Reports ► Nicaragua Reports ► Accounts Payable Details Nicaragua Format Report
Accounts Payable Nicaragua Format Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Payment Date | Date range. Restricts Expense Voucher selection |
Payment Due Date | If specified, restricts payment selection |
Include Vouchers On Hold | Determines if the Vouchers on hold should be included in the report. |
Vendor | Allows to select Vendor from the list |
Expense Voucher | Allows to select Expense Voucher from the list |
Deduction | If selected, restrict Expense Voucher Payment Detail selection to those with matching field |
Accounting Office | If selected, restrict Expense Voucher selection to those with matching field |
Comment | Optional |
Consolidated Profit And Loss Statement
Overview
Presents in detail the results of the finance exercise for a specific period for all the institutions from the Non Financial Public Sector. The result obtained from this report is commonly called “Net Result”, which is recorded in the Results for the Year account, which is part of the Equity within the Balance Sheet report, and is subsequently accumulated in the Accrued Results account at the beginning of each Accounting year.
Navigation
General Ledger ► Reports ► Nicaragua Reports ► Consolidated Profit And Loss Statement
Consolidated Profit And Loss Statement Screen Fields
Fields | Description |
Fiscal Year | User select Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period | User selects the Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Hierarchy Rollups UACS Elements | The Hierarchical Elements Restriction that may be selected as filter criteria for the report. The Coding Block restriction that may be selected as filter criteria for the report. |
Profit and Loss Nicaragua Format Report
Overview
Presents in detail the results of the finance exercise for a specific period. The result obtained from this report is commonly called “Net Result”, which is recorded in the Results for the Year account, which is part of the Equity within the Balance Sheet report, and is subsequently accumulated in the Accrued Results account at the begining of each Accounting year.
Navigation
General Ledger ► Reports ► Nicaragua Reports ► Profit and Loss Nicaragua Format Report
Profit and Loss Nicaragua Format Report Screen Fields
Fields | Description |
Fiscal Year | Shows the current fiscal year by default. User may change this value. |
Fiscal Period | Shows the current fiscal period by default. User may change this value. |
Accounting Entity | Allows to select Accounting entity from the list |
Comment | Optional |
Statement of changes in equity Report
Sub Ledger Account Report
Overview
The purpose of this report is display the Journal Voucher data for Nicaragua Government specific requirements related to Sub-Ledgers.
The user is able to group the Sub-ledgers account data for a number of criteria, displaying sub-totals if required. Through this report the user can see the Opening Balance from Fiscal Period, the Fiscal Period movement's amount, and the Fiscal Period Actual Balance for a specific Sub Ledger Code or for a entire Sub Ledger Type, grouped and sumarized by Insitution and Accounting Item.
Navigation
General Ledger ► Reports ► Nicaragua Reports ► Sub Ledger Account Report
Sub Ledger Account Report Screen Fields
Fields | Description |
Fiscal Year | Shows the current fiscal year by default. User may change this value. |
Fiscal Period From | User types Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Fiscal Period To | User types Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Journal Voucher From Date | Date range of the JV |
JV Date To | Date range of the JV |
Accounting Item | Code for the COA element of the Coding Block for segment = Object Code at the lowest level. |
Sector | Allows to select sector from the list |
Journal Voucher Accounting Office | JV's Accounting Office filter one particular Institution. |
Sub Ledger Type | Allows to select Sub Ledger Type from the dropdown list |
Sub Ledger Code | lookup to one of the catalogue referenced Vendor, Customer, Bank Account, Deduction Retention, Loan Register, Debt Instrument, Investment, Generic Sub–Ledger etc. |
Journal Voucher | Allows to select the JEV from the lookup field. |
Journal Voucher Origin | Optional parameter. Possible values are: "Manual", "Expense Voucher", "Payment", "Void Cheque", "Invoice"," and Receipt Voucher". "Debit Note", "Credit Note", "Goods Receipt Note", "Goods Return Note", "Goods Receipt Accrual Reversal", "Payroll", "Assets", "Inventory", "Bank Deposit", "Fiscal Period Closure", "Other", or "All". |
Comment | Optional parameter |
Hierarchy Rollups UACS Elements | The Hierarchical Elements Restriction that may be selected as filter criteria for the report. The Coding Block restriction that may be selected as filter criteria for the report. |
Trial Balance Report
Overview
This report displays accounts belonging to a specific Concept in the OBJECT Segment with its respective accumulated balance, actual, summary and total, allowing to the user to check the correct posting of the accounts.
Navigation
General Ledger ► Reports ► Nicaragua Reports ► Trial Balance Report
Trial Balance Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Fiscal Period From | First Fiscal Period of Current Fiscal Year |
Fiscal Period To | Current Fiscal Period |
Accounting Entity | Allows to select Accounting entity from the list |
Comment | Optional |
Hierarchy Rollups UACS Elements | The Hierarchical Elements Restriction that may be selected as filter criteria for the report. The Coding Block restriction that may be selected as filter criteria for the report. |
Philippines Reports
Cash Flow Statement
Overview
This report identify every fund that has an entry cash flow and finds all expenditures, to obtain the final balance of the cash flows for the selected fiscal year and fiscal period. It provides different filter option to generate a specific report.
A screenshot of the Cash Flow Statement Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to installed revision, System Parameters and Rendering Control configuration.
Users access Cash Flow Statement Report from within the menu through this navigation path: General Ledger ► Reports ► Philippines Reports ► Cash Flow Statement Report.
Filters
The following table lists and describes all filter fields for the Cash Flow Statement Report in their default order. Note that some fields depends 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 Period From | It lists and allows users to select the initial value of the fiscal period range as a report filter. |
| Fiscal Period To | It lists and allows users to select the last value of the fiscal period range as a report filter. |
| Annual Cash Flow Statement | The default value set as unchecked. It allows users to mark it as checked as a report filter. |
| Aggregated Amount | The default value set as unchecked. It allows users to mark it as checked as a report filter. |
| Institution | It allows users to select one or multiple institution as a filter. |
Visible Fields
The following table lists and describes all visible fields for the Cash Flow Statement 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. A sample of the Cash Flow Statement Report is available here.
| Field | Description |
|---|---|
| Government or Country Name | It shows the name of the country on the report. |
| Institution name | Display name of the institution as per filter. |
| Report Name | Name of the report. |
| Report Date | Indicates date of report generation. This value is automatically generated by the system. |
| Report Time | Indicates the time of report generation. This value is automatically generated by system. |
| User | Indicates the user who has generated the report. |
| Fiscal Year | Indicates the fiscal year description. |
| Period | Indicates the fiscal period description. |
| Filter Criteria | It indicates the selected filter criteria for the report. |
| Currency | Domestic currency of the country. |
| Description | A short description. |
| Group Name | It indicates name of the group or subgroup. |
| Period1 Amount | It shows the calculated amount from GL. |
| Accountant General | It is kept as blank to fill manually by accountant general. |
| Director | It is kept as blank to fill manually by the director. |
Buttons
The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Cash Flow Statement Report feature.
| Button Image | Description |
|---|---|
| This button allows users to generate the report as PDF format. |
| This button allows users to generate the report as MS Excel format. |
| This button allows users to generate the report in the excel format. |
| This button allows users to generate the report in ODS format. |
| This button allows users to generate the report in RTF format. |
| This button allows the users to generate the report in MS Word format. |
| This button allows users to generate the report in ODT format. |
Cash Operations Report
Overview
The purpose of this report is to Display information regarding periodical OR yearly Cash Operations.
Navigation
General Ledger ► Reports ► Philippines Reports ► Cash Operations Report
Cash Operations Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Fiscal Period | Mandatory - Allow to select fiscal period from the drop down. |
Report Type | Allows to select report type from the dropdown list |
Organization | Mandatory - Allow to select Department which roll up from the "Agency" and allow to select "Agency" which roll up from operating unit and allow to select the Operating Unit. When select the operating unit the corresponding agency and department will be print. (Show department/agency/operating unit in the drop down) |
Consolidated Trial Balance
Overview
Each Agency prepared Trial Balance Monthly/Quarterly/Anually basis for the statutory requirement to send COA and for preparation of financial statement.
Navigation
General Ledger ► Reports ► Philippines Reports ► Consolidated Trial Balance
Consolidated Trial Balance Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Fiscal Period | Mandatory - Allow to select fiscal period from the drop down. |
Organization | Mandatory - Allow to select Department which roll up from the "Agency" and allow to select "Agency" which roll up from operating unit and allow to select the Operating Unit. When select the operating unit the corresponding agency and department will be print. (Show department/agency/operating unit in the drop down) |
Multi-Fund Concept | Optional - Allow to select one fund or mutiple fund (From-To). |
Group By | Optional - Allow to select group by fund. |
Is Opening Balance Included | Mandatory - Allow to select include opening balance or not. |
Show Opening Balance Only | Optional - Select this flag to show only the balance in the beginning of the year. |
Object | Mandatory - Allow to select concept of sub-object code. |
Trial Balance Report Type | Mandatory - Allow to select period from the drop down. It is a close domain period for the month or Up to the month. |
Comment | Optional. This will be filled up after the report is printed. |
Financial Statements
Consolidated Statement of Changes in Net Assets
Overview
Fields | Description | |
Fiscal Year | Mandatory-Allow to select fiscal year. | |
Fiscal Period | Mandatory - Allow to select fiscal period from the drop down. | |
Fund | Optional - Allow selection of "Fund Cluster" in the "Fund" segment of COA. In element selection, User can select more than one fund as filter. | |
Organization | Mandatory - Allow to select Department which roll up from the "Agency" and allow to select "Agency" which roll up from operating unit and allow to select the Operating Unit. When select the operating unit the corresponding agency and department will be print. (Show department/agency/operating unit in the drop down) | |
| If true, will include Columns of Central Office and Regional Office for all Report Type | |
Include Comparatives | If true, will include corresponding figures for previous FY for all Report Type |
Statement Of Comparison Of Budget and Actual Amount
Overview
This report enables users to analyse the Budget allocation with actual spending.
Navigation
General Ledger ► Reports ► Philippines Reports ► Financial Statements ► Statement Of Comparison Of Budget and Actual Amount
Statement Of Comparison Of Budget and Actual Amount Screen Fields
Fields | Description |
Budget Control Type | Allows to select budget control type from drop down list |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Fiscal Period | Mandatory - Allow to select fiscal period from the drop down. |
Multi-Fund Concept | Optional - Allow to select one fund or mutiple fund (From-To). |
Organization | Mandatory - Allow to select Department which roll up from the "Agency" and allow to select "Agency" which roll up from operating unit and allow to select the Operating Unit. When select the operating unit the corresponding agency and department will be print. (Show department/agency/operating unit in the drop down) |
Statement Of Financial Position
Overview
This report enables the users to analyse the Financial Position (Balance Sheet) of the Government or an Agency.
Navigation
General Ledger ► Reports ► Philippines Reports ► Financial Statements ► Statement Of Financial Position
Statement Of Financial Position Screen Fields
Fields | Description | |
Fiscal Year | Mandatory-Allow to select fiscal year. | |
Fiscal Period | Mandatory - Allow to select fiscal period from the drop down. | |
Report Type | Allows to select report type from the dropdown list | |
Organization | Mandatory - Allow to select Department which roll up from the "Agency" and allow to select "Agency" which roll up from operating unit and allow to select the Operating Unit. When select the operating unit the corresponding agency and department will be print. (Show department/agency/operating unit in the drop down) | |
Multi-Fund Concept | Optional - Allow to select one fund or mutiple fund (From-To). | |
| If true, will include Columns of Central Office and Regional Office for all Report Type | |
Include Comparatives | If true, will include corresponding figures for previous FY for all Report Type | |
Include Funds breakup | If true, will include Columns of each Fund from Fund Cluster |
Statement of Financial Perfomance Report
Overview
This report enables the users to analyse the Financial Performance (Income Statement) of the Government or an Agency.
Navigation
General Ledger ► Reports ► Philippines Reports ► Financial Statements ►Statement of Financial Perfomance Report
Statement of Financial Perfomance Report Screen Fields
Fields | Description | |
Fiscal Year | Mandatory-Allow to select fiscal year. | |
Fiscal Period | Mandatory - Allow to select fiscal period from the drop down. | |
Report Type | Allows to select report type from the dropdown list | |
Organization | Mandatory - Allow to select Department which roll up from the "Agency" and allow to select "Agency" which roll up from operating unit and allow to select the Operating Unit. When select the operating unit the corresponding agency and department will be print. (Show department/agency/operating unit in the drop down) | |
Multi-Fund Concept | Optional - Allow to select one fund or mutiple fund (From-To). | |
| If true, will include Columns of Central Office and Regional Office for all Report Type | |
Include Comparatives | If true, will include corresponding figures for previous FY for all Report Type |
General Journal Report
Overview
It is listing of the journal voucher for the period. It will send to Commission on audit every month for review.
Navigation
General Ledger ► Reports ► Philippines Reports ► General Journal Report
General Journal Report Screen Fields
Fields | Description |
Fiscal Year | Default Current Fiscal Year. |
Voucher Date From | Form Date of Voucher generation |
Voucher Date To | To Date of Voucher generation |
Organization Type | Mandatory-Allow to select Department which is roll up from the "Agency" and allow to select "Agency" which is roll up from operating unit and allow to select operating unit. When select the operating unit the corresponding agency and department will be print. |
Fund Cluster | Mandatory-Allow to select the fund cluster from the fund segment from concept fund cluster which roll up from authorization concept of UACS. |
Fund Authorization | Optional- Allow to select fund authorization from fund segment from concept authorization which roll up from the fund category from UACS. If select the authorization the corresponding fund cluster will be filled up. |
Posting Status | As per existing 'Journal Voucher Report'. |
Voucher Source | As per existing 'Journal Voucher Report'. |
Batch Number | As per existing 'Journal Voucher Report'. |
Voucher Status | Allow to select workflow status of the voucher |
Date Of Approval From | From Date of report approval |
Date Of Approval To | To Date of report approval |
Comment | Optional parameter |
General Ledger Report
Overview
Monitoring the movement of the account and see the balance of the each general ledger.
Navigation
General Ledger ► Reports ► Philippines Reports ► General Ledger Report
General Ledger Report Screen Fields
Fields | Description |
Fiscal Year | Default Current Fiscal Year. |
Is Group By Fund | This attribute is displayed only when the Multi Fund parameter is TRUE. |
Account Balancing Type | Closed Domain (MONTHLY, DAILY) default value is DAILY |
Start Date | Default value is Current Date, Display only when Account Balancing Type value is DAILY |
End Date | Default value is Current Date, Display only when Account Balancing Type value is DAILY |
Currency | Display the JV match with the currency |
UACS Code | Show the code of the at sub object level from the object code segment show only the expense object code. |
Organization Type | Mandatory-Allow to select Department which is roll up from the "Agency" and allow to select "Agency" which is roll up from operating unit and allow to select operating unit. When select the operating unit the corresponding agency and department will be print. |
Sub Ledger Type | Dropdown display all the Sub Ledger Types |
Fund Category | Allow to select fund category code |
Comment | Optional parameter |
Investment report
Overview
A common Investment report to get total investments, details of each investment, earnings per investment, total earnings, maturity periods for the investments etc.
Navigation
General Ledger ► Reports ► Philippines Reports ► Investment report
Investment report Screen Fields
| Fields | Description |
| Fiscal Year | Default value is current Fiscal Year. This is a mandatory filter. |
| Fiscal Period | Default value is current Fiscal Period. This is a mandatory filter. Report populate records up to last day of selected fiscal period. |
| Investment Type | Allows users to select different types of financial investments from look up functionality. |
List Of Journal Entry Vouchers Report
Overview
The purpose of the this report is to list the Journal Entry Voucher (JEV) per: Department, Agency, Operating Unit.
Navigation
General Ledger ► Reports ► Philippines Reports ► List Of Journal Entry Vouchers Report
List Of Journal Entry Vouchers Report Screen Fields
Fields | Description |
Voucher Status | Workflow Status of the JEV |
Fiscal Year | Mandatory - single selection by default current year |
Organization | Allows to select the organization from the dropdown list |
From Date | Mandatory – Select From date from the date picker |
To Date | Mandatory – Select To date from the date picker |
Comment | This will enable the user with the possibility of adding a comment to the report |
Monthly Report of Non-Tax Revenue Collections Report
Overview
The purpose of this report is to monitor monthly collection of non-tax and other receipts.
A screenshot of the Monthly Report of Non-Tax Revenue Collections 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 ► Reports ► Philippines Reports ► Monthly Report of Non-Tax Revenue Collections Report.
Filters
The following table lists and describes all filter for the Monthly Report of Non-Tax Revenue Collections 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 |
|---|---|
| Fiscal Year | This is a mandatory field, allows users to select fiscal year for the report. |
| Fiscal Period | This is a mandatory field, allows users to select fiscal period of the selected fiscal year for the report. |
| Organization | This field allows users to select orgnization code to filter the report. |
| Funding Source | The field refers to the funding source of the collections included in the report. |
| Allotment Class | It allows users to select allotment class to filter the report. It also allows users to set a range (from-to) of allotment class to filter the report. |
| Comment | The field allows users to add a custom comment to the generated report. |
| Coding Block Filter Type | This field allows users to select a coding block filter type for hierarchy rollups UACS element for the report. |
| UACS | The field is visible only when coding block filter type is coding block. It allows choosing the UACS of the report. |
| Segment | It refers to the segments of the chart fo accounts. |
| Concept | It refers to the concept of the selected segment of chart fo accounts. |
Visible Fields
A sample of the Monthly Report of Non-Tax Revenue Collections 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 |
|---|---|
| Fiscal Year | Refers to fiscal year for the report. |
| Department | Indicates the department for which the report is generated. |
| Agency | Indicates the agency for which the report is generated. |
| Funding Cluster | Indicates the fund cluster for which the report is generated. |
| Comment | This shows the user entered custom comment. |
| Particulars | It shows the description of the UACS codes. |
| Account Code | This column shows the UACS codes. |
| Amount | This column shows the collection amounts of the UACS codes. |
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 Monthly Report of Non-Tax Revenue Collections 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. |
Moving Trial Balance Report
Overview
Each Agency prepared Trial Balance Monthly/Quarterly/Anually basis for the statutory requirement to send COA and for preparation of financial statement. From this trial balance the user can be able to see the Opening banalnce, Transaction and closing Balance of the selected period.
Navigation
General Ledger ► Reports ► Philippines Reports ► Moving Trial Balance Report
Moving Trial Balance Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Trial Balance Report Type | Optional-Select this flag to show only the balance in the beginning of the year, by default false |
Fiscal Period | Mandatory. Allow to select fiscal period from the drop down. |
Organization | Mandatory-Allow to select Department which is roll up from the "Agency" and allow to select "Agency" which is roll up from operating unit and allow to select operating unit. When select the operating unit the corresponding agency and department will be print. |
Multi Fund Concept | Optional. Allow to select one fund or multiple fund (From-To) |
Concept | Mandatory. Allow to select concept of the of the sub-object code |
Comment | This will enable the user with the possibility of adding a comment to the report. |
Regional Breakdown of Income
Overview
To analyze the composition of income per region.
Navigation
General Ledger ► Reports ► Philippines Reports ► Regional Breakdown of Income
Regional Breakdown of Income Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Fiscal Period | Mandatory - Allow to select fiscal period from the drop down. |
Organization | Mandatory - Allow to select Department which roll up from the "Agency" and allow to select "Agency" which roll up from operating unit and allow to select the Operating Unit. When select the operating unit the corresponding agency and department will be print. (Show department/agency/operating unit in the drop down) |
Fund Cluster | Non-mandatory, allow many selection from concept "Fund Cluster" in the "Fund" segment of UACS. IF none selected, value for all will be displayed. |
Allotment Class | Mandatory-Allow multiple selection from allotment class from UACS. Which is roll up from "Sub-major account group" |
Comment | Optional. This will be filled up after the report is printed out. |
Schedule of Subsidiary Ledger Report
Overview
To analyse amount payable of a vendor against each disbursement voucher.
Navigation
General Ledger ► Reports ► Philippines Reports ► Schedule of Subsidiary Ledger Report
Schedule of Subsidiary Ledger Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Currency | Optional - if its selected will get all the EV with selected currency |
From Date | Allows to select Form date from date picker |
To Date | Allows to select To date from date picker |
Is Group By GL Account | Default value is TRUE |
Vendor | Mandatory - Look Up to select the vendors to be included in the report. |
Treasury Bank Account | Mandatory- Drop down to select Treasury Bank Name for the Bank account name from the treasury bank account table. Print only the short code from the treasury bank account table. |
Expense Voucher Classification | Mandatory - To allow the user to select the payment Type related to the Expense Voucher. |
Include Vouchers On Hold | This value comes from the parameter of the Module Expenditures. Default value is TRUE. |
Include Payment Suspended | This value comes from the parameter of the Module Expenditures. Default value is TRUE. |
Organization | Mandatory-Allow to select Department which is roll up from the "Agency" and allow to select "Agency" which is roll up from operating unit and allow to select operating unit. When select the operating unit the corresponding agency and department will be print. |
Fund Cluster | Mandatory- Allow to select Fund cluster from concept "Fund Cluster" it is roll up from "Authorization" in the Funding source segment of UACS. |
Fund Authorization | Mandatory- Allow selection from concept "Authorization" which is roll up from "Fund Category” in the "Fund" Segment of UACS. Print as per selection. |
UACS Code | Mandatory-Allow single selection the "Sub-object” code from the object segment of the UACS from the drop down show the code and description. |
Comment | Optional. This will be filled up after the report is printed. |
Stand Alone Trial Balance Report
Overview
Each Agency prepares Trial Balance Monthly/Quarterly/Anually as basis for the statutory requirement to send to Commission On Audit -COA- and for preparation of financial statement.
Navigation
General Ledger ► Reports ► Philippines Reports ► Stand Alone Trial Balance Report
Stand Alone Trial Balance Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory - single selection by default current year |
Show Balances | Optional-Select this flag to show only the balance in the beginning of the year, by default false |
Fiscal Period | By default show the initial fiscal period and current fiscal period. |
Organization | Mandatory-Allow to select Department which is roll up from the "Agency" and allow to select "Agency" which is roll up from operating unit and allow to select operating unit. When select the operating unit the corresponding agency and department will be print. |
Multi Fund Concept | Optional. Allow to select one fund or mutiple fund (From-To) |
Concept | Mandatory. Allow to select concept of the of the sub-object code |
Comment | This will enable the user with the possibility of adding a comment to the report |
Subsidiary Ledger Report
Overview
The purpose of this report is to verify the movement of the transaction of the each sub-ledger based on the sub-ledger type like Vendor, Customer or Bank Account.
Navigation
General Ledger ► Reports ► Philippines Reports ► Subsidiary Ledger Report
Subsidiary Ledger Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
From Date | Allows to select Form date from date picker |
To Date | Allows to select To date from date picker |
Operating Unit | Mandatory- Allow to select from concept "Operating Unit" in the "Organization" Segment of UACS. (Based on selection 4.8 Department & 4.9 Entity Name filled up corresponding with operating unit). Print based on selection |
Fund Cluster | Optional - Allow many selection from concept "Fund Cluster" in the "Fund" segment of COA. |
Sub Ledger Type | Mandatory -Single selection allow to select from the drop down type of the sub-ledger (Sub-ledger type field) from the sub-ledger table |
Comment | Optional. This will be filled up after the report is printed. |
Savings Account Investment And Financing Report
Srilanka Reports
COFOG Break Up Of Expenditure
Overview
The purpose of the this report is to Classify the expenditure based on purpose of transactions.
Navigation
General Ledger ► Reports ► Srilanka Reports ► COFOG Break Up Of Expenditure Report
COFOG Break Up Of Expenditure Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Currency | Currency Name |
COFOG | This will establish the filter per COFOG Concept |
Comment | This will enable the user with the possibility of adding a comment to the report |
Deposits Register Report
Overview
The purpose of the this report is to Display the transactions and the running Account Balance for each of the Depositors (Vendors).
Navigation
General Ledger ► Reports ► Srilanka Reports ► Deposits Register Report
Deposits Register Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Fiscal Period From | This will establish the filter per Fiscal Period FROM |
Fiscal Period To | This will establish the filter per Fiscal Period TO |
Currency | Currency Name |
Depositor | The source for Vendor is 'Beneficiary' |
Subtotal | To indicate if subtotals for the Depositor are to be displayed |
Group By Type | This will allow the grouping per Generic Sub-Ledger > Sub-Type |
Group By Generic Sub Ledger ID | This will allow the grouping per Generic Sub-Ledger ID |
Hierarchy Rollups UACS Elements | The Hierarchical Elements Restriction that may be selected as filter criteria for the report. The Coding Block restriction that may be selected as filter criteria for the report. |
Financial Statement Reports
Net Change In Deposit Accounts And Liabilities Report
Overview
The purpose of this report is to display Net Change in Deposit Accounts and Other Liabilities.
Navigation
General Ledger ► Reports ► Srilanka Reports ► Financial Statement Reports ► Net Change In Deposit Accounts And Liabilities Report
Net Change In Deposit Accounts And Liabilities Report Screen Fields
| Fields | Description |
| Fiscal Year | Fiscal Year is mandatory. Drop down is available for fiscal year selection. |
| Fiscal Period | Fiscal Period is mandatory. Drop down is available for fiscal Period selection. |
Notes to the Financial Statements
Statement Of Changes Net Assets Equity Report
Statement Of Financial Position
Statement of Cash Flows
Overview
This report identifies funds that have an entry cash flow and presents all the expenditures, to obtain the final balance of the cash flows for the selected fiscal year and fiscal period.
A screenshot of the Statement of Cash Flows Report is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to installed revision, System Parameters and Rendering Control configuration.
Users access Statement of Cash Flows Report from within the menu through this navigation path: General Ledger ► Reports ► Srilanka Reports ► Financial Statement Reports ► Statement Of Cash Flows Report.
Filters
The following table lists and describes all filter fields for the Statement of Cash Flows Report in their default order. Note that some fields depends 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 and allows users to select it as a filter. |
| Fiscal Period | It lists the fiscal period and allows users to select a fiscal period from the list as a filter. |
Visible Fields
The following table lists and describes all visible fields for the Statement of Cash Flows 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. A sample of the Statement of Cash Flows Report is available here.
| Field | Description |
|---|---|
| Government or Country Name | It indicates the name of the country or government on the report. |
| Institution name | It shows the name of the institutions. |
| Report Name | It shows the name of the report. |
| Report Date | The system automatically indicates the date of the report generation. |
| Report Time | It indicates the time of report generation. |
| User | User Id who generates the report. |
| Environment | It indicates the name of the environment. |
| Fiscal Year | It indicates the fiscal year of the report as per users filter selection. |
| Period | Indicates the fiscal period. |
| Currency | It indicates the domestic currency. |
| Description | It shows the description. |
| Group Name | It shows the name of the group or subgroup. |
| Amount | It shows the calculated amount. |
Buttons
The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Statement of Cash Flows Report feature.
| Button Image | Description |
|---|---|
| This button allows users to generate the report as PDF format. |
| This button allows users to generate the report as MS Excel format. |
| This button allows users to generate the report in the excel format. |
| This button allows users to generate the report in ODS format. |
| This button allows users to generate the report in RTF format. |
| This button allows the users to generate the report in MS Word format. |
| This button allows users to generate the report in ODT format. |
Statement of Financial Performance
Financing The Budget Deficit Report
Overview
The purpose of the this report is to Display the modes by which the Sri Lankan Government finances the Budget Deficit.
Navigation
General Ledger ► Reports ► Srilanka Reports ► Financing The Budget Deficit Report
Financing The Budget Deficit Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Fiscal Period | Allow to select fiscal period. |
Trial Balance - Institution Wise
Overview
| Fields | Description |
| Fiscal Year | Current fiscal year is selected by default. User can select fiscal year from drop down. |
| Fiscal Period | Mandatory filter shows by default the current fiscal period, users can change it. |
| Type | Allows user to select Type from drop down list. |
| Object code | Users can select the level (concept) at which information is shown. Users can select more than one element of the concept selected as filter, if no elements are selected, report presents all. |
| Currency | Allows users to select a Currency from drop down. |
| Organization | Allows users to select an Organization from drop down. |
| Comment | Users comments to be added to generated report. |
Trial Balance Detail Institution Wise Report
Overview
This report displays accounts belonging to a specific Concept in the OBJECT Segment with its respective accumulated balance, actual, summary and total, allowing to the user to check the correct posting of the accounts at Institution level.
Navigation
| Fields | Description |
| Fiscal Year | Default value is current Fiscal Year. This is a mandatory filter. |
| Fiscal Period | Default value is current Fiscal Period. This is mandatory filter. |
| Currency | Display list of currency. |
| Concept | Display a List of Concepts belonging to OBJECT Code Segment. This is a mandatory filter. |
| Organization | Allows users to select a single element or a group of elements depending on the selected CONCEPT. |
| Comment | User comment to be added to generated report. |
Work In Progress Report
Overview
This report helps to identify the monetary value of work that has been done and work that has not yet been paid for because it has not yet been completed.
Navigation
General Ledger ► Reports ► Srilanka Reports ► Work In Progress Report
Work In Progress Report Screen Fields
Fields | Description |
Fiscal Year | Mandatory-Allow to select fiscal year. |
Fiscal Period | Mandatory - Allow to select fiscal period |
From Date | Mandatory - Allow to select the range of dates for the period. |
To Date | Mandatory - Allow to select the range of dates for the period. |
Vendor | Allows to Select the Vendor from the list |
Purchasing Office | Allows to Select the purchasing office from the list |
Comment | Optional |
Trial Balance Report
Overview
Trial balance report allow users to check the correct posting of the accounts. Ensuring transactions are in balance.
Navigation
General Ledger ► Reports ► Trial Balance Report
Trial Balance Report screen Fields
| Fields | Description |
| Fiscal Year | Display a List of Fiscal Years in the system. Mandatory Parameter. |
| Fiscal Period | Display a List of Fiscal Period in the system. Mandatory Parameter. |
| Show Opening Balances | If this flag is false, then system will not take into account opening balances of the Fiscal Year when showing amount of report. |
| Currency | Currency for the report. |
| Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
| Group By Fund | If checked indicates that the report will be grouped by fund. |
| Concept | Display a List of Concepts belonging to OBJECT Code Segment. Mandatory Parameter. |
| Comment | Optional parameter. |
| Attachment | Size |
|---|---|
| Trial bal rep nav.JPG | 9.4 KB |
| Trial balance report.JPG | 49.21 KB |
Trial Balance Detail Report
Overview
This report displays accounts belonging to a specific Concept in the OBJECT Segment with its respective accumulated balance, actual, summary and total, allowing to the user to check the correct posting of the accounts.
Navigation
General Ledger ► Reports ► Trial Balance Detail Report
Trial Balance Detail Report Screen Fields
| Fields | Description |
| Fiscal Year | Display a List of Fiscal Years in the system. Mandatory Parameter. |
| Fiscal Period | Display a List of Fiscal Periods in the system. Mandatory Parameter. |
| Currency | Currency for the report. |
| Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
| Group By Fund | Filter the report Group by fund. |
| Concept | Display a List of Concepts belonging to OBJECT Code Segment. Mandatory Parameter. |
| Comment | A comment may be added to the report output via this field. |
| Attachment | Size |
|---|---|
| TBD report nav.JPG | 10.1 KB |
| TBD report.JPG | 50.44 KB |
Balance Sheet Report
Overview
This reports allows users to analyse the entire financial position of the government or an institution, up to a certain fiscal period.
Navigation
General Ledger ► Reports ► Balance Sheet Report
Balance Sheet Report screen Fields
| Fields | Description |
| Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
| Fiscal Period | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
| Multi-Fund Concept | User can select more than one fund as filter. If no elements are selected, system will take them all. This should appear only when multi fund parameter is true, when such parameter is false, then this group doesn´t apply. System will insert a page break between funds. |
| Group By Fund | Filter the report by Group by fund. |
| Concept | conepts of CoA segment marked as object code. |
| Comment | A comment may be added to the report output via this field. |
| Attachment | Size |
|---|---|
| Balance sheet report.JPG | 43.89 KB |
| Balance sheet report navigation.JPG | 9.81 KB |
Journal Voucher Details Report
Overview
This report prints out a detailed listing of all journal vouchers that match the specified selection criteria.
Navigation
General Ledger ► Reports ► Journal Voucher Details Report
Journal Voucher Details Report Screen Fields
| Fields | Description |
| Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
| Fiscal Period | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
| Include Coding Block Description | Concatenation of the description of the individual elements in the coding block. |
| Voucher | Id of the journal Voucher. |
| Posting Status | Filter option for status of the transactions in the system. Options are Saved and Temp Saved. |
| Temp Number | Allow users to select a specific temp # or a range of temp # to view in the report. |
| Voucher Source | Indicates the report will be grouped by Voucher source. |
| Voucher Date | Default current system date |
| Batch | Allow users to select a specific batch or a range of batches to view in the report. |
| Voucher Status | Filter the report by Voucher Status. Following values are available. |
| Voucher Type | Filter the report by Voucher Type. Following values are available. |
| Sub-Ledger Type | Filter the report by sub-ledger type. Following values are available. 'Customer' 'Vendor' |
| Comment | A comment may be added to the report output via this field. |
| Attachment | Size |
|---|---|
| Journal voucher details report navigation.JPG | 10.46 KB |
| Journal Voucher Details Report.jpg | 88.74 KB |
Account Analysis Detail Report
Overview
The purpose of the "Account Analysis Report - Detail" report is to display the Journal Voucher data.
Users able to group the Journal Voucher data for a number of criteria, displaying sub-totals if required. The grouping options are based on the different groups of the GL code.
In addition, the report offers the ability to group the data by Period, providing a higher level grouping.
Finally, users able to sort the data on up to four criteria, allowing complete flexibility over the output.
Navigation
General Ledger ► Reports ► Account Analysis Detail Report
Account Analysis Detail Report Screen Fields
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period From | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Fiscal Period To | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Journal Voucher Date From | Journal Voucher From date. |
Journal Voucher Date To | Journal Voucher To date. |
Sub-Ledger Type | Allows to select Sub-Ledger Type from dropdown list. |
Obligation | Obligation that linked to Journal Voucher. |
Origin | Optional parameter. Possible values are: "Manual", "Expense Voucher", "Payment", "Void Cheque", "Invoice", "Receipt Voucher". "Debit Note", "Credit Note", "Goods Receipt Note", "Goods Return Note", "Goods Receipt Accrual Reversal", "Payroll", "Assets", "Inventory", "Bank Deposit", "Fiscal Period Closure", "Other", or "All". |
Journal Voucher Classification | Optional Parameter to select a specific JV Classification. |
Journal Voucher | Optional parameters. To filter the data of one particular Journal Voucher |
Accounting Office | Accounting Office filter one particular Institution. |
Reconciled Indicator | To indicate if the current transaction is reconciled with a matching transaction in the Bank Statement. |
Display cheque/deposit information | Information related to Display check/ deposit information. |
Currency | Only display if Foreign Amount has a value |
Display In Domestic Currency | Allow the user to select currency using this parameter |
Cheque Series | Will be updated when a payment is approved. |
Hierarchy Rollups UACS Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Cheque Number | Filter the information in case a value is entered. |
Cheque Date | Filter the information in case a value is entered. |
Account Analysis Summary Report
Overview
This report provides aggregated summary level general ledger account information, depending on users defined selection criteria.
Navigation
General Ledger ► Reports ► Account Analysis Summary Report
Account Analysis Summary Report screen Fields
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period From | Beginning limit for the period covered in the report. |
Fiscal Period To | End limit for the period covered in the report. |
Include Opening Balance | Checkbox indicating if the opening balance of the account will be included in the report. |
Suppress Balance | Checkbox indicating if the period total will be suppressed in the report. |
Sub Ledger Type | Allows to select Sub-Ledger Type from dropdown list |
Currency | Currency for the report. |
Display In Domestic Currency | Option to display amounts in Domestic, Foreign, or Both currencies. If Domestic currency is selected, only the amounts in Domestic currency are displayed. If Foreign currency is selected, only the amounts in Foreign currency are displayed. If Both currencies are displayed, the amounts in both currencies are displayed. |
Comment | A comment may be added to the report output via this field. |
Hierarchy Rollups UACS Elements | Indicates that there will be a hierarchical element restriction and coding block restriction used to filter. |
Group By | The items that the user is available to group the data |
Detail General Ledger Report
Overview
The purpose of the Detail General Ledger Report is to display the Journal Vouchers within the system grouped by object and by fund when applicable.
Navigation
General Ledger ► Reports ► Detail General Ledger Report
Detail General Ledger Report Screen Fields
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Include Coding Block Description | A coding block description corresponding to all the elements descriptions. |
| Group By | If checked indicates that the report will be grouped by Fund. |
| Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
| Fiscal Period From | Beginning limit for the period covered in the report. |
| Fiscal Period To | End limit for the period covered in the report. |
| Hierarchy Rollups UACS Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
| Comment | A comment may be added to the report output via this field. |
Budget Comparison Inquiry Report
Overview
The Income statement - Budget Comparison Inquiry displays the Budget, actual Year-To-Date and variance, per Revenue, Cost of Sales, Expenditures, and Net Income/Loss elements, of the selected Object concept.
The variance is calculated and displayed as an amount and also a percentage.The figures displayed are based on the year to date revenue and expenses as at the current reporting period or active period.
Navigation
General Ledger ► Reports ► Budget Comparison Inquiry Report
Budget Comparison Inquiry Report screen Fields
| Fields | Description |
| Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
| Fiscal Period | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
| Budget Control Type | Filter criteria to filter the report by Budget Control Type. |
| Currency | Currency for the report. |
| Hierarchy Rollups UACS Elements | The Hierarchical Elements Restriction that may be selected as filter criteria for the report. The Coding Block restriction that may be selected as filter criteria for the report. |
Journal Voucher Report
Overview
The purpose of this report is to present a full detail of the Journal Voucher, including detailed information from JV including, Status , voucher source, item details, description JV, description item, workflow information and others.
Navigation
General Ledger ► Reports ► Journal Voucher Report
Journal Voucher Report Screen Fields
| Fields | Navigation |
| Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
| Fiscal Period From | Beginning limit for the period covered in the report. |
| Fiscal Period To | End limit for the period covered in the report. |
| Voucher Id | Optional Parameter. Id of the journal voucher. |
| Posting Status | Optonal Parameter. This field shows voucher is either saved or temp saved. |
| Temp Number | Allow users to select a specific temp # or a range of temp # to view in the report. |
| Origin | Selects the origin from dropdown list |
| Voucher Date | Default current system date |
| Batch Number | Allow users to select a specific batch or a range of batches to view in the report. |
| Voucher Status | Filter the report by Voucher Status. Following values are available. Approval Requested Approved Cancelled Created Rejected Template |
| Voucher Type | Filter the report by Voucher Type. Following values are available. 'Regular' 'Currency Gain & Loss' 'Retained Earnings' Default is 'Regular' |
| Sub-Ledger Type | Filter the report by Sub-Ledger Type. Default is 'Not Applicable' |
Income Statement Report
Overview
The income statement report provides a timely portrayal or your organization's financial status at a specified period of time.
Navigation
General Ledger ► Reports ► Income Statement Report
Income Statement Report Screen Fields
| Fields | Description |
| Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
| Fiscal Period From | Starting date of the Fiscal Period range to be selected for generating the report. |
| Fiscal Period To | Last date of the Fiscal Period range to be selected for generating the report. |
| Concept | Display a List of Concepts belonging to OBJECT Code Segment. Mandatory Parameter. |
| Multi-Fund Concept | Different multi fund concepts related to organization level from the COA segment can be selected. |
| Comments | A comment may be added to the report output via this field. |
Currency Exchange Gain And Loss Report
Overview
The report shows list of all Current Assets and Current Liabilities G/L accounts that are having foreign currency (in the Currency attribute in the General Ledger entity) along with their currency and closing balance for the current period.
The report calculate the gain or loss for each G/L account by applying the current market Exchange Rate for each currency on the Domestic book balance of the account and compare it with the Domestic calculated balance. The gains and loss amount listed in the report.
The market exchange rate will be latest rate value of each currency.
Navigation
General Ledger ► Reports ► Currency Exchange Gain and Loss Report
Currency Exchange Gain And Loss Report
Fields | Description |
Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period | Current Fiscal Period to be selected for generating the report. |
Sub Ledger Type | Sub Ledger type Bank Account, Vendor, Customer can be selected as the filter criteria for the report. |
Currency | Currency for the report. |
Multi-Fund Concept | User can select more than one fund as filter. If no elements are selected, system will take them all. |
Group by Fund | If checked indicates that the report will be grouped by Fund. |
Group By Object Code | Indicates the output result is grouped by Object Code segment. |
Include Sub Ledger Code | Users can select it to include the Sub Ledger code to display. |
Comment | Comments for this report. Optional Parameter. |
Hierarchy Rollups UACS Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Inadeh Reports
Balance Sheet Report
Overview
This report displays the financial status of an Institution, displaying the Current assets, non-current assets, liabilities and equities, allowing to users to know the financial situation up to a specific Fiscal Period.
Navigation
General Ledger ► Reports ► Inadeh Reports ► Balance Sheet Report
Balance Sheet Report screen fields:
| Fields | Description |
| Fiscal Year | User types Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
| Fiscal Period | User Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
| Institution | Id of the Institution. Optional parameter. |
| Comment | A comment may be added to the report output via this field. |
Laos Report
Summary Of Holding Account Transactions Report
Overview
Summarised report on holding account transactions is generated through this report.
Navigation
General Ledger ► Reports ► Laos Reports ► Summary Of Holding Account Transactions Report
Summary Of Holding Account Transactions Report screen Fields
Field | Description |
Fiscal Year | Fiscal Year for which the revenue report is generated, is selected from drop down box. |
From Date | Initial Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
To Date | End Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
Currency | Currency of revenue is selected from drop down box. |
Comment | Comment on the report on revenue, is entered in this field. |
Element | Organisational Element is selected from the lookup button. |
Summary Of Revenue By Classification Report
Overview
Summarised report on Revenue by classfification is generated through this report.
Navigation
General Ledger ► Reports ► Laos Reports ► Summary Of Revenue By Classification Report
Summary Of Revenue By Classification Report screen Fields
Field | Description |
Fiscal Year | Fiscal Year for which the revenue report is generated, is selected from drop down box. |
From Date | Initial Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
To Date | End Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
Treasury Office | Institution of Treasury Office to which the revenue relates, is selected from lookup button. |
Currency | Currency of revenue is selected from drop down box. |
Revenue Classification | Classification on which the revenue falls is seelcted in this field. |
Comment | Comment on the report on revenue, is entered in this field. |
Coding Block Filter Type | Filter Type applied on the revenue report is selected from drop down box. Possible filters are: Coding Block, Coding Block Expression Filter, Hierarchical Coding Block Elements. |
Segment | Segment is selected from drop down box. Possible values are: Fund, Fund Source, Organisation, Program and Object. |
Concept | Concept get automatically selected depending on the value selected for the Segment. |
Summary Of Revenue By Revenue Type Report
Overview
Summarised report on Revenue by revenue type is generated through this report.
Navigation
General Ledger ► Reports ► Laos Reports ► Summary Of Revenue By Revenue Type Report
Summary Of Revenue By Revenue Type Report screen Fields
Field | Description |
Fiscal Year | Fiscal Year for which the revenue report is generated, is selected from drop down box. |
From Date | Initial Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
To Date | End Date of revenue that is taken into consideration for report generation purpose, is selected from calendar button. |
Currency | Currency of revenue is selected from drop down box. |
Transaction Analysis | Basis of transaction analysis is selected from drop down box. |
Comment | Comment on the report on revenue, is entered in this field. |
Trial Balance For Laos Report
Objective:
This report displays accounts belonging to a specific Concept in the OBJECT Segment with its respective accumulated balance, actual, summary and total, allowing to the user to check the correct posting of the accounts.
Navigation:
Trial Balance For Laos Report screen Fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Fiscal Period | The period covered in the report. |
| Organization Type Element | Filter report by Organization type Element. |
| Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
| Group By Fund | If checked indicates that the report will be grouped by fund. |
| Concept | Filter report by Concept. |
| Trial Balance Report Type | Filter report by Trial Balance Report Type. Two options are available. 1.For the month. 2.Upto the month. |
| Comment | A comment may be added to the report output via this field. |
| Attachment | Size |
|---|---|
| Trial Balance For Laos Report Nav.JPG | 10.86 KB |
| Trial Balance For Laos Report.JPG | 51.17 KB |
Journal Voucher Listing Report
Objective:
The purpose of this report is to present a full detail of the Journal Voucher, including detailed information from JV including, Status , voucher source, item details, description JV, description item, workflow information and others.
Navigation:
Journal Voucher Listing Report screen Fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Posting Status | Optional Parameter. This field shows voucher is either saved or temp saved. |
| Voucher Source | Filter the report by Voucher Source. |
| Journal Voucher From Date | Filter report by Date from Journal Voucher included in this report. |
| Journal Voucher To Date | Filter report by Date upto Journal Voucher included in this report. |
| Batch Number | Allow users to select a specific batch or a range of batches to view in the report. |
| Voucher Status | Filter the report by Voucher Status. Following values are available. Approval Requested Approved Cancelled Created Rejected Template |
| Transaction Analysis | Filter report by Journal Voucher Transaction Analysis. |
| Approved From Date | Filter report by the date(starting) from approval of the Journal Voucher. |
| Approved To Date | Filter report by the date (end) upto approval of the Journal Voucher. |
| Attachment | Size |
|---|---|
| Journal Voucher Listing Report Nav.JPG | 10.35 KB |
| Journal Voucher Listing Report.jpg | 87.13 KB |
Daily Bank Account By Currency Report
Objective:
In Lao - Treasury bank account is always mapped to Institution and is also always mapped to 3 Coding Block through offset code, offset code for bank in transit revenue, offset code for bank transit payments. So, Multiple Treasury bank accounts can be mapped to an Institution. A Daily report is hence required to find the bank balances either by institution or by Treasury Bank Account.
Navigation:
Daily Bank Account By Currency Report screen fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Start Date | Beginning limit for the period covered in the report. |
| End Date | End limit for the period covered in the report. |
| Instittution | Filter the report by Institution. |
| Currency | Currency for the report. |
| Treasury Bank Account | Filter the report by Treasury Bank Account. |
| Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
| Comment | A comment may be added to the report output via this field. |
| Attachment | Size |
|---|---|
| Daily bank account by currency report.jpg | 66.13 KB |
| Daily bank account by currency report Nav.jpg | 10.04 KB |
Current Account Statement Report
Objective:
In Lao, Treasury works like bank with a no. of depositors and loan accounts. Account Statement like bank statement is required for such accounts - Currency wise.
Navigation:
Current Account Statement Report screen fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Start date | Beginning limit for the period covered in the report. |
| End Date | End limit for the period covered in the report. |
| Currency | Currency for the report. |
| Vendor | Filter the report by vendor. |
| Comments | A comment may be added to the report output via this field. |
| Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
| Attachment | Size |
|---|---|
| Current Account Statement Report Nav.jpg | 11.22 KB |
| Current Account Statement Report.jpg | 100.2 KB |
Profit And Loss Statement Report
Objective:
Navigation:
Profit And Loss Statement Report screen Fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Fiscal Period | The period covered in the report. |
| Multi fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
| Group By fund | If checked indicates that the report will be grouped by fund. |
| Concept | Filter report by Concept. |
| Comment | A comment may be added to the report output via this field. |
| Attachment | Size |
|---|---|
| Profit And Loss Statement Report.JPG | 47.97 KB |
| Profit And Loss Statement Report Nav.JPG | 11.1 KB |
Financial Statement Of National Treasury Report
Objective:
Navigation:
Financial Statement Of National Treasury Report screen Fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Fiscal Period | The period covered in the report. |
| Multi-Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
| Group By Fund | If checked indicates that the report will be grouped by fund. |
| Concept | Filter the report by Concept. |
| Comment | A comment may be added to the report output via this field. |
Summary Of Revenue By Budget Nomenclature Report
Objective:
Navigation:
Summary Of Revenue By Budget Nomenclature Report screen Fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Account Balancing Type | |
| Journal Voucher Dates | |
| Comment | A comment may be added to the report output via this field. |
| Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Daily Or Monthly Account Balancing Report
Objective:
Navigation:
Daily Or Monthly Account Balancing Report screen Fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Account Balancing Type | Filter the report by Account Balancing Type. Daily or Monthly. |
| Start days | Beginning limit for the period covered in the report. |
| End Days | End limit for the period covered in the report. |
| Currency | Currency for the report. |
| Sub Ledger Type | Filter the report by Sub ledger type. |
| Comments | A comment may be added to the report output via this field. |
| Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Holding Account Details - Documents sent Between Divisions
Objective:
Navigation:
Holding Account Details Report screen Fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Start Date | Beginning limit for the period covered in the report. |
| End Date | End limit for the period covered in the report. |
| GL Account Code | Filter The Report by GL Account Code. |
| Currency | Currency for the report. |
| Comment | A comment may be added to the report output via this field. |
General Ledger Account Details Report
Objective:
The purpose of the Detail General Ledger Report is to display the Journal Vouchers within the system grouped by object and by fund when applicable.
Navigation:
General Ledger Account Details Report screen Fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Group By Fund | If checked indicates that the report will be grouped by Fund. |
| Account Balancing Type | Filter the report by account balancing type. |
| Start Days | The Financial Year report for a specific year. |
| End Days | End limit for the period covered in the report. |
| Currency | Currency for the report. |
| Sub Ledger Type | Filter The report by Sub Ledger Type. Following Options are available. |
| Multi Fund Concept | Users can select more than one fund as filter. If no elements are selected, system will take them all. |
| Comment | A comment may be added to the report output via this field. |
| Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Expenditure by Payment Type Report
Objective:
Navigation:
Expenditure by Payment Type Report screen Fields:
| Fields | Description |
| Fiscal Year | The Financial Year report for a specific year. |
| Start Date | Beginning limit for the period covered in the report. |
| End Date | End limit for the period covered in the report. |
| Currency | Currency for the report. |
| Comment | A comment may be added to the report output via this field. |
| Hierarchy Rollups Coa Elements | Indicates that there will be a hierarchical element restriction and Coding block restriction used to filter. |
Standalone General Ledger Rollover
Overview
Balance of General Ledger is carried forward to next financial year through this screen.
Navigation
General Ledger ► Standalone General Ledger Rollover
Standalone General Ledger Rollover screen Fields
Field | Description |
Fiscal Year | Fiscal year is selected from drop down box as required in order to proceed with General Ledger Rollover. |