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

Customer payment report showing invoices payment allocated to.

I started a new job where the gal before me was applying payments incorrectly over the past 3 years. Now I'm trying to collect on past due invoices that the customer is stating have already been paid. 

 

Is there a report I can run that will show what invoices were paid with a specific payment? In other words if we received check # 123 and it paid invoices A, B & C... is there a report that will break this out so I can do a v-lookup to the remittance the customer provided to see what/where payments were applied incorrectly? The only was I can see doing this is literally clicking on each invoice to see what payment was applied and over the course of 3+ years there are a lot of invoices!!

 

I'm using QuickBooks Enterprise 2019.

 

 

 

1 Comment
HoneyLynn_G
QuickBooks Team

Customer payment report showing invoices payment allocated to.

Hello there, @tracou96.

 

Thanks for providing detailed information about the report you need to run. I'm the right person to assist you today!

 

We don't have a report that will show what invoices were paid with a specific payment at this time. As a workaround, you can customize the Deposit Detail report.

 

Here's how:

  1. On the top menu, click Reports.
  2. Choose Banking.
  3. Select Deposit Detail.
    1.JPG
  4. Click the Customize Report tab.
  5. Go to the Filters tab.
  6. For Accounts, select Accounts Receivable.
  7. Click OK.
    2.JPG
  8. For Transaction Type, select Invoice and Payments.
  9. Click OKs.
    3.JPG
  10. Modify the date period and click Refresh.
    4.JPG

You can review the report to identify which are paid and not. That should keep you going today, @tracou96.

 

For additional reference about customizing reports, you can open the link.

 

Keep me posted on how these steps work out for you. I'll be here if you have other reports questions. Have a good one.