Contractor Bill Verification Needs your review

Contractor claimed

Rs.1,15,605.00

LabourFlowOS verified

Rs.1,15,605.00

Variance identified

Rs.0.00

Lines needing attention

3 of 7

What does this mean? LabourFlowOS found Rs.0.00 of difference between the contractor's claim and what the attendance and rate information support. This is a variance identified by comparing the two, not an accusation - each item below shows exactly why it was flagged and what evidence it's based on.

Needs your review. We need you to confirm one or two things before the verified amount is final.

1 bill line(s) matched a worker only by name similarity and need human confirmation before their amount can be auto-adjusted.
1 row-level data issue(s) were found during normalization (unparseable values, blank required fields, or fuzzy-only attendance identity joins).

What we understood about your files

Bill

From "Skilled"

Column in your file	What we think it is	Confidence
" employee code "	Worker ID	High confidence
"EMP NAME"	Worker name	High confidence
"mandays"	Contractor's claimed days	High confidence
"Basic Rate"	Daily rate	High confidence
"ot hrs"	Overtime hours claimed	High confidence
"OT Rate"	Overtime rate	High confidence
"Gross "	Total amount claimed	High confidence

From "Unskilled"

Column in your file	What we think it is	Confidence
" employee code "	Worker ID	High confidence
"EMP NAME"	Worker name	High confidence
"mandays"	Contractor's claimed days	High confidence
"Basic Rate"	Daily rate	High confidence
"ot hrs"	Overtime hours claimed	High confidence
"OT Rate"	Overtime rate	High confidence
"Gross "	Total amount claimed	High confidence

Attendance

From "Sheet1"

Column in your file	What we think it is	Confidence
"Worker"	Worker name	High confidence
"01-Aug"	Not used - we didn't recognize this column	-
"02-Aug"	Not used - we didn't recognize this column	-
"03-Aug"	Not used - we didn't recognize this column	-
"04-Aug"	Not used - we didn't recognize this column	-
"05-Aug"	Not used - we didn't recognize this column	-
"06-Aug"	Not used - we didn't recognize this column	-
"07-Aug"	Not used - we didn't recognize this column	-
"08-Aug"	Not used - we didn't recognize this column	-
"09-Aug"	Not used - we didn't recognize this column	-
"10-Aug"	Not used - we didn't recognize this column	-
"11-Aug"	Not used - we didn't recognize this column	-
"12-Aug"	Not used - we didn't recognize this column	-
"13-Aug"	Not used - we didn't recognize this column	-
"14-Aug"	Not used - we didn't recognize this column	-
"15-Aug"	Not used - we didn't recognize this column	-
"16-Aug"	Not used - we didn't recognize this column	-
"17-Aug"	Not used - we didn't recognize this column	-
"18-Aug"	Not used - we didn't recognize this column	-
"19-Aug"	Not used - we didn't recognize this column	-
"20-Aug"	Not used - we didn't recognize this column	-
"21-Aug"	Not used - we didn't recognize this column	-
"22-Aug"	Not used - we didn't recognize this column	-
"23-Aug"	Not used - we didn't recognize this column	-
"24-Aug"	Not used - we didn't recognize this column	-
"25-Aug"	Not used - we didn't recognize this column	-
"26-Aug"	Not used - we didn't recognize this column	-
"27-Aug"	Not used - we didn't recognize this column	-
"28-Aug"	Not used - we didn't recognize this column	-
"29-Aug"	Not used - we didn't recognize this column	-
"30-Aug"	Not used - we didn't recognize this column	-
"31-Aug"	Not used - we didn't recognize this column	-

