Skip to main content
October 8, 2023
Solved

Moving from 1800Accountent to QBO

  • October 8, 2023
  • 1 reply
  • 0 views

I'm in the process of moving from 1800Accountant to Quickbooks Online. Does anyone have any experience with moving the Chart of Accounts over? Doing it one item at a time is driving me insane.

Best answer by AileneA

Hello, funjugmedia. I am pleased to offer my assistance in importing your Chart of Account from 1800 Accountant to QuickBooks Online. It would be my pleasure to guide you through the process.


When it comes to moving your chart of accounts to QuickBooks Online can be done in a group. We can use the import data feature that allows you to transfer your data at once. To get started, you can reach out to 1800 Accountant and request to export your financial data, which includes your chart of accounts, customer and supplier details, opening account balances, and any other relevant data. Once you have all this information, you can proceed with the import process in QuickBooks Online.

 

Although migrating your data can seem overwhelming, QuickBooks provides helpful tools and resources to make it easier. One important thing to keep in mind is the supported format for your data. It's recommended that you use a spreadsheet in Excel, Google Sheets, or a CSV file when importing your chart of accounts. This will ensure your data is appropriately formatted and easily integrated into QuickBooks Online.

 

Overall, the process of moving your chart of accounts to QuickBooks Online is easy with the right tools and resources; it can be done smoothly and efficiently. Just be sure to follow the recommended guidelines and format your data correctly before importing it into QuickBooks Online.

 

Here's how:

 

  1. Sign in to QuickBooks Online.
  2. Click the Gear icon. Then select Import Data.
  3. Choose Chart of Accounts.
  4. To upload a file from your computer, tap Browse and choose the file. Then hit Open.
  5. Or, to upload from Google Sheets, press Connect to sign into your Google account. Pick the correct file, and then Select.
  6. Hit Next.

 

 

 

Once you've completed the data import process, thoroughly reviewing your information in QuickBooks Online is important. This step is necessary to ensure that all data has been accurately transferred and that no errors have occurred during the migration. It's also advisable to reconcile your accounts to ensure the balances match up. This will give you peace of mind that your financial records are accurate and up-to-date. After successfully migrating and setting up everything in QuickBooks Online, you can start using the platform to manage your accounting and financial tasks easily and efficiently. 

 

Also, I just wanted to give you a heads-up about some limitations you may encounter when migrating your data to QuickBooks Online. While the process can be relatively smooth, it's important to keep in mind that not all data may transfer over seamlessly.

 

One thing to note is that certain custom fields or data types may not be supported, which means that you may need to recreate them within QuickBooks Online. Additionally, it's possible that some formatting or data structures may not carry over exactly as they were in your previous system. This can require some manual adjustments to ensure accuracy and consistency in your data. For more details about it, please check out this article: Import your chart of accounts to QuickBooks Online

 

Let me share some resources to manage and navigate your QuickBooks account. Here are a few options that you might find helpful:

 

  • Video Tutorials for QuickBooks Online - You can watch videos that can help you perform the most vital features of the program.
  • Small Business Webinars and Trainings - QuickBooks offers a variety of training resources, including online courses and live webinars. These can be a great way to learn more about using QuickBooks and managing your finances. 
  • QuickBooks Community - This is a great place to connect with other QuickBooks users and get answers to your questions. You can search the community for topics related to your specific needs.

 

If you have any further questions or concerns regarding importing your data to QBO, please feel free to let me know. I'm here to assist you in any way that I can. Have a great day!

1 reply

Fiat Lux - ASIA
October 8, 2023

You can buy a 3rd party conversion service. Another option, export your data out and prepare it in xls or csv file format. Then you can use an importer tool to proceed.

https://get.transactionpro.com/qbo

 

AileneAAnswer
October 8, 2023

Hello, funjugmedia. I am pleased to offer my assistance in importing your Chart of Account from 1800 Accountant to QuickBooks Online. It would be my pleasure to guide you through the process.


When it comes to moving your chart of accounts to QuickBooks Online can be done in a group. We can use the import data feature that allows you to transfer your data at once. To get started, you can reach out to 1800 Accountant and request to export your financial data, which includes your chart of accounts, customer and supplier details, opening account balances, and any other relevant data. Once you have all this information, you can proceed with the import process in QuickBooks Online.

 

Although migrating your data can seem overwhelming, QuickBooks provides helpful tools and resources to make it easier. One important thing to keep in mind is the supported format for your data. It's recommended that you use a spreadsheet in Excel, Google Sheets, or a CSV file when importing your chart of accounts. This will ensure your data is appropriately formatted and easily integrated into QuickBooks Online.

 

Overall, the process of moving your chart of accounts to QuickBooks Online is easy with the right tools and resources; it can be done smoothly and efficiently. Just be sure to follow the recommended guidelines and format your data correctly before importing it into QuickBooks Online.

 

Here's how:

 

  1. Sign in to QuickBooks Online.
  2. Click the Gear icon. Then select Import Data.
  3. Choose Chart of Accounts.
  4. To upload a file from your computer, tap Browse and choose the file. Then hit Open.
  5. Or, to upload from Google Sheets, press Connect to sign into your Google account. Pick the correct file, and then Select.
  6. Hit Next.

 

 

 

Once you've completed the data import process, thoroughly reviewing your information in QuickBooks Online is important. This step is necessary to ensure that all data has been accurately transferred and that no errors have occurred during the migration. It's also advisable to reconcile your accounts to ensure the balances match up. This will give you peace of mind that your financial records are accurate and up-to-date. After successfully migrating and setting up everything in QuickBooks Online, you can start using the platform to manage your accounting and financial tasks easily and efficiently. 

 

Also, I just wanted to give you a heads-up about some limitations you may encounter when migrating your data to QuickBooks Online. While the process can be relatively smooth, it's important to keep in mind that not all data may transfer over seamlessly.

 

One thing to note is that certain custom fields or data types may not be supported, which means that you may need to recreate them within QuickBooks Online. Additionally, it's possible that some formatting or data structures may not carry over exactly as they were in your previous system. This can require some manual adjustments to ensure accuracy and consistency in your data. For more details about it, please check out this article: Import your chart of accounts to QuickBooks Online

 

Let me share some resources to manage and navigate your QuickBooks account. Here are a few options that you might find helpful:

 

  • Video Tutorials for QuickBooks Online - You can watch videos that can help you perform the most vital features of the program.
  • Small Business Webinars and Trainings - QuickBooks offers a variety of training resources, including online courses and live webinars. These can be a great way to learn more about using QuickBooks and managing your finances. 
  • QuickBooks Community - This is a great place to connect with other QuickBooks users and get answers to your questions. You can search the community for topics related to your specific needs.

 

If you have any further questions or concerns regarding importing your data to QBO, please feel free to let me know. I'm here to assist you in any way that I can. Have a great day!

October 8, 2023

Thank you. Will reach out to them now. We aren't having the most amicable of breakups, so hopefully they will help.