Reconciliation Status | Source | Location GSTIN | Location Name | GSTIN | Legal Name | Invoice Number | Date | Invoice Value | Taxable | IGST | CGST | SGST | CESS | Total-GST | DOC-TYPE(2A) | PAN | Vendor Code | IRN | Place of Supply | Service Type | Requestor Emp Code | Requestor Emp Name | Requestor Emp Email | Purchasing Group | Purchasing Group Code | Department Name | Errors |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Matched |
Purchase Register
GSTR2A |
TATA CONSULTANCY SERVICES LIMITED |
INV12333
INV12333 |
12-01-2023
12-01-2023 |
9,426.50
9,426.50 |
15,748,200
15,748,200 |
-
- |
9,426.50
9,426.50 |
9,426.50
9,426.50 |
1,417,338
1,417,338 |
1,417,338
1,417,338 |
INV |
AAACR4849R
AAACR4849R |
8605574
8605574 |
IRN1234
IRN1234 |
Ahmedabad
Ahmedabad |
BC
BC |
516590
516590 |
Devdatta Roy
Devdatta Roy |
devdatta.roy@tatacapital.com
devdatta.roy@tatacapital.com |
H13
H13 |
IT - HFL
IT - HFL |
IT
IT |
N/A
N/A |
|||
Matched |
Purchase Register
GSTR2A |
TATA CONSULTANCY SERVICES LIMITED |
INV12333
INV12333 |
12-01-2023
12-01-2023 |
9,426.50
9,426.50 |
15,748,200
15,748,200 |
-
- |
9,426.50
9,426.50 |
9,426.50
9,426.50 |
1,417,338
1,417,338 |
1,417,338
1,417,338 |
INV |
AAACR4849R
AAACR4849R |
8605574
8605574 |
IRN1234
IRN1234 |
Ahmedabad
Ahmedabad |
BC
BC |
516590
516590 |
Devdatta Roy
Devdatta Roy |
devdatta.roy@tatacapital.com
devdatta.roy@tatacapital.com |
H13
H13 |
IT - HFL
IT - HFL |
IT
IT |
N/A
N/A |
|||
Matched |
Purchase Register
GSTR2A |
TATA CONSULTANCY SERVICES LIMITED |
INV12333
INV12333 |
12-01-2023
12-01-2023 |
9,426.50
9,426.50 |
15,748,200
15,748,200 |
-
- |
9,426.50
9,426.50 |
9,426.50
9,426.50 |
1,417,338
1,417,338 |
1,417,338
1,417,338 |
INV |
AAACR4849R
AAACR4849R |
8605574
8605574 |
IRN1234
IRN1234 |
Ahmedabad
Ahmedabad |
BC
BC |
516590
516590 |
Devdatta Roy
Devdatta Roy |
devdatta.roy@tatacapital.com
devdatta.roy@tatacapital.com |
H13
H13 |
IT - HFL
IT - HFL |
IT
IT |
N/A
N/A |
|||
Mismatched |
Purchase Register
GSTR2A |
TATA CONSULTANCY SERVICES LIMITED |
INV12333
INV12333 |
12-01-2023
12-01-2023 |
9,426.50
9,526.50 |
15,748,200
15,500,200 |
-
- |
9,426.50
9,926.50 |
9,426.50
9,226.50 |
1,417,338
1,517,338 |
1,417,338
1,817,338 |
INV |
AAACR4849R
AAACR4849R |
8605574
8605574 |
IRN12345
IRN12345 |
Pune
Pune |
BC
BC |
516590
516590 |
Devdatta Roy
Devdatta Roy |
devdatta.roy@tatacapital.com
devdatta.roy@tatacapital.com |
H13
H13 |
IT - HFL
IT - HFL |
IT
IT |
Due to xyz
|
|||
Mismatched |
Purchase Register
GSTR2A |
TATA CONSULTANCY SERVICES LIMITED |
INV12333
INV12333 |
12-01-2023
12-01-2023 |
9,426.50
9,526.50 |
15,748,200
15,500,200 |
-
- |
9,426.50
9,926.50 |
9,426.50
9,226.50 |
1,417,338
1,517,338 |
1,417,338
1,817,338 |
INV |
AAACR4849R
AAACR4849R |
8605574
8605574 |
IRN12345
IRN12345 |
Pune
Pune |
BC
BC |
516590
516590 |
Devdatta Roy
Devdatta Roy |
devdatta.roy@tatacapital.com
devdatta.roy@tatacapital.com |
H13
H13 |
IT - HFL
IT - HFL |
IT
IT |
Due to xyz
|
|||
Mismatched |
Purchase Register
GSTR2A |
TATA CONSULTANCY SERVICES LIMITED |
INV12333
INV12333 |
12-01-2023
12-01-2023 |
9,426.50
9,526.50 |
15,748,200
15,500,200 |
-
- |
9,426.50
9,926.50 |
9,426.50
9,226.50 |
1,417,338
1,517,338 |
1,417,338
1,817,338 |
INV |
AAACR4849R
AAACR4849R |
8605574
8605574 |
IRN12345
IRN12345 |
Pune
Pune |
BC
BC |
516590
516590 |
Devdatta Roy
Devdatta Roy |
devdatta.roy@tatacapital.com
devdatta.roy@tatacapital.com |
H13
H13 |
IT - HFL
IT - HFL |
IT
IT |
Due to xyz
|
|||
PR Only | Purchase Register | 24GHKLL6789N1ZX Cygnet Enterprise GJ |
Arvind Maharashtra | 24WGDHP2234N1ZX J &P Ltd |
TATA CONSULTANCY SERVICES LIMITED | INV12333 | 20-01-2023 | 9,426.50 | 15,748,200 | - | 9,426.50 | 9,426.50 | 1,417,338 | 1,417,338 | INV | AAACR4849R | 8605574 | IRN43455 | Surat | BC | 516590 | Devdatta Roy | devdatta.roy@tatacapital.com | H14 | IT - HFL | IT | N/A |
PR Only | Purchase Register | 24GHKLL6789N1ZX Cygnet Enterprise GJ |
Arvind Maharashtra | 24WGDHP2234N1ZX J &P Ltd |
TATA CONSULTANCY SERVICES LIMITED | INV12333 | 20-01-2023 | 9,426.50 | 15,748,200 | - | 9,426.50 | 9,426.50 | 1,417,338 | 1,417,338 | INV | AAACR4849R | 8605574 | IRN43455 | Surat | BC | 516590 | Devdatta Roy | devdatta.roy@tatacapital.com | H14 | IT - HFL | IT | N/A |
Reconciliation Status | PR_GSTIN | PR_Legal Name | PR_Count of Invoice Number | PR_Sum of Invoice Value | PR_Total-GST | PR_Total-GST to be accounted |
---|---|---|---|---|---|---|
Matched | TATA CONSULTANCY SERVICES LIMITED |
50
|
12,52,34,606
|
1,91,03,584
|
||
Mismatched | TATA CONSULTANCY SERVICES LIMITED |
50
|
12,52,34,606
|
1,91,03,584
|
||
Grand Total | 100 | 25,04,69,212 | 38,207,168 |
Grand Total | PR_Total-GST | PR_Count of Invoice Number | PR_Total-GST to be Accounted |
---|---|---|---|
Grand Total | 210389386.63 | 192 | 5090750 |
Reconciliation Status | PR_Department | PR_Total_GST | PR_Count of Invoice Number | PR_Total-GST to be accounted |
---|---|---|---|---|
Mismatched |
Unassigned Department
|
8,34,37,861
|
112
|
8,34,37,861
|
Matched |
Department Name
|
1476.9
|
1
|
1476.9
|
Grand Total | 8,39,338.26 | 113 | 8,39,338.26 |
Grand Total | PR_Total-GST | PR_Count of Invoice Number | PR_Total-GST to be Accounted |
---|---|---|---|
Grand Total | 210389386.63 | 192 | 5090750 |