Pharmacy Claims Reconciliation: Matching What Each Plan Promised to What It Paid

The clock: when a Part D claim should be paid

For Medicare Part D, a federal rule sets the clock. Under 42 CFR 423.520, a Part D sponsor must pay a clean claim from a network pharmacy — other than mail-order and long-term care pharmacies — within 14 days after it is received if it is electronic, or 30 days for any other claim. An electronic claim counts as received on the day it is transferred. A claim is deemed clean if the sponsor sends no notice of a deficiency within 10 days of receiving it, and a clean claim paid late carries interest under the same section.

Commercial and Medicaid managed-care plans pay on the terms of their contracts and state rules, which the network agreement or the PSAO can state. The method does not change; only the clock does. Write each payer’s clock into the reconciliation sheet so that “late” means a number of days, not a feeling. This is rule text; what a contract allows is a question for the PSAO or the pharmacy’s attorney. Not legal advice.

A Georgia pharmacy owner put the cost of an unpredictable payment stream plainly in a 2022 letter to the FTC: “I can’t forecast the cash flow that other businesses use to grow.” Reconciliation does not make payers predictable. It makes the pharmacy’s own receivables visible, which is the input any forecast needs.

How to do pharmacy claims reconciliation each week

The method works in any stack, from a reconciliation module to a spreadsheet. It needs three inputs: the adjudicated claims report from the dispensing system, the 835 files (or paper remittances), and the bank deposits. None of them needs a patient name to be matched.

• Match each claim to its 835 line on the claim identifiers: prescription number, fill date, BIN and PCN, and the plan’s claim reference.
• Give every claim one status: paid as promised; short-paid (paid less than the promise); unpaid and inside its clock; unpaid and past its clock; reversed; or paid with no matching claim.
• Total each status by payer, and age the unpaid by days since the claim was transmitted, in bands set against each payer’s clock.
• Match each 835 to a bank deposit by amount and trace number. A deposit with no remittance, or a remittance with no deposit, is an exception of its own.
• Work the exceptions in order of dollars, oldest first, and write down the cause of each one.

Illustrative example: in a week with $40,000 promised, claims promised $38,500 were paid in full; 30 claims promised $1,000 were paid $400, a $600 shortfall; and claims promised $500 were unpaid — $300 still inside their clock, $200 past it. The $600 and the $200 are the week’s work list. Two lines come out of every week, both by payer — dollars short-paid against promise, and dollars unpaid past their clock — and those two lines matter more to a monthly owner review than the matched total.

Reading the adjustments on an 835

X12, which maintains the codes, says Claim Adjustment Reason Codes “describe why a claim or service line was paid differently than it was billed.” Each adjustment pairs a group code — CO for contractual obligation, PR for patient responsibility, OA for other adjustment, PI for payer-initiated reductions — with a reason code. A few that matter in pharmacy reconciliation:

• 45: “Charge exceeds fee schedule/maximum allowable or contracted/legislated fee arrangement” — the gap between the amount billed and the contracted price, expected wherever the pharmacy bills more than the contract pays.
• 130: “Claim submission fee.”
• 295: “Pharmacy Direct/Indirect Remuneration (DIR).”
• 253: “Sequestration - reduction in federal payment.”
• 133: “The disposition of this service line is pending further review” — a line X12 says requires a reversal and correction once it is finalized.

Not every reduction sits on a claim line. The 835 also carries adjustments at the payment level — recoupments of earlier payments, balances carried forward, fees taken in bulk — that belong to no single claim, and this is where a short deposit hides. The CORE rule adopted in 45 CFR 162.1603 on uniform use of these codes is why the same code should mean the same thing from every payer. Whether a given fee is allowed under the pharmacy’s contract is a question for the PSAO or its attorney, not for the code list.

What a PSAO report answers, and what it leaves to the owner

Where a PSAO or software vendor provides a reconciliation report, it answers the first question: was each claim paid what it was promised? Read it before building anything. By design, though, it compares two numbers the plan produced — the promise and the payment. It cannot say whether the promise itself covered what the drug cost, which plans make up most of the short-pays, or whether the short-pays flagged last month were chased and recovered.

