Inbound Journal Entry (GLI006)
  • 29 May 2024
  • 4 Minutes to read
  • Dark
    Light
  • PDF

Inbound Journal Entry (GLI006)

  • Dark
    Light
  • PDF

Article summary

Interface Description

GLI006 is an Inbound Journal Entry interface that supports a method of entry to receive General Ledger journals from external systems. Agencies can make the journal entries in their own system and import them into Florida PALM. This allows for a way to have journal entries in Florida PALM that are made independently from the Florida PALM system.

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

N/A

File Layout

Field names and descriptions from the interface layout are provided below. 

Data Field Name

Record Type

Data Field Description

Record Code

Journal Header

Record Code identifying the information on the record.

Business Unit

Journal Header

Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions.

Journal Date

Journal Header

Specifies the date the journal was created.

Adjusting Entry

Journal Header

Adjusting entry is an entry recorded at the end of the accounting period to record month-end or year-end adjustments, which includes audit adjustments, and adjustments performed to support financial reporting like GAAP, Full Accrual, etc.

Adjusting Period

Journal Header

Month-end or Year-end adjustments are segregated from the regular accounting period(s). Adjustment period is used to record the month end or year-end adjustment

Ledger Group

Journal Header

One or more ledgers indicating where journal entries will be posted to affect financial balances.

Ledger

Journal Header

Identifies where the journal entries will be recorded to impact financial balances.

Reversal Code

Journal Header

A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process.

Reversal Date

Journal Header

Specifies the date for an automatic reversal journal entry.

Reversal Adjustment Period

Journal Header

Indicates the Accounting Period for a reversal adjustment journal.

Source

Journal Header

Identifies the origin of a journal entry to facilitate inquiries and reporting.

Transaction Reference Number

Journal Header

Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal entry. The journal reference is helpful if you need to trace back to the source of the transaction.

Description

Journal Header

Used to provide a short description reflecting the purpose of the journal.

Journal Class

Journal Header

Used to categorize types of journals.

Long Description

Journal Header

Used to provide a long description reflecting the purpose of the journal.

Record Code

Journal Line

Record Code identifying the information on the record.

Business Unit

Journal Line

Used to define an organization or organizational subset that is independent with regards to one or more accounting or operational functions.

GL Journal Line Number

Journal Line

Sequential number of lines in the journal.

Ledger

Journal Line

Identifies where the journal entries will be recorded to impact financial balances.

Organization

Journal Line

Organization ChartField tracks information according to a breakdown of your organization.

Account

Journal Line

Provides functionality to capture detailed transactional data. Can be specified as a balance sheet account or operating account.

Fund

Journal Line

Segregates and captures specific activities or classifies certain objectives in accordance with special regulations, restrictions, or limitations.

Budget Entity

Journal Line

Budget Entity ChartField represents organizations and/or functions to which appropriations are made and typically represents a program.

Category

Journal Line

Category ChartField represents both appropriation categories and revenue source codes.

State Program

Journal Line

Stores Chart of Accounts information and provides the basic structure to segregate and categorize transactional and budget data.

Grant

Journal Line

Grant ChartField is used for tracking grants funding.

Contract

Journal Line

Contract ChartField captures expenditure and revenue transactions for two party agreements.

OA1

Journal Line

OA1 tracks optional organization reporting, cost pools, expenditures, revenues, or other specific use.

OA2

Journal Line

OA2 tracks optional organization reporting, cost pools, expenditures, revenues, or other specific use.

PC Business Unit

Journal Line

Project Costing Business Unit.

Project

Journal 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

Journal 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

Journal Line

PC Source types identify the purpose or origin of a transaction.

PC Proj Category

Journal Line

PC Project Category provides more flexibility and granularity in tracking and analyzing costs; not required.

PC Subcategory

Journal Line

PC Subcategories provides more flexibility and granularity in tracking and analyzing costs; not required.

Analysis Type

Journal Line

Type of project transaction.

Monetary Amount

Journal 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 Line Reference

Journal Line

May be used to reflect a legacy system transaction number.

Journal Line Description

Journal Line

Description of the journal line which is populated with the Account ChartField value description as a default unless a specified value is provided.

Budget Date

Journal Line

Indicates the date within the correlating budget period that the journal is eligible to be budget checked against.

Inter/IntraUnit Group Number

Journal Line

Groups a set of journal lines as a set of InterUnit or IntraUnit transactions.

Inter/IntraUnit Anchor

Journal Line

Indicates which journal line contains the anchor Business Unit value for the InterUnit or IntraUnit transactions.

Filler1

Journal Line

This field is reserved for future use in Florida PALM.

Filler2

Journal Line

This field is reserved for future use in Florida PALM.

Version History

Date

Revision Description

11/29/2023

Original Version

01/17/2024Removed Commitment Control Amount Type, Journal ID and System Source fields from File Layout section to conform to Financial Wave requirements.  

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.