- 30 Aug 2024
- 4 Minutes to read
-
Print
-
DarkLight
-
PDF
Inbound Budget Journal Spreadsheet Upload (KKI012)
- Updated on 30 Aug 2024
- 4 Minutes to read
-
Print
-
DarkLight
-
PDF
Interface Description
The Spreadsheet Upload tool is intended for use when a large volume of Budget Journals need to be created. The Inbound Budget Journal Spreadsheet Upload interface creates Budget Journals using spreadsheet utility tool.
- DFS users can use this tool to create budget journals for designated budget structures (i.e., Appropriations, Releases, and Reserves).
- Agency users can use this tool to create budget journals only for the Allotments and Revenue Estimates ledgers.
This interface consists of the following core functions:
- Enter the details on the Budget Journal Spreadsheet template.
- Create a csv file in the appropriate format.
- Import the file into the Florida PALM through custom process.
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:
Interface Selection Criteria
The interface data selection criteria includes the following:
Data Field | Data Field Details |
---|---|
Run Control ID | Required |
Character Set | Required |
Journal ID Mask | Optional |
File Layout
The layout of the interface is listed below.
Data Field | Record Type | Data Field Description |
---|---|---|
Business Unit | KK Budget Header | Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions. |
Journal Date | KK Budget Header | Specifies the transaction date the journal was created. |
Long Description | KK Budget Header | Long description field of up to 254 characters, e.g., EOG Code & Title to represent entries into LAS/PBS for appropriations, unbudgeted reserve, releases, and budget amendments. An EOG Code for budget amendments is unique and assigned systematically by EOG/OPB Budget Amendment Process System. |
Ledger Group | KK Budget Header | Defines the appropriate ledger group for the transaction. Ledger groups enable the grouping of Detail Ledgers which allows multiple ledgers to be controlled by a single Budget Structure. Ledger Groups also enable the interaction of Detail Ledgers with one another to calculate remaining spending authority for expenditure budgets and variances for revenue estimates. |
Budget Entry Type | KK Budget Header | Used to categorize budget amounts to enable reporting of budget activity. Select 0 for Original when establishing new budget amounts. Select 1 for Adjustment when adjusting or modifying the amount of an existing budget. |
Alternate Description | KK Budget Header | Alternate description of 150 characters in length. |
Journal Line Number | KK Budget Line | Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header. |
Budget Period | KK Budget Line | Budget Period (Appropriation year) |
SpeedKey | KK Budget Line | Code that defines ChartField line information for Budget Journals. The full ChartField string as defined in the SpeedKey will be populated onto the Budget Journals during the file load process. |
Organization | KK Budget Line | Organization ChartField tracks information according to a breakdown of your organization. |
Account | KK Budget Line | Provides functionality to capture detailed transactional data. Can be specified as a balance sheet account or operating account. |
Fund | KK Budget Line | Segregates and captures specific activities or classifies certain objectives in accordance with special regulations, restrictions, or limitations. |
Budget Entity | KK Budget Line | Budget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program. |
Category | KK Budget Line | Category ChartField represents both appropriation categories and revenue source codes. |
State Program | KK Budget Line | State Program is used to identify the plan for an organization and use of resources to meet specified objectives of the State. |
Grant | KK Budget Line | Grant ID value used to track financial assistance that provides support or stimulation to accomplish a public purpose. |
Contract | KK Budget Line | Contract ChartField captures expenditure and revenue transactions for two party agreements. |
OA1 | KK Budget Line | OA1 is a flexible ChartField reserved for tracking for optional reporting or specific use. |
OA2 | KK Budget Line | OA2 is a flexible ChartField reserved for tracking for optional reporting or specific use. |
PC Business Unit | KK Budget Line | 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 | KK Budget Line | Project ChartField 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. |
Activity | KK Budget Line | Tracks specific tasks that make up a Project and records transactional details; a Project must have at least one associated Activity ID. |
PC Source Type | KK Budget Line | Source types identify the purpose or origin of a transaction. |
Monetary Amount | KK Budget Line | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. Value includes decimal point and two decimals i.e. 9999.99 |
Journal Class | KK Budget Line | This field reserved for LAS/PBS budget journal categorization of mandatory reserve or unbudgeted reserve transactions. |
Journal Line Reference | KK Budget Line | Used to store a reference for a particular line, e.g., GAA Line Number. The GAA Line Number is the specific line number of the GAA legislation passed and authorized budget for agency for stated purposes in the performance of functions authorized by law. |
Journal Line Reference Description | KK Budget Line | Journal line description, e.g. statutory authority for appropriations. |
Version History
Date | Revision Description |
---|---|
12/01/2023 | Original Version |
08/30/2024 | Updates include version history dates of: 2/16/2024: Design Updates completed for ChartFields validations as per the ledger groups. 3/22/2024: --to remove CC_PROJECT references from processing rules. --to remove ALOT_XXXXX references from processing rules for Project ChartFields. |