Project Costing Budget Spreadsheet Upload (PCI008)
- 28 Aug 2024
- 3 Minutes to read
-
Print
-
DarkLight
-
PDF
Project Costing Budget Spreadsheet Upload (PCI008)
- Updated on 28 Aug 2024
- 3 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Interface Description
Florida PALM Project Costing module is used for creating and maintaining Projects and their associated budgets or spend plans. The Project Costing module must be used for all Fixed Capital Outlay (FCO) but may be utilized for any project the Agency may need to track and report expenses and associated revenues.
The Project Costing module also provides additional Project Specific ChartFields that can be associated to the Project’s budget and/or recorded on Project related transactions.
Users will use these and other Project Costing specific fields, to report on project budgets, costs, and revenue. While at least one Activity is required to be established for each project, the Project Source Type, Project Category, and Project Subcategory are optional.
This spreadsheet upload will be used to upload the Budgetary information for an already existing Project within Florida PALM. The custom spreadsheet upload process will update the Budgetary information on a project, based on the details provided in the file. Once the Budgetary information is uploaded successfully, the Budget plan will be available for Finalization.
Click below to view the interface file layout and sample data file.
Business Process Model
This interface can be found in the following business processes:
Selection Criteria
The interface data selection criteria include the following:
Data Field | Data Field Details |
|---|---|
Attached File | Required |
File Layout
Field names and descriptions from the interface layout are provided below. Please refer to the detailed interface layout and sample data file.
| Data Field Name | Record Type | Data Field Description |
|---|---|---|
| PC Business Unit | Project Budget Plan | Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for Project related ChartFields. |
| Project ID | Project Budget Plan | Represents the Project ChartField which is used to capture a planned undertaking of something to be accomplished or produced, having a beginning and ending date, for which expenditures/costs and revenues are to be tracked. |
| Description | Project Budget Plan | Budget Plan Description |
| Activity ID | Project Budget Detail | Activity ID tracks specific tasks that make up a Project and records transactional details; a Project must have at least one associated Activity ID. |
| Project Budget Item | Project Budget Detail | Project Budget Item is used to define lower level budgets by expenditure type. Each Budget Item is associated with the corresponding Budgetary Account Value. |
| Budget Period | Project Budget Detail | Budget Period (Appropriation Year) |
| GL Business Unit | Project Budget Detail | Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions. |
| Organization | Project Budget Detail | Organization ChartField identifies the organizational entity associated with a transaction. |
| Account | Project Budget Detail | Specified as balance sheet account or operating account. |
| Fund | Project Budget Detail | Segregates and captures specific activities or classifies certain objectives in accordance with special regulations, restrictions, or limitations. |
| Budget Entity | Project Budget Detail | Budget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program. Budget Entity will retain the same value as in the current business system |
| Category | Project Budget Detail | Category ChartField represents both appropriation categories and revenue source codes. Category in PALM is mapped one-one with the current business system |
| State Program | Project Budget Detail | State Program ChartField tracks revenue and expenditures for programs within or across your organizations. |
| Grant | Project Budget Detail | Grant ID value used to track financial assistance that provides support or stimulation to accomplish a public purpose. |
| Contract | Project Budget Detail | Contract ChartField captures expenditure and revenue transactions for two party agreements. |
| OA1 | Project Budget Detail | Other Accumulator ChartField can be used for various purposes, such as, tracking for optional reporting, or cost pools. |
| OA2 | Project Budget Detail | Agency Unique ChartField is a flexible field reserved for tracking for optional reporting or specific use. |
| PC Source Type | Project Budget Detail | The Source Type ChartField identifies the purpose or origin of a Project-related transaction. |
| PC Category | Project Budget Detail | The Project Category ChartField provides more flexibility and granularity in tracking and analyzing financial activity associated with a Project. |
| PC Subcategory | Project Budget Detail | The Subcategory ChartField provides more flexibility and granularity in tracking and analyzing financial activity associated with a Project. |
| Accounting Date | Project Budget Detail | The accounting entry date for a given transaction. Date must be in MM/DD/YYYY format |
| Foreign Amount | Project Budget Detail | Specifies the budget amount. |
Version History
Date | Revision Description |
|---|---|
06/04/2024 | Original Version |
| 08/28/2024 | Updated per version history date 07/15/2024: Updated as per DDID #0718 - Add Budget Plan details |
Was this article helpful?
