cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Why are "Unapplied Cash Bill Payment Expense" on my P&L report? All of them have been applied to a bill and none are the result of not being "matched".

 
8 Comments
Level 12

Re: Why are "Unapplied Cash Bill Payment Expense" on my P&L report? All of them have been applied to a bill and none are the result of not being "matched".

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?

Level 2

Re: Why are "Unapplied Cash Bill Payment Expense" on my P&L report? All of them have been applied to a bill and none are the result of not being "matched".

Some of them definitely are a timing issue. Most are not. And yes, If I change the report to accrual, they disappear.

Level 12

Re: Why are "Unapplied Cash Bill Payment Expense" on my P&L report? All of them have been applied to a bill and none are the result of not being "matched".

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

Level 2

Re: Why are "Unapplied Cash Bill Payment Expense" on my P&L report? All of them have been applied to a bill and none are the result of not being "matched".

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(

Level 12

Re: Why are "Unapplied Cash Bill Payment Expense" on my P&L report? All of them have been applied to a bill and none are the result of not being "matched".

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

Level 2

Re: Why are "Unapplied Cash Bill Payment Expense" on my P&L report? All of them have been applied to a bill and none are the result of not being "matched".

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.

Level 2

Re: Why are "Unapplied Cash Bill Payment Expense" on my P&L report? All of them have been applied to a bill and none are the result of not being "matched".

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.

QuickBooks Team

Re: Why are "Unapplied Cash Bill Payment Expense" on my P&L report? All of them have been app...

Hi teverhart26,

 

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.

 

  1. Click the Plus icon (+). Then, click Pay Bills.
  2. If you see bills matching the bill payments in the list, click the checkboxes next to them, then Save.
  3. If you don’t see a matching bill for one of your bill payments, create it:
    • Select the Plus icon (+) on the Toolbar, then select Bill.
    • Fill out the form with the same vendor, amount, and date as the bill payment.
    • Select Save.
  4. Repeat the steps for any bill payments left on the list.

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.

Need to get in touch?

Contact us