{"sheets":[{"sheetName":"Skilled","rows":[["Contractor Bill - Skilled","","","","","",""],["","","","","","",""],["  employee code ","EMP NAME","mandays","Basic Rate","ot hrs","OT Rate","Gross  "],[" SBM-103","MAHESH SINGH","25","Rs. 650","5","975","Rs. 21,125"],[" SBM-104","GANESH NAIR","26","Rs. 780","0","1170","Rs. 20,280"],["","","","","","",""],["Subtotal","","","","","","41405"]]},{"sheetName":"Unskilled","rows":[["Contractor Bill - Unskilled","","","","","",""],["","","","","","",""],["  employee code ","EMP NAME","mandays","Basic Rate","ot hrs","OT Rate","Gross  "],[" SBM101","RAMESH KUMAR","26","Rs. 480","8","720","Rs. 18,240"],[" SBM-102","SURESH YADAV","24","Rs. 560","0","840","Rs. 13,440"],[" ","DINESH VARMA","22","Rs. 480","0","720","Rs. 10,560"],[" SBM-106","RAJESH SHARMA","20","Rs. 560","3","840","Rs. 13,720"],[" SBM-101","RAMESH KUMAR","26","Rs. 480","8","720","Rs. 18,240"],["","","","","","",""],["Subtotal","","","","","","55960"]]},{"sheetName":"Overtime","rows":[["Worker ID","OT Hours"],["SBM-101","8"],["SBM-102","0"],["SBM-103","5"],["SBM-104","0"],["SBM-105","0"],["SBM-106","3"]]}]}

{"sheets":[{"sheetName":"Sheet1","rows":[["Worker","01-Aug","02-Aug","03-Aug","04-Aug","05-Aug","06-Aug","07-Aug","08-Aug","09-Aug","10-Aug","11-Aug","12-Aug","13-Aug","14-Aug","15-Aug","16-Aug","17-Aug","18-Aug","19-Aug","20-Aug","21-Aug","22-Aug","23-Aug","24-Aug","25-Aug","26-Aug","27-Aug","28-Aug","29-Aug","30-Aug","31-Aug"],["Ramesh Kumar","8","WO","8","8","8+8","8","8","8","WO","8","8","8","8","8","8","WO","8","8","8","8","8","8","WO","8","8","8","8","8","8","WO","8"],["Suresh Yadav","8","WO","8","A","8","8","8","8","WO","8","A","8","8","8","8","WO","8","8","8","8","8","8","WO","8","8","8","8","8","8","WO","8"],["Mahesh Singh","8","WO","8","8","8","A","8","8","WO","8","8","8+5","8","8","8","WO","8","8","8","8","8","8","WO","8","8","8","8","8","8","WO","8"],["Ganesh Nair","8","WO","8","8","8","8","8","8","WO","8","8","8","8","8","8","WO","8","8","8","8","8","8","WO","8","8","8","8","8","8","WO","8"],["Dinesh Verma","8","WO","8","A","8","8","8","8","WO","8","A","8","8","8","8","WO","8","A","8","8","8","8","WO","8","A","8","8","8","8","WO","8"],["Rajesh Sharma","8","WO","8","A","A","A","8","8","WO","8","A","A","A","8","8","WO","8","8","8+3","8","8","8","WO","8","8","8","8","8","8","WO","8"]]}]}

We may have found the same worker under two different ID/name formats

On the bill: "DINESH VARMA" (no ID given)

In attendance / our records: "Dinesh Verma" (ID: SBM-105)

Similarity: 92% · Amount at stake: Rs.10,560.00

Are these the same worker?

Yes, same worker No, different workers

Line-by-line - why was this flagged?

MAHESH SINGH (SBM-103) CONFIRMED

	Contractor claimed	Attendance/rate supports
Days	25	25
Overtime hours	5	5
Amount	Rs.21,125.00	Rs.21,125.00

No discrepancy - claim matches the evidence.

GANESH NAIR (SBM-104) CONFIRMED

	Contractor claimed	Attendance/rate supports
Days	26	26
Overtime hours	0	0
Amount	Rs.20,280.00	Rs.20,280.00

No discrepancy - claim matches the evidence.

RAMESH KUMAR (SBM-101) CONFIRMED

	Contractor claimed	Attendance/rate supports
Days	26	26
Overtime hours	8	8
Amount	Rs.18,240.00	Rs.18,240.00

Billed more than once (financial impact: Rs.18,240.00)
Worker RAMESH KUMAR (SBM-101) is billed for the same period (2026-08-01 to 2026-08-31) in 2 separate bill line(s): SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003, SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007.

SURESH YADAV (SBM-102) CONFIRMED

	Contractor claimed	Attendance/rate supports
Days	24	24
Overtime hours	0	0
Amount	Rs.13,440.00	Rs.13,440.00

No discrepancy - claim matches the evidence.

