Frank,
You can open the file you created in excel. Each column will be a specific field. For the most part, it goes top to bottom, and left to right as far as field order. I know Patient Sig (box 12) is column BS, Patient Sig Date is column BT, and Insured Sig (box 13) is column BU.
To Determine which column is what field, I use the following:
1) Open claim file in Excel
2) Insert row on 1st row of Excel (above the claims)
3) Insert the field headers on that 1st row(provided below, do not copy the paranthesis)
4) Optimize column widths
You should now be able to view the claims with the data in the labeled columns. This is how I determined what column boxes 12/13 were. One thing to note, you will need to delete the first row (where field labels exist) before sending to Office Ally; it causes issues. My system doesn't ask me to save the file as any different format, but if it prompts you to 'save as', you'd want to select text, tab-delimited file format. Hope my explanation was clear enough. Let me know if you're able to figure it out. Again, fields are listed below.
(InsurancePlanName InsurancePayerID InsuranceStreetAddr InsuranceCity InsuranceState InsuranceZip InsuranceCityStateZip InsurancePhone PlanMedicare PlanMedicaid PlanChampus PlanChampVA PlanGroupHealthPlan PlanFECA PlanOther PatientID PatientLast PatientFirst PatientMidInit PatientDOB PatientMale PatientFemale InsuredLast InsuredFirst InsuredMidInit PatientStreetAddress PatientCity PatientState PatientZip PatientPhone PatientRelationSELF PatientRelationSPOUSE PatientRelationCHILD PatientRelationOTHER InsuredStreetAddress InsuredCity InsuredState InsuredZip InsuredPhone PatientMaritalSingle PatientMaritalMarried PatientMaritalOther PatientEmploymentEmployed PatientEmploymentFullTimeStudent PatientEmploymentPartTimeStudent OtherInsuredLast OtherInsuredFirst OtherInsuredMidInit OtherInsuredPolicyOrGroupNumber OtherInsuredDOB OtherInsuredSexMale OtherInsuredSexFemale OtherInsuredEmlpoyerNameOrSchoolName OtherInsuredInsurancePlanorProgramName CondtionRelatedToEmlpoymentYes CondtionRelatedToEmlpoymentNo CondtionRelatedToAutoAccidentYes CondtionRelatedToAutoAccidentNo AutoAccidentState CondtionRelatedToOtherAccidentYes CondtionRelatedToOtherAccidentNo ReservedForLocalUse InsuredPolicyGroupOrFecaNumber InsuredDOB InsuredGenderMale InsuredGenderFemale InsuredEmployerNameOrSchoolName InsuredInsurancePlanNameOrProgramName IsThereAnotherHealhPlanBenefitYes IsThereAnotherHealhPlanBenefitNo PatientSignature PatientSignatureDate InsuredSignature DateOfCurrent DateOfSimilarIllness UnableToWorkFromDate UnableToWorkToDate ReferringPhysician ReferPhysQualifier ReferringPhysicianID Refer_Phys_NPI Super_Phys_NPI HospitalizationFromDate HospitalizationToDate Box19Notes OutsideLabChargesYes OutsideLabChargesNo OutsideLabFees DiagCode1 DiagCode2 DiagCode3 DiagCode4 DiagCode5 DiagCode6 DiagCode7 DiagCode8 MedicaidResubCode MedicaidRefNumber PriorAuthNo HCFACLIANumber FromDateOfService1 ToDateOfService1 PlaceOfService1 EMG1 CPT1 ModifierA1 ModifierB1 ModifierC1 ModifierD1 DiagCodePointer1 Charges1 Units1 EPSDT1 RenderingPhysQualifier1 RenderingPhysID1 RenderingPhysNPI1 FromDateOfService2 ToDateOfService2 PlaceOfService2 EMG2 CPT2 ModifierA2 ModifierB2 ModifierC2 ModifierD2 DiagCodePointer2 Charges2 Units2 EPSDT2 RenderingPhysQualifier2 RenderingPhysID2 RenderingPhysNPI2 FromDateOfService3 ToDateOfService3 PlaceOfService3 EMG3 CPT3 ModifierA3 ModifierB3 ModifierC3 ModifierD3 DiagCodePointer3 Charges3 Units3 EPSDT3 RenderingPhysQualifier3 RenderingPhysID3 RenderingPhysNPI3 FromDateOfService4 ToDateOfService4 PlaceOfService4 EMG4 CPT4 ModifierA4 ModifierB4 ModifierC4 ModifierD4 DiagCodePointer4 Charges4 Units4 EPSDT4 RenderingPhysQualifier4 RenderingPhysID4 RenderingPhysNPI4 FromDateOfService5 ToDateOfService5 PlaceOfService5 EMG5 CPT5 ModifierA5 ModifierB5 ModifierC5 ModifierD5 DiagCodePointer5 Charges5 Units5 EPSDT5 RenderingPhysQualifier5 RenderingPhysID5 RenderingPhysNPI5 FromDateOfService6 ToDateOfService6 PlaceOfService6 EMG6 CPT6 ModifierA6 ModifierB6 ModifierC6 ModifierD6 DiagCodePointer6 Charges6 Units6 EPSDT6 RenderingPhysQualifier6 RenderingPhysID6 RenderingPhysNPI6 TaxID SSN EIN PatientAcctNumber AcceptAssignYes AcceptAssignNo TotalCharges AmountPaid BalanceDue PhysicianSignature PhysicianSignatureDate PhysicianLast PhysicianFirst PhysicianMidInit FacilityName FacilityStreetAddr FacilityCity FacilityState FacilityZip FacilityCityStateZip FacilityNPI FacilityID MammographyCertification SupplierName SupplierStreetAddr SupplierCity SupplierState SupplierZip SupplierCityStateZip SupplierPhone SupplierNPI GroupID)
