cancel
Showing results for 
Search instead for 
Did you mean: 
cactus
Level 2

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

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!

 

 

Solved
Best answer February 24, 2020

Best Answers
JamesDuanT
Moderator

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

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!

View solution in original post

3 Comments 3
JamesDuanT
Moderator

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

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!

cactus
Level 2

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

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

xabrinax
Level 1

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

Thank you! Finally Credit Card Transactions by Category

Need to get in touch?

Contact us