QuickBooks Online to NetSuite Data Migration Training

Signing up for this self-taught course gives you access to...

• 50+ videos sharing step-by-step instructions for running reports from QBO
• Monthly office hours with Paul, founder of OptimalData Consulting
• Seven downloadable Excel files for creating the NetSuite CSV files required for historical financials, open AP and open AR transactions

• Overview of master records
• Export the account list from QuickBooks
• NetSuite chart of accounts
• Import GL accounts to NetSuite
• Export the class and location list from QuickBooks
• Import departments, classes, and segments to NetSuite
• Export the item list from QuickBooks
• Overview of NetSuite item fields, types, and groupings by our very own Alex Burant!
• Export the vendor and customer lists from QuickBooks
• Cleaning the QuickBooks customer/vendor list
• Prepare a customer upload file

• Overview of historical trial balances
• Adding a custom field to represent the QBO account and class
• Create the import AP vendor and import AR customer
• Preparing the JE template from a TB
• Preparing the opening balance sheet journal entry
• Preparing the JE template from a transaction list
• Import the historical financials as journal entries into NetSuite
• Validating my trial balance uploads
• What if I need to delete my journal entries?

• Overview of loading open accounts payable transactions
• Create the open accounts payable suspense account
• How to run and format a QBO accounts payable aging detail report
• Preparing open accounts payable import files
• Loading the open accounts payable transactions into NetSuite
• Reversing the import accounts payable vendor balance
• Validating the open accounts payable load

• Overview of loading open AR transactions
• How to run and format a QuickBooks Online AR aging detail report
• Create the open AR suspense account and item
• Preparing the open AR import files
• Turn off NetSuite auto-generated numbers for AR transaction types
• Loading the open AR transactions into NetSuite
• Reversing the import AR customer balance
• Validating the open AR load