cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Super Explorer ***

unapplied cash bill payment expense issue

I understand what unapplied cash bill payment is but cant figure out why it's showing as unapplied in this case. Also, my p/l for this customer/project is understated bc the expense seems to be counting the expense twice.

 

Context: An expense was initially created to reflect the payment. Later on, we created a bill (we want to see it this way) and then applied the expense as payment to the bill.

 

I have attached the screenshot of the:

Bill

Expense

Bill payment showing expense and bill

Project report showing the payment counting twice. (the unapplied cash bill payment expense includes the guaranteed payment shown separately)

 

NOTE I couldnt save as 1file so attached is the first set of screenshots and I'll add the second to a reply

We'd greatly appreciate any help in clarifying what we're doing wrong.

 

Solved
Best answer 04-12-2019

Accepted Solutions
QuickBooks Team

Re: unapplied cash bill payment expense issue

Hello there, haskenazi1.

 

I greatly appreciate the detailed information and screenshot you provided. Let's get this sorted out.

 

Base on the screenshot you provided, both Bill and Expense are attached to the project. Attaching both transactions causes the duplication. With that, only the Bill should be attached to the project and you'll need to remove the project from the Expense transaction.

 

Here's how to do it:

  1. Click Expenses on the left menu.
  2. Choose Vendors tab.
  3. Select the Vendor.
  4. Locate the Expense transaction and click View/Edit.
  5. Under Customer/Project, click the drop-down and remove the project attached to it.
  6. Click Save and close.

 

I'll leave you with an article to know more about editing an expense in QBO: How to enter, edit, or delete expenses.

 

That should point you to the right direction. If I can assist you with anything else or additional questions about managing unapplied cash bill payment, feel free to leave me a reply.

11 Comments
Super Explorer ***

Re: unapplied cash bill payment expense issue

This is the second set of screenshots related to the original post

QuickBooks Team

Re: unapplied cash bill payment expense issue

Hey @haskenazi1,

 

Thank you for providing me a detailed explanation of your concerns, and for providing some handy screenshots.

 

You can delete either the Bill Payment or Expense made to avoid duplication. I can provide some details and help you further.

 

When paying for a bill, you can either create a Check, Expense, or you can use the Pay Bills feature. In your case, you've created an expense and applied it to a bill.

 

Then you created another bill payment, which duplicated the payments to the bill. One payment showed as an unapplied cash bill payment because of this.

 

To fix this, you can delete either the expense you've made or the bill.

 

Here's how you can delete the expense:

  1. On the left panel, click on Expenses, then choose Vendors.
  2. Select the vendor, then click on Transaction List.
  3. Click on the expense you've made.
  4. Click on More, then select Delete.

If you want to delete the bill payment, you may follow these steps:

  1. From the vendor Transaction List, select the Bill Payment.
  2. Click on More.
  3. Select Delete.

That's it! Your payments won't be counted twice.

 

Please let me know if you have any other concerns. I'll be around to help.

Super Explorer ***

Re: unapplied cash bill payment expense issue

THanks for your reply. Before I delete anything I should mention that this is all for a period already reconciled in Jan 2018 and my books are reconciled as of Feb 2019. When I go to reconcile now, I see the beginning balance is accurate. So if I delete the expense, won't that make the beginning balance not accurate? Meaning, this is not an issue of a duplicate transaction otherwise I wouldn't be able to reconcile?

Established Community Backer ***

Re: unapplied cash bill payment expense issue

I can't see the screenshot

What account did you use in the CATEGORY column of the expense transaction?

And what is the date of the expense transaction, and the bill

Super Explorer ***

Re: unapplied cash bill payment expense issue

@Malcolm Ziman  Good questions - I thought the date may be the issue but wasn;t sure

 

Account in Expense is Accounts Payable and date of expense is 02/06/18

 

Bill date is 01/12/18 and Due Date is 01/22/18

 

