Report showing Invoices Paid

Let's run a Transaction List by Customer report, @kshankman.

This report displays all the transactions and subtotals of income and expenses per customer. I'll be glad to guide you in customizing it.

Here's how:

1. On the top menu bar, select Reports.
2. Click Customers & Receivables and click Transaction List by Customer.
3. Click the Customize Report button.
4. Under the Report Date Range section, select Last Month.
5. In the Filters tab, search for Transaction Type.
6. In the Transaction Type drop-down, click Multiple Transaction Types.
7. Select Invoice and Payment and tick Ok.
8. Search for Paid Status in the Filters tab and choose Either.
9. Hit Ok to complete the process.

Also, I'd recommend memorizing this report to save its current customization settings.

For future reference, I've added this article to help you track how your business is doing: Customize company and financial reports.

Keep me posted if you require further assistance with running reports in QuickBooks Desktop. I'm here to help. Have a good one!

Thank you.  However, when I run this report, if I received a payment on 11/15/2022 for multiple invoices created before 11/1/2022, I see the payment, but not the invoices that were being paid.

For example, 

Customer A     Invoice 1    5/15/2022    $200

Customer A      Invoice 2   6/15/2022     $300

Customer A     Invoice 3    11/15/2022   $400

Customer A     Payment    11/20/2022   $500 (paying for Invoice 1 & 2)

I need a report that shows me that in November 2022 Invoice 1 and Invoice 2 were paid.

The report I run above shows me Invoice 3 and Payment from November.

Thank you for your help!

Can you please update on this Quickbooks - we need to track what invoices have been matched to each payment and the amount.  Standard report in other software!!!

I'm here to help you run a report that displays your invoices with payments, Timas.

In QuickBooks Desktop (QBDT), you may run and customize the Customer Balance Detail report to see your customer invoices with their corresponding payments and balances. 

Here's how:

1. Open your QuickBooks Desktop file.
2. Go to the Reports tab, then click on Customers and Receivables.
3. Select Customer Balance Detail.
4. Choose the Customize Report button, then click Filters.
5. On the Transaction Type, select Multiple Transaction Types, then choose Invoices and Payments.
6. Select Paid Status, then choose Closed.
7. Click OK.
8. Filter the dates and other customization.
9. Review your invoices and payments from there.

For visual reference, I've added a screenshot below:

Otherwise, you can open each of your invoices to see their payments. I'll show you how:

1. Go to the Customers tab, then click on Customer Center.
2. Tap 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.
   

For more tips about handling your invoices in QBDT, please see these articles: 

• Create Invoices
• Record an Invoice Payment

Additionally, I've added this article that'll help you select reports that you can run in QuickBooks to easily keep track of your sales and focus on the information that matters most to your business: Customize Customer, Job, and Sales Reports.

If you have any other questions about getting the details of your invoices with payments, let me know by adding a comment below. I'm always here to help. Keep safe always!

I do not see this as an option on my screen.  Is there another way?

Thanks for chiming in on this forum, katesbug2.

For me to fully address your concern and provide you with a detailed resolution, may I know which option on your screen you're having difficulties with? What steps have you done? You can also provide screenshots and other details so I can get back to you and ensure you'll get the assistance you need.

Any additional information is much appreciated.

Feel free to get back in on this thread for any updates. We'll always be around whenever you need help. Have a good one!

This doesn't show how the payments were actually applied to specific invoices. Can you tell from the report which invoice payment 3006 under Andres,Cristina was applied to? I think that is what we are trying to get here.

Thank you for sharing your interest, David.

I know how much you want to see which previous payments you applied to customer invoices. You'll want to check this specific data by going to the Customer's Transaction list. From there, double-click the payment to see the associated invoices from the Reports tab's  Recent Transaction section.

Here's how:

1. Go to the Customers menu and then select Customer Center.
2. Select the client in question.
3. From the Transactions tab, double-click the Payment in question.
4. Click the Reports tab and choose Transact History.

Alternatively, you can run the Transaction List by Customer report and filter it to show invoices and payment since this displays the income and expenses per customer. Let me show you how:

1. Select Reports from the top menu bar.
2. Choose Customers & Receivables, then 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. Hit OK again to complete the process.

