OptimalData

What to expect from this course

What is data migration?

The data migration timing

Understanding the team & who does what?

Four accounting cleanup tasks

Hard cutover vs soft cutover

Sample email to auditors discussing your upcoming NetSuite implementation

Implications of using BILL for AP payments

Using the NetSuite internal ID

Overview of Master Records

Export the account list from QBO

Overview of designing a chart of accounts

Import GL accounts into NetSuite

Export the class and location list from QBO

Import classes, departments, and other segments to NetSuite

Export the QuickBooks item list

Overview of item fields by Alex Burant at Anchor Group

Overview of item types by Alex Burant at Anchor Group

Overview of item groupings by Alex Burant at Anchor Group

Export the vendor list from QBO

Export the customer list from QBO

Cleaning the QBO customer/vendor list

Preparing the customer upload file

Article Link: Importing Entity Addresses from QuickBooks Online

Overview

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 (point-in-time approach)

Preparing the opening balance sheet journal entry (net change approach)

Preparing the JE template from a transaction list (net change approach)

Import the historical financials as journal entries into NetSuite

Validating my trial balance uploads

What if I need to delete my journal entries?

Feedback and OptimalData assistance

Overview

Create the open AP suspense account

How to run and format a QBO AP aging detail report

Preparing the open AP import files

Loading the open AP transactions into NetSuite

Reversing the import AP vendor balance

Validating the open AP load