This page (revision-12) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JEscott

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
12 26-Nov-2021 10:22 10 KB JMyers to previous
11 26-Nov-2021 10:22 12 KB JMyers to previous | to last
10 26-Nov-2021 10:22 11 KB JEscott to previous | to last
9 26-Nov-2021 10:22 11 KB JEscott to previous | to last
8 26-Nov-2021 10:22 11 KB JEscott to previous | to last
7 26-Nov-2021 10:22 11 KB JEscott to previous | to last
6 26-Nov-2021 10:22 11 KB JEscott to previous | to last
5 26-Nov-2021 10:22 11 KB JEscott to previous | to last
4 26-Nov-2021 10:22 11 KB JEscott to previous | to last
3 26-Nov-2021 10:22 11 KB JEscott to previous | to last
2 26-Nov-2021 10:22 4 KB JEscott to previous | to last
1 26-Nov-2021 10:22 3 KB JEscott to last

Page References

Incoming links Outgoing links
IDGA
IDGA

Version management

Difference between version and

At line 1 removed 3 lines
[{TableOfContents }]
!!!DEFINE G/L ACCOUNTS
At line 6 changed one line
Users less familiar with accounting systems and [general ledger accounts|GENERAL LEDGER ACCOUNTS] usually find G/L account codes simpler to work with than account numbers.
Users less familiar with accounting systems and general ledger accounts usually find G/L account codes simpler to work with than account numbers.
At line 10 changed one line
;[G/L Account|GL_ACCOUNT_CODE]:This field provides the name or abbreviation for a general ledger account that uniquely identifies it to the organization. G/L account codes include items such as expense accounts for labor, salary, wages, benefits, payroll taxes, and fringe costs, liability accounts for taxes, benefits, and other sundry liabilities, and payroll clearing accounts, bank accounts, suspense accounts, etc.
;G/L Company: This field identifies the GL company for which the GL Account Codes are being defined. GL_Company_Code is a 16-character alphanumeric mandatory field you must manually enter or use the LOV (F9) to choose their option.
At line 9 added 2 lines
;G/L Account:This field provides the name or abbreviation for a general ledger account that uniquely identifies it to the organization. G/L account codes include items such as expense accounts for labor, salary, wages, benefits, payroll taxes, and fringe costs, liability accounts for taxes, benefits, and other sundry liabilities, and payroll clearing accounts, bank accounts, suspense accounts, etc. GL_Account_Code is a 16 character alphanumeric mandatory field you must manually enter.
At line 13 changed 7 lines
;[Description|DESCRIPTION]:This field shows the user defined description of the purpose of the account.
;[Journal Type|JOURNAL_TYPE]:This field indicates that the GL account code posts to either a financial or a statistical journal.
;[Account Type|ACCOUNT_TYPE]:This field catagorizes the account into a specific type. Account type is used for sorting and query purposes. Asset, Liability (CR), Equity, Revenue, or Expense (DR) Most accounts will be Liability (CR) or Expense (DR).
;[Account Usage|ACCOUNT_USAGE]:Indicates the purpose of the account, for example, as an expense, liability, clearing or other special type of account.
|General Expenses (DR)\\0010| - indicates that the amount is to be journalized as ‘Expenses’\\ - Expense (DR) amount is posted exactly as the amount specified, positive\\ or negative. \\- these are normally wages (that make up gross) and ER contributions of\\company benefit\\ - need to be indicated on Pay Component ([IPPC]) form as ‘Debit Account’\\in order to be posted as a expense
|General Liability (CR)\\0020|- indicates that the amount is to be journalized as ‘Liabilities’\\ - Liability (CR) amount will be negated and then posted\\- these are normally EE deductions and ER contributions for company\\benefits \\- need to be indicated on Pay Component ([IPPC]) form as ‘Credit Account’\\in order to be posted as a liability
|EAS Work Type \\0030|- indicates to use the GL account code to concatenate with the assignment's\\work type and then further retrieve the distribution mask by this \\GL account and work type from [IDGA] form \\''E.G.'' \\''GL Account = 'SAT O/T WAGES''\\ '''EAS Work Type = '10' means 'Booth set up' ''\\''then use 'SAT O/T WAGES10' to retrieve Distribution Mask from [IDGA]''
;Description:This field shows the user defined description of the purpose of the account. Description is a 50 character alphanumeric optional field you may manually enter.
;Journal Type:This field indicates that the GL account code posts to either a financial or a statistical journal. Journal_Type is a mandatory fixed lexicon ([X_JOURNAL_TYPE])
;Account Type:This field catagorizes the account into a specific type. Account type is used for sorting and query purposes. Asset, Liability (CR), Equity, Revenue, or Expense (DR) Most accounts will be Liability (CR) or Expense (DR). Account_Type is a mandatory fixed lexicon ([X_ACCOUNT_TYPE])
;Account Usage:Indicates the purpose of the account, for example, as an expense, liability, clearing or other special type of account. Account_Usage is an optional fixed lexicon ([X_ACCOUNT_USAGE]).
|General Expenses (DR)\\0010| - indicates that the amount is to be journalized as ‘Expenses’\\ - Expense (DR) amount is posted exactly as the amount specified, positive\\ or negative. \\- these are normally wages (that make up gross) and ER contributions of\\company benefit\\ - need to be indicated on Pay Component (IPPC) form as ‘Debit Account’\\in order to be posted as a expense
|General Liability (CR)\\0020|- indicates that the amount is to be journalized as ‘Liabilities’\\ - Liability (CR) amount will be negated and then posted\\- these are normally EE deductions and ER contributions for company\\benefits \\- need to be indicated on Pay Component (IPPC) form as ‘Credit Account’\\in order to be posted as a liability
|EAS Work Type \\0030|- indicates to use the GL account code to concatenate with the assignment's\\work type and then further retrieve the distribution mask by this \\GL account and work type from IDGA form \\''E.G.'' \\''GL Account = 'SAT O/T WAGES''\\ '''EAS Work Type = '10' means 'Booth set up' ''\\''then use 'SAT O/T WAGES10' to retrieve Distribution Mask from IDGA''
At line 21 changed one line
|Labor Clearing 0102|- to balance Labor GL entries during 'Journalize Labor' ([UPLG])\\- to clear Labor GL entries during 'Journalize Pays' ([UPGL])\\- only those GL accounts with the 'Pre Payroll' toggle set to ON will be\\accumulated to 'Labor Clearing'
|Labor Clearing 0102|- to balance Labor GL entries during 'Journalize Labor' (UPLG)\\- to clear Labor GL entries during 'Journalize Pays' (UPGL)\\- only those GL accounts with the 'Pre Payroll' toggle set to ON will be\\accumulated to 'Labor Clearing'
At line 41 changed one line
;[Posting Date Method|POSTING_DATE_METHOD]:The Posting Date method controls the accounting period to which general ledger entries are to be attributed and by default, entries for a pay period are allocated based on the type of payment. Post all entries based on the ‘Pay Period End Date’ or the ‘Pay Issue Date’, or post by the ‘Derive Fiscal’ (most commonly used) method.
;Posting Date Method:The Posting Date method controls the accounting period to which general ledger entries are to be attributed and by default, entries for a pay period are allocated based on the type of payment. Post all entries based on the ‘Pay Period End Date’ or the ‘Pay Issue Date’, or post by the ‘Derive Fiscal’ (most commonly used) method.
At line 44 changed 12 lines
;[Distribution Mask|DISTRIBUTION_MASK]: This field holds the distribution code or distribution mask associated with this GL account code.
;[Account Charge To|ACCOUNT_CHARGE_TO]:This field indicates if this G/L Account is to be charged to either the 'Wage’ or 'Benefit' accounts set up on [IEAS] distributions tab for each employee's assignment. The Account Charge To field will typically be set to ‘Wage Account’; for Benefit Burden G/L Accounts, you must manually set it to ‘Benefit Account’. [UPGL] will use the [IEAS] Distributions tab entries according to [IDGA] 'Account Charge To' set up as follows:
;:If [IDGA]’s Account Charge To field is set to ‘Benefit Account’, then the [IEAS] Distribution entries with the Split Rule field set to ‘Benefit Account’ will be used.
;:If the [IEAS] distribution entries with the ‘Benefit Account’ Split Rule are not set up, then the split rules will be used. Otherwise, [IEAS] distribution entries with other split Rule will be used. i.e. 'Split by Percent', etc.
;[Affects Costing|AFFECTS_COSTING]: If the Affects Costing toggle is ON, this account will create cost accounting entries for posting to a costing system. If the Affects Costing toggle is OFF, no costing entries will be created.
;[Retain Detail|RETAIN_DETAIL]: When interfacing to a G/L system, if the Retain Detail toggle is ON, no consolidation of payroll accounting entries will be performed. Detailed entries will be created by account, by person, by pay and by pay line detail. If the toggle is OFF, payroll accounting entries will be consolidated by general ledger account.
;[Pre-Payroll|PRE_PAYROLL]: If the Pre-Payroll toggle is ON, any accounting process that runs prior to payroll processing (e.g. [UPLG] - labor distribution) will create accounting entries for posting to the general ledger and costing. If the Pre-Payroll toggle is OFF, these accounting processes will create no accounting entries.
;[Accrual Required|ACCRUAL_REQUIRED]:If the Accrual Required toggle is ON, this account will have accrual accounting entries created on the last payroll of a fiscal period. Accruals will be calculated based on the accrual method of the Employee's Group ([IDGR]). If the toggle is OFF, no accrual entries will be created for this account.
;[Post Payroll|POST_PAYROLL]:If the Post Payroll toggle is ON, the payroll process will create accounting entries for posting the general ledger ([UPGL]) and for costing purposes. If the Post Payroll toggle is OFF, the payroll process will create no accounting entries.
;[InterCompany Required|INTERCOMPANY_REQUIRED]: If the InterCompany toggle is ON, inter-company accounting entries will be generated between entities. If the toggle is OFF, no inter-company accounting will be done.
;:Posting_Date_Method is an optional fixed lexicon ([X_POSTING_DATE_METHOD])
;Distribution Mask: This field holds the distribution code or distribution mask associated with this GL account code. Distribution_Format is a 50-character alphanumeric optional field that will default from the G/L Company chosen.
;Account Charge To:This field indicates if this G/L Account is to be charged to either the 'Wage’ or 'Benefit' accounts set up on IEAS distributions tab for each employee's assignment. The Account Charge To field will typically be set to ‘Wage Account’; for Benefit Burden G/L Accounts, you must manually set it to ‘Benefit Account’. UPGL will use the IEAS Distributions tab entries according to IDGA 'Account Charge To' set up as follows:
;:If IDGA’s Account Charge To field is set to ‘Benefit Account’, then the IEAS Distribution entries with the Split Rule field set to ‘Benefit Account’ will be used.
;:If the IEAS distribution entries with the ‘Benefit Account’ Split Rule are not set up, then the split rules will be used. Otherwise, IEAS distribution entries with other split Rule will be used. i.e. 'Split by Percent', etc.
;:Account_Charge_To is an optional fixed lexicon ([X_ACCOUNT_CHARGE_TO]).
----
!Account Toggles
;Affects Costing: If the Affects Costing toggle is ON, this account will create cost accounting entries for posting to a costing system. If the Affects Costing toggle is OFF, no costing entries will be created. Affects_Costing is an optional toggle field.
;Retain Detail: When interfacing to a G/L system, if the Retain Detail toggle is ON, no consolidation of payroll accounting entries will be performed. Detailed entries will be created by account, by person, by pay and by pay line detail. If the toggle is OFF, payroll accounting entries will be consolidated by general ledger account. Retain_Detail is an optional toggle field.
;Pre-Payroll: If the Pre-Payroll toggle is ON, any accounting process that runs prior to payroll processing (e.g. UPLG - labor distribution) will create accounting entries for posting to the general ledger and costing. If the Pre-Payroll toggle is OFF, these accounting processes will create no accounting entries. Pre_Payroll is an optional toggle field.
;Accrual Required:If the Accrual Required toggle is ON, this account will have accrual accounting entries created on the last payroll of a fiscal period. Accruals will be calculated based on the accrual method of the Employee's Group (IDGR). If the toggle is OFF, no accrual entries will be created for this account. Accrual_Required is an optional toggle field.
;Post Payroll:If the Post Payroll toggle is ON, the payroll process will create accounting entries for posting the general ledger (UPGL) and for costing purposes. If the Post Payroll toggle is OFF, the payroll process will create no accounting entries. Post_Payroll is an optional toggle field.
;InterCompany Required: If the InterCompany toggle is ON, inter-company accounting entries will be generated between entities. If the toggle is OFF, no inter-company accounting will be done. Intercompany_Required is an optional toggle field.
----
At line 63 changed 13 lines
;[Entity|ENTITY_CODE]: The G/L account should vary by the entity identified in this field.
;[Unit|UNIT_CODE]: The G/L account will vary by the unit identified in this field. You must enter an entity prior to specifying the unit.
;[Group|GROUP_CODE]: The G/L account should vary by the group identified in this field. You must enter an entity and unit prior to specifying the group.
;[Other Suffix|GL_ACCOUNT_SUFX]: This field is currently not being used.
;[State|STATE_PROVINCE_CODE]: The G/L account should vary by the state/province identified in this field.
;[County|COUNTY_CODE]: The G/L account should vary by the county identified in this field. You must enter a state prior to specifying the county.
;[Geo|GEO_CODE]: The G/L account should vary by the tax jurisdiction (i.e. Geo code) identified in this field. You must enter a state prior to specifying the tax jurisdiction.
;[School District|SCHOOL_DISTRICT_CODE]:The G/L account should vary by the school district identified in this field. You must enter a state prior to specifying the school district.
----
![Notes|Edit:Internal.IDGA]
[{InsertPage page='Internal.IDGA' default='Click to create a new notes page'}]
;Entity: The G/L account should vary by the entity identified in this field. Entity_Code from [P2K_CM_ENTITIES] is an optional 16-character alphanumeric field that you may manually enter or select a value from the LOV (F9) provided.
;Unit: The G/L account will vary by the unit identified in this field. You must enter an entity prior to specifying the unit. Unit_Code from [P2K_CM_UNITS] is an optional 16-character alphanumeric field that you may manually enter or select a value from the LOV (F9) provided.
;Group: The G/L account should vary by the group identified in this field. You must enter an entity and unit prior to specifying the group. Group_Code from [P2K_CM_GROUPS] is an optional 16-character alphanumeric field that you may manually enter or select a value from the LOV (F9) provided.
;Other Suffix: This field is currently not being used. GL_Account_Sufx is an optional 30 character field that you may manually enter.
;State: The G/L account should vary by the state/province identified in this field. State_Province_Code from [P2K_CM_STATE_PROVINCES] is an optional 16-character field that you may manually enter or select a value from the LOV (F9) provided.
;County: The G/L account should vary by the county identified in this field. You must enter a state prior to specifying the county. County_Code from [P2K_CM_COUNTIES] is an optional 16-character field that you may manually enter or select a value from the LOV (F9) provided.
;Geo: The G/L account should vary by the tax jurisdiction (i.e. Geo code) identified in this field. You must enter a state prior to specifying the tax jurisdiction. Jurisdiction from [P2K_CM_TAX_JURISDICTIONS] is an optional 16-character field that you may manually enter or select a value from the LOV (F9) provided.
;School District:The G/L account should vary by the school district identified in this field. You must enter a state prior to specifying the school district. School_District_Code from [P2K_CM_SCHOOL_DISTRICTS] is an optional 16-character field that you may manually enter or select a value from the LOV (F9) provided.
This page (revision-12) was last changed on 26-Nov-2021 10:22 by JMyersTop