QuickBooks Team

Reports and accounting

Yes, we can do this in QuickBooks 2020, CrazyKZ.


We pull up the Profit and Loss report and filter all expense accounts. Then, we'll sort them by amount and that's it. Here's how:

  1. Go to Reports and choose Company & Financial.
  2. Select Profit & Loss Standard.
  3. Set the date range and click Customize Report.
  4. In the Display tab, set the Sort in to Total and select Descending order.
  5. Click the Filters tab.
  6. Choose the Account filter.
  7. In the Account drop list, choose expenses and other expense accounts.
  8. Click OK.

You can click on Memorize to save your customization. You can also click the Excel button, select Create new worksheet and then Export to save the data to Excel.


You can always reach out if you need help getting data on reports.

View solution in original post