Build cash-flow visibility from receivables and committed purchases
For CFO / finance controller · Compare approaches
TL;DR — what you’ll learn
- Separate accrued billing revenue from expected cash collections in rolling hospital treasury forecasts.
- Group inflows and outflows by certainty tier—confirmed bank balances, scheduled TPA/corporate settlements, and committed purchase/payroll obligations.
- Model payer collection delays explicitly alongside non-deferrable payroll, statutory and critical supplier due dates.
- Preserve actual bank closing balances and prior forecast snapshots so variance explanations remain auditable.
Illustrative hospital administrative and operations coordination desk; not a client facility.
A 120-bed hospital reports strong monthly billed revenue, yet faces a short-term working-capital squeeze in Week 3 of its 13-week rolling cash view (CFW-13W-08). An expected ₹20.00 lakh bulk settlement from two Third-Party Administrators (TPAs) shifts outward by 14 days while pending query responses are reviewed, whereas ₹42.00 lakh in staff payroll, statutory tax remittances and critical reagent supplier payments remain strictly due in Week 3. A finance report that equates billed inpatient revenue with available cash gives leadership no warning of the ₹22.00 lakh timing gap.
For hospital CFOs, controllers and promoters, the essential question is how to build a rolling cash-flow forecast from actual receivable ageing and committed purchases without hiding collection timing risks.
Separate booked revenue from expected cash
Hospital revenue and hospital cash move on different clocks. Outpatient cash and UPI collections settle within 24–48 hours, whereas credit bills under insurance TPAs, corporate tie-ups and government schemes pass through discharge documentation, submission, query adjudication, deduction review and batch remittance before reaching the bank. Meanwhile, outflows follow rigid calendars: monthly salary runs, PF/ESI/TDS statutory dates, loan EMIs, equipment lease instalments and critical pharmacy/implant vendor credit limits.
Bahmni billing and accounting and Hayati TPA billing illustrate the operational boundary between hospital billing/accounting records and external TPA claim workflows (reference context only; treasury management, banking covenants and tax remittance schedules require review by the hospital’s finance controller and treasury/tax advisers).
In the illustrative CFW-13W-08 Week-3 cash-flow bridge (all figures in ₹ Lakh), base-case and delayed-payer scenarios are compared against committed obligations:
Scroll horizontally to see all columns.
Cash-flow component (Week 3 of CFW-13W-08) | Base scenario (₹ Lakh) | Delayed-TPA scenario (₹ Lakh) | Variance (₹ Lakh) | Source record & owner |
|---|---|---|---|---|
| Opening reconciled bank balance | ₹35.00 | ₹35.00 | ₹0.00 | Confirmed bank statements (Treasury) |
| Direct OPD/IPD cash & gateway settlements | ₹28.00 | ₹28.00 | ₹0.00 | HIS collection & gateway settlement logs (AR) |
| Scheduled TPA & corporate remittances | ₹20.00 | ₹0.00 | -₹20.00 | Approved/settled claim advice register (TPA desk) |
| Committed payroll, statutory & lease outflows | -₹30.00 | -₹30.00 | ₹0.00 | Locked payroll register & statutory calendar (HR/Finance) |
| Critical pharmacy, reagent & PO maturities | -₹24.00 | -₹24.00 | ₹0.00 | Three-way matched AP aging & PO schedule (AP/Stores) |
| Projected Week-3 closing cash position | ₹29.00 | ₹9.00 | -₹20.00 | ₹15.00L minimum operating buffer breached by ₹6.00L |
In the base scenario, Week 3 closes at ₹35.00L + ₹28.00L + ₹20.00L - ₹30.00L - ₹24.00L = ₹29.00L (above the hospital’s illustrative ₹15.00 lakh minimum operating buffer). When the ₹20.00 lakh TPA remittance shifts by two weeks, projected closing cash drops to ₹9.00L (₹6.00L below the ₹15.00 lakh buffer), triggering an early working-capital review.
Map commitment versus payment
A useful cash-flow tool does not treat every open invoice in the 30-day ageing bucket as equally collectible next week. Instead, it separates claims that have received a formal payer settlement advice from claims still in "Submitted" or "Query Pending" status, and pairs them with committed purchase orders (not just posted supplier invoices) so large upcoming capital or reagent deliveries appear before the invoice arrives.
Connect the rolling cash view to Use receivables ageing to select the next action, Automate hospital invoice matching at line level and Cost a service line without hiding allocation assumptions so that TPA claim aging, accounts-payable invoice holds and service-line consumable commitments feed the weekly treasury pack from verified subledgers.
Worked workflow
Original illustrative workflow. Follow the labelled transitions, including the exception paths.
- A · StepImport reconciled opening bank balances, AR claim-status aging and AP/PO commitments
- B · StepClassify expected cash inflows and outflows by certainty tier and week bucket
- C · StepRun base and delayed-payer sensitivity scenarios against minimum cash buffer rules
- D · DecisionAll subledger balances reconciled to bank and timing assumptions signed by owners?
- E · StepFlag unallocated bank receipts, unapproved AP deferrals or buffer breaches in treasury queue
- F · StepAR, AP and CFO owners update collection evidence or approve vendor payment scheduling
- G · StepCFO approves locked weekly cash forecast and working-capital action plan
- H · StepArchive snapshot for next week actual-vs-forecast variance reconciliation
Scroll horizontally to see all columns.
| From | Condition | Next |
|---|---|---|
| A: Import reconciled opening bank balances, AR claim-status aging and AP/PO commitments | Continue | B: Classify expected cash inflows and outflows by certainty tier and week bucket |
| B: Classify expected cash inflows and outflows by certainty tier and week bucket | Continue | C: Run base and delayed-payer sensitivity scenarios against minimum cash buffer rules |
| C: Run base and delayed-payer sensitivity scenarios against minimum cash buffer rules | Continue | D: All subledger balances reconciled to bank and timing assumptions signed by owners? |
| D: All subledger balances reconciled to bank and timing assumptions signed by owners? | No | E: Flag unallocated bank receipts, unapproved AP deferrals or buffer breaches in treasury queue |
| E: Flag unallocated bank receipts, unapproved AP deferrals or buffer breaches in treasury queue | Continue | F: AR, AP and CFO owners update collection evidence or approve vendor payment scheduling |
| F: AR, AP and CFO owners update collection evidence or approve vendor payment scheduling | Continue | C: Run base and delayed-payer sensitivity scenarios against minimum cash buffer rules |
| D: All subledger balances reconciled to bank and timing assumptions signed by owners? | Yes | G: CFO approves locked weekly cash forecast and working-capital action plan |
| G: CFO approves locked weekly cash forecast and working-capital action plan | Continue | H: Archive snapshot for next week actual-vs-forecast variance reconciliation |
Compare base and delayed-payer scenarios
Three data gaps regularly distort hospital cash forecasts: bulk TPA bank transfers that sit in an unallocated receipt suspense account because remittance advice files have not been matched, emergency implant or drug purchases ordered outside standard PO workflows, and patient refunds or consultant payouts approved mid-week without updating the outflow schedule. Additionally, overwriting last week’s forecast tab with this week’s actuals destroys the team’s ability to learn which payer buckets consistently slip.
In the CFW-13W-08 workflow above, decision gate D blocks publication of the weekly forecast until bank balances reconcile and any buffer breach (₹9.00L vs ₹15.00L threshold) has an owner-reviewed action note (E and F) before CFO sign-off (G).
Update forecasts without overwriting actuals
Pilot the 13-week rolling cash model (CFW-13W-08) over four consecutive weekly cycles alongside existing treasury spreadsheets. Require each week’s opening balance to tie exactly to bank statements, track forecast-to-actual variance by inflow/outflow category, and test the delayed-payer scenario (-₹20.00L) so finance can sequence non-clinical discretionary spend without touching statutory dues or critical medical supplies.
Cash-flow planning software organises receivable, payable and bank data under transparent assumptions; credit facility decisions, statutory remittance compliance and vendor payment approvals remain with the CFO and authorised finance signatories.
Next actions
- Split your accounts-receivable forecast feed by claim stage (adjudicated settlement advice received vs submitted/queried) rather than using flat ageing percentages.
- Run the Week-3
CFW-13W-08base (₹29.00L) and delayed-TPA (₹9.00L) scenarios to establish an explicit operating cash buffer trigger. - Lock each weekly forecast snapshot before rolling forward so Friday treasury reviews compare actual collections against the prior week’s committed assumptions.
Discuss this workflow
Request a workflow assessment focused on this question: Which uncertain collections and commitments should a hospital expose in a cash forecast?
Describe the operation using business information only. Please leave out patient details.
Applying this guide
The scenarios and numbers are illustrative. Confirm these provider-specific inputs before implementation:
- CFO, financial controller and treasury lead: Approved 13-week cash-flow structure, certainty-tier definitions and minimum operating buffer policy (`CFW-13W-08`).
- Accounts receivable / TPA desk lead and accounts payable manager: Signed weekly collection assumptions and three-way matched supplier maturity schedules tied to subledger exports.
- ERP / finance systems administrator: Automated snapshot archiving preserving prior forecast versions alongside actual bank reconciliation imports.
References
- Bahmni billing and accounting — Illustrates separation between clinical events, billing and ERP/Odoo accounting; not tax or accounting-policy authority.
- Hayati TPA billing — Illustrates hospital-side TPA billing alignment versus external payer decisions; feature descriptions are not outcome proof.
Topics: hospital budget cash flow · hospital cash forecast · hospital working capital planning · healthcare budget cash flow