It is October 1 and you want to know what December looks like, so you open the profit and loss statement. Wrong report. The money you will deposit this quarter has already been earned — it is sitting in a claims queue right now, sorted into columns by how long it has waited. The report that tells you what Q4 holds is the one nobody reads on purpose.
The short version: your accounts receivable aging report is not a collections chore, it is a cash forecast you already own. Pull it and four numbers fall out: days in A/R, the share past 90 days, the dollars sitting past the point where your payer’s own clock ran out, and the same balance sorted by payer instead of by age. Apply a realistic collection likelihood to each bucket and you get a Q4 deposit estimate far more honest than anything on your P&L. In the illustrative practice below, $148,000 of face-value A/R is worth about $117,520 in cash — and the 21% sitting past 90 days produces only 10% of it. Rhode Island hands you a statutory clock, plus a 90-day trap that quietly voids it.
What your accounts receivable aging report actually is
Every practice management system produces one. It takes every unpaid claim and patient balance and sorts it by days elapsed since service or billing: current, 31 to 60, 61 to 90, 91 to 120, over 120. Most owners glance at the bottom-right total, decide it looks like last month, and close it.
That total is the least useful number on the page. The distribution is the forecast. A $148,000 balance almost entirely under 60 days is a comfortable quarter. The same $148,000 with a third past 90 days is a payroll conversation with yourself in mid-November. Same total, different Q4 — exactly what specialist bookkeeping for healthcare practices should surface monthly, unasked.
It forecasts for a structural reason: cash lags production. What you collect in October, November and December is mostly what you billed in August, September and October. You are reading a delivery schedule, not predicting the future.
The four numbers to pull off the report
1. Days in A/R
The formula:
- Days in A/R = total accounts receivable ÷ average daily net charges
- Average daily net charges = annual net charges ÷ 365
A practice collecting roughly $840,000 a year generates about $2,301 a day in net charges. Carry $148,000 of A/R against that and you are at 64 days. Compiled guidance puts the target under 40 days, usually attributed to MGMA; some revenue-cycle sources cite 30 to 40 attributed to HFMA. Treat those as rules of thumb, not settled data — the datasets are proprietary and secondhand versions disagree. The direction is not ambiguous: 64 is a long way from 40, and the gap is weeks of your own money.
2. The share past 90 days
This is the number that predicts pain. The commonly cited target is less than 10% of A/R past 90 days, widely attributed to HFMA. Sources disagree on the bucket — some set a similar ceiling at 60 days, a tougher standard. Pick one, write it down, measure the same way monthly. The trend line matters more than whose threshold you borrowed.
3. Dollars past the payer’s own deadline
Almost nobody computes this one, and it carries the leverage. Not “how old is this claim” but “how far past the deadline the payer is bound to.” In Rhode Island that deadline is statutory. Those dollars are not merely aged — they are overdue in a sense you can act on.
4. The same picture, by payer
Age buckets hide the diagnosis. Sort the same balance by payer and the story usually collapses into one or two names: a plan running 30 days behind everyone else, or one whose denials your team quietly stopped reworking. An aging problem is almost never evenly distributed, and you cannot fix what the report averaged away. If your system will not produce that view cleanly, fix that first — a QuickBooks advisor in Rhode Island and books that reconcile to your practice management system pay for themselves here alone.
Rhode Island gives you a clock: R.I. Gen. Laws § 27-18-61
Most owners chasing a slow payer are negotiating from feel. In Rhode Island you do not have to — the prompt-processing statute sets actual day counts.
What the statute requires
- Thirty calendar days to pay a complete electronic claim from the date of receipt.
- Forty calendar days to pay a complete written claim from the date of receipt.
- If a claim is denied or pended, the plan has thirty calendar days from receipt to notify you in writing of every reason and what additional information it needs.
- Late payment accrues interest at 12% per annum, starting on the 31st day after receipt of a complete electronic claim, or the 41st day for a complete written claim.
- The plan must establish a written standard defining what counts as a complete claim and distribute it to all participating providers.
That last bullet is the sleeper. “Complete claim” is not defined in the statute — each plan defines it and must give you that definition. If your billing team has never read the completeness standard for your top three payers, request it. A claim returned as incomplete is a claim on which the clock never started.
Parallel sections carry identical terms for the other carrier types — § 27-20-47 for nonprofit medical service corporations, § 27-41-64 for HMOs. The carrier’s corporate form does not change the clock.
The 90-day trap that voids your protection
The statute carves out an exception most practices walk into without noticing. A plan is not in violation for a claim initially submitted more than ninety days after the service is rendered, or resubmitted more than ninety days after the provider received the plan’s notice.
Read that again with your aging report open. Anything in the 91-to-120 and over-120 columns that was slow to go out the door, or has sat unworked since a denial arrived, may fall outside the statute entirely. The clock protects claims you submitted promptly and are actively working. It does nothing for a claim your team parked. That is the strongest argument there is for a weekly aging review.
What eastern Massachusetts practices get instead
If you practice in Franklin, Bellingham or Attleboro, do not assume the Rhode Island numbers travel across the line. Massachusetts gives providers no equivalent statutory clock — c. 176O, § 6 governs evidence of coverage, not payment deadlines. On that side your enforceable deadline is the one in your payer contract, which means somebody has to read the contract. Medicare runs on its own schedule either way: contractor guidance describes a payment floor of 13 days for electronic claims and 28 for paper, with interest on clean claims unpaid past day 30.
Turning the aging report into a Q4 cash number
Take each bucket, apply a collection likelihood, add it up. The practice below is an illustrative composite — a solo internal medicine practice in North Providence collecting roughly $840,000 a year. Not a real client, not a benchmark.
The percentages in the third column are planning placeholders, not industry data. There is no authoritative recovery rate by aging bucket, and anyone quoting one precisely is guessing. Build yours from your last four quarters: what share of each bucket actually became cash.
| Aging bucket | Balance | Assumed collection rate | Expected cash |
|---|---|---|---|
| 0 – 30 days | $62,000 | 96% | $59,520 |
| 31 – 60 days | $34,000 | 90% | $30,600 |
| 61 – 90 days | $21,000 | 75% | $15,750 |
| 91 – 120 days | $13,000 | 55% | $7,150 |
| Over 120 days | $18,000 | 25% | $4,500 |
| Total | $148,000 | — | $117,520 |
Three things fall out of that table immediately.
- The face value overstates the cash by $30,480. If you have been mentally banking $148,000, your quarter is planned around money that is 21% imaginary.
- The $31,000 past 90 days produces $11,650. That is 21% of the balance delivering 10% of the cash. Aged A/R does not sit still; it evaporates.
- Sixty-four days against a sub-40 rule of thumb strands about three and a half weeks of collections in the pipe. At $70,000 a month, closing half that gap is a five-figure one-time cash release — without one additional patient.
That expected-cash figure is what belongs in your forecast. Drop it into a rolling 13-week cash flow forecast beside payroll, rent, debt service and the January estimated tax payment, and you will see your trough week coming instead of meeting it. Practices in Smithfield and Johnston routinely find the week they dreaded is six weeks out and manageable with two calls made early.
The Q4 timing problems the aging report will not show you
The aging report forecasts collections well. It is not a complete forecast of your cash, because three fourth-quarter mechanics sit outside it.
- The holiday production gap. Late November and December lose clinical days to closures and no-shows. Because cash lags production, that dip lands in your account in January and February, not December. The October report cannot see it.
- The January 1 deductible reset. By Q4 more of your panel has met their deductible, so more of what you produce is paid by the plan. January 1 reverses that, the patient-responsibility share jumps, and patient balances collect more slowly than payer balances. A healthy Q4 aging report can be followed by a Q1 that is not, for reasons unrelated to how well you work claims.
- Year-end cash commitments. Equipment bought before December 31 for tax reasons, bonuses, the January estimated tax payment. Decisions, not collections — but they belong beside the A/R number. Coordinate with your tax planning and check the Rhode Island filing deadlines first.
A 30-day plan
- Week 1: compute the four numbers, then request the completeness standard from your top three payers. It tells you exactly why claims are being pended.
- Week 2: work the 61-to-90 bucket first, not the oldest. Counterintuitive and correct. Those claims still have real recovery value and may still sit inside the 90-day window. The over-120 column is a write-off decision, not a collections project.
- Week 3: name an owner and a date for every balance over $1,000 past 60 days. Not “billing is on it.” A person and a calendar date.
- Week 4: build the expected-cash table from your own recovery history, load it into a 13-week forecast, and put a 30-minute aging review on the calendar every week.
The practices that fix this do not have better software. They have somebody who reads the report on a schedule. That habit is most of the gap between getting surprised and not — and much of what a fractional CFO quietly does. The 16 parts of your business maps where else it is missing.
Frequently asked questions
What is a good days in A/R for a medical or dental practice?
Compiled guidance points at under 40 days, usually attributed to MGMA, with some revenue-cycle sources citing 30 to 40 days attributed to HFMA. Treat these as rules of thumb, not verified benchmarks — the underlying datasets are proprietary and secondhand versions disagree. The more useful test is your own trend: if days in A/R climbs quarter over quarter, something in your billing process broke, wherever you sit against a published figure.
How long does an insurer have to pay a claim in Rhode Island?
Under R.I. Gen. Laws § 27-18-61, a health plan must pay a complete electronic claim within 30 calendar days of receipt and a complete written claim within 40. If it denies or pends a claim it has 30 days from receipt to notify you in writing of every reason and what more it needs. Late payments accrue 12% per annum interest from the 31st day for electronic claims, the 41st for written. Sections § 27-20-47 and § 27-41-64 apply the same terms to other carrier types.
Does Rhode Island’s prompt-pay law cover every unpaid claim?
No, and this is the part that catches practices out. The statute does not apply to a claim initially submitted more than 90 days after the service was rendered, or resubmitted more than 90 days after you received the plan’s denial or pend notice. Claims submitted late, or dropped after a denial, may sit outside the protection entirely — which is why the 61-to-90-day bucket deserves attention before the oldest one.
What percentage of accounts receivable should be over 90 days?
The most commonly cited target is under 10%, generally attributed to HFMA. Sources disagree on the bucket — some apply a similar ceiling at 60 days, a tougher standard. Choose one definition, apply it consistently, watch the direction of travel. A practice moving from 21% to 14% is doing something right even while above anyone’s threshold.
Can I really forecast Q4 cash from an aging report?
You can forecast the collections portion well, because cash lags production by weeks and Q4’s raw material is already in the pipe on October 1. Apply your own historical recovery rate to each bucket and the estimate is usually close. What the report cannot see is holiday production gaps, the January 1 deductible reset, and year-end commitments like equipment purchases and the January estimated tax payment — those belong beside the forecast, not inside it.
Bottom line
Your accounts receivable aging report is the most predictive document in the practice and the least read. It tells you what next quarter deposits, which payer is the real problem, and which dollars sit inside a window you can enforce. In Rhode Island that window has teeth: 30 days electronic, 40 written, 12% interest — and a 90-day trap that punishes claims nobody works.
None of this needs new software or a bigger billing team. It needs four numbers, a collection-likelihood column built from your own history, and someone reading the report weekly instead of quarterly. The practices blindsided in December almost always had the answer sitting in a report on October 1.
Want a second set of eyes on your aging report before Q4 closes? Send your aging summary and last three months of collections and we will build the expected-cash table with you on a call — you leave with a real Q4 number, not a face value. Book a free 30-minute consultation, or read how CFO advisory works with a CFO advisor in Rhode Island. Still weighing books against strategy? Start with bookkeeper vs. CFO advisor, the seven signs it is time, and what it costs in Rhode Island.
General information for Rhode Island and Massachusetts practice owners, not tax, legal or billing-compliance advice. Dollar figures and collection rates are an illustrative composite — not real client results, not benchmarks. Day counts were verified against the published text of R.I. Gen. Laws §§ 27-18-61, 27-20-47 and 27-41-64.
by