Overview
The Agency and Operating Unit prepare this report on each month and send this to BIR and COA to show the tax deduction based on the each each business class.
Navigation
Expenditures ► Reports ► Philippines Reports ► Alphabetical List Of Taxes Withheld From Suppliers Report
Alphabetical List Of Taxes Withheld From Suppliers Report Screen Fields
Fields | Descriptions |
Fiscal Year | By default, show the current fiscal year. Based on requirement user can modify |
Fiscal Period | Mandatory- Allow to select date single selection from the Fiscal Period. Print based on selection. |
Organization | Mandatory - Allow to select from concept "Department" in the "Organization" Segment of UACS. Derived Department name from the concept "Department" which rolls up from the agency. Single Selection. |
Comment | Optional. This will be filled up after the report is printed. |
Overview
To analyze the DVs which are pending for payment including those which are partially paid.
Navigation
Expenditures ► Reports ► Philippines Reports ► DV Pending for Payment
DV Pending for Payment Screen Fields
Fields | Descriptions |
Fiscal Year | This is mandatory. Defaults to current year. Allow selection of previous year. |
Organization | Mandatory- Allow to select the concept from the organization segment. Show the only concept name (Example: Department/Agency/Operating Unit in the drop down. So, the user can select any one) |
From Date | Mandatory - User to input period covered. |
To Date | Mandatory - User to input period covered. |
Comment | Optional. This will be filled up after the report is printed. |
Overview
The Agency and Operating Unit prepare this report on each month and send this to BIR and COA to show the tax deduction based on the each each business class. This report will show only the withholding tax.
Navigation
Expenditures ► Reports ► Philippines Reports ► Expanded Withholding Tax
Expanded Withholding Tax Screen Fields
Fields | Descriptions |
Fiscal Year | By default, show the current fiscal year. Based on requirement user can modify |
Fiscal Period | Mandatory- Allow to select date single selection from the Fiscal Period. Print based on selection. |
Operating Unit | Optional- Allow Selection from concept "Operating Unit" in the "Organization" Segment of UACS. (Based on selection the point no 2 and 3 filled up corresponding with operating unit). Print based on selection |
Tax Type | Mandatory-Allow to select the tax type for the tax table. |
Comment | Optional. This will be filled up after the report is printed. |
Overview
The Index of Payment is used by the Accounting Division/Unit to record/monitor payments made to each creditor/payee. It shall be maintained by fund cluster.
Navigation
Expenditures ► Reports ► Philippines Reports ► Index of Payment Report
Index of Payment Report Screen Fields
Fields | Descriptions |
Fiscal Year | Mandatory-Allow to select fiscal year. By default, show the current fiscal year. |
From Date | Mandatory-Allow to select from date |
To Date | Mandatory-Allow to select to date |
Organization | Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS. By Default, it will show Agency but user can change to Operating Unit/Department. |
Funding Source | Mandatory- Allow to select Fund cluster from concept "Fund cluster" it is roll up from "Authorization" in the Funding source segment of UACS. Print based on selection. Show the code and name of the fund |
Vendor Classification | Optional-Single selection the category will come from the vendor category Table. |
Vendor | Mandatory- Single selection allow to select the Vendor ID from the vendor table. Show the vendor ID with Name in the look up. |
Comment | Comments made on the report |
Overview
This report is used by users to analyze the composition of expenses per region.
Fields | Descriptions |
Fiscal Year | Mandatory dropdown filter. It allows users to select the Fiscal Year to generate the report. The default value is the current fiscal year. |
Fiscal Period | Mandatory dropdown filter. It allows users to select fiscal month from the fiscal period. |
Organization | Mandatory filter. Users can select Department / Agency / Operating Unit from the dropdown. Information is retrieved from the Organization segment of UACS. By default, it shows Agency but users can change to Operating Unit. |
Fund Cluster | Allows users to select multiple concepts from "Fund Cluster" in the "Fund" segment of UACS. If none selected, values for all are displayed. |
Allotment Class | Mandatory filter. Allows users to select allotment class from UACS, which is roll up from "Sub-major account group". |
Comment | Comment to print on the output report. |
Overview
To determine the utilized amount against the NTA received and find out the remaining balance.
Navigation
Expenditures ► Reports ► Philippines Reports ► Registry of Allotments and Notice of Transfer of Allocation Report
Registry of Allotments and Notice of Transfer of Allocation Report Screen Fields
Fields | Descriptions |
Fiscal Year | Mandatory-Allow to select fiscal year. |
From Date | Mandatory - Date picker, allow to select From Date single selection |
To Date | Mandatory - Date picker, allow to select To Date single selection |
Operating Unit | Mandatory-Allow Selection from concept "Operating Unit" in the "Organization" Segment of UACS. |
Funding Source | Mandatory - Allow many selection from concept "Fund Source" in the "Fund" segment of COA. If none selected, value for all will be displayed. |
Comment | Optional. This will be filled up after the report is printed out. |
Overview
This report used by the Disbursing Officer to report daily or as often as necessary his/her disbursements made through ADA. It shall include cancelled ADA and be maintained by fund cluster.
Navigation
Expenditures ► Reports ► Philippines Reports ► Report of Advice to Debit Account Issued Report
Report of Advice to Debit Account Issued Report Screen Fields
Fields | Descriptions |
Bank Account No. | Non-mandatory- Single selection. Show only those banks which are related to the bank. |
Fiscal Year | By default, show the current fiscal year. Based on requirement user can modify |
From Date | Allows to select from date |
To Date | Allows to select to date |
Operating Unit | Allow Selection from concept "Operating Unit" in the "Organization" Segment of UACS. |
Funding Source | Allow selection from concept "Fund Cluster" from "Fund" Segment of COA. |
Report Type | Mandatory- Allow to select report type detail or summary from the close domain |
Comment | Optional. This will be filled up after the report is printed. |
Overview
To analyze the aging payments due to creditors. This report is submitted to COA for post-audit purpose. This report will provide the end user to generate a consolidated or unconsolidated report. Consolidated Report consist both Central and Regional Offices information whereas, unconsolidated report only consist information specific to the office which is either Central or Regional Office.
Fields | Descriptions |
Fiscal Year | This is mandatory. Defaults to current year. Allow selection of previous year. |
As at | Mandatory- Allow to select date single selection. Print based on selection. The reporting period in which the accounts are outstanding. |
Organization Unit Type | Allows to select organization unit type from dropdown menu |
Organization | Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS. By Default, it will show Agency but user can change to Operating |
Fund Cluster | 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 single selection from allotment class from UACS. Which is roll up from "Sub-major account group" |
UACS Object Code | Mandatory - Allow selection from concept "GL CONTRA ACCOUNT" in the ''OBJECT" segment of UACS. Show only those codes relating to Allotment Class. Print as per selection. |
Comment | Optional. This will be filled up after the report is printed. |
Overview
This report is prepared for monitoring the expenses against the each responsibility center. This report prepared monthly basis/As on date basis and send to COA for analysis purpose.
Navigation
Expenditures ► Reports ► Philippines Reports ► Schedule of Expenses per Responsibility Center Report
Schedule of Expenses per Responsibility Center Report Screen Fields
Fields | Descriptions |
Fiscal Year | Mandatory-Allow to select fiscal year. By default, show the current fiscal year. |
Report Type | Allows to select the report type from drop down list |
Period From | Mandetory- Allow to select from fiscal period (For the Month) |
Period To | Mandetory- Allow to select To fiscal period (For the Month) |
UACS | Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS. |
Organization | Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS. By Default, it will show Agency but user can change to Operating Unit/Department. |
Comment | Comments made on the report |
Overview
The purpose of the this report is to show the status of:
Fields | Descriptions |
Fiscal Year | Mandatory-Allow to select fiscal year. By default, show the current fiscal year. |
Fiscal Period | Mandatory, single selection. Allow user to select quarters. |
Organization | Mandatory - User can select Department / Agency / Operating Unit from the dropdown. This will be coming from the Organization segment of UACS. By Default, it will show Agency but user can change to Operating Unit/Department. |
Fund Cluster | “Fund cluster” from concept Fund Source from fund segment of UACS. |
Comment | Comments made on the report |
Hierarchy Rollups Coa Elements | Selection of segment and concept as per Hierarchical COA option Group by. |
Overview
The purpose of the this report is to show the status of:
Fields | Descriptions |
Fiscal Year | Dropdown to select Fiscal Year as filter for this report. |
Fiscal Period | Dropdown to select Fiscal Period as filter for this report. |
Organization | Mandatory filter, Allow Selection of concept in the "Organization" Segment of COA and element code for the concept selected. |
Funding Source | Mandatory filter, multiple selection. Allow selection from concept "Fund Cluster" from "Fund" Segment of COA. |
Comment | Comment to add on the output report. |
Hierarchy Rollups Coa Elements | Selection of segment and concept as per Hierarchical COA option Group by. |