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

Acc Code | 65301304 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepared by: | [NAME]
Posting Period | 2024-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reviewed by: | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Values
Forwarder | Forwarder Inv # | Invoice Date | [NAME] | Departure (National-City) | Destination (National-City) | ETA Date | Vendor / Customer | Vendor / SAL Sales Inv # | Fabric PO # | Weight ([NAME]) | CBM | CTN / BAGS / ROLLS | 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
JLA LOGISTICS LTD | [NAME] | 2024-02-01 00:00:00 | SEA | CHINA-SHANGHAI | SRI LANKA-COLOMBO | (blank) | SUNLINE SANKEI YOKOHAMA(H.K) CO LTD | 10082725 | B-SLK-231219-3 | 225 | 0.6 | 15 | (blank) |  |  |  |  |  | 273 |  |  |  |  | 1136.07 | 585 |  |  |  |  |  |  |  |  | 1994.07
 | JIC24020128 | 2024-02-08 00:00:00 | SEA | CHINA-SHANGHAI | SRI LANKA-COLOMBO | (blank) | Excel rich International Ltd | JMDN-240012 | CF23-0205 | 5184 | 12 | 136 | (blank) |  |  |  |  |  | 3276 |  |  |  |  | 1865.37 | 1326 |  |  |  |  |  |  |  |  | 6467.37
 | JIC24020316 | 2024-02-12 00:00:00 | SEA | CHINA-SHANGHAI | SRI LANKA-COLOMBO | (blank) | RETEX TEXTILE CO., LTD | BD240302 | HUK346-1 | 221 | 0.9 | 9 | (blank) |  |  |  |  |  | 351 |  |  |  |  | 1249.17 | 585 |  |  |  |  |  |  |  |  | 2185.17
 | JIC24020114 | 2024-01-24 00:00:00 | SEA | CHINA-SHANGHAI | SRI LANKA-COLOMBO | (blank) | Luckytex Co., Ltd | LK2401985 | CF23-0214 | 6682.1 | 19 | 171 | (blank) |  |  |  |  |  | 6669 |  |  |  |  | 2660.97 |  |  |  |  |  |  |  |  |  | 9329.97
 | JIC24010655 | 2024-01-13 00:00:00 | SEA | INDIA-MANI | SRI LANKA-COLOMBO | (blank) | [NAME] INC | KL240183 | TRIM | 3076.84 | 13.57 | 320 | (blank) |  |  |  |  |  |  |  |  |  |  | 1599 | 1716 |  |  |  |  |  |  |  |  | 3315
 | JIC24020125 | 2024-01-16 00:00:00 | SEA | CHINA-SHANGHAI | SRI LANKA-COLOMBO | (blank) | SUNG IL INTERNATIONAL COMPANY LIMITED | (blank) | TRIM | 155 | 0.6 | 13 | (blank) |  |  |  |  |  | 273 |  |  |  |  | 1132.17 |  |  |  |  |  |  |  |  |  | 1405.17
[NAME] | S14024097763 | 2024-04-29 00:00:00 | AIR | KOREA-SEOUL | SRI LANKA-COLOMBO | 2024-04-21 00:00:00 | VISIONWORLD CO., LTD | W24-3018-6 | CF24-0017 | 2767 | 6.859 | 33 | (blank) |  |  |  |  |  |  |  |  |  |  | 3559.608 | 1021.8 |  |  |  |  |  | 65395.278 |  |  | 69976.686
 | S14024096034 | 2024-04-29 00:00:00 | AIR | KOREA-SEOUL | SRI LANKA-COLOMBO | 2024-04-20 00:00:00 | VISIONWORLD CO., LTD | W24-3018-5 | CF24-0017 | 2985 | 7.834 | 34 | (blank) |  |  |  |  |  |  |  |  |  |  | 3695.64 | 1021.8 |  |  |  |  |  | 70547.48999999999 |  |  | 75264.93
 | S14024094648 | 2024-04-29 00:00:00 | AIR | KOREA-SEOUL | SRI LANKA-COLOMBO | 2024-04-19 00:00:00 | VISIONWORLD CO., LTD | W24-3018-4 | CF24-0017 | 2752 | 7.189 | 33 | (blank) |  |  |  |  |  |  |  |  |  |  | 3550.248 | 1021.8 |  |  |  |  |  | 65040.768 |  |  | 69612.826
 | S14024092967 | 2024-04-29 00:00:00 | AIR | KOREA-SEOUL | SRI LANKA-COLOMBO | 2024-04-17 00:00:00 | VISIONWORLD CO., LTD | W24-3018-2 | CF24-0017 | 2874 | 7.502 | 33 | (blank) |  |  |  |  |  |  |  |  |  |  | 3626.376 | 1021.8 |  |  |  |  |  | 67924.116 |  |  | 72572.292
