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

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
34 26-Nov-2021 10:22 21 KB JAiken to previous
33 26-Nov-2021 10:22 21 KB JEscott to previous | to last
32 26-Nov-2021 10:22 21 KB JEscott to previous | to last
31 26-Nov-2021 10:22 21 KB JEscott to previous | to last
30 26-Nov-2021 10:22 21 KB JEscott to previous | to last
29 26-Nov-2021 10:22 21 KB JEscott to previous | to last
28 26-Nov-2021 10:22 21 KB JEscott to previous | to last
27 26-Nov-2021 10:22 21 KB JEscott to previous | to last
26 26-Nov-2021 10:22 21 KB JEscott to previous | to last
25 26-Nov-2021 10:22 21 KB JEscott to previous | to last
24 26-Nov-2021 10:22 21 KB JEscott to previous | to last
23 26-Nov-2021 10:22 21 KB JEscott to previous | to last
22 26-Nov-2021 10:22 21 KB JEscott to previous | to last
21 26-Nov-2021 10:22 21 KB JEscott to previous | to last

Page References

Incoming links Outgoing links
GENERAL LEDGER ACCOUNTS
GENERAL LEDGER ACCOUNTS

Version management

Difference between version and

At line 120 added 101 lines
;:0121 - I/C DR
;:0122 - I/C CR
;:0124 - I/C Suffix Mask
;:0125 - I/C DR Suffix
;:0126 - I/C CR Suffix
On [IDGA] screen, the following G/L Account entries are examples of set up:
|__G/L Account__| __Account Usage__| __Distr Mask__
|DUE FROM| SUFFIX 0124 - I/C Suffix Mask| ??-XXXX-????-??????
|DUE FROM| 0121 - I/C DR| 01-0880-0000-131000
|DUE FROM| 0100 0125 - I/C DR Suffix| 01-0880-0000-131100
|DUE FROM| 0885 0125 - I/C DR Suffix| 01-0880-0000-131885
|DUE TO| 0122 - I/C CR |??-????-0000-207088
|DUE TO 0100| 0126 - I/C CR Suffix| ??-????-0000-207088
|DUE TO 0885| 0126 - I/C CR Suffix| ??-????-0000-207088
Account Usage '0124 - I/C Suffix Mask' entry indicates that from:
Distr Mask ??-XXXX-????-??????
;:''Positions 4 - 7 ( XXXX ) contain the ‘Fund’ portion, which will be used as a suffix to read Account Usage '0125', '0126' entries.''
Account Usage '0121 - I/C DR' must be set up (used as the default).
;:''If suffix entries are not set up for Account usage 0125, this entry will be used.
;:'' The G/L Account Code 'DUE FROM' is then concatenated with the ‘Fund' portion of the distribution to read IDGA again with Account Usage '0125' and G/L Account code = 'DUE FROM 0100'.''
Account Usage '0122 - I/C CR' must be set up (used as the default).
;:''Same process as Account Usage '0121'.''
----
!!Inter-Company & Fringe
In Fund accounting, each agency (Police, Airport, etc. – 99 different funds) have a “share” in the General Fund bank account. All checks are paid by a single fund from the General Fund bank account. (There is only one bank account.)
For all monies paid out of the general fund on behalf of the various agencies, a transfer of “cash” is required in the general ledger. In this example, the liabilities are recorded and paid out of the general fund.
----
!!Example Definitions
1. G/L Distribution Segment
;:Fund - Department - Object - Project
;:??? - ???? - ????? - ?????
;:(The project is optional.)
2. Funds
;:341 – Agency 1 – operational area
;:400 – Agency 2 – operational area
;:001 – General Fund – general operating fund
3. Employer portion of health insurance is included in the fringe element.
;:Note that the Health Expense GL account does not have the I/C toggle turned ON since net expense charged to the agency is from the Fringe Expense Account. If the health expense (GL Account Code) has the inter-company toggle turned ON it will result in incorrect entries.
4. Inter-Company feature is controlled by the individual [IDGA] entries.
5. Fringe Benefit feature controlled by the group ([IDGR]) and element definitions. This example uses hours worked to pro-rate the employer paid fringe benefits.
----
!!Example Entry – with the Inter-Company and Fringe features turned OFF
Wages are paid for an employee who usually works at Agency 1. In this pay, the employee worked on a special project for Agency 2 for 10 of the 80 hours. [UPGL] creates the following entries:
||GL Acct|| PC Desc|| GL Code|| Dr Amt|| Cr Amt|| Fund|| I/C|| Fringe
|341-0615-4000| Reg $ |Wage-Ex| $800.00 | |Agency 1| Off| Off
|400-0775-4000| Reg $| Wage-Ex| $200.00| |Agency 2| Off| Off
|001-4171-2122| Fed Tax| Fdtax-Liab| | $250.00| General| Off| Off
|001-0615-3400| EE Health |Hth-Liab| |$100.00 |General| Off| Off
|341-0615-1100| ER Health| Hth-Exp |$120.00| |Agency 1| Off| Off
|001-0615-3400| ER Health| Hth-Liab| | $120.00 |General| Off| Off
|001-1000-0220| Net Pay| Bank-Liab| |$650.00| General |Off| Off
|Journal Total| | | $1,120.00| $1,120.00| | |
----
!!Example Entry - the Inter-Company feature turned OFF and the Fringe feature turned ON
;Total Fringe Costs $120.00 (ER Health)
;:''Agency 1 - 60 hours / total 80 hours X $120.00 = $90.00''
;:''Agency 2 – 20 hours / total 80 hours X $120.00 = $30.00''
||GL Acct|| PC Desc|| GL Code|| Dr Amt|| Cr Amt|| Fund|| I/C|| Fringe
|341-0615-4000| Reg $| Wage-Ex| $800.00| | Agency 1| Off| Off
|400-0775-4000| Reg $| Wage-Ex| $200.00 | |Agency 2| Off| Off
|001-4171-2122| Fed \\Tax|Fdtax-Liab | |$250.00| General| Off| Off
|001-0615-3400| EE\\Health|Hth-Liab| | $100.00| General| Off| Off
|341-0615-1100| ER\\Health|Hth-Exp |$120.00| | Agency 1| Off| On
|001-0615-3400| ER\\Health|Hth-Liab | |$120.00 |General| Off| Off
|001-1000-0220| Net\\Pay|Bank-Liab| |$650.00| General |Off| Off
ADDITIONAL FRINGE ENTRIES
|341-0615-1100| ER\\Health|Frng-Liab| | $120.00| Agency 1| Off| On
|341-0615-1100| ER\\Health|Frng-Exp| $90.00| | Agency 1| Off| On
|400-0615-1100| ER\\Health|Frng-Exp| $30.00| | Agency 2| Off| On
|Journal Totals| | | $1,240.00 | $1,240.00 | | |
Since the employee also worked in Agency 2, the additional entries relieve the health costs charged to Agency 1 based on the hours worked.
;Agency 1 Health Expense:
;:$120.00 Original Entry
;:$90.00 Health expense create by the fringe feature (Fringe Expense)
;:$120.00 Health expense clear by the fringe feature. (Fringe Liability)
;:$90.00 Net Health Costs
;Agency 2 Health Expense
;:$30.00 Health expense create by the fringe feature (Fringe Expense)
----
!!Example Entry – the Inter-Company and the Fringe features turned ON
This page (revision-34) was last changed on 26-Nov-2021 10:22 by JAikenTop