Bookkeeping for an Independent Pharmacy in Texas (Inventory, DIR Fees, PBM Reconciliation, and Monthly Close)

Disclaimer: The information on this website (including all examples, explanations, and content) is for general informational purposes only and should not be considered tax, legal, or financial advice. Always consult with a qualified professional about your specific situation.

Pharmacy Bookkeeping Is Mostly About Inventory and PBM Reconciliation

Independent pharmacy bookkeeping has two specific problems that most other small businesses do not have at the same time: very large drug inventory that has to be tracked through cost of goods sold, and PBM reimbursement that includes DIR fees and clawbacks that arrive long after the original adjudication.

A pharmacy with a generic small business chart of accounts and no inventory method is not really doing bookkeeping. It is keeping receipts. This post walks through the practical bookkeeping setup for a Texas independent pharmacy.

The related operational topics live in our payroll for independent pharmacies in Texas, tax deductions for independent pharmacies, and profit but no cash in an independent pharmacy posts. For the small business bookkeeping foundations this post builds on (cash vs accrual, chart of accounts basics, monthly close discipline), see our small business bookkeeping 101 guide and top 5 bookkeeping mistakes that wreck your tax return.

Chart of Accounts for an Independent Pharmacy

Revenue Accounts

  • Prescription Revenue (or split by brand vs generic, or by payor type)
  • Cash Pay Prescription Revenue
  • OTC and Front End Retail Revenue
  • Compounding Revenue (if applicable)
  • Immunization Revenue (if applicable)
  • MTM (Medication Therapy Management) Revenue (if applicable)
  • Delivery and Other Service Revenue

Cost of Goods Sold

  • Prescription Drug COGS (drug inventory expensed as dispensed)
  • OTC and Front End COGS
  • Compounding Supplies COGS (if applicable)

The prescription drug COGS is typically the largest single expense in the pharmacy P&L (often 65 to 80% of prescription revenue, varies significantly by payor mix and drug mix).

Operating Expense Accounts

  • Wages and Payroll Taxes
  • Employee Benefits
  • Rent or Mortgage Interest
  • Utilities
  • Phone and Internet
  • Pharmacy Management Software (PioneerRx, Liberty, Computer-Rx, Rx30, BestRx, QS/1, PrimeRx)
  • E-Prescribing and Adjudication Fees
  • Marketing and Advertising
  • Continuing Education
  • Professional Memberships (TPA, NCPA, APhA)
  • Pharmacist Liability Insurance
  • General Liability Insurance
  • Cyber Liability Insurance
  • Office Supplies
  • Repairs and Maintenance
  • Depreciation Expense
  • TSBP License Fees
  • DEA Registration Fees
  • DIR Fees (often a separate line for visibility)

Balance Sheet Accounts

  • Operating Cash Account
  • Reserve / Savings Account
  • Accounts Receivable (typically primarily PBM and third party payor receivables)
  • Patient Receivable (typically small for pharmacies; most patient portion is collected at the time of dispensing)
  • Prescription Drug Inventory
  • OTC and Front End Inventory
  • Fixed Assets (Robotics, Refrigeration, Compounding Equipment, Build Out, Vehicle if applicable)
  • Accumulated Depreciation
  • Accounts Payable (wholesaler invoices)
  • Credit Cards Payable
  • Loans Payable
  • Owner Equity

Adjustments and Write Offs

  • Inventory Loss (expiration, refrigeration failure, breakage)
  • Bad Debt Expense (uncollected patient copays for accrual basis pharmacies)

Drug Inventory: The Biggest Bookkeeping Topic

Most independent pharmacies carry $200,000 to $500,000+ of inventory at any time. Getting the inventory accounting wrong is the single most damaging bookkeeping mistake in pharmacy.

How It Should Work

When you receive a wholesaler shipment:

  • Inventory increases (balance sheet) by the cost
  • Accounts payable increases by the cost
  • When the wholesaler invoice is paid, A/P decreases and cash decreases

When prescriptions are dispensed:

  • Prescription Drug COGS increases (P&L expense) by the dispensed cost
  • Inventory decreases by the same amount
  • Revenue posts when adjudicated (accrual) or when remitted (cash)

The pharmacy management software tracks dispensings at the SKU level. The books need to reflect the total inventory balance and total COGS for the month, reconciled to physical inventory counts.

Inventory Method

The IRS allows several inventory methods (FIFO, weighted average, retail method). Pharmacies typically use one of these consistently year over year. The choice affects the ending inventory value and therefore the COGS for the year. Changing methods requires Form 3115 filing.

Talk to your tax advisor about which method makes sense for your pharmacy given drug pricing trends and turnover characteristics.

Inventory Counts

Physical inventory counts should happen at least annually for tax purposes and ideally more often for management purposes (quarterly or even monthly for high value items). The variance between the inventory the pharmacy management software says exists and the inventory that is actually on the shelves is itself a useful management number.

Expired and Lost Inventory

