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 Payroll Clearing.pdf
Batch Review - Journal Entry Personal Form:(No Personalization)Query:All Records Row Form Tools Batch Number 193558 Model Percent Reverse Doc Type/No/Co JE 24280 00048 G/L Date 12/31/2021 Explanation JE 73 Payroll Clearin Ledger Type A Records 1 - 100 * Defa Account Number Amount Account Description Subledger Type Subledger Subledger Description Remark 48597.5191.29200 5,418.64-dmin. & General Sal 2021 Payro 48501.5191.29200 24.07 Admin. & General Sala 2021 Payrol 48502.5191.29100 22.17 Misc. Customer Service Exp.2021 Payrol 48504.5191.29200 58.08 Admin. & General Sala 2021 Payrol 48506.5191.28130 46.67 Other Gas Supply Exp.2021 Payrol 48508.5191.28750 38.25 Meas. & Reg. Stations-Gen.2021 Payrol 48508.5191.28760 32.14 Meas. & Reg. Stations-Ind.2021 Payrol 48508.5191.28780 1.06 Meter & House Reg. Exp.2021 Payrol 48508.5191.28790 1.34 Customer Installation 2021 Payrol 48508.5191.28890 49.55 Mtc of Meas & Reg Eq.2021 Payrol 48508.5191.28900 12.72 Mtc. of Meas. & Reg. Eq.-Ind 2021 Payrol 48508.5191.28930 4.12 Maint of Meters & Hou 2021 Payrol 48508.5191.29020 .11 Meter Reading Expense 2021 Payrol 48508.5191.29030 .11 Customer Records & Co 2021 Payrol 48509.5191.28700 14.00 Operation Supervision 2021 Payrol 48509.5191.29200 5.05 Admin. & General Sala 2021 Payrol 48513.5191.28410 52.64 Operation Labor & Exp 2021 Payrol 48514.5191.29200 140.00 Admin. & General Sala 2021 Payrol Page 1 of 2Batch Review - Journal Entry 1 5 202https://mdupd92.c03g.velocity.cloud/jde/E1Client.mafService?jdemafjascacheUID=2629&jdemafjasLauncher=PSFT_TE_V3_... Purpose: To true‐up expenses that hit BU 48597, based on a labor distribution of actual hours in 2021. Source: Data provided by Reports Now pulled by Nicole Gyllenskog. *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 48597.5191.29200 (5,418.64) 2021 Payroll Tax Clearing 48597.5110.29200 (18,046.06) 2021 Straight Time Clearing 0.44% 48501.5191.29200 24.07 2021 Payroll Tax Clearing 48501.5110.29200 80.17 2021 Straight Time Clearing 0.41% 48502.5191.29100 22.17 2021 Payroll Tax Clearing 48502.5110.29100 73.82 2021 Straight Time Clearing 1.07% 48504.5191.29200 58.08 2021 Payroll Tax Clearing 48504.5110.29200 193.43 2021 Straight Time Clearing 0.86% 48506.5191.28130 46.67 2021 Payroll Tax Clearing 48506.5110.28130 155.41 2021 Straight Time Clearing 0.71% 48508.5191.28750 38.25 2021 Payroll Tax Clearing 48508.5110.28750 127.39 2021 Straight Time Clearing 0.59% 48508.5191.28760 32.14 2021 Payroll Tax Clearing 48508.5110.28760 107.05 2021 Straight Time Clearing 0.02% 48508.5191.28780 1.06 2021 Payroll Tax Clearing 48508.5110.28780 3.54 2021 Straight Time Clearing 0.02% 48508.5191.28790 1.34 2021 Payroll Tax Clearing 48508.5110.28790 4.45 2021 Straight Time Clearing 0.91% 48508.5191.28890 49.55 2021 Payroll Tax Clearing 48508.5110.28890 165.01 2021 Straight Time Clearing 0.23% 48508.5191.28900 12.72 2021 Payroll Tax Clearing 48508.5110.28900 42.37 2021 Straight Time Clearing 0.08% 48508.5191.28930 4.12 2021 Payroll Tax Clearing 48508.5110.28930 13.73 2021 Straight Time Clearing 0.00% 48508.5191.29020 0.11 2021 Payroll Tax Clearing 48508.5110.29020 0.35 2021 Straight Time Clearing 0.00% 48508.5191.29030 0.11 2021 Payroll Tax Clearing 48508.5110.29030 0.35 2021 Straight Time Clearing 0.26% 48509.5191.28700 14.00 2021 Payroll Tax Clearing 48509.5110.28700 46.62 2021 Straight Time Clearing 0.09% 48509.5191.29200 5.05 2021 Payroll Tax Clearing 48509.5110.29200 16.82 2021 Straight Time Clearing 0.97% 48513.5191.28410 52.64 2021 Payroll Tax Clearing 48513.5110.28410 175.32 2021 Straight Time Clearing 2.58% 48514.5191.29200 140.00 2021 Payroll Tax Clearing 48514.5110.29200 466.24 2021 Straight Time Clearing 0.43% 48518.5191.29010 23.33 2021 Payroll Tax Clearing 48518.5110.29010 77.71 2021 Straight Time Clearing 2.58% 48518.5191.29030 140.00 2021 Payroll Tax Clearing 48518.5110.29030 466.24 2021 Straight Time Clearing 3.35% 48520.5191.29120 181.60 2021 Payroll Tax Clearing 48520.5110.29120 604.79 2021 Straight Time Clearing 1.16% 48521.5191.29200 62.84 2021 Payroll Tax Clearing 48521.5110.29200 209.26 2021 Straight Time Clearing 2.44% 48526.5191.29200 132.38 2021 Payroll Tax Clearing 48526.5110.29200 440.88 2021 Straight Time Clearing 0.26% 48533.5191.28700 14.19 2021 Payroll Tax Clearing 48533.5110.28700 47.26 2021 Straight Time Clearing 0.04% 48534.5191.28740 2.02 2021 Payroll Tax Clearing 48534.5110.28740 6.71 2021 Straight Time Clearing 0.05% 48534.5191.28750 2.73 2021 Payroll Tax Clearing 48534.5110.28750 9.08 2021 Straight Time Clearing 1.08% 48534.5191.28780 58.32 2021 Payroll Tax Clearing 48534.5110.28780 194.24 2021 Straight Time Clearing 3.49% 48534.5191.28790 189.27 2021 Payroll Tax Clearing 48534.5110.28790 630.33 2021 Straight Time Clearing 0.28% 48534.5191.28870 14.95 2021 Payroll Tax Clearing 48534.5110.28870 49.80 2021 Straight Time Clearing 0.11% 48534.5191.28871 5.93 2021 Payroll Tax Clearing 48534.5110.28871 19.74 2021 Straight Time Clearing 0.98% 48534.5191.28920 53.28 2021 Payroll Tax Clearing 48534.5110.28920 177.43 2021 Straight Time Clearing 1.06% 48534.5191.28930 57.47 2021 Payroll Tax Clearing 48534.5110.28930 191.38 2021 Straight Time Clearing 1.67% 48534.5191.29020 90.58 2021 Payroll Tax Clearing 48534.5110.29020 301.65 2021 Straight Time Clearing 0.45% 48534.5191.29030 24.45 2021 Payroll Tax Clearing 48534.5110.29030 81.42 2021 Straight Time Clearing 0.00% 48535.5191.28750 0.13 2021 Payroll Tax Clearing 48535.5110.28750 0.42 2021 Straight Time Clearing 0.01% 48535.5191.28790 0.45 2021 Payroll Tax Clearing 48535.5110.28790 1.51 2021 Straight Time Clearing 1.12% 48535.5191.28800 60.89 2021 Payroll Tax Clearing 48535.5110.28800 202.79 2021 Straight Time Clearing 1.30% 48535.5191.28920 70.59 2021 Payroll Tax Clearing 48535.5110.28920 235.09 2021 Straight Time Clearing 0.54% 48535.5191.29020 29.01 2021 Payroll Tax Clearing 48535.5110.29020 96.60 2021 Straight Time Clearing 0.00% 48536.5191.28630 0.20 2021 Payroll Tax Clearing 48536.5110.28630 0.67 2021 Straight Time Clearing 1.31% 48536.5191.28700 71.25 2021 Payroll Tax Clearing 48536.5110.28700 237.28 2021 Straight Time Clearing 0.86% 48536.5191.28740 46.67 2021 Payroll Tax Clearing 48536.5110.28740 155.42 2021 Straight Time Clearing 0.15% 48536.5191.28760 8.08 2021 Payroll Tax Clearing 48536.5110.28760 26.92 2021 Straight Time Clearing 0.01% 48536.5191.28780 0.81 2021 Payroll Tax Clearing 48536.5110.28780 2.71 2021 Straight Time Clearing 1.24% 48536.5191.28800 66.96 2021 Payroll Tax Clearing 48536.5110.28800 223.01 2021 Straight Time Clearing 0.57% 48536.5191.28870 30.67 2021 Payroll Tax Clearing 48536.5110.28870 102.15 2021 Straight Time Clearing 0.00% 48536.5191.28890 ‐ 2021 Payroll Tax Clearing 48536.5110.28890 ‐ 2021 Straight Time Clearing 3.31% 48536.5191.28920 179.47 2021 Payroll Tax Clearing 48536.5110.28920 597.70 2021 Straight Time Clearing 0.06% 48536.5191.29030 3.27 2021 Payroll Tax Clearing 48536.5110.29030 10.88 2021 Straight Time Clearing 0.00% 48536.5191.29250 0.03 2021 Payroll Tax Clearing 48536.5110.29250 0.08 2021 Straight Time Clearing 0.36% 48538.5191.28700 19.37 2021 Payroll Tax Clearing 48538.5110.28700 64.50 2021 Straight Time Clearing 0.63% 48538.5191.28740 34.37 2021 Payroll Tax Clearing 48538.5110.28740 114.47 2021 Straight Time Clearing 0.19% 48538.5191.28750 10.14 2021 Payroll Tax Clearing 48538.5110.28750 33.78 2021 Straight Time Clearing 1.83% 48538.5191.28790 99.32 2021 Payroll Tax Clearing 48538.5110.28790 330.76 2021 Straight Time Clearing 0.20% 48538.5191.28800 10.94 2021 Payroll Tax Clearing 48538.5110.28800 36.43 2021 Straight Time Clearing 0.16% 48538.5191.28870 8.53 2021 Payroll Tax Clearing 48538.5110.28870 28.40 2021 Straight Time Clearing 0.24% 48538.5191.28871 13.10 2021 Payroll Tax Clearing 48538.5110.28871 43.62 2021 Straight Time Clearing 0.39% 48538.5191.28920 21.12 2021 Payroll Tax Clearing 48538.5110.28920 70.35 2021 Straight Time Clearing 0.56% 48538.5191.28930 30.49 2021 Payroll Tax Clearing 48538.5110.28930 101.54 2021 Straight Time Clearing 0.71% 48538.5191.29020 38.65 2021 Payroll Tax Clearing 48538.5110.29020 128.73 2021 Straight Time Clearing 0.66% 48538.5191.29030 35.83 2021 Payroll Tax Clearing 48538.5110.29030 119.33 2021 Straight Time Clearing 0.04% 48538.5191.29250 2.15 2021 Payroll Tax Clearing 48538.5110.29250 7.17 2021 Straight Time Clearing 0.55% 48539.5191.28700 29.93 2021 Payroll Tax Clearing 48539.5110.28700 99.69 2021 Straight Time Clearing 0.89% 48539.5191.28740 48.14 2021 Payroll Tax Clearing 48539.5110.28740 160.32 2021 Straight Time Clearing 0.03% 48539.5191.28750 1.82 2021 Payroll Tax Clearing 48539.5110.28750 6.05 2021 Straight Time Clearing 0.08% 48539.5191.28760 4.39 2021 Payroll Tax Clearing 48539.5110.28760 14.61 2021 Straight Time Clearing 0.00% 48539.5191.28780 0.24 2021 Payroll Tax Clearing 48539.5110.28780 0.81 2021 Straight Time Clearing 0.06% 48539.5191.28800 2.98 2021 Payroll Tax Clearing 48539.5110.28800 9.94 2021 Straight Time Clearing 0.77% 48539.5191.28870 41.80 2021 Payroll Tax Clearing 48539.5110.28870 139.20 2021 Straight Time Clearing 0.01% 48539.5191.28871 0.68 2021 Payroll Tax Clearing 48539.5110.28871 2.27 2021 Straight Time Clearing 0.01% 48539.5191.28890 0.45 2021 Payroll Tax Clearing 48539.5110.28890 1.49 2021 Straight Time Clearing 0.00% 48539.5191.28900 0.24 2021 Payroll Tax Clearing 48539.5110.28900 0.81 2021 Straight Time Clearing 1.32% 48539.5191.28920 71.27 2021 Payroll Tax Clearing 48539.5110.28920 237.35 2021 Straight Time Clearing 0.39% 48541.5191.28700 21.11 2021 Payroll Tax Clearing 48541.5110.28700 70.31 2021 Straight Time Clearing 0.46% 48542.5191.28700 24.67 2021 Payroll Tax Clearing 48542.5110.28700 82.16 2021 Straight Time Clearing 0.66% 48542.5191.28740 35.91 2021 Payroll Tax Clearing 48542.5110.28740 119.60 2021 Straight Time Clearing 0.00% 48542.5191.28750 0.15 2021 Payroll Tax Clearing 48542.5110.28750 0.50 2021 Straight Time Clearing 0.22% 48542.5191.28780 12.02 2021 Payroll Tax Clearing 48542.5110.28780 40.04 2021 Straight Time Clearing 3.29% 48542.5191.28790 178.12 2021 Payroll Tax Clearing 48542.5110.28790 593.19 2021 Straight Time Clearing 1.25% 48542.5191.28800 67.56 2021 Payroll Tax Clearing 48542.5110.28800 225.01 2021 Straight Time Clearing Straight Time Clearing‐ 5110Payroll Tax Clearing‐ 5191 0.13% 48542.5191.28920 7.00 2021 Payroll Tax Clearing 48542.5110.28920 23.31 2021 Straight Time Clearing 0.12% 48542.5191.28930 6.23 2021 Payroll Tax Clearing 48542.5110.28930 20.76 2021 Straight Time Clearing 0.18% 48542.5191.29020 9.97 2021 Payroll Tax Clearing 48542.5110.29020 33.20 2021 Straight Time Clearing 0.00% 48542.5191.29030 (0.12) 2021 Payroll Tax Clearing 48542.5110.29030 (0.42) 2021 Straight Time Clearing 0.00% 48542.5191.29250 0.02 2021 Payroll Tax Clearing 48542.5110.29250 0.06 2021 Straight Time Clearing 0.58% 48543.5191.28700 31.60 2021 Payroll Tax Clearing 48543.5110.28700 105.23 2021 Straight Time Clearing 0.53% 48543.5191.28740 28.81 2021 Payroll Tax Clearing 48543.5110.28740 95.96 2021 Straight Time Clearing 0.02% 48543.5191.28760 0.90 2021 Payroll Tax Clearing 48543.5110.28760 2.99 2021 Straight Time Clearing 0.01% 48543.5191.28780 0.47 2021 Payroll Tax Clearing 48543.5110.28780 1.57 2021 Straight Time Clearing 0.01% 48543.5191.28790 0.49 2021 Payroll Tax Clearing 48543.5110.28790 1.62 2021 Straight Time Clearing 0.37% 48543.5191.28870 20.16 2021 Payroll Tax Clearing 48543.5110.28870 67.14 2021 Straight Time Clearing 0.01% 48543.5191.28890 0.30 2021 Payroll Tax Clearing 48543.5110.28890 1.00 2021 Straight Time Clearing 1.35% 48543.5191.28920 73.22 2021 Payroll Tax Clearing 48543.5110.28920 243.85 2021 Straight Time Clearing 0.00% 48543.5191.28930 0.01 2021 Payroll Tax Clearing 48543.5110.28930 0.03 2021 Straight Time Clearing 0.02% 48546.5191.28436 1.19 2021 Payroll Tax Clearing 48546.5110.28436 3.97 2021 Straight Time Clearing 0.40% 48546.5191.28700 21.93 2021 Payroll Tax Clearing 48546.5110.28700 73.04 2021 Straight Time Clearing 0.92% 48546.5191.28740 49.72 2021 Payroll Tax Clearing 48546.5110.28740 165.60 2021 Straight Time Clearing 0.01% 48546.5191.28760 0.37 2021 Payroll Tax Clearing 48546.5110.28760 1.24 2021 Straight Time Clearing 2.86% 48546.5191.28780 155.16 2021 Payroll Tax Clearing 48546.5110.28780 516.73 2021 Straight Time Clearing 0.26% 48546.5191.28790 14.07 2021 Payroll Tax Clearing 48546.5110.28790 46.87 2021 Straight Time Clearing 0.11% 48546.5191.28800 5.73 2021 Payroll Tax Clearing 48546.5110.28800 19.07 2021 Straight Time Clearing 0.05% 48546.5191.28870 2.96 2021 Payroll Tax Clearing 48546.5110.28870 9.86 2021 Straight Time Clearing 0.22% 48546.5191.28920 11.96 2021 Payroll Tax Clearing 48546.5110.28920 39.82 2021 Straight Time Clearing 0.23% 48546.5191.29020 12.40 2021 Payroll Tax Clearing 48546.5110.29020 41.30 2021 Straight Time Clearing 1.30% 48546.5191.29030 70.37 2021 Payroll Tax Clearing 48546.5110.29030 234.36 2021 Straight Time Clearing 0.02% 48547.5191.28630 1.13 2021 Payroll Tax Clearing 48547.5110.28630 3.76 2021 Straight Time Clearing 1.05% 48547.5191.28700 56.79 2021 Payroll Tax Clearing 48547.5110.28700 189.13 2021 Straight Time Clearing 0.78% 48547.5191.28740 42.23 2021 Payroll Tax Clearing 48547.5110.28740 140.64 2021 Straight Time Clearing 0.02% 48547.5191.28760 1.29 2021 Payroll Tax Clearing 48547.5110.28760 4.29 2021 Straight Time Clearing 0.03% 48547.5191.28800 1.63 2021 Payroll Tax Clearing 48547.5110.28800 5.44 2021 Straight Time Clearing 0.52% 48547.5191.28870 27.96 2021 Payroll Tax Clearing 48547.5110.28870 93.12 2021 Straight Time Clearing 0.03% 48547.5191.28890 1.83 2021 Payroll Tax Clearing 48547.5110.28890 6.11 2021 Straight Time Clearing 1.09% 48547.5191.28920 59.15 2021 Payroll Tax Clearing 48547.5110.28920 196.98 2021 Straight Time Clearing 0.16% 48549.5191.28436 8.73 2021 Payroll Tax Clearing 48549.5110.28436 29.07 2021 Straight Time Clearing 0.05% 48550.5191.28530 2.92 2021 Payroll Tax Clearing 48550.5110.28530 9.71 2021 Straight Time Clearing 0.51% 48550.5191.28700 27.73 2021 Payroll Tax Clearing 48550.5110.28700 92.36 2021 Straight Time Clearing 0.14% 48550.5191.28740 7.75 2021 Payroll Tax Clearing 48550.5110.28740 25.82 2021 Straight Time Clearing 0.06% 48550.5191.28760 3.06 2021 Payroll Tax Clearing 48550.5110.28760 10.18 2021 Straight Time Clearing 0.00% 48550.5191.28800 0.03 2021 Payroll Tax Clearing 48550.5110.28800 0.08 2021 Straight Time Clearing 1.57% 48550.5191.28870 85.07 2021 Payroll Tax Clearing 48550.5110.28870 283.33 2021 Straight Time Clearing 0.00% 48550.5191.28890 0.13 2021 Payroll Tax Clearing 48550.5110.28890 0.44 2021 Straight Time Clearing 1.18% 48550.5191.28920 63.82 2021 Payroll Tax Clearing 48550.5110.28920 212.55 2021 Straight Time Clearing 0.02% 48550.5191.29250 1.24 2021 Payroll Tax Clearing 48550.5110.29250 4.13 2021 Straight Time Clearing 0.40% 48552.5191.28700 21.70 2021 Payroll Tax Clearing 48552.5110.28700 72.27 2021 Straight Time Clearing 0.98% 48552.5191.28740 53.25 2021 Payroll Tax Clearing 48552.5110.28740 177.34 2021 Straight Time Clearing 0.00% 48552.5191.28750 0.02 2021 Payroll Tax Clearing 48552.5110.28750 0.05 2021 Straight Time Clearing 2.70% 48552.5191.28780 146.14 2021 Payroll Tax Clearing 48552.5110.28780 486.69 2021 Straight Time Clearing 0.33% 48552.5191.28790 17.66 2021 Payroll Tax Clearing 48552.5110.28790 58.81 2021 Straight Time Clearing 0.03% 48552.5191.28800 1.63 2021 Payroll Tax Clearing 48552.5110.28800 5.44 2021 Straight Time Clearing 0.01% 48552.5191.28870 0.67 2021 Payroll Tax Clearing 48552.5110.28870 2.22 2021 Straight Time Clearing 0.01% 48552.5191.28871 0.80 2021 Payroll Tax Clearing 48552.5110.28871 2.65 2021 Straight Time Clearing 0.02% 48552.5191.28920 1.10 2021 Payroll Tax Clearing 48552.5110.28920 3.65 2021 Straight Time Clearing 0.13% 48552.5191.29020 6.91 2021 Payroll Tax Clearing 48552.5110.29020 23.01 2021 Straight Time Clearing 0.85% 48552.5191.29030 45.88 2021 Payroll Tax Clearing 48552.5110.29030 152.79 2021 Straight Time Clearing 0.00% 48552.5191.29250 0.10 2021 Payroll Tax Clearing 48552.5110.29250 0.34 2021 Straight Time Clearing 0.43% 48553.5191.28700 23.33 2021 Payroll Tax Clearing 48553.5110.28700 77.71 2021 Straight Time Clearing 0.13% 48553.5191.28740 7.28 2021 Payroll Tax Clearing 48553.5110.28740 24.26 2021 Straight Time Clearing 0.00% 48553.5191.28750 0.18 2021 Payroll Tax Clearing 48553.5110.28750 0.59 2021 Straight Time Clearing 0.61% 48553.5191.28780 32.80 2021 Payroll Tax Clearing 48553.5110.28780 109.24 2021 Straight Time Clearing 0.99% 48553.5191.28790 53.62 2021 Payroll Tax Clearing 48553.5110.28790 178.58 2021 Straight Time Clearing 0.00% 48553.5191.28920 0.08 2021 Payroll Tax Clearing 48553.5110.28920 0.25 2021 Straight Time Clearing 0.00% 48553.5191.29020 (0.05) 2021 Payroll Tax Clearing 48553.5110.29020 (0.15) 2021 Straight Time Clearing 0.43% 48553.5191.29030 23.48 2021 Payroll Tax Clearing 48553.5110.29030 78.20 2021 Straight Time Clearing 0.01% 48554.5191.28631 0.39 2021 Payroll Tax Clearing 48554.5110.28631 1.30 2021 Straight Time Clearing 1.66% 48554.5191.28740 90.16 2021 Payroll Tax Clearing 48554.5110.28740 300.26 2021 Straight Time Clearing 0.56% 48554.5191.28870 30.41 2021 Payroll Tax Clearing 48554.5110.28870 101.28 2021 Straight Time Clearing 0.51% 48558.5191.28800 27.47 2021 Payroll Tax Clearing 48558.5110.28800 91.50 2021 Straight Time Clearing 0.43% 48559.5191.28660 23.42 2021 Payroll Tax Clearing 48559.5110.28660 78.00 2021 Straight Time Clearing 1.51% 48559.5191.28930 81.89 2021 Payroll Tax Clearing 48559.5110.28930 272.72 2021 Straight Time Clearing 0.05% 48563.5191.28700 2.86 2021 Payroll Tax Clearing 48563.5110.28700 9.53 2021 Straight Time Clearing 0.03% 48563.5191.28740 1.57 2021 Payroll Tax Clearing 48563.5110.28740 5.24 2021 Straight Time Clearing 0.01% 48563.5191.28760 0.33 2021 Payroll Tax Clearing 48563.5110.28760 1.10 2021 Straight Time Clearing 0.03% 48563.5191.28850 1.49 2021 Payroll Tax Clearing 48563.5110.28850 4.95 2021 Straight Time Clearing 0.02% 48569.5191.28530 0.93 2021 Payroll Tax Clearing 48569.5110.28530 3.11 2021 Straight Time Clearing 0.08% 48569.5191.28700 4.22 2021 Payroll Tax Clearing 48569.5110.28700 14.04 2021 Straight Time Clearing 0.01% 48573.5191.29030 0.39 2021 Payroll Tax Clearing 48573.5110.29030 1.31 2021 Straight Time Clearing ‐0.01% 48574.5191.29030 (0.35) 2021 Payroll Tax Clearing 48574.5110.29030 (1.16) 2021 Straight Time Clearing 0.44% 48582.5191.29200 24.09 2021 Payroll Tax Clearing 48582.5110.29200 80.24 2021 Straight Time Clearing 0.00% 48597.5191.29200 ‐ 2021 Payroll Tax Clearing 48597.5110.29200 ‐ 2021 Straight Time Clearing 0.34% 48598.5191.29200 18.57 2021 Payroll Tax Clearing 48598.5110.29200 61.86 2021 Straight Time Clearing 0.00% 71300.5191.19030 0.10 2021 Payroll Tax Clearing 71300.5110.19030 0.35 2021 Straight Time Clearing 0.00% 71300.5191.29030 0.22 2021 Payroll Tax Clearing 71300.5110.29030 0.73 2021 Straight Time Clearing 0.00% 71400.5191.19030 (0.20) 2021 Payroll Tax Clearing 71400.5110.19030 (0.67) 2021 Straight Time Clearing ‐0.01% 71400.5191.29030 (0.42) 2021 Payroll Tax Clearing 71400.5110.29030 (1.41) 2021 Straight Time Clearing 0.09% 72000.5191.29200 4.76 2021 Payroll Tax Clearing 72000.5110.29200 15.86 2021 Straight Time Clearing 0.22% 90100.5191.29200 11.68 2021 Payroll Tax Clearing 90100.5110.29200 38.90 2021 Straight Time Clearing 0.55% 4760600.5191.29200 29.89 2021 Payroll Tax Clearing 4760600.5110.29200 99.54 2021 Straight Time Clearing 0.08% 4761000.5191.29200 4.55 2021 Payroll Tax Clearing 4761000.5110.29200 15.14 2021 Straight Time Clearing 0.19% 4762000.5191.29200 10.31 2021 Payroll Tax Clearing 4762000.5110.29200 34.35 2021 Straight Time Clearing 0.01% 4767300.5191.29030 0.29 2021 Payroll Tax Clearing 4767300.5110.29030 0.98 2021 Straight Time Clearing ‐0.01% 4767400.5191.29030 (0.78) 2021 Payroll Tax Clearing 4767400.5110.29030 (2.59) 2021 Straight Time Clearing 12.65% \480991.0191 685.49 2021 Payroll Tax Clearing \480991.0191 2,283.00 2021 Straight Time Clearing 0.00% \470991.0191 ‐ 2021 Payroll Tax Clearing \470991.0191 ‐ 2021 Straight Time Clearing 0.29% \99991.0191 15.73 2021 Payroll Tax Clearing \99991.0191 52.38 2021 Straight Time Clearing 48524.5191.4171 00281670 W 1.76 2021 Payroll Tax Clearing 48524.5110.4171 00281670 W 5.85 2021 Straight Time Clearing 48524.5191.4171 00282598 W 1.26 2021 Payroll Tax Clearing 48524.5110.4171 00282598 W 4.19 2021 Straight Time Clearing 48524.5191.4171 00282600 W 2.67 2021 Payroll Tax Clearing 48524.5110.4171 00282600 W 8.91 2021 Straight Time Clearing 48524.5191.4171 00282604 W ‐ 2021 Payroll Tax Clearing 48524.5110.4171 00282604 W ‐ 2021 Straight Time Clearing 48524.5191.4171 00285906 W ‐ 2021 Payroll Tax Clearing 48524.5110.4171 00285906 W ‐ 2021 Straight Time Clearing 48524.5191.4171 00290018 W 0.11 2021 Payroll Tax Clearing 48524.5110.4171 00290018 W 0.38 2021 Straight Time Clearing 0.00 0.00 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 ‐