Bill Payment Date is 02/06/18 and it is a zero amount bc the expense pays the bill 

 

Not sure if this could explain the issue, but while the expense is zero, the amount in the payment field for the bill and the expense in the bill pay screen are both the full amount of the payment. Should one be zero? Dont think so but...

 

Thanks for your help

QuickBooks Team

Re: unapplied cash bill payment expense issue

Hello there, haskenazi1.

 

I greatly appreciate the detailed information and screenshot you provided. Let's get this sorted out.

 

Base on the screenshot you provided, both Bill and Expense are attached to the project. Attaching both transactions causes the duplication. With that, only the Bill should be attached to the project and you'll need to remove the project from the Expense transaction.

 

Here's how to do it:

  1. Click Expenses on the left menu.
  2. Choose Vendors tab.
  3. Select the Vendor.
  4. Locate the Expense transaction and click View/Edit.
  5. Under Customer/Project, click the drop-down and remove the project attached to it.
  6. Click Save and close.

 

I'll leave you with an article to know more about editing an expense in QBO: How to enter, edit, or delete expenses.

 

That should point you to the right direction. If I can assist you with anything else or additional questions about managing unapplied cash bill payment, feel free to leave me a reply.

Super Explorer ***

Re: unapplied cash bill payment expense issue

Ah so this is a design issue and not an actual duplicate transaction amount? So if I remove from the project, the transaction won't appear twice in my p/l statement? 

 

That makes a lot of sense bc I did just add the project to that expense this morning before this all happened. Though seems odd that if it's only counted once on the books, that it would count it twice in the project report.

 

Thank you!

Established Community Backer ***

Re: unapplied cash bill payment expense issue


@haskenazi1 wrote:

@Malcolm Ziman  Good questions - I thought the date may be the issue but wasn;t sure

 

Account in Expense is Accounts Payable and date of expense is 02/06/18

 

Bill date is 01/12/18 and Due Date is 01/22/18

 

Bill Payment Date is 02/06/18 and it is a zero amount bc the expense pays the bill 

 

Not sure if this could explain the issue, but while the expense is zero, the amount in the payment field for the bill and the expense in the bill pay screen are both the full amount of the payment. Should one be zero? Dont think so but...

 

Thanks for your help


Given that the Bill is dated before the payment, there is no unapplied cash bill payment expense.  Where do you see it? Cash basis P&L? What time period?

Super Explorer ***

Re: unapplied cash bill payment expense issue

Cash Basis P/l by customer ALL dates with filter for select customers/

 

The bigger issue - though possibly related - is that the expense is being counted twice.

 

Someone else suggested this is only counted twice in the project report I had attached in one of the screenshots and not actually counting twice on my books. Would be odd if that were the case but would at least explain why I can't figure out what's going on when e/t seems to be done correctly

Super Explorer ***

Re: unapplied cash bill payment expense issue

Upon reflection, if the other poster is correct that the project is counting the expense and bill as separate transactions, then that does in fact explain why it's also counting one of them as unapplied. Bc there is really only one payment for one bill, but the project report is seeing 2 transactions for 1 bill. Definitely a design flaw that should be fixed.

Moderator

Re: unapplied cash bill payment expense issue

Hello haskenazi1,

 

Jumping in this thread to provide additional information.

 

The Profit and Loss by Customer report only shows the actual company's revenues (invoices, sales receipts, income, etc.) and expenses (checks, bill payments, etc.) per customer/job. Unpaid bills are posted in the Balance Sheet report. Once the bills are paid (Bill Payment), they will be removed in the Balance Sheet report and will be posted in the Profit and Loss report. 

 

For any reports for Projects, the system doesn't count two transactions if the expense is linked to the bill (enter a bill, then click on the Bill Pay to pay it).

 

You might want to run the A/P detail report to see which bills aren't paid yet. Unlinked expenses to the bills might be the reason why the report showing multiple transactions.

 

Have a great day!

Need to get in touch?

Contact us