Consolidation Of Financial Statements And Budget Execution
Automatically Import Consolidation
Overview
The Automatically Import Consolidation feature allows to consolidate financial statements and budget execution aoutomatically for the selected organization.
A screenshot of the Automatically Import Consolidation feature is available here. Image is shown as reference material; position and names for labels, fields, and buttons are subject to system parameters, rendering control configuration and installed revision.
Users access the report from within the menu through this navigation path: General Ledger ► Consolidation Of Financial Statements and Accounting Institutions ► Automatically Import Consolidation.
Visible Fields
The following table lists and describes all visible fields for the Automatically Import Consolidation feature, 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 | The field allows users to select the fiscal year for the consolidation. |
| Fiscal Period | The field allows users to select the fiscal period for the consolidation. |
| Consolidation Type | The consolidation type is displayed in this field. |
| Sector Element | It allows users to define the CoA element code of the Sector for the process. |
| Organization Element | It allows users to define the CoA element code of the Organization for the process. |
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 expense voucher feature.
| Button Image | Description |
|---|---|
 | The Lookup tool allows users to browse and select existing items. Once selected, all available information automatically populates the corresponding fields. |
 | The Execute button allows users to start the process. |
Consolidation Equivalences
Overview
Obtain and publish the execution of the budget, sum and represents the situation financial budgetary consolidated of the entire Non-Financial Public Sector.
Navigation
Expenditures ► Consolidation Of Financial Statements And Budget Execution ► Consolidation Equivalences
Consolidation Equivalences Screen Fields
Fields | Descriptions |
Id | Consecutive unique number, automatically generated and assigned by the system. |
Active | Default True |
Consolidation Type | Allows to select consolidation type from dropdown list |
Base Concept | List of concepts associated to the COA Group |
Consolidation Equivalences Rules
Consolidation Equivalences Rules Tab Screen Fields
Fields | Descriptions |
Serial Number | Consecutive unique number, automatically generated and assigned by the system. |
Origin Base Concept Object | The user should be able to do roll up to the Highest level of the Concept. |
Origin Concept | Select the origin concept from dropdown list. |
Origin Concept Object | Lookup button. Elements from Origin Concept. The user should be able to do roll up to the Highest level of the Concept. |
Origin Debit/Credit | Select the origin debit/credit from dropdown list. |
Destination Base Concept Object | Lookup button. Element from Consolidation Equivalences Base Concept. The user should be able to do roll up to the Highest level of the Concept. |
Destination Concept | List of concepts associated to the COA Group |
Destination Concept Object | Lookup button. Elements from Destination Concept. The user should be able to do roll up to the Highest level of the Concept. |
Is Amount Validation | Default False |
Priority | Select the Priority from dropdown menu |
Consolidation Master
Overview
Navigation
Expenditures ► Consolidation Of Financial Statements And Budget Execution ► Consolidation Master
Consolidation Master Screen Fields
Fields | Descriptions |
Code | Unique identifier. Consecutive unique number, automatically generated and assigned by the system. |
Fiscal Year | Default Actual Fiscal Year. |
Fiscal Period | Only shows Fiscal Periods with Status ‘CLOSED’ |
Workflow Status | This field shows the status of the workflow depending on the Workflow Configuration Setting for this entity the basic Stages are: ‘Created’, ‘Approval Requested’, ‘Approved’, ‘Rejected’, 'Cancelled', 'Template'. The default value is 'Created'. |
Consolidation Type | Select the consolidation type from dropdown menu |
Sector Element | Select the sector element from lookup field |
Organization Element | Select the organization element from lookup field |
Created By | User who created the record. |
Created Date | Date and time of creation. Default current system date and time. Populated automatically by the system at creation time of the record. |
Approved By | User who approved the Cutoff Validations. Populated automatically by the system, when the Consolidation Master is approved. |
Approved Date | Date and time in which the Consolidation Master turns to ‘Approved’ Status |
Consolidation Of Financial Statements And Budget Execution Report
Overview
This report shows the final consolidated information of Statement of Financial and Budget Execution for the Current Fiscal Year and the selected Fiscal Period for all the institutions from the Non Financials Public Sector.
Navigation
Expenditures ► Consolidation Of Financial Statements And Budget Execution ► Consolidation Of Financial Statements And Budget Execution Report
Consolidation Of Financial Statements And Budget Execution Report Screen Fields
Fields | Descriptions |
Fiscal Year | List of values. User select Fiscal Year. This parameter is mandatory and shows the current fiscal year by default. |
Fiscal Period From | Users can select the starting fiscal period of the current or previous Fiscal Year from which the they want to generate report. |
| Fiscal Period To | Users can select the end fiscal period of the current or previous Fiscal Year from which the they want to generate report. |
| Budget Control Type | Mandatory - User can select the required Budget Control Type from the dropdown list. |
Hierarchy Rollups Coa Elements | Allow Hierarchical Selection from Organization Segment of the CoA. |
Coding Block Filter Type | Select the coding block type from dropdown menu |
Coding Block | Any element (s) or range of elements of any concept of any segment included in the parameter Budget Execution COA Group for Consolidation. |
| Segment | Users can be able to select the available segments as per their selection requirement. |
| Concept | The user should be able to select a concept that belongs to the selected segment. |
Import Manual Consolidation
Overview
Import manual consolidation allows the user to import the consolidation of Financial Statements through the Excel file.
Navigation
Expenditures ► Consolidation Of Financial Statements And Budget Execution ► Import Manual Consolidation
Import Manual Consolidation Screen Fields
Fields | Descriptions |
Fiscal Year | Default: Actual Fiscal Year, Read Only field |
Fiscal Period | Only shows Fiscal Periods with Status ‘CLOSED’ |
Consolidation Type | Select the Budget Execution for consolidation type |
Sector Element | Select the sector element from lookup field |
Organization Element | Select the organization element from lookup field |
Upload File | Upload the file from the system related to this entity |