and now we will learn how to manage and import vendor data the vendor Center behaves exactly as
the Customer Center does all features available for clients customers are also available in the
vendor Center for vendors as well both windows allow you to add and edit multiple list items
at once this means if we have a long list of vendors we don't have to type it in one-by-one
with their name and address every single time we can basically copy and paste this whole
piece right into the vendor Center in QuickBooks and we could have done that with the customer
center as well if you use the feature for add or edit multiple list items first to open the
vendor Center you click from the main menu vendor vendor Center now again you have the
same two tabs with the same features available but instead of clicking new vendor you're going
to click add multiple vendors by the way this feature is also available in the customer center
but just follow along add multiple vendors now this sheet looks just like an Excel spreadsheet
and you really could just take all of your vendor information highlight it assuming it was laid out
in Excel in this format copy and then paste it right into here with the little warning message
there and then you would update all your vendor records from Excel into QuickBooks but there's
only one little catch you can batch import your vendor list and this would be the way to
do it but you must line up the columns before you copy and paste so if we take a look here
we see that the vendor name and the company name we can get rid of company name and get
mrs. and middle initial and last name and if we scroll over we would get things like address but
basically we just we want name and address so this button here allows you to customize the
columns and here all the columns that are already there and here are the ones that we would like to
add I think we should remove everything except address and you could play around with this
feature until your columns here match the columns in Excel so let's just get rid of everything else
except address last name phone fax email so we'll click down here and we'll click remove remove oh
we don't want to remove address or address too but we do want to remove these remove remove remove
remove remove so that all the address lines are left then when we click OK we have the name and
we have places for address this would line up with the Excel spreadsheet then all you have to do is
highlight by clicking on the first name in the top left click and drag to whatever data you want to
copy in then in Excel you click copy then you can come back to QuickBooks come to the top left here
click right click paste and it lines up the data in QuickBooks exactly the way it was in Excel when
you save the changes click OK you can now see that you have six vendors on your vendor list and every
time you have a transaction with them it will show up here so if you have a transaction with ups that
you want to find you would open the vendor Center click on UPS click around here and see the result