Skip to main content Skip to footer

ISP report information

This information will help you to put the data included within reports/charts into context.

You can find out what’s included in each report category and any notes about how the data has been produced, for example, what is and what is not included in the data.

Common information reports

These reports are freely available to the general public.

Prescribing data

Dispensing data

Organisation data

Data download

Data Download enables you to further manipulate data using a programme of your choice. You can access Data Download on the Information Services Portal.

Our user guide (Word: 414KB) gives details on how to use the Data Download facility. There is also data specification information (Word: 327 KB) available.

When downloading information, standard spreadsheet applications may not be able to handle the volumes of data contained in the monthly data sets. 

 File type

 Approx. download size (zip)

 Approx. uncompressed .csv

  National

 450 MB

 3.5 GB

 Regional Office

 125 MB

 1 GB

 Area Team

 20 MB

 150 MB

 PCO

 3.5 MB

 25 MB

 Practice

 100 KB 

 900 KB

If you're downloading large volumes of data, for example, National, Regional Office and some Area Teams, you may need to use a bespoke IT solution or an add-on able to handle larger data sets, for example the Microsoft PowerPivot add-on for Excel.              

Using Microsoft PowerPivot

The PowerPivot add-on is available from Microsoft.

Once PowerPivot has been installed, to load large files, follow these instructions:

1. Start Excel as normal
2. Click on the PowerPivot tab  
3. Click on the PowerPivot window icon (top left)
4. In the PowerPivot window, click on the 'from other sources' icon
5. In the table import wizard, for example, scroll to the bottom and select 'text file'
6. Browse to the file you want to open and choose the file extension you require, for example '.csv'

Once the data has been imported, you can view it as a table or view and manipulate it as a graph.

Other add-ons are available and you should use whichever add-on or bespoke solution best meets your needs. 

Notes

Detailed prescribing information is updated on a monthly basis providing information on a practice’s / cost centre prescribing habits and costs.

The extract includes prescribing data attached to a commissioner / provider and includes unidentified prescribers where we have been able to identify a commissioner / provider.

The data is based on items prescribed on NHS prescriptions that were dispensed in the community, this includes items prescribed in England.

The data does not include:

  • items where a prescription was issued, but not presented for dispensing or not submitted to NHS Prescription Services by the dispenser
  • items prescribed in Wales, Scotland or Northern Ireland but dispensed in England
  • items prescribed in England, but dispensed in Wales, Scotland and Isle of Man
  • items prescribed by dentists
  • items prescribed on FP10HP forms by hospitals which are not attributed to a practice / cost centre on our database

                                                                       
Items - shows the number of times a product appears on a prescription form, for each unique quantity prescribed.

Quantity - shows the quantity for each of these prescribed items.

For example, in the data below, Amlodipine 10mg tablets have been prescribed once with a quantity of 28 and 4 times with a quantity of 7. In this case the total number of items is 5, and the total quantity prescribed (quantity * items) is 56.

 BNF Description

 Items

 Quantity

  Amlodipine_Tab 10mg

 1

 28

 Amlodipine_Tab 10mg

 4

 7

Net Ingredient cost (NIC) - is the basic price of a drug as stated in Part II, Clause 8 of the Drug Tariff.

Actual Cost - is the basic price of the drug, less the national average discount percentage (NADP), plus Payment for Consumables (previously known container allowance), Out of Pocket Expenses and Payment for Containers (10p for splitting packs). The calculation for the discount amount is the basic price multiplied by the NADP. Actual Cost only relates to England.

ADQ (Average Daily Quantity) - is a measure of prescribing volume based on prescribing behaviour in England. It represents the assumed average maintenance dose per day for a drug used for its main indication in adults. The ADQ is not a recommended dose but an analytical unit to compare prescribing activity. ADQs are reviewed on a regular basis, to reflect any changes in drug use and to include new drugs.

Patient list size data - is updated when a new month’s data is uploaded. The data does not include temporary resident band.

BNF code information - is updated on an annual basis.

The BNF Code is a 15 digit code in which the first 7 digits are allocated according to the categories in the BNF and the last 8 digits represent the medicinal product, form, strength and the link to the generic equivalent product. NHS Prescription Services has created pseudo BNF chapters, which are not published, for items not included in BNF chapters 1 to 15. The majority of such items are dressings and appliances which NHS Prescription Services has classified into the four pseudo BNF chapters 20 - 23.

NB - If a product is a generic product produced by a specific manufacturer, this item is not allocated a BNF code but is assigned a seven digit 'PPA code'. This is an internal code used to link this product back to the BNF code of the generic product.

Information included in Data Download:

