Question

pending invoice report

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

C

CatzAuthor

Thanks for getting back to this thread and for the screenshot you attached, @Catz.

In QuickBooks Desktop, you may generate a QuickReport of the Accounts Receivable. This will show invoices with partial payments on a specific date.

Here's how:

Proceed to the Lists tab.
Choose Chart of Accounts.
Select the Accounts Receivable.
Right-click your mouse, then click QuickReport: Accounts Receivable.
Select Customize Report.
From the Display tab, search and select the Paid and Open Balance.
Under the Filters tab, search the Transaction Type and choose Invoice.
From the Filters tab again, search the Paid Status and choose Open.
Add the specific data that you want to run a report.

You can also export other reports to an Excel file. From there, you can personalize to show the data you want. To learn more about running reports in QuickBooks Desktop, you can check this article: Understand reports.

I'm also attaching this link to help memorize reports in QuickBooks if you want the same settings of the customized statement to be available for future use: Create, access and modify memorized reports.

Keep me posted if you have further question about running pending invoice report in QuickBooks. I'll be around to help you. Stay safe!

Yeah, that's not what I need either

Sign up

Login with SSO

Let's get you signed in

Login with SSO