Why compounding pharmacies require financial segmentation, not only clinical segmentation
From a financial-reporting standpoint, a compounding pharmacy that has both a 503A patient-specific business line and a 503B outsourcing facility business line is conducting two separate businesses “under one roof.” It’s different regulations, it’s different ways of making money, it’s different ways of relating to customers, it’s different margin profiles.
Companies that do not segment ERP reporting in this way end up with one blended margin figure that obscures which side of the business is doing well. Segmentation should be done at the chart of accounts, class, or department level, not as a report constructed after the fact in a spreadsheet.
Beyond-use dating as an inventory setting problem
The compounding pharmacy equivalent of an expiration date is a beyond-use date that varies based on the formulation, storage conditions and applicable USP chapter and is often shorter and more variable than a standard manufactured drug’s shelf life. Generic expiration date fields in the ERP are therefore not sufficient.
The item master and lot configuration must be capable of supporting calculation logic for beyond-use dates specific to compounded preparations, not a single fixed shelf life per item. This is a tricky balance to strike, with the risk of two extremes: either dispensing product after its true beyond-use date, or throwing away usable product because the system used a too-conservative default.
Tracking waste of controlled substances and hazardous chemicals
Waste documentation requirements for compounding operations involving controlled substances or hazardous drugs go beyond standard inventory shrinkage tracking. Any quantity discarded from a failed compound, an expired preparation, or routine waste from the compounding process itself should be logged, including the reason, quantity, witness where required, and disposition.
This can be done in NetSuite by having a documented waste transaction type associated with the relevant item and lot, but it needs to be intentionally set up. Organizations that track waste informally, using paper logs that are not tied to the ERP, create a reconciliation gap between what the system says was consumed and what was actually used in finished preparations.
SEGMENTATION OF BUSINESS REVENUE 503A VS 503B
503A patient-specific compounding is generally billed on a per-prescription basis, generally to a specific patient or their insurance, with revenue recognized when the drug is dispensed. Compounding for 503B office-use is usually billed to health care facilities or providers under supply agreements with revenue recognized upon delivery and acceptance, and often with completely different pricing and volume dynamics.
By setting up the chart of accounts, customer master data, and item categories separately for each revenue stream, the organization can see the true profitability by business line and support the very different demand forecasting and staffing models that each side of the business requires.
Batch costings for compounded preparations
Specifically, batch costing is configured appropriately to benefit 503B batch compounding. Ingredient cost, compounding labor, testing and release cost, and packaging are allocated across the units produced from a batch. Without this, office-use product pricing decisions are made with incomplete cost information, and margin erosion on specific formulations is not detected until it shows up as a decline in aggregate profitability.
The batch costing structure must be inextricably linked to the lot and quality release workflow. Cost, compliance documentation and inventory movement should all be associated with the same batch record, not tracked in parallel systems.
Consolidating into a single reporting structure
The compounding pharmacies that get the most out of NetSuite treat beyond-use dating, waste documentation, and revenue segmentation as parts of a single design, not three separate problems. A well-configured item master translates to correct beyond-use dates. Well configured waste transaction type creates defensible compliance documentation. A properly segmented chart of accounts will generate a P&L by business line that is reflective of economic reality.
Organizations who address these issues one-by-one, after the fact, end up spending way more to fill the gaps than they would have spent building the structure properly during implementation.