Spreadsheet: 851342d1701550625-match-data-in-two-worksheets-and-copy-2-columns-accross-sample
Sheet: Worksheet1

Date of transaction | Transaction | Amount (OMR) VAT | Declaration Number | As Per Import Purchase Log (JDE) | 06.Imports  [NAME] Number | Name Of The Supplier | Location (Country) Of The Supplier -  Place Of Supply ,Along With Complete Address | Location (Country) Of The [NAME] | Tax Code | Nature Of Supply | Invoice Number | Date Of Invoice | Invoice Value | Rate Of  Exchange | Quantity | [NAME] | Value Of Purchase In OMR | Date Of Imports Of Goods | [NAME] Number | [NAME]  (YES/NO/Suspended) | Value Of Goods As Per Customs | Customs Duty | Excise Tax | Taxable Value Of Goods As Per Customers(CIF+Customs Duty+Excise Tax) | [NAME] ( Import Log) | Company | GL Date | Invoice Type | Invoice Number | Purchase Order Type | [NAME] | [NAME] | Value as per BOE (CIF) | VAT 5% | Diff
2023-07-04 00:00:00 | BOOKING | 22.667 | DECIMP0507238515005 | REI
2023-07-06 00:00:00 | BOOKING | 803.545 | DECIMP0607238515779 | REI
2023-07-12 00:00:00 | BOOKING | 39.828 | DECIEC2707238579971 | REI
2023-07-13 00:00:00 | BOOKING | 181.616 | DECIMP0907238524256 | REI |  | [NAME]. Ltd. | PENANG | MALAYSIA | IMPGP | IMPGP - Import goods VAT postponement | 10013_21 | 2023-06-21 00:00:00 | USD 9434.6 |  | 46 |  | OMR 3632.321 | 2023-07-09 00:00:00 |  | Deferred | 3632.321 |  |  |  |  | REI OIL AND GAS PROCESS SERVICES LLC |  |  |  |  |  | [NAME] 4FT GRP Linear | 3632.321
2023-07-14 00:00:00 | BOOKING | 37.322 | DECIMP1707238549763 | REI
2023-07-15 00:00:00 | BOOKING | 96.105 | DECIMP1407238542192 | REI
2023-07-16 00:00:00 | BOOKING | 54.555 | DECREX1707238551449 | REI
2023-07-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U-PO000731
2023-07-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U-PO000714
2023-07-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U-PO000731
2023-07-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U-PO000587
2023-07-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U-PO000552
2023-07-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U-PO000288
2023-07-18 00:00:00 | BOOKING | 755.321 | DECIMP1807238552861 | REI
2023-07-21 00:00:00 | BOOKING | 194.061 | DECIMP2007238560859 | REI
2023-07-23 00:00:00 | BOOKING | 1.011 | DECIMP2307238565487 | REI
2023-07-25 00:00:00 | BOOKING | 131.842 | DECIMP2607238579463 | REI
2023-07-26 00:00:00 | BOOKING | 493.259 | DECIMP2607238575705 | REI
2023-07-27 00:00:00 | BOOKING | 166.955 | DECIMP2607238579075 | REI
2023-07-27 00:00:00 | BOOKING | 41.482 | DECIEC2707238579971 | REI
2023-07-30 00:00:00 | BOOKING | 78.992 | DECIEC3007238587819 | REI
2023-08-01 00:00:00 | BOOKING | 121.573 | DECIMP2207238564096 | REI
2023-08-03 00:00:00 | BOOKING | 179.424 | DECIMP0208238600306 | REI
2023-08-04 00:00:00 | BOOKING | 62.916 | DECIMP0308238603801 | REI
2023-08-05 00:00:00 | BOOKING | 3.705 | DECIEC0508238607387 | REI
2023-08-06 00:00:00 | BOOKING | 58.583 | DECIMP0508238608082 | REI
2023-08-11 00:00:00 | BOOKING | 109.744 | DECIMP1008238626869 | REI
2023-08-13 00:00:00 | BOOKING | 302.601 | DECIMP1008238624968 | REI
2023-08-14 00:00:00 | BOOKING | 258.946 | DECIEC1408238636328 | REI
2023-08-15 00:00:00 | BOOKING | 7145.119 | DECIMP1508238640822 | REI |  | PARKER HANNIFIN CORP. | MINERAL WELLS | U.S.A. | IMPGP | IMPGP - Import goods VAT postponement | 28800315 OP-1 | 2023-10-02 00:00:00 |  |  | 896.31 |  | OMR 2370.087 | 2023-10-10 00:00:00 |  | Deferred | 2370.087 |  |  |  |  | REI OIL AND GAS PROCESS SERVICES LLC |  |  |  |  |  | ANTHRACITE COAL | 2370.087
2023-08-16 00:00:00 | BOOKING | 554.661 | DECIMP1608238642952 | REI
2023-08-17 00:00:00 | BOOKING | 422.357 | DECIMP1608238645009 | REI
2023-08-19 00:00:00 | BOOKING | 89.736 | DECIMP1808238649751 | REI
2023-08-20 00:00:00 | BOOKING | 583.846 | DECIMP2008238655225 | REI
2023-08-21 00:00:00 | BOOKING | 750.198 | DECIEC2008238655999 | REI
2023-08-21 00:00:00 | BOOKING | 314.108 | DECIMP2108238659734 | REI
2023-08-26 00:00:00 | BOOKING | 33.822 | DECIMP2508238672784 | REI
2023-08-27 00:00:00 | BOOKING | 24.663 | DECIEC2608238674143 | REI
2023-08-28 00:00:00 | BOOKING | 45.021 | DECIEC2708238678837 | REI
2023-08-29 00:00:00 | BOOKING | 129.831 | DECIEC2507238572043 | REI
2023-08-29 00:00:00 | BOOKING | 811.331 | DECIMP2808238681600 | REI
2023-08-29 00:00:00 | BOOKING | 358.312 | DECIMP2808238681770 | REI
2023-08-31 00:00:00 | BOOKING | 22.118 | DECIEC3108238690551 | REI
2023-09-07 00:00:00 | BOOKING | 157.848 | DECIEC0609238711210 | REI
2023-09-12 00:00:00 | BOOKING | 4851 | DECIMP1209238728704 | REI |  | WEG Middle East FZE | DUBAI | UNITED ARAB EMIRATES | IMPGP | IMPGP - Import goods VAT postponement | N/A | 2022-12-05 00:00:00 | USD 252000 |  | 2 |  | OMR 97020 | 2023-09-12 00:00:00 |  | Deferred | 97020 |  |  |  |  | REI OIL AND GAS PROCESS SERVICES LLC |  |  |  |  |  | AC MOTOR | 97020
2023-09-17 00:00:00 | BOOKING | 216.827 | DECIMP1609238744068 | REI
2023-09-23 00:00:00 | BOOKING | 119.456 | DECIEC2309238765304 | REI
2023-09-23 00:00:00 | BOOKING | 104.297 | [NAME] | REI
2023-09-24 00:00:00 | BOOKING | 9.5 | DECIMP2409238768058 | REI
2023-09-24 00:00:00 | BOOKING | 9.5 | DECIMP2409238768058 | REI