Spreadsheet: 755917d1637178874-identifying-possible-duplicate-cells-in-column-and-adding-duplicates-in-new-column-for-cla-gstr-2a-reco
Sheet: PTable

 |  |  |  |  |  |  |  |  | Remarks | Values
Difference in |  |  |  |  |  |  |  |  | As per GSTR-2A |  |  |  |  | As per Tally
Taxable Value | IGST | CGST | SGST | Invoice Value |  |  | GST No. | Invoice Number | Taxable Value | IGST | CGST | SGST | Sum of Inv. Value | Taxable Value | IGST | CGST | SGST | Sum of Inv. Value
 |  |  |  |  |  |  | 27AAACE6898B1ZI | 21-22/056/CWP |  |  |  |  |  | 7500 |  | 675 | 675 | 8850
 |  |  |  |  |  |  |  | 056/CWP | 7500 |  | 675 | 675 | 8850
 |  |  |  |  |  |  | 27AAAJM0005H1ZO | 2122/ID-1116/CWP | 59000 |  | 1475 | 1475 | 61950 | 59000 |  | 1475 | 1475 | 61950
 |  |  |  |  |  |  |  | 2122/ID-1131/CWP |  |  |  |  |  | 1000 |  | 25 | 25 | 1050
 |  |  |  |  |  |  | 27AAAPC8227D1Z6 | 2122/ID-1105/CWP | 1200 |  | 108 | 108 | 1416 | 1200 |  | 108 | 108 | 1416
 |  |  |  |  |  |  | 27AADFH3259H1ZD | 21-22/058/CWP |  |  |  |  |  | 36698.4 |  | 3302.86 | 3302.86 | 43304
 |  |  |  |  |  |  |  | 2122/ID-1095/CWP | 17298.36 |  | 1556.85 | 1556.85 | 20412 | 17298.36 |  | 1556.85 | 1556.85 | 20412
 |  |  |  |  |  |  |  | 2122/ID-1134/CWP | 17298.36 |  | 1556.85 | 1556.85 | 20412
 |  |  |  |  |  |  |  | 058/CWP | 36698.4 |  | 3302.86 | 3302.86 | 43304
 |  |  |  |  |  |  |  | 108/CWP | 36698.4 |  | 3302.86 | 3302.86 | 43304
 |  |  |  |  |  |  | 27AADPK7120N1ZK | 2122/ID-1140/CWP | 2700 |  | 67.5 | 67.5 | 2835 | 2700 |  | 67.5 | 67.5 | 2835
 |  |  |  |  |  |  | 27AAGFH1642D2ZQ | 21-22/085/CWP |  |  |  |  |  | 13055 |  | 1174.95 | 1174.95 | 15400
 |  |  |  |  |  |  |  | 21-22/094/CWP |  |  |  |  |  | 9325 |  | 839.25 | 839.25 | 11004
 |  |  |  |  |  |  |  | 085/CWP | 13055 |  | 1174.95 | 1174.95 | 12334
 |  |  |  |  |  |  |  | 094/CWP | 9325 |  | 839.25 | 839.25 | 11004
 |  |  |  |  |  |  | 27AAHPR4923L1Z8 | 2122/ID-1138/CWP | 2600 |  | 65 | 65 | 2730 | 2600 |  | 65 | 65 | 2730
 |  |  |  |  |  |  | 27AAJCM4639H1Z6 | 21-22/103/CWP |  |  |  |  |  | 165000 |  | 14850 | 14850 | 194700
 |  |  |  |  |  |  |  | 103/CWP | 165000 |  | 14850 | 14850 | 194700
 |  |  |  |  |  |  | 27AALHV9985Q1ZJ | 21-22/066/CWP |  |  |  |  |  | 65240 |  | 5871.6 | 5871.6 | 77000
 |  |  |  |  |  |  |  | 21-22/111/CWP |  |  |  |  |  | 1864 |  | 167.76 | 167.76 | 2200
 |  |  |  |  |  |  |  | 111/CWP | 1864 |  | 167.76 | 167.76 | 2200
 |  |  |  |  |  |  | 27AAQFC3670A1ZK | 21-22/071/CWP |  |  |  |  |  | 37300 |  | 3357 | 3357 | 44000
 |  |  |  |  |  |  |  | 2122/ID-1113/CWP | 30000 |  | 2700 | 2700 | 35400 | 30000 |  | 2700 | 2700 | 35400
 |  |  |  |  |  |  |  | 071/CWP | 37300 |  | 3357 | 3357 | 44000
 |  |  |  |  |  |  | 27AASFR2221G1Z6 | 21-22/068/CWP |  |  |  |  |  | 145570.32 |  | 12708.29 | 12708.29 | 166620
 |  |  |  |  |  |  |  | 21-22/086/CWP |  |  |  |  |  | 146793.6 |  | 12815.08 | 12815.08 | 168020
 |  |  |  |  |  |  |  | 21-22/112/CWP |  |  |  |  |  | 146793.6 |  | 12815.08 | 12815.08 | 168020
 |  |  |  |  |  |  |  | 2122/ID-1118/CWP | 145754.7 |  | 12724.38 | 12724.38 | 166831 | 145754.7 |  | 12724.38 | 12724.38 | 166831
 |  |  |  |  |  |  |  | 068/CWP | 145570.32 |  | 12708.29 | 12708.29 | 166620
 |  |  |  |  |  |  |  | 086/CWP | 146793.6 |  | 12815.08 | 12815.08 | 168020
 |  |  |  |  |  |  |  | 112/CWP | 146793.6 |  | 12815.08 | 12815.08 | 168020
 |  |  |  |  |  |  | 27AAUPB1182G1ZP | 21-22/063/CWP |  |  |  |  |  | 36698.4 |  | 3302.86 | 3302.86 | 43304
 |  |  |  |  |  |  |  | 21-22/091/CWP |  |  |  |  |  | 36698.4 |  | 3302.86 | 3302.86 | 43304
 |  |  |  |  |  |  |  | 2122/ID-1127/CWP | 28830.6 |  | 2594.75 | 2594.75 | 34020 | 28830.6 |  | 2594.75 | 2594.75 | 34020
 |  |  |  |  |  |  |  | 063/CWP | 36698.4 |  | 3302.86 | 3302.86 | 43304
 |  |  |  |  |  |  |  | 091/CWP | 36698.4 |  | 3302.86 | 3302.86 | 43304
 |  |  |  |  |  |  | 27AAVPU4681J1ZO | 21-22/104/CWP |  |  |  |  |  | 5595 |  | 503.55 | 503.55 | 6600
 |  |  |  |  |  |  |  | 104/CWP | 5595 |  | 503.55 | 503.55 | 6600
 |  |  |  |  |  |  | 27AAWHR8752G1ZA | 21-22/113/CWP |  |  |  |  |  | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  |  | 2122/ID-1122/CWP | 18000 |  | 450 | 450 | 18900 | 18000 |  | 450 | 450 | 18900
 |  |  |  |  |  |  |  | 2122/ID-1128/CWP | 1300 |  | 32.5 | 32.5 | 1365 | 1300 |  | 32.5 | 32.5 | 1365
 |  |  |  |  |  |  |  | 2122/ID-1145/CWP | 15772 |  | 394.3 | 394.3 | 16560.6 | 15772 |  | 394.3 | 394.3 | 16560.6
 |  |  |  |  |  |  |  | 113/CWP | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  | 27AAWPM6001H1ZI | 21-22/065/CWP |  |  |  |  |  | 37291 |  | 3356.19 | 3356.19 | 44003
 |  |  |  |  |  |  |  | 21-22/092/CWP |  |  |  |  |  | 20515 |  | 1846.35 | 1846.35 | 24200
 |  |  |  |  |  |  |  | 21-22/101/CWP |  |  |  |  |  | 7339.68 |  | 660.57 | 660.57 | 8661
 |  |  |  |  |  |  |  | 2122/ID-1101/CWP | 53885 |  | 3078.73 | 3078.73 | 60042 | 53885 |  | 3078.73 | 3078.73 | 60042
 |  |  |  |  |  |  |  | 2122/ID-1115/CWP | 27720 |  | 693 | 693 | 29106 | 27720 |  | 693 | 693 | 29106
 |  |  |  |  |  |  |  | 2122/ID-1126/CWP | 9720 |  | 243 | 243 | 10206 | 9720 |  | 243 | 243 | 10206
 |  |  |  |  |  |  |  | 2122/ID-1136/CWP | 60960 |  | 1423.99 | 1423.99 | 59808 | 60960 |  | 1423.99 | 1423.99 | 59808
 |  |  |  |  |  |  |  | 065/CWP | 37291 |  | 3356.19 | 3356.19 | 44003
 |  |  |  |  |  |  |  | 092/CWP | 20515 |  | 1846.35 | 1846.35 | 24200
 |  |  |  |  |  |  |  | 101/CWP | 7339.68 |  | 660.57 | 660.57 | 8661
 |  |  |  |  |  |  | 27ABCPJ9807F1ZN | 21-22/075/CWP |  |  |  |  |  | 7339.68 |  | 660.57 | 660.57 | 8661
 |  |  |  |  |  |  |  | 21-22/095/CWP |  |  |  |  |  | 7339.68 |  | 660.57 | 660.57 | 8661
 |  |  |  |  |  |  |  | 2122/ID-1110/CWP | 5766.12 |  | 518.95 | 518.95 | 6804 | 5766.12 |  | 518.95 | 518.95 | 6804
 |  |  |  |  |  |  |  | 2122/ID-1130/CWP | 5766.12 |  | 518.95 | 518.95 | 6804 | 5766.12 |  | 518.95 | 518.95 | 6804
 |  |  |  |  |  |  |  | 075/CWP | 7339.68 |  | 660.57 | 660.57 | 8661
 |  |  |  |  |  |  | 27ABCPJ9807F1ZZ | 095/CWP | 7339.68 |  | 660.57 | 660.57 | 8661
 |  |  |  |  |  |  | 27ABFFM7712H1Z6 | 2122/ID-1102/CWP | 5200 |  | 468 | 468 | 6136 | 5200 |  | 468 | 468 | 6136
 |  |  |  |  |  |  |  | 2122/ID-1121/CWP | 124141 |  | 231 | 231 | 1575 | 1500 |  | 37.5 | 37.5 | 1575
 |  |  |  |  |  |  | 27ADNPG9615R1ZO | 21-22/073/CWP |  |  |  |  |  | 18349.2 |  | 1651.43 | 1651.43 | 21652
 |  |  |  |  |  |  |  | 073/CWP | 18349.2 |  | 4525 | 1651.43 | 21652
 |  |  |  |  |  |  | 27AEAPC0213R1ZR | 21-22/099/CWP |  |  |  |  |  | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  |  | 099/CWP | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  | 27AEEPS3602Q1Z2 | 21-22/081/CWP |  |  |  |  |  | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  |  | 21-22/090/CWP |  |  |  |  |  | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  |  | 2122/ID-1120/CWP | 5766.12 |  | 518.95 | 518.95 | 6804 | 5766.12 |  | 518.95 | 518.95 | 6804
 |  |  |  |  |  |  |  | 081/CWP | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  |  | 090/CWP | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  |  | 109/CWP | 7460 |  | 671.4 | 671.4 | 8803
 |  |  |  |  |  |  | 27AFEPJ4271M1Z6 | 21-22/096/CWP |  |  |  |  |  | 7339.68 |  | 660.57 | 660.57 | 8661
 |  |  |  |  |  |  |  | 2122/ID-1106/CWP | 4650 |  | 116.25 | 116.25 | 4883 | 4650 |  | 116.25 | 116.25 | 4883
 |  |  |  |  |  |  |  | 2122/ID-1114/CWP | 4650 |  | 116.25 | 116.25 | 4883 | 4650 |  | 116.25 | 116.25 | 4883
 |  |  |  |  |  |  |  | 2122/ID-1129/CWP | 13373.64 |  | 709.14 | 709.14 | 14792 | 13373.64 |  | 709.14 | 709.14 | 14792
 |  |  |  |  |  |  |  | 2122/ID-1144/CWP | 4394 |  | 109.85 | 109.85 | 4614 | 4394 |  | 109.85 | 109.85 | 4614
 |  |  |  |  |  |  |  | 096/CWP | 7339.68 |  | 660.57 | 660.57 | 8661
 |  |  |  |  |  |  | 27AIPPM9171K1ZG | 21-22/087/CWP |  |  |  |  |  | 37300 |  | 3357 | 3357 | 44000
 |  |  |  |  |  |  |  | 2122/ID-1142/CWP | 5080 |  | 231 | 231 | 5542 | 5080 |  | 231 | 231 | 5542
 |  |  |  |  |  |  |  | 087/CWP | 37300 |  | 3357 | 3357 | 44000
 |  |  |  |  |  |  | 27AKEPA0198B1ZP | 21-22/062/CWP |  |  |  |  |  | 20504 |  | 1845.36 | 1845.36 | 24200
 |  |  |  |  |  |  |  | 062/CWP | 20504 |  | 1845.36 | 1845.36 | 24200
 |  |  |  |  |  |  | 27AMUPS4456Q1ZR | 21-22/079/CWP |  |  |  |  |  | 18349.2 |  | 1651.43 | 1651.43 | 21652
 |  |  |  |  |  |  |  | 079/CWP | 18349.2 |  | 1651.43 | 1651.43 | 21652
 |  |  |  |  |  |  | 27ANVPM5353L1Z6 | 21-22/100/CWP |  |  |  |  |  | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  |  | 100/CWP | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  | 27AOGPP2932N1ZH | 2122/ID-1111/CWP | 11532.24 |  | 1037.9 | 1037.9 | 13608 | 11532.24 |  | 1037.9 | 1037.9 | 13608
 |  |  |  |  |  |  | 27APZPG2567E1ZH | 21-22/057/CWP |  |  |  |  |  | 18650 |  | 1678.5 | 1678.5 | 22000
 |  |  |  |  |  |  |  | 2122/ID-1093/CWP |  |  |  |  |  | 67.79 |  | 6.1 | 6.1 | 80
 |  |  |  |  |  |  |  | 057/CWP | 18650 |  | 1678.5 | 1678.5 | 22000
 |  |  |  |  |  |  | 27AUUPP2734L1ZV | 21-22/077/CWP |  |  |  |  |  | 22890 |  | 2060.1 | 2060.1 | 27010
 |  |  |  |  |  |  |  | 21-22/078/CWP |  |  |  |  |  | 38150 |  | 3433.5 | 3433.5 | 45000
 |  |  |  |  |  |  |  | 21-22/106/CWP |  |  |  |  |  | 28994 |  | 2609.46 | 2609.46 | 34213
 |  |  |  |  |  |  |  | 077/CWP | 22890 |  | 2060.1 | 2060.1 | 27010
 |  |  |  |  |  |  |  | 078/CWP | 38150 |  | 3433.5 | 3433.5 | 45000
 |  |  |  |  |  |  |  | 106/CWP | 28994 |  | 2609.46 | 2609.46 | 34213
 |  |  |  |  |  |  | 27AVXPJ7212P1ZP | 21-22/059/CWP |  |  |  |  |  | 77356 |  | 6962.04 | 6962.04 | 91280
 |  |  |  |  |  |  |  | 059/CWP | 77356 |  | 6962.04 | 6962.04 | 91280
 |  |  |  |  |  |  | 27AXZPD4573D1Z4 | 21-22/083/CWP |  |  |  |  |  | 51000 |  | 4590 | 4590 | 60180
 |  |  |  |  |  |  |  | 21-22/110/CWP |  |  |  |  |  | 10000 |  | 900 | 900 | 11800
 |  |  |  |  |  |  |  | 083/CWP | 51000 |  | 4590 | 4590 | 60180
 |  |  |  |  |  |  |  | 110/CWP | 10000 |  | 900 | 900 | 11800
 |  |  |  |  |  |  | 27BNTPK0027J1ZS | 21-22/105/CWP |  |  |  |  |  | 14487.5 |  | 1303.88 | 1303.88 | 17095
 |  |  |  |  |  |  |  | 105/CWP | 14487.5 |  | 1303.88 | 1303.88 | 17095
 |  |  |  |  |  |  | 27BRXPP5853K1ZP | 21-22/074/CWP |  |  |  |  |  | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  |  | 2122/ID-1109/CWP | 10416.12 |  | 635.2 | 635.2 | 11687 | 10416.12 |  | 635.2 | 635.2 | 11687
 |  |  |  |  |  |  |  | 2122/ID-1112/CWP | 2700 |  | 67.5 | 234 | 2835 | 2700 |  | 67.5 | 67.5 | 2835
 |  |  |  |  |  |  |  | 2122/ID-1141/CWP | 13500 |  | 337.5 | 337.5 | 14175 | 13500 |  | 337.5 | 337.5 | 14175
 |  |  |  |  |  |  |  | 074/CWP | 3669.84 |  | 330.29 | 330.29 | 4330
 |  |  |  |  |  |  | 27BVYPD7205E1ZF | 21-22/088/CWP |  |  |  |  |  | 24000 |  | 2160 | 2160 | 28320
 |  |  |  |  |  |  |  | 088/CWP | 24000 |  | 2160 | 2160 | 28320
 |  |  |  |  |  |  | 27BWZPS3537N1Z9 | 21-22/107/CWP |  |  |  |  |  | 6600 |  | 594 | 594 | 7788
 |  |  |  |  |  |  |  | 107/CWP | 6600 |  | 594 | 594 | 7788
 |  |  |  |  |  |  | 27EBGPP9611B1ZN_x000D_ | 21-22/076/CWP |  |  |  |  |  | 5000 |  | 450 | 450 | 5900
 |  |  |  |  |  |  |  | 21-22/080/CWP |  |  |  |  |  | 30000 |  | 2700 | 2700 | 35400
 |  |  |  |  |  |  |  | 21-22/089/CWP |  |  |  |  |  | 50000 |  | 4500 | 4500 | 59000
 |  |  |  |  |  |  |  | 21-22/093/CWP |  |  |  |  |  | 95000 |  | 8550 | 8550 | 112100
 |  |  |  |  |  |  |  | 21-22/102/CWP |  |  |  |  |  | 8000 |  | 720 | 720 | 9440
 |  |  |  |  |  |  |  | 076/CWP | 5000 |  | 450 | 450 | 5900
 |  |  |  |  |  |  |  | 080/CWP | 30000 |  | 2700 | 2700 | 35400
 |  |  |  |  |  |  |  | 089/CWP | 50000 |  | 4500 | 4500 | 59000
 |  |  |  |  |  |  |  | 093/CWP | 95000 |  | 8550 | 8550 | 112100
 |  |  |  |  |  |  |  | 102/CWP | 8000 |  | 720 | 720 | 9440
 |  |  |  |  |  |  | 27FQEPS844F1ZH | 21-22/060/CWP |  |  |  |  |  | 71200 |  | 6408 | 6408 | 84016
 |  |  |  |  |  |  |  | 21-22/061/CWP |  |  |  |  |  | 20 |  | 1.8 | 1.8 | 24
 |  |  |  |  |  |  |  | 21-22/069/CWP |  |  |  |  |  | 43610 |  | 3924.9 | 3924.9 | 51460
 |  |  |  |  |  |  |  | 21-22/082/CWP |  |  |  |  |  | 1865 |  | 167.85 | 167.85 | 2201
 |  |  |  |  |  |  |  | 2122/ID-1098/CWP | 215 |  | 5.38 | 5.38 | 226 | 215 |  | 5.38 | 5.38 | 226
 |  |  |  |  |  |  |  | 2122/ID-1117/CWP | 504 |  | 12.6 | 12.6 | 529 | 504 |  | 12.6 | 12.6 | 529
 |  |  |  |  |  |  |  | 060/CWP | 71200 |  | 6408 | 6408 | 84016
 |  |  |  |  |  |  |  | 061/CWP | 20 |  | 1.8 | 1.8 | 24
 |  |  |  |  |  |  |  | 069/CWP | 43610 |  | 3924.9 | 3924.9 | 51460
 |  |  |  |  |  |  |  | 082/CWP | 1865 |  | 167.85 | 167.85 | 2201
 |  |  |  |  |  |  | 27IPIPK0388N2Z3 | 21-22/064/CWP |  |  |  |  |  | 100000 |  | 9000 | 9000 | 118000
 |  |  |  |  |  |  |  | 21-22/070/CWP |  |  |  |  |  | 65000 |  | 5850 | 5850 | 76700
 |  |  |  |  |  |  |  | 21-22/084/CWP |  |  |  |  |  | 50000 |  | 4500 | 4500 | 59000
 |  |  |  |  |  |  |  | 21-22/098/CWP |  |  |  |  |  | 20000 |  | 1800 | 1800 | 23600
 |  |  |  |  |  |  |  | 2122/ID-1100/CWP | 900 |  | 81 | 81 | 1062 | 900 |  | 81 | 81 | 1062
 |  |  |  |  |  |  |  | 064/CWP | 100000 |  | 9000 | 9000 | 118000
 |  |  |  |  |  |  |  | 070/CWP | 65000 |  | 5850 | 5850 | 76700
 |  |  |  |  |  |  |  | 084/CWP | 50000 |  | 4500 | 4500 | 59000
 |  |  |  |  |  |  |  | 098/CWP | 20000 |  | 1800 | 1800 | 23600