Skip to main content Skip to footer

Report information

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

You can find notes about how the data has been produced, for example, what is and what is not included in the data.

Itemised Prescribing Payment (IPP) report

The Itemised Prescribing Payment (IPP) Report is available via ePACT2.

The Itemised Prescribing Payment (IPP) Report shows the reimbursement costs for each prescribing organisation for prescriptions dispensed by pharmacy and appliance contractors. 

It's used by NHS England to calculate the charge shown in the Cash Report for CCGs.

We also use this to calculate charges to be invoiced to:

  • hospital trusts
  • Independent Sector Healthcare Providers (ISHPs)
  • local authorities

If you have any queries about Cash Report, contact NHS England by: Email: nhsenglandcash.management@nhs.net.
 

Useful information

IPP uses actual cost in rows 1- 4 of the report therefore payments for containers (Drug Tariff Part IV) and out of  pocket expenses for identified prescribing are included in these rows.

Payments for containers (Drug Tariff Part IV) and out of pocket expenses for dentists and national unidentified prescribers are included in line 7 - Elements for which resources have been retained centrally.
 

What is included in IPP Reports

There are 3 views of the report available, depending on your permissions.

  • National (DHSC Only)
  • Area
  • Commissioner/Provider

National IPP Report

The National IPP Report is only available to the Department of Health and Social Care and NHSBSA users. It shows the consolidated figures for relevant organisations.

Area IPP Report

Area View shows the aggregate Area detail. It's possible to view commissioner / provider Report by clicking into the 'Comm./Prov Individual Tab' and selecting the required commissioner / provider's name from “drop-down menu”.

Access to the Area IPP Report is only available to authorised users approved by the named Area Team.

Commissioner / provider IPP Report

Commissioner/Provider View shows the detailed breakdown of reimbursement costs for individual Commissioner/Providers, including Hospital Trusts. 

Access to an individual organisation's IPP report is only available to authorised users approved by the named organisation.

The are 7 lines on the report:

Line 1 - Practice / Comm. / Prov. prescribing where the correct practice, cost centre or hospital unit could be identified

The actual cost of prescribing in the named commissioner / provider by identified practice prescribers, commissioner / provider employed prescribers or hospital units i.e. GP, nurse, supplementary prescribers or hospital units, for the named dispensing month, which have been dispensed in primary care.

Line 2 - Unidentified prescribing where only the commissioner / provider could be identified

Contains all commissioner / provider prescribing which has been dispensed in primary care that can not be linked to a specific prescriber or hospital unit but can be linked to the named commissioner / provider.

Line 3 - Deputising Services where only the commissioner / provider could be identified

Contains all deputising service prescribing which has been dispensed in primary care that can be linked to the named commissioner / provider.

Line 4 - Community Prescribing

Contains all prescribing issued under a community Nurse Prescribing Contract. Community Nurse Prescribing contracts were discontinued in April 2013 as part of NHS reforms.
 

Line 5 - Adjustments to Charge Statements (this line is currently not used)

The actual cost of adjustments caused by, for example, late notification of GP movements, computer produced prescriptions for a GP still being generated for a previous practice, and pricing errors.
 

Line 6 - Lost batch prescriptions (this line is currently not used)

The actual cost of lost batches as authorised by the commissioner / provider. From April 2013, commissioner / provider no longer authorise lost batches as this is now done by Area Teams.

Line 7 - Elements for which resources have been retained centrally

This is the proportional share per commissioner / provider of other costs based on prescribing which can not be directly attributed to practices. These costs include:

  • VAT
  • nationally unidentified prescribing
  • broken bulk
  • schedule adjustments
  • net cross boundary costs out of pocket expenses
  • payments for containers for national unidentified prescribing
  • Urgent Medicine Supply (wef December 2016)
     

Resources:

ePACT2 User Guides

Glossary of terms

Data Dictionary (Excel: 46KB)​​​

Contact us if you have any questions or would like more information.

 

Remuneration Report

The Remuneration Reports are available via ePACT2.

