T&M billing for 200+ consultants across 15 clients generates 3,000+ timesheet line items per month, and rate card variations, forex conversions, and TDS deductions create systematic reconciliation gaps.
Match approved timesheet hours to invoice line items by consultant and rate, reconcile bank receipt against invoice after TDS and forex adjustments, validate rate card against contract terms.
Section 194J at 10%, FIRC for USD clients, FEMA 9-month realization rule, rate card master per client-consultant pair, tolerance for forex conversion variance.
Timesheet-to-invoice-to-cash reconciliation, rate card compliance report, forex gain/loss register, and TDS receivable tracker by client.
At scale, time-and-material billing reconciliation is a volume problem. An Indian IT company with 200 consultants across 15 clients processes 3,000+ billable line items per month, each requiring a match between the timesheet system, the rate card, the invoice, the bank receipt, and the TDS credit. T&M billing reconciliation confirms that every approved hour was billed at the contracted rate, collected in full net of TDS, and recorded with correct forex treatment for foreign-currency clients.
What Time-and-Material Billing Reconciliation Is
Time-and-material billing reconciliation matches five data sources for each client each month: the approved timesheet (hours per consultant), the rate card (contractual hourly or daily rate per role), the invoice (hours multiplied by rate, plus applicable GST), the bank statement (net cash received after TDS deduction), and Form 26AS (TDS credit confirmation). The reconciliation is complete when the invoiced amount equals the sum of cash received and TDS deducted, and when the TDS credit in Form 26AS matches the TDS receivable in the books.
For Indian IT companies, T&M contracts are typically governed by Section 194J (10% TDS on professional services) or Section 194C (1-2% on contracts), and the correct classification affects both the receivable amount and the tax credit. The ICAI provides guidance on Ind AS 115 revenue recognition for T&M contracts, where revenue is recognised as services are rendered — making the timesheet the source document for revenue recognition.
How T&M Billing Reconciliation Works
Timesheet-to-Invoice Matching
The first reconciliation step matches approved timesheets to the invoice. For each client, the billing system pulls approved hours per consultant, multiplies by the rate card rate, and generates the invoice. The reconciliation check confirms: total approved hours match total invoiced hours, rate card rates match invoiced rates (including any mid-period rate revisions), and leave or non-billable days are excluded. A variance as small as 8 hours across 200 consultants represents a billing error of ₹40,000 to ₹1,60,000 depending on the rate.
Rate Card Validation
Rate cards change with annual escalations, role upgrades, and client-negotiated adjustments. The reconciliation confirms that each consultant was billed at the rate effective for the billing period. A rate card update effective 1 April that is not applied until the May invoice cycle creates a one-month underbilling that must be caught and invoiced as an adjustment. Across 200 consultants and 15 clients, there are typically 20 to 30 rate changes per quarter.
Cash Receipt and TDS Matching
When the client pays, they deduct TDS and remit the net amount. The reconciliation matches: bank credit (via UTR or NEFT reference) + TDS deducted = invoice amount. For USD-paying clients, the bank credit is in INR at the FIRC conversion rate, and the forex difference between invoice-date rate and receipt-date rate must be booked as a realised gain or loss.
T&M Reconciliation Data Sources
| Data Source | What It Contains | Matching Key | Common Variance |
|---|---|---|---|
| Timesheet system (Jira, Harvest, internal) | Approved hours per consultant per client per day | Employee ID + client code + date | Unapproved timesheets included in billing; leave days marked billable |
| Rate card register | Contracted hourly/daily rate per role per client | Client code + role code + effective date | Rate revision not applied to current billing period |
| Invoice (Tally, SAP, Zoho) | Billable hours x rate + GST at 18% | Invoice number + client PAN | GST on manpower supply at 18% vs. professional services at 18% (pre-2022 rate difference) |
| Bank statement | Net payment received via NEFT/wire; UTR or FIRC reference | UTR number or FIRC reference | Partial payment by client; forex conversion variance on USD receipts |
| Form 26AS (TRACES) | TDS credit — certificate number, amount, section, quarter | TDS certificate number + deductor PAN | Wrong section (194C vs. 194J); amount mismatch due to GST inclusion in TDS base |
India-Specific Compliance for T&M Billing
The Section 194J versus 194C classification dispute is particularly acute for T&M contracts. A client classifying a staff augmentation engagement under 194C deducts TDS at 2%, while the IT company expects 194J at 10%. This 8-percentage-point gap creates a TDS receivable mismatch that persists until one party files a correction return. Form 26AS for Q4 (January to March) is typically available by late May — meaning the full-year TDS reconciliation for IT services cannot be completed until two months after the financial year ends.
For companies billing in USD, the FIRC from the receiving bank is the authoritative document for forex reconciliation. RBI regulations under FEMA require that export proceeds are realised within 9 months of the invoice date (extended from the earlier 6-month window). Outstanding receivables beyond this period trigger compliance reporting requirements.
Companies managing T&M billing across 15+ clients with mixed INR and USD billing benefit from reconciliation software India that automates the timesheet-to-invoice-to-bank chain. For the TDS credit verification layer, TDS reconciliation software matches Form 26AS entries against the TDS receivable ledger by certificate number, flagging section code mismatches and amount variances. The monthly process for closing T&M billing follows the same structure outlined in the month-end close checklist. IT companies running both T&M and fixed-price engagements should review milestone billing reconciliation for IT services for the deliverable-based matching process.
Below are the most common questions Indian IT company finance teams ask about T&M billing reconciliation.