20230109INT to Staff Attachment - Response to No. 21_2021 Total Stores Clearing.pdf

JD Edwards Holden, Stephen J[JPD920]
Batch Review - Journal Entry Personal Form:(No Personalization)Query:All Records
Row Form Tools
Batch Number 1935980 Model Percent Reverse
Doc Type/No/Co JE 24290 00048 G/L Date 12/31/2021
Explanation *2021 Total Stores Clearing Ledger Type AA
Records 1 - 40 * Default
Account Number Amount Account Description Subledger Type Subledger Subledger Description Remark
48.1630.00100 Freight EOY clear stores clea
48.1630.00300 37,647.81-Invoice Price Variance (Inven) EOY clear stores clear
48.1630.0031 263,760.96-Inventory Adjustments-AAI EOY clear stores clear
48.1630.00310 44.96-Inventory Adjustments EOY clear stores clear
48.1630.00500 508,242.04-Non-Inventory Purchases EOY clear stores clear
48.1630.09000 845,301.09 Stores Clearing (Loading Cr) EOY clear stores clear
48.0300 30,477.07-Materials/Land Purchase W 00480991 Igc Construction Overhead ES EOY clear stores clear
48535.5300.28790 .32-Customer Installations EOY clear stores clear
48536.5300.28790 .41-Customer Installations EOY clear stores clear
48538.5300.28790 .16-Customer Installations EOY clear stores clear
48539.5300.28790 2.35-Customer Installations EOY clear stores clear
48542.5300.28790 .95-Customer Installations EOY clear stores clear
48542.5300.28800 .10-Other Expenses EOY clear stores clear
48543.5300.28740 3.52-Mains & Services EOY clear stores clear
48546.5300.28790 16.70-Customer Installations EOY clear stores clear
48547.5300.28740 .17-Mains & Services EOY clear stores clear
48547.5300.28790 .48-Customer Installations EOY clear stores clear
48550.5300.28740 9.87-Mains & Services EOY clear stores clear
3,524.20-
Account Number Account Description Level Of Detail General Ledger Period Balance General Ledger Balance Posting Edit Code
          48.1630.00100      Freight 5 2,900.00 3,524.20                                 
          48.1630.00300      Invoice Price Variance (Inven) 5 37,647.81                              
          48.1630.0031      Inventory Adjustments‐AAI 5 ‐0.01 263,760.96                           
          48.1630.00310      Inventory Adjustments 5 44.96 44.96                                      
          48.1630.00500      Non‐Inventory Purchases 5 32,374.09 508,242.04                           
          48.1630.09000      Stores Clearing (Loading Cr) 5 (845,301.09)                          
Total Object Account 1630 35,319.04                                           (32,081.12)                           
(1,604.05)                             
          48.1630.00100 ‐3,524.20 EOY clear stores clearing
          48.1630.00300 ‐37,647.81 EOY clear stores clearing
          48.1630.0031 ‐263,760.96 EOY clear stores clearing
          48.1630.00310 ‐44.96 EOY clear stores clearing
          48.1630.00500 ‐508,242.04 EOY clear stores clearing
          48.1630.09000 845,301.09 EOY clear stores clearing