Those are the owner’s questions, and they need the reconciliation joined to two more records: acquisition cost from wholesaler invoices, which turns a matched claim into a count of negative reimbursement by plan, and a log of short-pays chased and MAC appeals filed and won. A matched claim can still be a losing one.

Since January 1, 2026 there is one more stream to reconcile. Under the Medicare Drug Price Negotiation Program, the Medicare Transaction Facilitator began operating that day, and CMS says pharmacies receive remittance for maximum-fair-price refunds by paper check or by electronic remittance advice using the X12 835 standard. Those refunds belong in the same sheet, matched to the claims for the selected drugs and aged like any other receivable.

What bookkeeping does an independent pharmacy need every month?

Every month, an independent pharmacy needs its bank accounts reconciled, its plan receivables tied from claims to 835s to deposits, every fee and take-back on the remittances recorded where it can be totaled by payer, its wholesaler purchases matched to the statement, and the month’s source documents filed where they can be found years later. The weekly reconciliation above does the hard part of the receivables work; month-end turns it into balances the owner and the CPA can use.

The IRS lists the supporting documents a business keeps for its income and purchases, among them deposit information, invoices and proof of payment. In a pharmacy, that paper trail sits in the month’s claims reports, 835 files, deposit records and wholesaler invoices. Part D adds its own horizon: under 42 CFR 423.505(i), plan sponsors must require their first tier, downstream and related entities, a chain that 42 CFR 423.501 extends down to the ultimate provider of services, to agree that HHS, the Comptroller General or their designees may audit books and records related to the plan’s Medicare contract through 10 years from the end of the contract period or the completion of an audit, whichever is later. Ask the PSAO or the pharmacy’s attorney what each network agreement requires.

How any of these entries is treated for tax, including inventory and cost of goods sold, is a question for the pharmacy’s CPA. The bookkeeping job is to hand over numbers that are complete and tie out, in five month-end steps:

• Bank and card accounts: reconcile each one to its statement, and match every plan deposit to its 835 instead of posting it as one lump of sales.
• Plan receivables: carry the month-end balance of claims adjudicated but not yet paid, by payer, with the part past its clock shown on its own line. It should equal the open items on the reconciliation sheet.
• Remittance adjustments: record claim submission fees (code 130), DIR (code 295), sequestration (code 253) and recoupments by payer, in whatever account structure the CPA sets, so the dollars each plan took back are visible as one figure.
• Wholesaler purchases: match invoices, credit memos and returns to the monthly statement before paying it. The same invoices supply the acquisition cost used to find claims paid below cost.
• Medicare refunds: carry maximum-fair-price refunds still owed as their own receivable, and clear each one only when the payment arrives and is matched to the claims for the selected drug.

When this is not worth paying anyone for

A pharmacy whose PSAO or software reconciles every claim weekly, and whose owner reads the short-paid and past-clock totals by payer each month, has this covered. An owner who can run the five steps above in a spreadsheet and keep them going does not need outside help for reconciliation either.

Outside help earns its fee when the 835s arrive but nobody matches them, when deposits and remittances will not tie out, when payment-level adjustments are written off without a cause, or when reconciliation is one of several money questions at once. The free Cash Gap Calculator shows what slow payer cash does to the weeks ahead, and the Revenue Leak Calculator gives a rough first figure for the whole pharmacy.

Where the Revenue Review fits

The Revenue Review runs this reconciliation over twelve months and sets it beside the rest of the pharmacy’s money: claims paid below acquisition cost by plan, fees and true-ups matched back to the claims they came from, appeals filed and won, Medicare refunds outstanding, and cash tied up in inventory. It takes two weeks. It works from read-only access to aggregate exports the pharmacy already has — claims, remittance and fee totals, deposits — with no patient names, and it ends in a written report the pharmacy keeps: each leak with a monthly dollar figure wherever the records support one, a ranked list of what to fix, and a 90-day plan.

It does not replace the PSAO, chase payers on the pharmacy’s behalf, give legal advice, or take a share of anything recovered. It is built for independent pharmacies at $1 million a year and up, run by the pharmacist whose name is on the license. The next step is a free 20-minute call, where a pharmacy that does not need the Review is told so.