CheckRx, a companion service to Check34, will be available to all community pharmacy contractors from mid-August at www.checkrx.net. It uses the prescription item report (or Px report – see more information below), which the NHS Business Services Authority (NHSBSA) offers to contractors each month via its website, to give information on:
- FP34 payment data (script type, basic prices, fees paid, expensive items, etc.);
- Drug Tariff splits of items dispensed (Part VIII Category A/M/C split, Part VIIIB, appliances, ACBS, etc.);
- Brand/generic analysis and product usage by volume, value or number of items;
- Which GP practices your scripts come from, and Electronic Prescription Service (EPS) nominations; and
- Clinical/therapy area split (by item/patient).
CheckRx also provides competitor analysis, showing how pharmacies nearby are performing. It will show the number of items they are dispensing, how many Medicines Use Review (MUR) and New Medicine Service (NMS) consultations are being conducted, and their EPS nominations, as well as which local surgeries prescriptions originate from. This information is all sourced from publically available data on the Health & Social Care Information Centre (HSCIC) website.
Contractors will be able to review their Schedule of Payments – reconstructed from the Px report using PSNC’s PRISM pricing tool – and drill down into the various sections. Other areas on the dashboard will allow them to see which are the most frequently dispensed medicines (selected by value, number or volume), and which section of the Drug Tariff their items fall under.
A script source analysis chart shows which items have been prescribed by which GP practice, while another area splits items into clinical or therapeutic category (using BNF classifications). Finally, a set of pre-set search filters will allow for specific searches of all sections of the Px report.
Clicking on a section of the dashboard, e.g. Part VIII Category M of the Drug Tariff, will provide a report of all dispensed items for that month that fall into Category M. This can be exported for further analysis. Clicking on a line (item) in this report will give all the detail for the specific item, including reimbursement paid, endorsements and fees, and the prescribing practice.
Although CheckRx has its own web address, it shares the same administration module as Check34, so users can sign in to both services using the same user name and password. Account managers can set up and structure their company as they can in Check34. Users will be able to switch from one service to the other, provided they subscribe to both.
The NPA held a webinar demonstrated how to use the key features of CheckRx to improve and grow your pharmacy business. You can view the webinar here.
What is the Px report?
The Px report has been available to all contractors from the NHSBSA since the beginning of the year. It provides a line by line reconciliation of what a contractor has been paid for their prescription bundle for the relevant month. It details:
- Script type (paper or EPS) and form type (FP10, FP10MDA, FP10D, etc.);
- Paid, exempt and no charge items;
- Drug description, pack size and basic price (and SNOMED code);
- Amount paid (at Standard or Zero Discount Rate);
- Endorsements and fees paid;
- The originating GP practice; and
- A version of the patient’s NHS number.
It is used to compile a substantial part of the Schedule of Payments (FP34) sent monthly to every contractor.
However, the Px report is not very user friendly! It is presented as a 72-column spreadsheet, with as many rows as items priced for that month. There is a 31-page Transparency Standard User Guide on the NHSBSA website that explains how it all hangs together, but you need to be an Excel expert to apply it to the Px report.
CheckRx does all the hard work for you, turning this raw data into useful business intelligence for your pharmacy.
How can I use CheckRx to help my pharmacy business?
CheckRx can be used to:
- Identify missing fees/incorrect endorsements (e.g. Schedule 2/ 3 Controlled Drug scripts);
- Determine which items you are dispensing at a loss (e.g. branded generics);
- Expensive items reconciliation;
- Ensure supplementary fees are correctly paid;
- Understanding product usage (Drug Tariff category splits/generic/branded);
- Inform stock management and purchasing decisions (generic tendering, Non-Tariff programmes);
- Competitor analysis (prescription drift, EPS nomination); and
- Understanding therapeutic categories and patient groups to deliver clinically-focussed community pharmacy services locally.
How can I access CheckRx?
This new service will be available to all contractors from August 15, 2016 and can be accessed at www.checkrx.net
The CheckRx subscription fee for a single pharmacy for 12 months will be £144.
The National Pharmacy Association (NPA) has entered into an arrangement with PSNC Data Systems that means all NPA members in England will be offered the new service at a preferential rate (£120+VAT).
The NPA will also be managing subscription sales for CheckRx to any independent pharmacies not currently in NPA membership.
Company Chemists’ Association (CCA) members who want to find out more about CheckRx can email CheckRxadmin@psnc.org.uk or contact PSNC Data Systems on 0203 1220 813 for more information.
Where can I find my Px report?
Px reports for contractors are not held centrally by PSNC at the moment, so contractors will need to load their pharmacy Px reports into CheckRx (PSNC holds FP34 Schedule of Payment data for all contractors, so the data in Check34 is centrally managed).
This is a two step process:
- Contractors need to download their Px report from the NHS BSA website to their PC or laptop.
- Then they need to drop it into CheckRx – this is just like adding an attachment to an email.
Contractors will needs to have an account with the NHS BSA before they can download Px reports for their pharmacy(ies).
Detailed instructions on how to set up an NHS BSA account (steps 1-7) and download Px reports (8-15) are given below.
How can I set up an account on the NHS BSA website?
- To download your Px report you will need to have an account with the NHS BSA.
• If you already have an account go to How can I download a Px report?
• If you do not have an account continue to part 2
- Open your internet browser and go to www.nhsbsa.nhs.uk/PrescriptionServices.aspx
- In the menu bar on the left scroll down to select Dispensing Contractors – Information home page
- On the Dispensing Contractors – information page, select option 4 – Payment information available to pharmacy and appliance contractors
- For information on who can register click here
- For a Payment Information Registration Form click here
- Completed Registration Forms need to be returned fully completed by email to: firstname.lastname@example.org. It may take a few days for your account to be created.
How can I download a Px report?
- To download your Px report go to the NHS BSA website – Information Services Portal
- Enter your email and password to log in.
- Click on +Report in the blue box top left (above Broadcasts)
- Click on Payment Information
- Click on Prescription Item Report
- This will bring you to a screen with the list of Px reports available to you.
- In the Action column (far right), click on the blue icon to download your monthly report to your computer. Save the file into a folder on your computer using the same file name. DO NOT MAKE ANY ATTEMPT TO CHANGE THE FILE NAME OR FORMAT.
- Use the Bookmarked function (top right in black bar) to save this page for quick reference in future when you log in. The bookmark will appear on the screen after you have logged in.
How can I drop a Px report into CheckRx?
Downloading a Px report into CheckRx is a simple process, similar to adding an attachment to an email.
Your Px report should be in a .csv file format. The file name should be set out as:
PX reports should download from the NHS BSA website in a .csv format with a file name as shown above. DO NOT MAKE ANY ATTEMPT TO CHANGE THE FILE NAME OR FORMAT.
- Sign in to Check Rx – you will need to be the account manager.
- In the Admin Area select Px File Upload in the menu on the left.
- Click on Choose files. In the window that opens up, go to the folder on your computer where you saved the Px report(s) from the NHS BSA website. Select the files that you want to download and click Open. You can download as many files at a time as you wish.
- Click on Upload. You will see a message ‘Uploaded successfully. File(s) now queued for further processing.’
- Under Uploaded Files the status of the Px reports you have uploaded will show as ‘Queued For Process’.
- When processing is complete the status will show as ‘Extracted’. The extraction process may take several minutes, depending on how many files you have loaded.
Once the file has been extracted you may view the data in the CheckRx Dashboard.
Files with an incorrectly configured file name will be rejected, as will files for a pharmacy which is not in your account.