How to Record PBM Reimbursements in QuickBooks for Pharmacies

Short answer: When you fill a script you record revenue and a receivable. The copay collected at the register is a partial payment against that receivable, and the lump PBM EFT that lands days or weeks later is a payment against accounts receivable covering hundreds of claims, not new income. The gap between what you billed and what the plan allows is a contractual adjustment, which is contra revenue rather than bad debt. Booking that EFT as income on top of the revenue you already recorded at fill double counts your sales.

Last updated July 2026.

Why a pharmacy's bank statement lies to you

Open the bank statement for an independent pharmacy and you will see a handful of PBM deposits, each one a round-ish number with no obvious relationship to anything. That single deposit is not a sale. It is a lump remittance covering every claim in a payment cycle, sometimes hundreds of them, filled across a range of dates that ended before the deposit was cut.

Three things make the deposit misleading. It is aggregated, so one line of cash stands in for many prescriptions. It arrives net, already reduced by the plan's allowed amounts, by the copays your patients paid at the counter, and by any fees or recoupments the processor took out. And it is disconnected in time from the work, so January fills and February fills can sit inside the same deposit.

Categorize those deposits straight into a Sales account and you overstate revenue every month you also record prescriptions at fill, and you can never answer the question that matters: which claims have not been paid yet. The fix is to route every PBM deposit through accounts receivable.

The three moving parts of one prescription

Every third-party script has three numbers attached to it, and bookkeepers get into trouble by confusing them.

1. The billed amount

This is what you submit, usually your usual and customary price or a contract-driven submitted charge. It is the number your pharmacy system shows as the charge on the claim. It is almost never what you get paid.

2. The allowed amount

This is what the plan says the prescription is worth under your PBM contract: ingredient cost plus a dispensing fee, calculated off MAC, AWP minus a percentage, NADAC, or whatever formula your contract uses. The allowed amount is the total economic value of the fill to you. The difference between billed and allowed is a contractual adjustment.

3. The split between copay and plan payment

The allowed amount is then divided. The patient owes a copay or coinsurance, which you collect at the register on the day of pickup. The plan owes the rest, and that portion is what eventually shows up inside a lump EFT. Same allowed amount, two different sources of cash, arriving at two very different times.

A worked example that balances

Take one prescription. You bill 120 dollars. The plan's allowed amount is 85 dollars. The patient's copay is 10 dollars, paid in cash at the counter. The plan therefore owes 75 dollars, which will arrive later inside a lump remittance. The drug cost you 60 dollars from your wholesaler.

At the fill

Debit Accounts Receivable 120. Credit Prescription Revenue 120. You have recorded the sale on the day you dispensed the drug, which is when you earned it.

Record the contractual adjustment

Debit Contractual Adjustments 35. Credit Accounts Receivable 35. Contractual Adjustments is a contra revenue account that sits directly under Prescription Revenue on the profit and loss, so net revenue on this script reads 85 dollars. Accounts receivable now holds 85 dollars, which is exactly what you expect to collect from all sources.

Collect the copay

Debit Undeposited Funds (or Cash) 10. Credit Accounts Receivable 10. The receivable drops to 75 dollars, which is the plan's share and nothing else.

The PBM EFT arrives

Debit Cash 75. Credit Accounts Receivable 75. The receivable on this script is now zero. Check the math: 35 dollars of adjustment plus 10 dollars of copay plus 75 dollars of plan payment equals the 120 dollars you originally debited to AR. Nothing is left hanging.

The cost side

Debit Cost of Goods Sold 60. Credit Drug Inventory 60. Net revenue of 85 dollars against 60 dollars of drug cost leaves 25 dollars of gross profit on the script, before the dispensing labor, the vial, the label, and the rent. That 25 dollars is the number your P&L should show you, and it is invisible if you post the deposit as income.

Nobody journals one script at a time. In practice you post a daily or weekly summary journal entry straight out of the pharmacy management system: total billed to AR, total contractual adjustments, total copays collected, split by payment type. The mechanics are identical to the way a clinic books charges and allowances, which we walk through in the guide to bookkeeping for medical practices in QuickBooks.

