Question

Need a Report for Specific Vendor with Multiple Expense Accounts

Forum|Forum|4 years ago
November 18, 2021
4 replies
55 views

I am trying to generate a report that meets these conditions:

1 Vendor and 2-3 expense accounts (payments made).

I have a few vendors in which bills are categorized by labor and materials (two separate expense accounts).

I am trying to find a report that will pull a single vendor plus the specified expense accounts.

Yes, I can pull the Expense by Vendor detail, but I really need each account total separated, but I don't want to manually have to add up each expense for each account if that makes sense.

Please tell me I am missing something!

Thanks in advance.

QuickBooks Desktop

M

MirriamM

QuickBooks Team

Hi there, @rebeccarac3.

In QuickBooks Desktop (QBDT), we have the Transaction Detail report that you can run and customize based on your needs. You can set the Filter for Account into Multiple All Accounts. Then, make use of the columns by checking the Account, Account Type, and Split under Column selection to see where you can locate the split amounts.

To do this, here's how:

Go to the Reports menu at the top.
Select Custom Reports.
Click Transaction Detail.
Click the Customize Report button.
Go to the Display tab.
From the COLUMNS field, type in and select Split, Account, and Account Type.
Go to the Filters tab.
Type in and select Account under the FILTER field, and choose the preferred account from the Account drop-down menu
Type in and select Vendor under the FILTER field, and choose the preferred vendor from the Vendor drop-down menu
Click OK.

For more details about personalizing reports in QBDT, see this article: Customize reports in QuickBooks Desktop. Then, you can utilize the Memorize button to save the customization of the report. By doing so, you won’t have to go to the customization process again in case you need the same information in the future.

Don’t hesitate to respond on this thread if you have additional questions or concerns about reports. I'm always around to assist you. Have a good day!

R

rebeccarac3Author

I have tried these steps numerous times, and the report still will not isolate the preferred vendor.

It is pulling several different vendor, despite having filter to ONE preferred vendor.

Getting frustrated, because it seems like a pretty simple report, and not sure why I can't get it to work.

AlcaeusF

Level 14

Thanks for getting back to us, @rebeccarac3.

I appreciate you following the steps shared by my colleague above. Allow me to chime and share additional details for the report you're trying to pull up in QuickBooks Desktop (QBDT).

Instead of selecting Preferred Vendor in the Choose Filter section, choose Name. Then, pick the specific vendor's name in the drop-down next to it. This way, other names such as customers won't show.

Before doing so, ensure to select All vendors in the Preferred Vendor first. Here's a sample screenshot from my QBDT test file.

You can always check out the articles given by my colleague above that tackle customizing and saving reports in QBDT, or visit our website for other tips and resources you can use for future reference. Here's the link: Self-help articles.

If you need more help with reports or something else in QuickBooks, just let me know in the comment section below. I'll be happy to help. Have a good one.

Sign up

Login with SSO

Let's get you signed in

Login with SSO