To save its current data customization, I encourage memorizing this report.

I also recommend checking out this article that will help in tracking how your business is doing: Customize company and financial reports.

I'm still here if you need a helping hand in managing your reports. Don't hesitate to tag me (@Jovychris_A) in your comments. Take care.

I'm having the same issue where we receive a payment from a customer, who has multiple invoices open with the same dollar amount so when it comes through the bank fed QBO doesn't know what inovoice to apply the payment to. I don't need a report myself but what other ways can we find what invoice the customer paid?

Hi there, KC033.

Allow me to join you here and offer my help about your questions about invoices and applying payments to them. 

I'd also like to ask if you are receiving the payments manually? Please note that QBO will look for a match if the downloaded transaction has the same amount with an open invoice. You'll want to reach out to your customer to verify which invoice was paid if multiple transactions have the same amount. 

Please see this article for more details about this feature: Categorize and Match Online Bank Transactions in QuickBooks Online.

Although, you can run the Invoices and Received payments report. This will give you a list of invoices and the payments that are applied to them. Here's how:

1. Go to the Reports menu and look for Invoices and Received payments.
2. Choose Customize at the upper-right hand corner, then scroll-down to the Filter section.
3. Click the drop-down list beside Customer and select the name of the customer in the drop-down list.
4. Choose Run report.

You'll also want to use the QuickBooks Payments to receive online payments from your customers. Using this feature, the system will automatically apply and match the payment to your invoices. Let me share these articles with you on how to use it:

• Take and Process Payments in QuickBooks Online with QuickBooks Payments
• Automatic Matching for QuickBooks Payments

Feel free to check out these articles as well in case you need more guidance when receiving payments in QBO:

• Link a Bank Deposit to an Invoice in QuickBooks Online
• Find Missing Payments You Want to Deposit in the Bank Deposit Window

The Community is always here if you need anything else. 

Can you please let me know if it is possible or not to generate what should be a very basic and very useful report in QBO which shows the following

date; payment recieved; invoice number reconciled against.

If there is no report which does this then please tell me that what I need is not possible.

Please do NOT suggest any reports that do not show payments linked to an invoice.

Thank you

Good morning, @accounts-gateway. 

Thanks for chiming in on this thread.

The best route would be to use the instruction my colleague gave above your response. Which is to use the Invoices and received payments report. 

Learn more about our reports in QBO through these links below: 

• Run reports
• Customize reports

If these steps don't end in the results you want, come back to us so we can determine the final answer your business. Have a wonderful day! 

I am trying to do the same thing. All of you are missing the point. 

