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_1220 JE 73 Workers Comp Clearing.pdf
Batch Review - Journal Entry Personal Form:(No Personalization)Query:All Records Row Form Tools Batch Number 183045 Model Percent Reverse Doc Type/No/Co JE 22703 00048 G/L Date 12/31/2020 Explanation JE 73 Workers Comp Clearin Ledger Type A Records 1 - 100 * Defa Account Number Amount Account Description Subledger Type Subledger Subledger Description Remark 48.1840.5001 947.68-ac Payout Burden-W 2020 WC C 48.1840.ID 28,481.41- Idaho Workers Comp 2020 WC Cl 48501.5199.29200 118.42 Admin. & General Sala 2020 WC Cl 48502.5199.29100 112.16 Misc. Customer Service Exp.2020 WC Cl 48504.5199.29200 383.70 Admin. & General Sala 2020 WC Cl 48506.5199.28130 236.12 Other Gas Supply Exp.2020 WC Cl 48508.5199.28660 38.72 Maint of Communication 2020 WC Cl 48508.5199.28700 3.85 Operation Supervision 2020 WC Cl 48508.5199.28750 164.97 Meas. & Reg. Stations-Gen.2020 WC Cl 48508.5199.28760 112.33 Meas. & Reg. Stations-Ind.2020 WC Cl 48508.5199.28780 9.67 Meter & House Reg. Exp.2020 WC Cl 48508.5199.28850 7.43 Maint. Supervision & Eng.2020 WC Cl 48508.5199.28890 257.50 Mtc. of Meas. & Reg. Eq.-Gen 2020 WC Cl 48508.5199.28900 54.38 Mtc. of Meas. & Reg. Eq.-Ind 2020 WC Cl 48508.5199.28930 127.57 Maint. of Meters & House Reg 2020 WC Cl 48509.5199.28700 70.84 Operation Supervision 2020 WC Cl 48513.5199.28410 523.17 Operation Labor & Exp 2020 WC Cl 48514.5199.29200 708.37 Admin. & General Sala 2020 WC Cl Page 1 of 2Batch Review - Journal Entry 1 7 2021https://erpprod.mdu.com/jde/E1Client.mafService?jdemafjascacheUID=5003&jdemafjasLauncher=PSFT_TE_V3_SW&jdemafj ... Trial Balance By Object - Trial Balance by Object Personal Form:(No Personalization) Row Tools Object/Subsidiary 1840 Select / Skip To Thru Date 12/31/2020 Period / Date Company 00048 Intermountain Gas Type/Subledger * Ledger Type 1 General Ledger Ledger Type 2 General Ledger Records 1 - 17 * Default Account Number Account Description Level Of Detail General Ledger Period Balance General Ledger Balance Posting Edit Code 48.1840.1000 Medical 6 225,467.25 226,537.72 48.1840.1100 Dental 6 9,775.91 8,093.27 48.1840.1200 Vision 6 249.50 17.82 48.1840.2000 NCLI employer 6 489.56- 15,553.31- 48.1840.2020 NCLI 6 9,845.70 121,800.04 48.1840.2100 Contr Life Employer 6 5,220.22- 71,005.15- 48.1840.2200 AD & D employee 6 738.82- 9,679.96- 48.1840.2300 Spouse Life Employee 6 1,832.00- 24,282.14- 48.1840.2400 Dependent Life employee 6 53.48- 687.82- 48.1840.4020 EAP Employer paid 6 452.96- 5,055.83- 48.1840.4120 LTD Employer paid 6 1,990.26 350.89 48.1840.4920 Business Travel Employer 6 418.12 48.1840.5000 Vac Payout Burden-PR Tax 6 1,677.81 11,489.85 48.1840.5001 Vac Payout Burden-WC 6 224.96 947.68 48.1840.5002 Vac Payout Burden-401k 6 2,161.51 9,426.77 48.1840.ID Idaho Workers Comp 6 12,545.05- 28,481.41 Total Object Account 1840 230,060.81 281,299.36 Page 1 of 2Trial Balance By Object - Trial Balance by Object 1 7 2021https://erpprod.mdu.com/jde/RunApp.mafService?e1UserActInfo=true&e1.mode=view&e1.namespace=&RENDER_MAFLET=... Purpose: To true‐up worker's compensation, based on a labor distribution of actual hours in 2020. Source: Data provided by Craig Pulley, HR Manager Account Number Account Description Level Of Detail General Ledger Period Balance General Ledger Balance Posting Edit Code 48.1840.1000 Medical 6 225,467.25 226,537.72 48.1840.1100 Dental 6 9775.91 8,093.27 48.1840.1200 Vision 6 249.5 17.82 48.1840.2000 NCLI employer 6 ‐489.56 ‐15,553.31 48.1840.2020 NCLI 6 9,845.70 121,800.04 48.1840.2100 Contr Life Employer 6 ‐5,220.22 ‐71,005.15 48.1840.2200 AD & D employee 6 ‐738.82 ‐9,679.96 48.1840.2300 Spouse Life Employee 6 ‐1,832.00 ‐24,282.14 48.1840.2400 Dependent Life employee 6 ‐53.48 ‐687.82 48.1840.4020 EAP Employer paid 6 ‐452.96 ‐5,055.83 48.1840.4120 LTD Employer paid 6 1990.26 350.89 48.1840.4920 Business Travel Employer 6 418.12 89,577.29$ 48.1840.5000 Vac Payout Burden‐PR Tax 6 1677.81 11,489.85 48.1840.5001 Vac Payout Burden‐WC 6 224.96 947.68 48.1840.5002 Vac Payout Burden‐401k 6 2,161.51 9,426.77 48.1840.ID Idaho Workers Comp 6 (12,545.05) 28,481.41 29,429.09$ Total Object Account 1840 230,060.81 281,299.36 48.1840.5001 (947.68) 2020 WC Clearing 48.1840.ID (28,481.41) 2020 WC Clearing 0.40% 48501.5199.29200 118.42 2020 WC Clearing 0.38% 48502.5199.29100 112.16 2020 WC Clearing 1.30% 48504.5199.29200 383.70 2020 WC Clearing 0.80% 48506.5199.28130 236.12 2020 WC Clearing 0.13% 48508.5199.28660 38.72 2020 WC Clearing 0.01% 48508.5199.28700 3.85 2020 WC Clearing 0.56% 48508.5199.28750 164.97 2020 WC Clearing 0.38% 48508.5199.28760 112.33 2020 WC Clearing 0.03% 48508.5199.28780 9.67 2020 WC Clearing 0.03% 48508.5199.28850 7.43 2020 WC Clearing 0.87% 48508.5199.28890 257.50 2020 WC Clearing 0.18% 48508.5199.28900 54.38 2020 WC Clearing 0.43% 48508.5199.28930 127.57 2020 WC Clearing 0.24% 48509.5199.28700 70.84 2020 WC Clearing 1.78% 48513.5199.28410 523.17 2020 WC Clearing 2.41% 48514.5199.29200 708.37 2020 WC Clearing 0.40% 48518.5199.29010 117.95 2020 WC Clearing 2.35% 48518.5199.29030 692.05 2020 WC Clearing 2.72% 48520.5199.29120 801.84 2020 WC Clearing 1.25% 48521.5199.29200 368.49 2020 WC Clearing 0.00% 48521.5199.29260 ‐ 2020 WC Clearing 0.01% 48524.5199.4171 4.03 2020 WC Clearing 0.05% 48526.5199.29080 13.78 2020 WC Clearing 2.28% 48526.5199.29200 670.66 2020 WC Clearing 0.40% 48533.5199.28700 118.06 2020 WC Clearing 0.41% 48534.5199.28740 121.27 2020 WC Clearing 0.08% 48534.5199.28750 23.52 2020 WC Clearing 0.64% 48534.5199.28780 187.49 2020 WC Clearing 3.69% 48534.5199.28790 1,086.05 2020 WC Clearing 0.13% 48534.5199.28870 38.40 2020 WC Clearing 0.08% 48534.5199.28871 23.84 2020 WC Clearing 1.09% 48534.5199.28920 319.53 2020 WC Clearing 1.01% 48534.5199.28930 298.47 2020 WC Clearing 2.03% 48534.5199.29020 598.81 2020 WC Clearing 0.49% 48534.5199.29030 144.96 2020 WC Clearing 0.00% 48535.5199.28740 0.22 2020 WC Clearing 0.02% 48535.5199.28780 5.81 2020 WC Clearing 0.00% 48535.5199.28790 1.19 2020 WC Clearing 1.10% 48535.5199.28800 324.72 2020 WC Clearing 0.01% 48535.5199.28870 3.85 2020 WC Clearing 1.16% 48535.5199.28920 340.37 2020 WC Clearing 0.54% 48535.5199.29020 158.69 2020 WC Clearing 1.24% 48536.5199.28700 365.26 2020 WC Clearing 1.05% 48536.5199.28740 309.89 2020 WC Clearing 0.00% 48536.5199.28750 1.31 2020 WC Clearing 0.07% 48536.5199.28760 21.49 2020 WC Clearing 0.04% 48536.5199.28780 12.35 2020 WC Clearing 1.04% 48536.5199.28800 305.79 2020 WC Clearing 1.19% 48536.5199.28870 349.94 2020 WC Clearing 0.02% 48536.5199.28890 5.10 2020 WC Clearing 0.00% 48536.5199.28900 0.64 2020 WC Clearing Worker's Compensation‐ 5199 2.32% 48536.5199.28920 682.88 2020 WC Clearing 0.04% 48536.5199.29030 13.23 2020 WC Clearing 0.33% 48538.5199.28700 97.99 2020 WC Clearing 1.24% 48538.5199.28740 365.17 2020 WC Clearing 0.16% 48538.5199.28750 45.72 2020 WC Clearing 0.01% 48538.5199.28760 3.33 2020 WC Clearing 1.92% 48538.5199.28790 564.25 2020 WC Clearing 0.19% 48538.5199.28800 55.39 2020 WC Clearing 0.19% 48538.5199.28870 57.14 2020 WC Clearing 0.44% 48538.5199.28871 130.91 2020 WC Clearing 0.61% 48538.5199.28920 179.19 2020 WC Clearing 0.51% 48538.5199.28930 150.84 2020 WC Clearing 0.80% 48538.5199.29020 235.32 2020 WC Clearing 0.49% 48538.5199.29030 145.08 2020 WC Clearing 0.04% 48538.5199.29250 12.59 2020 WC Clearing 0.49% 48539.5199.28700 144.98 2020 WC Clearing 1.11% 48539.5199.28740 327.33 2020 WC Clearing 0.04% 48539.5199.28750 12.54 2020 WC Clearing 0.02% 48539.5199.28760 4.58 2020 WC Clearing 0.06% 48539.5199.28800 16.61 2020 WC Clearing 0.61% 48539.5199.28870 178.21 2020 WC Clearing 0.00% 48539.5199.28871 0.44 2020 WC Clearing 0.01% 48539.5199.28890 2.65 2020 WC Clearing 0.00% 48539.5199.28900 1.05 2020 WC Clearing 1.09% 48539.5199.28920 319.52 2020 WC Clearing 0.40% 48541.5199.28700 118.06 2020 WC Clearing 0.00% 48542.5199.28631 0.77 2020 WC Clearing 0.45% 48542.5199.28700 133.49 2020 WC Clearing 0.78% 48542.5199.28740 228.85 2020 WC Clearing 0.29% 48542.5199.28780 83.93 2020 WC Clearing 3.32% 48542.5199.28790 978.45 2020 WC Clearing 1.04% 48542.5199.28800 304.93 2020 WC Clearing 0.01% 48542.5199.28870 2.31 2020 WC Clearing 0.00% 48542.5199.28890 0.96 2020 WC Clearing 0.12% 48542.5199.28920 36.61 2020 WC Clearing 0.11% 48542.5199.28930 32.03 2020 WC Clearing 0.18% 48542.5199.29020 52.01 2020 WC Clearing 0.01% 48542.5199.29030 2.84 2020 WC Clearing 0.01% 48542.5199.29250 4.29 2020 WC Clearing 0.00% 48543.5199.28630 0.33 2020 WC Clearing 0.03% 48543.5199.28631 8.69 2020 WC Clearing 0.49% 48543.5199.28700 143.24 2020 WC Clearing 0.64% 48543.5199.28740 187.05 2020 WC Clearing 0.01% 48543.5199.28760 2.62 2020 WC Clearing 0.04% 48543.5199.28780 11.23 2020 WC Clearing 0.02% 48543.5199.28790 5.93 2020 WC Clearing 0.35% 48543.5199.28870 102.65 2020 WC Clearing 0.02% 48543.5199.28890 7.24 2020 WC Clearing 0.02% 48543.5199.28900 5.73 2020 WC Clearing 1.08% 48543.5199.28920 316.75 2020 WC Clearing 0.00% 48543.5199.28930 1.09 2020 WC Clearing 0.37% 48546.5199.28700 108.04 2020 WC Clearing 1.06% 48546.5199.28740 312.49 2020 WC Clearing 0.02% 48546.5199.28760 5.88 2020 WC Clearing 3.05% 48546.5199.28780 897.88 2020 WC Clearing 0.22% 48546.5199.28790 65.58 2020 WC Clearing 0.06% 48546.5199.28800 17.13 2020 WC Clearing 0.06% 48546.5199.28870 17.28 2020 WC Clearing 0.19% 48546.5199.28920 55.77 2020 WC Clearing 0.25% 48546.5199.29020 72.51 2020 WC Clearing 1.19% 48546.5199.29030 349.17 2020 WC Clearing 0.02% 48546.5199.29250 4.76 2020 WC Clearing 0.02% 48547.5199.28630 6.56 2020 WC Clearing 1.16% 48547.5199.28700 341.20 2020 WC Clearing 0.73% 48547.5199.28740 214.88 2020 WC Clearing 0.01% 48547.5199.28760 2.31 2020 WC Clearing 0.03% 48547.5199.28800 8.13 2020 WC Clearing 0.41% 48547.5199.28870 119.37 2020 WC Clearing 0.05% 48547.5199.28890 13.62 2020 WC Clearing 0.00% 48547.5199.28900 0.99 2020 WC Clearing 1.13% 48547.5199.28920 331.45 2020 WC Clearing 0.27% 48549.5199.28436 80.69 2020 WC Clearing 0.01% 48550.5199.28530 3.91 2020 WC Clearing 0.51% 48550.5199.28700 150.77 2020 WC Clearing 0.14% 48550.5199.28740 40.15 2020 WC Clearing 0.02% 48550.5199.28760 7.35 2020 WC Clearing 0.00% 48550.5199.28780 0.22 2020 WC Clearing 0.01% 48550.5199.28800 3.31 2020 WC Clearing 1.66% 48550.5199.28870 489.92 2020 WC Clearing 0.02% 48550.5199.28890 6.24 2020 WC Clearing 0.00% 48550.5199.28900 1.02 2020 WC Clearing 1.08% 48550.5199.28920 319.12 2020 WC Clearing 0.01% 48550.5199.29020 3.06 2020 WC Clearing 0.04% 48550.5199.29250 12.71 2020 WC Clearing 0.37% 48552.5199.28700 110.20 2020 WC Clearing 1.01% 48552.5199.28740 296.67 2020 WC Clearing 0.02% 48552.5199.28750 6.18 2020 WC Clearing 2.79% 48552.5199.28780 820.41 2020 WC Clearing 0.54% 48552.5199.28790 159.18 2020 WC Clearing 0.03% 48552.5199.28800 8.29 2020 WC Clearing 0.01% 48552.5199.28870 3.53 2020 WC Clearing 0.02% 48552.5199.28871 5.30 2020 WC Clearing 0.06% 48552.5199.28920 18.44 2020 WC Clearing 0.21% 48552.5199.29020 62.14 2020 WC Clearing 0.87% 48552.5199.29030 255.45 2020 WC Clearing 0.01% 48552.5199.29250 1.79 2020 WC Clearing 0.42% 48553.5199.28700 122.52 2020 WC Clearing 0.10% 48553.5199.28740 29.25 2020 WC Clearing 0.50% 48553.5199.28780 148.20 2020 WC Clearing 1.23% 48553.5199.28790 361.05 2020 WC Clearing 0.00% 48553.5199.28870 1.15 2020 WC Clearing 0.01% 48553.5199.28920 2.61 2020 WC Clearing 0.01% 48553.5199.28930 1.48 2020 WC Clearing 0.05% 48553.5199.29020 15.46 2020 WC Clearing 0.34% 48553.5199.29030 101.04 2020 WC Clearing 0.00% 48553.5199.29250 0.49 2020 WC Clearing 0.06% 48554.5199.28631 16.67 2020 WC Clearing 1.57% 48554.5199.28740 463.27 2020 WC Clearing 0.35% 48554.5199.28870 104.22 2020 WC Clearing 0.80% 48558.5199.28800 236.12 2020 WC Clearing 0.30% 48559.5199.28660 88.02 2020 WC Clearing 0.85% 48559.5199.28930 249.91 2020 WC Clearing 0.04% 48563.5199.28700 10.40 2020 WC Clearing 0.04% 48563.5199.28740 10.72 2020 WC Clearing 0.02% 48563.5199.28850 6.93 2020 WC Clearing 0.01% 48563.5199.28900 3.44 2020 WC Clearing 0.00% 48569.5199.28410 ‐ 2020 WC Clearing 0.00% 48569.5199.28700 ‐ 2020 WC Clearing 0.00% 48572.5199.29030 ‐ 2020 WC Clearing 0.01% 48574.5199.29030 4.16 2020 WC Clearing 0.43% 48582.5199.29200 125.80 2020 WC Clearing 0.40% 48598.5199.29200 118.06 2020 WC Clearing 0.00% 71200.5199.19030 ‐ 2020 WC Clearing 0.00% 71200.5199.29030 ‐ 2020 WC Clearing 0.00% 71200.5199.41713 ‐ 2020 WC Clearing 0.04% 72000.5199.29200 12.73 2020 WC Clearing 0.00% 76900.5199.28700 ‐ 2020 WC Clearing 0.16% 90100.5199.2920 47.22 2020 WC Clearing 0.01% 95500.5199.2875 3.28 2020 WC Clearing 0.03% 95500.5199.28890 9.35 2020 WC Clearing 0.00% 95500.5199.28900 0.49 2020 WC Clearing 0.04% 4760600.5199.292 11.94 2020 WC Clearing 0.12% 4762000.5199.292 36.38 2020 WC Clearing 0.00% 4766900.5199.287 ‐ 2020 WC Clearing 0.00% 4767200.5199.290 ‐ 2020 WC Clearing 13.42% \480991.0199 3,950.46 2020 WC Clearing 0.02% \470992.0199 7.02 2020 WC Clearing 0.12% \99991.0199 34.16 2020 WC Clearing 0.00