Skip to main content
SvitlanaP
Sep 24, 2021 2:23 PM UTC
Question

Invoices and received payments

Hello,

 

lets assume that customer pays 100 USD that covers open balances of several outstanding invoices. Which report can show how this amount of 100 USD was spread between invoices. Invoices and Received Payments report shows payment and original invoice amount not the settlement amount. 

 

Thank you. 

 

24 replies

AlexV
AlexV
Sep 24, 2021 4:13 PM UTC

Hi SvitlanaP!

 

Thanks for posting again here. Let me help you in running the report you need.

 

When you run the Invoices and Received Payments report, click the small Gear icon next to the Export button. Then, add the A/R Paid column by checking it. This allows you to see if the invoice is fully paid or not. If not, you can click the transaction to see how much payment is applied to it.

 

You can also create a customer statement in QuickBooks Online. This will list all the transactions with the settlement amount.

 

I added some links you can check. These will list all available reports in QuickBooks Online and how to customize them:

 

Comment below if you need more help. Take care!

Ohceilings1
Dec 28, 2024 6:35 PM UTC

Hello, I was suppoed to receive a call from the book keeping support but have not heard from them. 

SrTeM
Jan 21, 2022 12:08 AM UTC

How do I created this report in Quickbooks Enterprise Desktop?

AlcaeusF
AlcaeusF
Jan 21, 2022 1:52 AM UTC

Hello @SrTeM,

 

Welcome to the Community. I'd be glad to help you create the report in QuickBooks Desktop Enterprise.

 

You can run the Customer Balance Detail report to show the details you need. Personalize the columns and filters to show the invoices and payments, as well as the specific filters.

 

Here's how:

 

  1. Click the Reports tab at the top menu bar.
  2. Hover your cursor to Customers & Receivables.
  3. Press Customize Report.
  4. Go to the Display tab.
  5. Choose the date range.
  6. Filter the columns. 
  7. Go to the Filters tab.
  8. Choose the transaction types you want to include in the report.
  9. Hit OK.

 

Additionally, I recommend visiting the following link to learn more about how you can track your sales using predefined reports in QuickBooks: Customize customer, job, and sales reports in QuickBooks Desktop.

 

Reach out to me if you need further assistance running the report in the Desktop version. I'll be happy to help you some more.

corneroffice
May 27, 2022 6:06 PM UTC

These instructions must be incorrect. I get a report that shows payments and invoices, but not which payment goes with which invoice(s).  Where is that information?

Kimisyntec
Jan 13, 2023 6:10 PM UTC

NONE of these answer the question.  It is a simple report, it shows the payment and what invoices that payment paid!  NOT by clicking on each payment and seeing the payment screen.  That is NOT helpful at all!

 

This is the most basic of reports I don't understand why it isn't anywhere!

Adrian_A
Adrian_A
Jan 13, 2023 7:28 PM UTC

 I know a report that shows the payment and its associated payment, Kimisyntec.

 

It isn't the kind of experience we want you to come across. We can run the Invoices and Received Payments report to show the mentioned details. Here's how:

 

  1. Click the Reports tab.
  2. Enter and select Invoices and Received Payments.
  3. Click the Customize button.
  4. On the Row/Column section, select Num and Amount.
  5. Hit Run report.

 

I've also added included this article if you want to pull up the report with the same customization: Create and access memorized reports.

 

I'm just a post-away to help with any of your concerns.

Kimisyntec
Jan 13, 2023 8:34 PM UTC

Hi Adrian

 

I am using QBs Enterprise, I believe your info below is for QBO?

 

Thanks

Terms & ConditionsAccessibility statement