Why two reports in your office give two different A/R totals

What each report is actually counting

Before you can reconcile anything, you have to accept that you are holding three answers to three questions. The totals were never supposed to match. Here is what each one is actually asking.

The insurance aging report

Which claims have left this office and not come back resolved. This is a list of CLAIMS, not a list of dollars owed, and the dollars printed beside each line are what was billed to the payer. It says nothing about whether the payer agreed to any of it.

The accounts receivable report

How much does this practice expect to receive, from every party. It is organised around the ACCOUNT, meaning the person or family responsible for the balance, and it usually nets an estimate of the insurance portion out of what it shows as the patient's share.

An analytics dashboard

What is outstanding with payers right now. Most analytics layers are answering a version of the first question with a version of the second question's dollars, which is exactly why a third number appears the moment you add one.

The consequence that catches people out is this. A claim can be open on the aging report and contribute nothing at all to accounts receivable, because the ledger has already treated that treatment as settled. Nobody made a mistake. One report tracks the paperwork, the other tracks the money, and paperwork and money finish at different moments.

It is worth being precise about what the aging total means, because the word people reach for is usually wrong. The dollars on that report are billed dollars: a signal worth reviewing, never confirmed loss and never confirmed collection. Write offs, patient responsibility and contractual adjustments all still sit between that number and your bank account.

The five reasons the totals differ

When the gap is bigger than you can explain, it is almost always one of these five, and usually more than one at once. None of them is exotic.

1. 1Claims that were paid but never closed. The payment posted to the account and nobody moved the claim itself to a finished status. On screen it looks like an open claim sitting in an old age column beside an account whose balance is square. This inflates the aging report only. Accounts receivable is already correct, which is why collections can be healthy while the aging total climbs.
2. 2Duplicates from resubmission. When a claim is corrected and sent again, most systems create a second claim record rather than replacing the first. One piece of treatment now appears twice, often in two different age columns. This inflates the aging report and leaves A/R untouched, because the account was only ever charged once.
3. 3Patients who are no longer covered. The plan lapsed or the patient changed employers between the appointment and the submission. The claim stays open forever with a payer who will never pay it, while the balance has usually already moved to the patient. This inflates the aging report and can double count the same treatment across both reports until somebody resolves the claim.
4. 4Estimates nobody revisited. The office estimated one figure at treatment planning, the payer allowed another, and the difference sits quietly inside the account balance until someone posts an adjustment. This one distorts accounts receivable rather than the aging report, and it is the reason an A/R total can drift without a single new claim.
5. 5Different date bases. Two reports can age the same claim from two different dates, which puts one piece of work in two different buckets on the same morning. This is the one that makes reports look broken when they are not, so it has its own section below.

Each of those has a different fix, which is the practical reason to classify before you act. A practice that reads the whole gap as a collections problem will spend a week calling payers about claims that were settled months ago.

Estimated insurance versus billed

This is the single biggest source of disagreement, and it is by design rather than by accident.

Practice software stores an estimate of what insurance will pay on a claim, computed from the fee schedule and the plan details on file. That estimate is what an accounts receivable report nets out of the account balance, so the figure it shows you is the portion the office believes the patient will end up owing. The aging report shows the other number entirely: what was billed to the payer. Same claim, two different dollar figures, both stored deliberately.

The consequence is one an office feels every month. An account carrying a large estimated insurance figure shows a small patient balance, so it looks quiet in every patient facing view and may be excluded from statements entirely. The same account can be sitting near the top of the aging report at the same time. Neither view is lying to you. One is asking what the patient owes, the other is asking what the payer has not answered.

The mechanics of how that estimate is calculated, why it goes stale, and what it does to a statement run are covered in estimated insurance and your A/R.

When a report thinks a claim happened

There are at least three dates attached to any claim that has been worked more than once: the date of service, the date the claim was first submitted, and the date it was last submitted. A report has to pick one to age from, and different reports in the same office frequently pick differently.

What each choice does to the picture

• Aged from the last submission. Every resubmission resets that claim to zero days. A claim that has been chased for the better part of a year appears in the newest bucket the morning after somebody resends it, and the oldest column looks reassuringly short.
• Aged from the first submission. Closer to honest, but it still hides the time between the appointment and the day the claim finally went out, which is often where the delay actually started.
• Aged from the date of service. Resubmission proof. The clock started when the treatment happened and nothing an office does afterwards can wind it back, which is also the basis a filing deadline is measured from.

Neither of the first two is wrong in itself. The problem is comparing them. Two reports on two date bases will disagree about which bucket a claim belongs in and therefore about every subtotal on the page, even when they agree perfectly about the grand total. Before you reconcile anything, find out what each report ages from, because a mismatch here can look like a missing claim when nothing is missing. Why claim age should run from the date of service goes into what this does to a worklist.

How to reconcile them in one sitting

This is a task, not a project. If it is taking more than a morning, the process below has gone wrong somewhere rather than the data.

1. 1Pick one as of date and run every report on it. Two reports run on two different days, or one run at lunchtime and one after the afternoon posting, will differ for that reason alone. Freeze the date first, because whatever gap that removes was never a reconciliation problem.
2. 2Export both to a spreadsheet and join on the claim identifier. Not on the patient. Families share accounts, patients have multiple claims, names are entered inconsistently, and a join on a person will produce differences that are artefacts of the join rather than of the reports. If one export has no claim identifier, that is the first thing to fix.
3. 3Sort the differences by size, not by age. Instinct says start with the oldest. Arithmetic says start with the largest. If a small handful of claims is carrying most of the gap, a descending sort puts them in front of you in the first minute, and if none is, you have learned that too.
4. 4Classify each difference into one of the five causes. Write the cause beside the row. This is the step people skip, and it is the only one that produces anything reusable: by the end you will know which of the five your office actually has, which tells you what to change on Monday.
5. 5Fix the causes, not the totals. Close the claims that were paid. Resolve the duplicates. Move the balances for lapsed coverage. Post the adjustments the payer already decided. The totals then agree as a result, which is the only version of agreement that stays true next month.

Which number to run the office on

The honest answer is that you need both, for different jobs, and most of the confusion in an office comes from using one where the other belongs.

Use the insurance aging report as your worklist. It is a list of discrete items a human being can act on today: call this payer, resend that claim, attach the radiograph. Every line has an owner and a next action. That is what makes it useful in the morning and useless in a board meeting.

Use the accounts receivable report for financial reporting. It is the one that includes patient responsibility, which means it is the one that reflects what the practice is genuinely owed by everybody. That is what makes it right for the accountant and hopeless as a call list.

Never substitute one for the other. Working A/R as a claims list sends staff after patients for money an insurer has not answered on yet. Reporting on the aging total tells an owner the practice is owed money that patients may in fact owe, or that nobody owes at all.

If you want one figure that travels between reports with the least damage, use the count of open claims over a chosen age. Not a dollar total. A count. It cannot be distorted by an estimate or an adjustment, and once the age basis is settled it goes up and down for close to one reason, which is whether the claims are being worked. Settle the basis first: a count over ninety days is still two different numbers if one report ages from the date of service and another from the last submission.