Blog/Healthcare

A Weekly Claim Ageing Review for Hospital Insurance Receivables

Run a claim ageing review that shows where insurance receivables are stuck, who owns each bucket, and which claims need escalation this week.

By Sagar Makker · 6 min read · October 2026
Caregiver Nurse
In short
Ageing by days alone is not enough. Age claims by stage and by payer as well.
Give each ageing bucket an owner and an action, not just a colour.
Escalate the oldest high-value claims every week, with a named next step.
The problem

This post is for CFOs, revenue cycle heads and finance controllers at hospitals with significant insurance and scheme receivables. Most hospitals produce an ageing report, but it often shows totals by days outstanding without saying why claims are stuck or who should act. Old claims become harder to recover as documents get lost and staff move on. You will get a weekly review format that ages claims by stage and payer, assigns owners, and drives specific actions.

The monthly MIS shows insurance receivables split into zero to thirty, thirty-one to sixty, sixty-one to ninety and over ninety days. The over-ninety bucket keeps growing, and the CFO asks the TPA desk why. The answer is a list of reasons from memory: some claims are in query, some are awaiting documents, some were short paid and not followed up, and some nobody has looked at for weeks.

The report counts days from discharge, so it cannot separate a claim stuck in hospital hands, such as not yet submitted, from one stuck with the payer. Nobody owns specific buckets. When a senior TPA executive leaves, the claims they handled quietly age further. By the time the auditors ask about provisioning, many claims need reconstruction from scratch.

Why it happens
01Ageing measured only from discharge date, not by claim stage
02No split between claims waiting on the hospital and on the payer
03Ageing buckets with no owner or defined action
04Review held monthly at summary level rather than weekly at claim level
05Claims of departed staff not reassigned
How to fix it
1
Add stage to every claim
The finance controller adds a claim stage field to the tracker: not submitted, submitted, in query, approved awaiting payment, short paid under review, disputed. The TPA desk updates it as claims move.
2
Age by stage and payer
Finance produces an ageing view by stage and payer, not just days. This separates claims waiting on the hospital from those waiting on insurers, TPAs or schemes, and shows which payers are slowest.
3
Assign owners to every claim
The revenue cycle head assigns each open claim a named owner, and reassigns claims immediately when staff leave. Each bucket also has a defined next action, such as resubmit, escalate or dispute.
4
Hold a weekly claim-level review
Every week, the revenue cycle head and TPA desk lead review claims above a value threshold you choose and all claims beyond your oldest ageing bucket, agreeing one next step and date per claim.
5
Escalate by payer and value
For aged claims with the payer, the CFO uses agreed escalation routes such as the payer's provider relations team. Check payer agreements for escalation contacts and timelines. Record outcomes in the tracker.
Worked example
A hospital turns its ageing report into actions

A 300-bed hospital in Hyderabad had a large and growing over-ninety-day insurance balance. The ageing report only showed days since discharge. Finance added claim stages and owners, and the revenue cycle head began a weekly review of high-value and oldest claims. The first reviews revealed that a meaningful part of the old balance had never been submitted or was waiting on internal documents, not on payers. Those were fixed internally. Payer-side delays were escalated with specific claim lists. Over the following quarters, the review became routine, and the CFO could explain the receivables position to auditors with confidence.

Common mistakes
×
Ageing only by days since discharge
Days alone hide whether the hospital or the payer is causing delay. Add claim stage so internal delays are visible and fixable.
×
Reviewing totals instead of individual claims
Summary reviews produce explanations, not actions. Review specific high-value and oldest claims weekly, with one agreed next step and date each.
×
Leaving claims with staff who left
Unowned claims age silently. Reassign every open claim on the day someone leaves the TPA desk, and check the handover in the next review.
Where an AI agent helps
Input
Claim tracker, settlement data, query log and payer list
Agent does
Builds the weekly ageing view by stage and payer and lists claims needing action
Human gate
Revenue cycle head approves escalations and reassignments in the weekly review
Outcome
Weekly ageing pack with owners, next steps and escalation list
Checklist
Add a claim stage field to your claim tracker
Produce ageing by stage and payer, not only days
Assign a named owner to every open claim
Review high-value and oldest claims every week
Reassign claims on the day a team member leaves
Record payer escalations and outcomes in the tracker
What to measure
Receivables by stage and ageing bucket
Claims not yet submitted after discharge
Aged claims without a named owner
Days sales outstanding for insurance claims
Questions
What ageing buckets should a hospital use for insurance claims?

Many hospitals use thirty-day buckets up to ninety days and an over-ninety bucket, but choose what fits your payers. More important is adding claim stage and payer, so you can see why claims are ageing.

How often should we review claim ageing?

Weekly at claim level for high-value and oldest claims, and monthly at summary level for the leadership MIS. Weekly reviews keep actions moving; monthly views show trends.

How should we provision for old insurance receivables?

Provisioning policy depends on your accounting framework and auditors. Discuss it with your statutory auditor and use your stage-wise ageing data to support a reasoned estimate rather than a flat rule.

Who should own the claim ageing review?

The revenue cycle head should run it weekly with the TPA desk lead, while the CFO owns the monthly summary and payer escalations. Every claim still needs a named individual owner.

Keep reading
All posts →
Female HospitalHealthcare
Build a TPA Claim Follow-Up System That Does Not Rely on Memory
4 min readRead →
Doctors HospitalHealthcare
Fixing Medical Coding Errors That Hold Up Hospital Insurance Claims
6 min readRead →
Doctor PatientHealthcare
Reconciling TPA Short Payments and Claim Deductions Line by Line
7 min readRead →
Next step

Want this fixed in your business?

Send the workflow. You get a scope and a fixed price within two working days — or a straight answer that it isn't a fit.

Secure by default · find → fix → verify · authorised scope only
Send a brief →enquiry@xdqlabs.com