Pharmacy Stats & How They Work?
Step-by-step guide to understanding and using Pharmacy Stats for performance reporting in SiCompounding
Overview
Pharmacy Stats provide a high-level, real-time view of overall pharmacy performance. This reporting area is designed to answer critical operational and business questions at any point during the day, such as:
- How many new patients have been served?
- How many SiPrescribe orders are coming in?
- How many new prescriptions were received?
- How do sterile compounds vs. dispenses compare?
- What are total dispenses?
- What does shipping activity look like?
Results can be filtered by State, Context, and Date Range, allowing you to tailor the data to exactly what you need to review.
Accessing Pharmacy Stats
- Click the FileMaker Pro icon to open the application.
- When FileMaker opens, locate the large menu bar on the left side of the window.
- Click SiCompounding (near the top of the menu).
- In the next window, click Pharmacy from the icons across the middle of the screen to open the Dashboard.
- From the Dashboard, click Reports.
The Reports window opens, providing access to:
- Pharmacy Stats (selected by default)
- On-Demand Reports
- Click the Stats button to begin reviewing Pharmacy Stats.
Configuring Pharmacy Stats Filters
From SiCompounding Settings, the Pharmacy Stats section allows you to configure how results are calculated and displayed.
Select Period
- Use the Select Period dropdown to choose a predefined date range (for example, Last Quarter or Last 30 Days).
- To define a custom range, enter a From Date and To Date using the calendar icons.
State Filter
- Select a State from the dropdown to limit results to a specific state.
Context Filter
- Select a Context (for example, Pharmacy) to further refine the reported data.
Example:
- Select Period: Last 30 Days
- State: Florida
- Context: Pharmacy
The stats displayed below will reflect only data that matches these criteria.
Understanding the Pharmacy Stats Data
The reporting layout is designed to be intuitive and self-explanatory. Each stat represents a calculated metric based on the selected filters.
For example:
- The top row displays the number of New Patients served.
- Prescription activity shows Total Rx Dispenses and New SiPrescribe Rx counts.
- Sales sections compare Sterile versus Non-Sterile performance.
This area offers significant flexibility and insight into pharmacy operations.
Available Pharmacy Stats
Based on the selected period, the following statistics are available:
Patient, Provider, and Prescription Metrics
-
New Patients
-
New Physicians
-
New e-Rx
-
New SiPrescribe
-
New Institution
-
New Prescriptions
-
Not Filled
-
On Hold
-
New Rx Fill Rate
-
AVG Rx Return
Orders and Revenue
- Total Orders
- $Total Revenue
- $AVG Order
- AVG Order Return
Payment Sources
- Paid by Patients %
- Paid by Providers %
- Paid by Institutions %
Dispensing and Drug Sales
- Total Dispenses
- $Drug Sales
- $AVG Dispense
- AVG Return After Pay
Sterile Compounding
- Sterile Dispenses
- $Total Sterile
- $AVG Sterile
- Sterile Compounded
Non-Sterile Compounding
- Non Sterile Dispenses
- $Total Non Sterile
- $AVG Non Sterile
- Non Sterile Compounded
Shipping, Supplies, and Adjustments
-
Freight
-
$Supplies Sales
-
$State Surcharges
-
$Total Discounts
-
$Shipping Discount
-
Total Replacements
-
$Replacements Value
Controlled Substances and Claims
-
Total Dispenses CS
-
% Dispenses CS
-
Total Pickups
-
Pickup %
-
Total Claim Fee
-
Total Card Finder
-
Total Medicare D
Drilling Into a Stat
Each statistic is interactive.
- Click on any Stat to view the underlying records.
Example:
- Click New e‑Rx.
- The Prescriptions window opens in List View, displaying all new prescriptions within the selected date range.
Printing and Exporting Stat Details
When viewing a drilled-down list:
- Look to the far right of the menu bar, next to the Search field.
- Three clickable Report / Print icons are available for output options.
These allow you to print or export the detailed records associated with the selected stat.
Summary
Pharmacy Stats offer a powerful, flexible way to monitor pharmacy performance in real time. By combining date ranges, state filters, and contextual views, users can quickly answer operational, financial, and clinical performance questions.
This completes the step-by-step guide for Pharmacy Stats & How They Work.
Why Create a Communications Note?
Learn how Communications Notes centralize pharmacy interactions and provide traceable documentation across patients, providers, prescriptions, and orders.
On Demand Reports & How They Work?
Learn how to search, run, filter, and export On Demand Reports within SiCompounding for detailed operational and compliance reporting.