edgeMED Help Center > Practice Management > Billing
edgeMED billing export guide.
Getting Started
If your organization is interested in an ongoing export of your edgeMED billing data, notify an edgeMED customer care representative of your interest and provide them with the email address you will use to access your data.
Access Your Data
Once we receive your email address, a web link will be provided to you so you can access the exports. To access the data associated with the URL, you will need to log into the Gmail account for the email address provided to edgeMED. Alternatively, you will be prompted to sign in to the Gmail account associated with the email address provided to edgeMED if you are logged out of all Gmail accounts prior to clicking on the URL.
Your export file will be updated daily at 8:00a ET and 3:00p ET. The exports will be provided in .csv format and will contain all records (not simply net new records).
Data Elements
Click here to view the data elements available in the export:
- doctor_company_id
- billing_event_type
- claim_id
- claim_status_id
- claim_status_date
- era_payment_claim_status_code_id
- encounter_id
- display_encounter_id
- encounter_created_date
- charge_created_by
- encounter_detail_id
- encounter_detail_charge_id
- encounter_detail_status_code
- encounter_charge_id
- charge_type
- place_of_service
- service_facility_location_id
- service_date_from
- service_date_to
- batch_date
- initial_billed_date
- charge_created_date
- responsible_payer
- responsible_party_code
- rendering_provider
- rendering_provider_npi
- rendering_provider_last_name
- rendering_provider_first_name
- rendering_provider_entity_name
- billing_provider_last_name
- billing_provider_first_name
- billing_provider_entity_name
- billing_provider_npi
- billing_provider
- supervising_provider_last_name
- supervising_provider_first_name
- supervising_provider_middle_initial
- attending_provider_last_name
- attending_provider_first_name
- attending_provider_middle_initial
- scheduling_provider_last_name
- scheduling_provider_first_name
- scheduling_provider_middle_initial
- scheduling_provider
- referring_provider_last_name
- referring_provider_first_name
- referring_provider_middle_initial
- procedure_code
- procedure_name
- revenue_code
- dx_A
- dx_B
- dx_C
- dx_D
- M1
- M2
- M3
- M4
- charge_amount
- unit_charge_amount
- units
- anesthesia_start_time
- anesthesia_end_time
- encounter_fee_schedule_name
- expected_rate
- patient_id
- patient_dob
- patient_chart_number
- patient_last_name
- patient_first_name
- patient_middle_initial
- patient_gender
- patient_street_address_1
- patient_street_address_2
- patient_city
- patient_state
- patient_zipcode
- patient_home_phone
- patient_work_phone
- patient_cell_phone
- payer_name
- primary_insurance_policy_number
- primary_insurance_group_number
- primary_insurance_name
- primary_insurance_phone
- secondary_insurance_name
- tertiary_insurance_name
- payment_id
- payment_reference
- is_posted
- payment_created_date
- Payment Created By (Coming Soon!)
- payment_date
- posted_date
- payment_method
- allowed_amount
- disallowed_amount
- payment_amount
- deductible_amount
- co_insurance_amount
- co_payment_amount
- writeoff_amount
- total_adjustment_amount
- adjustment_codes
- reason_code
- penalty
- payment_date
- payment_date
- charge_is_self_pay
- resubmission_code_type_id
- payment_responsible_party_id
- payment_transaction_code
- payment_reference
- transaction_type_code
- is_denial
- patient_responsibility_amount
- leave_open
- insurance_encounter_detail_payment_id
- insurance_misc_payment_id
- patient_encounter_detail_payment_id
- patient_encounter_misc_payment_id
- patient_fund_detail_id
Billing Event Type
The column for Billing Event Type describes the type of data found in each row of the data export. There are 7 possible values that fall into two types of rows, payment rows and charge rows.
Payment Rows:
When building reports or calculations for payments, use payment rows. You can combine these different payment row types into a single report or calculation as needed (or choose only one payment row type if required). For the charge data related to each payment row, you will find the relevant charge data in the columns of the payment row. This can be helpful for identifying payment/charge relationships but isn’t recommended for charge-related calculations.
Insurance Payment
Misc Insurance Payment
Patient Payment
Misc Patient Payment
Patient Fund Payment
Charge Rows:
When building reports or calculations for charge-related inquiries, use only charge rows. Payment rows will not provide accurate overall charge reporting, because charges without an associated payment will not appear in the payment rows. Also, attempting to combine Charge and Payment row types in the same reporting will provide incorrect charge calculations - charges that have received a corresponding payment will appear twice.
Billed Charge
Unbilled Charge
Still need help? Contact us!