Billing not adding up

juggernautsei wrote on Friday, October 12, 2012:

Hi,

We have an issue with billing. I have done alot of searching and can’t really come up with a good answer for the delima.
Ok, Patient is showing a Balance Due of $515.34 in the demograpichs. However, when we go over to Fees > Billing > EOBs and put in the patien ID and run all report. The balance due is $309.54. I have traced that both the patient demographics and the sl_eob_search are using the same function get_balance from the patient_inc.php file.

If they are both using the same function, how can they total different amounts is my first question.

The next thing I did was to copy and paste the list of charges from the EOB report to a spread sheet and make sure it added up. See below. I got a balance that was not the either!  So, my next question is how is it doing the math cause I am not getting what the system is saying is the balance.

We are using 4.1.0 patch 11 on a WAMP stack. I will gladly take any suggestions.

2012-03-16 Procedure 93458:26 457.00         457
Adj 2012-04-19: Ins adjust Ins1 MEDICARE P -305.81        -305.81
Note 2012-04-19: Deductable $30.24 MEDICARE P
Paid 2012-04-19: 886042758 MEDICARE P -120.95                           -120.95
2012-03-16 Procedure 36252:59 500.00          500
Adj 2012-04-19: Ins adjust Ins1 MEDICARE P -145.93        -145.93
Note 2012-04-19: Deductable $70.81 MEDICARE P
Paid 2012-04-19: 886042758 MEDICARE P -283.26        -283.26
2012-03-16 Procedure 93306:26 59 250.00         250
Adj 2012-04-19: Ins adjust Ins1 MEDICARE P -186.13        -186.13
Note 2012-04-19: Deductable $12.77 MEDICARE P
Paid 2012-04-19: 886042758 MEDICARE P -51.10          51.1
2012-03-16 Procedure 99223:25 AI 286.00          286
Adj 2012-04-19: Ins adjust Ins1 MEDICARE P -94.52                                   -94.52
Note 2012-04-19: Deductable $38.30 MEDICARE P
Paid 2012-04-19: 886042758 MEDICARE P -153.18        -153.18
2012-03-17 Procedure 99232 103.00         103
Adj 2012-04-18: Ins adjust Ins1 MEDICARE P -34.41        -34.41
Paid 2012-04-18: 886041093 MEDICARE P -54.87                           -54.87
2012-03-19 Procedure 99233 148.00         148
Adj 2012-04-18: Ins adjust Ins1 MEDICARE P -49.67        -49.67
Paid 2012-04-18: 886041093 MEDICARE P -78.66                           -78.66
Paid 2012-10-10: Visa 040426 -15.00                           -15
2012-03-21 Procedure 99232 103.00         103
Adj 2012-04-18: Ins adjust Ins1 MEDICARE P -34.41        -34.41
Paid 2012-04-18: 886041093 MEDICARE P -54.87                           -54.87
2012-03-22 Procedure 99232 103.00         103
Adj 2012-04-18: Ins adjust Ins1 MEDICARE P -34.41        -34.41
Paid 2012-04-18: 886041093 MEDICARE P -54.87        -54.87
2012-03-23 Procedure 99232 103.00         103
Adj 2012-04-18: Ins adjust Ins1 MEDICARE P -34.41          34.41
Paid 2012-04-18: 886041093 MEDICARE P -54.87                            -54.87
2012-03-24 Procedure 99232 103.00          103
Adj 2012-04-18: Ins adjust Ins1 MEDICARE P -34.41        -34.41
Paid 2012-04-18: 886041093 MEDICARE P -54.87                           -54.87
2012-03-25 Procedure 99232 103.00         103
Adj 2012-04-18: Ins adjust Ins1 MEDICARE P -34.41        -34.41
Paid 2012-04-18: 886041093 MEDICARE P -54.87                           -54.87
2012-03-26 Procedure 99232 103.00         103
Adj 2012-04-18: Ins adjust Ins1 MEDICARE P -34.41        -34.41
Paid 2012-04-18: 886041093 MEDICARE P -54.87        -54.87
2012-03-27 Procedure 99232 103.00         103
Adj 2012-05-01: Ins adjust Ins1 MEDICARE P -34.41        -34.41
Note 2012-05-01: Deductable $13.72 MEDICARE P
Paid 2012-05-01: 886057594 MEDICARE P -54.87        -54.87
2012-03-28 Procedure 99232 103.00         103
Adj 2012-04-18: Ins adjust Ins1 MEDICARE P -34.41        -34.41
Paid 2012-04-18: 886041093 MEDICARE P -54.87                           -54.87
2012-04-26 Office Visit 98.00                             98
Adj 2012-05-16: Ins adjust Ins1 MEDICARE P -28.99        -28.99
Note 2012-05-16: Deductable $13.80 MEDICARE P
Paid 2012-05-16: 886080316 MEDICARE P -55.21                            -55.21
2012-04-26 Procedure 93010 13.25         13.25
Adj 2012-06-19: Ins adjust Ins1 MEDICARE P -4.89        -4.89
Note 2012-06-19: Deductable $1.67 MEDICARE P
Paid 2012-06-19: 886126410 MEDICARE P -6.69                            -6.69
2012-06-21 Office Visit 98.00                              98
Adj 2012-07-13: Ins adjust Ins1 MEDICARE P -28.99         -28.99
Note 2012-07-13: Deductable $13.80 MEDICARE P
Paid 2012-07-13: 8861682428 MEDICARE P -55.21                            -55.21
2012-06-21 Procedure G8553 0.01                              0.01
Adj 2012-07-13: Ins adjust Ins1 MEDICARE P -0.01          -0.01
480.56

juggernautsei wrote on Monday, October 15, 2012:

Ignore this as it is being. This problem is fixed in the 4.1.