Skip to main content
D
DaveMO
April 10, 2021
Solved

Detailed Report Of All Expenses

  • April 10, 2021
  • 1 reply
  • 0 views

Using QB Desktop Pro 2020. I'd like to create a report of all expenses for a given period, not just vendors. Internet searches show this for QB Online, but I'm having trouble doing it in my desktop version. I'd like the report to not just summarize, but rather to show each of these expenses in detail.

Best answer by Jen_D

Good thing, you came to the right page to help you with your reports, @DaveMO,

 

You may pull up a Transaction List by Vendor report to show the bill payments and checks you created for a specific period. Here's how: 

 

  1. From the Reports menu select Vendors & Payables.
  2. Select Transaction List by Vendor from the result.
  3. Click the Customize Report button at the top and update the Report Date Range.
  4. Once done, go to the Filters tab.
  5. In the Filter search box, enter and select Transaction Type.
  6. Choose Multiple Transaction Types and pick the bill payment and checks or other expense transactions you need.
  7. Hit OK when you're done.
  8. To save the custom filters, use the Memorize button at the top. You can use this for every Payment Method you want to track. Access saved reports in the Memorized Report List.

 

I'll be adding some articles to help you maximize the use of our reports in QuickBooks. See hem below:

 

 

If you have any questions about QBDT reports feel free to reach out back again, and I'll be right here to help. Have a nice day!

1 reply

Jen_D
Jen_DAnswer
April 10, 2021

Good thing, you came to the right page to help you with your reports, @DaveMO,

 

You may pull up a Transaction List by Vendor report to show the bill payments and checks you created for a specific period. Here's how: 

 

  1. From the Reports menu select Vendors & Payables.
  2. Select Transaction List by Vendor from the result.
  3. Click the Customize Report button at the top and update the Report Date Range.
  4. Once done, go to the Filters tab.
  5. In the Filter search box, enter and select Transaction Type.
  6. Choose Multiple Transaction Types and pick the bill payment and checks or other expense transactions you need.
  7. Hit OK when you're done.
  8. To save the custom filters, use the Memorize button at the top. You can use this for every Payment Method you want to track. Access saved reports in the Memorized Report List.

 

I'll be adding some articles to help you maximize the use of our reports in QuickBooks. See hem below:

 

 

If you have any questions about QBDT reports feel free to reach out back again, and I'll be right here to help. Have a nice day!

D
DaveMOAuthor
April 10, 2021

Thanks for your quick and thorough reply. I got it to work, with a little tweaking. Is it possible to have a report like this show a total of all the expenses it reports?

    C
    CharleneMaeF
    April 10, 2021

    Glad you're able to pull the report you need, DaveMO.

     

    I'd suggest exporting the report to Excel. From there, we can get the amount of all the expenses it reports. I'll guide you how.

     

    1. In QuickBooks, go to the Reports menu.
    2. Find and open the report.
    3. Select the Excel on the toolbar. 
    4. select Create New Worksheet. 
    5. When you’re ready to export, select OK. 

    For further guidance, please see this article: Export Reports as Excel Workbooks.

     

    Additionally, I encourage memorizing your reports in QuickBooks Desktop. This helps you access the current customized settings.

     

    I'll be glad to help you again if you have more questions about running reports. Please add the details in the comment section.

    Terms & ConditionsAccessibility statement