What Is a Settlement Factsheet — and Why Does It End Claim Disputes?

What is a settlement factsheet? A single, self-contained record of how one payout was calculated — the scheme terms that applied, the payee's actual achievement, the calculation step by step, any deductions or clawbacks, and who approved it. Its job is simple: when anyone asks "why is this number ₹X?", the answer is one document, not an argument.

Not to be confused with a mutual-fund fact sheet — "factsheet" here is a claim-settlement document in trade schemes, and "settlement" means claim and scheme settlement, not securities settlement.

What problem does it solve?

Picture a spreadsheet-run settlement operation. The distributor's number differs from yours by ₹18,000. The calculation lives in one analyst's Excel file, in a version nobody else can reproduce. The scheme terms were communicated as a WhatsApp-forwarded circular, and which slab applied depends on which forward you read. The argument runs for weeks over email, burns goodwill on both sides, and ends in a compromise number that satisfies no one and explains nothing — the anatomy of why distributor claims slip through the cracks.

Every one of those failure points is an assertion standing where evidence should be. The factsheet exists to invert that: the calculation is shown, not asserted. Terms, counted data, workings, adjustments, approvals — laid out once, in one place, for one settlement. Disputes don't vanish because everyone becomes agreeable; they vanish because there is nothing left to dispute except specific, checkable lines.

What does a good factsheet contain?

Section	What it shows	The dispute it prevents
Scheme reference & terms	Which scheme, its period, the rate or slab table applied	"We were on a different scheme"
Qualifying data	The payee's actual purchases or sales counted, with source	"You counted the wrong invoices"
Calculation workings	Step by step from achievement to gross payout	"Your math is wrong"
Adjustments	Deductions, recoveries, clawbacks from returns, TDS where applicable	"Why is the amount lower?"
Approvals & audit trail	Who checked, who approved, when	"Who signed this off?"
Net payable & settlement mode	The final amount and its credit-note or payout reference	"Where is the money?"

Three of the six rows carry most of the dispute weight. Qualifying data is where the two sides' numbers usually diverge — the payee counts a dispatch the payer counts in the next period, and the primary-vs-secondary sales distinction decides who is right. Adjustments is where surprise lives: a clawback from a returned sale or a netted deduction that was never itemised reads as an arbitrary haircut until the factsheet shows its arithmetic. And approvals is what turns the document from a claim into a record — the difference an audit trail makes when the auditor arrives months later.

How does each side use it?

The payer's finance team uses the factsheet as its maker-checker artefact: the checker reviews the workings rather than re-deriving them, approval authority is exercised against a complete picture, and at year-end the settlement file is audit-ready because every payout already carries its justification — the discipline behind a clean claim settlement process.

The payee — the distributor or dealer reading it — uses it to verify their own earnings without calling anyone. They check the counted invoices against their purchase register, follow the slab arithmetic, see why the net differs from the gross, and raise specific lines if something looks off. That self-service verification is what transparent claim submission promises from the other direction.

One honest note: a factsheet is a discipline, not a software feature. A rigorous team can produce one from a spreadsheet for every settlement — some do. What software changes is consistency and cost: the document is generated from the same data that computed the settlement, for every settlement, rather than assembled by hand for the contested ones after the argument has started.

How does ClaimDS handle this?

ClaimDS keeps every element of the factsheet on the settlement record itself, because each one is already part of how a claim moves through the system: the rebate agreement holds the scheme terms; the claim carries its evidence and the invoice-level base data it was validated against; the reconciliation shows matched and exception lines; approvals are recorded step by step in a tamper-evident audit log; and the settlement links to the credit note that executed it. The result is that "why is this number ₹X?" is answerable from one screen — and exportable to Excel when the payee wants to check it against their own records.

To see a settlement traced from scheme terms to credit note on live data, book a demo.

Where does tax fit?

The factsheet records what was settled; the tax treatment follows from who the payee is and what the arrangement says. Whether the settlement runs through a tax or commercial credit note is the Circular 251 question; whether TDS applies, and under which section, turns on the agency-vs-principal distinction — and none of it changes what the factsheet must show. Record the settlement completely, and the tax working has everything it needs.

Note: This article is general information about a documentation practice, not tax or legal advice. Tax positions belong to the linked guides and to your adviser.