20230109INT to Staff Attachment - Response to No. 21_1220 JE AW Clearing.pdf

Batch Review - Journal Entry Personal Form:(No Personalization)Query:All Records 
Row Form Tools
Batch Number 1830464 Model Percent Reverse
Doc Type/No/Co JE 22707 00048 G/L Date 12/31/2020
Explanation AW Clearin Ledger Type A
Records 1 - 4 * Default
Account Number Amount Account
Description
Subledger
Type Subledger Subledger
Description Remark
48514.5400.29210 284,159.93 Office Supplie E Vehicle
48.0400 8,788.45 Vehicle/Work Equip W 00480991 Igc Construction Overhead ES YE Vehicle
18448.0300.190 292,948.38- Overhead Costs YE Vehicle
Remaining Amount
Page 1 of 2Batch Review - Journal Entry
1 7 2021https://erpprod.mdu.com/jde/E1Client.mafService?jdemafjascacheUID=5084&jdemafjasLauncher=PSFT_TE_V3_SW&jdemafj ...
Account Subledger Subledger Type Amount Remark
48514.5400.29210 284,159.93 YE Vehicle clearing
48.0400 480991 W 8,788.45 YE Vehicle clearing
18448.0300.190 (292,948.38) YE Vehicle clearing
Ledger Type AA
Year 20
Format ytd
Period 12.00
Currency ***
Company 00048
*
INTERMOUNTAIN
TOTAL
Business Unit Object Account Sub Account SubL Type SubL Name COMPANY
* 5400 * * * (1,495,726.74)           97%
* 0400 * * * (50,409.88)                3%
(1,546,136.62)
Ledger Type AA
Year 20
Format ltd
Period 12.00
Currency ***
Company 00048
Business Unit [18400,18448]
Object Account Sub Account SubL Type SubL Name Auto and Work Equipment Include Clearing
[0000.0999,/00BF] * * * Total 292,948.38               
Ledger Type AA
Year 2020
Format ltd
Period 12
Currency ***
Company 00048
Business Unit [18400,18448]
Auto and Work Equipment Include Clearing
Total 292,948.38
0010 Fuel - Auto & Work Equipme -
0011 Fuel-Natural Gas 8,259.85
0013 Fuel-Propane Gas -
0015 Fuel-Gasoline 6,510,338.14
0016 Fuel-Diesel 1,047,580.07
-
0110 - Straight Time/Total Payroll -
0120 - Premium Time -
0131 - Bonusses & Commissions -
0150 - Taxable Meals -
0191 - Payroll Taxes -
0192 - Benefits -
200 - Subcontract Labor 1,558,493.52
0211 - Subcontract Labor 782,348.74
0300 - Materials 1,058,839.96
0300 - Materials 5,926.93
0410 - Company Vehicles -
0421 - Trailer Expense 240.76
0500 - Overhead Costs -
0521 - Meals & Entertainment -
0522 - Other Reimburseable Exp.-
0900 -Misc 2,615.14
0941 - Hydraulic -
0984 - Damage Payment -
0110 - Straight Time/Total Payroll -
0120 - Premium Time -
0131 - Bonusses & Commissions -
0150 - Taxable Meals -
0191 - Payroll Taxes -
0192 - Benefits -
0211 - Subcontract Labor -
0300 - Materials -
0410 - Company Vehicles -
0421 - Trailer Expense -
0110 - Straight Time/Total Payroll -
0120 - Premium Time -
0131 - Bonusses & Commissions -
0150 - Taxable Meals -
0191 - Payroll Taxes -
0192 - Benefits -
0200 - Subcontract Labor 342,380.99
0211 - Subcontract Labor 108,311.96
0300 - Materials 102,221.25
0410 - Company Vehicles 660.25
0410 - Company Vehicles -
0421 - Trailer Expense -
0110 - Straight Time/Total Payroll -
0120 - Premium Time -
0131 - Bonusses & Commissions -
0150 - Taxable Meals -
0191 - Payroll Taxes -
0192 - Benefits -
0200 - Subcontract Labor 190,199.95
0211 - Subcontract Labor 32,715.11
0300 - Materials 8,246.79
0410 - Company Vehicles 162.91
0410 - Company Vehicles -
0514 - Personal Vehicle Use -
0941 - Hydraulic -
0110 - Straight Time/Total Payroll -
0120 - Premium Time -
0131 - Bonusses & Commissions -
0150 - Taxable Meals -
0191 - Payroll Taxes -
0192 - Benefits -
0211 - Subcontract Labor 1,858.35
0200 - Subcontract Labor 424.71
0300 - Materials 1,272.73
0410 - Company Vehicles 347.16
0410 - Company Vehicles -
0421 - Trailer Expense -
0521 - Meals & Entertainment 14.34
0522 - Other Reimburseable Exp.-
0900 - Permits & Filing Fees 217,086.52
0913 - Permits & Filing Fees 71,857.91
0110 - Straight Time/Total Payroll 113,266.48
0120 - Premium Time -
0130 - Bonusses & Commissions 180.00
0131 - Bonusses & Commissions 6,606.85
0150 - Taxable Meals -
0191 - Payroll Taxes 9,112.57
0192 - Benefits 33,275.09
0200-Overhead Costs (18,984.57)
0211 - Subcontract Labor (40,360.26)
0292 - Custodial Services -
0300 - Materials (187,634.64)
0400 - Overhead 1,799.63
0410 - Company Vehicles 230.01
0500 - Overhead Costs 2,257.97
0511 - Commercial Air Service 1,061.93
0512 - Corporate Aircraft -
0514 - Personal Vehicle Use 314.69
0521 - Meals & Entertainment 343.10
0522 - Other Reimburseable Exp.1,316.71
0600 - Overhead Costs 655.86
0610 - Telephone -
0611 - Cell Phones -
0620 - -
0630 - Office Supplies -
0640 - Utilities -
0800 - Overhead Costs 487.99
0811 - Professional Organ. Dues -
0813 - -
0851 - Seminars & Meeting Reg.308.60
0853 - -
0854 - Other Employee Training -
0900 - Overhead Costs 1,183.62
0913 - Permits & Filing Fees 1,950.18
0922 - Prepaid Insurance Amortizati -
0941 - Hydraulic (41,947.33)
0950 - Freight 33.36
0982 - Reference Material -
0985 - Inventory Shrinkage -
0110 - Straight Time/Total Payroll -
0120 - Premium Time -
0131 - Bonusses & Commissions -
0150 - Taxable Meals -
0191 - Payroll Taxes -
0192 - Benefits -
0211 - Subcontract Labor 17,822.48
0300 - Materials 249.89
0410 - Company Vehicles -
0421 - Trailer Expense -
0913 - Permits & Filing Fees 1,002.32
0941 - Hydraulic -
0950 - Freight -
0300 - Materials -
0640 - Utilities -
0641 - CNG Station Operations -
0642 - CNG Station Operations -
0941 - Hydraulic -
0110 - Straight Time/Total Payroll -
0120 - Premium Time -
0131 - Bonusses & Commissions -
0150 - Taxable Meals -
0191 - Payroll Taxes -
0192 - Benefits -
0211 - Subcontract Labor -
0300 - Materials -
0410 - Company Vehicles -
0521 - Meals & Entertainment -
0522 - Other Reimburseable Exp.-
0983 - Depreciation 7,569,282.82
0941 - Hydraulic -
0999 - Clearing (19,233,271.01)
Total 292,948.38
Difference 0.00