Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
20230109INT to Staff Attachment - Response to No. 21_1221 JE 73 Workers Comp Clearing.pdf
Batch Review - Journal Entry Personal Form:(No Personalization)Query:All Records Row Form Tools Batch Number 193566 Model Percent Reverse Doc Type/No/Co JE 24282 00048 G/L Date 12/31/2021 Explanation JE 73 Workers Comp Clearin Ledger Type A Records 1 - 100 * Defa Account Number Amount Account Description Subledger Type Subledger Subledger Description Remark 48597.5199.29200 595.72-dmin. & General Sal 2021 WC C 48.2362.ID1 4,398.12- ID Workers Comp 2021 WC Cl 48501.5199.29200 22.18 Admin. & General Sala 2021 WC Cl 48502.5199.29100 20.43 Misc. Customer Service Exp.2021 WC Cl 48504.5199.29200 53.53 Admin. & General Sala 2021 WC Cl 48506.5199.28130 43.01 Other Gas Supply Exp.2021 WC Cl 48508.5199.28750 35.25 Meas. & Reg. Stations-Gen.2021 WC Cl 48508.5199.28760 29.62 Meas. & Reg. Stations-Ind.2021 WC Cl 48508.5199.28780 .98 Meter & House Reg. Exp.2021 WC Cl 48508.5199.28790 1.23 Customer Installation 2021 WC Cl 48508.5199.28890 45.66 Mtc. of Meas. & Reg. Eq.-Gen 2021 WC Cl 48508.5199.28900 11.72 Mtc. of Meas. & Reg. Eq.-Ind 2021 WC Cl 48508.5199.28930 3.80 Maint. of Meters & House Reg 2021 WC Cl 48508.5199.29020 .10 Meter Reading Expense 2021 WC Cl 48508.5199.29030 .10 Customer Records & Co 2021 WC Cl 48509.5199.28700 12.90 Operation Supervision 2021 WC Cl 48509.5199.29200 4.65 Admin. & General Sala 2021 WC Cl 48513.5199.28410 48.51 Operation Labor & Exp 2021 WC Cl Page 1 of 2Batch Review - Journal Entry 1 6 202https://mdupd92.c03g.velocity.cloud/jde/E1Client.mafService?jdemafjascacheUID=2879&jdemafjasLauncher=PSFT_TE_V3_... Purpose: To true‐up worker's compensation, based on a labor distribution of actual hours in 2021. Source: Data provided by Reports Now pulled by Nicole Gyllenskog. Account Number Account Description Level Of Detail General Ledger Period Balance General Ledger Balance Posting Edit Code 48597.5199.29200 Admin. & General Sala 595.72 48.2362.ID1 Idaho Workers Comp 6 (13,506.80) 4,398.12 4,993.84$ 48597.5199.29200 (595.72) 2021 WC Clearing 48.2362.ID1 (4,398.12) 2021 WC Clearing 0.44% 48501.5199.29200 22.18 2021 WC Clearing 0.41% 48502.5199.29100 20.43 2021 WC Clearing 1.07% 48504.5199.29200 53.53 2021 WC Clearing 0.86% 48506.5199.28130 43.01 2021 WC Clearing 0.71% 48508.5199.28750 35.25 2021 WC Clearing 0.59% 48508.5199.28760 29.62 2021 WC Clearing 0.02% 48508.5199.28780 0.98 2021 WC Clearing 0.02% 48508.5199.28790 1.23 2021 WC Clearing 0.91% 48508.5199.28890 45.66 2021 WC Clearing 0.23%48508.5199.28900 11.72 2021 WC Clearing 0.08% 48508.5199.28930 3.80 2021 WC Clearing 0.00% 48508.5199.29020 0.10 2021 WC Clearing 0.00% 48508.5199.29030 0.10 2021 WC Clearing 0.26% 48509.5199.28700 12.90 2021 WC Clearing 0.09% 48509.5199.29200 4.65 2021 WC Clearing 0.97% 48513.5199.28410 48.51 2021 WC Clearing 2.58% 48514.5199.29200 129.02 2021 WC Clearing 0.43% 48518.5199.29010 21.50 2021 WC Clearing 2.58% 48518.5199.29030 129.02 2021 WC Clearing 3.35%48520.5199.29120 167.36 2021 WC Clearing 1.16% 48521.5199.29200 57.91 2021 WC Clearing 2.44% 48526.5199.29200 122.00 2021 WC Clearing 0.26% 48533.5199.28700 13.08 2021 WC Clearing 0.04% 48534.5199.28740 1.86 2021 WC Clearing 0.05% 48534.5199.28750 2.51 2021 WC Clearing 1.08% 48534.5199.28780 53.75 2021 WC Clearing 3.49% 48534.5199.28790 174.43 2021 WC Clearing 0.28% 48534.5199.28870 13.78 2021 WC Clearing 0.11% 48534.5199.28871 5.46 2021 WC Clearing 0.98% 48534.5199.28920 49.10 2021 WC Clearing 1.06%48534.5199.28930 52.96 2021 WC Clearing 1.67% 48534.5199.29020 83.48 2021 WC Clearing 0.45% 48534.5199.29030 22.53 2021 WC Clearing 0.00% 48535.5199.28750 0.12 2021 WC Clearing 0.01% 48535.5199.28790 0.42 2021 WC Clearing 1.12% 48535.5199.28800 56.12 2021 WC Clearing 1.30% 48535.5199.28920 65.06 2021 WC Clearing 0.54% 48535.5199.29020 26.73 2021 WC Clearing 0.00% 48536.5199.28630 0.19 2021 WC Clearing 1.31% 48536.5199.28700 65.66 2021 WC Clearing 0.86%48536.5199.28740 43.01 2021 WC Clearing 0.15% 48536.5199.28760 7.45 2021 WC Clearing 0.01% 48536.5199.28780 0.75 2021 WC Clearing 1.24% 48536.5199.28800 61.71 2021 WC Clearing 0.57% 48536.5199.28870 28.27 2021 WC Clearing 0.00% 48536.5199.28890 ‐ 2021 WC Clearing 3.31% 48536.5199.28920 165.40 2021 WC Clearing 0.06% 48536.5199.29030 3.01 2021 WC Clearing 0.00% 48536.5199.29250 0.02 2021 WC Clearing 0.36% 48538.5199.28700 17.85 2021 WC Clearing 0.63%48538.5199.28740 31.68 2021 WC Clearing 0.19% 48538.5199.28750 9.35 2021 WC Clearing 1.83% 48538.5199.28790 91.53 2021 WC Clearing 0.20% 48538.5199.28800 10.08 2021 WC Clearing 0.16% 48538.5199.28870 7.86 2021 WC Clearing 0.24% 48538.5199.28871 12.07 2021 WC Clearing 0.39% 48538.5199.28920 19.47 2021 WC Clearing 0.56% 48538.5199.28930 28.10 2021 WC Clearing 0.71% 48538.5199.29020 35.62 2021 WC Clearing 0.66% 48538.5199.29030 33.02 2021 WC Clearing 0.04%48538.5199.29250 1.98 2021 WC Clearing 0.55% 48539.5199.28700 27.59 2021 WC Clearing 0.89% 48539.5199.28740 44.36 2021 WC Clearing 0.03% 48539.5199.28750 1.67 2021 WC Clearing 0.08% 48539.5199.28760 4.04 2021 WC Clearing Worker's Compensation‐ 5199 0.00% 48539.5199.28780 0.22 2021 WC Clearing 0.06% 48539.5199.28800 2.75 2021 WC Clearing 0.77% 48539.5199.28870 38.52 2021 WC Clearing 0.01% 48539.5199.28871 0.63 2021 WC Clearing 0.01% 48539.5199.28890 0.41 2021 WC Clearing 0.00% 48539.5199.28900 0.22 2021 WC Clearing 1.32% 48539.5199.28920 65.68 2021 WC Clearing 0.39% 48541.5199.28700 19.46 2021 WC Clearing 0.46% 48542.5199.28700 22.74 2021 WC Clearing 0.66% 48542.5199.28740 33.10 2021 WC Clearing 0.00% 48542.5199.28750 0.14 2021 WC Clearing 0.22% 48542.5199.28780 11.08 2021 WC Clearing 3.29% 48542.5199.28790 164.15 2021 WC Clearing 1.25% 48542.5199.28800 62.27 2021 WC Clearing 0.13% 48542.5199.28920 6.45 2021 WC Clearing 0.12% 48542.5199.28930 5.75 2021 WC Clearing 0.18% 48542.5199.29020 9.19 2021 WC Clearing 0.00% 48542.5199.29030 (0.12) 2021 WC Clearing 0.00% 48542.5199.29250 0.02 2021 WC Clearing 0.58% 48543.5199.28700 29.12 2021 WC Clearing 0.53% 48543.5199.28740 26.55 2021 WC Clearing 0.02% 48543.5199.28760 0.83 2021 WC Clearing 0.01% 48543.5199.28780 0.44 2021 WC Clearing 0.01% 48543.5199.28790 0.45 2021 WC Clearing 0.37% 48543.5199.28870 18.58 2021 WC Clearing 0.01% 48543.5199.28890 0.28 2021 WC Clearing 1.35% 48543.5199.28920 67.48 2021 WC Clearing 0.00% 48543.5199.28930 0.01 2021 WC Clearing 0.02% 48546.5199.28436 1.10 2021 WC Clearing 0.40% 48546.5199.28700 20.21 2021 WC Clearing 0.92% 48546.5199.28740 45.83 2021 WC Clearing 0.01% 48546.5199.28760 0.34 2021 WC Clearing 2.86% 48546.5199.28780 142.99 2021 WC Clearing 0.26% 48546.5199.28790 12.97 2021 WC Clearing 0.11% 48546.5199.28800 5.28 2021 WC Clearing 0.05% 48546.5199.28870 2.73 2021 WC Clearing 0.22% 48546.5199.28920 11.02 2021 WC Clearing 0.23% 48546.5199.29020 11.43 2021 WC Clearing 1.30% 48546.5199.29030 64.86 2021 WC Clearing 0.02% 48547.5199.28630 1.04 2021 WC Clearing 1.05% 48547.5199.28700 52.34 2021 WC Clearing 0.78% 48547.5199.28740 38.92 2021 WC Clearing 0.02% 48547.5199.28760 1.19 2021 WC Clearing 0.03% 48547.5199.28800 1.51 2021 WC Clearing 0.52% 48547.5199.28870 25.77 2021 WC Clearing 0.03% 48547.5199.28890 1.69 2021 WC Clearing 1.09% 48547.5199.28920 54.51 2021 WC Clearing 0.16% 48549.5199.28436 8.04 2021 WC Clearing 0.05% 48550.5199.28530 2.69 2021 WC Clearing 0.51% 48550.5199.28700 25.56 2021 WC Clearing 0.14% 48550.5199.28740 7.15 2021 WC Clearing 0.06% 48550.5199.28760 2.82 2021 WC Clearing 0.00% 48550.5199.28800 0.02 2021 WC Clearing 1.57% 48550.5199.28870 78.40 2021 WC Clearing 0.00% 48550.5199.28890 0.12 2021 WC Clearing 1.18% 48550.5199.28920 58.82 2021 WC Clearing 0.02% 48550.5199.29250 1.14 2021 WC Clearing 0.40% 48552.5199.28700 20.00 2021 WC Clearing 0.98% 48552.5199.28740 49.08 2021 WC Clearing 0.00% 48552.5199.28750 0.01 2021 WC Clearing 2.70% 48552.5199.28780 134.68 2021 WC Clearing 0.33% 48552.5199.28790 16.27 2021 WC Clearing 0.03% 48552.5199.28800 1.51 2021 WC Clearing 0.01% 48552.5199.28870 0.62 2021 WC Clearing 0.01% 48552.5199.28871 0.73 2021 WC Clearing 0.02% 48552.5199.28920 1.01 2021 WC Clearing 0.13% 48552.5199.29020 6.37 2021 WC Clearing 0.85% 48552.5199.29030 42.28 2021 WC Clearing 0.00% 48552.5199.29250 0.09 2021 WC Clearing 0.43% 48553.5199.28700 21.50 2021 WC Clearing 0.13% 48553.5199.28740 6.71 2021 WC Clearing 0.00% 48553.5199.28750 0.16 2021 WC Clearing 0.61% 48553.5199.28780 30.23 2021 WC Clearing 0.99% 48553.5199.28790 49.42 2021 WC Clearing 0.00% 48553.5199.28920 0.07 2021 WC Clearing 0.00% 48553.5199.29020 (0.04) 2021 WC Clearing 0.43% 48553.5199.29030 21.64 2021 WC Clearing 0.01% 48554.5199.28631 0.36 2021 WC Clearing 1.66% 48554.5199.28740 83.09 2021 WC Clearing 0.56% 48554.5199.28870 28.03 2021 WC Clearing 0.51% 48558.5199.28800 25.32 2021 WC Clearing 0.43% 48559.5199.28660 21.59 2021 WC Clearing 1.51% 48559.5199.28930 75.47 2021 WC Clearing 0.05% 48563.5199.28700 2.64 2021 WC Clearing 0.03% 48563.5199.28740 1.45 2021 WC Clearing 0.01% 48563.5199.28760 0.30 2021 WC Clearing 0.03% 48563.5199.28850 1.37 2021 WC Clearing 0.02%48569.5199.28530 0.86 2021 WC Clearing 0.08% 48569.5199.28700 3.89 2021 WC Clearing 0.01% 48573.5199.29030 0.36 2021 WC Clearing ‐0.01% 48574.5199.29030 (0.32) 2021 WC Clearing 0.44% 48582.5199.29200 22.20 2021 WC Clearing 0.00% 48597.5199.29200 ‐ 2021 WC Clearing 0.34% 48598.5199.29200 17.12 2021 WC Clearing 0.00% 71300.5199.19030 0.10 2021 WC Clearing 0.00% 71300.5199.29030 0.20 2021 WC Clearing 0.00% 71400.5199.19030 (0.19) 2021 WC Clearing ‐0.01%71400.5199.29030 (0.39) 2021 WC Clearing 0.09% 72000.5199.29200 4.39 2021 WC Clearing 0.22% 90100.5199.29200 10.76 2021 WC Clearing 0.55% 4760600.5199.29200 27.55 2021 WC Clearing 0.08% 4761000.5199.29200 4.19 2021 WC Clearing 0.19% 4762000.5199.29200 9.50 2021 WC Clearing 0.01% 4767300.5199.29030 0.27 2021 WC Clearing ‐0.01% 4767400.5199.29030 (0.72) 2021 WC Clearing 12.65% \480991.0199 631.77 2021 WC Clearing 0.00% \470991.0199 ‐ 2021 WC Clearing 0.29%\99991.0199 14.49 2021 WC Clearing 48524.5199.4171 00281670 W 1.62 2021 WC Clearing 48524.5199.4171 00282598 W 1.16 2021 WC Clearing 48524.5199.4171 00282600 W 2.57 2021 WC Clearing 48524.5199.4171 00282604 W ‐ 2021 WC Clearing 48524.5199.4171 00285906 W ‐ 2021 WC Clearing 48524.5199.4171 00290018 W ‐ 2021 WC Clearing 0.00 Purpose: To true‐up expenses that hit BU 48597, based on a labor distribution of actual hours in 2021. Source: Data provided by Spreadsheet Server pull. *Pulled via SS Company Business Unit Object Subsidiary Account Subledger Description Amount 00048 48597 5192 29200 48597.5192.29200 Admin. & General Sala 118.21 Other benefits 00048 48597 5199 29200 48597.5199.29200 Admin. & General Sala 595.72 WC 00048 48597 5193 29200 48597.5193.29200 Admin. & General Sala 707.36 vacation 00048 48597 5198 29200 48597.5198.29200 Admin. & General Sala 837.62 PR 00048 48597 5197 29200 48597.5197.29200 Admin. & General Sala 2,385.14 401k 00048 48597 5131 29200 48597.5131.29200 Admin. & General Salar 2,845.41 incentive comp 00048 48597 5191 29200 48597.5191.29200 Admin. & General Sala 5,418.64 payroll 00048 48597 5194 29200 48597.5194.29200 Admin. & General Sala 11,839.12 Med 00048 48597 5110 29200 48597.5110.29200 Admin. & General Salar 18,046.06 Straight time 42,793.28 From:Gyllenskog, Nicole To:Dedden, Ted; Ogami, Niki Subject:FW: GTL imputed amounts Date:Monday, June 21, 2021 9:15:44 AM Hi, Talked to Mel, we should probably clear this account when we make our year-end 1840 clearings. I’ll put something on my calendar to try and help remember too. Nicole From: Morrison, Melody <Melody.Morrison@mdu.com> Sent: Monday, June 21, 2021 8:58 AM To: Gyllenskog, Nicole <Nicole.Gyllenskog@intgas.com>; Dedden, Ted <Ted.Dedden@intgas.com>; Ryan, Christopher <Christopher.Ryan@cngc.com>; Conwell, Kevin <Kevin.Conwell@cngc.com>; Keller, Melissa <Melissa.Keller@mdu.com>; Fergel, Steven <Steven.Fergel@mdu.com> Cc: Hauff, Jeremy <Jeremy.Hauff@mdu.com>; Anderson, Jessica <jessica.anderson@mdu.com>; Nygard, Tammy <Tammy.Nygard@mdu.com>; Bakke, Mike <Mike.Bakke@mdu.com>; Fix, Jeffrey <Jeffrey.Fix@mdu.com> Subject: FW: GTL imputed amounts I have been working with Payroll to resolve some items/issues that we have seen since going live with UKG. Some of these issues are around the home business unit that is setup on each employee’s Home business unit account. If that same account is a part of the employee’s SLD it will create some issues with items like Life Insurance imputed income (formerly taxable premium) for the SLD charges for the loading benefits on the journal entries that payroll has to fix for every payroll run. The decision would be to move all employee’s in each company to have the same Home business unit that is not a part of anyone’s SLD. We will be using the following accounts for each company. I have adjusted the naming of the accounts for CNGC and IGC to be XXX Payroll Adjustment MDU 99700.5XXX.29200 CNGC 4769700.5XXX.29200 IGC 48597.5XXX.29200 At year end we can review the costs in these accounts to make an allocation split similar to all the other payroll loading adjustment we do at year end to split these charges between O&M and capital. RNG Portion 0.11% 48524.5194.4171 42,226.97 2021 Medical Clearing 45.22 48524.5191.4171 5,418.64 2021 Payroll Tax Clearing 5.80 48524.5110.4171 18,046.06 2021 Straight Time Clearing 19.33 48524.5199.4171 4,993.84 2021 WC Clearing 5.35 Row Labels Sum of Units 56 00281670 122.1 30.25%48524.5194.4171 00281670 W 13.68 2021 Medical Clearing 00282598 87.5 21.68%48524.5194.4171 00282598 W 9.80 2021 Medical Clearing 00282600 186 46.09%48524.5194.4171 00282600 W 20.84 2021 Medical Clearing 00282604 0 0.00%48524.5194.4171 00282604 W ‐ 2021 Medical Clearing 00285906 0 0.00%48524.5194.4171 00285906 W ‐ 2021 Medical Clearing 00290018 8 1.98%48524.5194.4171 00290018 W 0.90 2021 Medical Clearing Grand Total 459.6 403.6 ‐ 48524.5191.4171 00281670 W 1.76 2021 Payroll Tax Clearing 48524.5191.4171 00282598 W 1.26 2021 Payroll Tax Clearing 48524.5191.4171 00282600 W 2.67 2021 Payroll Tax Clearing 48524.5191.4171 00282604 W ‐ 2021 Payroll Tax Clearing 48524.5191.4171 00285906 W ‐ 2021 Payroll Tax Clearing 48524.5191.4171 00290018 W 0.11 2021 Payroll Tax Clearing ‐ 48524.5110.4171 00281670 W 5.85 2021 Straight Time Clearing 48524.5110.4171 00282598 W 4.19 2021 Straight Time Clearing 48524.5110.4171 00282600 W 8.91 2021 Straight Time Clearing 48524.5110.4171 00282604 W ‐ 2021 Straight Time Clearing 48524.5110.4171 00285906 W ‐ 2021 Straight Time Clearing 48524.5110.4171 00290018 W 0.38 2021 Straight Time Clearing ‐ 48524.5199.4171 00281670 W 1.62 2021 WC Clearing 48524.5199.4171 00282598 W 1.16 2021 WC Clearing 48524.5199.4171 00282600 W 2.46 2021 WC Clearing 48524.5199.4171 00282604 W ‐ 2021 WC Clearing 48524.5199.4171 00285906 W ‐ 2021 WC Clearing 48524.5199.4171 00290018 W 0.11 2021 WC Clearing ‐