Add Suppliers to QuickBooks
Don't have QuickBooks Online?
Open step-by-step instructions
Read step-by-step instructions
Import suppliers from a spreadsheet
Import a supplier spreadsheet
In the Supplier list, click Import suppliers.
Organise Your Spreadsheet
Organise your spreadsheet to match the format of the sample below. Make sure your column titles and the order of your columns match our example.
You can download this sample file here.
Choose Your File
On the Import Supopliers page, click Browse. Select your file and click Open.
Choose Your Excel Columns
For every QuickBooks field, choose one of your Excel columns and that data will be imported into the corresponding QuickBooks field. Click Next.
Check off all of your suppliers. Click Import. Now you can access all of your suppliers in QuickBooks.
Add a new supplier
Click New Supplier
Go to the Suppliers list and click New supplier.
Fill out the supplier form
Fill out the form as needed. The only required field is the Display Name.
Locate Businesses in Your Area
If you want QuickBooks to find all of the local businesses in your area, go to the gear menu and click QuickBooks Labs.
Choose the Autocomplete widget
Choose the Autocomplete widget and the next time you enter a supplier (or customer) name in QuickBooks, it will suggest businesses in your area.