Reports
Expense Voucher List By Voucher# Report
Overview
This report essentially serves as a log of all expense vouchers (Eexpense Vouchers and Expense Vouchers related to Purchase Orders) within a specified numerical range that have been posted over a given period of time. This report provides total expense vouchers for each period and grand total for all periods being specified.
Navigation
Expenditures ► Reports ► Expense Voucher list by Voucher # Report
Expense Voucher List by Voucher # Report Screen Fields
| Fields | Descriptions |
| Fiscal Year | This field contains the Financial Year for which report will be generated |
| Fiscal Period From | Beginning limit for the period covered in the report. |
| Fiscal Period To | End limit for the period covered in the report. |
| Work Flow Status | Users can select any options from available six options for generate the report. Options are Approved Request, Approved, Cancelled, Created, Rejected and Template. |
| Posting Ststus | Filter option for status of the transactions in the system. Options are Saved and Temp Saved. |
| Source | The source of the expense voucher is mentioned in this field to generate the report. Available options are Temp and Temp Saved. |
| Type | The type of voucher to be displayed in report, either ‘Against a PO’, ‘Regular Expense’, or ‘Both’. |
| Recurring EVs | If checked indicates that the expense vouchers are recurring. Only recurring EV will displayed in the report. |
| From Date | Beginning limit of the posting date for the expense vouchers covered in the report. |
| To Date | End limit of the posting date for the expense vouchers covered in the report. |
| Coding Block | The Coding Block for the Expense Voucher List by Voucher # Report. Users can mention specific coding block for generate specific coding block wise report. |
| Coding Block Description | A description of the coding block. This section is automatically generated and defines each segment in the coding block with regards to what group it represents in the chart of accounts. |
| Financial Institution | This field indicates the Financial Institution for generate Expense Voucher List by Voucher report. |
| Vendor | Users can look up and select a vendor as filter criteria for the Expense Voucher List by Voucher Report. |
| Voucher Accounting Office | This field indicates the Accounting Office for generate report. Users can selete the institution which is used as accounting office also. |
| Payment Mode | Users can look up Payment Mode here to generated payment mode wise report. |
| Payment Location | This field indicates the Payment Location to generate specific payment location wise report. |
| Treasury Bank Account | Users can look up Treasury Bank Account here to generated specific Treasury Bank Account wise report. |
Laos Reports
Approved PV Batch Report
Navigation
Expenditures ► Reports ► Laos Reports ► Approved PV Batch Report
Approved PV Batch Report Screen Fields
Fields | Description |
Fiscal Year | Default Value is Current Fiscal Year |
Batch Date | Default value is Current Date, Expense Voucher Batch Generation matches with the batch Date |
Batch Number | Drop down, display the List of batch Number matches with the batch date |
Accounting Office | Institution Lookup. Logged User, Employee institution as a default |
Comment | Allows to write a comment on this report |
Laos Accounts Payable Report
Navigation
Expenditures ► Reports ► Laos Reports ► Laos Accounts Payable Report
Laos Accounts Payable Report Screen Fields
Fields | Description |
Report Type | Allows to select the report type from the dropdown list |
Fiscal Year | Default Current Fiscal Year. |
Currency | Default blank, if its selected will get all the EV with selected currency |
Payment Type | Allows to select the payment type from the dropdown list |
GL Account Code | Display the drop down list of all the distinct object element code - description in the coding block of the OffsetCode table those matched in the Concept Offset Code Mapping table |
Is Group By GL Account | Default value is TRUE |
Vendor | Allows to select the vendor from the lookup field |
Organization | Allows to select the organization from the lookup field |
Treasury Bank Account | Allows to select the Bank Account from the lookup field |
Include Vouchers On Hold | Default value if TRUE. |
Include Payment Suspended | Default value is FALSE |
Comment | Allows user to write a comment on this |
Line Ministry Batch Report
Navigation
Expenditures ► Reports ► Laos Reports ► Line Ministry Batch Report
Line Ministry Batch Report Screen Fields
Fields | Description |
Fiscal Year | Default Value is Current Fiscal Year |
Batch Date | Default value is Current Date, Expense Voucher Batch Generation matches with the batch Date |
Batch Number | Drop down, display the List of batch Number matches with the batch date |
Institution | Allows to select Institution from lookup field |
Comment | Allows to write a comment on this report |
Progress Report Of Payments Against Annual Budget Report
Navigation
Expenditures ► Reports ► Laos Reports ► Progress Report Of Payments Against Annual Budget Report
Progress Report Of Payments Against Annual Budget Report Screen Fields
Fields | Description |
Fiscal Year | Default Value is Current Fiscal Year |
PV Workflow Stage | The stages in the Workflow process will have the custom key value as 1. Line ministry Approval (LM_APPROVAL) 2. Received Treasury (RECEIVED_TR) 3. Approved Treasury (APPROVED_TR), 4. Sent For Payment (SENT_FOR _PAYMENT) 5. Paid (PAID)) |
Is Paid | Tristate checkbox if the user selects True will displays the PAID EV's, if selects False then will displays the NOT_PAID EV's if the user selects empty then will be shown both the EV's |
Comment | Allows to write a comment |
Workflow Stage Date | From Date: And To Date (default is current date the user can't change the to date) |
Hierarchy Rollups Coa Elements | Selection of segment and concept as per Hierarchical COA option Group by. |
Progress Report Of Payments By PV Numbers Report
Overview
The purpose of this report is to generate information regarding Payment Vouchers on the basis of Payment Voucher Number and their detailed information on progress status.
Navigation
Expenditures ► Reports ► Laos Report ► Progress Report of Payments by PV Number Report.
Progress Report of Payments by PV Number Report Screen Fields
Fields | Description |
Fiscal Year | Fiscal Year to which the Payment Voucher relates to be selected as filter criteria. |
Expense Voucher | Expense Voucher to which the Payment Voucher relates to be selected from the lookup button. |
Vendor | Code of the vendor to whom the payment is to be made. |
PV Workflow Stage | Stage of the Payment Voucher for which information is to be generated. |
EV Paid Status | Whether report is to be generated for all expense vouchers or partially paid or not paid ones, is to be filtered in this field. |
Comment | Comment on the report is made in this field. |
EV Workflow Execution Step Date | Allows to select From date and To date to generate the report for specific dates. |
Progress Report of Payments Against Budgets and Cash Allocation.
Overview
The purpose of this report is to generate detailed information regarding Payment Vouchers with respect to Planned Budget and Cash Allocation for a particular period.
Navigation
Expenditures ► Reports ► Laos Report ► Progress Report of Payments against Budgets and Cash Allocation.
Progress Report of Payments against Budgets and Cash Allocation Screen Fields
| Fields | Description |
| Fiscal Year | Fiscal Year to which the Payment Voucher relates to be selected as filter criteria. |
| PV Workflow Stage | Stage of the Payment Voucher for which information is to be generated. Status of Payment Voucher Workflow may be: Line Ministry Approved; Approved by Head of Expenditure LM; Approved for Payment and Received in Treasury. |
| Is Paid | Whether the Payment Voucher has been paid, is mentioned in this field. |
| As At Workflow Stage Date | Current Date is shown by the system. It refers to end date up to which the information is to be shown in the report. |
| Comment | Comment on the report. |
| Coding Block Filter Type | Information for the report is filtered on the basis on Coding Block which may be: Coding Block, Coding Block Expression Filter and Hierarchical Coding Block Element. |
Tracking List Of Document Verifications Report
Navigation
Expenditures ► Reports ► Laos Reports ► Tracking List Of Document Verifications Report
Tracking List Of Document Verifications Report Screen Fields
Fields | Description |
Fiscal Year | Default Value is Current Fiscal Year |
Batch Date | Default value is current date |
Batch Number | Display drop down list of the EV batch number for the selected batch date |
Comment | Allows to write a comment on this report |
Liberia Reports
Daily Expense Voucher Report
Overview
This report essentially serves as a log of all expense vouchers (EVs), Paid and Unpaid including Cheque Number and Number of days in Process for a specified date.
Navigation
Expenditures ► Reports ► Liberia Report ► Daily Expense Voucher Report
Daily Expense Voucher Report Screen Fields
| Fields | Description |
| Ministry & Agency | Institution of Ministry & Agency to be selected from lookup button as filtering criteria. |
| Fiscal Year | Fiscal Year to which the Expense Voucher relates is to be selected from dropdown box |
| Paid Status | Whether the Expense Voucher has been paid in full or partially or not at all paid, is mentioned in this field as filtering criteria. |
| Posting Status: From Date | Starting date of posting status from which date the data for report is filtered. |
| Posting Status: To Date | End date of posting status up to which date the data for report is filtered. |
Nicaragua Reports
Budget Balance of Revenue and Expenses Report
Overview
| Fields | Description |
| Account Plan Group - Income | Allows to select Income from the drop down list. |
| Account Plan Group - Expense | Allows to select Expense from the drop down list. |
| Print Amount | Allows to select Amount from the drop down list. |
| Fiscal Year | Current FY with is open for Execution equal to TRUE |
| Fiscal Period From | Fiscal Period with status is OPEN in list. |
| Fiscal Period To | Fiscal Period with status is OPEN in list. |
| Comment | Optional Parameter |
Budget Control Actuals Per Financing Source Report
Overview
Generic report of expenditure execution, with financing source
Navigation
Fields | Descriptions |
Budget Control Type | Budget Control Type selected by the User. Do not allow multi selection. |
Fiscal Year | User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details. |
Fiscal Period | Mandatory and display only, since report shows Period To Date allotment details. |
Currency | Selection of Currency to show the data. |
Concept | Allows to select concept from dropdown list |
Comment | Optional. This will be filled up after the report is printed. |
Budget Control Current Vrs Obligations Report
Overview
Generic report of expenditure execution, Current vs Commitments and Obligations.
Navigation
Expenditures ► Reports ► Nicaragua Reports ► Budget Control Current Vrs Obligations Report
Budget Control Current Vrs Obligations Report Screen Fields
Fields | Descriptions |
Budget Control Type | Budget Control Type selected by the User. Do not allow multi selection. |
Fiscal Year | User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details. |
Fiscal Period | Mandatory and display only, since report shows Period To Date allotment details. |
Currency | Selection of Currency to show the data. |
Concept | Allows to select concept from dropdown list |
Comment | Optional. This will be filled up after the report is printed. |
Budget Control Outstanding Amounts And Ratios Report
Overview
Generic report of expenditure execution, amounts and ratios.
Navigation
Expenditures ► Reports ► Nicaragua Reports ► Budget Control Outstanding Amounts And Ratios Report
Budget Control Outstanding Amounts And Ratios Report Screen Fields
Fields | Descriptions |
Budget Control Type | Budget Control Type selected by the User. Do not allow multi selection. |
Fiscal Year | User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details. |
Fiscal Period | Mandatory and display only, since report shows Period To Date allotment details. |
Currency | Selection of Currency to show the data. |
Comment | Optional. This will be filled up after the report is printed. |
Budget Control Outstanding Amounts Report
Overview
Generic report of expenditure execution.
Navigation
Expenditures ► Reports ► Nicaragua Reports ► Budget Control Outstanding Amounts Report
Budget Control Outstanding Amounts Report Screen Fields
Fields | Descriptions |
Budget Control Type | Budget Control Type selected by the User. Do not allow multi selection. |
Fiscal Year | User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details. |
Fiscal Period | Mandatory and display only, since report shows Period To Date allotment details. |
Currency | Selection of Currency to show the data. |
Concept | Allows to select concept from dropdown list |
Comment | Optional. This will be filled up after the report is printed. |
Budget Control and Actuals by Economic Clasification Definition E Report
Overview
This reports allows users to analyze, by economic classification type, the entire financial position of the government or an institution, up to a certain fiscal period. If no period is selected the entire fiscal year is taken into consideration.
Navigation
Expenditures ► Reports ► Nicaragua Reports ► Budget Control and Actuals by Economic Clasification Definition E Report
Budget Control and Actuals by Economic Clasification Definition E Report Screen Fields
Fields | Descriptions |
Budget Control Type | Dropdown to select Budget Control Type filter for this report. |
Fiscal Year | Dropdown to select Fiscal Year filter for this report. |
Fiscal Period Initial | Dropdown select Initial Fiscal Period filter for this report. |
| Fiscal Period End | Dropdown select End Fiscal Period filter for this report. |
Comment | Any comment to add in the output report. |
Budget Control and Actuals by Economic Clasification Report
Overview
Generic report of expenditure execution, with Economic classification.
Navigation
Expenditures ► Reports ► Nicaragua Reports ► Budget Control and Actuals by Economic Clasification Report
Budget Control and Actuals by Economic Clasification Report Screen Fields
Fields | Descriptions |
Budget Control Type | Budget Control Type selected by the User. Do not allow multi selection. |
Fiscal Year | User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details. |
Fiscal Period | Mandatory and display only, since report shows Period To Date allotment details. |
Comment | Optional. This will be filled up after the report is printed. |
Consolidated Statement of Revenues and Expenditures Report
Overview
This report shows a Consolidated Statement of Revenues and Expenditures Report () for the Current Fiscal Year, based on the selected Fiscal Year and Budgetary Execution Group, and the Specified Financial Coding Block Grouping information.
Navigation
Expenditures ► Reports ► Nicaragua Reports ► Consolidated Statement of Revenues and Expenditures Report
Consolidated Statement of Revenues and Expenditures Report Screen Fields
Fields | Descriptions |
Fiscal Year | User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details. |
Fiscal Period | List of values. User selects the Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. |
Comment | Optional. This will be filled up after the report is printed. |
Hierarchy Rollups Coa Elements | Allow the user to group and filter by any concept and range of elements belonging to the group of the Budget Control Type |
Quarter Execution Nicaragua Reports
Budget Control Outstanding Amounts Quarter
Overview
Generic report of expenditure execution Quarter.
Navigation
Expenditures ► Reports ► Nicaragua Reports ►Quarter Execution Nicaragua Reports ► Budget Control Outstanding Amounts Quarter
Budget Control Outstanding Amounts Quarter Report Screen Fields
Fields | Descriptions |
Budget Control Type | Dropdown to select Budget Control Type as filter criteria for this report. |
Fiscal Year | Dropdown to select Fiscal Year as filter criteria for this report. |
Fiscal Period Initial | Dropdown select Initial Fiscal Period as filter criteria for this report. |
| Fiscal Period End | Dropdown select End Fiscal Period as filter criteria for this report. |
| Currency | Dropdown select Currency as filter criteria for this report |
| Concept | Dropdown select Concept as filter criteria for this report |
Comment | Any comment to add in the output report. |
Budget Control Outstanding Amounts and ratios Quarter Report
Overview
Generic report of expenditure execution, amounts and ratios by Quarter.
Navigation
Expenditures ► Reports ► Nicaragua Reports ► Budget Control and Actuals by Economic Clasification Report
Budget Control Outstanding Amounts and ratios Quarter Report Screen Fields
Fields | Descriptions |
Budget Control Type | Dropdown to select Budget Control Type as filter criteria for this report. |
Fiscal Year | Dropdown to select Fiscal Year as filter criteria for this report. |
Fiscal Period Initial | Dropdown select Initial Fiscal Period as filter criteria for this report. |
| Fiscal Period End | Dropdown select End Fiscal Period as filter criteria for this report. |
| Currency | Dropdown select Currency as filter criteria for this report |
Comment | Any comment to add in the output report. |
Revenues Budget Per Item And Collecting Unit Actuals Report / Presupuesto de Ingresos por Rubro Unidad Recaudadora
Overview
The Revenues Budget Per Item And Collecting Unit Actuals Report shows the amounts of revenue for each Collection Unit.
A screenshot of the Revenues Budget Per Item And Collecting Unit Actual Report/Presupuesto de Ingresos por Rubro Unidad Recaudadora 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: Expenditures ► Reports ► Nicaragua Reports ► Presupuesto de Ingresos por Rubro Unidad Recaudadora.
Filters
The following table lists and describes all filter for the Revenues Budget Per Item And Collecting Unit Actual 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 |
|---|---|
| Print Amount | The field allows users to choose how the amount is going to be displayed in the report. |
| Execution CoA Group | It refers to the CoA Groups for the report. |
| Fiscal Year | It refers to the fiscal year for the report. |
| Fiscal Period From | This field allows users to define from which fiscal period the report is to be generated. |
| Fiscal Period To | This field allows users to define till which fiscal period the report is to be generated. |
| Comment | This field allows users to give any custom comment to the report. |
| Coding Block Filter Type | This field allows users to select a coding block filter type for hierarchy rollups coding block element for the report. |
| Coding Block | The field is visible only when coding block filter type is coding block. It allows choosing the coding block of the report. |
| Segment | It refers to the segments of the chart fo accounts. |
| Concept | It refers to the concept of the selected segments of the chart fo accounts. |
Visible Fields
A sample of the Revenues Budget Per Item And Collecting Unit Actuals Report output is available here. The following table lists and describes all visible fields for the Revenues Budget Per Item And Collecting Unit Actuals 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 |
|---|---|
| Concept | This column shows description of CoA Elements of the corresponding elements of each row. |
| Collecting Unit (Revenues) | This column shows the amounts for the related selected report filters. |
| Collecting Unit (Customs Services) | This column shows the amounts for the related selected report filters. |
| Collecting Unit (Treasury) | This column shows the amounts for the related selected report filters. |
| Total Income | This is a calculated amount column, shows total amount. |
Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Revenues Budget Per Item And Collecting Unit Actuals Report.
| Button Image | Description |
|---|---|
 | This button allows users to generate the report as PDF. |
 | This button allows users to generate the report as MS Excel. |
 | This button allows users to generate the report as MS Excel (XLSX format). |
 | This button allows users to generate the report as RTF. |
 | This button allows users to generate the report as MS Word. |
 | This button allows users to generate the report in ODT format. |
 | This button allows users to generate the report in ODS format. |
Statement of Accumulated Investments by Expense Category Report
Overview
The purpose is to Investments by Expense Category.
Navigation
Expenditures ► Reports ► Nicaragua Reports ► Statement of Accumulated Investments by Expense Category Report
Statement of Accumulated Investments by Expense Category Report Screen Fields
Fields | Descriptions |
Fiscal Year | User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details. |
Institution | Non-Mandatory. User can select a single value |
Agency | Non-Mandatory. User can select a single value |
Expense Category | Non-Mandatory. User can select a single value |
Comment | Optional. This will be filled up after the report is printed. |
Status Of Cash Flow Report
Overview
Financial control report detailing the cash flow statement for each funding agency, by agreement / project.
Navigation
Expenditures ► Reports ► Nicaragua Reports ► Status Of Cash Flow Report
Status Of Cash Flow Report Screen Fields
Fields | Descriptions |
Fiscal Year | User selects Fiscal Year. This parameter is mandatory and display only, since report shows Year To Date allotment details. |
Fiscal Period | Current Period. User types Period. This parameter is mandatory. |
Institution | Optional. If left blank, all OCE/OEP institutions are taking into consideration. User can only select valid OCE/OEP institutions. |
Comment | Optional. This will be filled up after the report is printed. |
Philippines Reports
Alphabetical List Of Taxes Withheld From Suppliers Report
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. |
DV Pending for Payment
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. |
Expanded Withholding Tax
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. |
Index of Payment Report
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 |
Regional BreakDown Of Expenses
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. |
Registry of Allotments and Notice of Transfer of Allocation 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. |
Report of Advice to Debit Account Issued Report
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. |
Schedule Of Payables Report
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. |
Schedule of Expenses per Responsibility Center Report
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 |
Statement Of Appropriations Allotments Obligations Disbursements And Balances 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. |
Summary of Appropriations, Allotments, Obligations, Disbursements and Balances by Object of Expenditures Report
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. |
Srilanka Reports
Accounts Payable with Aging Analysis Report
Overview
The accounts payable aging report categorizes payable to suppliers based on time frames. The intent of the report is to help TOD in determining which invoices are overdue for payment.
Navigation
Expenditures >> Reports >> Srilanka Reports >> Accounts Payable with Aging Analysis Report
Accounts Payable with Aging Analysis Report Screen Fields
Fields | Descriptions |
Fiscal Year | Mandatory-Allow to select fiscal year. By default, show the current fiscal year. |
Payment Date | Mandatory. Restricts Expense Voucher selection: Invoice Receipt Date |
Payment Due Date | Payment Due Date. Default as per the Payment Terms defined in the Expense Voucher header |
Include Vouchers On Hold | Determines if the Vouchers on hold should be included in the report. |
Include Payment Suspended | To indicate if the payment has been suspended through the ‘Payment Suspension’ Process. Suspended Payments will not be processed within the Payment function and cannot be released. Extracted Payments cannot be suspended. Default is False |
Include Vouchers Suspended | Determines if the Vouchers on hold should be included in the report. |
Period | Allows to select the period from dropdown list |
Vendor | Allows to select the vendor code from search functionality |
Accounting Office | This will always get the Accounting Office value of the relevant EV. |
Treasury Bank Account | Allows to select the Treasury Bank Account Treasury Bank Account from search functionality |
Payment Mode | Default value will be populated automatically from the selected vendor information if defined, if not defined in the Vendor, it will be populated from the selected Institution, if not defined in the Institution then default will populated be as defined in the Expenditures Parameter |
Payment Method | System will allow user to select only the Payment Type that selected Institution has access to. |
Payment Location | Default value will be populated automatically from the selected vendor information if defined, if not defined in the Vendor, it will be populated from the selected Institution, if not defined in the Institution then default will populated be as defined in the Expenditures Parameter |
Comment | Comments made on the report |
Vendor Analysis Progress Report
Overview
To identify the progress of a Purchase Order versus payments (disbursements).
Navigation
Fields | Descriptions |
Fiscal Year | Mandatory-Allow to select fiscal year. By default, show the current fiscal year. |
Fiscal Period | Optional - Allow to select fiscal period. |
Purchase Order Date | Optional. Date Picker. Allow to select a range of dates |
Purchase Order | Optional. Allow to select a range of PO #'s, should be a numeric range. |
Purchasing Vehicle | Purchasing Vehicle Short Description |
Vendor | Optional - Vendor name |
Buyer | Optional - Buyer name |
Purchasing Office | Optional - Institution name |
Requester | Optional - Institution name |
Item | Optional - Catalogue Item short Description |
Vendor Analysis Report
Overview
Allows users to analyze the amount of business which the organization has done with particular vendors.
Navigation
Fields | Descriptions |
Fiscal Year | Dropdown to select Fiscal Year Filter criteria for this report. |
Fiscal Period From | Filter criteria for Fiscal Period From for this report. |
| Fiscal Period To | Filter criteria for Fiscal Period To for this report. |
| Report Type | Dropdown to select Report Type Filter criteria for this report. |
| Workflow Stage | Workflow stage of EV that may be selected as filter criteria. |
| Include Pending Approval | Check box, that allow the selection of Pending Approval Expense Vouchers in the report. |
| Comment | Any specific comment to add in the output report. |
Cheque Series | Filter for the check series. |
| Accounting Office | Lookup for select Accounting Office as filter criteria. |
| Financial Institution | Lookup for select Financial Institution as filter criteria. |
| Financial Institution Branch | Dropdown to select Financial Institution Branch Filter criteria for this report. |
| Payment Mode | Lookup for select Payment Mode as filter criteria. |
| Payment Location | Lookup for select Payment Location as filter criteria. |
| Treasury Bank Account | Lookup for select Treasury Bank Account as filter criteria. |
| Cheque Number | Filter criteria for check numbers. |
| Cheque Date | Filter criteria for check date. |
Vendor Analysis Report
Overview
The purpose of the "Vendor Analysis Report" is to allow the user to analyze the amount of business which the organization has done with particular vendors. The user has the choice of producing summary or detailed Vendor Analysis reports, with or without period totals.
Navigation
Expenditures ► Reports ► Vendor Analysis Report
Vendor Analysis Report Screen Fields
| Fields | Descriptions |
| Fiscal Year | This field contains the Financial Year for which report will be generated. |
| Fiscal Period From | Beginning limit for the period covered in the report. |
| Fiscal Period To | End limit for the period covered in the report. |
| Report Type | The type of report to be generated, either ‘Detail’ or ‘Summary’. |
| Workflow Stage | Users can select any options from available six options for generate the report. Options are Approved Request, Approved, Cancelled, Created, Rejected and Template. |
| Include Pending Approval | If checked indicates that vouchers with a status of approval pending will be included in the report. |
| Comment | Users can insert comment here which will be published with the generated report. |
| Cheque Series | This field indicates the cheque series for generate report, for example cheque series printed on the cheque book. |
| Accounting Office | This field indicates the Accounting Office for generate report. Users can selete the institution which is use as accounting office also. |
| Financial Institution | This field indicates the Financial Institution for generate report. |
| Financial Institution Branch | Users can look up and select the financial institution branch according to the previously selected Financial Institution. |
| Payment Mode | Users can look up and select Payment to generated specific payment mode wise report. |
| Payment Location | This field indicates the Payment Location for generate report. |
| Treasury Bank Account | Users can look up and select Treasury Bank Account here to generate Treasury Bank Account related report. |
| Cheque Number | Under this heading, there are two fields i.e. Cheque Number From and Cheque Number To. Cheque Number From indicates beginning number of cheque and Cheque Number to indicates ending cheque number for generate cheque specific report. |
| Cheque Date | Under this heading, there are two options i.e. From Date (beginning date of cheque) and To Date (ending date of cheque) for generate cheque date wise report. |
| Group by | Users can select group option from the dropdown menu list for generate group wise report. |
| Hierarchy Rollups CoA Element | There are three options i.e. Coding Block, Coding Block Expression Filter and Hierarchical Coding Block Elements. Coding Block option for generate report according to specific coding block. Coding Block Expression Filter is for generate report according to specific coding block expression filter. Hierarchical coding block option helps to generate specific Segment, Concept wise report. |
| Vendor | User can look up and select a vendor for the vendor analysis report. |
Accounts Payable 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.
Navigation
Expenditures ► Reports ► Accounts Payable Report
Accounts Payable Report Screen Fields
Fields | Descriptions |
Report Type | The type of report will be generated, either ‘Detail’ or ‘Summary’. |
Fiscal year | This field contains the Financial Year for which report will be generated. |
Payment Date | Filter criteria for the date of payment. Default value is current date. Users can select any date. |
Payment Due Date | Filter criteria to filter the report by the date the payment is due to be paid. |
Include Vouchers on Hold | If checked indicates that the report will contain vouchers with a status of On Hold. |
Include Payment Suspended | Allows to select Suspended Payments from dropdown list |
Vendor | Users can look up and select a vendor as filter criteria for the Accounts Payable Report. |
Accounting Office | Users can look up and select an accounting office as filter criteria for the Accounts Payable Report. |
Treasury Bank Account | Users can look up and select a bank as filter criteria for the Accounts Payable Report. |
Payment Mode | Users can look up and select a Payment Mode as filter criteria for the Accounts Payable Report. |
Payment Method | Users can look up and select a Payment Method as filter criteria for the Accounts Payable Report. |
Payment Location | Users can look up and select a Payment Location as filter criteria for the Accounts Payable Report. |
Comment | Supporting comment which will be publish with report |
Expenditure List By Commitments Or Obligations Report
Overview
Generate expenditure report based on Pre-created Commitment or Obligation select by the users.
Navigation
Expenditures ► Reports ► Expenditure List by Commitments or Obligations Report
Expenditure List By Commitment or Obligation Report Screen Fields
| Fields | Descriptions |
| Fiscal Year | Users can insert the fiscal year to generate report. For example, if users insert 2013, that means report will generate for the year 2013 only. |
| Fiscal Period From | Beginning limit for the period covered in the report. |
| Fiscal Period To | End limit for the period covered in the report |
| Journal Voucher Workflow Status | There are six options available to choose i.e. Approved Request, Approved, Cancelled, Created, Rejected and Template. Report will generate on basic on workflow status choose by the users. |
| Journal Voucher Posting Status | There are two options available to choose i.e. Saved and Temp Saved. Report will generate on basic on workflow status choose by the users |
| Currency | Users should select any one currency from the dropdown list. There are two options available i.e. Domestic Currency and Foreign Currency. |
| Commitment | Holds pre-created commitment for reporting purpose. Report will generated basic of commitment select by the users. It is non-mandatory field. |
| Obligation | Holds pre-created obligation for reporting purpose. Report will generated basic of obligation select by the users. It is non-mandatory field. |
| Comment | Field contain additional information and/or remarks for publish in the report. |
Expense Voucher Details Report
Overview
This report prints out a detailed listing of all expense vouchers that were created during a specified period of time. Vouchers are printed in numerical sequence. This report displays information to assist on maintaining accurate control over every expense voucher that was input in the system.
Navigation
Expenditures ► Reports ► Expense Voucher Details Report
Expense Voucher DetailsReport Screen Fields
| Fields | Descriptions |
| Fiscal Year | Fiscal year to generate report. Report will generate basis of fiscal year mentioned here. |
| Fiscal Period From | Beginning limit for the period covered in the report. |
| Fiscal Period To | End limit for the period covered in the report |
| Source | There are six dropdown options i.e. Assets, Contract Management, Inventory, Manual, Other External Source, Payroll and Purchase Order. Users can select any option from available six options; Report will be generated on basis of source option selected by the users. |
| Posting Status | There are two options available to choose i.e. Saved and Temp Saved. Report will generate on basic on workflow status choose by the users. |
| Workflow Status | There are six options available to choose i.e. Approved Request, Approved, Cancelled, Created, Rejected and Template. Report will generate on basic on workflow status choose by the users. |
| Posting Date | There are two fields i.e. Posting Date From and Posting Date To. Posting Date From indicates starting date of report and Posting Date to indicate ending date of report. |
| Voucher | Allow the users enter a single value or a range of values. There are two fields i.e. Voucher From and Voucher To. Voucher From field indicates starting expense voucher ID and Voucher To field indicates ending expense voucher ID in report. |
| Batch | Allow the users enter a single value or a range of values. . There are two fields i.e. Temporary From and Temporary To. Temporary From field indicates starting temp number and Temporary to field indicates ending temp number in report. |
| Temporary | Allow the users enter a single value or a range of values. . There are two fields i.e. Batch From and Batch To. Batch From field indicates starting batch number and Batch To field indicates ending batch number in report. |
Expense Voucher Detailed Report
Expense Voucher Detailed Report
Overview
The purpose of this report is to present a full detail of the Expense Voucher, including detailed information from EV like, Status, voucher source, item details, EV description, Domestic Amount, Paid Status, Vendor Name, Treasury Bank Account, workflow information and others.
Navigation
Expenditures ► Reports ► Expense Voucher Detailed Report
Expense Voucher Detailed Report Screen Fields
Expense Voucher Detailed Report screen includes following fields:
| Fields | Descriptions |
| Fiscal Year | fiscal year to generate report. For example, if users insert 2013, that means report will generate for the year 2013 only. |
| Fiscal Period From | Beginning limit for the period covered in the report. |
| Fiscal Period To | End limit for the period covered in the report |
| Posting status | There are two options available to choose i.e. Saved and Temp Saved. Report will generate on basic on workflow status choose by the users. |
| Workflow Status | There are six options available to choose i.e. Approved Request, Approved, Cancelled, Created, Rejected and Template. Report will generate on basic on workflow status choose by the users. |
| Voucher Source | There are six dropdown options i.e. Assets, Contract Management, Inventory, Manual, Other External Source, Payroll and Purchase Order. Users can select any option from available six options; Report will be generated on basis of source option selected by the users. |
| Cheque Date | Users can insert cheque date for generate cheque date wise report. It is not mandatory field. |
| Financial Institution | This field indicates the Financial Institution for generate report |
| Financial Institution Branch | Users can look up and select the financial institution branch according to the previously selected Financial Institution. |
| Vendor | Users can look up and select a vendor as filter criteria for the Accounts Payable Report. |
| Accounting Office | Shows accounting office from Institution |
| Payment Mode | Users can look up and select a Payment Mode as filter criteria for the Accounts Payable Report. |
| Payment Location | Users can look up and select a Payment Location as filter criteria for the Accounts Payable Report |
| Treasury Bank Account | Users can look up and select a bank as filter criteria for the Accounts Payable Report |
| Cheque Number | Allow the users enter a single value or a range of values. . There are two fields i.e. Cheque Number From and Cheque Number To. Cheque Number From field indicates starting Cheque Number and Cheque Number to field indicates ending cheque number in report. |
| Voucher Date | Allow the users enter a single value or a range of values. . There are two fields i.e. From Date and To Date. From Date field indicates starting date and To Date field indicates ending date in report. |
| Expense Voucher ID | Allow the users enter a single value or a range of values. There are two fields i.e. Expense Voucher ID From and Expense Voucher ID To. Expense Voucher ID From field indicates starting Expense Voucher ID and Expense Voucher ID to field indicates ending expense voucher ID in report. |
| Journal Voucher ID | Allow the users enter a single value or a range of values. There are two fields i.e. Journal Voucher ID From and Journal Voucher ID To. Journal Voucher ID From field indicates starting Journal Voucher ID and Journal Voucher ID to field indicates ending journal voucher ID in report. |
| Temp | Allow the users enter a single value or a range of values. There are two fields i.e. Temp ID From and Temp ID To. Temp ID From field indicates starting temp ID and Temp ID to field indicates ending temp ID in report. |