Convert Simply Accounting to QuickBooks

Convert Simply Accounting to QuickBooks
  • August 30, 2022

Simply Accounting to QuickBooks migration is a relatively straightforward process thanks to Intuit's numerous solutions that can help you out. You can find the necessary solutions on this page if you've already made the decision to switch from Simply Accounting to QuickBooks.

The QuickBooks conversion tool may be trusted to transfer your data from Sage 50 (formerly Simply Accounting) to QuickBooks. Most of your accounting information is transferred automatically via the conversion tool, notably the most crucial information. Before converting your data you should clean up unwanted files and entries in QuickBooks Desktop.

In this post, you’ll learn how to convert Simply Accounting to QuickBooks Desktop.

Steps to Migrate Data from Simply Accounting to QuickBooks

Using the QuickBooks conversion tool, you can convert the data for Simply Accounting 2015 and later to QuickBooks Desktop data. However, you cannot use this tool to convert the data for versions older than 2015. For the older versions, you have to rely on the manual method of migrating data from Simply Accounting to QuickBooks Desktop.

Step 2: Data that can be converted from Simply Accounting to QuickBooks:

  • Transactions for vendors and customers.
  • Vendor, customer, employee, item, and account lists.
  • Account balances.
  • Employee profiles.
  • Paycheck information in Journal Entry format.
  • Information general ledger account balance.

Data that cannot be converted from Simply Accounting to QuickBooks

  • Closed Purchase Orders, Sales Orders, and Estimates.
  • Payroll deductions for Social Security and Medicare insurance.
  • Fixed assets.
  • Work tickets.
  • Hourly and salary payroll items.
  • Deductions from wages of employees and contractors.

Additional information about Simply Accounting data that you need to note when converting to Quickbooks Desktop:

  • QuickBooks desktop supports charts of account numbers only up to 7 digits. If any account number in Simply Accounting is more than 7 digits, then make the required correction, or the conversion process will fail.
  • All Simply Accounting transaction data - despite the currency that it is recorded in - is recorded in QuickBooks in the home currency.
  • Not all reversing journal entries are recorded in QuickBooks from Simply Accounting.
  • You should verify the transactions after the conversion process to make sure that the data has been transferred accurately.

Step 2: Get ready to move your data to QuickBooks Desktop

You ought to set up a few items to utilize the conversion tool to transfer your records from Simply Accounting to QuickBooks desktop. The following items should be completed before translating your financial information:

  • Installing and activating the QuickBooks desktop will migrate the data immediately into a new company file that is compliant with the QuickBooks desktop. You won't be able to validate the conversions of your accounting data if the application isn't installed on your computer.
  • Keep your financial data on your local hard drive so you can use the QuickBooks conversion tool on it. Don't keep your financial data on a different server. Rather, move it to your local device.
  • Take a backup of your Simply Accounting financial information using the instructions below to ensure that you have a record of your financial information even if something were to happen to the primary company file.
    • Launch Simply Accounting.
    • Click on File, then Back Up.
    • Choose the option to Include Company Name so that the backup file’s name describes the data that it stores.
    • Click on Include Archives, especially if you’ve used Simply Accounting to file taxes online.
    • Click on Include Attachments. This prevents the loss of any documents that you may have attached to transactions in Simply Accounting.
    • Click on Backup.
    • Choose the appropriate directory and click on Save, then OK.

You’re now ready to convert all of your Simply Accounting data to QuickBooks desktop data.

Step 3: Configure Simply Accounting for data migration to QuickBooks Desktop

Setting up preferences in Simply Accounting is essential for migrating data to Quickbooks Desktop. After configuring the data, you can use the conversion tool to migrate data from Simply Accounting to QuickBooks for PC.

