Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Quickbooks desktop premier edition 2020
Need a list of invoices with invoice date and amount for a time period. I tried following another thread by selecting transaction type etc., but dates are all wrong and missing invoices. All wasn't showing invoices entered on 4/1 even though I selected through 4/4. Why is it so difficult to get a list of invoices?
Solved! Go to Solution.
I’m here to walk you through in finding the list of your invoices in QuickBooks Desktop, @melissa321.
Yes, BRC is right. We can generate the Transaction List by Customer report and filter the transaction type to show just your invoices.
Here’s how:
I’ve added some snippets below for your references:
Here's an article you can read for more details: Customize reports in QuickBooks Desktop.
Just in case you want to export this report to Excel, feel free to check out this article for the detailed steps and information: Export reports as Excel workbooks in QuickBooks Desktop.
If you have other report concerns or requires additional assistance, don’t hesitate to reply below. It’s always my pleasure to keep you on the right track. Keep safe.
It isn't usually difficult. At least it shouldn't be:
Start with a transaction detail report (Reports | Custom | Transaction Detail.)
- Filter it for:
- TransactionType = Invoice
- Detail Level = Summary only
- Date = whatever date range you want
That should do it.
Thanks, but I'm missing invoices still and the dates are not the invoice dates. I think it is giving me payment details and not original invoice amount?
I can't find "detail - summary only"? I don't see any filters that might be limiting search but it is giving me only paid invoices.
Still plugging away and think I figured out my error. I was selecting cash basis and it was giving me paid invoices so I selected accrual instead and it gives me the correct list. I just wanted a list of invoices so I didn't think the cash vs accrual would make a difference but the way the report is created apparently it does.
I’m here to walk you through in finding the list of your invoices in QuickBooks Desktop, @melissa321.
Yes, BRC is right. We can generate the Transaction List by Customer report and filter the transaction type to show just your invoices.
Here’s how:
I’ve added some snippets below for your references:
Here's an article you can read for more details: Customize reports in QuickBooks Desktop.
Just in case you want to export this report to Excel, feel free to check out this article for the detailed steps and information: Export reports as Excel workbooks in QuickBooks Desktop.
If you have other report concerns or requires additional assistance, don’t hesitate to reply below. It’s always my pleasure to keep you on the right track. Keep safe.
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