Financial Summary by Service Code

Day-to-Day Users
1

wjbaptis wrote on Monday, January 14, 2013:

Does anyone know how to use this report. I’m only seeing invoices that were created between the to and from dates and also have payments between the to and from dates. Any payments made during that period for invoices created outside the to and from dates does not display. Is this sort of like a CASH report grouped by service code? Thanks.

2

tmccormi wrote on Monday, January 14, 2013:

Just sounds like a bug to me.  It was written by Rod and updated by Visolve for one of my customers.  Perhaps someone at Visovle would be willing to take a look at it.

svc_code_financial_report.php
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530   1) <?php
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530   2) /**
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530   3)  * This is a report of Financial Summary by Service Code.
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530   4)  *
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530   5)  * This is a summary of service code charge/pay/adjust and balance,
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530   6)  * with the ability to pick "important" codes to either highlight or
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530   7)  * limit to list to. Important codes can be configured in
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530   8)  * Administration->Service section by assigning code with
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530   9)  * 'Service Reporting'.
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  10)  *
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  11)  * Copyright (C) 2006-2010 Rod Roark <rod@sunsetsystems.com>
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  12)  *
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  13)  * LICENSE: This program is free software; you can redistribute it and/or
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  14)  * modify it under the terms of the GNU General Public License
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  15)  * as published by the Free Software Foundation; either version 2
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  16)  * of the License, or (at your option) any later version.
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  17)  * This program is distributed in the hope that it will be useful,
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  18)  * but WITHOUT ANY WARRANTY; without even the implied warranty of
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  19)  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  20)  * GNU General Public License for more details.
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  21)  * You should have received a copy of the GNU General Public License
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  22)  * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  23)  *
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  24)  * @package OpenEMR
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  25)  * @author  Visolve
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  26)  * @link    http://www.open-emr.org
7b8e0ccc (visolve-openemr 2012-06-18 17:55:35 +0530  27)  */

Tony
www.mi-squared.com / @tonymi2
oemr.org / @OEMR_org

3

visolveemr wrote on Tuesday, January 15, 2013:

Hi Wjbaptis/Tony,

Sure we will have a look on this report. Before that, the purpose of this report is , display the financial summary of  Facility/Provider/particular period (From and To payment date) by grouping the “Service Codes”.

For eg,  You want to know , how much payments made for particular service code in a particular period of time , you can use this report. And you can configure the important codes( administration -> lists -> Service Codes for Financial summary) .

If any bug is in the  report, Can you point out what is the bug OR any enhancement should be work on ?

Thanks,
Ranjith
- Visolve

4

bradymiller wrote on Tuesday, January 15, 2013:

Hi,
Pretty sure the “tagged” service codes are identified in Administration->Services->(‘Service Reporting’ toggled on) (note when hovering over this toggle box get ‘Service Code Finance Reporting’ title displayed) and are only used as filter when the ‘Important Codes’ toggle in the report is turne on.
-brady
OpenEMR

5

wjbaptis wrote on Tuesday, January 22, 2013:

Thanks everyone.

@ Ranjith - The issue happens when an invoice is created outside the To and From Payment dates. The report does not pick up that line item. But, if the invoice was created within the To and From Payment dates, the item is shown.

6

wjbaptis wrote on Wednesday, January 30, 2013:

Morning Ranjith,

Were you able to reproduce this? Let me know if you need more information. Thanks - Will

7

visolveemr wrote on Thursday, January 31, 2013:

Hi Will,

Thanks for the patience.
Here the workflow of that report.

1 . Patient has two visits .(29-1-13,30-1-13)
2 . In the 29 th visit,patient billed with code1 - price:200 Units:2 -> patient paid -> 400

3.  In the 30th visit,patient billed with same code1 - price:200 units:4 -> Patient paid > 800

4. Now in the Financial Summary by Service Code report, if you search that code From : 29-1-13 To : 30-1-13,
   The result should be ,** Units: 6**  Amt Billed: 1200 Paid Amt: 1200 Balance Amt: 0

5. If you search that code from 30-1-13 To: 31-1-13,
   The result should be , Units: 4  Amt Billed: 800 Paid Amt: 800 Balance Amt: 0

If this is not expected, let us know whats the expected behavior of that report.?

Thanks,
Ranjith
www.visolve.com

8

wjbaptis wrote on Thursday, January 31, 2013:

Hi Ranjith.

Thanks for you reply. Your results are correct for your example. Let me modify it a little. Suppose on the 30th encounter, the patient only paid $200 instead of $800. Then, on 1-2-13 (Feb 1, 2013), they paid the additional balance of $600. If I do a search for 1-2-13 to 1-2-13, the report won’t pick up the $600. Looks like it’s because the search is outside the visit date. Should the report pickup all payments in the search criteria regardless of the visit date? Thanks for any insight. - Will

9

visolveemr wrote on Thursday, January 31, 2013:

Hi Will,

Thanks for Pointing out the Issue. Now i could able to reproduce that issue.
Will fix this issue ASAP and circulate the same.

Thanks,
Ranjith
www.visolve.com

10

visolveemr wrote on Friday, February 01, 2013:

Hi Will,

As per your scenario,
"

Suppose on the 30th encounter, the patient only paid $200 instead of $800. Then, on 1-2-13 (Feb 1, 2013), they paid the additional balance of $600. "

Actually This** “From” and  “To”  date meant for DOS**.  IF we need the result as you expected, we need to use “Payment Post Date” for this “From” and “To”.

So, If we paid the remaining balance on next visit (using Batch payments), it will paid for initial DOS only. As of now We are not filtering the report by date of payment posting.

AS per the design, there is no issues (i believe), If  the “Filter Date” needs  to be the “payment Posting Date” , then we can change the filter accordingly.

Share your suggestions to make this report more efficient !

Note: while posting the payment / invoice after the visit using “Fee->Payments”, pay in to the appropriate visit(old Visit). Else payment will go without proper Code.

Thanks,
Ranjith
www.visolve.com

11

wjbaptis wrote on Friday, February 01, 2013:

Thanks Ranjith for looking into this. It’s a great report. As an enhancement, is it possible to give users an option to group the paid amt by (Month, Quarter, or Year). Sort of like pivot tables using Payment date. As for example, I enter a search date of Jan 01, 2012 to July 31, 2012. Then from a drop down list, I choose to see payments grouped by Month. The report can show additional columns  Jan 2012, Feb 2012, …  with the sum of all payments received during that period. Let me know if you need more clarification. Thanks.

12

juggernautsei wrote on Wednesday, December 03, 2014:

Hello Tony / Visolve(Ranjith),

did this feature get updated? If so, is there code posted anywhere?

13

tmccormi wrote on Monday, January 05, 2015:

No changes have been made to this feature recently.

Tony McCormick

–
Please be aware that e-mail communication can be intercepted in
transmission or misdirected. Please consider communicating any sensitive
information by telephone. The information contained in this message may be
privileged and confidential. If you are NOT the intended recipient, please
notify the sender immediately with a copy to hipaa-security@mrsb-ltd.com and
destroy this message.