Overview
This report displays the Actual Expenditure for Current Year, Budget for Next Year, and quarterly break-up of the annual budget. The report can be filtered by Scenario, Budget Version, Budget Plan Type, Budget Control Type, and Institution.
Navigation
Budget Planning ► Reports ► Budget Planned Allocation Report
Budget Planned Allocation Report screen Fields
Field | Description |
Fiscal Year | Mandatory parameter. Fiscal Year for which the Expenditure will be displayed, as selected by the User. The Budget Information will be displayed for “Fiscal Year +1”. The default will be the current Fiscal Year. |
Scenario | Mandatory parameter. Users should select any Scenario from a drop-down menu displaying the Scenarios which are Active and with Scenario Fiscal Year including the selected Fiscal Year. |
Budget Version # | Mandatory parameter. Users should select any Budget Version from a drop-down menu displaying the Budget Versions within the selected Scenario, with status set to “Fully Sent for Execution” or “Partially Sent for Execution” or “Approved”. |
Item Code | Level of Summarization for the Item Code, displayed under the Report Body. The User can select any Concept within the Segment at the same level as Lower Level CoA Group, or higher level, within the Object Code Segment, for which the Actuals and Budget will be displayed. If the Item Code Concept selected is lower than the lowest level, an error message is generated. |
Institution/Organization Concept | Optional Parameter. Users can select a concept within the segment which is configured as "organization segment ", for which Actuals and Budget will be displayed under the Report. The Institution/Organization Level should be at least at the lowest level of the CoA Group. If the Institution/Organization Concept is not at the lower than the lowest level, an error message is generated. |
Functional Classification Segment | Optional Parameter. Users can select a segment for “Functional Classification” (for which the Actuals and Budget information will be displayed). |
Functional Classification Level Concept | Optional Parameter. Users can select a Concept for Functional Classification summarization, at the same level as Lower Level CoA Group, or higher level, within the Functional Classification Segment (for which the Actuals and Budget will be displayed). |
Budget Control Type Tab | Optional Parameter. Users can select one (1) or more Budget Control Types. |
Budget Plan Type Tab | Optional Parameter. Users can select one (1) or more Budget Plan Type. |
Element Tab | Optional parameter. Users can select one (1) or more elements within the selected Institution/Organization Concept. |
Overview
This report shows a list of the defined Budget Ceiling Figures and relevant planned amounts. It also shows the variance between Ceiling Figures Amounts and Planned Budget Amounts. This report will be helpful for budgeting authorities as it will help them identify any deviations from already allocated Ceiling Figures
Navigation
Budget Planning ► Rerports ► Budget Ceilings Report
Budget Ceilings Report screen fields and Tab
Fields | Description |
Budget Planning Scenario | Users should select any Scenario from a dropdown menu displaying the active Scenarios. |
Budget Version | Users should select any Budget Version from a dropdown menu displaying the Budget Versions within the selected Scenario |
Fiscal Year | Users should select Fiscal Year from a dropdown menu displaying the Fiscal Year. |
Status | Signifies the current status of the report in the workflow |
Ceiling COA Group | Users may select the COA group from the list of Scenario groups with Apply for Ceilings set to True. |
Plan COA Group | Users can select CoA group which is going to be used for this entity. |
Include Without Ceilings | If it is unchecked the ceiling is not included. |
Comment | Users comment |
Overview
This report shows a budget comparison report (surplus or deficit variance) between the previous fiscal year and the current fiscal year, based on the selected budget planning group, and the specified Financial Coding Block grouping information.
Navigation
Budget Planning ► Reports ► Budget Plan Report
Budget Plan Report screen Fields
Field | Description |
Fiscal Year | Display all available fiscal years. Mandatory Parameter. |
Display Periods | This parameter will be used to group and display the report by Fiscal period. |
Fiscal Period | By default all available Fiscal Periods that belong to the selected fiscal year must be used to generate the reports unless the user select a specific Fiscal Period. |
Budget Version | Mandatory parameter. The user should select any version that belongs to any Scenario that matches the selected fiscal year. |
Budget Plan | The budget plan is the main entity as from it all coding blocks used to generate the report will be extracted and matched vs the Budget Controls to get execution data. The Budget Plan must match the selected Fiscal Year and must belong to the selected Budget Version |
Budget Plan Status | Budget Plan Status that can be selected from the following possible values: “All”, “Open”, “Completed”, “Under Analysis”, “Closed”, “Partially Sent for Execution”, “Fully Sent for Execution”, “Revised”, “Uncompleted”. |
Institution | Institution to be selected by the User from the list of CoA elements from the segment with Organization Segment set to True. |
COA Group | COA Group used extract information for this report. The COA group must be entered by the user, if no Budget Plan is selected. |
Group By Budget Plan | Allow user to group information by Budget Plan. |
Comment | Comment entered by Users. |
Overview
This report shows a previous year actual data and current amounts, as well as planned amounts for current Fiscal Year used for Planning and indicative years, in case of medium term budgets.
Navigation
Budget Planning ► Reports ► Budget Estimates Report
Budget Estimates Report screen Fields
Field | Description |
Fiscal Year | Users should select Fiscal Year from a dropdown menu displaying the Fiscal Years. |
Budget Version | Users can select any version that belongs to any Scenario that matches the selected fiscal year. |
Budget Plan Tab | Users can select one (1) or more Budget Plans(s) that matches the selected Fiscal Year and that belongs to the selected Budget Version. |
Budget Plan Status | Users can select the Budget Plan status from the following list: "All", "Open", "Completed", "Under Analysis", "Closed", "Partially sent for Execution" and "Fully Sent for Execution", “Revised”, and “Uncompleted”. |
Institution | Allows Users to select any institution element within the COA segment with Organization Segment set to True. |
COA Group | COA group selected from the list of Scenario groups that is at the Lowest Level and with Apply for Ceilings set to False. The COA Group should be entered manually if no Budget Plan is selected. |
Group by: Budget Plan | This checkbox is used to group report by Budget Plans. |
Is current amount | This checkbox is used to define if Budget Control Original or Current Amount will be displayed under the Budget Estimates Report. |
Comment | Comment entered by the User. |
| Budget Plan Type | This is an Optional Filter.The user could select a BP Type with COA Group |
| Budget Plan | The budget plan is the main entity, as from it all coding blocks used to generate the report will be extracted and matched vs the Budget Controls to get execution data |
Overview
This report shows comparison between two budget versions. It displays complete budget line (Coding Block), Description of selected description concept Ex: Economic Classification, Budgeted Amounts for 1st Budget Version and budgeted amount for 2nd budget version. Users have the option to select any two budget versions that users want to compare.
Navigation
Budget Planning ► Reports ► Budget Version Comparison Report
Budget Version Comparison Report screen Fields
Field | Description |
Scenario | Through this parameter users can choose the scenario for which he wants to generate the report. Mandatory Parameter. |
Budget Version 1 | Mandatory parameter. Through this parameter users can choose the first Budget Version to compare, from the list of Budget Versions that belong to the selected scenario. |
Fiscal Year for Budget Version 1 | Mandatory parameter. Through this parameter users can choose the scenario fiscal year, from the list of Fiscal Years of the selected Scenario, for the first Budget Version to compare. |
Budget Version 2 | Through this parameter users can choose the second Budget Version to compare, from the list of Budget Versions that belong to the selected scenario. |
Fiscal Year for Budget Version 2 | Mandatory parameter. Through this parameter users can choose the scenario fiscal year, from the list of Fiscal Years of the selected Scenario, for the second Budget Version to compare. Scenario CoA Group: Mandatory Parameter. Through this parameter user will choose the Scenario CoA Group for which the report will be generated. |
Comment | Comment entered by the User. |
| Scenario CoA Group | The system will automatically assign the lowest group in hierarchy for the budget plan structure linked to the selected budget plan, the Group must be selected from the corresponding Scenario COA group linked to a specific Budget plan structure which at the end are linked to the Budget plan. |
Overview
This Report enables users to report future year Commitments and Obligations against the Budget Plan. This report can be generated at the detailed budget plan lines or can be summarized to any level of the COA. It offers up to 3 fiscal years of budget and will calculate the variance of the budget plans for each years. Users can then identify any negative variance and correct them as Budget Plans that are less than future year commitments and obligations will not be sent to Execution.
Navigation
Budget Planning ► Reports ► Budget Plan Versus Planned Commitments And Obligations Report
Budget Plan Versus Planned Commitments And Obligations Report screen Fields
Field | Description |
Scenario | Scenario from which the information is extracted for this report, from the list of active scenarios. |
Budget Version | Budget Version selected from the list of Budget Version(s) that belongs to the selected Scenario. |
Fiscal Year (1) | First Fiscal Year selected from the list of Fiscal Years associated to the scenario. Through this parameter, the User can choose the first Budget Version Fiscal Year for which the comparison will be performed. |
Fiscal Year (2) | Second Fiscal Year selected from the list of Fiscal Years associated to the scenario. Through this parameter, the User can choose the Second Budget Version Fiscal Year for which the comparison will be performed. |
Fiscal Year (3) | Third Fiscal Year selected from the list of Fiscal Years associated to the scenario. Through this parameter, the User can choose the third Budget Version Fiscal Year for which the comparison will be performed. |
COA Group | COA Group selected by the user, restricted to the Scenario COA groups with Apply for Ceilings set to False. |
Comment | Comment entered by the User. |
Hierarchy Rollups COA Elements | This functionality will allow to filter by any of the CoA concept elements. |
Coding Block Filter type | Possible values are “Coding Block”, “Coding Block Expression Filter”, and “Hierarchical Coding Block Element”. If “Coding Block” is selected, the system will allow the user to enter a coding block that will be used for filtering. “Coding Block Expression Filter” is selected the system will allow the user to enter a coding block expression that will be used for filtering. If “Hierarchical Coding Block Element” is selected, the system will allow the user to select any CoA concept element or ranges of elements, from the segment that are included in the selected CoA Group. |
Coding Block | This field will allow the user to enter the Coding Block, if Coding Block Filter type is set to “Coding Block”. |
Segment | Segment used for filtering if Coding Block Filter type is set to “Hierarchical Coding Block Element” – one (1) or more segment(s) can be selected, or for grouping (along with the selected concept), for any Coding Block Filter type. |
Concept | Concept used for filtering, for each selected segment, if Coding Block Filter type is set to “Hierarchical Coding Block Element”, or for grouping, for any Coding Block Filter type. |
Overview
This report shows a list of the defined Budget Ceilings for the selected Fiscal Year compared to the Previous Year’s Ceiling. It also shows the variance between the two Ceilings amounts. This report is helpful for budgeting authorities as it helps them identify any variances between the Ceilings Figures for both years.
Navigation
Budget Planning ► Reports ► Budget Ceilings Comparison Report
Budget Ceilings Comparison Report screen Fields
Field | Description |
Scenario | First Scenario, from the list of Active Scenarios, for which the report will be generated. |
Budget Version | It manages the status and general information of each budget version. Each budget version within same scenario will share Budget Scenario parameters, Budget Plan Structure and Budget Ceiling Information. |
Fiscal Year (1) | First Scenario Fiscal Year for which the report will be generated |
Fiscal Year (2) | Second Scenario Fiscal Year, for which the report will be generated |
Fiscal Year (3) | Third Scenario Fiscal Year, for which the report will be generated |
COA Group | COA Group, selected from the list of COA groups belonging to Scenario A and B, with Apply for Ceiling set to True. |
Comment | Comment entered by the user. |
Hierarchy Rollups COA Elements | This functionality will allow to filter by any of the CoA concept elements. |
Coding Block Filter type | Possible values are “Coding Block”, “Coding Block Expression Filter”, and “Hierarchical Coding Block Element”. If “Coding Block” is selected, the system will allow the user to enter a coding block that will be used for filtering. “Coding Block Expression Filter” is selected the system will allow the user to enter a coding block expression that will be used for filtering. If “Hierarchical Coding Block Element” is selected, the system will allow the user to select any CoA concept element or ranges of elements, from the segment that are included in the selected CoA Group. |
Coding Block | This field will allow the user to enter the Coding Block, if Coding Block Filter type is set to “Coding Block”. |
Segment | Segment used for filtering if Coding Block Filter type is set to “Hierarchical Coding Block Element” – one (1) or more segment(s) can be selected, or for grouping (along with the selected concept), for any Coding Block Filter type. |
Concept | Concept used for filtering, for each selected segment, if Coding Block Filter type is set to “Hierarchical Coding Block Element”, or for grouping, for any Coding Block Filter type. |
Group | If checked, grouping will be performed for the selected Concept. |
Sub Total | If checked, sub totals will be displayed for the selected grouping. |
Overview
The purpose of this report is to show the distribution of Budget Ceilings from higher COA group levels to lower levels.
Navigation
Budget Planning ► Reports ► Budget Ceiling Distribution Report
Budget Ceiling Distribution Report screen Fields
Field | Description |
Scenario | Scenario from which the Budget Plan information extracted. |
Fiscal Year | By clicking dropdown list users get the fiscal year list to select. |
COA Group | Selected COA Group of parent ceiling displayed, selected from the list of Scenario COA Groups. |
Comment | Comment based on the report. |
Overview
The purpose of this report is to show the list of Budget Plans, with Budget Plan Code, Budget Plan Description, Budget Plan Status, Last Updated Date and Responsible User, for the selected Budget Version, Deadline Date, Budget Plan Status, Budget Plan Type, and filtered Chart of Accounts concepts and elements.
Navigation
Budget Planning ► Reports ► Budget Plan Report
Budget Plan Status Report screen Fields
Field | Description |
Scenario | Scenario from which the Budget Plan information will be extracted. |
Fiscal Year | Display all available fiscal years. Mandatory Parameter. |
Date for Generation | Date for which the budget plan is generated. |
Budget Version | Mandatory parameter. The user should select any version that belongs to any Scenario that matches the selected fiscal year. |
Budget Plan Status | Budget Plan Status that can be selected from the following possible values: “All”, “Open”, “Completed”, “Under Analysis”, “Closed”, “Partially Sent for Execution”, “Fully Sent for Execution”, “Revised”, “Uncompleted”. |
| Budget Plan Type | Budget Plan Type ID and Description. |
Comment | Comment based on the report. |
Group Individual Institutions | Default checkbox value is true. |
Group By Institution Type | Group it by the type of institutions. |
Institution | As per report requirement check the institution. |
Overview
This is a statutory budget report that is sent out to Government Of Jamaica for discussion and approval. The report shows detailed estimates for Ministries and Departments expenditures, for Financial Patterns Recurrent (1), Capital A (2), or Capital B (3).
.
Navigation
Budget Planning ►Budget Book Builder ► Jamaica Reports ► Statutory Provisions and Provisions to be Voted
Statutory Provisions and Provisions to be Voted screen fields and Tab
| Field | Description |
Scenario | Through this parameter user can choose the scenario for which he wants to generate the report |
Planning CoA Group | The Default value is the CoA Group from Scenario CoA Group with attribute Lower level CoA Group equal to Null |
Print Amount | States the print amount |
Execution CoA Group | Signifies the Executing CoA group for the report to be generated. |
Fiscal Year | The current Fiscal Year |
Fiscal Year – 2 | This is the Budget Execution Fiscal Year |
Fiscal Year – 1 | This field states the Actuals Fiscal Year |
Budget Version (Fiscal Year) | First Budget Version in list. Alphabetically ascending order. |
Fiscal Year 1: | This field states the Projection 1 Fiscal Year |
Budget Version (Fiscal Year 1) | Budget version for Fiscal Year 1 |
Fiscal Year 2 | This field states the Projection 2 Fiscal Year |
Budget Version (Fiscal Year 2) | Budget version for Fiscal Year 2 |
Fiscal Year 3 | This field states the Projection 3 Fiscal Year |
Budget Version (Fiscal Year 3) | Budget version for Fiscal Year 3 |
Comment | Comment regarding the report |
Overview:
This Report list the budget amount calculated by the Cost Drivers values register during Budget Line detail registration.
Navigation:
Budget Line Cost Driver Report screen fields:
| Fields | Description |
| Fiscal Year | Filter criteria for fiscal year, Displays all available fiscal years. |
| Budget Version | Filter criteria for budget version. Users can select any version that belongs to any Scenario that matches the selected fiscal year. |
| Budget Plan | Filter criteria for Budget Plan, Indicates a single Budget Plan that matches the fiscal year in Budget version. |
| Institution | Filter criteria for Institution. Allows the user to select any institution. |
| Budget Plan Status | The user could select the Budget Plan status as filter criteria. |
| CoA Group | COA Group used extract information for this report. The COA group must be entered by the users, if no Budget Plan is selected. |
| Group By Budget Plan | Allow users to group information by Budget Plan. |
| Comment | Comment entered by Users. |
| Hierarchy Rollups UACS Elements | Allow the user to filter by any concept and range of elements belonging to the CoA group. |