Spreadsheet: 876484d1723177220-how-to-set-the-formula-in-column-j-to-show-the-company-name-excel-formula
Sheet: 65301304 (Year)

Acc Code | 65301304 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepared by: | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reviewed by: | [NAME]
 |  | Values
Posting Period | Remark | POL DEL | POL REG | POL HK1 | [NAME] | POL HK3 | FRE CHG | POD HK1 | POD HK2 | POD HK3 | POD HK4 | POD REG | POD DEL | POD DUT | BLP REG | BLP DEL | CIF CMB | [NAME] | FAB AIR | LDP BST | MIS CHG | Total
2023-04-30 00:00:00 | (blank) | 1326 | 7406.15 |  |  |  | 10198.81999999999 |  |  |  |  | 11692.75000000001 | 5569.999999999998 |  |  |  |  |  |  |  |  | 36193.72
2023-05-31 00:00:00 | (blank) | 25612.25 | 44381.8 |  |  |  | 118116.32 | 12164.9 | 4697 |  |  | 43626.0766 | 20316.13 | -663 |  |  |  |  | 22417.98 |  |  | 290669.4666
2023-06-30 00:00:00 | (blank) | 15683.37 | 17737.35 |  |  | 1285 | 60734.75 | 11506.95 | 2391 | 1130 | 9960 | 39474.54000000002 | 21975.69 | 3276 |  |  |  |  | 4264.65 | 8697.66 |  | 201470.95
2023-07-31 00:00:00 | (blank) | 19078.70096 | 24284.94520000001 |  |  |  | 73088.15 | 16696.03 | 4152.01 | 4450.5 | 6482.275000000001 | 30981.962 | 26574.44 |  |  |  |  |  | 28175.3492 |  |  | 234202.0823599999
2023-08-23 00:00:00 | (blank) | 4658.66 | 5059.23 | 455 | 307 |  | 27726.162 | 10624.08 | 2064.88 | 5284.99 | 6158 | 31444.312 | 17490 |  |  |  |  |  | 58086.588 |  |  | 171517.752
2023-09-30 00:00:00 | (blank) | 1686.388 | 3023.596 |  |  | 7713 | 18954 | 6174 |  | 1885 | 2391 | 8357.848284 | 3627 |  |  |  |  |  | 11920.546 |  |  | 99978.87328399996
2023-10-31 00:00:00 | (blank) | 8309.017225 | 2854.1849 |  |  |  | 79272.17199999999 | 4422.7 |  | 1872.3 | 4228 | 85947.562 | 33025.44 | 1128.27 |  |  |  |  | 217746.945615 |  |  | 443124.3817399998
2023-11-30 00:00:00 | (blank) | 6138.12 | 8018.739999999999 |  |  |  | 43643.488 |  |  | 4059.99 | 3553 | 25337.302 | 10118.006 |  |  |  |  |  | 24360.96 |  | 1170 | 126399.606
2023-12-31 00:00:00 | (blank) | 5830.599249999999 | 6057.85975 |  |  |  | 39635.19 | 1630 |  | 6100.99 | 2160 | 32422.113505 | 16496.049 |  | 4846.6612 | 4091.625 |  |  | 8926.86825 |  |  | 133280.309755
2024-01-31 00:00:00 | (blank) | 9180.51 | 12676.83 |  |  | 83 | 12505.62 | 2498.88 |  | 6694.999999999999 | 2843 | 28994.30947 | 8719.085 |  | 1648.4825 | 824.9475000000001 |  |  | 3303.69 |  |  | 89973.35447000003
2024-02-29 00:00:00 | (blank) | 5596.306625 | 9171.92 |  |  |  | 86982.74400000002 | 1360.4 | 1902 |  |  | 50771.541 | 27554.336 |  |  |  |  |  | 116737.852175 |  |  | 300077.1098
2024-03-31 00:00:00 | (blank) | 8740 | 12270.41 |  |  |  | 10815.238 | 2007.36 |  | 3734.6 | 3711 | 37090.55799999998 | 9525.29 |  |  |  |  |  | 151037.9101 |  |  | 238932.3761
2024-04-30 00:00:00 | (blank) | 8474.9 | 5579.9564 |  |  |  | 13110.78 |  |  |  | 5051 | 29443.092 | 9952.5 |  |  |  |  |  | 280645.442 |  |  | 352257.6804
Grand Total |  | 120314.82206 | 158522.97225 | 455 | 307 | 9081 | 594783.434 | 69085.29999999999 | 15206.89 | 35213.37 | 46537.275 | 455583.966859 | 210943.966 | 3741.27 | 6495.143700000001 | 4916.572499999999 |  |  | 927624.78134 | 8697.66 | 1170 | 2718077.662509