Skip to main content
C
cactus
February 25, 2020
Solved

QBO: Filter the "Expenses by Vendor Summary" report by Distribution Account (a specific credit card)

  • February 25, 2020
  • 1 reply
  • 0 views

As the title says.

 

Expenses by Vendor Summary is exactly the layout I want, but I can't find out how to scope it to only show payments made by a specific credit card (e.g. distribution account or account filter in customize settings)

 

I'm sure I'm missing it because employers would want to be able to see summary totals for where an employee has been spending money...

 

And before this comes up, I know I can "Run Report" for the account representing the credit card and group it by vendor BUT I don't really want the transaction detail, its not compact. I don't necessarily want to dive into specific transactions without being able to see the big picture of where someone is spending.

 

 

Thanks in advance!

 

 

Best answer by JamesDuanT

I like how you come up of customizing the Transaction Detail by Account report, cactus.

 

Currently, that is the only report that we can customize to drill-down the expenses. Aside from the customization you did, I might be able to add a few more to achieve the data you want. Here's how to do it:

  1. Open the Transaction Detail by Account report and click the Customize button.
  2. Enter the correct Report period and go to the Rows/Columns section.
  3. Select Vendor in the Group by field.
  4. Mark the following columns:
      • Credit
      • Debit
      • Account
    Note: You can remove other columns if necessary.
  5. Go to the Filter section and select the credit card in the Account field.
  6. Select All Income/Expense Accounts or All Expenses Accounts in the Distribution Account field.
  7. Click Run report.

With this customization, you can see where the amounts were spend under the ACCOUNT column. You can save the customization or export the data to Excel.

 

We'll also share your idea to our Product Development Team. They'll take note of it for product updates.

 

Let me know if you need additional assistance in customizing the report. Have a great day!

1 reply

J
JamesDuanTAnswer
February 25, 2020

I like how you come up of customizing the Transaction Detail by Account report, cactus.

 

Currently, that is the only report that we can customize to drill-down the expenses. Aside from the customization you did, I might be able to add a few more to achieve the data you want. Here's how to do it:

  1. Open the Transaction Detail by Account report and click the Customize button.
  2. Enter the correct Report period and go to the Rows/Columns section.
  3. Select Vendor in the Group by field.
  4. Mark the following columns:
      • Credit
      • Debit
      • Account
    Note: You can remove other columns if necessary.
  5. Go to the Filter section and select the credit card in the Account field.
  6. Select All Income/Expense Accounts or All Expenses Accounts in the Distribution Account field.
  7. Click Run report.

With this customization, you can see where the amounts were spend under the ACCOUNT column. You can save the customization or export the data to Excel.

 

We'll also share your idea to our Product Development Team. They'll take note of it for product updates.

 

Let me know if you need additional assistance in customizing the report. Have a great day!

C
cactusAuthor
February 25, 2020

Thank you James, I look forward to possibly seeing it in an update!

Terms & ConditionsAccessibility statement