What report could I pull to show a list of all payments made in a given time frame, and which invoices and credit memo's that payment applied to.

Good day, jenn18.

You can run the Invoices and Received Payments report. This will give you the list of payments from a certain period of time and the invoices that the transactions were applied to.

Here's how:

1. Go to the Reports menu and look for Invoices and Received Payments.
2. Select a date in the Report period field. 

You can also customize the report in case you want to see specific customer names in the report. Use this as a guide on how to do that: Customize reports in QuickBooks Online.

Please don't hesitate to visit us again if you need anything else.

**Say "Thanks" by clicking the thumb icon in a post

**Mark the post that answers your question by clicking on "Accept as solution"

Hi,

Thanks for answering. 

I have already tried this report. For some reason when I pull the report, some of the payments show invoices it applied to, but many of the payments don't. When I click on a payment, it opens a new window that lists all the invoices it was applied to, so I know it has invoices associated to it, I'm not sure why they don't show up in the report though. 

Welcome to Community @jenn18,

Make sure to filter the date range of the report correctly to show all the associated transaction on that statement. You can follow the steps provided by my colleague JenoP and select the report period date where the invoice was created and when did you receive the payment.

Also, you can customize the report to focus on the statement you've wanted. Once done, you can memorize the report to save the modification settings.

Fill me in if you need more help by leaving a comment below. I'll be around in the Community to help. Take care and have a great day!

I want to see all of the payments made in January, but the associated invoices the payments applied aren't all in January.. How do I date the report to only show January payments but ALL invoice dates associated?

Thanks for adding more details, @jenn18.

You can pull the Invoices and Receive Payments report and make sure setting the Custom date to January. This way, the payments will show on that report's particular month as well as the backdated invoices.

Here's how:

1. Click the Magnifying glass icon on the upper right.
2. Type "Invoices and receive payments" and then select Invoices and receive payments.
3. Change the Report period to Custom.

4. Then set the date from January 1 to January 31.

Since I didn't have prior invoices that were paid in January, I pulled my February report. As you can see, the report will show the Payment first on the Transaction Type column so that you can easily determine the associated invoices on it.

Please refer to my screenshot below.

Keep me posted by leaving a message to this thread if you have more questions. I'm always here to help. Stay safe and well!

This is not working. I'm not sure if there's a problem with how we receive payments that's making this report not pull accurately.. I have a January 1, 2020 -January 31, 2020 filter set. Please see my screenshots. When looking at the report, none of the invoices show on the payments, but when I click on the payment a new window opens and shows all the invoices it was applied to. Is this because the report only shows Parent accounts (Costco Wholesale), and the payments were applied to invoices under the Child account (Costco Wholesale - Morris)?

I appreciate you for getting back to us and sharing a screenshot, jenn18.

Yes. You're correct. The Invoices and Received Payments report only displays the total amount of the parent account. Then, when you click the total amount, you can see there the linked invoices and the payments under the child-account (sub-account).

For us to see the linked transaction under the parent account and the child-account, we'll have to click each payment.

I've also added these articles for more information when receiving an invoice payment:

• Record invoice payments
• About bank or credit card subaccount setup

Feel free to get back to me if you still need help. Keep safe!