Usual culprit is timing. Were the payments entered prior to the bills? Were the payments regular checks or bill pay checks? Can you clear them by toggling between accrual and cash on the report?
Some of them definitely are a timing issue. Most are not. And yes, If I change the report to accrual, they disappear.
My experience with this situation has never led to a fix. The issue does not exist in desktop versions but are you using Class Tracking and missing Class designations on some of the affected transactions?
Here is the QBO help article which of course gives little in how to fix it other than saying it may be correct. https://quickbooks.intuit.com/community/Help-Articles/What-s-Unapplied-Cash-Payment/m-p/185755
Life is too short, leave it for your tax CPA, that's why they get the big bucks, lol
This issue is most definitely an QBO problem as this didn't happen prior to the "upgrade".
We do not use class tracking for expenses or income.
I appreciate the advice to leave it to my accountant, but this was one reason I was hired (to straighten out the problems.) Oh well! :0(
The "problem" of unapplied cash payments has been around since I have been using QBO. An upgrade may have exasperated the issue and included transactions that should in no way be included. If none of the short list of situations in the article apply then by all means escalate this into a bug report. Gear icon>Profile (far right)>Feedback. It is about the only way the software engineers are made aware of things that go bump in the night
I appreciate all your input.
We operate on an accrual basis anyway, so I could just ignore what shows up on the rare occasions I run a cash basis P&L.
It's just my nature to want to see nice clean reports that actually reflect what's going on in our books.
Would the due date of the bill have anything to do with this?
On most of the entries, the bill date is before the payment date, but the due date on the bill is almost always after the payment date.
In addition to @john-pero's answer, the due date has nothing to do with the unapplied cash bill payments in the report. Just make sure to apply the bill payment to a bill that is dated before the bill payment. I'll walk you through how.
You can read the details about the report in this article: What's Unapplied Cash Payment?
I've also added these articles for your reference:
If you have other questions in mind, please don't hesitate to reach out anytime.