Detailed Prescribing Information - provides information on a practice / cost centre’s prescribing habits and costs. The extract includes data for prescriptions which are directly attached to a commissioner / provider.  

Detailed Prescribing Information download data source has changed and the extract is now taken from our Information Services data warehouse there are some subtle changes to the data.

For further information view our guide to the differences (Word: 248KB).

BNF Code Information - allows a user to select from the latest 3 versions of BNF updates.

Patient List Size Information - provides the details of patient list sizes for all practices at the required organisation level. Patient list information can not be downloaded at National Level. To get a national data set download 5 regions.

Resources

Guide to differences (Word: 248KB)

Information Services Portal user guide

Glossary of terms (Excel: 28KB) Electronic Drug Tariff

BNF classification and pseudo classification used by NHS Prescription Services

If you have any queries you can contact the Information Services team on 0191 203 5050 or email us at nhsbsa.help@nhs.net

Home oxygen therapy - CCG

The Home Oxygen Therapy report is accessed via the Information Services Portal.

These reports are only available to users who have been authorised  to view Home Oxygen Reports by their respective Organisations.

The system holds 24 months of data which is updated on a monthly basis. 

Notes

Home oxygen therapy payments are made the month following supply. 

What is included in the Home Oxygen Therapy Reports

CCG Payment Claim - Allow CCGs/Regions to monitor the payments made to the oxygen suppliers for patients registered in their CCG/region. 

This report is split into three data views

  • CCG Payment Claim Summary
  • CCG Payment Claim - In Area Supply
  • CCG Payment Claim - Out of Area Supply

This report will detail the Claim to CCGs for the oxygen supplied by their home regions as well as any out of area Supply

Resources

Information Services Portal user guides

Glossary of terms (Excel: 28KB) Frequently Asked Questions (Word:439KB)

If you have any queries you can contact the Information Services team on 0191 203 5050 or email us at nhsbsa.help@nhs.net

Home Oxygen Therapy Reports

Home Oxygen Therapy Adjustment Notification Form

This form should only be used to make adjustments to payments claimed by the supplier who has the contract for your CCG area.

The form should clearly state the Supplier Name and Address, the region, CCG name and CCG code. 
Please indicate if the amount is to be PAID to the supplier or DEDUCTED from the supplier. 
All amounts stated should be excluding VAT.

The form should be signed by an authorised signatory. If you are unsure who the signatories for Home Oxygen Therapy Adjustments are for your organisation please contact the Customer Payment Team on 0191 244 6488.

The Home Oxygen Therapy Adjustment Form is available in both PDF and Word format and can be downloaded below:

Adjustment Form (Word: 251KB)

Adjustment Form (PDF: 195KB)

Home Oxygen Therapy Out of Area Adjustment Notification Form

This form should only be used to make adjustments to payments that have been claimed by suppliers for Home Oxygen Therapy supplied to patients when they have been out of the CCG area.

The form should clearly state the

  • Supplier name and address
  • Region
  • CCG name
  • CCG code.

Please indicate if the amount is to be PAID to the supplier or DEDUCTED from the supplier. All amounts stated should be excluding VAT.

The form should be signed by an authorised signatory. If you are unsure who the signatories for Home Oxygen Therapy Adjustments are for your organisation please contact the Customer Payment Team on 0191 244 6488.

Please note that the forms are designed to accommodate up to four adjustments on one notification, please ensure that the values are totalled correctly. Where possible complete each notification in full rather than submit multiple notifications with one value on each, please retain a copy of the authorised notification for your records. The forms are accepted by fax or post, in order to reduce the risk of processing twice there is no requirement to post originals after they have been faxed. NHS Prescription Services processes the payment however, there is no payment monitoring performed by NHS Prescription Services. If you require confirmation that the adjustments have been processed, the CCG can check the reports on the system, where an adjustment is received towards the end of a month, it may not be processed until the following month.

Out of Area Adjustment Form (Word: 251KB)Out of Area Adjustment Form (PDF: 195KB)

Management Information Spreadsheet (MIS) report

Access to this report is restricted to authorised users only.

This report consists of a management information file detailing monthly Community Pharmacy and Appliance Payments by type of payment and contractor account. Payments include all drug costs, fees, patient charges, locally authorised payments, etc. Other details such as the numbers of items dispensed, patients charges collected are also included.

The management information files reflect the contractor's payment and prescription data associated with the Area Team structure at the relevant payment date.

This information is provided to fulfil a number of requirements including:-

  • Pharmacy and appliance contractor payment monitoring 
  • Contract management 
  • Reconciling payments 
  • Audit 
  • Fraud prevention 