DIR fees and price concessions after the 2024 rule change

This is the part that changed, and a lot of pharmacy bookkeeping advice on the internet is still written for the old world. In the Contract Year 2024 Medicare Advantage and Part D final rule, issued in April 2022, CMS required Part D sponsors to reflect all pharmacy price concessions in the negotiated price at the point of sale, applying to claims from January 1, 2024 forward. In plain English: on the Part D side, the concession is now baked into a lower reimbursement at the moment of the fill instead of being clawed back months later as a retroactive DIR debit against your bank account.

The bookkeeping consequence is straightforward. Your reimbursement per Part D script is lower up front, so the receivable you record at fill should reflect the actual expected payment rather than an optimistic number you will later have to reverse. The old routine of holding a DIR accrual and watching for surprise debits two quarters after the fill largely goes away for Part D, and the contractual adjustment at fill gets correspondingly bigger. Cash flow is smoother, but the margin was always this thin; you just used to find out later.

Do not read that as the end of all pharmacy fees. Part D sponsors are still permitted to report pharmacy incentive payments, meaning positive amounts paid to you after the point of sale, as post point of sale DIR. Commercial plans and some Medicaid managed care contracts can carry their own fees, effective rate reconciliations, network fees, and true-ups that hit the account after the fact. Audit recoupments and chargebacks still happen on every line of business. When one of those debits lands, it is a reduction of revenue (or an operating expense, depending on how your CPA prefers to present it), not a cost of goods, because no additional drug left the shelf. Pick one treatment, write it down, and stay consistent so year over year comparisons mean something.

Reconciling the remittance to the deposit

Your pharmacy system (PioneerRx, QS/1, Liberty, Rx30, or whatever you run) holds the claim detail. The bank statement holds the cash. Reconciliation is the act of tying the two together, and it is where most independents lose money quietly.

The workflow: pull the remittance advice for the payment cycle, total the paid amount, and match that total to the deposit on the bank statement. If they agree, apply the payment across the open claims in AR. If they do not agree, the difference is telling you something, usually a fee, a reversal, an audit recoupment, or a denied claim. Post that difference to the adjustment or recoupment account, never to a plug in Sales.

Claims that were never paid stay in AR, and that aging report is the whole point of doing it this way. A denied claim you can still fix has real cash sitting in it, and if PBM deposits go straight to income you never see the denial at all.

Getting the bank side into QuickBooks accurately matters here, because you are matching against those deposits. If your bank feed is unreliable or you are catching up on months of statements, converting the PDFs is faster than hand keying. Our PDF to QBO converter turns statement PDFs into a Web Connect file, and if you are cleaning up a full year at once, the bulk statement conversion workflow handles the whole stack in one pass. There is a full walkthrough on converting pharmacy bank statements for QuickBooks if you want the step by step.

Drug inventory and the wholesaler ACH

Drugs bought from your primary wholesaler (McKesson, Cardinal Health, Cencora) are inventory, not an expense at purchase. Debit Drug Inventory, credit Accounts Payable when the invoice posts. The cost only becomes an expense when the drug is dispensed, at which point it moves to cost of goods sold, as in the 60 dollar entry above.

The complication is that a single ACH draft from the wholesaler often covers many invoices across a statement period. Categorizing that draft as one lump purchase misstates both inventory and payables. It should be applied against the specific bills it pays, which is why larger pharmacies automate the accounts payable side of those wholesaler invoices so the ACH draft matches a defined set of bills instead of an unexplained balance.

Perpetual inventory drifts. Partial fills, returns to stock, damaged product, expired stock pulled for return, and outright shrink all pull the book number away from what is on the shelf. A periodic physical count, at minimum annually and more often on high dollar categories, trues it up. The adjustment goes to cost of goods sold or to a separate inventory shrink account so you can see how big it is.

The front end and sales tax

Front end and OTC sales work like any other retail store. The customer pays at the register, revenue is recognized on the spot, and there is no receivable to track. Keep front end sales in a separate income account from prescription revenue, because the margins are different and blending them hides which half of the store earns money.

