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!
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.
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.
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.
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.
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
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.