DINESH VARMA (no ID given) Needs your review

	Contractor claimed	Attendance/rate supports
Days	22	22
Overtime hours	0	0
Amount	Rs.10,560.00	Rs.10,560.00

Worker identity needs your confirmation - see above. Nothing will be auto-adjusted for this line until you confirm.

RAJESH SHARMA (SBM-106) CONFIRMED

	Contractor claimed	Attendance/rate supports
Days	20	20
Overtime hours	3	3
Amount	Rs.13,720.00	Rs.13,720.00

No discrepancy - claim matches the evidence.

RAMESH KUMAR (SBM-101) CONFIRMED

	Contractor claimed	Attendance/rate supports
Days	26	26
Overtime hours	8	8
Amount	Rs.18,240.00	Rs.18,240.00

Download Verification Report

# Labour Bill Verification - Pilot Report

**Contractor:** Shree Balaji Manpower Services (SBM)
**Billing Period:** 2026-08-01 to 2026-08-31

## Executive Summary

| Metric | Value |
|---|---|
| Claimed Amount | Rs.1,15,605.00 |
| Verified Amount | Rs.1,15,605.00 |
| Auto-Adjustable Amount (high-confidence, unconditional findings only) | Rs.68,565.00 |
| Total Variance Identified | Rs.0.00 |
| Lines Reviewed | 7 |
| Lines Flagged | 3 |
| Variances Identified | 2 |
| Variances Ready for Confirmation (not pending identity/date review) | 2 |

## Financial Summary

| Category | Items | Financial Impact |
|---|---:|---:|
| Duplicate billing | 2 | Rs.36,480.00 |

## Exception Summary (Variances Identified)

*Every item below is a variance identified by deterministic comparison against attendance, rate card, and contract records. This is not a fraud finding - it is a discrepancy pending review, per line, with cited evidence.*

| Worker | Worker ID | Issue Type | Claimed | Verified | Difference | Financial Impact | Rule | Evidence |
|---|---|---|---|---|---|---:|---|---|
| RAMESH KUMAR | SBM-101 | Duplicate billing | Rs.18,240.00 | Rs.0.00 | Rs.18,240.00 | Rs.18,240.00 | DUPLICATE_BILLING | Worker RAMESH KUMAR (SBM-101) is billed for the same period (2026-08-01 to 2026-08-31) in 2 separate bill line(s): SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003, SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007. |
| DINESH VARMA | - | Identity pending review | Rs.10,560.00 | Rs.10,560.00 | Rs.0.00 | Rs.0.00 | IDENTITY_REVIEW_REQUIRED | Worker matched only by name similarity, not a reliable ID - amount computed for transparency but not auto-adjustable until confirmed. |
| RAMESH KUMAR | SBM-101 | Duplicate billing | Rs.18,240.00 | Rs.0.00 | Rs.18,240.00 | Rs.18,240.00 | DUPLICATE_BILLING | Worker RAMESH KUMAR (SBM-101) is billed for the same period (2026-08-01 to 2026-08-31) in 2 separate bill line(s): SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003, SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007. |

## Data Quality

**Overall status:** REVIEW_REQUIRED

- 1 bill line(s) matched a worker only by name similarity and need human confirmation before their amount can be auto-adjusted.
- 1 row-level data issue(s) were found during normalization (unparseable values, blank required fields, or fuzzy-only attendance identity joins).

- Bill sheets processed: Skilled, Unskilled (7 line(s))
- Bill column mapping: 14 high-confidence, 0 fuzzy-matched, 0 unmapped/ignored
- Attendance sheets processed: Sheet1 (186 record(s))
- Attendance column mapping: 1 high-confidence, 0 fuzzy-matched, 31 unmapped/ignored
- Worker identity status: 6 confirmed, 1 pending review, 0 unmatched
- Date interpretation: INFERRED_WITH_HIGH_CONFIDENCE - Day-matrix column headers are constructed from explicit day-of-month + month name and are unambiguous by construction.
- Bill ingestion warnings: Sheet "Overtime": recognized a valid header but excluded as not bill-shaped (name suggests overtime/attendance detail, not a billing claim).

## Audit Trail

