Commission Receivable Ageing and Broker Working Capital

A broking firm's debtor ledger looks safe. Its commission debtors are two dozen IRDAI-registered insurers, every one solvent, supervised and holding regulatory capital. The intuition follows: insurers do not default, so commission receivables need no ageing, so the ledger sits as one number called accrued commission.

That is wrong for a reason unrelated to insurer credit. Commission receivables go bad through reconciliation failure, not counterparty failure. A placement binds in May, the accrual posts in May, the insurer's statement arrives in September with a different policy number, a different rate, or no line at all, and nobody has time to chase INR 40,000 across two systems. The balance does not default. It ages, gets written off eighteen months later as a prior period adjustment, and nobody learns which insurer or line produced it.

The sums are large. A firm placing property and engineering at brokerage of 7 to 12.5 percent, and liability at 10 to 15 percent, carries a receivable worth a tenth of every rupee of premium it touches. That debtor is the biggest current asset on the balance sheet, and the asset the bank holds security over.

What follows is about that asset, not about the future shape of commission, which is worked through in the companion piece on trail commission and broker cash-flow planning. This one assumes today's pay structure and asks a duller question: of the money you have already earned, where is it?

An ageing schedule is arithmetic performed on a date. Get the date wrong and every bucket below is decoration. Four candidates sit on any placement:

1. Bind date, when cover incepts and the placement obligation is discharged.
2. Premium receipt date, when the client's money reaches the insurer and the policy is on risk under Section 64VB of the Insurance Act, 1938.
3. Statement date, when the insurer's commission statement first names the entry.
4. Credit note date, when the insurer raises the instrument the firm gets paid against.

These can span five months on one account. Ageing from the credit note date is the commonest choice because it is what the accounting system captures, and the worst available: it resets the clock every time the insurer is slow, so a balance outstanding since April reads as current in September. The schedule then reports that nothing is old, the exact failure mode it exists to prevent.

Age from the entitlement date: the date the firm's right became unconditional, for most direct placements the later of bind and premium receipt. That change usually adds sixty to ninety days to the apparent age of the book on day one, which is uncomfortable and correct.

A single-column ageing tells the finance controller that INR 3.4 crore is over 90 days. It does not tell anyone what to do on Monday. It earns its keep only when cut along dimensions that match somebody's job.

• By insurer. Two or three insurers usually hold most of the aged balance, and the cause is structural: a statement format that omits the firm's own policy reference, or an accounts team that reconciles quarterly. A solvable problem, once it has a number attached.
• By line of business. Retail health and miscellaneous retail, at realised yields of 15 to 20 percent including variable components, throw off high volumes of small entries and therefore the long tail of unmatched lines. Large-risk commercial, at realised yields of 8 to 10 percent, produces few entries, each material alone.
• By reason code. Not aged, but why: rate dispute, policy-reference mismatch, co-insurance share unallocated, endorsement not flowed through, statement line never raised, or awaiting the insurer's payment run. Only the last is a timing item. The rest are defects.

The reason-code cut is the one firms skip and the one that changes behaviour. When 60 percent of the over-90 balance reads "policy reference mismatch", the fix is a field in the placement system, not a call to the insurer's finance head.

Days sales outstanding transfers to broking with one adjustment: the denominator is commission income, not premium handled. A firm computing DSO on premium is measuring the insurer's collection cycle, not its own.

Use commission days outstanding: closing commission receivable divided by commission income for the period, times days in the period, computed monthly on a rolling twelve-month base so a lumpy renewal quarter does not distort it.

Take a firm with INR 30 crore of annual commission income and a closing receivable of INR 8.6 crore. That is 105 days of its own revenue in other people's ledgers. Whether that is good depends on the decomposition:

1. The insurer's payment cycle, a monthly or fortnightly statement run with a defined lag. Contractual and irreducible; call it 30 to 45 days.
2. The accrual-to-statement lag, between booking the accrual and the entry appearing on any statement. Documentation speed, entirely the firm's to fix.
3. The reconciliation tail, everything beyond the point where both parties agree the entry exists. Should be near zero. Rarely is.

If 105 days splits into 40 contractual, 25 documentation and 40 tail, roughly INR 5.3 crore of the balance is self-inflicted. At a working-capital cost of 9 percent the firm spends close to INR 48 lakh a year financing its own filing habits. That is the sentence that gets the project funded.

Commission receivables are trade receivables without a significant financing component, so Ind AS 109 requires the simplified approach: a lifetime expected credit loss from initial recognition, with no staging assessment and no waiting for a significant increase in credit risk. There is no judgement about whether to provide, only about how much.

The route is a provision matrix: loss rates applied to ageing buckets, derived from the firm's own write-off experience. Firms go wrong in two opposite directions.

