Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
July 25, 2022
Question

pending invoice report

  • July 25, 2022
  • 1 reply
  • 23 views

I have created a pending invoice report. Partial payments have been applied but the report shows the total balance owed (ex: billed $1,000 - payment $500.00 ... report shows $1,000)

How can I produce a report that shows the billed and payment amounts?

Hope that makes sense

1 reply

Level 5
July 25, 2022

Yes, it does, @Catz. Thank you for sharing details about your concern with the invoice report.

 

I can guide you through the correct report so you can access the desired pending invoice data.

 

You can run the Customer Balance Detail report and have it customized. As a result, the Amount Paid column will be displayed. Here's how you can do it:

 

1. In your QuickBooks Desktop, open the Reports menu.

2. Click on Customer & Receivables and select Customer Balance Detail.

 

 

3. Go to the Customize Report button.

 

 

4. Under the Column section, search for Amount Paid and put a check beside it. Once done, click on OK.

 

 

You should be getting this view on the report by then.

 

 

I'm also adding this module about the different ways of handling customer transactions in QBDT: Get started with customer transaction workflows in QuickBooks Desktop.


Please let us know if you have other customer-related concerns. You can also include queries about your QuickBooks Desktop. We're here to assist you always. Have a great start of the week!

CatzAuthor
July 25, 2022

Actually, that doesn't work for me ... when you apply a payment to a pending invoice - it's like there's no payment applied at all - the payment is a separate line item and if you look at the invoice the payment is not even applied - it's held until it's made into a final invoice and then it's applied - so reports are skued.

CatzAuthor
July 25, 2022

This is the type of report I'm looking for - see attached