cancel
Showing results for 
Search instead for 
Did you mean: 
RCheney
Level 1

Unapplied Cash Bill Payment Expenses-Dates wont change

Hello Friends!

 

I have several transactions showing up in my Unapplied Cash Bill Payment Expense account. All the transactions are vendor credits and their associated deposits.   A different date shows on the P&L than on the individual vendor credit.  For example, the P&L will list a date of 11/15/22 for the vendor credit but when I open the individual transaction, the date will read as 11/1/22.  The report isn't showing the same date as the individual transaction.  All of the vendor credits are dated before their matching deposit but the P&L shows the vendor credits as dated the same day as their associated deposits.    Since each of these vendor credits has an associated deposit the total in this account is $0.  I don't think this is a case of incorrect dates or unmatched transactions.  How can I clear this up? Thanks for your input!

2 Comments 2
Rea_M
Moderator

Unapplied Cash Bill Payment Expenses-Dates wont change

Hello there, @RCheney.

 

Let's apply your bill payments to your bills dated before the bill payments so you can clear up your Unapplied Cash Bill Payment Expense account in QuickBooks Online (QBO) and keep your financial data accurate.

 

When you run a Profit and Loss report (using the cash method), and an account called Unapplied Cash Bill Payment Expense shows up, it's due to the following reasons:

 

  • bill payment for a vendor is recorded before entering the bills
  • if you entered bill payments without matching them to bills

 

To fix this, you'll need to apply the bill payment to a bill that is dated before the bill payment. Here's how:

 

  1. With the Profit and Loss report open, look for Unapplied Cash Bill Payment Expense.
  2. Select the total amount. Take note of the vendor and amount for each bill payment in the list.
  3. Go to the + New button.
  4. Select Pay bills.
  5. If you see bills matching the bill payments in the list, select the checkboxes next to them, then Save.
  6. If you don’t see a matching bill for one of your bill payments, create it.
  7. Repeat the steps for any bill payments left on the list.

 

Once you're done, go to the Reports menu and run your Profit and Loss report again. The Unapplied Cash Bill Payment Expense account should be removed from your report.

 

Once everything is all set, you may also want to check out one of our Help pages as your reference to guide you in managing vendors and expenses, paying bills, and writing checks using QBO: Expenses and vendors help for QuickBooks Online.

 

If you have other reporting concerns or questions about managing expense transactions in QBO, please don't hesitate to comment below. I'm always ready to help. Take care, and I wish you continued success@RCheney.

MarshaClark
Level 3

Unapplied Cash Bill Payment Expenses-Dates wont change

I paid several vendor invoices twice over a couple of months.  The vendor and I agreed to apply those payments to a later invoice.  I applied those payments (checks) to an invoice dated months later.  Now I have those credits in Unapplied Cash Bill Payment Expenses.  How do I clear those out?  And, how should I have applied those over payments to a new invoice to avoid items appearing in the unapplied cash account?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us