New Reports Formats

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

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

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

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

18. 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.

19. Entered

20. Entered - Continued

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

22. 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

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

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

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