cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

vendor report including expense account default

I want to print a report of all vendors to include the fields from the Vendor Account Settings tab. ie

to display the general ledger expense account that we have assigned to each vendor payment to default to.   Thanks

6 Comments
BRC
Established Community Backer ***

Re: vendor report including expense account default

Is the field available to add when you create one of the vendor list reports?

QuickBooks Team

Re: vendor report including expense account default

Greetings, @BRC and @HF 44,

 

We're unable to pull up a vendor report that includes the expense account assigned in the Vendor's Account Settings. Also, there isn't an option to add this field on any vendors report.

 

The expense account selected will show up in the accounts field when you create a bill.

 

If you need to record your payables in QuickBooks Desktop, feel free to read through this link: Enter bills.

 

If you also need to customize vendor reports based on your business needs, check this out: Customize vendor reports.

 

Should you have follow-up questions, please let me know. I'll get back to you with the information you need.

Established Member

Re: vendor report including expense account default

Really need a solution for this... there should be a way to generate this report.

 

Would like to simply show the Vendor Name, and the 3 auto fill columns - would obviously be blank if there are not any items filled in.

QuickBooks Team

Re: vendor report including expense account default

Hi there, paulcwhite.

 

Thank you for posting here in the QuickBooks Community.

 

Since QuickBooks is unable to automatically generate a report that includes the fields from the Vendor Account Settings tab, I suggest creating a custom report to show this information.

 

You can customize this to the expense accounts associated with the vendor transactions.

 

 

Here's how:

 

  1. Click the Reports tab.
  2. Select Custom Reports, then Transaction Detail.
  3. On the search icon under Columns, make sure to select the Name, Type and Account.
  4. Click the Filters tab.
  5. On the search icon, type or select Account.
  6. On the drop-down arrow under Account, choose Expense and other expense accounts.
  7. Go bank to search icon, then select the Transaction type.
  8. On the drop-down arrow under the Transaction type, select Bill.
  9. Click the OK button.

 

If you want to filter the report to show paid or unpaid bills, you can follow the steps below:

 

  1. Select the Filters tab,
  2. On the search icon, select Paid Status.
  • Close- it means the bill is paid.
  • Open- the bill is not yet paid.
  • Either- both status will show.

 

At this time, this is the workaround we can offer.

 

You can check this article to customize reports based on your business needs and to see purchase orders and sales orders by item: Customize vendor reports.

 

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.​

Established Member

Re: vendor report including expense account default

Thanks for your response, but I do not see how this answers then need to see a list of all vendors and the auto fill expense(s) associated with them???

 

That is the report I need.

 

Then I can know what to update so that I can import credit card charges and have the proper expense account auto populated for charges to the specific vendor.

QuickBooks Team

Re: vendor report including expense account default

Hi @paulcwhite,

 

I understand how useful it is to run a report that includes the expense account associated with the vendor. Running and customizing the Transaction Detail report shared by ChristieAnn is the best report we can consider right now.

 

But I want to let you know that your voice matters and I'm submitting feedback on your behalf. For now, you can visit our blog site so you'll be able to get the latest news about QuickBooks and what our Product Care Team is working on.

 

Please feel free to post any questions you have below. The Community is always here to help out.