\480991.0300 ‐30,477.07 EOY clear stores clearing
48535.5300.28790 ‐0.32 EOY clear stores clearing
48536.5300.28790 ‐0.41 EOY clear stores clearing
48538.5300.28790 ‐0.16 EOY clear stores clearing
48539.5300.28790 ‐2.35 EOY clear stores clearing
48542.5300.28790 ‐0.95 EOY clear stores clearing
48542.5300.28800 ‐0.10 EOY clear stores clearing
48543.5300.28740 ‐3.52 EOY clear stores clearing
48546.5300.28790 ‐16.70 EOY clear stores clearing
48547.5300.28740 ‐0.17 EOY clear stores clearing
48547.5300.28790 ‐0.48 EOY clear stores clearing
48550.5300.28740 ‐9.87 EOY clear stores clearing
48508.5300.28890 ‐20.99 EOY clear stores clearing
48534.5300.28920 ‐0.18 EOY clear stores clearing
48535.5300.28920 ‐90.32 EOY clear stores clearing
48536.5300.28920 ‐413.26 EOY clear stores clearing
48538.5300.28920 ‐58.42 EOY clear stores clearing
48539.5300.28920 ‐331.68 EOY clear stores clearing
48542.5300.28870 ‐0.78 EOY clear stores clearing
48542.5300.28920 ‐52.59 EOY clear stores clearing
48543.5211.28920 ‐2.98 EOY clear stores clearing
48543.5300.28870 ‐18.32 EOY clear stores clearing
48543.5300.28920 ‐109.83 EOY clear stores clearing
48546.5300.28920 ‐72.96 EOY clear stores clearing
48547.5300.28870 ‐68.81 EOY clear stores clearing
48547.5300.28890 ‐13.05 EOY clear stores clearing
48547.5300.28920 ‐152.83 EOY clear stores clearing
48550.5300.28870 ‐9.72 EOY clear stores clearing
48550.5300.28890 ‐0.26 EOY clear stores clearing
48550.5300.28920 ‐127.51 EOY clear stores clearing
48552.5300.28890 ‐0.46 EOY clear stores clearing
48552.5300.28920 ‐15.07 EOY clear stores clearing
48553.5300.28920 ‐9.00 EOY clear stores clearing
95%5%
107 Construction Work in Progress $5,840,208.95 107 & 108 $5,860,570.87 94.92% 95%
108 Accum. Prov. for Depreciation $20,361.92 401 & 402 & 417 $313,396.16 5.08% 5%
401 Operation Expense $6,840.10
402 Maintenance Expense $306,215.45
417 RNG $340.61
$6,173,967.03
401 48535 5300 28790 Operation Expense $63.30 0.02%
401 48536 5300 28790 Operation Expense $80.03 0.03%
401 48538 5300 28790 Operation Expense $31.17 0.01%
401 48539 5300 28790 Operation Expense $459.58 0.15%
401 48542 5300 28790 Operation Expense $184.92 0.06%
401 48542 5300 28800 Operation Expense $20.16 0.01%
401 48543 5300 28740 Operation Expense $686.87 0.22%
401 48546 5300 28790 Operation Expense $3,260.12 1.04%
401 48547 5300 28740 Operation Expense $33.64 0.01%
401 48547 5300 28790 Operation Expense $93.16 0.03%
401 48550 5300 28740 Operation Expense $1,927.15 0.62%
402 48508 5300 28890 Maintenance Expense $4,096.16 1.31%
402 48534 5300 28920 Maintenance Expense $34.59 0.01%
402 48535 5300 28920 Maintenance Expense $17,626.43 5.63%
402 48536 5300 28920 Maintenance Expense $80,654.13 25.76%
402 48538 5300 28920 Maintenance Expense $11,401.18 3.64%
402 48539 5300 28920 Maintenance Expense $64,733.10 20.68%
402 48542 5300 28870 Maintenance Expense $152.84 0.05%
402 48542 5300 28920 Maintenance Expense $10,262.87 3.28%
402 48543 5211 28920 Maintenance Expense $581.60 0.19%
402 48543 5300 28870 Maintenance Expense $3,574.52 1.14%
402 48543 5300 28920 Maintenance Expense $21,435.07 6.85%
402 48546 5300 28920 Maintenance Expense $14,239.35 4.55%
402 48547 5300 28870 Maintenance Expense $13,428.84 4.29%
402 48547 5300 28890 Maintenance Expense $2,547.34 0.81%
402 48547 5300 28920 Maintenance Expense $29,827.23 9.53%
402 48550 5300 28870 Maintenance Expense $1,896.79 0.61%
402 48550 5300 28890 Maintenance Expense $50.37 0.02%
402 48550 5300 28920 Maintenance Expense $24,886.36 7.95%
402 48552 5300 28890 Maintenance Expense $89.12 0.03%
402 48552 5300 28920 Maintenance Expense $2,941.12 0.94%
402 48553 5300 28920 Maintenance Expense $1,756.44 0.56%
$313,055.55
48535.5300.28790
48536.5300.28790
48538.5300.28790
48539.5300.28790
48542.5300.28790