Here are the steps to configure Simply Accounting for QuickBooks data conversion:

  1. Simply Accounting should be opened, and the company file holding the data you want to transfer should be selected.
  2. From the main menu, select Maintain, then choose Set up Security after selecting Users.
  3. Select the With the following login information option after clicking the Data Access/Crystal Reports tab.
  4. To subsequently authenticate data conversion, choose to modify and then provide a new password.
  5. To save the new password, click on OK.

You’ll need the password that you created here to complete the conversion process. When you choose the Simply Accounting company file in the conversion tool, you will have to enter a password to authenticate the conversion of data.

Step 4: Load the QuickBooks conversion tool

Intuit offers the QuickBooks conversion tool, which is available and can be used without cost. To grant this application the necessary access level to modify files on your machine, you can install it on your computer and execute it as an operator.

You can download and install the QuickBooks conversion tool by following the steps below:

  1. Download the QuickBooks conversion tool.
  2. Locate the icon for the QuickBooks conversion program when you open the downloaded file.
  3. When you do right-click on an icon, select Properties.
  4. Select Windows 8 under "Run this software in compatibility for" on the Compatibility tab.
  5. Mark the "Run as Administrator" checkbox. Select "OK."

Now that the gadget is ready for usage. The financial data processing may be started by simply linking it to QuickBooks and Simply Accounting.

Step 5: Start the conversion process

Now let's talk about the conversion procedure. You must select the database that has your financial information in this step for the conversion tool to be capable of extracting it and using it to generate a new company file.

Here are the steps to convert your Simply Accounting data to QuickBooks desktop data:

  1. After completing the prior action, launch the Conversion tool.
  2. Select Browse.
  3. Select the QuickBooks Desktop conversion for the Simply Accounting company file that you wish to use.
  4. Select your company file from the drop-down menu after clicking on the database name.
  5. You must go through the database's company files to select the one you wish to convert to QuickBooks Desktop if it has numerous company files.
  6. When configuring the Simply Accounting application in Step 3, you had to enter the password you had previously set. Select Next.
  7. Select the edition and version of QuickBooks.
    The year is indicated by the version; for example, QuickBooks Desktop 2022. One of Pro, Premier, or Enterprise is the edition.
  8. To select a directory to save the transformed data file to, click Browse.
  9. After reviewing your selections, click Convert File.
  10. Permit QuickBooks to view the file when it starts up automatically.
  11. QuickBooks will ask you whether you want to continue after you click Yes for each certificate.

The conversion process won't stop until all of your Simply Accounting data that can be imported into QuickBooks Desktop has been converted. The tool will notify you when the procedure is finished.

At the end of the transformation procedure, select Open in QuickBooks. Once QuickBooks has launched, you can check your data after conversion.

Step 6: Verify the converted data

You should check the transformed data when the conversion procedure is complete to ensure that your books remain accurate. This can be accomplished by looking through the unsuccessful transaction log and producing data like balance sheets.

Here are the steps to view the failed transaction log for Simply Accounting to QuickBooks conversion:

  1. Launch the File Explorer from the Start menu.
  2. Open the directory C:\USERS\[Username for windows account]\My Documents\Intuit\QuickBooks.
  3. Open the Failed Transaction Log file in the directory.

The log will contain a list of every operation that Simply Accounting did not import into QuickBooks. These trades can be entered manually into QuickBooks, or you can transform the data once more by using the same process. Users frequently make errors when they omit some of the aforementioned procedures.

If the process fails, then you’ll get one of the following error messages:

  • “It looks like something went wrong”
    • It's possible that the Simply Accounting company file isn't kept locally. Make a copy of the company file in this situation and store it on the computer's hard drive.
    • You didn't alter the title of your Simply Accounting company file to eliminate special characters, and you named the transformed QuickBooks file with a special character.
    • To finish the transfer to QuickBooks, there is an internal problem in your Simply Accounting company file that needs to be corrected.
  • “We just need a little more info”
    • Users who fail to configure the conversion tool's interoperability setting frequently receive this notice. The identical Step 4 - loading the QuickBooks conversion tool - has been defined.

