How to get a report of a patient's ledger?

navier98 wrote on Thursday, June 14, 2012:

Hi:

I’m looking at the patient summary screen but couldn’t figure out how to get the patient’s ledger, a list of charges and payments since day 1.  Can anyone help me, please…  If the GUI doesn’t show the ledger, can it be pulled from the DB?  What’s the table I should look at?

thanks!!

tmccormi wrote on Thursday, June 14, 2012:

The closest you can get to a ledger in OpenEMR is to do this…. (warning counter intuitive…)
Select Fee->Billing then click on the  link
Now enter a patient name (last, first) or Patient ID (in the Chart ID: field)
Change the selector at the end of the row from “Open” to “all” and click search.
Now select everything via the check boxes and hit the Print or Download Selected statement button.  The resulting file is basically what you need.

Otherwise that a look at the sites/default/statement.inc.php for how to get a ledger.  It would be very cool to have an on-demand ledger from the patient record.

-Tony