I work at a mental health counseling agency that does not accept insurance directly, as we are out-of-network providers. However, many of our patients take the paper receipts we provide and submit them to insurance independently. With our new OpenEMR installation, we would like to continue to generate similar receipts. However, I cannot find a suitable receipt (billing summary, EOB, superbill, report, etc.) that will suffice. For the receipt to be complete, we need the following data on one report:
Patient Name
Patient DOB
Patient Address
Provide Name
Provider NPI
ICD9 diagnostic code
Date(s) of service
CPT service code(s)
Price of Service
Record of receipt of payment(s) from patient
Does anything like this currently exist? If so…where. If not, can anyone guide me in the right direction as to how to customize such a receipt. Thanks for your time!
A good candidate is the Patient Statement, which is generated from Fees/Billing/EOB/Due Pt.
The form can be found in sites/default.statements.inc.php. Lines of code for Physician Name, NPI, DOB and ICD-9 have to be added. The form usually prints up with the CPT code, which did not show up in the first attachment.
When posting the patient’s payment, the staff member has to pretend all insurances had paid by choosing the radio buttons. It may not be necessary to check the secondary billing box but it does not hurt to check it. This will set up the claim to go to the patient. See second attachment.
Of course if no insurance carriers have been entered for the patient, these steps can be skipped.
Excellent! Thanks for the screen shots as well. That’s a good starting point. I’m sure more questions will arise, but I will see how far I can get first. Thanks!
One of the developers will have to help you with insertion of lines of code, if you don’t know how.
If they don’t respond, I’ll take a crack at it. CPT’s have already been coded in, so it may not be such a monumental task to merely add ICD-9 codes.
Let’s wait and see if Visolve responds. They are excellent at that sort of thing.
In the meantime, go to the above cited php file and see if you can figure it out for yourself. If successful, please post again for the benefit of other users.
For now, my best guess is insertion somewhere near line 200. See attachment.
That’s exactly what I’ve been playing with. I was easily able to get more info about the practitioner/facility into the header. For example, I modified sqlStatement() parameter to include such things as f.fax and f.facility_npi from the facility table.
But I’m having trouble getting details out of encounter related tables to print out via statement.inc.php.
I suppose this is because in a “normal” practice it might be considered bad form, at least, to have the billing folks see specifics about the encounters (e.g. icd9 and cpt codes). shrug
So far I’ve followed a chain back to openemr/library/invoice_summary.inc.php which seems to be where data is pulled from the DB and subsequently ends up in $line[‘detail’] in statement.inc.php.
If I’m reading things correctly, if there’s no charge for an item (e.g. an icd9 code) then it won’t get pulled from the DB.
I don’t really want to break the billing portion of this software but will if I have to! heheh.
I wonder if what CapMinds is working on with SuperBill would be helpful. I am going from posting this to reading about that project.
You only need to be in the statement.inc.php file. Once the correct line of codes have been inserted, the patient statement should print up without much fuss.
A charge is assigned to the CPT (procedure) code not to the ICD-9 (diagnosis) code. This would have been done before a practice goes live.
A super bill is another name for an encounter form, which did not fit the bill for Daniel’s requirements.
Had a closer look at the file. Unlike the CMS 1500 form which contains hints as how to alter it, the patient statement form is not that obvious. Will have to defer to one of the developer.
Thanks again fsgl. So, if I understand you correctly, statement.inc.php will can output an encounter’s icd9 code? I haven’t been able to get it to do that using $lines[‘detail’][xxx].
And I think the OP’s list included icd9 codes.
anyway, the modified superbill I mentioned upthread might be something at fits precisely the OP’s request. I’ve been playing with it some (with 4.1.2) and I like it. I’ll see how my client likes it though, cuz that’s what counts, in my case.
I’m resurrecting this thread because I have just sat down again to try to create a custom receipt for patients that includes their CPT codes along with ICD-9 codes and NPI numbers. Like izzaboo above, I was able to change or add facility specific information and static text formatting in the EOB, but I have been stumped as to how to get the following three additional pieces of information onto the EOB for each encounter:
Since these data are in the encounter form, I thought I would be able to simply call up those three pieces from each encounter…but, alas, it is not that simple. Does anyone have some insight into how this might be done?
You need code_type, code, code_text from billing table. For receipt you probably should include option of printing only CPTs/billable services without diagnostics if patient is not going to submit the receipt to insurance.
Provider NPIs are in users table accessed based on name/id information in form_encounter. In some cases you should also consider billing facility.