How to reconcile an IT services vendor statement

A step-by-step method for reconciling an IT and professional services vendor statement against the SOW, rate card, milestones and caps. Read the full guide.

Twitter LinkedIn WhatsApp
Ask AI: ChatGPT Claude Gemini Grok
How to reconcile an IT services vendor statement

Margin drift is the gap between what a vendor contract says and what the invoice actually charges. In IT and professional services, that gap hides inside a statement of work nobody re-reads once signed.

A vendor statement for this category rarely errors on math. It errors on a milestone claimed before its exit criteria are met, a resource billed at a rate the SOW does not list, or a capped engagement quietly running past its cap. Reconciling the statement means testing each of those, one at a time, against the SOW itself.

Executive Summary

An IT and professional services statement reconciles against a statement of work in a way a freight or contract labor invoice does not: the deliverable is often a fixed fee, a capped-and-burn estimate, or a blended rate card applied to unstructured time entries, and the SOW that governs it lives in a PDF a system never reads. The reconciliation fails less often on the ledger than on the mapping between what the SOW promised and what the statement summarizes, because line items rarely repeat the same phrasing twice.

The mechanism behind drift here is not fraud. It is that a vendor statement aggregates hours, milestones and expenses into a single balance, and the underlying detail, the timesheet, the milestone acceptance, the expense receipt, sits elsewhere or nowhere. Reconciliation means rebuilding that detail against the SOW's own terms before agreeing to the number.

What changes it is a fixed sequence: pull the governing SOW and every amendment, rebuild the statement into its component parts, check each part against its own contract clause, and hold the balance open until every part clears. Skipping the sequence, or reconciling the total first, is how a wrong statement gets paid on time.

1. What documents do you need before you start reconciling?

You need the signed statement of work and every amendment, the resource rate card or rate schedule referenced in it, timesheets or time entries for the period, milestone acceptance records if the engagement is milestone-based, and the vendor statement itself broken into its line items rather than a single balance. Missing any one of these means you are reconciling a total, not a contract.

Start by locating the current SOW, not the master services agreement. The MSA sets general terms; the SOW sets the price, the rate card, the cap, and the deliverables. If the engagement has run more than a few months, check for amendments: a change order that added scope or extended a deadline changes what the statement should show.

Next, pull the rate card the SOW actually references. Professional services SOWs frequently cite a rate card by role ("Senior Consultant," "Project Manager") rather than by named individual, so you need the role-to-rate mapping, not just a dollar figure on the statement.

Then collect the evidence for delivery: timesheets for time-and-materials work, or a signed acceptance record for a milestone. Without this, you cannot tell whether a line item on the statement reflects work performed or work invoiced on an assumption.

Finally, get the statement itself in a line-item form. A vendor summary showing one number for the month tells you nothing you can check.

2. How do you break a lump-sum statement into checkable line items?

Request or reconstruct the statement as separate lines: each resource or role, the rate applied, the hours or the milestone claimed, and any expense pass-through. A single balance cannot be checked against a contract clause; a line item can. If the vendor will not itemize, treat that refusal itself as a control gap worth escalating before payment.

IT and professional services vendors can often produce a detailed backup on request, even when the default statement format is a single total. Ask for it before the payment cycle closes, not after a dispute starts.

Once itemized, sort each line by type: time-and-materials hours by role, fixed-fee milestones, and reimbursable expenses. Each type has a different contract clause governing it, so mixing them defeats the reconciliation before it begins.

For time-and-materials lines, match the role name on the statement to the role name on the rate card. A senior title billed for work a junior resource performed is a mismatch, and the SOW's rate card is the only place that distinction is enforceable.

For milestone lines, the amount should match the SOW's fixed price for that milestone exactly. A milestone billed above its stated fixed price, or billed before its acceptance criteria were signed off, is a reconciliation failure regardless of the hours actually worked underneath it.

3. Where does a not-to-exceed cap actually get tested?

An NTE cap is tested against cumulative billing for the engagement, not against the current period alone. Add this statement's charges to every prior period's accepted charges and compare the running total to the SOW's stated cap. A statement that looks reasonable in isolation can still push the engagement over a cap nobody was tracking cumulatively.

A recurring failure in this category is treating each monthly statement as its own reconciliation. An NTE cap is a contract term over the life of the SOW, and testing it requires a running total, not a monthly snapshot.

Build a simple cumulative ledger: opening balance from prior accepted statements, plus this period's approved charges, against the SOW's cap. If the running total crosses the cap, the statement should show either an explicit change order raising the cap or a line stopping billing at the ceiling.

