Importing National Correct Coding Initiative Data

Website

To retrieve the latest list of NCCI Codes, go to http://www.cms.hhs.gov/NationalCorrectCodInitEd

NCCI Types

On the left side of the screen you will see two types of lists that you can download:

  • NCCI Edits – Physicians
  • NCCI Edits – Hospital Outpatient PPS

Selecting Your List

To download the NCCI list, select the NCCI list you would like to download for your Line of Service. Then choose the list that best fits your Service Type. Once you select the list for your Service Type you will find two downloadable lists.

  • CPT Codes – Column 1/ Column 2
  • CPT Codes – Mutually Exclusive

You will need to download both of these files.

Downloading

  1. Select the link for Column 1/ Column 2
  2. A new screen will open asking you to "Agree" to their License Agreement. Click "Agree"
  3. You will be prompted to Save the Zip file for Column 1/ Column 2. Select a location for you to save the file to.
  4. Click Save or Ok to save the list.
  5. Click the "Back" button at the top of your web browser to go back to the previous page.
  6. Repeat steps 1-4 to download the Mutually Exclusive list.

Extracting

To extract the files you just downloaded you will need to have WinZip installed in your PC. (WinZip’s Evaluation version will work just fine.) To extract the lists please follow the steps below:

  1. Right click on the list you would like to extract and select "Extract Here"
  2. An .xls file will appear on your screen.
  3. Do steps 1 & 2 for both zip files that you downloaded.

Editing

In order for the lists to be uploaded to SolAce, some of its columns will have to be deleted and edited. Please follow the instructions below on how to properly edit your .xls files:

  1. Double-click on the .xls file to open it
  2. Click on Row 1 and drag your mouse down to row 2 to highlight the entire Row (click on the actual Row numbers)
  3. While the rows are highlighted, click on Edit and Delete at the top of your screen
  4. Select the Box for Row 1, Column F.
  5. While you have box F1 selected, click on Edit, Clear, and All from the top menu
  6. Now that box F1 is empty, Type "Modifier Allowed" in box F1 and press Enter.
  7. On the menu at the top of your screen, click on Data and Sort
  8. In the "Sort By" box, click the drop down arrow and select "Deletion Date" and select "Ascending"
  9. In the "My list has" area, select Header Row so that the first row of your spreadsheet is not highlighted. (the headers)
  10. Press OK at the bottom
  11. Scroll down the sheet until you find the first row of data that has an actual date instead of an * for its Deletion Date.
  12. Click on the Row Number for that first row of data that you found that has an actual date for its Deletion Date. (You should see the entire row highlighted)
  13. Press F8 on your keyboard once
  14. Press the Page Down button on your keyboard until you have moved past all of the data on the sheet.
  15. Press Delete on your Keyboard. (We need to delete all the codes that have deletion dates. We only want to keep the ones with *’s in the Deletion Date column)
  16. Hold down the Control Key on your keyboard and press the Home button. (this will bring you back to the top of the sheet)
  17. Click on column "C" at the top of the spreadsheet and drag your mouse to highlight columns "D" and "E" as well.
  18. With the 3 columns highlighted, click on Edit at the top of your screen and click on Delete.
  19. You should now only have 3 columns. Columns A, B, and C
  20. Click on File and Save As (not Save) at the top of your screen.
  21. At the bottom of the Save box, for "Save as type" click on the drop down arrow until you find CSV (Comma delimited *.csv) and select it.
  22. Make sure you are saving this file in the same location as your original .xls file and press SAVE.
  23. Do steps 1-22 for both of the .xls files that you have extracted.

The final view of the data in Excel should be as follows:

Importing To SolAce