To confirm the accuracy of your translated data, you can also produce reports like a balance sheet.

You can use QuickBooks Desktop and the procedures below to construct a balance sheet:

  1. From the main menu, select Reports.
  2. Tap Company & Financial.
  3. Select Balance Sheet Standard by clicking.
  4. Select the date as of. (You can choose the date of today.)

The balance sheet summary is now accessible. You must manually update the remaining operations in QuickBooks if the net assets do not equal the total equity and liabilities.

Manually Converting transactions and lists from Simply Accounting to QuickBooks Desktop

The majority of your data from Simply Accounting can be transferred using the QuickBooks conversion tool, but because of the conversion tool's limitations, many categories and activities might not be transferred. The payments must then be individually converted by being exported from Simply Accounting in CSV file format and imported into QuickBooks desktop.

Migrate vendor lists from Simply Accounting to QuickBooks Desktop

Steps to export the vendor list in CSV format from Simply Accounting to import into QuickBooks:

  1. Launch Simply Accounting.
  2. Select Reports from the menu.
  3. Click Vendors, then OK Lists.
  4. The vendor lists you want to export should be selected.
  5. Please take note that selecting "select all" will allow you to select every list that is shown.
  6. Select "OK."
  7. Click on File and then Export once Simply Accounting has generated the Vendor List Report.
  8. To export the vendor list in CSV format, select the directory.
  9. Select Save.

You can choose which vendor lists from Simply Accounting to export. The location you specified in Step 7 contains the CSV file containing the vendor lists from Simply Accounting.

Before starting the QuickBooks desktop vendor list transfer from Simply Accounting, you must open the CSV file in Excel and modify the fields to convert the data to a style that QuickBooks desktop can import.

Our QuickBooks professionals can assist you if you have trouble with this process.

Steps to import vendor lists in CSV format from Simply Accounting to QuickBooks Desktop:

  1. Download QuickBooks Import Excel CSV toolkit.
  2. Click on Save after deciding where you want to save the application.
  3. QuickBooks_Import_Excel_And_CSV.exe should be double-clicked.
  4. Select Browse, then search for the location where you want to transfer the toolkit's files.
  5. Wait for the extraction method to be completed before selecting OK.
  6. Open the Toolkit, and then import the files by following the on-screen directions.
  7. Select the list of vendors that were exported from Simply Accounting.
  8. Pause for the data to import into QuickBooks.

You’ve now successfully imported the CSV file containing vendor details into the QuickBooks desktop.

Migrate customer lists from Simply Accounting to QuickBooks Desktop

Steps to export the customer list in CSV format from Simply Accounting to import into QuickBooks:

  1. Launch Simply Accounting.
  2. Select Reports from the menu.
  3. Select Customers after clicking OK Lists.
  4. The customer lists you want to transfer can be chosen.
  5. Please take note that selecting "select all" will allow you to select every customer list that is offered.
  6. Select "OK."
  7. Click on File, then Export once Simply Accounting has generated the Customer List Report.
  8. Select the directory to which you want to export the CSV-formatted customer lists.
  9. Select Save.

Simply Accounting will export all the customer lists that you chose. The CSV file that you export from Simply Accounting can be found in the location that you chose to save the file in.

You must open the CSV file in Excel and modify the columns before you can start importing customer lists from Simply Accounting into the QuickBooks desktop. This is necessary to ensure that the data is in a format that QuickBooks desktop can import.

Our QuickBooks specialists can assist you if you find this process challenging.

Steps to import vendor lists in CSV format from Simply Accounting to QuickBooks Desktop:

  1. Download QuickBooks Import Excel CSV toolkit.
  2. Then click Save after selecting the folder where you need to save the application.
  3. On the QuickBooks_Import_Exceland_CSV.exe screen, double-click.
  4. To unpack the files for the toolbox, choose Browse then choose the folder.
  5. Wait for the extraction to be finished before clicking OK.
  6. Start the Toolkit, then import the files as directed on the screen.
  7. Select the Simply Accounting export of the Customer List CSV file.
  8. Hold off until QuickBooks imports the data.

