Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
tcutrona
February 2, 2023
Question

Custom Invoice Report Needed

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

4 replies

Rea_M
Level 10
February 2, 2023

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:

 

  1. Go to Business overview and select Reports or go to the Reports menu.
  2. Use the Find report by name search bar and search the Transaction List by Date report. Then, select it to open its data.
  3. Click the Customize button.
  4. Set the date in the Report period section.
  5. Go to the Filter section.
  6. Set the A/R Paid option to Paid and Transaction Type to Invoice.
  7. Click the Run report button. 

 

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.

tcutronaAuthor
February 6, 2023

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

JamesAndrewMModerator
Moderator
February 6, 2023

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:

 

  1. Access your QuickBooks Online company.
  2. Go to the Reports tab.
  3. In the Search bar, type Sales by Customer Details and then click on it.
  4. Have the Accounting method set to Cash.
  5. Click the Customize button, and then go to the Filter section.
  6. Modify the Transaction Type set to Invoices. 
  7. Make the A/R Paid set to Paid.
  8. Once done, Run the report.

 

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!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement