Question

Data Migration from Netsuite

Forum|Forum|6 years ago
April 10, 2020
6 replies
13 views

I want to know whether we can migrate from Netsuite to Quickbooks Desktop version. Whether such option available in quickbooks menu itself.

Please also guide other options

Regds

Bala

Chennai, India

QuickBooks Desktop

Anna S

Nice to have you here in the Community, @balakmu.

I'm happy to provide you with more details about migrating your data from Netsuite to QuickBooks Desktop, but there are a few questions I need you to answer first.

Do you already have an active QuickBooks subscription?
Are you migrating from Netsuite to QuickBooks Desktop or QuickBooks Desktop to Netsuite?

Once you answer these questions, I can determine the best options for you to migrate.

However, in QuickBooks, you can import excel files into your company file. As for Netsuite, I recommend reaching out to their support team for an exact answer. They are more knowledgeable about their product so they can give you any details you need.

I'll keep an eye out for your response.

B

balakmuAuthor

Hi

Thanks for the reply. my client want to move to Quickbooks Premier 2020

Presently they are using netsuite. Is there any tool available

Regds

Bala

M

Maybelle_S

QuickBooks Team

Thank you for getting back here in the Intuit Community, @balakmu.

To migrate from Netsuite to QuickBooks Desktop version, you can use the third-party converter to ensure that the data is 100% accurate and all links are maintained. To make sure the NetSuite P&L, Balance Sheet and Trial balances match the Quickbooks data file. Also, the open invoices and open bills report in NetSuite will be the same as Quickbooks.

If you have any other concerns, please don't hesitate to place a comment below.

A

almeidad

NetSuite conversions require data to be downloaded using the API and CSV files and are then transferred to QuickBooks.

Once you know what data you’ll be bringing into QuickBooks, you should make sure that the upload file contains everything you have highlighted. A CSV file upload is the quickest method of importing data to QuickBooks, but checking that the source data is accurate and complete beforehand should be a given. You should also be sure to have identified required fields and checked that they are included in the CSV file.

Use a professional third-party conversion provider for a solution or send me a PM for more information.

C

CTurk

We are wanting to migrate our data from Netsuite to Quickbooks online. Would you be able to provide any guidance ? Would it be similar to migrating to QB Desktop ?

Fiat Lux - ASIA

Level 14

@CTurk

You may open a new blank QBO account

https:// quickbooks.grsm.io/US

https:// quickbooks.grsm.io/us-promo

then you may have 2 options:

1. Utilize a migration tool

https:// transactionpro.grsm.io/qbo

2. Purchase a 3rd party conversion service.

Most Netsuite users preferred migrating to QB Desktop Premier/Enterprise and deploy a private cloud if required.

The following NetSuite records can be converted to Quickbooks:

NetSuite Entities to QuickBooks
Contact
Customer
Employee
Group
Job
Partner
Vendor

NetSuite Activities to QuickBooks
Event
Phone Call
Task
Project Task

NetSuite Accounting to QuickBooks
Account
Accounting Periods
Budget
Class
Currency
Department
Location
Revenue Recognition Schedule
Revenue Recognition Template
Subsidiary
Units of Measure

NetSuite Transactions to QuickBooks
Bin Putaway Worksheet
Bin Transfer
Build/Unbuild Assembly
Cash Refund
Cash Sale
Check
Credit Memo
Customer Deposit
Customer Deposit Application
Customer Payment
Customer Refund
Estimate
Intercompany Journal Entry
Inventory Adjustment
Invoice
Item Demand Plan
Item Fulfillment
Journal Entry
Opportunity
Purchase Order
Purchase Order Receipt
Return Authorization
Sales Order
Transfer Order
Vendor Bill
Vendor Credits
Vendor Payment
Vendor Returns
Work Order

NetSuite Support to QuickBooks
Case
Issue
Solution
Topic

NetSuite Items to QuickBooks
Assembly/BOM Item, including serial and lot numbered
Description
Discount
Gift Certificate Item
Inventory Item, including serial and lot numbered
Inventory Number
Kit/Package Item
Markup
Non-Inventory Item for Purchase/Sale/Re-sale
Other Charge for Purchase/Sale/Re-sale
Payment
Service for Purchase/Sale/Resale
Subtotal
Download

NetSuite Communications to QuickBooks
Message
Note

NetSuite Miscellaneous to QuickBooks
Expense Report
Time Tracking
Other Lists

NetSuite Web Site to QuickBooks
Categories

NetSuite Tax Records to QuickBooks
Sales Tax Item
Tax Groups
Tax Type

NetSuite Customization to QuickBooks
Custom Lists
Custom Record Type
Custom Record

NetSuite Marketing to QuickBooks
NetSuite Campaign
NetSuite Campaign Response
NetSuite Promotion Code

NetSuite File Cabinet to QuickBooks
File
Folder

What they don’t convert?
The following information is not converted:

Bank Reconciliation (You will need to do a single bank reconciliation after the conversion. They will send you instructions to do this.)
Paychecks are converted as Journal Entries (Importing Paychecks is not supported by QuickBooks)
Employee YTD information
Individual employee wage or deduction information
Custom templates
Jobs are not attached to transactions
Budgets
Fixed Asset Items
Work Tickets
In some cases, fields are not compatible and are not transferred over. You will need to manually enter such fields after the conversion.

Should you prefer migrating to QB Desktop or QB Online, send your business email address in a private message to us.

Angelyn_T

Moderator

Thank you for getting back, @CTurk.

Allow me to share some information about the QuickBooks Online (QBO) file size and feature limits.

There isn't a file size limit in QBO. The system loads your data as needed. Meaning, the overall size of the data file doesn’t substantially affect performance. The speed of your internet connection plays a big part. Meeting or exceeding the system requirements for QuickBooks Online improves QuickBooks Online performance more than file size.

For your Netsuite data, I would recommend connecting with Netsuite Support. This way, they verify the process and determine the possible limitations of the number of years (transactions) you can import to QuickBooks.

To know more about the technical limits, file sizes, transaction volumes, and data entry in QuickBooks Online, I recommend checking out this link: QuickBooks Online file size and feature limits.

Moreover, you can also open this article to learn more about the usage limits in QuickBooks Online.

If you have any other questions about exporting/importing data into QuickBooks, please let me know by adding a comment below. I'm always here to help. Have a good one!

I

IW619

I am also looking for the best route to migrate transactions from NetSuite to QBO Advance. Is there an approved or recommended vendor list that will help

in this process? Or can it be done ourself?

M

MirriamM

QuickBooks Team

Welcome to the Community space, IW619.

When it comes to using third-party apps, QuickBooks Online (QBO) doesn't control how the app syncs. We only receive and record the data on the system.

For more details on how to migrate transactions from NetSuite to QBO, I'd recommend contacting NetSuite support team. They can provide more information about this.

In case you need some related articles for managing your account, you'll want to visit our Community Help Articles hub.

If you have additional questions about QuickBooks, let me know by commenting below. I'll get back to you. Have a great day.

M

MichaelTomar

QuickBooks Desktop doesn't offer a direct migration option from NetSuite within its menu. However, you can use Skyvia to facilitate this migration. Skyvia can connect to both NetSuite and QuickBooks Desktop, allowing you to set up data flows to transfer financial data between the two platforms. It's a versatile and efficient solution for such migrations.

T

TimotiSbr

For QuickBooks Desktop export lists and use IIF or Excel import. If you move to QBO a tool like Skyvia can migrate customers items invoices and payments with field mapping and checks.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded