Local Navigation

• Florida Medicaid Home Page
• Abuse & Overpayment
• Area Offices
• Assistive Care Services
• Behavioral Health
• Child Health Services
• Cost Reimbursement
• Disease Management
• Draft Handbook Review
• Durable Medical Equipment (DME)
• Family Planning
• HCBS Waivers
• HIPAA
• Intergovernmental Transfer (IGT) Workgroup
• Long-Term Care Partnership
• Medicaid Encounter Data System (MEDS)
• Medicaid HMOs
• Medicaid Privacy Notice
• Medicaid Procurements
• Medicaid Reform
• Medicaid Research Contracts and Evaluations
• Medicaid State Plan
• MediKids
• MediPass
• Newborn Eligibility
• Nursing Facility Provider Information
• Nursing Home Transition
• Organ Transplant Advisory Council
• Payment Error Rate Measurement (PERM)
• Pharmacy Services
• Preferred Drug List
• Provider Service Network (PSN)
• Provider Training e-Library
• Quality in Managed Care
• Recent Presentations
• Reimbursement Workgroups Meetings
• Report Medicaid Fraud
• Statewide Medicaid Managed Care Program
• Substance Abuse Services
• Utilization Review

834 Analyzer

Version 2.0

The 834 Analyzer is a program that allows the display of parsed 834 data in a printable spreadsheet format. The 834 Analyzer program is not intended for use in a production environment, but rather to aid managed care plans to view their trading partner's outbound transactions. The 834 Analyzer is designed to display 834 transactions downloaded from Florida Medicaid's fiscal agent. The analyzer may not function properly with files produced by other entities, however, the macros are not protected and may be altered by the end user.

Excel must be set to accept macros in order for the 834 Analyzer to function. After opening Excel, click "Tools", "Macro", and then "Security." Click the radio button for "Medium" and close Excel. When reopening Excel and enabling macros, "Analyze X12" will appear on the menu bar. "Click "Analyze X12" to run the program. Clicking "Save Workbook" will save the analyzed file for future analysis. "Reset workbook" will remove the analysis worksheets. The download file includes the 834 analyzer program, user documentation, and a sample 834 file. The State of Florida will not provide support for this tool!

834 Analyzer v2.0 Download

PLEASE READ THE FOLLOWING DISCLAIMER.

NOTE: The analyzer program requires Excel 2000 or Excel 2003 to operate.

DISCLAIMER: The State of Florida (including its employees and agents) assumes no responsibility for consequences resulting from the use of the information herein, or in any respect for the content of such information including (but not limited to) error or omissions or the accuracy or reasonableness of assumptions made in the design of the 834 Analyzer. The State of Florida is not responsible for, and expressly disclaims all liability for, damages of any kind arising out of use, reference to, or reliance on such information obtained from the 834 Analyzer and makes no guarantees or warranties, including (but not limited to) any expressed or implied warranties of fitness for a particular use or purpose with respect to the use of the tool.