Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 27, 2023
Solved

How do I change a customer to a vendor in QuickBooks Online?

  • March 27, 2023
  • 3 replies
  • 54 views

I am an accountant that has access to my client's QBO.  While reconciling their credit card report, I noticed that one of their Vendors is set up as a Customer. I know that you cant edit a customer to a vendor, but how do I transfer all the expenses posted to this "Customer" to the Vendor I am creating. This person should have never been a customer in the first place. There are 121 expenses to transfer over, I do not want to open them 1 by 1 and change the payee. I also want to add this goes back to at least 2019 if not before. 

Thank you,

Best answer by cody_a

You can move those transactions over, but you'll need to create a new vendor profile first since QuickBooks Online won't let you convert an existing customer name directly into a vendor.

Why this happens

QuickBooks Online keeps customer, vendor, and employee names unique across your company so your reports, checks, and transactions don't get crossed up. That's the reason a name can't just switch categories on its own, even when it's clearly been entered under the wrong list.

Steps to move the transactions

  1. Create the new vendor. Go to Expenses & Bills, then Vendors, and select New Vendor. Give it a name that's at least one character different from the customer name (for example, "John J. Doe" instead of "John Doe").
  2. Pull every transaction tied to the customer. Run a Transaction List by Customer report for that name. This lists every expense in one place so you're not hunting through your books one at a time.
  3. Reassign each transaction. Open each one from the report, change the payee to the new vendor name, and save.
  4. Delete the old customer name once every transaction has been moved over.
  5. Clean up the vendor name if you want to drop the extra character now that the original customer name is gone.


This works the same way whether you're catching up a handful of transactions or well over a hundred going back several years. Running the report first is what saves you from opening each transaction blind.

Check out this article for more: Move names between Customer, Vendor, and Employee lists in QuickBooks Online

If any of the transactions are trickier, like ones that already have payments applied, drop a reply and we'll help sort those out too.

 

3 replies

QuickBooks Team
March 27, 2023

Hello there.

 

I recognize how important this option is inside QuickBooks Online (QBO). However, the feature you're trying to access is unavailable. Know that to move existing expenses from Customers to Vendors. You'll need to open those transactions and change the payee inside them.

 

 Also, you can refer to this page to learn more about changing a customer to a vendor inside the program: Moving names from one list to another.

 

After transferring those expenses to your newly created vendor, you'll want to make the customer inactive to avoid confusions. I'll input the steps below to get you going. To begin, these are the steps:

 

  1. Access your QuickBooks Online company.
  2. On the left navigational bar, Go to Get paid & pay or Sales.
  3. Click Customers, and then select the customer's name to open their profile.
  4. Click the dropdown ▼ next to Edit.
  5. Select Make inactive. Then confirm by selecting Yes, make inactive.

 

For further guidelines, please see this article: Add and manage customers in QuickBooks Online.

 

Moreover, here's an article about modifying reports and adding details to it inside QBO: Customize reports in QuickBooks Online.

 

I appreciate you for dropping by here today. Please don't hesitate to leave a comment below if you need assistance accomplishing QuickBooks-related tasks. I'll be here, ready to help syou. Stay safe!

March 29, 2023

I appreciate your detailed reply. Unfortunately, the solution you described is exactly what I didn't want to do. Again, as I am their new accountant, I don't have permission to spend their money/my time on this and was looking for a quicker solution - which you said was impossible.  I'm not the only person that has had this issue arise. Please pass this along to the R&D team to add this feature to a future update.

Thank you,

cody_a
cody_aCommunity ManagerAnswer
Community Manager
August 20, 2026

You can move those transactions over, but you'll need to create a new vendor profile first since QuickBooks Online won't let you convert an existing customer name directly into a vendor.

Why this happens

QuickBooks Online keeps customer, vendor, and employee names unique across your company so your reports, checks, and transactions don't get crossed up. That's the reason a name can't just switch categories on its own, even when it's clearly been entered under the wrong list.

Steps to move the transactions

  1. Create the new vendor. Go to Expenses & Bills, then Vendors, and select New Vendor. Give it a name that's at least one character different from the customer name (for example, "John J. Doe" instead of "John Doe").
  2. Pull every transaction tied to the customer. Run a Transaction List by Customer report for that name. This lists every expense in one place so you're not hunting through your books one at a time.
  3. Reassign each transaction. Open each one from the report, change the payee to the new vendor name, and save.
  4. Delete the old customer name once every transaction has been moved over.
  5. Clean up the vendor name if you want to drop the extra character now that the original customer name is gone.


This works the same way whether you're catching up a handful of transactions or well over a hundred going back several years. Running the report first is what saves you from opening each transaction blind.

Check out this article for more: Move names between Customer, Vendor, and Employee lists in QuickBooks Online

If any of the transactions are trickier, like ones that already have payments applied, drop a reply and we'll help sort those out too.