United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tracou96
Level 1
posted
‎April 24, 2019 07:26 AM
last updated ‎April 23, 2019 2:26 PM

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.

 

 

 

Reply
1 Comment 1
HoneyLynn_G
QuickBooks Team
QuickBooks Team
‎April 24, 2019 10:03 AM

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.

Reply