Provides information to support the monitoring and management of remuneration payments for pharmaceutical services supplied by pharmacy and appliance contractors.

This report only shows payments which relate to remuneration and include payments previously sourced from funding held centrally by the Department of Health, known as the global sum.

ePACT2 will hold data from April 2018, which will be updated on a monthly basis.

The Remuneration Report is split into 2 views:

  • 'All values' - used for information purposes only and provides users with an overall view of remuneration for all the organisations which are linked to them
  • 'Recharge values' - showing only the remuneration which the organisation has been charged for

The 'recharge view' is only available to organisations at Area Team level and above.

Useful information

All remuneration costs are invoiced to the appropriate organisation with the exception of those relating to Clinical Commissioning Groups, which are recharged to NHS England.

Where a particular fee or an allowance cannot be directly attributable to a specific commissioner / provider, the activity and associated amount recharged is shared across all commissioner / providers.

The basis for the sharing is in accordance with specified formulae, which are listed in the Rumuneration Report glossary (Excel: 690 KB).

The fees column shows the number of identifiable fees which can be directly attributed to a commissioner / provider, cost centre or hospital unit.

Fees are identified from the prescriber number or the commissioner / provider information included on the prescription form.

Fees which cannot be attributed to a particular commissioner / provider are shared and shown under National Unidentified Prescribers.

Unidentified Prescriber shows the fees / allowances attributed to unidentified prescribers where a prescription form (FP10, FP10HP) does not contain sufficient detail to identify the prescriber but the commissioner/provider can be identified

Resources:

ePACT2 User Guides

Glossary of terms

Data Dictionary (Excel: 46KB)​​​​

Contact us if you have any questions or would like more information.

 

Prescribing Monitoring Document (PMD)

Prescribing Monitoring Document (PMD) reports are accessed through ePACT2.

PMD provides monthly financial information about prescribing costs against budgets, to enable management of the drugs element of unified budgets.

The figures shown on this report are for monitoring purposes only and do not reflect the actual charge.

Data within the PMD report is updated on a monthly basis.

Statements are issued every month and show:

  • the indicative prescribing budget for the current financial year (not shown in April or May) 
  • total monthly expenditure 
  • cumulative expenditure (April to current month) 
  • forecast out-turn (based on information provided by the Department of Health and Social Care which is based on a spending pattern, calculated using previous years spending data). The accuracy is determined by local factors at a local level (not shown in April or May) 
  • the number of dispensing days in the month and year to date

The annual statement produced for March shows the actual expenditure for the financial year.

Useful information

Figures are based on the 'actual' cost of drugs prescribed.

 'Actual' cost is the basic price of the drug less the National Average Discount Percentage (NDAP) plus:

  • Payment for Consumables (previously known as Container Allowance)
  • Out of Pocket Expenses
  • Payment for Containers (10p for splitting packs)

All amounts are rounded to the nearest pound (£):

Monthly spend - some of the costs incurred for the dispensing of prescriptions are excluded from the expenditure figure. These are professional fees, on-cost, oxygen cylinder delivery service, and oxygen concentrator services.

OOHC budgets are held locally. The OOHC expenditure shown only relates to FP10 prescribing that has been dispensed in the community.

Budget and forecast figures will not be shown on PMD statements for the first two months of each financial year. This is due to the volatility of prescribing over a short time period which can seriously distort the annual outturn amount.

If a practice moves to a new commissioner / provider mid-year, they'll retain their existing budget as this has been set according to the needs of the practice. If their target budget needs to change mid-year, these changes need to be agreed with the commissioner / provider. If the practice splits, the budgets will need to be agreed with the commissioner / provider and will normally be prorated with list sizes.

Practice budgets are notified to us by commissioner / provider. We do not hold records of local contingency funds.

What is included in PMD Reports

There are 5 types of report available to view:

  • National Statement
  • Area & Comm./Prov.* Statement
  • Practice Summary in Comm./Prov. (commissioner/provider)
  • Practice Prescribing
  • Practice Annual Profile

