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