NetSuite

Measure can export invoices and payments in a CSV format that is ready to import directly into NetSuite. This is useful if you manage your accounting in NetSuite but do not have a live API integration. You can export from Measure on a schedule and import the file into NetSuite using its standard CSV import tool.

Invoice Line Items Export

The invoice line items export produces one row per line item, with invoice-level fields repeated on each row. This maps directly to NetSuite’s Invoice import record type.

Column	Description
External ID	The Measure invoice ID, used as the NetSuite external ID for deduplication
Invoice Number	The invoice number from Measure
Invoice Date	Invoice date formatted as `YYYY-MM-DD`
Due Date	Payment due date formatted as `YYYY-MM-DD`
Status	NetSuite-compatible status (see mapping below)
Currency	Full currency name (e.g. `US Dollar`, `CA Dollar`)
Customer	Customer display name
Customer Email	Primary email address on the customer record
Billing Address 1–2	Street address lines
Billing City / State / Zip / Country	Billing address fields
Item	Product name
Item Description	Line item description
Quantity	Line item quantity
Unit Price	Price per unit
Amount	Total line amount
Tax Rate	Applicable tax rate
Tax Amount	Total tax charged on the line
Memo	Invoice notes
Service Start Date	Service period start formatted as `YYYY-MM-DD`
Service End Date	Service period end formatted as `YYYY-MM-DD`

Invoice Status Mapping

Measure invoice statuses are mapped to the closest equivalent NetSuite status:

Measure Status	NetSuite Status
Draft	Pending Approval
Void	Pending Approval
Pending	Open
Overdue	Open
Uncollectible	Open
Payment Processing	Open
Paid	Paid In Full

Payments Export

The payments export produces one row per payment transaction. This maps to NetSuite’s Customer Payment import record type.

Column	Description
Invoice Number	The invoice number the payment applies to
Customer ID	The Measure customer identifier
Invoice Payment	Payment amount
Payment Date	Date the payment was initiated, formatted as `YYYY-MM-DD`
Payment Captured Date	Date the payment was captured, formatted as `YYYY-MM-DD`
Payment Currency	Full currency name (e.g. `US Dollar`, `CA Dollar`)
Payment Amount	Payment amount (same as Invoice Payment)
Payment Method	Payment provider or method (e.g. `STRIPE`, `WIRE`, `CHEQUE`)
Payment ID	The Measure payment transaction ID

Introduction

How Measure Works

Invoice Line Items Export

Invoice Status Mapping

Payments Export

​Invoice Line Items Export

​Invoice Status Mapping

​Payments Export

Invoice Line Items Export

Invoice Status Mapping

Payments Export