Loading...
HomeMy WebLinkAbout20230109INT to Staff Attachment - Response to No. 21_1220 JE 58 Vacation Accrual.pdf Batch Review - Journal Entry Personal Form:(No Personalization)Query:All Records  Row Form Tools Batch Number 1830266 Model Percent Reverse Doc Type/No/Co JE 1050 00048 G/L Date 12/31/2020 Explanation JE 58 VACATION ACCRUAL Ledger Type A Records 1 - 100 * Defa Account Number Amount Account Description Subledger Type Subledger Subledger Description Remark 48.2423.3010 188,548.93-acation Wa e acation a 48501.5193.29200 758.69 Admin. & General Sala Vacation ac 48502.5193.29100 718.58 Misc. Customer Service Exp. 48504.5193.29200 2,458.34 Admin. & General Sala 48506.5193.28130 1,512.82 Other Gas Supply Exp. 48508.5193.28660 248.10 Maint of Communication 48508.5193.28700 24.65 Operation Supervision 48508.5193.28750 1,056.98 Meas. & Reg. Stations-Gen. 48508.5193.28760 719.71 Meas. & Reg. Stations-Ind. 48508.5193.28780 61.98 Meter & House Reg. Exp. 48508.5193.28850 47.63 Maint. Supervision & Eng. 48508.5193.28890 1,649.80 Mtc. of Meas. & Reg. Eq.-Gen 48508.5193.28900 348.40 Mtc. of Meas. & Reg. Eq.-Ind 48508.5193.28930 817.31 Maint. of Meters & House Reg 48509.5193.28700 453.85 Operation Supervision 48513.5193.28410 3,351.92 Operation Labor & Exp 48514.5193.29200 4,538.47 Admin. & General Sala 48518.5193.29010 755.71 Supervision Page 1 of 2Batch Review - Journal Entry 1 7 2021https://erpprod.mdu.com/jde/E1Client.mafService?jdemafjascacheUID=4963&jdemafjasLauncher=PSFT_TE_V3_SW&jdemafj ... T2 JE T3 & TA Beg. Bal. Vacation Vacation Vacation Ending Bal. Required Balance  48.2423.30109 at 1/1/20 Payof Transfers Loading at 12/31/20 Adjustment at 12/31/20 IGC (1,490,450.35)    170,746.42         47,031.26           (110,346.14)  (1,383,018.81)    (188,548.93)    (1,571,567.74)          C:\Users\niki.ogami\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\F6RPM3P4\[IGC 2020 Accrued Vacation Analysis summary.xlsx]Vac Accrual Intermountain Gas Company Accrued Vacation Analysis December 31, 2020 Trial Balance By Object - Trial Balance by Object Personal Form:(No Personalization) Row Tools Object/Subsidiary 2423 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 - 2 * Default  Account Number Account Description Level Of Detail General Ledger Period Balance General Ledger Balance Posting Edit Code 48.2423.30109 Vacation Wages 5 23,816.00 1,383,018.81- Total Object Account 2423 23,816.00 1,383,018.81- Page 1 of 2Trial Balance By Object - Trial Balance by Object 1 6 2021https://erpprod.mdu.com/jde/RunApp.mafService?e1UserActInfo=true&e1.mode=view&e1.namespace=&RENDER_MAFLET=... 2019 Vacation True‐up (188,548.93)                                         48.2423.30109 (188,548.93)                                        2020 Vacation Clearing 0.40% 48501.5193.29200 758.69                                                  2020 Vacation Clearing 0.38% 48502.5193.29100 718.58                                                  2020 Vacation Clearing 1.30% 48504.5193.29200 2,458.34                                              2020 Vacation Clearing 48505.5193.29100 ‐                                                         2020 Vacation Clearing 0.80% 48506.5193.28130 1,512.82                                              2020 Vacation Clearing 0.13% 48508.5193.28660 248.10                                                  2020 Vacation Clearing 0.01% 48508.5193.28700 24.65                                                    2020 Vacation Clearing 0.56% 48508.5193.28750 1,056.98                                              2020 Vacation Clearing 0.38% 48508.5193.28760 719.71                                                  2020 Vacation Clearing 0.03% 48508.5193.28780 61.98                                                    2020 Vacation Clearing 0.03% 48508.5193.28850 47.63                                                    2020 Vacation Clearing 0.87% 48508.5193.28890 1,649.80                                              2020 Vacation Clearing 0.18% 48508.5193.28900 348.40                                                  2020 Vacation Clearing 0.43% 48508.5193.28930 817.31                                                  2020 Vacation Clearing 0.24% 48509.5193.28700 453.85                                                  2020 Vacation Clearing 1.78% 48513.5193.28410 3,351.92                                              2020 Vacation Clearing 2.41% 48514.5193.29200 4,538.47                                              2020 Vacation Clearing 0.40% 48518.5193.29010 755.71                                                  2020 Vacation Clearing 2.35% 48518.5193.29030 4,433.91                                              2020 Vacation Clearing 2.72% 48520.5193.29120 5,137.29                                              2020 Vacation Clearing 1.25% 48521.5193.29200 2,360.84                                              2020 Vacation Clearing 0.00% 48521.5193.29260 ‐                                                         2020 Vacation Clearing 0.01% 48524.5193.4171 25.83                                                    2020 Vacation Clearing 0.05% 48526.5193.29080 88.28                                                    2020 Vacation Clearing 2.28% 48526.5193.29200 4,296.84                                              2020 Vacation Clearing 0.40% 48533.5193.28700 756.41                                                  2020 Vacation Clearing 0.41% 48534.5193.28740 776.96                                                  2020 Vacation Clearing 0.08% 48534.5193.28750 150.67                                                  2020 Vacation Clearing 0.64% 48534.5193.28780 1,201.24                                              2020 Vacation Clearing 3.69% 48534.5193.28790 6,958.21                                              2020 Vacation Clearing 0.13% 48534.5193.28870 246.00                                                  2020 Vacation Clearing 0.08% 48534.5193.28871 152.76                                                  2020 Vacation Clearing 1.09% 48534.5193.28920 2,047.21                                              2020 Vacation Clearing 1.01% 48534.5193.28930 1,912.24                                              2020 Vacation Clearing 2.03% 48534.5193.29020 3,836.52                                              2020 Vacation Clearing 0.49% 48534.5193.29030 928.75                                                  2020 Vacation Clearing 0.00% 48535.5193.28740 1.40                                                       2020 Vacation Clearing 0.02% 48535.5193.28780 37.22                                                    2020 Vacation Clearing 0.00% 48535.5193.28790 7.65                                                       2020 Vacation Clearing 1.10% 48535.5193.28800 2,080.42                                              2020 Vacation Clearing 0.01% 48535.5193.28870 24.69                                                    2020 Vacation Clearing 1.16% 48535.5193.28920 2,180.69                                              2020 Vacation Clearing 0.54% 48535.5193.29020 1,016.69                                              2020 Vacation Clearing 1.24% 48536.5193.28700 2,340.20                                              2020 Vacation Clearing 1.05% 48536.5193.28740 1,985.40                                              2020 Vacation Clearing 0.00% 48536.5193.28750 8.40                                                       2020 Vacation Clearing 0.07% 48536.5193.28760 137.66                                                  2020 Vacation Clearing 0.04% 48536.5193.28780 79.14                                                    2020 Vacation Clearing 1.04% 48536.5193.28800 1,959.17                                              2020 Vacation Clearing 1.19% 48536.5193.28870 2,242.04                                              2020 Vacation Clearing 0.02% 48536.5193.28890 32.66                                                    2020 Vacation Clearing Vacation True‐up‐ 5193 0.00% 48536.5193.28900 4.08                                                       2020 Vacation Clearing 2.32% 48536.5193.28920 4,375.15                                              2020 Vacation Clearing 0.04% 48536.5193.29030 84.75                                                    2020 Vacation Clearing 0.33% 48538.5193.28700 627.82                                                  2020 Vacation Clearing 1.24% 48538.5193.28740 2,339.63                                              2020 Vacation Clearing 0.16% 48538.5193.28750 292.95                                                  2020 Vacation Clearing 0.01% 48538.5193.28760 21.36                                                    2020 Vacation Clearing 1.92% 48538.5193.28790 3,615.07                                              2020 Vacation Clearing 0.19% 48538.5193.28800 354.89                                                  2020 Vacation Clearing 0.19% 48538.5193.28870 366.11                                                  2020 Vacation Clearing 0.44% 48538.5193.28871 838.75                                                  2020 Vacation Clearing 0.61% 48538.5193.28920 1,148.05                                              2020 Vacation Clearing 0.51% 48538.5193.28930 966.42                                                  2020 Vacation Clearing 0.80% 48538.5193.29020 1,507.70                                              2020 Vacation Clearing 0.49% 48538.5193.29030 929.53                                                  2020 Vacation Clearing 0.04% 48538.5193.29250 80.63                                                    2020 Vacation Clearing 0.49% 48539.5193.28700 928.84                                                  2020 Vacation Clearing 1.11% 48539.5193.28740 2,097.20                                              2020 Vacation Clearing 0.04% 48539.5193.28750 80.32                                                    2020 Vacation Clearing 0.02% 48539.5193.28760 29.35                                                    2020 Vacation Clearing 0.06% 48539.5193.28800 106.40                                                  2020 Vacation Clearing 0.61% 48539.5193.28870 1,141.80                                              2020 Vacation Clearing 0.00% 48539.5193.28871 2.80                                                       2020 Vacation Clearing 0.01% 48539.5193.28890 16.98                                                    2020 Vacation Clearing 0.00% 48539.5193.28900 6.72                                                       2020 Vacation Clearing 1.09% 48539.5193.28920 2,047.14                                              2020 Vacation Clearing 0.40% 48541.5193.28700 756.41                                                  2020 Vacation Clearing 0.00% 48542.5193.28631 4.90                                                       2020 Vacation Clearing 0.45% 48542.5193.28700 855.27                                                  2020 Vacation Clearing 0.78% 48542.5193.28740 1,466.24                                              2020 Vacation Clearing 0.29% 48542.5193.28780 537.76                                                  2020 Vacation Clearing 3.32% 48542.5193.28790 6,268.79                                              2020 Vacation Clearing 1.04% 48542.5193.28800 1,953.67                                              2020 Vacation Clearing 0.01% 48542.5193.28870 14.78                                                    2020 Vacation Clearing 0.00% 48542.5193.28890 6.13                                                       2020 Vacation Clearing 0.12% 48542.5193.28920 234.54                                                  2020 Vacation Clearing 0.11% 48542.5193.28930 205.18                                                  2020 Vacation Clearing 0.18% 48542.5193.29020 333.20                                                  2020 Vacation Clearing 0.01% 48542.5193.29030 18.21                                                    2020 Vacation Clearing 0.01% 48542.5193.29250 27.49                                                    2020 Vacation Clearing 0.00% 48543.5193.28630 2.10                                                       2020 Vacation Clearing 0.03% 48543.5193.28631 55.68                                                    2020 Vacation Clearing 0.49% 48543.5193.28700 917.74                                                  2020 Vacation Clearing 0.64% 48543.5193.28740 1,198.44                                              2020 Vacation Clearing 0.01% 48543.5193.28760 16.76                                                    2020 Vacation Clearing 0.04% 48543.5193.28780 71.96                                                    2020 Vacation Clearing 0.02% 48543.5193.28790 38.00                                                    2020 Vacation Clearing 0.35% 48543.5193.28870 657.66                                                  2020 Vacation Clearing 0.02% 48543.5193.28890 46.37                                                    2020 Vacation Clearing 0.02% 48543.5193.28900 36.73                                                    2020 Vacation Clearing 1.08% 48543.5193.28920 2,029.35                                              2020 Vacation Clearing 0.00% 48543.5193.28930 7.00                                                       2020 Vacation Clearing 48543.5193.29250 ‐                                                         2020 Vacation Clearing 0.37% 48546.5193.28700 692.19                                                  2020 Vacation Clearing 1.06% 48546.5193.28740 2,002.10                                              2020 Vacation Clearing 0.02% 48546.5193.28760 37.65                                                    2020 Vacation Clearing 3.05% 48546.5193.28780 5,752.62                                              2020 Vacation Clearing 0.22% 48546.5193.28790 420.17                                                  2020 Vacation Clearing 0.06% 48546.5193.28800 109.72                                                  2020 Vacation Clearing 0.06% 48546.5193.28870 110.70                                                  2020 Vacation Clearing 0.19% 48546.5193.28920 357.30                                                  2020 Vacation Clearing 0.25% 48546.5193.29020 464.56                                                  2020 Vacation Clearing 1.19% 48546.5193.29030 2,237.10                                              2020 Vacation Clearing 0.02% 48546.5193.29250 30.47                                                    2020 Vacation Clearing 0.02% 48547.5193.28630 42.02                                                    2020 Vacation Clearing 1.16% 48547.5193.28700 2,186.02                                              2020 Vacation Clearing 0.73% 48547.5193.28740 1,376.71                                              2020 Vacation Clearing 0.01% 48547.5193.28760 14.81                                                    2020 Vacation Clearing 0.03% 48547.5193.28800 52.08                                                    2020 Vacation Clearing 0.41% 48547.5193.28870 764.80                                                  2020 Vacation Clearing 0.05% 48547.5193.28890 87.23                                                    2020 Vacation Clearing 0.00% 48547.5193.28900 6.35                                                       2020 Vacation Clearing 1.13% 48547.5193.28920 2,123.58                                              2020 Vacation Clearing 0.27% 48549.5193.28436 516.94                                                  2020 Vacation Clearing 0.01% 48550.5193.28530 25.04                                                    2020 Vacation Clearing 0.51% 48550.5193.28700 965.95                                                  2020 Vacation Clearing 0.14% 48550.5193.28740 257.24                                                  2020 Vacation Clearing 0.02% 48550.5193.28760 47.10                                                    2020 Vacation Clearing 0.00% 48550.5193.28780 1.40                                                       2020 Vacation Clearing 0.01% 48550.5193.28800 21.19                                                    2020 Vacation Clearing 1.66% 48550.5193.28870 3,138.85                                              2020 Vacation Clearing 0.02% 48550.5193.28890 39.99                                                    2020 Vacation Clearing 0.00% 48550.5193.28900 6.56                                                       2020 Vacation Clearing 1.08% 48550.5193.28920 2,044.54                                              2020 Vacation Clearing 0.01% 48550.5193.29020 19.61                                                    2020 Vacation Clearing 0.04% 48550.5193.29250 81.42                                                    2020 Vacation Clearing 0.37% 48552.5193.28700 706.07                                                  2020 Vacation Clearing 1.01% 48552.5193.28740 1,900.74                                              2020 Vacation Clearing 0.02% 48552.5193.28750 39.57                                                    2020 Vacation Clearing 2.79% 48552.5193.28780 5,256.29                                              2020 Vacation Clearing 0.54% 48552.5193.28790 1,019.84                                              2020 Vacation Clearing 0.03% 48552.5193.28800 53.14                                                    2020 Vacation Clearing 0.01% 48552.5193.28870 22.59                                                    2020 Vacation Clearing 0.02% 48552.5193.28871 33.97                                                    2020 Vacation Clearing 0.06% 48552.5193.28920 118.16                                                  2020 Vacation Clearing 0.21% 48552.5193.29020 398.09                                                  2020 Vacation Clearing 0.87% 48552.5193.29030 1,636.63                                              2020 Vacation Clearing 0.01% 48552.5193.29250 11.47                                                    2020 Vacation Clearing 0.42% 48553.5193.28700 784.95                                                  2020 Vacation Clearing 0.10% 48553.5193.28740 187.40                                                  2020 Vacation Clearing 0.50% 48553.5193.28780 949.52                                                  2020 Vacation Clearing 1.23% 48553.5193.28790 2,313.18                                              2020 Vacation Clearing 0.00% 48553.5193.28870 7.35                                                       2020 Vacation Clearing 0.01% 48553.5193.28920 16.72                                                    2020 Vacation Clearing 0.01% 48553.5193.28930 9.46                                                       2020 Vacation Clearing 0.05% 48553.5193.29020 99.05                                                    2020 Vacation Clearing 0.34% 48553.5193.29030 647.35                                                  2020 Vacation Clearing 0.00% 48553.5193.29250 3.15                                                       2020 Vacation Clearing 0.06% 48554.5193.28631 106.81                                                  2020 Vacation Clearing 1.57% 48554.5193.28740 2,968.11                                              2020 Vacation Clearing 0.35% 48554.5193.28870 667.74                                                  2020 Vacation Clearing 0.80% 48558.5193.28800 1,512.82                                              2020 Vacation Clearing 0.30% 48559.5193.28660 563.96                                                  2020 Vacation Clearing 0.85% 48559.5193.28930 1,601.18                                              2020 Vacation Clearing 0.04% 48563.5193.28700 66.63                                                    2020 Vacation Clearing 0.04% 48563.5193.28740 68.66                                                    2020 Vacation Clearing 0.02% 48563.5193.28850 44.42                                                    2020 Vacation Clearing 0.01% 48563.5193.28900 22.06                                                    2020 Vacation Clearing 0.00% 48569.5193.28410 ‐                                                         2020 Vacation Clearing 0.00% 48569.5193.28700 ‐                                                         2020 Vacation Clearing 0.00% 48572.5193.29030 ‐                                                         2020 Vacation Clearing 0.01% 48574.5193.29030 26.66                                                    2020 Vacation Clearing 0.43% 48582.5193.29200 805.99                                                  2020 Vacation Clearing 0.40% 48598.5193.29200 756.41                                                  2020 Vacation Clearing 0.00% 71200.5193.19030 ‐                                                         2020 Vacation Clearing 0.00% 71200.5193.29030 ‐                                                         2020 Vacation Clearing 0.00% 71200.5193.4171300 ‐                                                         2020 Vacation Clearing 0.04% 72000.5193.29200 81.53                                                    2020 Vacation Clearing 0.00% 76900.5193.28700 ‐                                                         2020 Vacation Clearing 0.16% 90100.5193.29200 302.56                                                  2020 Vacation Clearing 0.01% 95500.5193.28750 21.01                                                    2020 Vacation Clearing 0.03% 95500.5193.28890 59.88                                                    2020 Vacation Clearing 0.00% 95500.5193.28900 3.15                                                       2020 Vacation Clearing 0.04% 4760600.5193.29200 76.48                                                    2020 Vacation Clearing 0.12% 4762000.5193.29200 233.09                                                  2020 Vacation Clearing 0.00% 4766900.5193.28720 ‐                                                         2020 Vacation Clearing 0.00% 4767200.5193.29030 ‐                                                         2020 Vacation Clearing 13.42% \480991.0193 25,310.08                                            2020 Vacation Clearing 0.02% \470992.0193 45.00                                                    2020 Vacation Clearing 0.12% \99991.0193 218.87                                                  2020 Vacation Clearing 0.00