You’ve now successfully imported the CSV file containing customer details into the QuickBooks desktop.

Migrate chart of accounts from Simply Accounting to QuickBooks Desktop

You can import the chart of accounts you established in Simply Accounting into the QuickBooks desktop rather than creating a new one from the beginning. You must rely on the chart of accounts to accomplish this. The data is exported in CSV format so that it can be easily imported into QuickBooks.

The export CSV file contains the following details about each account in your chart of accounts:

  • Category
  • Ledger Name of the account
  • Nominal code
  • Tax rate
  • Control account
  • Visibility

To integrate the CSV file straight into QuickBooks after exportation, you must alter it.

Note: Only account number charts with up to 7 digits are supported by QuickBooks. Any account that violates this restriction should have its details changed.

Steps to the export chart of account in CSV format from Simply Accounting

  • Select "Business settings" from the options menu.
  • The Chart of Accounts option is found in the Financial Settings area.
  • Then select Export Accounts.
  • Choose the CSV option from the available list.

You’ll be notified by Simply Accounting after the export process finishes.

Steps to import your chart of accounts from Simply Accounting into QuickBooks:

  1. Start QuickBooks.
  2. Select Chart of Accounts from the Lists menu.
  3. After selecting Accounts, choose Import From Excel.
  4. Before importing data from the CSV file, QuickBooks will allow you to make a backup of the company file. To protect your data, I advise that you adhere to the on-screen directions and make a backup.
  5. Select the CSV file that you exported from Simply Accounting by clicking Browse.
  6. The chart of accounts that you wish to transfer your company file is on one of the sheets that you should choose.

Migrate sales tax data from Simply Accounting to QuickBooks Desktop

You can build a sales tax report in Simply Accounting that details all the sales taxes you've tracked down and paid for a certain company file. The data can be filtered based on date. Reports are offered in both summary and detail.

Steps to export sales tax data from Simply Accounting to QuickBooks:

  1. Left-click on the Reports menu.
  2. Select Sales Tax Report from the menu.
  3. In the From and To fields, select a date range.
  4. Select CSV from the Export menu so that it may be imported into QuickBooks.

After exporting the sales tax information, you can use the CSV file to import it into the QuickBooks desktop. Information like the amount of sales tax, the tax authority and agency, the taxable sales, and the tax rate are all included in the exported file.

Steps to import sales tax data from Simply Accounting to QuickBooks:

  1. Download the setup for the QuickBooks Import Excel CSV toolkit and double-click on it to launch the setup.
  2. Select Browse.
  3. Choose a location for the files that will be extracted for the import tool.
  4. Launch the toolkit, then import the sales tax list by following the on-screen directions.
  5. The Sales Tax CSV file you exported from Simply Accounting should be selected.
  6. Wait for the data to be imported into QuickBooks.

Your sales tax data was successfully migrated from Simply Accounting to QuickBooks Desktop. To make certain that all of your data was accurately imported, you can construct a sales tax report in QuickBooks and compare it with the one in Simply Accounting.

Steps to create a sales tax report in QuickBooks Desktop:

  1. Select Reports from the menu.
  2. Select Vendors and Payables.
  3. On the Sales Tax Liability tab, click on Sales tax.

Migrate payroll data from Simply Accounting Payroll to QuickBooks Desktop

Using the data export option, you may export the entire payroll in CSV format, including information on the employees and their salaries, which you can then import into QuickBooks Desktop.

Steps to export payroll data from Simply Accounting payroll to QuickBooks Desktop:

  1. Select Data Export from the File menu.
  2. Simply choose Payroll Data Export.
  3. Select Next.
  4. Choose the data you wish to export, such as employee names, salaries, etc.
  5. Select Next.
  6. In the Path box, specify the name and location of the exported CSV file.
  7. To ensure that the exported file has identifiable headings, choose "Create a CSV file with Payroll fields as column headers?"
  8. Click Finish after selecting Next.
  9. To start the export process, choose OK.

