more-arw search

Q&A Forum

Conversion from QuickBooks Pro 2009 to NetSuite

quickbooks to netsuite conversionMy Company is in the process of converting from QuickBooks Pro 2009 to NetSuite.  Has anyone used the NetSuite import function to import historical data from QuickBooks?

If so, was it successful or did it require a lot of manual adjustments?  If it wasn't successful can you recommend a work around?

Answers

Brian Reilly
Title: VP
Company: vConstruct
(VP, vConstruct) |

Margaret - there are definitely some challenges in using the native NetSuite CSV import tool. The tool only processes 25k records at a time so you'll have to chunk your data for import. In addition, you can only enter one type (table) of data at a time so you'll have to determine the optimal order (for parent first, children second). It's a bit time consuming to do this work and since you'll likely be using QuickBooks until the deployment has completed, it's likely you'll have to do a delta migration at some point.

Jordan Krizman
Title: Marketing Manager
Company: ProfitKeeper
(Marketing Manager , ProfitKeeper) |

Margaret,

we have done historical imports from QuickBooks, it was successful, and it required a lot of manual adjustments.

I can give you a better answer if you can answer these 3 questions:
1) How much historical transaction data do you have in QuickBooks?
2) What is the length of time (dates) you plan to import?
3) Which transactions do you plan to import?(historical sales, historical purchases etc.)

In terms of a workaround, we haven't found an automated tool that can completely replace the manual process. The data that goes into an automated tool should be "scrubbed" to ensure its quality. And you still might have to go in manually to make adjustments.

It pays to at least check out Brian's tool and see what it can do for you.
Also, you may also message me for more detailed information.

Margaret Hsia
Title: Financial Consultant
Company:
(Financial Consultant, ) |

1)A few thousand transactions in total
2)Less than 2 years of data for a startup company
3)Would like to pull everything over - all transactions, journal entries, etc.

Jordan Krizman
Title: Marketing Manager
Company: ProfitKeeper
(Marketing Manager , ProfitKeeper) |

Margaret, your project would be on the lower end of the spectrum for a data migration. We have converted 7-8 years of data for companies without a problem.
Again, you might find an automated import tool, but all data will have to be verified, at least in part, manually.

Topic Expert
Len Green
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

Hi Margaret:
I ask this question because sometimes the need for historic data may best be served by different solutions. For example:
1. If you only need prior period data for comparative reporting, consider loading journal entries for prior period account balances and rolling them forward to the cut over date (but remember to use your NEW chart of account structure to achieve comparability)
2. If you need transaction detail (other than open balances at cut over date), consider whether simple transaction detail reports can be run from QB and saved for reference in case you need to refer to them. That way you may be able to avoid loading records like inactive vendors etc.
3. If you have fixed assets to migrate, make sure your new system can pick up midlife cost and accumulated depreciation at cut over date.

I have seen clients spend a lot of time (and thus money) trying to recreate history in a new system with very little value; in the end, what do you really need from history and what is the best way to extract/store/access it?

David Weiss
Title: eCommerce Practice Manager
Company: Key
(eCommerce Practice Manager, Key) |

NetSuite themselves should be able to import your Quickbooks file for you.

If, for some reason, you or NetSuite cannot import your existing data, there are tools, such as Pervasive Data Integrator, which can read and write to and from both Quickbooks and NetSuite. This is the tool we use to migrate quite a bit of data into and out of NetSuite.

Sara Laidlaw
Title: President
Company: Accounting Services Bureau Inc
LinkedIn Profile
(President, Accounting Services Bureau Inc) |

I developed a utility that will export Net Change Trial Balances including an option to export by class code (by dept) from QuickBooks. I recently added an export of net changes in monthly columns. If someone simply desires history for comparative purposes without all the detail, does Netsuite do this directly from QuickBooks or does it import csv files as journal entries? It is called TBX Trial Balance Exporter if anyone is interested.

Lisa Wu
Title: VP of Finance
Company: Mirantis Inc.
LinkedIn Profile
(VP of Finance, Mirantis Inc.) |

Our company is implementing Netsuite as well. Would anyone suggest a best way of converting existing deferred revenue into Netsuite? We would like to use NS feature of tracking deferred revenue by customers and amortizing based on revenue recognition templates.

Topic Expert
Len Green
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

“Lisa, I have a couple of quick questions for you.

1. Do you have the Advanced Projects Module in NetSuite (which is required for Variable Revenue Recognition Templates).
2. Do you have a need for Variable Rev Rec, or are Fixed templates adequate?
3. What type of items are you going to use in Netsuite for Rev Rec?
4. Is there a need for Discount or Markup items? (they are handled a little differently)

For loading Deferred Revenue, do you want to load it just at go-live or are you intending on trying to load historicals as well? When loading customer (and vendor) level transactions, the most common practice is to use the 3200 account (out of the box Opening Balance account in NetSuite). We have done this for thousands of transactions (A/R and A/P)for multiple clients in numerous industries.

Let me know if that helps or if you would like to discuss.

Regards
Len

Topic Expert
Bob Stenz
Title: Controller
Company: Silicon Valley start-up
(Controller, Silicon Valley start-up) |

Hi Lisa, I see that you are a Silicon Valley company. www.frankrimerman.com (a local CPA firm) did a great job of bringing my company's deferred revenue in NetSuite for a reasonable rate.

Al Prince
Title: Senior Software Engineer
Company: I*
(Senior Software Engineer, I*) |

Here is one option that worked great for us:
http://quickbooksrepairpro.com/convert-netsuite-to-quickbooks.aspx

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.

QuickBooks Quicker - 24 Courses Available