M & R Forwarding (HK) Ltd. | DN00900195 | 2024-04-16 00:00:00 | (blank) | INDIA-MANI | CHINA-GUANGZHOU | 2024-04-09 00:00:00 | LANIFICIO NOVA FIDES S.P.A. | FE203 | CF24-0006 | 1000 | 5.999 | ROL | (blank) | 4254 | 1516.9764 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9358.8 |  |  | 15129.7764
 | DN00902319 | 2024-04-16 00:00:00 | (blank) | INDIA-MANI | CHINA-GUANGZHOU | 2024-04-09 00:00:00 | LANIFICIO NOVA FIDES S.P.A. | FE203 | CF24-0006 | 1000 | 5.999 | ROL | (blank) |  |  |  |  |  |  |  |  |  |  | 1322.64 | 1653.3 |  |  |  |  |  |  |  |  | 2975.940000000001
CHU KONG TRANSHIPMENT & LOGISTICS CO.,LTD | DCKT2404050097 | 2024-04-05 00:00:00 | SEA | CHINA-GUANGZHOU | CHINA-HONG KONG | (blank) | (blank) | (blank) | TRIM | 451.1 | 3.5 | 30 | (blank) |  |  |  |  |  |  |  |  |  | 718 |  |  |  |  |  |  |  |  |  |  | 718
 | DCKT2404160185 | 2024-04-16 00:00:00 | SEA | CHINA-GUANGZHOU | CHINA-HONG KONG | (blank) | (blank) | (blank) | TRIM | 37.5 | 0.2 | 1 | (blank) |  |  |  |  |  |  |  |  |  | 525 |  |  |  |  |  |  |  |  |  |  | 525
 | DCKT2404160186 | 2024-04-16 00:00:00 | SEA | CHINA-GUANGZHOU | CHINA-HONG KONG | (blank) | (blank) | (blank) | TRIM | 1262.5 | 6.7 | 61 | (blank) |  |  |  |  |  |  |  |  |  | 1118 |  |  |  |  |  |  |  |  |  |  | 1118
LOK SIU TRANSPORTATION | 2454 | 2024-02-28 00:00:00 | TRUCK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 545 |  |  |  |  |  |  |  |  |  |  | 545
 | 2458 | 2024-04-05 00:00:00 | TRUCK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 745 |  |  |  |  |  |  |  |  |  |  | 745
 | 2459 | 2024-04-16 00:00:00 | TRUCK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 615 |  |  |  |  |  |  |  |  |  |  | 615
 | 2460 | 2024-04-23 00:00:00 | TRUCK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 785 |  |  |  |  |  |  |  |  |  |  | 785
TAC Logistics (HK) LTD. | 69790 | 2024-03-11 00:00:00 | SEA | CHINA-GUANGZHOU | CHINA-HONG KONG | (blank) | (blank) | (blank) | TRIM | 433 | 1.14 | 34 | (blank) | 1556.5 | 832.64 |  |  |  | 233.23 |  |  |  |  | 1669.02 |  |  |  |  |  |  |  |  |  | 4291.39
 | 69791 | 2024-03-18 00:00:00 | SEA | CHINA-GUANGZHOU | CHINA-HONG KONG | (blank) | (blank) | (blank) | TRIM | 1179.39 | 7.22 | 38 | (blank) | 1714.4 | 2085.51 |  |  |  | 1489.32 |  |  |  |  |  |  |  |  |  |  |  | 2378.99 |  |  | 7668.220000000001
 | 69792 | 2024-03-31 00:00:00 | SEA | CHINA-GUANGZHOU | CHINA-HONG KONG | (blank) | (blank) | (blank) | TRIM | 465.29 | 2.69 | 52 | (blank) | 950 | 1144.83 |  |  |  | 546.23 |  |  |  |  | 2376.809999999999 |  |  |  |  |  |  |  |  |  | 5017.869999999999
Grand Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 8474.9 | 5579.9564 |  |  |  | 13110.78 |  |  |  | 5051 | 29443.092 | 9952.5 |  |  |  |  |  | 280645.4419999999 |  |  | 352257.6804