It is possible within Wiki to have amounts from taxation to be journalized into separate accounts depending on the state, county, city or school district that the employee is in. If you are paying employees in Michigan and Indiana and have separate general ledger accounts for each state then you need to journalize by the level of taxation.
You should set up IDGL account suffix information by state, county, GEO or school district. Please follow the G/L Suffix Logic explained previously.
Pay Component Usage - IPCU#
For the Pay Components that are to be separately journalized, the "PC GL Type" field on the PC Usage form needs to be completed.- Work State/Prov for
- 6601 State Work Deduction - Regular
- 6602 State Work Deduction – Additional
- 6603 State Work Deduction - Supplemental
- Work County for
- 6801 County Work Deduction - Regular
- 6802 County Work Deduction - Additional
- Work GEO for
- 6901 City Work Deduction - Regular
- 6902 City Work Deduction - Additional
- Res State/Prov for
- 6621 State Res Deduction - Regular
- 6622 State Res Deduction - Additional
- 6624 State Res Deduction - Supplemental
- Res County for
- 6821 County Res Deduction - Regular
- 6822 County Res Deduction - Additional
- Res GEO for
- 6921 City Res Deduction - Regular
- 6922 City Res Deduction - Additional
- School District for
- 6803 County Work Deduction - School
- 6823 County Res Deduction - School
- 6903 City Work Deduction – School
- 6904 City Work Deduction – School
Pay Component - IPPC#
For the taxation Pay Components with the usages indicated above, make sure you have a G/L account indicated in the 'Credit Acc't' field.- i.e.: for PC 6400 (City Work Ded Tax)
- Credit Acc't = CITY WORK TX
GL Accounts - IDGA#
For the Credit Account from IPPC, define the GL mask- i.e.: CITY WORK TX mask = ??-9999-??????-99999999-999
Government Registration - IDGV#
For each 'level' of journalization, you need to ensure that there is a government registration defined.- For State/Prov (Res and/or Work) complete the following fields
- Registration Type:US State Registr
- State/Province:(Name of the state)
- Dist. Mask Cr:(Full or partial mask)
- For County (Res and/or Work) complete the following fields
- Registration Type:US Local Registr
- County:(Name of the county)
- Dist. Mask Cr:(full or partial mask)
- For School District (Res and/or Work, County or City) complete the following fields
- Registration Type:US Local Registr
- School District:(tax code for the school district)
- Dist. Mask Cr:(full or partial mask)
- For City (Res and/or Work) complete the following fields
- Registration Type:US Local Registr
- Jurisdiction:(tax jurisdiction code for the city)
- Dist. Mask Cr:(full or partial mask)
- i.e.:Local Registration - Jurisdiction:Aliquippa, PA
- Distr CR = ??-9999-777101-99999999-999
- Local Registration - Jurisdiction:Hopewell, PA
- Distr CR = ??-9999-777303-99999999-999
Example:
The GL distribution from the set up above for PC 6400, will be determined as follows:
| Employee's Distribution from IEAS | 10-0042-731401-99999999-999 |
| PC 6400 Credit Acc't | CITY WORK TX |
| IDGA for CITY WORK TX | ??-9999-??????-99999999-999 |
| IDGV according to the employee's work GEO code | ??-9999-777101-99999999-999 |
| RESULT OF GL WILL BE: | 10-9999-777101-99999999-999 |
