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