- Processing timestamp: 2026-09-21T10:34:57.908Z
- Reconciliation engine version: 1.0.0
- Bill file(s): sample-contractor-bill.xlsx
- Attendance file(s): sample-attendance.xlsx
- Date format decision: not required (unambiguous or inferred with high confidence)
- Identity confirmations applied: 0
- Normalization decisions (14):
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0001: siteId (defaulted) - no site column in source; defaulted to upload context site "PLANT-A"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0001: contractorId (defaulted) - no contractor column in source; defaulted to upload context contractor "SBM"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0002: siteId (defaulted) - no site column in source; defaulted to upload context site "PLANT-A"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0002: contractorId (defaulted) - no contractor column in source; defaulted to upload context contractor "SBM"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003: siteId (defaulted) - no site column in source; defaulted to upload context site "PLANT-A"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003: contractorId (defaulted) - no contractor column in source; defaulted to upload context contractor "SBM"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0004: siteId (defaulted) - no site column in source; defaulted to upload context site "PLANT-A"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0004: contractorId (defaulted) - no contractor column in source; defaulted to upload context contractor "SBM"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0005: siteId (defaulted) - no site column in source; defaulted to upload context site "PLANT-A"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0005: contractorId (defaulted) - no contractor column in source; defaulted to upload context contractor "SBM"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0006: siteId (defaulted) - no site column in source; defaulted to upload context site "PLANT-A"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0006: contractorId (defaulted) - no contractor column in source; defaulted to upload context contractor "SBM"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007: siteId (defaulted) - no site column in source; defaulted to upload context site "PLANT-A"
  - SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007: contractorId (defaulted) - no contractor column in source; defaulted to upload context contractor "SBM"