You now have two options for importing this data into QuickBooks desktop: either manually entering each list item or using a third-party add-on, which will cost you based on the add-membership fee. You may also get in touch with our accounting software specialists, who can help you migrate your payroll, wage, and employee information from Simply Accounting to QuickBooks Desktop.

Migrate fixed assets data from Simply Accounting to QuickBooks Desktop

Fixed asset data cannot be exported from Simply Accounting to QuickBooks desktop. Currently, the QuickBooks conversion tool does not make this possible. Additionally, since you must manually export and then manually input the fixed asset data, the manual approach can be time-consuming.

You have two choices:

  • To move fixed asset data from Simply Accounting to QuickBooks Desktop, use an add-on.
  • Contact our accounting professionals so they can move your fixed asset data to QuickBooks Desktop.

Migrate inventory and services data from Simply Accounting to QuickBooks Desktop

You may export inventory list items from Simply Accounting in CSV format. Before importing the CSV file into QuickBooks Desktop, you may update this list and personalize it to meet your needs.

Steps to export inventory and services from Simply Accounting:

  1. Select Import/Export from the File menu.
  2. Click Records Export.
  3. Select "Export records to an import file for Simply Accounting."
  4. Select Next.
  5. Pick Services & Inventory.
  6. Give the exported CSV file a name and select a location.
  7. Select Next.
  8. Select the Items you want to export, then select Next.
  9. To build the Export Records Summary, click on OK.
  10. To modify the exported data, use Microsoft Excel.

Steps to use the QuickBooks Excel CSV toolkit to import item lists from Simply Accounting to QuickBooks Desktop:

  1. Launch QuickBooks_Import_Exceland_CSV.exe by double-clicking on the downloaded file.
  2. Select Browse.
  3. Choose a location for the files that will be extracted for the import tool.
  4. Launch the toolkit, then import the sales tax list by following the on-screen directions.
  5. Choose the Inventory List Items CSV file that Simply Accounting exported.
  6. Wait for the data to be imported into QuickBooks.

There isn't yet a built-in feature in QuickBooks that allows for the bulk import of inventory listings. As a result, you must rely on the services of professionals in accounting software or add-ons. You must pay an annual price to access the add-ons' fundamental features because they often offer a subscription option. The number of transactions or list items that you can import into QuickBooks using the free ones is often restricted.

If you don’t want to manually import the inventory data from Simply Accounting to QuickBooks desktop, then you can get in touch with our team of accounting experts.

Conclusion

You just need to know this information to move all of your data from Simply Accounting to QuickBooks desktop without difficulty. We've discussed both automated and manual techniques for moving your accounting data from Simply Accounting to QuickBooks Desktop. This post has examined several Intuit-provided tools that make it easier to import and export accounting data. The links on the Intuit website allow you to get these tools.

You can also rely on add-ons from third parties to migrate your data, but you will be required to pay the add-membership fee. Make sure you choose a reputable add-on from Intuit's marketplace when utilizing one. Your risk of data loss and theft may rise if you download software from an arbitrary third-party website. For assistance with the transition from Simply Accounting to QuickBooks, you may also get in touch with our professionals.


Blog Post

Related Articles

Easy Migration of QuickBooks Enterprise to QuickBooks Online

July 7, 2022
QuickBooks Enterprise and QuickBooks Online are both used by organizations for handling their day-to-day accounting,...

How to Convert QuickBooks Online to QuickBooks Enterprise?

August 16, 2022
So you want to move your accounting data from QuickBooks Online to QuickBooks Enterprise. Even though the process is...

Steps to Import General Ledger into QuickBooks Desktop and Online

March 1, 2024
In your accounting system, your Main Book, also known as the General Ledger, contains individual accounts that show...
Call Now+1-800-961-4963