An accounts receivable report shows balances that remain open in the billing records. An aging report groups those balances by how long they’ve been outstanding. In pharmacy medical billing, it helps you find unpaid vaccine, testing, consultation and equipment claims, then distinguish payer follow-up from payment posting or patient-balance work.
The useful number is the remaining balance after the relevant payments and adjustments. A report can still show a $300 charge after the payer has paid and the pharmacy has collected part of the patient share. The example below follows that claim to its actual $20 remainder, then explains why the same balance can appear in different aging columns.
What the report includes
A summary report groups balances by payer, patient, location or another category. The detail view shows the claims or invoices behind a total. Start with the summary to find a payer or location worth investigating, then open its detail before deciding what to do with the money shown.
Read the report’s balance definition alongside its columns. Gross billed charges, balances after posted payments and adjustments, and an estimate of expected collections answer different questions. HFMA’s financial definitions distinguish net receivables from amounts before contractual and other allowances. A billing report may not apply all of those accounting estimates, so its total may differ from the receivable on the financial statements.
For a pharmacy, keep medical-benefit claims distinguishable from prescription claims and retail customer accounts. The same patient or service may appear in more than one system. If dispensing-system data creates a downstream medical claim, establish which record owns the receivable before adding both exports together. Our medical versus pharmacy benefit guide explains the billing channels.
Also check whether the report includes unsubmitted claims and unbilled encounters. A report built only from submitted claims cannot show clinical work that never reached submission.
How a $300 claim leaves $20 outstanding
Consider a hypothetical pharmacy-supplied equipment claim billed at $300. The payer allows $200, pays $160 and assigns $40 to patient responsibility. Its remittance identifies the other $100 as a contractual adjustment. Assume the pharmacy verifies that adjudication and has already collected $20 toward this equipment claim.
After correct posting, the claim has $160 in insurance payment, $100 in contractual adjustment and $20 in patient payment. Subtracting those three amounts from the $300 charge leaves $20. There is no remaining insurer balance in this example; the $20 is the remaining assigned patient share, subject to other coverage and applicable billing protections.
If the report still shows $300, inspect whether the payment and adjustment reached the claim. If it shows $40, check whether the patient’s $20 was applied. An old balance can reflect missing posting rather than money the payer still owes. CMS remittance guidance explains how the claim’s payments, adjustments and responsibility assignments are reported.
Match the patient receipt to the actual service. A prescription copay collected on the same visit does not automatically pay the equipment balance. Conversely, a verified payment for this equipment should not be collected a second time. If the payment is still an account credit, apply it to the supported charge before deciding what remains.
Credits can appear outside an aging total. For example, Jane’s A/R documentation says its report shows outstanding invoices without subtracting account credit. Check where your own report includes unapplied money.
A negative balance deserves its own review: it may reflect an overpayment, a duplicate posting or money applied to the wrong charge. Resolve its source and any refund obligation before offsetting it against unrelated unpaid claims.
What starts the aging clock?
An aging report may use columns such as 0–30, 31–60, 61–90 and over 90 days. Confirm whether the columns measure days outstanding or days past the due date; a current balance may not be overdue. Service date measures time since care; bill date measures time since billing; a responsibility-change date can measure time since a balance moved to another payer or to the patient. EZClaim documents separate report variants for those bases.
Suppose the equipment was supplied on August 1 and billed on August 21. On September 30, the claim is 60 days old by service date and 40 days old by bill date. If its remaining balance moved to the patient on September 20, responsibility-based aging could show 10 days. A move into a younger column changes the reported age, not the amount owed.
The report’s “as of” date answers a separate question: which point in time the balances represent. A September 30 snapshot can correctly include a payment that was still outstanding then, even if it arrived in October. When comparing reports, use the same cutoff, locations, account types, aging basis and treatment of credits.
A younger bucket does not restart a payer’s filing or appeal deadline. Use the deadline that applies to the claim and its notice. The timely-filing guide explains the evidence needed when receipt timing is disputed.
The claim status determines the follow-up
Age tells you how long a balance has remained open; the claim history tells you why. A rejected submission needs review of the rejection and submitted facts. A claim accepted for processing may need a status inquiry. An adjudicated denial needs its reason and the applicable correction or appeal route. Sending every aging claim again can create duplicates without resolving the original problem.
For Original Medicare, CMS lists claim-status options including contractor portals and electronic inquiries. Use the payer’s corresponding channel to establish whether it received and processed the claim. If the payer reports payment, compare the remittance and cash receipt with what was posted; our ERA reconciliation guide covers that match.
Keep insurer and patient follow-up separate. A balance grouped under a patient’s name can still include money awaiting insurance processing. Therabill’s documentation, for example, distinguishes a client view containing open insurance sessions from a finalized patient-due view. Read the responsibility and status fields before using a report to produce statements.
For the hypothetical $20 equipment balance, check any secondary coverage and patient protections before collection. CMS prohibits billing Qualified Medicare Beneficiaries for Medicare Part A or Part B cost sharing on covered services, including when the supplier is a pharmacy. A patient-balance label does not override that protection.
Why a lower total does not always mean more cash
A/R can fall because payments were posted, but also because charges were adjusted, reversed or written off. Compare the change with the period’s payment and adjustment activity before reporting it as improved collections. If a total does not reconcile, ask the billing or accounting owner to identify the transaction or report setting causing the difference rather than post a balancing adjustment without support.
For follow-up, compare like groups: the same payer, location, service type and aging basis. Put claims with approaching deadlines or an actionable rejection ahead of claims that merely sit in the oldest column. When a balance moves to secondary insurance or the patient, preserve access to its original service and submission history so the new grouping does not hide unfinished work.