The first error is providing nothing, on the argument that insurers are investment-grade counterparties whose default probability is negligible. This mistakes the loss driver. The write-off history of a commission ledger is not a default series. It is a series of amounts abandoned because reconciling them cost more than they were worth. A firm that has written off aged commission in each of the last five years and provides nothing is asserting that this year is different.

The second error is a generic corporate matrix borrowed from a client's manufacturing template. A commission loss curve is shaped differently: flat and low through the contractual cycle, then rising sharply once an entry passes the point where both accounts teams have moved on to next quarter's statements.

Build it from the actual series: take 36 months of accruals by cohort, measure what proportion of each was ultimately collected, credited away or written off and at what age, derive a loss rate per bucket from that curve, and re-derive annually.

One refinement earns its cost: split the matrix by reason code as well as age, because a 120-day balance coded "awaiting payment run" and one coded "rate disputed" have different collection odds. With that split the provision stops being a plug and becomes a forecast, which is the only form an auditor accepts without argument.

One boundary matters for presentation: commission recognised but still conditional on something other than the passage of time is a contract asset rather than a receivable, presented separately though still carrying expected credit loss. That line is drawn in the Ind AS 115 piece on broking revenue.

Most mid-sized broking firms run a cash-credit or overdraft limit secured on current assets, and the security is overwhelmingly the commission receivable. That makes the ageing schedule a financing document.

Drawing power is computed on eligible receivables, and age is the eligibility test. Facility terms commonly exclude book debts beyond 90 days entirely, then apply a margin (often 25 percent) to what survives. On the INR 8.6 crore ledger above, if INR 3.4 crore is beyond 90 days, the eligible base is INR 5.2 crore and the drawing power INR 3.9 crore, against a sanctioned limit that may be far higher. The firm believed it had a limit. What it has is an ageing profile.

So ageing improvement is a financing event: pulling INR 2 crore out of the over-90 bucket raises drawing power by INR 1.5 crore at no cost of capital. The reporting duty turns it into an audit finding. CARO 2020 requires the auditor to report, where a company has been sanctioned working-capital limits above INR 5 crore in aggregate from banks on the security of current assets, whether the quarterly returns filed with those lenders agree with the books of account, and to give details where they do not. Broking firms file periodic book-debt statements on a different ageing basis than the finance system uses. The two will not agree, and the auditor must say so by name.

Covenants compound it. A current-ratio covenant is satisfied by an ageing receivable right until it is provided against, at which point the provision hits both the numerator and the profit servicing interest cover. A firm that under-provides for three years and corrects in one is triggering an event of default on a balance that went bad slowly.

Aged commission receivables draw audit attention out of proportion to their size, sitting at the intersection of an estimate, a revenue cut-off and a bank security.

1. "Confirm the balance." Under SA 505, External Confirmations, the auditor circularises a sample of insurers, and the reconciliation tail becomes visible to somebody outside the firm: the insurer confirms its own ledger, and the difference is the item nobody could match.
2. "How did you build the loss rate?" SA 540 governs the audit of accounting estimates, and the matrix is one. Expect to produce the cohort data, the method, and why it moved or did not from last year. A matrix with no underlying data is not a weak estimate; it is an unsupported one, a worse category.
3. "Show the cut-off." The auditor tests both sides of 31 March against bind dates, not credit-note dates.
4. "Disputed or undisputed?" Schedule III forces the split and it is substantive. An entry argued over with an insurer for eight months is disputed, and calling it undisputed to dodge the disclosure misstates the accounts.

None of these is answerable in March. All are trivial for a firm that reconciled monthly all year.

The distance between a typical broking ledger and a defensible one is a short list of habits, none needing a system replacement.

1. Fix the entitlement date in the placement system and age from it. One field, one rule, every line.
2. Reconcile every insurer monthly. Matching a statement one month after the accrual costs a fraction of matching it at six, because the people who know what happened still remember. Reconciliation is a perishable good.
3. Code the reason on every unmatched line at discovery, from a fixed list of six or seven codes. No free text: the value is in the aggregation, and free text does not aggregate.
4. Report the ageing monthly, cut by insurer and branch, with the over-90 balance owned by a person rather than a department. Aged balances are collected by individuals who have been asked about them by name.
5. Rebuild the matrix annually from cohort data, split by age and reason code, and write the method down once.
6. Set a write-off policy with a threshold and an authority level, so small entries at a defined age are cleared deliberately rather than carried at a cost exceeding their value. A ledger that is never written off is not conservative. It is unmeasured.

The payoff is not accounting hygiene. A firm that pulls commission days outstanding from 105 to 70 releases a fifth of its annual revenue into its own bank account, permanently, without selling anything more. Around the INR 25 to 50 crore revenue band where broking economics start to work, that is the difference between funding the next hire from operations and funding it from the overdraft.