What happens when a vendor becomes a customer? You get to make sales from someone who you usually owe money!
Unfortunately, QuickBooks (Online and Desktop) has limitations when it comes to duplicate account names – you can only enter a person’s name once, even if they are on separate lists. One name, one account.
This duplicate name restriction applies to your customer, vendor and employee lists, as community member @yopotransport discovered trying to change a regular employee account into an independent contractor (“vendor”) account with the same name.
Don't let this deter you from growing your network!
There are several simple workarounds for this minor technical setback so you can create separate accounts and track separate expenses for anyone who is a vendor and a customer (or some other combination). Keep in mind, the display name is what the invoice recipient actually sees on an invoice or email – what we’re solving for is the internal database limitation.
My preferred method is to leave the vendor account entry as is and add a (c) to the “suffix” field of the customer name. This way, at a glance, I know exactly which account I am dealing with. Adding the (c) to the suffix, rather than the title or name data fields, also ensures the name still shows up alphabetically on my Customer List.
These methods work, but without the context of lists, they may cause confusion or introduce unnecessary complications on reports or emails.
Simply go to the Sales Tab, edit your customer's profile and add the (c) to the suffix data field. Then, go to the Expense Tab and create the new vendor account.
Remember, once you’ve set up multiple accounts for a single individual, treat them as separate accounts – don’t mix different types of transactions.
If you have your own method that works, keep using it -- make your QuickBooks work for you!
What's your experience?
Do you have customers who have become vendors? Are there any challenges or opportunities when someone is both?
I would disagree with the concept of adding or changing anything to a vendor name.
You never know when the IRS is going to change something that affects the vendors and reporting. Vendors you do not issue a 1099 to now, might need a 1099 in the future, or some other form.
Modify the customer name only.
IMO the simplest is to add a period after the first or last name, hardly anyone notices it when it appears on an invoice or sales receipt or even a report
That's a good point. In cases when you have to issue 1099s, it can get complicated. It's simple enough to change the method around for customers. Thank you for the feedback.
Adding a period is a good method.
Yes talking from the perspective of Order postings thru applications like eCC/ Unify Desktop we come across same problem which in more technical language of QuickBooks is called " List element already in Use". This error usually comes in when customer name is also present in vendor list or other names list. So the generic answer we provide is same as what you have suggested to add a dot [.] or any other character in the vendor name list or other name list and then try to post the Order again.
I have recently taken over QB for a company. They have customers that are also vendors in 2018 but never differentiated the accounts. So when I view a customer income report it also has the vendor payments applied and the report ends up negative. If I use your recommend to "c" in suffix, how do I create a vendor account and then transfer the payments made to the vendor account?
Thank you for reaching out. How far back do these transactions go? If it is more than a year, I would recommend leaving things as they are - the accounting was done based off of the existing data and they need to match the income figures on the filed taxes.
If you know for certain which go to the customer and vendor account, if there are no bills (i.e. open to-be-paid transactions using the existing account), it should be safe to create the separate vendor account and transfer the expenses. Don't touch any of the customer-facing transactions, especially for anything that's on an open invoice.
Hi James, they are in the first quarter of this year, but Fiscal year ended Aug 31. I guess I'll leave them and set up vendor accounts in January. Thx for the quick response.
Is there a way to display/search all the vendors that share very similar names with customers?
I'm working in a company file with where there are several people that are both customers & vendors, with slightly different versions of their names for each, and occasionally a transaction is assigned to the wrong one. This happened once with a vendor that receives a 1099, and it wasn't showing properly because one of the payments was incorrectly listed under the customer version of the name, and its something I need to doublecheck before creating 1099s.
So any kind of report that could list all customer/vendor/othernames that share a first name or share a last name kind of thing?
Hi there, @TaxCatSC.
Welcome to the Community family. Allow me to share some information about searching all the vendors that share very similar names with customers in QuickBooks Online.
Currently, the option to search all the vendors that share very similar names with customers in QuickBooks Online isn't available. You can only search multiple names by transaction. I can see how this feature would be beneficial to your business. I encourage you sharing this idea to our Product Developers. Doing this helps them to assess how we can improve our product and determine what features need to be added in future updates. You can do this by clicking on the Gear Icon and select on Send Feedback Online.
Also to be updated about our latest happenings, updates, and features, I'd recommend checking out our QuickBooks Online Blog. Through this, you're able to know the recent news about QuickBooks Online and what our Product Care Team is working on.
In case you need additional assistance, feel free to reach out to our Customer Care Team. You can reach through this contact details:
Please let me know if there's anything else I can do to help. I'll do my best to provide further assistance. Happy weekend!