See every pack, from import to the pharmacy shelf
PharmaIQ follows every pack from import to sell-in to sell-out, reconciles it against your targets, and shows where stock and share are moving. Built from the data you already have.
Any layout
No templates. Files are read as they arrive, even when the layout changed since last month.
Reconciled
Every load is checked against the file it came from. If the totals don't match, it doesn't load.
Traceable
Every number on every screen leads back to a source file and row.
Isolated
Each customer's data is separated by the database itself.
Follow every pack from import to pharmacy
Three flows, one product list, one set of territories. See where stock is building up and where it is running out, at every step of the chain.
Import
What was brought into the country, by SKU and month.
Sell-in
What was sold to each distributor, by partner and month.
Sell-out
What each distributor sold on, by territory, product and month.
Months of cover at every step, and an alert when a distributor is being loaded faster than it sells.
Every number against its target
Load your targets once, by product, territory and month. See actual against target and against last year, in units and value.
- Month, quarter, half and full year
- By product, brand, territory and partner
- A nightly check flags the gaps before the monthly meeting does
Sell-out value, this year
Thousands, by month
| Month | Actual | Target | Last year |
|---|
One platform, four layers
Data hub
Excel, legacy .xls, binary .xlsb and panel exports, read as they are. A file that looks wrong is flagged, not loaded quietly.
Master data
One product list, one set of territories, one list of partners. Every spelling a source invents is matched once, confirmed by a person, and remembered.
Analytics
Sell-out, market share, geography, channel stock, expiry exposure and trade marketing, all reading the same reconciled numbers.
AI analyst
Ask in plain language. Every figure in the answer traces to a query you can open. If it can't trace a number, it says so.
Built for every commercial seat
For manufacturers and their country offices, and for distributors.
Where are we growing, where are we losing share, and is it us or the market?
Which SKUs carry the brand, which pack sizes are fading, and did the campaign move anything?
My territory against plan, against last year, against the territory next door.
How much stock sits in the channel, how long it covers, and what expires before it sells.
Works with what you already have
No template to fill in. No change to how your partners report.
An analyst that shows its work
Most AI tools will give you a confident number. PharmaIQ gives you the number and the query behind it. It works only through the platform's own measures and declines when the data isn't loaded, rather than guessing.
| Product A · 500 mg × 20 | −18% | |
| Product B · 10 mg × 30 | −12% | |
| Product C · syrup 100 ml | −9% |
Show the query
query_sales(measure: [actual, target], period: Q3, group_by: sku, order:
gap, limit: 3)
Compared with what you use today
| Spreadsheets | Generic BI tool | Syndicated panel data | PharmaIQ | |
|---|---|---|---|---|
| Import, sell-in and sell-out in one chain | Separate files | If you build it | No | Yes |
| Actual vs target at every level | Manual | If you build it | No | Yes |
| Your own sell-out, by partner | Manual | If you build it | No | Yes |
| Handles files that change every month | By hand | Breaks | n/a | Yes |
| Product names matched across sources | By hand | No | Their codes only | Yes, with review |
| Totals reconciled against the source | Rarely | No | n/a | Every load |
| Market share labelled by method | No | No | Yes | Yes |
| Time to first dashboard | Days, every month | Months | Subscription | Weeks |
Panel data tells you about the market. PharmaIQ tells you about your business, and puts panel data next to it.
From your files to your dashboards
Send sample files
Last month's reports from each source, as they are.
We map them
Products, territories and partners, reviewed with your team.
Load your history
Every file checked against its own totals.
Go live
Your team signs in. New files load the day they arrive.
Your data stays yours
Isolation in the database
Customers are separated by the database itself, not by application code.
Hosted where you need it
A dedicated server in the region you choose.
Roles and an audit trail
No self-signup. Every user is provisioned, every admin change is logged.
Your own domain
Your team signs in at an address on your domain.
Priced by scope, not by seat
Every plan includes unlimited users and onboarding.
Essentials
Your sell-out, reconciled
- Sell-out by partner and territory
- Actual vs target
- Geography
- Products, territories and data review
Professional Most complete
The whole chain, with AI
- Everything in Essentials
- Full import → sell-in → sell-out chain
- Market share, channel stock and expiry
- Trade marketing
- AI analyst
Enterprise
For groups and multi-country teams
- Everything in Professional
- ERP exports
- Your own domain
- Dedicated hosting
- Multiple countries
See your own numbers in PharmaIQ
Send us last month's files. We'll show you what they look like reconciled.