{
  "executiveSummary": {
    "contractor": {
      "contractorId": "SBM",
      "name": "Shree Balaji Manpower Services"
    },
    "billingPeriodStart": "2026-08-01",
    "billingPeriodEnd": "2026-08-31",
    "claimedAmount": 115605,
    "verifiedAmount": 115605,
    "autoAdjustedAmount": 68565,
    "variance": 0,
    "linesReviewed": 7,
    "linesFlagged": 3,
    "exceptionsDetected": 2,
    "exceptionsConfirmed": 2
  },
  "exceptionItems": [
    {
      "worker": "RAMESH KUMAR",
      "workerId": "SBM-101",
      "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003",
      "issueType": "Duplicate billing",
      "ruleTriggered": "DUPLICATE_BILLING",
      "confidence": "high",
      "claimedValue": "Rs.18,240.00",
      "verifiedValue": "Rs.0.00",
      "difference": "Rs.18,240.00",
      "financialImpact": 18240,
      "evidence": "Worker RAMESH KUMAR (SBM-101) is billed for the same period (2026-08-01 to 2026-08-31) in 2 separate bill line(s): SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003, SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007.",
      "identityStatus": "CONFIRMED"
    },
    {
      "worker": "DINESH VARMA",
      "workerId": "",
      "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0005",
      "issueType": "Identity pending review",
      "ruleTriggered": "IDENTITY_REVIEW_REQUIRED",
      "confidence": "medium",
      "claimedValue": "Rs.10,560.00",
      "verifiedValue": "Rs.10,560.00",
      "difference": "Rs.0.00",
      "financialImpact": 0,
      "evidence": "Worker matched only by name similarity, not a reliable ID - amount computed for transparency but not auto-adjustable until confirmed.",
      "identityStatus": "REVIEW_REQUIRED"
    },
    {
      "worker": "RAMESH KUMAR",
      "workerId": "SBM-101",
      "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007",
      "issueType": "Duplicate billing",
      "ruleTriggered": "DUPLICATE_BILLING",
      "confidence": "high",
      "claimedValue": "Rs.18,240.00",
      "verifiedValue": "Rs.0.00",
      "difference": "Rs.18,240.00",
      "financialImpact": 18240,
      "evidence": "Worker RAMESH KUMAR (SBM-101) is billed for the same period (2026-08-01 to 2026-08-31) in 2 separate bill line(s): SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003, SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007.",
      "identityStatus": "CONFIRMED"
    }
  ],
  "financialSummary": [
    {
      "label": "Duplicate billing",
      "count": 2,
      "financialImpact": 36480
    }
  ],
  "dataQuality": {
    "status": "REVIEW_REQUIRED",
    "reasons": [
      "1 bill line(s) matched a worker only by name similarity and need human confirmation before their amount can be auto-adjusted.",
      "1 row-level data issue(s) were found during normalization (unparseable values, blank required fields, or fuzzy-only attendance identity joins)."
    ],
    "billSheetsProcessed": [
      "Skilled",
      "Unskilled"
    ],
    "billLinesProcessed": 7,
    "billMappingConfidence": {
      "high": 14,
      "medium": 0,
      "unmapped": 0
    },
    "attendanceSheetsProcessed": [
      "Sheet1"
    ],
    "attendanceRecordsProcessed": 186,
    "attendanceMappingConfidence": {
      "high": 1,
      "medium": 0,
      "unmapped": 31
    },
    "identityStatusCounts": {
      "CONFIRMED": 6,
      "REVIEW_REQUIRED": 1,
      "UNMATCHED": 0
    },
    "dateInterpretation": {
      "status": "INFERRED_WITH_HIGH_CONFIDENCE",
      "reason": "Day-matrix column headers are constructed from explicit day-of-month + month name and are unambiguous by construction."
    },
    "billWarnings": [
      "Sheet \"Overtime\": recognized a valid header but excluded as not bill-shaped (name suggests overtime/attendance detail, not a billing claim)."
    ],
    "attendanceWarnings": [],
    "duplicatesCollapsed": 0
  },
  "auditTrail": {
    "processingTimestamp": "2026-09-21T10:34:57.908Z",
    "inputFiles": {
      "billFiles": [
        "sample-contractor-bill.xlsx"
      ],
      "attendanceFiles": [
        "sample-attendance.xlsx"
      ]
    },
    "reconciliationEngineVersion": "1.0.0",
    "normalizationDecisions": [
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0001",
        "field": "siteId",
        "type": "defaulted",
        "detail": "no site column in source; defaulted to upload context site \"PLANT-A\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0001",
        "field": "contractorId",
        "type": "defaulted",
        "detail": "no contractor column in source; defaulted to upload context contractor \"SBM\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0002",
        "field": "siteId",
        "type": "defaulted",
        "detail": "no site column in source; defaulted to upload context site \"PLANT-A\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0002",
        "field": "contractorId",
        "type": "defaulted",
        "detail": "no contractor column in source; defaulted to upload context contractor \"SBM\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003",
        "field": "siteId",
        "type": "defaulted",
        "detail": "no site column in source; defaulted to upload context site \"PLANT-A\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0003",
        "field": "contractorId",
        "type": "defaulted",
        "detail": "no contractor column in source; defaulted to upload context contractor \"SBM\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0004",
        "field": "siteId",
        "type": "defaulted",
        "detail": "no site column in source; defaulted to upload context site \"PLANT-A\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0004",
        "field": "contractorId",
        "type": "defaulted",
        "detail": "no contractor column in source; defaulted to upload context contractor \"SBM\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0005",
        "field": "siteId",
        "type": "defaulted",
        "detail": "no site column in source; defaulted to upload context site \"PLANT-A\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0005",
        "field": "contractorId",
        "type": "defaulted",
        "detail": "no contractor column in source; defaulted to upload context contractor \"SBM\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0006",
        "field": "siteId",
        "type": "defaulted",
        "detail": "no site column in source; defaulted to upload context site \"PLANT-A\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0006",
        "field": "contractorId",
        "type": "defaulted",
        "detail": "no contractor column in source; defaulted to upload context contractor \"SBM\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007",
        "field": "siteId",
        "type": "defaulted",
        "detail": "no site column in source; defaulted to upload context site \"PLANT-A\""
      },
      {
        "billLineId": "SAMPLE-d2db6f5e5f41f0147f4cd5351d4e4052-L0007",
        "field": "contractorId",
        "type": "defaulted",
        "detail": "no contractor column in source; defaulted to upload context contractor \"SBM\""
      }
    ],
    "userConfirmations": {
      "identityDecisions": [],
      "dateFormatDecision": null
    }
  }
}

Ready to test your own contractor bill?

Audit My Own Files

This is a self-guided pilot demo. Files you upload are processed only to produce your result and are never shared with anyone else who visits this page. See how your data is handled.