> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getmeasure.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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                           |