SQL-Ledger for OpenEMR

OpenEMR.net provides a complete download to the development version of SQL-Ledger modified for accounting use with OpenEMR. The download can be found in the Downloads for Linux section. Accounting for OpenEMR will allow clinics to manage accounts receivable, print patient statements, and, with additional customization, upload your patient statements to your medical claims clearing house for processing and mailing. The new accounting features for OpenEMR include:

1. Ability to import an invoice to SQL-Ledger from the billing screen in OpenEMR, including Patient Billing Data (name, address, insurance company, insurance company id number, co-pay, event data such as location of service, number of units, ICD9s, CPTs, CPT modifiers, date of event, amount to be billed, and co-pay collected);

2. Ability for SQL-Ledger to process EOBs including, ability to enter an EOB data manually, ability to store EOB data entered, ability to edit or delete previously entered EOB data. With additional customization, SQL-Ledger will be able to receive ERA or EOB information electronically from your medical claims clearing house;

3. Ability to apply line items of an EOB to line items of an invoice;

4. Ability to track and show invoices and payments (full or partial) by line item, source of payment (patient/patient id, or insurance company/insurance company id) , adjustments and reasons for adjustments (bad debit, insurance company adjustment);

5. Updates to patient address or other demographic data in OpenEMR is synchronized with SQL-Ledger;

6. Ability to report on or modify outstanding amounts; and

7. Ability to print patient invoices with all the same data as an EOB and additional information (amount payed by insurance company, amount adjusted, remaining balance owed).

SQL-Ledger will provide accounting features for OpenEMR. Clinic users will begin by providing medical services to a patient. Next using the superbill section of OpenEMR the provider or billing department will select appropriate CPT and ICD codes for billing. Next, the billing department will create a claim file for all outstanding, unbilled medical claims for processing. After creating the file, the billing department will upload the file directly to the payer or to your medical claims clearing house using HIPAA ANSI X12. After the medical claims file is created, clinics can manage the outstanding patient balances in SQL-Ledger.

Leave a Reply

Your email address will not be published. Required fields are marked *