Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
P
Plink
February 24, 2021
Question

1 Vendor - Several Acct #'s

  • February 24, 2021
  • 3 replies
  • 7 views

I have several account numbers associated with 1 vendor.  I am trying to figure out how to enter these account numbers to print on a vendor report WITHOUT having to enter the vendor 5 times for 1 account number each.  Anyone have any ideas??  I thought I could just add them under "additional info" as a NOTE to print but...nope.  Any thoughts?

3 replies

MariaSoledadG
MariaSoledadGQuickBooks Team
QuickBooks Team
February 24, 2021

Let me add some information about running a report for your vendor, Plink.

 

Are you trying to run a report that will give you the vendor and account number information? If so, what specific report are you trying to generate?

 

Generally, once you've already entered and saved a vendor name in QuickBooks Desktop the information will remain. You may need to re-enter the same vendor, however, you'll have the option to select the name automatically on the field as the information was already saved without having you type all the words or letters again.

 

You'll want to export reports to excel and enter additional information from there such as account numbers by copying and pasting. To do this, follow the steps below:

  1. Open the report you want to export.
  2. Select the Excel drop-down at the top of the report, then select Create New Worksheet or Update Existing Worksheet.
  3. In the Send Report to Excel window, choose what you'd like to do with the report.
  4. Select the Advanced button to see other available options for the exported report then select OK. To ensure the exported report will show Header information

    If you are using a newer version of MS Excel and the exported report does not show header information, go to the Printing options section and make sure the On Printed report and screen option is selected.

For more information on what else you can import or export using MS Excel files, please read the article for detailed steps and information.

 

If there's anything else that you want us to help you with running reports, please let me know so I can get back to you. Stay Safe!

 

P
PlinkAuthor
February 25, 2021

I appreciate the response and am familiar w/ your instructions but allow me clarify;

 

I have several accounts for 1 vendor.  I don't want to have to enter the vendor 6 times for each account, seems ridiculously redundant.  What I am trying to find out is if there is a way I can enter all 6 accounts numbers (separating them w/ a colon, semi-colon, whatever....just to account for every account number w/ said vendor) into a particular field and be able to choose this field to print on the report without having to export into Excel.  The method you describe, if I understand correctly, would mean every time I need to print said report and export it to excel (if I had to), I would have to manually enter each account # every time?  I can't put the account numbers into the NOTE field because what if there is more than 1 note? (Provided I could even access this field to print via customizing the report), and there is no "note" area in the ADDITIONAL INFO tab when entering a new vendor.  It truly just seems ridiculous to have to enter a vendor 6 times to account for each account number w/ said vendor.  We are property management company and several of our properties have several buildings at 1 locations, thus, every building has its own set of account numbers but just 1 vendor.  Just looking for a way to enter ALL account numbers under the 1 vendor to which they apply.  Thanks

C
Candice14
Level 8
February 25, 2021

Good morning, @Plink. 

 

Thanks for reaching back out to the Community. Allow me to give you some information about vendors with multiple account numbers. 

 

The details that my colleague provided is the only way to associate all of the account numbers to one vendor. However, I'll send feedback to our Product Developers so they can consider this in one of the upcoming releases. They regularly review customer-submitted feedback and tries to collaborate them into the next available update for the product. 

 

Cruise on over to our QuickBooks Blog to keep up with what's new in the product. We try to improve our system to help every user of QuickBooks. 

 

Let me know if you have any other feedback about our system. I want to ensure that you're able to get back to running your business as soon as possible. Should you need any further assistance, feel free to ask. I'm always here to lend a helping hand. Have a great day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement