Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I need to run a report in which I can see all payments made for a specific date range (Example 02/17/2020 - 02/24/2020) for multiple accounts. I tried to run a sales by customer detail reports and a sales by item detail report but it only shows the payments made for the invoices dated 02/17/2020 - 02/24/2020. I need to be able to see payments that were made towards invoices even if they are outside the date range. This seems like it should be a very simple report but I can't figure it out for the life of me!
Solved! Go to Solution.
We can pull up the Transaction List by Customer Report, kathy1973.
This report displays all the transactions and subtotals of income and expenses per customer. I'll be glad to guide you in customizing it.
Please follow the steps below:
You can double-click the payments to know which invoice it was linked to.
To save its current customization settings, I recommend memorizing this report.
I also encourage checking out this article that will help in tracking how your business is doing: Customize company and financial reports.
You can also get one-on-one help with accounting for your business: Check out QuickBooks Live. |
I'm just a quick post away if you need a helping hand in managing your reports. Don't hesitate to tag me in your comments.
We can pull up the Transaction List by Customer Report, kathy1973.
This report displays all the transactions and subtotals of income and expenses per customer. I'll be glad to guide you in customizing it.
Please follow the steps below:
You can double-click the payments to know which invoice it was linked to.
To save its current customization settings, I recommend memorizing this report.
I also encourage checking out this article that will help in tracking how your business is doing: Customize company and financial reports.
You can also get one-on-one help with accounting for your business: Check out QuickBooks Live. |
I'm just a quick post away if you need a helping hand in managing your reports. Don't hesitate to tag me in your comments.
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:
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:
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:
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:
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:
After verification's complete, you'll see one of a few possible messages. I've listed each of them and their meanings:
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:
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:
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:
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:
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.
This is absurd. Why provide a list of payments without a total at the bottom? That makes no sense. It would take a computer a fraction of a second to include the total, but instead Inuit wants to waste hours of our time forcing us to do this manually each time by exporting it to Excel just to get a total that should have already been included. Please explain, in detail, why there is not already a total on this report (and many others in QB "Enterprise").
Hi there,
Thanks for joining the thread and sharing your thoughts about reports in QuickBooks. Since many reports have already been mentioned in the thread, can you help us specify the reports you're referring to?
You can also share with us the exact product you're using when running reports. This way, I can give you the appropriate explanation and solution to your concerns.
Any additional info would be much appreciated. Just add your details to the thread and I'll get back to you.
The report is the one in the title of the tread and it is mentioned in my question. This applies to most reports like this. The reports should show a total at the bottom of the report.
We are running Enterprise 2023, but the problem is in all versions of QB Desktop I have ever used. You asked what version of Enterprise we are running. Is the answer different for different versions of QB Desktop? If so, please answer the question for every version of QB Desktop for the last 10 years. Thank you.
Incase you have forgot the question: Why provide a list of payments without a total at the bottom?
Thank you for providing me with the necessary information. I'd like to share some insights with you about this report that will show all payments received.
QuickBooks Desktop's summary report includes the total of payments, which is not present in the transaction list report. You'll still need to export the report to an Excel file to get the total of payments in the transaction list report.
I understand that having a total payment in the transaction list report is important. I encourage you to share your feedback directly with our Product Developers. They are genuinely interested in hearing your input.
To send your input, here's how:
To keep updated on the product's latest release and updates, you can check out this article: QuickBooks Blog.
I've added this article to help you personalize the layout of your financial reports: Customize reports in QuickBooks Desktop.
If you have any concerns or questions while generating a report in QuickBooks Desktop, please do not hesitate to reach out to us. We are here to provide assistance and support. Have a great day!
Is this or is it not an accounting program? Doesnt accounting involve adding and subtracting? Doesnt it make sense to put a total at the end of a series of numbers? Isnt this why people use accounting programs? So it pulls all the information together? As much as qb engineers and developers love thier jobs they often fail to realize simplicity not complexity works better for businesses who need accounting but accounting isnt thier business, far from it. The simplest fixes would make this program so much more user friendly for businesses, but they all ignore it and want us all to spend endless hours clicking page after page on the program. QB this question was some time ago..it may surprise you to know that some folks still have adding machines and tape that run totals. For all you do you fall short on the simplest things. Why do I need multiple places on a single page to recieve payment? Why do I have to complete endless steps for the simplest of tasks? Clearly the product is a mess or you would have been able to answer this a heck of a lot quicker or here is an idea, call me a genius ...but it would be really cool if accounting program engineers and developers might realize the whole idea behind an accounting program is to get quick information and totals for the businesses that use them..not look at all the things you want to throw in there because you think its cute...I dont want to click multiple buttons for a simple calculation. Adding. Name of customer, invoice number, date, amount paid, amount owed and total amount for each at the bottom of the page enter something that all businesses need...a total.
Imagine if you will, a program that is supposed to simplify your business but in responses like this that pass your off to people who ignore everything as well. IF THE DEVELOPERS AND ENGINEEERS PAID ATTENTION TO BUSINESSES INSTEAD OF WHAT THEY CAN CREATE TO FEED THIER OWN EGOS THE BUSINESSES THAT ARE STUCK WITH THIS MONSTROSITY MIGHT ACTUALLY ENJOY USING IT..THIS IS NOT THE CASE.EVERY INSTANCE OF QB IS INCREDIBLY TIMECONSUMING AND CUMBERSOME,Having to call support and provide the same information repeatedly..dont they see the questions have been answered already? If not why not? Accounting needs totals..dont realize that? Ask accountants...ask bookkeepers, ask businesses, you dont so here it is, we need totals. You dont have the space for me to list everything but your community searches for information show just what a massive heap of dung this is that it has generated so many answers to so many problems that were created by qb...are any of these resolved? I dont even bother looking or asking hardly at all anymore..its probably got more letters than irs tax code...now tell me how great it is
This is QuickBooks Desktop, not Online, so there is no QBO account. This thread is over 4 years old and QuickBooks still has not added totals to the reports. Why would anyone expect asking for it again would work?
I started working on computer over 50 years ago, in 'product development". I guarantee you none of the "Product Developers" read those posts. If they did, they would have added totals to the reports decades ago. Why is management telling them not to add totals to the reports?
Also, "For now, it would be most effective to communicate your feedback directly to our Product Developers. "
My screenname sums up this situation.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here