We need a report (which should be a super basic report, so it's shocking it does not exist) that shows which payments were applied to which invoices, without having to navigate to another screen to figure it out. Just a report with "payments A and B were applied to Invoice 123" with the amounts and dates. All on one page, in one report, that can be exported.

I understand your point, @nstew. Let me share some updates about the report you need for your invoices and payment entries.

I can see how important it is for you to generate a report that shows which payments were applied. While the option for you is to pull up the Invoices and Received Payments report as suggested, you can always submit a feature request directly to our product developers. This way, they can evaluate the possibility of incorporating this functionality in the coming updates.

To start:

1. Go to the Gear icon, then Feedback.
2. Enter your comments or product suggestions.
3. Tap Next to submit.

Once done, your valuable suggestion goes to our Product Development team to help improve your QBO experience. You can track feature requests through the QuickBooks Online Feature Requests website.

On the other hand, I'm adding this content to provide additional guidance when running basic reports in our system: Run reports in QuickBooks Online.

Aside from that, you can get the most out of your reports by going to the Customize tab. From there, you may also memorize their customization settings for future use.

Please extend your patience about this matter. If you have follow-up questions about your reports, please let me know by leaving a comment below. I'm just a few clicks away to help you again. Have a good one!

Thank you for this!  I totally agree with you!!

Thank you for this!  I agree!!  This is super frustrating and seems like it should be relatively simple to do.

This is a snippet from my Invoices and Received Payments report (on Who Owes You section) in QBO Online.

I found your post when researching the same need you had and did not realize that this report HAS the information, but not in a post-processing friendly way. Each payment is followed by one or more lines for which invoice it paid or partially paid.

Unfortunately, if you customize this report, the "Open Balance" column that it supports is only the CURRENT open balance of the invoice. It does not show the open balance of the invoice right after the payment was applied. I am also unclear if the payment is correct after being partially applied to two different invoices and/or has a remainder -- and if this report is smart enough for that. When the amount pays the entire invoice(s) -- it tracks pretty well.

I currently am looking at writing code to flatten this in Excel -- the regular export is not spreadsheet-friendly for doing running balances or creating reports that go back in time. It also will not ungroup the entries, they are grouped by the Customer field hierarchy.

The report you refer to invoices and Payment received is an online report. For desktop enterprise users where is this report because it is not under Customer & Receivables.

Hey there, @bmwoverland.

Currently, the Invoices and Received Payments report is not available in QuickBooks Desktop (QBDT). 

However, you can still view the payments and invoices that make up each customer's balance by running the Customer Balance Detail report. Let me guide you how.

1. Navigate to the Reports menu, then select Customers and Receivables.
2. Choose Customer Balance Detail.
3. Click the Customize Report button, then Filters.
4. Under the Transaction Type, select Multiple Transactions Types, then Invoices and Payments.
5. Choose Paid Status, then Closed.
6. Hit OK.
7. Filter the dates and other customization.

Just in case you want the same settings of the customized report to be available for future use, you can check out this article for guidance: Create, access, and modify memorized reports.

Feel free to return to this thread if you have further concerns regarding running customer reports. I've got your back.

any update on this report we need it and no easy way to pull it.. We have 152 checks for over 300+ invoices any help would be greatly appreciated.

[email address removed]

Any updates on how to pull this faster than having to search for each deposit the log into our own spreadsheet we have 152 checks deposited with over 300+ invoices..... Please advise

trinahannah

I understand that keeping track of your business transactions is of the utmost importance to you, trinahannah. I see the benefit of having the Invoices and Received Payments report.

Currently, the report you're looking for is not available in QuickBooks Desktop. Alternatively, you can pull up the Customer Balance Detail report to view payments and invoices, including your customer's balances. 

1. Hover to the Reports menu, then select Customers & Receivables.
2. Choose Customer Balance Detail and click the Customize Report button, then Filters.
3. Look for the Transaction Type, and choose Multiple Transactions Types. 
4. Click Invoice and Payment, then press OK. 
5. Locate Paid Status, then click Closed or Open.
6. Hit OK.

I've included a screenshot for visual reference:

Moreover, you can memorize the reports you've customized. This way, you won't have to do the customization process again. 

I'll gladly assist you further in generating reports and managing invoices in QuickBooks Desktop. You can tap the reply button below to enter your queries. I'm always here to back you up. 

I'm not sure if my question was initialy understood but it seems we all have a similar problem.

My issue is:
We invoice all our customers through "QBOnline". If we invoice a customer the exact amount every time we service their location and then the customer pays a week, a month or 60 days later, that ACH payment comes in the Bank Detail under the Bank Transactions without a description or invoice paid number. It does not describe what invoice the customer is paying and it does not automatically "Match" with an specific invoice. It matches to "all" invoices as they are all the same amount. There's customers who do not provide a remittence report and I can not force them to do so.  Like the other person asked, what if we send hundreds of invoices? How do we know which invoice the customer paid through ACH? There is no report that will show that information without me matching a transaction first and I can not match a payment to an invoice without knowing what invoice the customer paid. So is there a place where I can find this information? - KC 020624

Thanks for joining the thread, @KC033. Let me share some insights for checking your customer's invoices paid through ACH. 

You'll want to sign in to your merchant services account, check the Activity & Reports section, and identify the customer.

You'll be able to look at the transaction and see the customer's name if they entered their name when processing the transaction.

Here's how: 

1. Sign in to Merchant Service Center.
2. In the top navigation bar, click the Activity & Reports drop-down list.
3. Select Transactions. 

Once logged in, you'll now be able to look at your batches and see which payments are combined.  

Also, we'll need to ensure we input the customer's name when processing the transaction. This way we'll be able to check the information. Otherwise, there's no way to retrieve them. 

Feel free to reply to this thread should you need additional assistance managing your invoices in QuickBooks Online. Take care.