ImportLensCFCX Work

NetSuite CSV Preflight Validator

Catch import failures before they reach NetSuite

Upload a CSV, select your record type, and get a full diagnostic report — structure, data quality, and record-specific rules checked in seconds.

Drop your CSV here, or click to browse

Max 5 MB · .csv files only

Three layers of validation

1

Structure

Column count consistency, required columns, encoding detection, BOM handling, delimiter validation, trailing empty rows.

2

Data Quality

Numeric validation on amount fields, date format consistency, whitespace-only cells, duplicate external IDs.

3

Record Rules

Journal entry debit/credit balance. Invoice and vendor bill entity and line item checks. Customer and vendor name requirements.

How it works

1

Upload your CSV

Drop your NetSuite CSV import file and select the target record type.

2

Instant analysis

ImportLens groups rows into transactions, runs three layers of checks, and scores your file.

3

Diagnostic report

Get a readiness verdict, issue-by-issue breakdown, column mapping, and clear next steps.

Readiness states

Ready

No issues found. Structurally ready for import.

Review

No errors, but warnings need review before import.

Fix Required

Errors that will likely block the import.

Not Importable

Structural problems. Major rework needed.

Supported record types

Journal Entry

Transactional

Debit/credit balance, account on every line, amount validation, transaction grouping.

Invoice

Transactional

Customer required, line items, amounts, transaction date, entity grouping.

Vendor Bill

Transactional

Vendor required, line items, amounts, transaction date, entity grouping.

Customer

Body-only

Name required, email format validation, duplicate detection.

Vendor

Body-only

Name required, email format validation, duplicate detection.

More coming

Planned

Purchase orders, sales orders, estimates, and more record types planned.

What ImportLens does not validate

—Custom forms or mandatory custom fields

—Whether entities, items, or accounts exist

—Workflow or approval routing rules

—OneWorld subsidiary settings

—Multi-currency configuration

—Custom segments or classifications

A clean report means the CSV is structurally sound — not that the import will succeed.

Built by CFCX Work