All migration guides

Migration guide

Migrate from Oracle NetSuite.

Export your chart of accounts, GL transactions, vendors, customers, and financial data from NetSuite using Saved Searches and built-in reports. Same enterprise capability, simpler licensing.

Enterprise migration support

Enterprise customers get free migration support. We'll do the heavy lifting for you — chart of accounts mapping, opening balance import, and 30-day parallel-run support.

Contact us

Before you start.

  • Close all accounting periods through your planned cutover date (Setup > Accounting > Manage Accounting Periods).
  • Reconcile all bank and credit card accounts through the cutover date.
  • Ensure you have an Administrator role or a role with full financial report access.
  • Note your subsidiary structure and fiscal calendar configuration.
  • Decide on a cutover date (ideally the last day of a fiscal period).
  • If exporting large datasets, consider using SuiteAnalytics Connect (ODBC) for bulk extraction.

Step 1

Export your data from Oracle NetSuite.

a.

Chart of Accounts

Navigate to:
Lists > Accounting > Accounts
Export:
From the account list view, click Export (CSV option in footer/toolbar). Or create a Saved Search on Account records.
Format:
CSV or Excel

Include account number, name, type, and subsidiary columns. For multi-subsidiary setups, the Saved Search approach gives you more control over which subsidiaries to include.

b.

Trial Balance (Opening Balances)

Navigate to:
Reports > Financial > Trial Balance
Export:
Set the "As of" date and subsidiary filters. Click Export > Excel or CSV.
Format:
Excel or CSV

Run per subsidiary if you have multiple. This becomes your per-entity opening balance in Quoining.

c.

General Ledger / Transaction Detail (optional)

Navigate to:
Reports > Financial > General Ledger, or create a Saved Search on Transaction records
Export:
Set the date range and subsidiary filters. Export from the report viewer or Saved Search results.
Format:
Excel or CSV

The built-in GL report can be slow for large datasets. Saved Searches are generally faster and more customizable. Add columns for date, account, debit, credit, memo, entity, and department.

d.

Vendor List

Navigate to:
Lists > Relationships > Vendors
Export:
Export from the list view (CSV), or create a Saved Search on Vendor records
Format:
CSV
e.

Open Bills (Vendor Bills)

Navigate to:
Create a Saved Search: Lists > Search > Saved Searches > New > Transaction
Export:
Filter: Type = Vendor Bill, Status = Open. Add columns: date, vendor, amount, due date, reference number. Run and Export.
Format:
CSV or Excel

Saved Searches on Transactions show up to 1,000 rows in the UI. The CSV export handles more. For very large AP datasets, use SuiteAnalytics Connect.

f.

Customer List

Navigate to:
Lists > Relationships > Customers
Export:
Export from the list view (CSV), or create a Saved Search on Customer records
Format:
CSV
g.

Open Invoices

Navigate to:
Create a Saved Search: Lists > Search > Saved Searches > New > Transaction
Export:
Filter: Type = Invoice, Status = Open. Add columns: date, customer, amount, due date, document number. Run and Export.
Format:
CSV or Excel

Same row-limit considerations as Vendor Bills above.

h.

Bank/Cash Transactions (optional)

Navigate to:
Create a Saved Search on Transaction records, filtered to Deposit, Check, Transfer, and Journal types for your bank accounts
Export:
Run and Export as CSV
Format:
CSV or Excel

Alternatively, download bank statements directly from your bank in CSV or OFX format for import into Quoining.

Watch out for

Common gotchas.

  • NetSuite Saved Search results are capped at approximately 1,000 rows in the browser UI. The CSV/Excel export handles larger result sets (typically up to 10,000+ rows). For very large datasets, use SuiteAnalytics Connect (ODBC).
  • Reports and exports respect role permissions. Use an Administrator role to ensure full financial visibility across all subsidiaries.
  • NetSuite uses "Subsidiaries" where Quoining uses "Entities." Map each NetSuite subsidiary to a Quoining entity during onboarding.
  • If you use NetSuite's Departments, Classes, and Locations, map them to Quoining's Departments and Custom Fields.
  • NetSuite's SuiteTalk REST API and SOAP API can programmatically export all record types for automated migration. Contact Quoining's Enterprise team for API-assisted migrations.

Step 2

Import into Quoining.

01

Sign up and complete onboarding

Enter your company name, create your entities, and set your fiscal year start month. Choose your chart of accounts or upload the one you exported.

02

Enter opening balances

Use the Opening Balance Wizard to enter your trial balance as of the cutover date. Each GL account gets a debit or credit entry that matches your source system's balance sheet.

03

Import vendors and customers

Use Settings > Data Import to upload your vendor and customer lists as CSV files. Quoining maps the columns automatically.

04

Re-enter open AP and AR

Enter any open (unpaid) bills and invoices as of the cutover date. This establishes your starting AP and AR aging. You can also use the AI Accountant to create these from your exported aging reports.

05

Connect your bank accounts

Connect via Plaid for automatic transaction sync, or import bank statements as CSV/OFX files. SmartGL will categorize transactions using Claude and present them for your review.

06

Run your first reconciliation

Reconcile each bank and credit card account through the cutover date. The GL-based reconciliation matches your bank statement against posted journal entries.

07

Compare financial statements

Run a Balance Sheet and Income Statement in Quoining as of the cutover date and compare them to your source system. They should match. If they don't, check the Opening Balance Wizard for discrepancies.

08

Go live

Once your trial balance matches, you're live. Start categorizing new transactions, entering bills and invoices, and running your monthly close in Quoining.

Frequently asked.

Ready to migrate?

Start free. No credit card required. Enterprise customers get free migration support.