Also check whether the cap applies to the whole engagement or to a specific phase. SOWs sometimes cap a discovery phase separately from a build phase, and applying the wrong cap understates or overstates what should have stopped.

4. How do you handle rate card mismatches by role?

Compare the exact role title on each invoice line to the exact role title in the SOW's rate schedule, not to a general sense of seniority. A statement charging "Solutions Architect" hours at a rate the SOW never listed, under any title, is not reconcilable until the vendor identifies which contracted role that work maps to.

Professional services SOWs list a fixed set of role titles and a rate for each. A statement should only ever use those titles. When it does not, that is not a formatting issue: it means the vendor has either substituted a resource the SOW did not price, or renamed a contracted role to something that reads as more senior.

Where a role genuinely changed, for example a named resource left and was replaced, check whether the SOW required client approval for resource substitution. Many do. A substitution billed without that approval is a compliance gap even if the new resource's rate happens to match.

5. When is an expense pass-through legitimate on this statement?

An expense line is legitimate only when the SOW authorizes expense pass-through, the expense type matches what the SOW permits, and a receipt or supporting document backs it. Travel, licensing fees and third-party tool costs are worth checking first, because each depends on a specific SOW clause rather than a general allowance, and a missing receipt makes the line unreconcilable regardless of the amount.

Some SOWs are fully inclusive, meaning the fixed fee or the hourly rate already covers travel and incidentals. A statement adding expense lines on top of an inclusive SOW is charging for something already paid for once.

Where expenses are permitted, check the category against the SOW's list. A clause permitting travel does not automatically permit software licensing costs or subcontractor fees passed through at a markup.

Ask for the receipt behind any expense line above a threshold you set for review. An expense summarized as "travel and other" with no backup is not reconcilable, and paying it sets the expectation that summary is sufficient going forward.

6. What do you do when the statement does not reconcile?

Hold the disputed line, not the whole invoice, and send the vendor a specific reconciliation exception citing the SOW clause and the line item it conflicts with. Pay the undisputed portion on schedule. A vague dispute invites a vague response; a cited clause and a specific dollar amount gets resolved faster than a general complaint.

Separate what reconciles from what does not before you contact the vendor. Paying the clean lines on time preserves the relationship and the discount terms; holding the entire statement over one disputed milestone creates friction that has nothing to do with the actual finding.

When you raise the exception, reference the SOW section number, the amendment if one applies, and the specific line item in dispute. A vendor account manager can resolve a cited clause quickly; a general complaint about "the invoice looking high" gets read as a relationship problem rather than a contract one.

Log every exception even after it resolves. A pattern of the same role being mis-titled, or the same expense category recurring without receipts, is the signal that the control belongs earlier in the process, at statement intake, rather than repeated at reconciliation each month.

For the wider pattern this sits inside, start with the margin drift guide. See also price file governance: why annual uploads create twelve months of drift and rebate accrual vs. actual: the reconciliation nobody runs.

7. Frequently Asked Questions (People Also Ask)

Do we need to reconcile every IT services statement or only the large ones?

The mechanism does not depend on size. A small statement with an unlisted role rate or a milestone claimed early is the same reconciliation failure as a large one. Set a dollar threshold for full line-item review if volume requires triage, but treat that as a workload decision, not evidence that small statements carry less risk.

What if the vendor refuses to itemize a lump-sum statement?

Treat the refusal as information. A vendor that cannot or will not break a statement into resource, rate and milestone detail is asking you to approve a number you cannot test against the SOW. Escalate before payment rather than after, and make itemized backup a condition of the next statement.

How do we handle a milestone that shipped late but the SOW has no late-delivery clause?

If the SOW is silent on lateness, the milestone amount is still owed once acceptance criteria are met, because the contract does not condition payment on timing. Note the delay separately for vendor management purposes, but do not withhold payment on a clause the SOW does not contain.

Can a resource substitution ever be approved after the fact?

Some SOWs allow retroactive approval if the client accepts the substitute resource's work product; others require prior written consent as a condition of billing. Check the substitution clause itself rather than assuming either answer, and document whichever path the SOW actually specifies.

What is the difference between a capped time-and-materials SOW and a fixed-fee SOW?

A capped time-and-materials SOW bills actual hours against a rate card up to a ceiling; a fixed-fee SOW pays a set amount per milestone regardless of hours worked. Each needs a different reconciliation: the capped SOW needs a cumulative hours ledger, the fixed-fee SOW needs a milestone acceptance check.

Who should own IT vendor statement reconciliation, AP or the project sponsor?

