Skip to main content
IT Services · 4 min read

Time-and-Material Billing Reconciliation for Indian IT Companies

At 200 consultants deployed across 15 clients, a time-and-material billing operation generates 3,000 or more billable line items per month — each combining a consultant's timesheet hours, a client-specific rate card, and a billing currency that may differ from the receipt currency. The reconciliation challenge is not the individual match. It is confirming that every approved timesheet hour was invoiced at the correct rate, received at the correct forex conversion, and reflected with the right TDS credit in Form 26AS.

Terra Insight
Terra Insight Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 10 April 2026
Domain expertise
TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops
Knowledge Card
Problem

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.

How It's Resolved

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.

Configuration

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.

Output

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 SourceWhat It ContainsMatching KeyCommon Variance
Timesheet system (Jira, Harvest, internal)Approved hours per consultant per client per dayEmployee ID + client code + dateUnapproved timesheets included in billing; leave days marked billable
Rate card registerContracted hourly/daily rate per role per clientClient code + role code + effective dateRate revision not applied to current billing period
Invoice (Tally, SAP, Zoho)Billable hours x rate + GST at 18%Invoice number + client PANGST on manpower supply at 18% vs. professional services at 18% (pre-2022 rate difference)
Bank statementNet payment received via NEFT/wire; UTR or FIRC referenceUTR number or FIRC referencePartial payment by client; forex conversion variance on USD receipts
Form 26AS (TRACES)TDS credit — certificate number, amount, section, quarterTDS certificate number + deductor PANWrong 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.

Primary reference: ICAI — Institute of Chartered Accountants of India — guidance on Ind AS 115 for service contracts and revenue recognition.

Frequently Asked Questions

How is TDS deducted on time-and-material IT services invoices?
Clients deduct TDS on T&M invoices under Section 194J at 10% for professional and technical services. The TDS is calculated on the invoice value excluding GST (per CBDT Circular 1/2014, TDS is deducted on the base amount when GST is shown separately on the invoice). For a monthly T&M invoice of ₹15,00,000 plus GST of ₹2,70,000 (18%), the client deducts TDS of ₹1,50,000 (10% of ₹15,00,000) and pays ₹16,20,000 (₹15,00,000 + ₹2,70,000 GST - ₹1,50,000 TDS). The TDS must be deposited by the client by the 7th of the following month and should appear in the IT company's Form 26AS within the same quarter.
What happens when approved timesheet hours do not match the invoiced hours?
A mismatch between approved timesheet hours and invoiced hours is one of the most common T&M reconciliation exceptions. Causes include: timesheets approved after the billing cut-off date (hours appear in the next month's invoice), client-rejected hours that were included in the invoice, rate card changes effective mid-month that were not applied to all line items, and leave or bench days incorrectly marked as billable. The resolution requires a three-way check: timesheet system (approved hours per consultant per client) vs. billing system (invoiced hours and rates) vs. client purchase order (contracted rate and maximum hours). Any variance above the contractual tolerance (typically 0.5-1% of monthly billing) must be investigated before invoice finalization.
How do Indian IT companies handle forex reconciliation on USD T&M billing?
Indian IT companies billing T&M clients in USD must reconcile at three exchange rate points: the invoice date rate (used to book the INR receivable), the FIRC (Foreign Inward Remittance Certificate) rate at which the bank converts the USD wire to INR, and the RBI reference rate on the reporting date for revaluing outstanding receivables. For a $50,000 monthly invoice booked at ₹84.20/USD (receivable = ₹42,10,000) and received at ₹84.50/USD (bank credit = ₹42,25,000), the realised forex gain of ₹15,000 must be recorded. Under Ind AS 21, unrealised gains on open receivables at quarter-end are recognised in profit and loss. The FIRC from the bank is the authoritative document for the actual conversion rate.
What is the typical month-end close timeline for T&M billing reconciliation?
For an Indian IT company with 15 clients on T&M billing, the month-end close for billing reconciliation typically follows: timesheet submission deadline (1st-2nd of the following month) → manager approval of timesheets (2nd-3rd) → billing team generates invoices from approved timesheets (3rd-5th) → invoices reviewed against rate cards and POs (5th-6th) → invoices dispatched to clients (6th-7th) → revenue recognised in the GL (7th-8th). The reconciliation of the previous month's receipts — matching bank credits to invoices, recording TDS receivables, and booking forex gains/losses — runs in parallel during days 1-5. For companies with 200+ consultants, this process extends to day 10-12 without automation.
Can a client deduct TDS under Section 194C instead of 194J for T&M contracts?
Yes, and this is a frequent source of reconciliation mismatches. Section 194C (1% for individuals, 2% for companies) applies to contracts for carrying out work, while Section 194J (10%) applies to professional or technical services. Some clients classify T&M staff augmentation contracts under 194C, arguing that the IT company is providing manpower rather than professional services. The IT company may disagree and expect 194J treatment. When the TDS rate in Form 26AS does not match the company's expectation, the finance team must either accept the lower credit and file the return accordingly, or request the client to file a TDS correction return (Form 26Q) changing the section code. The correction return process takes 30-60 days.

See how TransactIG handles reconciliation for your industry

Configuration takes 2–4 weeks. No code development required. ISO 27001:2022 certified.