To import your NCCI codes into SolAce please follow the following steps below:

  1. Log into SolAce
  2. Go to Setup and Edit Checks
  3. Select Add at the bottom of the screen
  4. Give your list a name. ( Either “Column 1/ Column 2” or “Mutually Exclusive” )
  5. Place a check mark in the Active box.
  6. For Tran Type, if you chose the list from the Physicians category, select “Professional Claims”. If you chose your list from the Hospital category, select “Institutional Claims”.
  7. For Check Type select “Correct Coding Initiatives”.
  8. In the Sub Type box select whether you will be importing the Column 1/ Column 2 list or the Mutually Exclusive list.
  9. Press the Import button at the bottom
  10. Browse to the .csv file that you just created.
  11. Select your .csv file and click Open.
  12. Press OK at the bottom of the screen
  13. Make sure that the “Active” box is checked for your list in the Main Edit Checks screen.
  14. Click SAVE at the top of the screen.

Congratulations! You have now imported your NCCI list into SolAce! Any claims that are imported or edited that don't match the conditions for the Edit Check will now trigger a warning. SolAce's core edits still occur - this adds correct coding checks to them.


The names of other companies, products and services are the property of their respective owners.

customer Testimonial

quote left quote right

customers From our customers

I am very pleased with our SolAce billing software and how easy it is to navigate. They have a great team who can train you to do billing even if you don’t have billing experience. Special thanks to Cathy, Gigi, and Skyler who always helps me out every time I have issues.

Shani Madaminova,
Administrator
Best Home Care, Inc
Jersey City, NJ

SolAce is awesome software. I absolutely LOVE it. For over three years I have used this software daily for multiple long term care facilities to submit claims to various MACs, Medicaid, and Medicare Advantage and Supplemental Insurance carriers. It is convenient, simple to use and far less costly than any Clearing House software I had explored. The ability to import from my Practice Management Software and Therapy Providers has reduced any RTP claims edits and denials are a thing of the past. Customer Support is “Johnny on the spot”, but terrific as they may be, it gets better - RARELY do I need to call. LOVE IT, LOVE IT, AND LOVE IT.

Susie Doran Carter, Westcare Management, Inc.
LTC Medicare Consultant and Billing Service
Salem, OR

I think our medical office was one of the first to use SolAce in the mid 1990’s and we are still using it today for all of our electronic billing because it works ! It was simple for our staff to learn and it integrated easily with our accounting/billing program. It has been especially nice to know that the Axiom staff is there when Medicare changes something and they are right on it. They made the 5010 change a simple process plus made educational seminars available to us. Thank you to all the Axiom/ Ivertex professionals who have helped us for the last 15+ years.

Carolyn Boles
From the office of Donald J. Boles Jr. MD PC
Tempe, AZ

SolAce has been a valuable tool that has been a life saver for my billing service for years. It has allowed me to bill professional and institutional claims with ease. Customer service @ SolAce is top rated in my opinion. The SolAce product is very user friendly and affordable. Thank you SolAce team for a great product.

S. Bowling
Idabel, Oklahoma

Easy to use, Customer support has always been excellent, Thanks SolAce Team.

Carl Shepherd
IT Administrator
THE WYNN GROUP, INC
Dublin, GA

I am a new client and was having a tough time getting everything set up just right. I had to make calls to CEDI and when I called back the rep I spoke with prior even helped the 2nd rep to make sure I got all the info I needed. They definitely work as a team. Within a short period of time they had my system up and running. I never could've done it without them.

Denise
Margate, FL

Awesome customer service every time!

Denise
Bellevue, NE

I can't tell you how wonderful it is to work with your agency. They are courteous, knowledgeable,friendly, and a joy to work with - I can't say enough. Thank you!!

Doreen
Bemidj, MN

The service was very good. Phone answered promptly even though it was around 6 p.m. my time. Very courteous and helpful. So far I have had really good experiences with your support team.

George
Mahornet, IL

The follow-up is outstanding - whenever there is an issue I am contacted to be sure that all is working well and to my satisfaction.

Joan
Batavia, IL

Everyone in your company is very helpful and pleasant, and they always have the quickest response time on fixing the situation.

Patricia
Orlando, FL

Tech was very helpful, very patient and very professional. She knew of the issue quickly and stayed at hand until issue was resolved. Very satisifed with the service.

Sherry
Largo, FL