How do I run a report that will show all payments received during a certain time period for a few select accounts?

Klent, 

This is closer than I have gotten! LOL! This gets me most of the way there but it shows ALL deposits for that week. I then have to manually pull out other "accounts" that I don't want to include which is very time consuming. If I try to filter by account, I get the dreaded blank report. If this is as close as I can get, it will definitely work for what I need. 

Thanks!

You were on the right track, now switch your report to cash instead of accrual.

So this works pretty well but provides totals that add up to all the transactions for the client.  That makes absolutely no sense that one would need to add up invoices and payments for a total.  Invoice plus + Payment should net a balance not the total of the two.  

I am trying to determine all sales and then subsequent payment receipts for a group of customers.  Since payment and invoices are both positive numbers I have to export the report. But by exporting this I would need to change all payments to negative numbers so that I could get a net total receivables by customer.  This is not the only report that doesn't change the sign so that you can get a net total of Invoice minus Payment = Balance.  I also used the Invoices and Payments report but this did not provide a total and exporting to excel still requires changing the sign of all payments and then another step of summing.  Is there some way to have the report recognize all Invoices and Sales receipts as positive numbers and payments, credit memos as negative?  One needs to be able to net these transactions for a net balance.

I'm here to add a few details, WS110.

The Transaction List by Customer report will show the payment as positive. However, the credits will show as negative. You can add the Open Balance column as a workaround. It will show you the customer's available balance. Here's how:

1. Click the Customize button.
2. Go to Change columns.
3. Tick the Open Balance box.
4. Click Run report.

Also, you can check the customer's balance by opening the Customer Balance Summary report. It won't show the payments and invoices, though. It will just provide the balance. Here's how:

1. Click Reports.
2. Enter Customer Balance Summary in the Find report by name field.

If you have additional questions, please feel free to get back to this thread. Take care!

I was having the same issue and this thread solved it for me.  Next question:  Now that I have the report to show me the payments for a date range, is there a way to total this amount?

Hello there, @Carmine2276.

Glad that this thread was able to help you figure out the report you need.

Customizing the report helps you get or generate the information you want. However, you can get the total amount of the invoices and each payment by exporting the report to Excel and manually get the total amount.

You can follow these steps to accomplish this task:

1. Open the Transaction List by Customer report.
2. Click the Customize Report button. Make sure to include all the details you need before exporting it.
3. Once done, click the Excel drop-down arrow, select Create New Worksheet.
4. Then, Export.
   

From the worksheet, you can get the total amount by manually doing it.

I've gathered some articles where you can get more details and tips about handling reports in QBDT:

• Customize reports in QuickBooks Desktop.
• Set up and modify Scheduled Reports. 

Please let me know how it goes. You can always go back here if you have other concerns about QuickBooks. Take care and stay safe, Carmine!

I dont seem to have Customers & Receivables 

Thanks for joining this thread, thestore2.

I've reviewed our ongoing/solved investigations and can confirm there's currently no records of subscribers reporting that their Customers and Receivables report is missing.

Since yours isn't showing up, I'd recommend using the Verify Data feature to see if anything needs to be rebuilt.

Here's how:

1. Choose Window, then Close All.
2. In your top menu bar, go to File.
3. Click Utilities.
4. Select Verify Data.

After verification's complete, you'll see one of a few possible messages. I've listed each of them and their meanings:

• "QuickBooks detected no problems with your data," - No action is required.
• "Your data has lost integrity," - This indicates that there's data damage in your company file. You'll want to perform a rebuild to correct the problem.
• An error message could display. If so, there might be an article about it. Try searching Intuit's QuickBooks Desktop support site for specific instructions.

If the Verify/Rebuild Data features didn't solve your issue, you'll want to get in touch with our Customer Care team so they can conduct further research:

1. In your top menu bar, go to Help, then QuickBooks Desktop Help.
2. Click Contact Us.
   
