CYBER MONDAY SALE 70% OFF QuickBooks for 3 months*   Ends 12/5

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
ricardo-bartlett
Level 2

Is it possible to print a report that shows only the last INVOICE created for any given customer. I only want the latest invoice reported for each account?

 
2 Comments 2
ChristineJoieR
QuickBooks Team

Is it possible to print a report that shows only the last INVOICE created for any given customer. I only want the latest invoice reported for each account?

While we're unable to print a single report showing only the last invoice for each customer directly, we can achieve this by customizing and exporting an existing report, Ricardo.

 

We can generate the Transaction List by Customer report, which serves as a starting point for this task. It includes all transactions for each customer, allowing us to filter and sort by recent dates and invoices.

 

Here's how:

 

1. Go to Reports and search for Transaction List by Customer.

2. Click Customize in the top-right corner.

  • Report period: Set this to All Dates to ensure you capture every invoice for every customer.
  • Filters: Select the Transaction Type and choose Invoice from the dropdown menu.

3. Click on the Run Report button. Then, click the Export icon.

4. Once done, customize the data to reflect the latest invoices and print the file.

 

Additionally, to find the latest invoices for each account, go to the Transaction Detail by Account, set the Transaction Type filter to Invoice. Then export the report to Excel, customize the data to reflect the latest invoices, and print the file.

 

See the reference below:
70.png

 

We are always here to help if you need any assistance.

ricardo-bartlett
Level 2

Is it possible to print a report that shows only the last INVOICE created for any given customer. I only want the latest invoice reported for each account?

Good morning, is this a report that I can request even if I have to pay to have it customized for my needs.

 

Please let me know as it is something that I really need for my business

 

Look forward to your reply, thanks again, 

 

Ricardo Bartlett

CLEAR VIEW of Eastlake 

619-992-3001

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us