AP can test the rate card and cap arithmetic, but only the project sponsor knows whether a milestone's exit criteria were actually met. The reconciliation needs both: a financial check against the contract and a delivery check against the work.

What counts as a receipt for a passed-through software license fee?

A receipt is the vendor's own invoice or purchase confirmation from the licensor, showing the license type, quantity and price. A line item on the professional services statement that only restates a dollar figure with no underlying document does not meet this test.

Should we dispute a mis-titled role even if the billed rate happens to be lower than the correct one?

Yes. The point of matching role titles to the rate card is contract compliance, not just price. A mis-titled role, even at a favorable rate this time, signals the vendor is not tracking which contracted role performed the work, which matters the next time the rate is not favorable.

Executive Summary

An IT and professional services statement reconciles against a statement of work in a way a freight or contract labor invoice does not: the deliverable is often a fixed fee, a capped-and-burn estimate, or a blended rate card applied to unstructured time entries, and the SOW that governs it lives in a PDF a system never reads. The reconciliation fails less often on the ledger than on the mapping between what the SOW promised and what the statement summarizes, because line items rarely repeat the same phrasing twice. The mechanism behind drift here is not fraud. It is that a vendor statement aggregates hours, milestones and expenses into a single balance, and the underlying detail, the timesheet, the milestone acceptance, the expense receipt, sits elsewhere or nowhere. Reconciliation means rebuilding that detail against the SOW's own terms before agreeing to the number. What changes it is a fixed sequence: pull the governing SOW and every amendment, rebuild the statement into its component parts, check each part against its own contract clause, and hold the balance open until every part clears. Skipping the sequence, or reconciling the total first, is how a wrong statement gets paid on time.

1. What documents do you need before you start reconciling?

You need the signed statement of work and every amendment, the resource rate card or rate schedule referenced in it, timesheets or time entries for the period, milestone acceptance records if the engagement is milestone-based, and the vendor statement itself broken into its line items rather than a single balance. Missing any one of these means you are reconciling a total, not a contract. Start by locating the current SOW, not the master services agreement. The MSA sets general terms; the SOW sets the price, the rate card, the cap, and the deliverables. If the engagement has run more than a few months, check for amendments: a change order that added scope or extended a deadline changes what the statement should show. Next, pull the rate card the SOW actually references. Professional services SOWs frequently cite a rate card by role ("Senior Consultant," "Project Manager") rather than by named individual, so you need the role-to-rate mapping, not just a dollar figure on the statement. Then collect the evidence for delivery: timesheets for time-and-materials work, or a signed acceptance record for a milestone. Without this, you cannot tell whether a line item on the statement reflects work performed or work invoiced on an assumption. Finally, get the statement itself in a line-item form. A vendor summary showing one number for the month tells you nothing you can check.

2. How do you break a lump-sum statement into checkable line items?

Request or reconstruct the statement as separate lines: each resource or role, the rate applied, the hours or the milestone claimed, and any expense pass-through. A single balance cannot be checked against a contract clause; a line item can. If the vendor will not itemize, treat that refusal itself as a control gap worth escalating before payment. IT and professional services vendors can often produce a detailed backup on request, even when the default statement format is a single total. Ask for it before the payment cycle closes, not after a dispute starts. Once itemized, sort each line by type: time-and-materials hours by role, fixed-fee milestones, and reimbursable expenses. Each type has a different contract clause governing it, so mixing them defeats the reconciliation before it begins. For time-and-materials lines, match the role name on the statement to the role name on the rate card. A senior title billed for work a junior resource performed is a mismatch, and the SOW's rate card is the only place that distinction is enforceable. For milestone lines, the amount should match the SOW's fixed price for that milestone exactly. A milestone billed above its stated fixed price, or billed before its acceptance criteria were signed off, is a reconciliation failure regardless of the hours actually worked underneath it.

3. Where does a not-to-exceed cap actually get tested?

An NTE cap is tested against cumulative billing for the engagement, not against the current period alone. Add this statement's charges to every prior period's accepted charges and compare the running total to the SOW's stated cap. A statement that looks reasonable in isolation can still push the engagement over a cap nobody was tracking cumulatively. A recurring failure in this category is treating each monthly statement as its own reconciliation. An NTE cap is a contract term over the life of the SOW, and testing it requires a running total, not a monthly snapshot. Build a simple cumulative ledger: opening balance from prior accepted statements, plus this period's approved charges, against the SOW's cap. If the running total crosses the cap, the statement should show either an explicit change order raising the cap or a line stopping billing at the ceiling. Also check whether the cap applies to the whole engagement or to a specific phase. SOWs sometimes cap a discovery phase separately from a build phase, and applying the wrong cap understates or overstates what should have stopped.

