Inbound Budget Journal Spreadsheet Upload (KKI012)
  • 30 Aug 2024
  • 4 Minutes to read
  • Dark
    Light
  • PDF

Inbound Budget Journal Spreadsheet Upload (KKI012)

  • Dark
    Light
  • PDF

Article summary

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 UnitKK Budget HeaderUsed to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions.
Journal DateKK Budget HeaderSpecifies the transaction date the journal was created.
Long DescriptionKK Budget HeaderLong 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 GroupKK Budget HeaderDefines 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 TypeKK Budget HeaderUsed 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 DescriptionKK Budget HeaderAlternate description of 150 characters in length.
Journal Line NumberKK Budget LineUniquely 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 PeriodKK Budget LineBudget Period (Appropriation year)
SpeedKeyKK Budget LineCode 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 LineOrganization ChartField tracks information according to a breakdown of your organization.
AccountKK Budget LineProvides functionality to capture detailed transactional data. Can be specified as a balance sheet account or operating account.
FundKK Budget LineSegregates and captures specific activities or classifies certain objectives in accordance with special regulations, restrictions, or limitations.
Budget EntityKK Budget LineBudget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program.
Category
KK Budget LineCategory ChartField represents both appropriation categories and revenue source codes.
State ProgramKK Budget LineState Program is used to identify the plan for an organization and use of resources to meet specified objectives of the State.
GrantKK Budget LineGrant ID value used to track financial assistance that provides support or stimulation to accomplish a public purpose. 
ContractKK Budget LineContract ChartField captures expenditure and revenue transactions for two party agreements.
OA1KK Budget LineOA1 is a flexible ChartField reserved for tracking for optional reporting or specific use.
OA2KK Budget LineOA2 is a flexible ChartField reserved for tracking for optional reporting or specific use.
PC Business UnitKK Budget LineUsed to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions for Project related ChartFields.
ProjectKK Budget LineProject 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.
ActivityKK Budget LineTracks specific tasks that make up a Project and records transactional details; a Project must have at least one associated Activity ID.
PC Source TypeKK Budget LineSource types identify the purpose or origin of a transaction.
Monetary AmountKK Budget LineSpecifies 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 ClassKK Budget LineThis field reserved for LAS/PBS budget journal categorization of mandatory reserve or unbudgeted reserve transactions.
Journal Line ReferenceKK Budget LineUsed 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 DescriptionKK Budget LineJournal line description, e.g. statutory authority for appropriations.

 Version History

Date

Revision Description

12/01/2023

Original Version

08/30/2024Updates 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.




Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.