3. Enter a brief description of your issue in our Ask a question (or tell us what's wrong) field.
   
4. Hit Continue.
   
5. Select Start messaging or Get a callback.

 
They'll be able to pull up your account in a secure environment and create an investigation ticket if necessary. Be sure to review their support hours so you'll know when agents are available.

Please don't hesitate in sending a reply if there's any questions. Enjoy the rest of your day!

There is never a Total for all customers not jjust each customer

That was great - thanks so much for that comprehensive explanation

I am on QB online 2023. We are a nonprofit church who receives offering weekly and we deposit it with individual names. I was able to run Income by customer to give them annual contribution receipt. But I am not getting anything from Q B online. We have no invoices . So how do I get my report.

I see the importance of generating the necessary report to provide accurate and comprehensive financial information about your nonprofit church's activities, @NLBC 2.

You can count on me to help you require the data in QuickBooks Online.

Let's make sure to create a sales receipt for every offering and associate them with the respective individuals. This way, the Income by Customer Summary will display the data you need. 

Here's how: 

1. Navigate to + New, then choose Sales Receipt.
2. From the Customer ▼ dropdown, select a customer.
3. From the Select a product/service ▼ dropdown, choose the product or service.
4. (Optional) You can edit your line item’s quantity or rate in the Qty and Rate field. 
5. Fill out the other necessary fields in the sales receipt, then click Save.

After completing the necessary actions, proceed to run the report and check if the data is now visible.

Additionally, consider memorizing the reports in QuickBooks Online to store the current customization preferences, allowing for effortless retrieval in the future.

If you require further assistance, please don't hesitate to ask. We're here to help you navigate through this process and ensure your reporting requirements are met. Keep safe!

Hey, I need a report where can I know how much receivable due of my current financial year ending date after  1 months or 2 months. 

If is there any reports which can help me about this thing in A/R and A/P then please  inform me

In XERO if we run A/P or A/R details report & the in the  filter of due date we enter year end the  we know how much we still receivable or payable for our last financial year in current date

If QBO have any of this type of feature the  please inform me..we have to check every invoice when we do year end accounting.

I see how useful it would be to run a report that shows the overall Accounts Receivable (A/R) and Accounts Payable (A/P) details, Mihir.

Let me help you pull up a report that will show these transactions.

We can run the Transaction Detail by Account. By customizing this report, we can achieve your goal. Here's how:

1. From the left navigation, choose Reports.
2. Type in Transaction Detail by Account in the search field.
3. Click it once it shows up. 
4. Go to Customize.
5. In the Report period, select Custom and enter the date range.
6. From the Rows/Columns, choose the columns you want to view in the report. Never forget the A/R Paid, A/P Paid, and Due Date. To show if it's paid or unpaid if you're in classic view. However, if you're in the new interface, go to Columns. Feel free to read this article for more info on customizing reports: Customize reports in QuickBooks Online.
7. Click Run report. 

For more info, you can read this article: Run reports in QuickBooks Online.

You might want to utilize the report you customize in the future, check out this article: Memorize reports in QuickBooks Online.

If you have additional questions about running a report, never hesitate to come back here. I'll be willing to help. Have a good one.

How do I run a report that shows applied payments for one customer. The answer to the above question lost me through various steps and and refining and being new to qb online my mind cant wrap my head around all those steps..simply put. 1 report that shows applied payments for 1 customer

Welcome to the Community space, @djzap1. Let's team up so you can access the report you need with specific data inside QuickBooks Online (QBO).

To accomplish this, you'll want to run a report that shows transactions inside your company file. This way, you can customize it to show transaction and payment details from a specific customer inside the account. Checking here on our end, you can run the Invoice and Receive Payments report or Sales by Customer Summary or Detail report. We'll write down the steps below to get you going:

1. Access your QuickBooks Online company.
2. On the left navigational bar, go to the Reports tab.
3. In the Search Bar, enter Invoice and Receive Payments.
4. Choose a specific reporting period and enter the date.
5. Click the Customize button and click Change columns.
6. Choose the data or column you want to show inside the report.
7. Go to the Filter section, and then tick the box beside Customer.
8. Click the Dropdown arrow and then choose a specific customer.
9. Once done, click the Run report button.

You can check this page for more details about modifying a report and adding more details to it: Customize reports in QuickBooks Online.

In addition, here are some articles to help you keep your current report setting for future use: Memorize reports in QuickBooks Online.

We look forward to having you here again if you need further assistance accessing business reports inside the program. We'll be around to help you out again. Have a good one.