Onaro™ONARO
OverviewImplementationExtraction guides

← All systems

NetSuite — Data Extraction Guide

Zero-Access pack. Follow each section, export the file, and return it to Onaro or upload it in the Meridian profile wizard. Verified as of 2026-09-13; vendor menus change.

Download NetSuite PDF

Journal entry CSV import template

Verified as of 2026-09-13

Steps

  1. Sign in to NetSuite with Make Journal Entry permission (and Import CSV File if using Setup → Import/Export).
  2. Preferred template download: go to Transactions → Financial → Make Journal Entries → Import.
  3. On the Import Assistant Scan & Upload page, open the Single Journal Entry Template File link and download the CSV.
  4. Alternative (bulk / saved mappings): Setup → Import/Export → Import CSV Records → Import Type Transactions → Record Type Journal Entry — use a sample CSV that matches your saved mapping, or build from Oracle’s Journal Entry CSV Files examples.
  5. Upload the template or sample into Meridian’s Export Profile wizard so headers match your import path.

What you should have

CSV with header + line fields (e.g. External ID, Department, Journal Entry -Line: Account / Debit / Credit / Memo). At least two balancing lines per entry.

Gotchas

  • Use the 2021.2+ line sublist header names (Journal Entry -Line: …) for automatic mapping.
  • OneWorld: journal entries and intercompany journal entries are separate import types — use separate files.
  • External ID (or Entry No.) should identify the journal and typically repeats on every line of that entry.

Source documentation

Trial balance / financial report export

Verified as of 2026-09-13

Steps

  1. Ask your NetSuite administrator which trial balance or financial report your firm exports for month-end tie-out.
  2. Open that report (often Reports → Financial → Trial Balance, or a saved search / SuiteAnalytics workbook).
  3. Set the As of / period to the last day of the Meridian reconciliation month.
  4. Export to CSV or Excel.
  5. Upload into Meridian’s Import Profile wizard (artifact: trial balance).

What you should have

CSV/Excel with accounts and debit/credit or balance amounts for the period.

Gotchas

  • Report labels and roles vary by OneWorld and customizations — use your controller’s standard TB.
  • Include subsidiary context if you close multiple subsidiaries.

Source documentation

Vendor bill / AP export

Verified as of 2026-09-13

Steps

  1. Ask your AP lead which vendor bill list, saved search, or SuiteAnalytics export your firm uses for spend review.
  2. Typical starting point: Transactions → Payables → Enter Bills (list view) or a Vendor Bill saved search for the assessment period.
  3. Filter to the date range; include vendor, date, amount, and expense account when available.
  4. Export to CSV or Excel.
  5. Upload into Meridian’s Import Profile wizard (artifact: AP / vendor bills).

What you should have

CSV/Excel of vendor bills or AP detail for the period.

Gotchas

  • Prefer an existing saved search your accounting team already trusts.
  • Do not include bank account or payment instrument secrets — bill-level detail is enough.

Source documentation

Chart of accounts / segments extract

Verified as of 2026-09-13

Steps

  1. Ask your administrator for a Chart of Accounts list export (often Lists → Accounting → Accounts, then Export).
  2. Export departments, classes, locations, and custom segments you use for AI spend attribution the same way.
  3. Upload CoA and dimension/segment files into Meridian’s Import Profile wizard.

What you should have

CSV/Excel account list plus dimension/segment value lists.

Gotchas

  • Inactive accounts can clutter mapping — export Active only unless Meridian asks otherwise.
  • OneWorld: confirm which subsidiary’s CoA applies.

Source documentation

Budget export

Verified as of 2026-09-13

Steps

  1. Ask your controller whether budgets live in NetSuite Budgets, a SuiteAnalytics workbook, or an external Excel file.
  2. Export the filed budget for the periods Meridian will variance against.
  3. Upload into Meridian’s Import Profile wizard (artifact: budget).

What you should have

CSV/Excel budget by period and department/class (or your filed budget shape).

Gotchas

  • External Excel budgets are acceptable — name the file with source and date for provenance.

Source documentation