Expired drugs, refrigeration failures, theft, and breakage are real losses. The accounting:

  • Inventory decreases (balance sheet) by the cost of the lost product
  • Inventory Loss expense increases (P&L)

For controlled substances, the disposal documentation (DEA Form 41 through a reverse distributor) supports the write off. Pharmacies that do not write off losses carry inflated inventory balances.

PBM Remittance Reconciliation

PBM remittances are the cash receipts from prescription dispensings. The reconciliation flow:

  1. Prescription adjudicated and revenue accrued
  2. PBM remits payment (typically 14 to 30 days later)
  3. Remittance reconciled to the original adjudications
  4. DIR fee clawbacks recorded when assessed

What Should Reconcile

The total adjudicated charges for a month should reconcile to:

  • The cash remittances received
  • Plus the remaining receivable at month end
  • Plus any DIR fee clawbacks
  • Plus any denied claim write offs

Pharmacies that do not reconcile PBM remittances against adjudications lose money. Missed remittances, miscalculated PBM payments, and unposted denials accumulate over time and are difficult to recover after several months.

DIR Fees

DIR fees clawed back by PBMs after the original adjudication are tracked as either a separate expense line on the P&L or as a reduction of prescription revenue. Either treatment is acceptable, but consistency matters.

Tracking DIR fees as a separate line (DIR Fees on the P&L) provides visibility into how much PBM clawback is affecting net revenue. This is one of the most important management numbers in independent pharmacy.

Equipment Depreciation

Robotic dispensing, refrigeration, controlled substance security, compounding equipment, and pharmacy build out are tracked as fixed assets and depreciated. Section 179 and bonus depreciation can accelerate the tax deduction. Our Section 179 vs bonus depreciation post covers the tax side.

The Monthly Close

A good monthly close for an independent pharmacy produces:

  • Reconciled bank and credit card statements
  • Drug inventory adjusted to physical count and dispensing records
  • OTC and front end inventory adjusted to count
  • PBM receivable reconciled to remittance records
  • DIR fees reconciled and recorded
  • Inventory losses (expiration, refrigeration, theft) recorded as expense
  • Owner compensation recorded correctly
  • Loan principal and interest split correctly
  • Depreciation entries
  • Reviewed P&L and balance sheet

Common Pharmacy Bookkeeping Mistakes

Expensing Wholesaler Invoices at Receipt

The biggest single mistake. Wholesaler invoices are inventory, not expense. Expense the inventory as dispensed through COGS.

Not Reconciling PBM Remittances

Missed and miscalculated remittances accumulate over time. Monthly reconciliation catches them early.

Not Tracking DIR Fees Separately

Mixing DIR fees with general operating expense hides their impact on net revenue.

Not Counting Inventory

Without physical counts, the inventory balance is theoretical. Variance between theoretical and actual is itself information.

Recording Equipment as Expense

Equipment is a fixed asset. Depreciation is the expense.

Mixing Personal and Pharmacy Expenses

Skipping the Monthly Close

Frequently Asked Questions

Cash basis or accrual basis?

The IRS generally requires accrual basis for businesses with meaningful inventory. Independent pharmacies almost always use accrual basis as a result.

How often should I count inventory?

At least annually for tax purposes. Quarterly or monthly is better for management purposes. High value items (controlled substances, refrigerated biologics, specialty drugs) deserve more frequent counts.

Should I track DIR fees by PBM?

Yes. Different PBMs have different DIR structures. Tracking by PBM lets the pharmacy see which contracts are most damaging and weigh whether to maintain or drop specific contracts.

Should I outsource bookkeeping?

Most independent pharmacies benefit from outsourcing to someone familiar with pharmacy bookkeeping specifically. The inventory accounting, PBM reconciliation, and DIR fee handling are easier with someone who knows the patterns.

How do I integrate pharmacy management software with QuickBooks?

Most pharmacies import a monthly summary from the pharmacy management system rather than syncing transaction by transaction. The pharmacy management software remains the source of truth for SKU level detail.

What about controlled substance inventory?

DEA tracking requirements apply to controlled substances regardless of the books. The accounting for controlled substance inventory follows the same rules as other drug inventory, with disposal documented on DEA Form 41 through a reverse distributor.

Getting Pharmacy Bookkeeping Right

Independent pharmacy bookkeeping is mostly about inventory and PBM reconciliation, with DIR fee tracking as a critical visibility item. Pharmacies that handle these correctly know their margins, can spot PBM contract problems, and can make decisions about which third party payors are worth keeping.

If you also want the related operational topics, our payroll for independent pharmacies in Texas guide covers the staff side, our tax deductions for independent pharmacies post covers deductions, and our profit but no cash in an independent pharmacy post covers cash flow.

We work with independent pharmacy owners across Quinlan, Hunt County, Rockwall, Kaufman, and the greater Dallas area on bookkeeping, payroll, tax preparation, and broader tax planning.

Want pharmacy bookkeeping that actually tells you what is going on? Contact us here to talk about getting your books, inventory tracking, and PBM reconciliation set up.