Input vs Output Validation

Reconcile consolidated stakeholder inputs against TCS payroll output — column-by-column

Month:

Input Group:

Status:

Total Records

Employees

Matched

All columns match

Mismatch

Has variance(s)

Match Rate

25%

Overall accuracy

Reconciliation Table — June 2026

Each salary column shows: Input · TCS Output · Variance · Status

8 / 8 records

Match

Mismatch

Positive Variance

Scroll horizontally to view all columns →

Emp ID	Employee Name	Input Group	Row Status	Advance Recovery				Business Advance				Relocation Exp & Claims				Other Deduction				Excess Claim Recovery				Leave Adjustment				Rent Recovery				Salary on Hold				Notice Pay Recovery				F&F Payment				Rec. Settled by Employee				Recovery Waive Off				Tax paid by ER on others				TW Closure				TW EMI				Gross Deduction				Curr. Month Net Pay				Recoverable (Prev Month)				Prev Month Payable				Prev Month Sal Paid				To be Recovered				Net Pay				Er ESI Contribution				Er LWF Contribution				Er PF Contribution				Er Pension Contribution				EDLI Contribution				PF Adm Charges				Superannuation Contribution				Er NPS Contribution
				Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status	Input	TCS Out	Variance	Status
EMP-1001	Arjun Nair	Group A – Retail	Mismatch	1,000	1,000	—	OK	1,150	1,150	—	OK	1,300	1,300	—	OK	1,450	1,412	38	Diff	1,600	1,600	—	OK	1,750	1,750	—	OK	1,900	1,900	—	OK	2,050	2,050	—	OK	2,200	2,200	—	OK	2,350	2,350	—	OK	2,500	2,500	—	OK	2,650	2,650	—	OK	2,800	2,800	—	OK	2,950	2,950	—	OK	3,100	3,100	—	OK	3,250	3,250	—	OK	3,400	3,433	+33	Diff	3,550	3,550	—	OK	3,700	3,700	—	OK	3,850	3,850	—	OK	4,000	4,000	—	OK	4,150	3,953	197	Diff	4,300	4,300	—	OK	4,450	4,450	—	OK	4,600	4,600	—	OK	4,750	4,750	—	OK	4,900	4,900	—	OK	5,050	5,050	—	OK	5,200	5,200	—	OK	5,350	5,350	—	OK
EMP-1024	Kavitha Reddy	Group B – Corporate	Mismatch	800	800	—	OK	920	911	9	Diff	1,040	1,040	—	OK	1,160	1,160	—	OK	1,280	1,280	—	OK	1,400	1,400	—	OK	1,520	1,520	—	OK	1,640	1,640	—	OK	1,760	1,760	—	OK	1,880	1,880	—	OK	2,000	2,000	—	OK	2,120	2,120	—	OK	2,240	2,240	—	OK	2,360	2,360	—	OK	2,480	2,480	—	OK	2,600	2,600	—	OK	2,720	2,720	—	OK	2,840	2,840	—	OK	2,960	2,960	—	OK	3,080	3,080	—	OK	3,200	3,200	—	OK	3,320	3,320	—	OK	3,440	3,477	+37	Diff	3,560	3,560	—	OK	3,680	3,616	64	Diff	3,800	3,800	—	OK	3,920	3,920	—	OK	4,040	4,040	—	OK	4,160	4,160	—	OK	4,280	4,280	—	OK
EMP-1087	Sanjay Patel	Group C – Operations	Match	1,200	1,200	—	OK	1,400	1,400	—	OK	1,600	1,600	—	OK	1,800	1,800	—	OK	2,000	2,000	—	OK	2,200	2,200	—	OK	2,400	2,400	—	OK	2,600	2,600	—	OK	2,800	2,800	—	OK	3,000	3,000	—	OK	3,200	3,200	—	OK	3,400	3,400	—	OK	3,600	3,600	—	OK	3,800	3,800	—	OK	4,000	4,000	—	OK	4,200	4,200	—	OK	4,400	4,400	—	OK	4,600	4,600	—	OK	4,800	4,800	—	OK	5,000	5,000	—	OK	5,200	5,200	—	OK	5,400	5,400	—	OK	5,600	5,600	—	OK	5,800	5,800	—	OK	6,000	6,000	—	OK	6,200	6,200	—	OK	6,400	6,400	—	OK	6,600	6,600	—	OK	6,800	6,800	—	OK	7,000	7,000	—	OK
EMP-1102	Meera Iyer	Group A – Retail	Mismatch	900	900	—	OK	1,030	1,030	—	OK	1,160	1,160	—	OK	1,290	1,290	—	OK	1,420	1,420	—	OK	1,550	1,493	57	Diff	1,680	1,680	—	OK	1,810	1,810	—	OK	1,940	1,940	—	OK	2,070	2,070	—	OK	2,200	2,200	—	OK	2,330	2,330	—	OK	2,460	2,460	—	OK	2,590	2,590	—	OK	2,720	2,849	+129	Diff	2,850	2,850	—	OK	2,980	2,980	—	OK	3,110	3,110	—	OK	3,240	3,240	—	OK	3,370	3,370	—	OK	3,500	3,500	—	OK	3,630	3,630	—	OK	3,760	3,760	—	OK	3,890	3,890	—	OK	4,020	4,020	—	OK	4,150	4,150	—	OK	4,280	4,280	—	OK	4,410	4,410	—	OK	4,540	4,540	—	OK	4,670	4,891	+221	Diff
EMP-1156	Rahul Gupta	Group D – Technology	Mismatch	1,500	1,516	+16	Diff	1,680	1,680	—	OK	1,860	1,860	—	OK	2,040	2,040	—	OK	2,220	2,220	—	OK	2,400	2,400	—	OK	2,580	2,580	—	OK	2,760	2,760	—	OK	2,940	2,940	—	OK	3,120	3,120	—	OK	3,300	3,300	—	OK	3,480	3,480	—	OK	3,660	3,660	—	OK	3,840	3,840	—	OK	4,020	4,020	—	OK	4,200	4,200	—	OK	4,380	4,380	—	OK	4,560	4,560	—	OK	4,740	4,740	—	OK	4,920	4,920	—	OK	5,100	5,100	—	OK	5,280	5,456	+176	Diff	5,460	5,460	—	OK	5,640	5,640	—	OK	5,820	5,820	—	OK	6,000	6,000	—	OK	6,180	6,180	—	OK	6,360	6,504	+144	Diff	6,540	6,540	—	OK	6,720	6,720	—	OK
EMP-1203	Deepa Sharma	Group B – Corporate	Match	700	700	—	OK	810	810	—	OK	920	920	—	OK	1,030	1,030	—	OK	1,140	1,140	—	OK	1,250	1,250	—	OK	1,360	1,360	—	OK	1,470	1,470	—	OK	1,580	1,580	—	OK	1,690	1,690	—	OK	1,800	1,800	—	OK	1,910	1,910	—	OK	2,020	2,020	—	OK	2,130	2,130	—	OK	2,240	2,240	—	OK	2,350	2,350	—	OK	2,460	2,460	—	OK	2,570	2,570	—	OK	2,680	2,680	—	OK	2,790	2,790	—	OK	2,900	2,900	—	OK	3,010	3,010	—	OK	3,120	3,120	—	OK	3,230	3,230	—	OK	3,340	3,340	—	OK	3,450	3,450	—	OK	3,560	3,560	—	OK	3,670	3,670	—	OK	3,780	3,780	—	OK	3,890	3,890	—	OK
EMP-1278	Vikram Singh	Group C – Operations	Mismatch	1,100	1,100	—	OK	1,260	1,260	—	OK	1,420	1,484	+64	Diff	1,580	1,580	—	OK	1,740	1,740	—	OK	1,900	1,900	—	OK	2,060	2,060	—	OK	2,220	2,220	—	OK	2,380	2,419	+39	Diff	2,540	2,540	—	OK	2,700	2,700	—	OK	2,860	2,860	—	OK	3,020	3,020	—	OK	3,180	3,180	—	OK	3,340	3,340	—	OK	3,500	3,500	—	OK	3,660	3,660	—	OK	3,820	3,820	—	OK	3,980	3,980	—	OK	4,140	4,140	—	OK	4,300	4,300	—	OK	4,460	4,460	—	OK	4,620	4,615	5	Diff	4,780	4,780	—	OK	4,940	4,940	—	OK	5,100	5,100	—	OK	5,260	5,260	—	OK	5,420	5,420	—	OK	5,580	5,580	—	OK	5,740	5,740	—	OK
EMP-1345	Priya Menon	Group D – Technology	Mismatch	1,300	1,300	—	OK	1,470	1,470	—	OK	1,640	1,640	—	OK	1,810	1,810	—	OK	1,980	1,980	—	OK	2,150	2,150	—	OK	2,320	2,270	50	Diff	2,490	2,490	—	OK	2,660	2,660	—	OK	2,830	2,830	—	OK	3,000	3,000	—	OK	3,170	3,170	—	OK	3,340	3,340	—	OK	3,510	3,510	—	OK	3,680	3,680	—	OK	3,850	3,850	—	OK	4,020	4,183	+163	Diff	4,190	4,190	—	OK	4,360	4,360	—	OK	4,530	4,530	—	OK	4,700	4,700	—	OK	4,870	4,870	—	OK	5,040	5,040	—	OK	5,210	5,210	—	OK	5,380	5,380	—	OK	5,550	5,678	+128	Diff	5,720	5,720	—	OK	5,890	5,890	—	OK	6,060	6,060	—	OK	6,230	6,230	—	OK

8 records · 30 salary columns · 4 sub-columns each (Input | TCS Output | Variance | Status)