Skip to main content
C
CourtneyF1
June 26, 2024
Question

AR Payment Application Report

  • June 26, 2024
  • 1 reply
  • 0 views

Hello!

We are trying to figure out how to pull a report that would show how we applied customer payments. For example, if a customer is asking us how we applied several payments, is there a way to pull a report that would show which invoices we applied the payment to?

 

Thank you!

1 reply

A
AileneA
June 26, 2024

We can pull up the Transaction List by Customer Report, CourtneyF1.

 

This report provides a comprehensive view of all transactions related to a specific customer, including payments, deposits, and other associated transactions. I would be delighted to assist you in customizing this report according to your specific needs.

 

Here's how:

 

  1. Select Reports from the top menu bar.
  2. Click Customers & Receivables and select Transaction List by Customer.
  3. Click the Customize Report button.
  4. In the Display tab, set the appropriate reporting date under the REPORT DATE RANGE section.
  5. In the Filters tab, select Transaction Type from the FILTER menu.
  6. Choose Multiple Transaction Types from the Transaction Type drop-down menu.
  7. From the pop-up window, select Invoice and Payment, then click OK.
  8. Click OK again to complete the process.

 

To determine which invoice the payments were applied to, you can double-click on the payment transactions. This action will allow you to view the details and trace the specific invoice to which the payment was allocated.

 

 

Alternatively, you can open each of your invoices to view the associated payments. Let me walk you through the process:

 

  1. Go to the Customers tab, then click on Customer Center.
  2. Click on the Transaction column beside Customer & Jobs.
  3. Select Invoices to open each invoice.
  4. Click on the Transaction column to see the payment link on your invoice.
  5. Repeat the same steps for other entries. 

 

 

 

 

To preserve the current customization settings of this report, I recommend memorizing it. This way, you can easily access and utilize the report with its preferred settings whenever needed.

 

I also recommend reading this article. It will guide you in effectively tracking your business's progress. You can find valuable insights and instructions on customizing company and financial reports to suit your specific needs.

 

If you have additional questions about running a report, don't hesitate to come back here in the Community. I'll be willing to help. Have a good one.

C
CourtneyF1Author
June 27, 2024

Thank you, we were looking for a step further here. We had a customer request how payments were applied from January 2024 to present and had to manually put an excel sheet together to show them how we applied payment. The steps you gave are helpful but it seems we would still need to put the information manually into excel to show how we applied the payments. The first report you provided we could pull into Excel but it won't specifically show the payment for $100 was applied to invoices 1, 2, and 3.

 

Any other ideas for this level of detail to show on an excel report?

A
AbegailS_
June 27, 2024

Welcome back to the Community, CourtneyF1.

 

I can see the importance of running a report for your customer to demonstrate how payments were applied.

 

Currently, this kind of report is unavailable. In the meantime, I recommend sending this request straight to our product engineers through feedback. Sharing features and options that you would like implemented is how our engineers look for new product updates.

 

Here's how:

  1. Go to the Help menu in your company file.
  2. Select Send Feedback Online and choose Product Suggestion.
  3. Click the Type of Feedback drop-down arrow and select Product Suggestion.
  4. Choose Reports in the Product Area.
  5. You can then add brief information in the box.
  6. Enter your name and e-mail address.
  7. Then, click the Send Feedback button.

 

For additional reference about managing reports in QuickBooks Desktop, check the following articles:

 

 

If you have any further concerns about running reports, please post them again in this thread. Our QuickBooks Community team and other QuickBooks experts are always here to help. Have a good one.

Terms & ConditionsAccessibility statement