Question

pending invoice report

Forum|Forum|4 years ago
July 25, 2022
8 replies
39 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

QuickBooks Desktop

M

Mich_S

Level 5

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!

C

CatzAuthor

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.

M

mv32

Level 8

Yeah, that's not what I need either

Hi @Catz.

Thanks for providing the screenshot to point us about what you need specifically to see on a report.

I already pulled up three reports for this and customized them, namely: Open Invoices, Customer Balance Detail, and Transaction List by Customer report. I get the columns to show in each report. However, the payments from the Amount Paid column doesn't seem to indicate the amounts.

In this case, I recommend submitting feedback online and let's consider it as product suggestion since the Amount Paid column is empty or 0 after payments has been received. Here's how:

Go to the Help menu and then select Send Feedback Online.
Select Product Suggestion.
Enter your feedback and details.
Hit Send Feedback.

Furthermore, you can check the articles shared by my colleagues, including the Customize reports in QuickBooks Desktop to show specific targets on report. And how to memorize them, so you won't have to recreate them moving forward.

Please comment here if you have additional questions about running specific reports. I'm always delighted to help you more. Take care always!

Sign up

Login with SSO

Let's get you signed in

Login with SSO