National

The National PMD Statement shows the aggregate National detail.

Area & Commissioner/Provider

Contains Area and Comm./Prov. totals.

Practice Summary in Comm./Prov.

Contains a list of practices in the commissioner's / provider’s area and also Prescribing which are outside the Commissioner/Provider. Out of area prescribing shows Commissioner/Provider community non-medical prescribing where a prescription has been provided to a patient who belongs to a practice which is outside of the Commissioner/Provider where the prescriber is employed.

The costs of these prescriptions will be charged back to the prescribers commissioner / provider. Any commissioner / provider community non-medical prescribing for practices within the commissioner / provider where the prescriber is employed, will be charged to the practice identified on the prescription form.

Practice Prescribing

The Practice Statement includes a breakdown of expenditure by major therapeutic group.

Practice Annual Profile

Monthly expenditure details for the whole of the previous year, (April to March), plus details for the current year to date. This information provided is cumulative. For example, April contains April details only, whilst May contains April and May.

It shows expenditure to date for each of the months.
 

Resources:

ePACT2 User Guides

Glossary of terms

Data Dictionary (Excel: 46KB)

​​​​Contact us if you have any questions or would like more information.

MO KTT

The charts and data tables show values for prescribing comparators supporting the QIPP (Quality, Innovation, Productivity and Prevention) medicine use and procurement workstream.

  • The aim of the comparators is to support organisations and prescribers to review the appropriateness of current prescribing, revise prescribing where appropriate and monitor implementation.  The comparators are not intended to be used as targets or performance tables but rather highlight variation and support local discussion and decisions regarding QIPP. 

Further information concerning QIPP, and in particular the Medicines use and procurement workstream incorporating the QIPP prescribing comparators, can be found at the following link: https://www.gov.uk/government/news/qipp-national-workstreams-updated

The current comparators cover 12 of the 14 therapeutic areas included in the latest update of the Medicines and Prescribing Centre publication – Key Therapeutic Topics - Medicines management options for local implementation

The reports have been split into 4 sections.

  • ADQ/Items
  • ADQ/STAR PU
  • Percentage/Items
  • Items/STAR PU

Charts are presented with their associated data to provide a high level view of prescribing at:

  • Regional Office
  • Area
  • Commissioner/Provider level
  • Practice
  • All Practice Data

Three Views to select:

  • In quarter
  • Quarter on Quarter
  • Year on Year

The data only includes NHS prescribing for prescribers who are linked to a practice.

The data provided is based on items which have been prescribed in England on an FP10 and FP10HP and dispensed in the community. The data may include items prescribed in England but dispensed in Wales, Scotland, Northern Ireland and the Isle of Man.

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 Wales, Scotland, Northern Ireland and Isle of Man but dispensed in England.  The data excludes items dispensed in prisons, hospitals and private prescriptions but does include prison and prescriptions issued by provider organisations which are dispensed in the community.  It also excludes items prescribed by dentists, unidentified prescribers and prescribers working directly for the commissioner/provider.

For comparators using PU weightings in the calculation, the following should be taken into account:

Practices that have prescribing, but do not have a list size, will be included in the data and have a comparator value of '0' as there is no list size to make the calculations.

Practices that have not prescribed, and do have a list size, will not be listed at all in the practice level data for that comparator.  However, the list sizes for those practices with no prescribing will contribute to the list size and therefore comparator value in reports at a higher level (Commissioner/Provider level).

Resources

ePACT2 User Guides

Glossary of terms

Data Dictionary (Excel: 46KB)

Contact us if you have any questions or would like more information.

Prescribing Analysis Reports

Prescribing Analysis Reports are accessed via ePACT2

Prescribing analysis reports provides information regarding volume and cost of prescribing which has taken place for primarily a Commissioner / Provider or Practice during the reporting period. Some reports provide Area and England analysis. Monthly and quarterly datasets are available.

The content of the reports is based on current geography structure.  The data will change each month as the geography structure changes.