4. How do you handle rate card mismatches by role?

Compare the exact role title on each invoice line to the exact role title in the SOW's rate schedule, not to a general sense of seniority. A statement charging "Solutions Architect" hours at a rate the SOW never listed, under any title, is not reconcilable until the vendor identifies which contracted role that work maps to. Professional services SOWs list a fixed set of role titles and a rate for each. A statement should only ever use those titles. When it does not, that is not a formatting issue: it means the vendor has either substituted a resource the SOW did not price, or renamed a contracted role to something that reads as more senior. Where a role genuinely changed, for example a named resource left and was replaced, check whether the SOW required client approval for [resource substitution](/guides/n-way-invoice-matching-explained). Many do. A substitution billed without that approval is a compliance gap even if the new resource's rate happens to match.

5. When is an expense pass-through legitimate on this statement?

An expense line is legitimate only when the SOW authorizes expense pass-through, the expense type matches what the SOW permits, and a receipt or supporting document backs it. Travel, licensing fees and third-party tool costs are worth checking first, because each depends on a specific SOW clause rather than a general allowance, and a missing receipt makes the line unreconcilable regardless of the amount. Some SOWs are fully inclusive, meaning the fixed fee or the hourly rate already covers travel and incidentals. A statement adding expense lines on top of an inclusive SOW is charging for something already paid for once. Where expenses are permitted, check the category against the SOW's list. A clause permitting travel does not automatically permit software licensing costs or subcontractor fees passed through at a markup. Ask for the receipt behind any expense line above a threshold you set for review. An expense summarized as "travel and other" with no backup is not reconcilable, and paying it sets the expectation that summary is sufficient going forward.

6. What do you do when the statement does not reconcile?

Hold the disputed line, not the whole invoice, and send the vendor a specific reconciliation exception citing the SOW clause and the line item it conflicts with. Pay the undisputed portion on schedule. A vague dispute invites a vague response; a cited clause and a specific dollar amount gets resolved faster than a general complaint. Separate what reconciles from what does not before you contact the vendor. Paying the clean lines on time preserves the relationship and the discount terms; holding the entire statement over one disputed milestone creates friction that has nothing to do with the actual finding. When you raise the exception, reference the SOW section number, the amendment if one applies, and the specific line item in dispute. A vendor account manager can resolve a cited clause quickly; a general complaint about "the invoice looking high" gets read as a relationship problem rather than a contract one. Log every exception even after it resolves. A pattern of the same role being mis-titled, or the same expense category recurring without receipts, is the signal that the control belongs earlier in the process, at statement intake, rather than repeated at reconciliation each month. For the wider pattern this sits inside, start with the [margin drift](/guides/contract-compliance-controls-p2p) guide. See also [price file governance: why annual uploads create twelve months of drift](/guides/price-file-governance-why-annual-uploads-create-twelve) and [rebate accrual vs. actual: the reconciliation nobody runs](/guides/rebate-accrual-vs-actual-the-reconciliation-nobody-runs).

Questions & Answers

Do we need to reconcile every IT services statement or only the large ones?

The mechanism does not depend on size. A small statement with an unlisted role rate or a milestone claimed early is the same reconciliation failure as a large one. Set a dollar threshold for full line-item review if volume requires triage, but treat that as a workload decision, not evidence that small statements carry less risk.

What if the vendor refuses to itemize a lump-sum statement?

Treat the refusal as information. A vendor that cannot or will not break a statement into resource, rate and milestone detail is asking you to approve a number you cannot test against the SOW. Escalate before payment rather than after, and make itemized backup a condition of the next statement.

How do we handle a milestone that shipped late but the SOW has no late-delivery clause?

If the SOW is silent on lateness, the milestone amount is still owed once acceptance criteria are met, because the contract does not condition payment on timing. Note the delay separately for vendor management purposes, but do not withhold payment on a clause the SOW does not contain.

Can a resource substitution ever be approved after the fact?

Some SOWs allow retroactive approval if the client accepts the substitute resource's work product; others require prior written consent as a condition of billing. Check the substitution clause itself rather than assuming either answer, and document whichever path the SOW actually specifies.

What is the difference between a capped time-and-materials SOW and a fixed-fee SOW?

A capped time-and-materials SOW bills actual hours against a rate card up to a ceiling; a fixed-fee SOW pays a set amount per milestone regardless of hours worked. Each needs a different reconciliation: the capped SOW needs a cumulative hours ledger, the fixed-fee SOW needs a milestone acceptance check.

Margin Drift Resources