# A/R report Ins Co vs Patient **URL:** \ **Category:** Day-to-Day Users\ **Created:** [August 12, 2019, 3:54pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611 "2019-08-12T15:54:19Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![rmagauran](https://community.open-emr.org/user_avatar/community.open-emr.org/rmagauran/32/11435_2.png) [@rmagauran](https://community.open-emr.org/u/rmagauran)\ **Post date:** [August 12, 2019, 3:54pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/1 "2019-08-12T15:54:19Z")
I received this today from my billers: > I am printing up the month end report and the A/R report. I noticed that there is almost nothing on the insurance A/R report. Was there a system update? It looks as though all of the balances that are billed out to the insurances are now assigned to the patient as their responsibility. The A/R report only shows the most recent claims that have been billed. I will hold off on printing the patient statements for the time being. Hopefully there is a quick and easy remedy for this. Anybody know why this would happen? ---
**Author:** ![PeggyG](https://community.open-emr.org/letter_avatar_proxy/v4/letter/p/e0b2c6/32.png) [@PeggyG](https://community.open-emr.org/u/PeggyG)\ **Post date:** [August 15, 2019, 8:26pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/2 "2019-08-15T20:26:55Z")
We are having a similar issue. When running financial reports for “Due Insurance”, the report is coming up blank. We know this not to be right. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [August 15, 2019, 8:33pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/3 "2019-08-15T20:33:24Z")
hi @PeggyG, what OpenEMR version? thank you ---
**Author:** ![PeggyG](https://community.open-emr.org/letter_avatar_proxy/v4/letter/p/e0b2c6/32.png) [@PeggyG](https://community.open-emr.org/u/PeggyG)\ **Post date:** [August 15, 2019, 8:39pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/4 "2019-08-15T20:39:04Z")
Currently on 5.0.1 and planning to do update friday. You are familiar with my husband, Jeff Guillory, I believe. I have seen your name on the forums. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [August 15, 2019, 8:44pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/5 "2019-08-15T20:44:19Z")
hi, of course @nursejeff 🙂 , haven’t seen this issue on 5.0.1, is it 5.0.1 (7) for patch 7? ---
**Author:** ![PeggyG](https://community.open-emr.org/letter_avatar_proxy/v4/letter/p/e0b2c6/32.png) [@PeggyG](https://community.open-emr.org/u/PeggyG)\ **Post date:** [August 15, 2019, 9:00pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/6 "2019-08-15T21:00:26Z")
yes, 5.0o.1(7) patch 7 ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [August 15, 2019, 11:24pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/7 "2019-08-15T23:24:06Z")
hi @PeggyG, do you choose any of the other columns or change the settings besides choosing ‘Due Ins’ before you run the report? ---
**Author:** ![PeggyG](https://community.open-emr.org/letter_avatar_proxy/v4/letter/p/e0b2c6/32.png) [@PeggyG](https://community.open-emr.org/u/PeggyG)\ **Post date:** [August 16, 2019, 3:29pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/8 "2019-08-16T15:29:30Z")
Yes,. I populate the Location, provider, aging column, date values. ---
**Author:** ![PeggyG](https://community.open-emr.org/letter_avatar_proxy/v4/letter/p/e0b2c6/32.png) [@PeggyG](https://community.open-emr.org/u/PeggyG)\ **Post date:** [August 16, 2019, 5:09pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/9 "2019-08-16T17:09:35Z")
Tried to send a screen print of the issue. Since I am a “new member” attachments are not allowed. It is pulling thru anything after July 1, but not the prior. PeggG ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [August 16, 2019, 11:31pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/10 "2019-08-16T23:31:04Z")
thanks @PeggyG, will check out those other variables to see if something is up ps you should be able to upload a file with the up arrow icon on the top of the reply box but there’s no need to send me anything for now ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [August 21, 2019, 7:46pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/11 "2019-08-21T19:46:08Z")
not able to reproduce on 5.0.1(7) by Location do you mean Facility? can you run it without choosing a facility by leaving it `-- All Facilities --` ---
**Author:** ![PeggyG](https://community.open-emr.org/letter_avatar_proxy/v4/letter/p/e0b2c6/32.png) [@PeggyG](https://community.open-emr.org/u/PeggyG)\ **Post date:** [August 21, 2019, 8:42pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/12 "2019-08-21T20:42:34Z")
I can leave all options open except date span and it still only gives me July and August as outstanding. which I know is not true. Peggy ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [August 21, 2019, 8:54pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/13 "2019-08-21T20:54:53Z")
what if you leave the date open? ---
**Author:** ![PeggyG](https://community.open-emr.org/letter_avatar_proxy/v4/letter/p/e0b2c6/32.png) [@PeggyG](https://community.open-emr.org/u/PeggyG)\ **Post date:** [August 21, 2019, 9:05pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/14 "2019-08-21T21:05:17Z")
If I leave the dates open, the same results are achieved. Peggy ---
**Author:** ![rmagauran](https://community.open-emr.org/user_avatar/community.open-emr.org/rmagauran/32/11435_2.png) [@rmagauran](https://community.open-emr.org/u/rmagauran)\ **Post date:** [August 21, 2019, 9:30pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/15 "2019-08-21T21:30:37Z")
Ola Peggy, I have the same issue still, and I just completed a completely flawless upgrade to 5.0.2 on an ubuntu box. 5.0.2 is a gem indeed but this problem is not fixed. No matter how the report is run here, the oldest Ins Due claim is 6/12/19. ~~Now when I replace the 5.0.2 file: openemr/interface/reports/collections\_report.php with the older version from a random 5.0.1 branch lying around, the bug disappears!~~ ---
**Author:** ![sjpadgett](https://community.open-emr.org/user_avatar/community.open-emr.org/sjpadgett/32/21623_2.png) [@sjpadgett](https://community.open-emr.org/u/sjpadgett)\ **Post date:** [August 21, 2019, 10:15pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/16 "2019-08-21T22:15:54Z")
On v502 goto globals and turn on User Debug in Logging. log out then in, run report and see if any errors show up… ---
**Author:** ![rmagauran](https://community.open-emr.org/user_avatar/community.open-emr.org/rmagauran/32/11435_2.png) [@rmagauran](https://community.open-emr.org/u/rmagauran)\ **Post date:** [August 22, 2019, 11:18am UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/17 "2019-08-22T11:18:49Z")
Is it possible that an inexperienced biller went through the claims and manually flagged them as “Done with Insurance 1”. What is the flag in the DB to note this? Is it the field “billing process” in the table “billing”? ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [August 22, 2019, 12:41pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/18 "2019-08-22T12:41:05Z")
hi @rmagauran, think so, from [Jerry’s work](https://github.com/openemr/openemr/pull/2585#issuecomment-515723910) ---
**Author:** ![sjpadgett](https://community.open-emr.org/user_avatar/community.open-emr.org/sjpadgett/32/21623_2.png) [@sjpadgett](https://community.open-emr.org/u/sjpadgett)\ **Post date:** [August 22, 2019, 1:55pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/19 "2019-08-22T13:55:13Z")
Hi All, Maybe someone can tell me what the practical use for Clear might be in production biling. Is this an option that we should get rid of? Currently Clear will reset the claim status to billed and reset claims bill process to the beginning i.e claim has not been submitted. The fee sheet status is left untouched. Why would there be a need to do this!!! ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [August 22, 2019, 2:10pm UTC](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611/20 "2019-08-22T14:10:08Z")
say you bill a claim to an insurer and it’s denied because they need more time to fix an eligibility issue so they say submit the claim a week from now [Next page](https://community.open-emr.org/t/a-r-report-ins-co-vs-patient/12611.md?page=2)