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. |