How to total payments and billing and writeoffs separately... 3 columns please anyone?

dgcmd wrote on Monday, October 27, 2014:

how to total payments and billing and write offs separately… 3 columns please that add up at the bottom… so I can see how much we have billed, how much paid and how much written off.

teryhill wrote on Monday, October 27, 2014:

Would this work for what you need? It is not in the current edition of openemr but I hope it will be soon.

Terry

fsgl wrote on Monday, October 27, 2014:

A Day Sheet would be a great addition. Thanks Terry.

One consideration. It’s easier to follow the payments & adjustments if they are grouped with each of the charges.

arnabnaha wrote on Monday, October 27, 2014:

It will be a great addition for sure…Thank u terry for everything…and I agree with fsgl…the total charges can be grouped with each provider or each patient seperately rather than putting it in the bottom.

teryhill wrote on Monday, October 27, 2014:

Are you wanting each encounter totaled? If you are wanting me to match payments to the encounter How do I handle it if the payments and adjustments are not on the same day as the encounter (not a daysheet then)?

The original client requested it by user so the staff could use it for checking up at the end of the day.

There is also a feature that will allow the printing of the last page (totals) for a date range so you can get a month to date, quarter to date and year to date or any combination that you would like.

Let me know what you want and I will give it a shot.

Thanks
Terry

teryhill wrote on Monday, October 27, 2014:

Day sheet take 2. I added totals per incident.

Terry

fsgl wrote on Monday, October 27, 2014:

How about Take 3?

The entry for H. Tudor should come after that for Catherine Parr. LibreOffice Writer has a mind of its own.

teryhill wrote on Wednesday, October 29, 2014:

Needs some clean-up but I think you will get the idea.

Terry

fsgl wrote on Wednesday, October 29, 2014:

Thanks again, Terry.

Most solo practices will need the Day Sheet only for a single day. Larger offices may require multi-day reporting.

blankev wrote on Wednesday, October 29, 2014:

If it is for a day sheet, for reading it is easier if Invoice and Payment are close together. Not first Invoices, followed by Payments of the different patients.

Or is this what you will do in the cleanup phase?

teryhill wrote on Wednesday, October 29, 2014:

I have the software set up so you (or any developer) can create their own print out. it just needs to be named “print_daysheet_report.php” and placed in the “sites/default/” directory. I will offer the 3 versions that have been shown here as starting points.

But the real answer to your question is “Yes” I hope (with some more education) to be able to align those items up.

Terry

teryhill wrote on Wednesday, October 29, 2014:

Getting Closer

Terry