1 / 25

New Reports Formats

New Reports Formats. New formats for 353 and 758 reports As well as new Billing file. E-reports. Save these reports somewhere on your computer. Then open Microsoft Excel. Click on FILE. Click on OPEN. Go to the directory that contains the file. Change the file type from . xls to .txt.

randalj
Download Presentation

New Reports Formats

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. New Reports Formats New formats for 353 and 758 reports As well as new Billing file.

  2. E-reports

  3. Save these reports somewhere on your computer. Then open Microsoft Excel.

  4. Click on FILE

  5. Click on OPEN

  6. Go to the directory that contains the file.

  7. Change the file type from .xls to .txt

  8. Click the dropdown and pick .txt

  9. Now you should see your file. Double click on the file name you want to open.

  10. Text Import Wizard will appear. Change file type to DELIMITED.

  11. Then click NEXT.

  12. Uncheck TAB and then check SEMICOLON.

  13. Then click FINISH

  14. New FilePSBILL-HID###-09092012.CSVOpen in Excel, follow the steps shown on slides 4 through 9.

  15. Now you should see your file. Double click on the .CSV file and it will go into Excel.

  16. This spread sheet is made in 5 sections. • Entered • Not Billed • Open • Not Billed 90 • Open 90

  17. Entered • This report will be ran quarterly. So this will just be looking at those claims entered during those months. • This first report is just July and August. • Private is the full charge, not what will be paid.

  18. Entered

  19. Entered - Continued

  20. Not Billed • These are all claims for the last 16 months that have not been billed.

  21. Reports for Not Billed Claims • Ky Medicaid – Report 306 & 3062 • HANDS – No report available • Passport – Report 3063 • Amerihealth – No report available • Coventry – Report 3066 • KY Spirit – Report 3067 • Wellcare – Report 3068 • Medicare – Report 537 • Insurance – Report 733 • Contracts – No Report available

  22. Open A/R • This is all A/R that are still open. • These could go back 3-4 years.

  23. Not Billed 90 • These are claims that are over 90 days old and have not been billed.

  24. Open 90 • A/R that has been open for 90 days or more.

More Related