The system will hold 60 rolling months data which will be updated on a monthly basis.

Caveats

Figures are based on the 'Net Ingredient' cost of drugs prescribed.

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

The data provided is for prescriptions issued by prescribers in England only which have been dispensed in the community. All Hospitals prescriptions, including those dispensed in the community, private prescriptions and dental prescribing, are included in the data.

Items show the number of times a product appears on a prescription form.

What is included in Prescribing Analysis Report

There are six types of report available to view

  • Comparison of Cost per ASTRO PU
  • Prescribing Costs by BNF Level
  • Prescribing Costs, Volume and Average Cost per Item
  • Prescribing Trend
  • Total Practice Prescribing
  • Top 20 Leading Drugs

Comparison of Cost per ASTRO PU

Comparison of NIC per Astro-PU between - Commissioner / Provider, Area and England or
between Practice, Commissioner / Provider and England.

  • Commissioner / Provider - monthly
  • Practice - monthly
  • Commissioner / Provider - quarterly
  • Practice – quarterly

This report will show comparison of cost per Astro PU of the selected organisation with respect to values against its parent organisation and National level for a period of thirteen months in case of monthly reports and for eight quarters in case of quarterly reports.

The ASTRO PUs are the number of cost based 'Age, Sex and Temporary Resident Originated Prescribing Units'.

Prescribing Costs by BNF Level

This report will lay out an analysis of NIC and Items by BNF Chapters or by top 40 BNF Section at various Commissioner/Provider and Practice levels in NHS Hierarchy. 

  • Commissioner / Provider for BNF Chapter – monthly
  • Practice for BNF Chapter – monthly
  • Commissioner / Provider for Top 40 BNF Section – monthly
  • Practice for Top 40 BNF Sections – monthly
  • Commissioner / Provider for BNF Chapter – quarterly
  • Practice for BNF Chapter – quarterly
  • Commissioner / Provider for Top 40 BNF Section – quarterly
  • Practice for Top 40 BNF Section - quarterly

Prescribing Costs, Volume and Average Cost per Item

This report will lay out an analysis of total prescribing costs (NIC) and volumes at Commissioner/Provider and Practice level in the NHS Hierarchy. The report will also show average cost per item (NIC) at the appropriate organisation level.

  • Commissioner / Provider – monthly
  • Practice – monthly
  • Commissioner / Provider – quarterly
  • Practice – quarterly

Prescribing Trend

Prescribing trend for items and NIC, provided as a total or as a breakdown of
BNF therapeutic groups at BNF chapter or BNF section level.

  • Commissioner / Provider – monthly
  • Practice - monthly
  • Commissioner / Provider by BNF Chapter – monthly
  • Practice by BNF Chapter – monthly
  • Commissioner / Provide by BNF Section – monthly
  • Practice by BNF Section – monthly
  • Commissioner / Provider – quarterly
  • Practice – quarterly
  • Commissioner / Provider by BNF Chapter – quarterly
  • Practice by BNF Chapter – quarterly
  • Commissioner / Provider by BNF Section – quarterly
  • Practice by BNF Section – quarterly

This report will lay out the trend of prescribing costs and items over a period of time, thirteen months in the case of monthly reports and eight quarters in the case of the quarterly reports.

Total Practice Prescribing

This report will show the overall prescribing ascribed to a practice showing the details of different prescribers:

GPs, nurses and other prescribers contracted to your practice.

  • Practice Prescribing – monthly
  • Practice Prescribing – quarterly

Top 20 Leading Drugs by NIC

This report shows the total cost and number of items corresponding to the top twenty cost drugs at various organisation levels:

  • England - monthly
  • Area - monthly
  • Commissioner / Provider - monthly
  • Practice - monthly
  • England - quarterly
  • Area - quarterly
  • Commissioner / Provider - quarterly
  • Practice - quarterly

Resources

Differences document (Word: 252KB)

ePACT2 User Guides

Glossary of terms

Data Dictionary (Excel: 46KB)

Contact us if you have any questions or would like more information.