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

Can you export data for customers to include invoices and balances into new entity. Moving from Sole Proprietor to a new entity S Corp.

 
2 Comments 2
Rea_M
Moderator

Can you export data for customers to include invoices and balances into new entity. Moving from Sole Proprietor to a new entity S Corp.

Let me share details about exporting customer data when moving to a new entity in QuickBooks Online (QBO), @dsjsales.

 

You're able to export your existing customer list from your current entity (Sole Proprietor) and manually import it to the new one (S-Corp). However, their invoices and balances won't be included.

 

You'll first have to export your list report to Excel. To do this, here's how:

 

  1. Sign in to the account (Sole Proprietor entity) that has your customer list.
  2. Go to Business overview and select Reports.
  3. Search for Contact List report.
  4. Customize the list report's columns.
  5. After saving your report, export it.
  6. Open the exported report in Excel.
  7. Delete rows 1-4 to remove your company name and report title from the sheet.
  8. Save your report again as Excel or CSV.

 

Once you're done, import your customer contact lists from Excel to your new entity. For the complete details, please see this article: Import customers from email contacts to QuickBooks Online.

 

For the step-by-step guide, you can also refer to this article: Move your lists to QuickBooks Online.

 

Also, changing the business entity can affect legal protections, tax savings, and ownership requirements. To know more about entity changes, I'd recommend checking out these articles: 

 

 

Please let me know in the comments if you have other concerns about managing customers' data and sales transactions in your new entity using QBO. I'm always ready to help. Take care, and I wish you continued success, @dsjsales.

Fiat Lux - ASIA
Level 15

Can you export data for customers to include invoices and balances into new entity. Moving from Sole Proprietor to a new entity S Corp.

@dsjsales 

You can utilize a migration tool if required.

https://transactionpro.grsm.io/qbo

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us