We have been doing vendor imports for all of our patient refunds and I just noticed a problem.  Since we want the check to be made out to "John Brown" that is the column that is imported.  However, although the checks come out correctly, the Vendor Name also says "John Brown" and not "Brown, John" as we would want it to be. 

I want all the vendors to be able to be sorted alphabetically, but with this problem, we have numerous vendors starting with their first name instead of the last name.

FIRST QUESTION:  Can anyone suggest an easy way to correct this?  We have too many to do this project one at a time.  Can I do an export, correct the names in Excel, and then reimport?  Will this work?

SECOND QUESTION: I cannot find a way to change the Vendor Import to have two columns, one for Vendor Name (Brown, John), and one for Check Name (John Brown).  Can anyone tell me how I can do this?

Thanks so much!

Cynthia S.