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

customer payments in check register do not match cash basis P&L statement


Apparently the issue is that I have not matched all of the customer payments to invoices.   I have multiple years of accounting to straighten out and I am boggled with the chore of doing so.

Question:  Can I delete invoices that are either partially and/or incorrectly matched to customer payments and create new ones to clean up this mess.  How much work will it be to match the customer payments after this re-jiggering.  Yes, my checking accts are fully reconciled.

       I had thought that if a payment was matched to customer/job and that accounting was cash basis that the payment would register as income whether there was an invoice or not.  Apparently not  Also I have orphan invoices that were supersed by others which were then paid.

      I assume also now that the income (still cash basis) is registered at the date of the invoice.

      Thanks in advance for any help or suggestions.

4 Comments 4
MJoy_D
Moderator

customer payments in check register do not match cash basis P&L statement

Hello, @handrailer

 

If you’re in a cash basis accounting, it’ll only be reported as income and expense once you’ve received the payment or paid the bill.

 

Yes, you can delete an invoice. However, removing it will cause the payments to be unapplied.

 

Here’s how to delete an invoice in QuickBooks Desktop (QBDT):

  1.  Go to your Customer Center from the Customers menu.
  2. Look for that customer and double-click the invoice to open it.
  3. Select the Edit button at the top.
  4. Click on Delete and then OK to confirm.

Once done, you can now recreate an invoice then match it to the payment. Here’s how to create an invoice in QuickBooks Desktop and on how to record an invoice payment.

 

Check these articles for more information:

Let me know if you need further help or assistance. I’m always glad to help in any way I can. Have a wonderful day!

handrailer
Level 1

customer payments in check register do not match cash basis P&L statement

What shocked me is that I had "received payments" but they did not show up on the cash basis P&L report.  As a matter of fact, when I totalled a particular years customer payments from my reconciled Q-Books checking account register  (all entered as a customer "received payment") I came up with a total that was about 16,000 less than the amount shown with the cash basis P&L.  

     Am I correct in assuming the discrepancy is all based in this linkage of payments to invoices.? I had assumed that this issue would only be a concern with accrual.

handrailer
Level 1

customer payments in check register do not match cash basis P&L statement

I found this.  No I didn't.     :-)

        Nope doesn't relate

ReymondO
QuickBooks Team

customer payments in check register do not match cash basis P&L statement

Thanks for getting back to us, @handrailer.

 

It could be that the linked payments to your invoice are the reason why there's a discrepancy in the Profit & Loss (P&L) report. It's also possible that there are dates that weren't included in this report. This can be the reason why some of the receive payments don't show in the P&L report. 

 

I recommend reaching out to our Customer Support Team so they can check your P&L report to trace where this discrepancy is coming from. Here's how to connect with us:

 

  1. Select Help (?) at the top right.
  2. Click the Contact Us button.
  3. Enter your concern in the description.
  4. Hit Let's talk.
  5. Select Get a callback.

 

For more contact details, you can visit our support website.

 

Please reach out if there's anything else I can do to help. Just click the reply button below so I can provide you further assistance.

Need to get in touch?

Contact us