28/11/2025
Earlier this year, we began working with a mid-sized pharmacy located in the United States—one that had been steadily growing but struggling to keep its financial records in order. The owners approached us with a simple concern: “Our sales are increasing, but our numbers don’t make sense anymore.”
Like many pharmacies, they relied on multiple systems—POS software, insurance reimbursement platforms, vendor portals, and QuickBooks. Over time, the data stopped aligning, and the financial statements drifted away from reality.
Understanding the Problem
During our initial review, several issues became clear:
1) Inventory purchases were being expensed directly instead of being recorded as stock.
2) POS and QuickBooks syncs were creating duplicate sales.
3) Insurance reimbursements from Medicare, Medicaid, and private insurers weren’t being matched correctly.
4) Vendor credits were applied incorrectly, leaving negative vendor balances.
5) COGS was inflated, causing the pharmacy’s profits to appear much smaller than they actually were.
The owners were relying on these inaccurate reports for pricing decisions, loan applications, and tax filings—so fixing the books wasn’t just an accounting exercise; it was critical for the business.
Our Cleanup Process
We approached the cleanup in a phased, methodical way so the pharmacy could continue its daily operations without disruption.
1. Reviewing the System Setup
We started by understanding how their POS, vendor portals, and insurance systems were pushing data into QuickBooks. This helped us identify the sources of duplication and misclassification.
2. Cleaning the Historical Data
This was the most time-consuming part, but also the most impactful.
a) Duplicate income entries were removed.
b) Inventory purchases were reclassified and properly adjusted.
c) Vendor balances were corrected by matching credits and invoices accurately.
d) Old unreconciled transactions—some dating back almost a year were analyzed and settled.
3. Reconciliation
We reconciled all bank accounts, card accounts, and insurance deposits month by month to ensure every transaction had a place and a purpose.
4. Fixing Reporting & COGS
Once the data was clean, we implemented an inventory and COGS system that aligned with how a pharmacy actually operates—accounting for expired stock, returns, discounts, and supplier schemes.
The Final Outcome
By the time we completed the cleanup, the owners were finally seeing numbers that matched the reality of their business. Some key improvements:
Overstated inventory expenses worth $58,000 were corrected.
Gross margin accuracy improved significantly.
The monthly closing process, which used to take weeks, was reduced to just a few days.
Insurance reimbursements were mapped properly, eliminating confusion about underpayments and timing differences.
They were able to approach lenders with clean, audit-ready financial statements and secured working capital smoothly.
The owners told us it felt like they were “getting their business back.” For the first time in a long time, they could see exactly which products were profitable, which insurance plans were paying slow, and which vendors were affecting their margins.
Why This Cleanup Matters
A pharmacy doesn’t operate like a normal retail store. Medicines have expiry dates, pricing regulations, controlled substance requirements, and complex insurance reimbursements. When the books aren’t maintained correctly, even small errors compound into major distortions.
By bringing structure, clarity, and accuracy back into their accounting system, we helped the pharmacy regain control of their operations and plan confidently for growth.