Sales tax is the trap. In most states, prescription drugs dispensed under a prescription are exempt from sales tax, while OTC merchandise, candy, greeting cards, and durable goods generally are not. Some states tax certain OTC items differently, some exempt OTC drugs when a prescription is written for them, and the rules move. Check your own state's guidance or ask your CPA rather than assuming; your point of sale system should be configured to flag taxable and exempt items correctly, and the sales tax liability it computes is what belongs in QuickBooks.

Common mistakes

Posting the PBM EFT to income. The most common error and the most expensive one. It double counts revenue if you also record fills, and it destroys your ability to see unpaid claims.

Calling the contractual adjustment bad debt. Bad debt is money a patient owed you and did not pay. A contractual adjustment is money the plan was never going to pay under a contract you signed. Different accounts, different tax and analysis consequences.

Treating unpaid copays as contractual adjustments. An uncollected copay is a patient receivable. If you eventually give up on it, that is bad debt, and it belongs in its own account so you can see how much you are losing at the counter.

Expensing wholesaler purchases at the invoice date. That turns your gross margin into noise, because the buy and the sale land in different months. Inventory first, COGS at dispense.

Letting AR age forever. If nothing ever clears out of accounts receivable, either you are not applying the remittances or you are sitting on denials nobody worked. Both are fixable, and both cost real money.

Using the wrong 1099 threshold. If you pay a relief pharmacist, a delivery driver, or a cleaner as an independent contractor, the reporting threshold for Form 1099-NEC is 2,000 dollars for payments made on or after January 1, 2026. Track contractor payments in QuickBooks so January does not turn into an archaeology project.

Frequently asked questions

Are DIR fees still charged in 2026?

Retroactive pharmacy DIR clawbacks on Medicare Part D were effectively ended for claims from January 1, 2024, because CMS now requires sponsors to build all pharmacy price concessions into the negotiated price at the point of sale. Fees did not vanish; they moved into a lower reimbursement at fill. Commercial plans, some Medicaid managed care contracts, and audit recoupments can still produce post-fill debits.

Should PBM deposits be recorded as income in QuickBooks?

No. If you already recorded revenue and a receivable when the prescription was dispensed, the PBM deposit is a payment against accounts receivable. Recording it as income counts the same sale twice. The only situation where a PBM deposit is income is a cash basis setup where no revenue was recorded at fill, and that setup gives you no visibility into unpaid claims.

What account do contractual adjustments go in?

Create a contra revenue account, commonly called Contractual Adjustments, and place it directly beneath Prescription Revenue on the profit and loss so gross billed charges, adjustments, and net revenue all appear in sequence. It is not an expense and it is not bad debt. Your P&L should let you read both what you billed and what you actually earned.

How do I match a lump PBM deposit to individual claims?

Use the remittance advice from the PBM or the payment reconciliation report in your pharmacy system. Total the paid claims on the remittance and compare that total to the deposit on the bank statement. Apply the payment across the open receivables, then post any difference to your adjustment or recoupment account. Unpaid claims stay in AR for follow up.

Is prescription revenue subject to sales tax?

In most states, prescription drugs dispensed under a valid prescription are exempt from sales tax, while front end and OTC merchandise generally is not. The exact treatment of OTC drugs, medical devices, and durable equipment varies by state and does change. Check your state's department of revenue guidance or ask your CPA rather than relying on a general rule.

Do I need to track drug inventory perpetually in QuickBooks?

Most independents keep the perpetual detail in the pharmacy system and carry a single summary inventory balance in QuickBooks, adjusted from physical counts and periodic COGS entries. Trying to mirror every NDC in QuickBooks is more work than it is worth. What matters is that purchases hit inventory, dispensed drugs hit COGS, and counts true the balance up.

Ready to get the cash side clean? Convert your bank and credit card PDFs into a QuickBooks-ready file with our pharmacy bank statement converter, then follow the steps for importing a bank statement into QuickBooks Online and start matching those PBM deposits to the claims behind them.