Thanks for posting a question here in the Community, @bhiatt20.
Yes, we can create a new company file to separate your personal and business accounts. We'll have to export and import the data from an existing company file.
First, let's create a new company file for your preferred account. Here's how:
- Go to the File menu, and then choose New Company.
- On the pop-up window, select Express Start if you want to get started right away or pick Detailed Start if you wish to do a complete setup of all info from the start.
3. Then, follow the onscreen steps to finish the setup.
Also, create a different name for your new company file. This way, QuickBooks Desktop won't accidentally override your data.
Once done, let's export your data to Excel. To export customer, vendor, and payroll lists, here's how:
- Open the Customer/Vendor/Payroll center.
- Select Excel drop-down ▼ and choose Export Customer/Vendor/Employee list if you want to export data such as name, balances, and contact information. However, choose Export Transactions if you want to export them either by name or transaction type.
- In the Export window, pick whether to create a new worksheet or update an existing worksheet.
- Click the Export button. Then, edit the info in Excel as needed.
Then, let's import them to your new company file. I'll guide you with the steps:
- Go to the File menu, and then select Utilities.
- Click Import, and then Excel Files.
- If you get the Add/Edit Multiple List Entries window, pick No.
- Follow the wizard in the importing file.
Please refer to this article for more details about the steps above:Export and import data to QBDT.
You may want to visit our QuickBooks App store to check for some suggested apps that can help you with editing and importing your files: https://desktop.apps.com/home.
Please let me know if you have more questions about managing your data or anything else related to QuickBooks. I'll be here to help you. Take care and stay safe.