NHSBSA has enhanced the support it currently offers to NHS England regional teams to manage the performance of pharmacy contracts by providing enriched information, analysis and insight on contractor payment and prescription data.

A monthly reporting tool has been developed to help NHS England regional teams to identify unusual/inappropriate behaviour, potential fraudulent activity and areas of interest. Insight will be delivered for four metrics defined by NHS England as key areas of interest:

  • MUR 
  • NMS 
  • Out of Pocket Expenses 
  • Staff Hours (unavailable from December 2016)

A cumulative reporting tool has been developed to allow users to look at the data over a specific financial year. A dashboard has been created in the tool which accumulates the monthly data and produces year-to-date information on the three payment metrics, providing an overall picture of a pharmacy contractor’s activity over a financial year in these areas.

Webinar Sessions

Webinar sessions are available upon request to give an overview of the toolkit.

Request a webinar session

Access to the monthly toolkit template (Excel: 1.04MB)

Access to the cumulative toolkit template (Excel: 6.64MB)

User Guides - Useful information to help you:

Get started using the toolkit (Word: 4.77MB) How to sort the data in the pharmacy MIS toolkit (Word: 214KB) How to add a freeze frame to the pharmacy MIS toolkit (Word: 312KB) Cumulative Dashboard User Guide (Word: 1.09MB)

Cumulative MIS Toolbox Categorisation Explained (Word: 111KB)

Description and specification of MIS Toolkit metrics (Word: 111KB)

Frequently Asked Questions Toolkit (Word: 106KB) Answers to some of the most common queries by our users.

MIS Glossary (Excel: 70KB)

LPC Levy Calculation (Excel: 30KB)

LPC Levy Calculation Prior to Dec'16 Prescriptions (Excel: 31KB)

Frequently Asked Questions (FAQs) (Word:31KB)

Out of Pocket Expenses report

Out of Pocket Expenses Reports are accessed via the Information Services Portal

The Out of Pocket Expenses report is available to Area Team authorised users.

The Out of Pocket Expenses report details the monthly claims for Out of Pocket Expenses by Contractor within the Area Team submitted to NHS Business Services Authority by Pharmacy and Appliance Contractors detailing:

  • Area Team
  • Contractor
  • BNF Code
  • Presentation
  • NIC
  • OOPE
  • Quantity
  • Manufacturer

Definition of Out Of Pocket Expenses as outlined in the Drug Tariff Part II - Requirements Enabling Payments to be made for the supply of Drugs, Appliances and Chemical Reagents - CLAUSE 12 OUT OF POCKET EXPENSES:

Where, in exceptional circumstances, out-of-pocket expenses have been incurred in obtaining a drug, appliance or chemical reagent other than those priced in Part VIIIA Category A and M, Part VIIIB, Part IXA, Part IXR of the Tariff and all other specials and imported products not listed and not required to be frequently supplied by the contractor, or where out-of-pocket expenses have been incurred in obtaining oxygen from a manufacturer, wholesaler or supplier specially for supply against a prescription, where such expenses on any occasion exceed 50p payment of the full amount may be made where the contractor sends a claim giving particulars to the Pricing Authority on the appropriate prescription form. The endorsement shall be ‘XP’ or ‘OOP’ to indicate the contractor has taken all reasonable steps to avoid claiming.

Notes


The data provided is based on England Community Dispensing (not prescribing) only. The data may include items prescribed in Wales, Scotland, Northern Ireland and the Isle of Man which have been dispensed in England.

Please note this means that if a prescription was issued, but not presented for dispensing or was not submitted to NHS Prescription Services by the dispenser, then it is not included in the data provided.

The data excludes items prescribed in England but dispensed in Wales, Scotland, Northern Ireland and Isle of Man.

The data excludes items dispensed in prisons, hospital and private prescriptions but does include dental, prison and hospital prescriptions which are dispensed in the community.

Each line shown within the data represents an individual item against which Out of Pocket Expenses has been claimed.

Net Ingredient cost (NIC) is the basic price of a drug as stated in Part II Clause 8 of the Drug Tariff.
Quantity normally shows the quantity of a product prescribed. However, where a product is packed in a 'special container'(see Drug Tariff Part II Clause 10) the pharmacist is not required to split the pack and may supply the number of containers or original packs which provide the quantity nearest to that prescribed. In some circumstances these items show quantity as the number of units supplied i.e. 1 or 2 even though a pack may contain 56 tablets.

Resources

Information Services Portal user guides

Glossary of terms (Excel: 28KB) Frequently Asked Questions (Word: 448KB)

If you have any queries you can contact the Information Services team on 0191 203 5050 or email us at nhsbsa.help@nhs.net