Spreadsheet: 800814d1665901004-facing-date-error-in-formula-when-new-data-is-pasted-formula-mistake-from-n-to-r-to-correct
Sheet: B2B

Goods and Services Tax  - GSTR 2A
Taxable inward supplies received from registered persons
[NAME] of supplier | Trade/Legal name of the [NAME] | Invoice details |  |  |  | Place of supply | Supply Attract Reverse Charge | Rate (%) | Taxable Value (₹) | Tax Amount |  |  |  | GSTR-1/IFF/GSTR-5 Filing Status | GSTR-1/IFF/GSTR-5 Filing Date | GSTR-1/IFF/GSTR-5 Filing Period | GSTR-3B Filing Status | Amendment made, if any | Tax Period in which Amended | Effective date of cancellation | Source | IRN | IRN date
 |  | Invoice number | Invoice type | Invoice Date | Invoice Value (₹) |  |  |  |  | Integrated Tax  (₹) | Central Tax (₹) | State/UT tax (₹) | Cess  (₹)
27AAEFB7230K1ZG | April | 175/GST | R | 21-04-2022 | 92465 | Karnataka | N | 5 | 88062 | 4403.1 | 100 | 0 | 0 | Y | 10-May-22 | Apr-22 | N
27AAEFB7230K1ZG | April | 175/GST-Total | R | 21-04-2022 | 92465 | Karnataka | N | - | 88062 | 4403.1 | 0 | 0 | 0 | Y | 10-May-22 | Apr-22 | N
29AAGCR3967G1ZX | November | BL/159/22-23 | R | 20-04-2022 | 12486 | Karnataka | N | 18 | 10581 | 0 | 952.29 | 952.29 | 0 | Y | 11-May-22 | Apr-22 | N
29AAGCR3967G1ZX | November | BL/159/22-23-Total | R | 20-04-2022 | 12486 | Karnataka | N | - | 10581 | 0 | 952.29 | 952.29 | 0 | Y | 11-May-22 | Apr-22 | N
29AAGCR3967G1ZX | November | BL/4/22-23 | R | 05-04-2022 | 12449 | Karnataka | N | 18 | 10550 | 0 | 949.5 | 949.5 | 0 | Y | 11-May-22 | Apr-22 | N
29AAGCR3967G1ZX | November | BL/4/22-23-Total | R | 05-04-2022 | 12449 | Karnataka | N | - | 10550 | 0 | 949.5 | 949.5 | 0 | Y | 11-May-22 | Apr-22 | N
06AUMPK7295D2ZA | March | 2325 | R | 13-04-2022 | 59658 | Karnataka | N | 5 | 56817 | 2840.85 | 0 | 0 | 0 | Y | 07-May-22 | Apr-22 | N
06AUMPK7295D2ZA | March | 2325-Total | R | 13-04-2022 | 59658 | Karnataka | N | - | 56817 | 2840.85 | 0 | 0 | 0 | Y | 07-May-22 | Apr-22 | N
29ADDFS6267R1Z1 | Tuesday | SL/22-23/0085 | R | 21-04-2022 | 8320 | Karnataka | N | 12 | 7500 | 0 | 450 | 450 | 0 | Y | 11-May-22 | Apr-22 | N
29ADDFS6267R1Z1 | Tuesday | SL/22-23/0085 | R | 21-04-2022 | 8320 | Karnataka | N | 18 | 60 | 0 | 5.4 | 5.4 | 0 | Y | 11-May-22 | Apr-22 | N
29ADDFS6267R1Z1 | Tuesday | SL/22-23/0085-Total | R | 21-04-2022 | 8320 | Karnataka | N | - | 7560 | 0 | 455.4 | 455.4 | 0 | Y | 11-May-22 | Apr-22 | N
29AHXPT9340A1ZQ | Thursday | 10 | R | 05-04-2022 | 11167 | Karnataka | N | 12 | 9970.75 | 0 | 598.25 | 598.25 | 0 | Y | 11-May-22 | Apr-22 | N
29AHXPT9340A1ZQ | Thursday | 10-Total | R | 05-04-2022 | 11167 | Karnataka | N | - | 9970.75 | 0 | 598.25 | 598.25 | 0 | Y | 11-May-22 | Apr-22 | N
29AHXPT9340A1ZQ | Thursday | 127 | R | 13-04-2022 | 2382 | Karnataka | N | 5 | 1549.89 | 0 | 38.75 | 38.75 | 0 | Y | 11-May-22 | Apr-22 | N
29AHXPT9340A1ZQ | Thursday | 127 | R | 13-04-2022 | 2382 | Karnataka | N | 12 | 674.1 | 0 | 40.45 | 40.45 | 0 | Y | 11-May-22 | Apr-22 | N
29AHXPT9340A1ZQ | Thursday | 127-Total | R | 13-04-2022 | 2382 | Karnataka | N | - | 2223.99 | 0 | 79.2 | 79.2 | 0 | Y | 11-May-22 | Apr-22 | N
29BBSPM7598F1ZN | Venus | SS/21-22/898 | R | 13-08-2021 | 21181 | Karnataka | N | 5 | 20172.36 | 0 | 504.31 | 504.31 | 0 | Y | 11-Sep-21 | Aug-21 | N
29BBSPM7598F1ZN | Venus | SS/21-22/898-Total | R | 13-08-2021 | 21181 | Karnataka | N | - | 20172.36 | 0 | 504.31 | 504.31 | 0 | Y | 11-Sep-21 | Aug-21 | N
29ANEPM3599F1ZK | Mercury | TR/21-22/575 | R | 09-08-2021 | 7094 | Karnataka | N | 5 | 6756 | 0 | 168.9 | 168.9 | 0 | Y | 10-Sep-21 | Aug-21 | N
29ANEPM3599F1ZK | Mercury | TR/21-22/575-Total | R | 09-08-2021 | 7094 | Karnataka | N | - | 6756 | 0 | 168.9 | 168.9 | 0 | Y | 10-Sep-21 | Aug-21 | N
29ANEPM3599F1ZK | Mercury | TR/21-22/602 | R | 10-08-2021 | 810 | Karnataka | N | 5 | 771 | 0 | 19.28 | 19.28 | 0 | Y | 10-Sep-21 | Aug-21 | N
29ANEPM3599F1ZK | Mercury | TR/21-22/602-Total | R | 10-08-2021 | 810 | Karnataka | N | - | 771 | 0 | 19.28 | 19.28 | 0 | Y | 10-Sep-21 | Aug-21 | N
29AACCM4684P1ZN | August | 1124T081711402 | R | 20-08-2017 | 7179.21 | Karnataka | N | 5 | 2115.49 | 0 | 52.89 | 52.89 | 0 | Y | 05-Feb-18 | Aug-17 | Y
29AACCM4684P1ZN | August | 1124T081711402 | R | 20-08-2017 | 7179.21 | Karnataka | N | 12 | 605.23 | 0 | 36.31 | 36.31 | 0 | Y | 05-Feb-18 | Aug-17 | Y
29AACCM4684P1ZN | August | 1124T081711402 | R | 20-08-2017 | 7179.21 | Karnataka | N | 18 | 1688.01 | 0 | 151.92 | 151.92 | 0 | Y | 05-Feb-18 | Aug-17 | Y
29AACCM4684P1ZN | August | 1124T081711402 | R | 20-08-2017 | 7179.21 | Karnataka | N | 28 | 1787.69 | 0 | 250.28 | 250.28 | 0 | Y | 05-Feb-18 | Aug-17 | Y
29AACCM4684P1ZN | August | 1124T081711402-Total | R | 20-08-2017 | 7179.21 | Karnataka | N | - | 6196.42 | 0 | 491.4 | 491.4 | 0 | Y | 05-Feb-18 | Aug-17 | Y
29AAICP9462E1ZZ | December | 666/22-23 | R | 30-04-2022 | 51384 | Karnataka | N | 5 | 10309.26 | 0 | 257.73 | 257.73 | 0 | Y | 13-May-22 | Apr-22 | N
29AAICP9462E1ZZ | December | 666/22-23 | R | 30-04-2022 | 51384 | Karnataka | N | 12 | 36213.65 | 0 | 2172.83 | 2172.83 | 0 | Y | 13-May-22 | Apr-22 | N
29AAICP9462E1ZZ | December | 666/22-23-Total | R | 30-04-2022 | 51384 | Karnataka | N | - | 46522.91 | 0 | 2430.56 | 2430.56 | 0 | Y | 13-May-22 | Apr-22 | N
29ALVPP1985H1Z6 | Saturday | 886 | R | 12-10-2021 | 106591 | Karnataka | N | 18 | 12450 | 0 | 1120.5 | 1120.5 | 0 | Y | 19-Nov-21 | Oct-21 | Y
29ALVPP1985H1Z6 | Saturday | 886 | R | 12-10-2021 | 106591 | Karnataka | N | 28 | 71796.88 | 0 | 10051.56 | 10051.56 | 0 | Y | 19-Nov-21 | Oct-21 | Y
29ALVPP1985H1Z6 | Saturday | 886-Total | R | 12-10-2021 | 106591 | Karnataka | N | - | 84246.88 | 0 | 11172.06 | 11172.06 | 0 | Y | 19-Nov-21 | Oct-21 | Y
29AAFCS6449B1Z8 | October | 202122-12350 | R | 22-10-2021 | 7986 | Karnataka | N | 18 | 6768 | 0 | 609.12 | 609.12 | 0 | Y | 10-Nov-21 | Oct-21 | Y
29AAFCS6449B1Z8 | October | 202122-12350-Total | R | 22-10-2021 | 7986 | Karnataka | N | - | 6768 | 0 | 609.12 | 609.12 | 0 | Y | 10-Nov-21 | Oct-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/397 | R | 07-10-2021 | 10170 | Karnataka | N | 12 | 2530.62 | 0 | 151.84 | 151.84 | 0 | Y | 07-Nov-21 | Oct-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/397 | R | 07-10-2021 | 10170 | Karnataka | N | 18 | 5953.59 | 0 | 535.82 | 535.82 | 0 | Y | 07-Nov-21 | Oct-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/397 | R | 07-10-2021 | 10170 | Karnataka | N | 0 | 310 | 0 | 0 | 0 | 0 | Y | 07-Nov-21 | Oct-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/397-Total | R | 07-10-2021 | 10170 | Karnataka | N | - | 8794.21 | 0 | 687.6600000000001 | 687.6600000000001 | 0 | Y | 07-Nov-21 | Oct-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/425 | R | 19-10-2021 | 10618 | Karnataka | N | 12 | 535.8 | 0 | 32.15 | 32.15 | 0 | Y | 07-Nov-21 | Oct-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/425 | R | 19-10-2021 | 10618 | Karnataka | N | 18 | 8489.8 | 0 | 764.08 | 764.08 | 0 | Y | 07-Nov-21 | Oct-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/425-Total | R | 19-10-2021 | 10618 | Karnataka | N | - | 9025.599999999999 | 0 | 796.23 | 796.23 | 0 | Y | 07-Nov-21 | Oct-21 | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-Invoice | 42800d43da4ade845fa0f71fcfed09442b023800443a069bcedd67f103ae66f0 | 11-10-2021
29AAACG1108N1ZM | June | BLR/S/21-22/0456 | R | 11-10-2021 | 12954 | Karnataka | N | 18 | 10978.2 | 0 | 988.04 | 988.04 | 0 | Y | 11-Nov-21 | Oct-21 | Y |  |  |  | E-Invoice | 42800d43da4ade845fa0f71fcfed09442b023800443a069bcedd67f103ae66f0 | 11-10-2021
29AAACG1108N1ZM | June | BLR/S/21-22/0456-Total | R | 11-10-2021 | 12954 | Karnataka | N | - | 10978.2 | 0 | 988.04 | 988.04 | 0 | Y | 11-Nov-21 | Oct-21 | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-Invoice | cc9000a3e171b33c040dc131d85fe2f0f0bf5dd98415582e64d08d87f6abb0c8 | 11-10-2021
29AAACG1108N1ZM | June | BLR/T/21-22/0068 | R | 11-10-2021 | 69646 | Karnataka | N | 18 | 59021.76 | 0 | 5311.96 | 5311.96 | 0 | Y | 11-Nov-21 | Oct-21 | Y |  |  |  | E-Invoice | cc9000a3e171b33c040dc131d85fe2f0f0bf5dd98415582e64d08d87f6abb0c8 | 11-10-2021
29AAACG1108N1ZM | June | BLR/T/21-22/0068-Total | R | 11-10-2021 | 69646 | Karnataka | N | - | 59021.76 | 0 | 5311.96 | 5311.96 | 0 | Y | 11-Nov-21 | Oct-21 | Y
29AABCW2348B1ZI | July | OIM-21-033 | R | 08-11-2021 | 35587.9 | Karnataka | N | 5 | 12600 | 0 | 315 | 315 | 0 | Y | 09-Dec-21 | Nov-21 | Y
29AABCW2348B1ZI | July | OIM-21-033 | R | 08-11-2021 | 35587.9 | Karnataka | N | 18 | 15705 | 0 | 1413.45 | 1413.45 | 0 | Y | 09-Dec-21 | Nov-21 | Y
29AABCW2348B1ZI | July | OIM-21-033 | R | 08-11-2021 | 35587.9 | Karnataka | N | 0 | 3826 | 0 | 0 | 0 | 0 | Y | 09-Dec-21 | Nov-21 | Y
29AABCW2348B1ZI | July | OIM-21-033-Total | R | 08-11-2021 | 35587.9 | Karnataka | N | - | 32131 | 0 | 1728.45 | 1728.45 | 0 | Y | 09-Dec-21 | Nov-21 | Y
29AAECG1830B1Z2 | September | 1711 | R | 22-11-2021 | 87861 | Karnataka | N | 5 | 7512 | 0 | 187.8 | 187.8 | 0 | Y | 03-Dec-21 | Nov-21 | Y
29AAECG1830B1Z2 | September | 1711 | R | 22-11-2021 | 87861 | Karnataka | N | 18 | 65828 | 0 | 5924.52 | 5924.52 | 0 | Y | 03-Dec-21 | Nov-21 | Y
29AAECG1830B1Z2 | September | 1711-Total | R | 22-11-2021 | 87861 | Karnataka | N | - | 73340 | 0 | 6112.320000000001 | 6112.320000000001 | 0 | Y | 03-Dec-21 | Nov-21 | Y
29ACXPJ0280A1ZL | Tuesday | 1634 | R | 27-11-2021 | 20104 | Karnataka | N | 5 | 16000 | 0 | 400 | 400 | 0 | Y | 04-Feb-22 | Nov-21 | Y
29ACXPJ0280A1ZL | Tuesday | 1634 | R | 27-11-2021 | 20104 | Karnataka | N | 18 | 2800 | 0 | 252 | 252 | 0 | Y | 04-Feb-22 | Nov-21 | Y
29ACXPJ0280A1ZL | Tuesday | 1634-Total | R | 27-11-2021 | 20104 | Karnataka | N | - | 18800 | 0 | 652 | 652 | 0 | Y | 04-Feb-22 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/500 | R | 15-11-2021 | 11303 | Karnataka | N | 18 | 8588.7 | 0 | 772.98 | 772.98 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/500 | R | 15-11-2021 | 11303 | Karnataka | N | 12 | 721.44 | 0 | 43.29 | 43.29 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/500 | R | 15-11-2021 | 11303 | Karnataka | N | 0 | 360 | 0 | 0 | 0 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/500-Total | R | 15-11-2021 | 11303 | Karnataka | N | - | 9670.140000000001 | 0 | 816.27 | 816.27 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/514 | R | 20-11-2021 | 20141 | Karnataka | N | 18 | 16687.3 | 0 | 1501.86 | 1501.86 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/514 | R | 20-11-2021 | 20141 | Karnataka | N | 12 | 401.76 | 0 | 24.11 | 24.11 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/514-Total | R | 20-11-2021 | 20141 | Karnataka | N | - | 17089.06 | 0 | 1525.97 | 1525.97 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/522 | R | 23-11-2021 | 24441 | Karnataka | N | 18 | 19950 | 0 | 1795.5 | 1795.5 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/522 | R | 23-11-2021 | 24441 | Karnataka | N | 12 | 803.52 | 0 | 48.21 | 48.21 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29ABYPS1803Q1ZL | Monday | INC/21-22/522-Total | R | 23-11-2021 | 24441 | Karnataka | N | - | 20753.52 | 0 | 1843.71 | 1843.71 | 0 | Y | 05-Dec-21 | Nov-21 | Y
29CUJPM7343B1ZH | Earth | 593 | R | 17-11-2021 | 33652 | Karnataka | N | 5 | 32050 | 0 | 801.25 | 801.25 | 0 | Y | 24-Dec-21 | Nov-21 | Y
29CUJPM7343B1ZH | Earth | 593-Total | R | 17-11-2021 | 33652 | Karnataka | N | - | 32050 | 0 | 801.25 | 801.25 | 0 | Y | 24-Dec-21 | Nov-21 | Y
29CUJPM7343B1ZH | Earth | 594 | R | 17-11-2021 | 1327 | Karnataka | N | 18 | 1125 | 0 | 101.25 | 101.25 | 0 | Y | 24-Dec-21 | Nov-21 | Y
29CUJPM7343B1ZH | Earth | 594-Total | R | 17-11-2021 | 1327 | Karnataka | N | - | 1125 | 0 | 101.25 | 101.25 | 0 | Y | 24-Dec-21 | Nov-21 | Y
29AGDPS5725R1ZH | Wednesday | 21220917 | R | 23-11-2021 | 1203600 | Karnataka | N | 0 | 1020000 | 0 | 91800 | 91800 | 0 | Y | 10-Dec-21 | Nov-21 | Y
29AGDPS5725R1ZH | Wednesday | 21220917-Total | R | 23-11-2021 | 1203600 | Karnataka | N | - | 1020000 | 0 | 91800 | 91800 | 0 | Y | 10-Dec-21 | Nov-21 | Y
29ABDCS6031L1Z1 | Sunday | 1317/21-22 | R | 04-12-2021 | 131008 | Karnataka | N | 18 | 111024 | 0 | 9992.16 | 9992.16 | 0 | Y | 08-Jan-22 | Dec-21 | Y
29ABDCS6031L1Z1 | Sunday | 1317/21-22-Total | R | 04-12-2021 | 131008 | Karnataka | N | - | 111024 | 0 | 9992.16 | 9992.16 | 0 | Y | 08-Jan-22 | Dec-21 | Y
29ABDCS6031L1Z1 | Sunday | 1403/21-22 | R | 15-12-2021 | 409233 | Karnataka | N | 18 | 346808 | 0 | 31212.72 | 31212.72 | 0 | Y | 08-Jan-22 | Dec-21 | Y
29ABDCS6031L1Z1 | Sunday | 1403/21-22-Total | R | 15-12-2021 | 409233 | Karnataka | N | - | 346808 | 0 | 31212.72 | 31212.72 | 0 | Y | 08-Jan-22 | Dec-21 | Y