cancel
Showing results for 
Search instead for 
Did you mean: 
OnPoint525
Level 1

Exporting vendor/customer to excel

I've attempted to export my client and vendor lists to excel via "export to IFF". Looks like there is a lot of duplication in resulting excel file that requires a substantial editing - often hours upon hours. Also, QB for mac doesn't allow you to enter client website which is important information for us. Most of my vendors especially require payment online. Is there a specific way to export vendors/clients that relatively clean?

3 Comments 3
qbteachmt
Level 15

Exporting vendor/customer to excel

If you have duplicates in the export, you have duplicates in your QB File; that is the source of what you just Exported. You can Edit the duplicate in QB, rename it to match the original, and it will ask to Merge the names. For instance, Larsen and Larson, if these are different spellings of the same Customer, you merge them.


For website, you can put that into Alt Fax, Alt Phone, edit the address details to see a Notes line, go to Additional Info and set up a Custom Field, even. You also see the actual Notes Function is available for things like this; you can use the Date Stamp function here, as well. For Mac, you also have Contact Sync, to sync to your contacts list, where you can maintain more contact info about customer and vendor names.

Sks1984
Level 1

Exporting vendor/customer to excel

I'm new person export business please help me 

Kirill - CloudBusiness LLC
Level 3

Exporting vendor/customer to excel

Hello,

 

  As a workaround, I suggest you to try this app https://appcenter.intuit.com/b-importer.

 

  Among its features, you'll find Export, which will perfectly suit your needs. The app has free trial, so you can both test it and resolve your issue.

 

  I hope it will save you tons of time!

Need to get in touch?

Contact us