Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWe take several progress payments, from our customers, throughout their home remodeling project. What I'm unable to find is a report that would look at all invoices paid in full in a specific period of time (last final, zero balance payment).
Desktop used to have a closed invoice I could check, QBO has an open invoice button, but no close invoice selection. Furthermore If I customize my report and check paid under A/R paid that still gives a list of all the progress payments, not the paid in full/zero balance invoices.
Any help would be appreciated.
I'll help you find the report you need, @tcutrona.
Let's pull up and customize the Transaction List by Date report so you can look at all your fully paid invoices in QuickBooks Online (QBO) and manage your sales and income transactions accordingly.
In QBO, financial and transaction reports tell you everything about the different aspects of your business. To get the data you need, follow the steps below:
If you wish to learn more about report features and how to run specific ones to get the info you need in QBO, please see this article: Run reports in QuickBooks Online.
Also, you can create and customize accounts receivable aging reports to give you an overview of your customers' outstanding balances, who are falling behind their payments, how much is still due, and how long they’re past due. You may want to check out this article as your reference to guide you on how you can run these reports in QBO: Run an accounts receivable aging report.
Please feel free to leave a comment below if you have other concerns about pulling up reports and managing transactions in QBO. I'm always ready to help. Take care, @tcutrona.
That didn't produce the report I'm needing. It shows all payments done in a period of time, not just the payments that closed invoices 100%.
I appreciate you for getting back to the thread, @tcutrona. I'll chime in and share information about what report you can pull to show paid invoices in QuickBooks Online (QBO).
If you want a clear picture of your sales in QuickBooks, including paid invoices, run the Sales by Customer Detail Report with the Cash accounting method selected rather than the Accrual accounting method. This allows you to view the amount paid on your invoices.
Here's how:
In addition, if you want to save the current settings of your customized report and have them carry over the next time you run the same report in QuickBooks, you can utilize this article: Memorize reports in QuickBooks Online.
I’m just a post away if you need anything else. Have a great day!
I appreciate the advice, but still does not produce a report that only shows the final payment to an invoice in a given time. It shows all the invoices that were CREATED in that time frame, and also happen to be paid in full (alot were paid in full in a different time period).
Example:
I am doing the report as you have instructed for the time period 10/01/2022-12/31/2022. All the invoices that are paid in full, and were created in that time frame populate. Some of those invoices, in reality got paid in full after 1/1/2023.
I don't care at all when an invoice was created, I just want to know when it was paid in full between 10/01/2022-12/31/2022.
Hopefully someone can help.
Thank you,
Tony
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