Stripe and NetSuite fields and references

Learn how the Stripe Connector for NetSuite applies fields to Stripe and NetSuite records.

Use the list below to identify the correlation between Stripe records and NetSuite records.

Stripe and NetSuite object mapping

NetSuite represents Stripe records as follows:

Stripe object	NetSuite record
Charge	Customer payment
Credit note	Credit memo (in most cases) and refund (in some cases)
Coupon	Discount item
Customer	Customer
Dispute	Customer refund
Invoice	Invoice and credit memo (in some cases)
Invoice item	Service sale item or discount item
Payout	Deposit
Price	Service sale item
Refund	Customer refund and credit memo (in some cases)
Subscription	None (monthly invoices represent subscriptions)

NetSuite record IDs and Stripe IDs

When a Stripe record successfully syncs to NetSuite, the NetSuite internal ID for the new record saves to the metadata of the Stripe record.

NetSuite stores the Stripe ID as follows:

Record	ID placement in NetSuite
CreditMemo	memo, externalId
Customer	Comments (only added if externalId is empty)
CustomerPayment	memo, externalId
Deposit	memo, externalId
Dispute	memo, externalId
Invoice	memo, externalId
NetSuite items (discount, service sales item, and so on)	Item Name, Item ID, other display name fields, externalId

NetSuite memo fields

A Stripe: prefixes any memo fields that contain the corresponding Stripe record ID. This allows you to identify which Stripe record corresponds to a NetSuite record. The connector doesn’t use the memo field in NetSuite and adds notes for informational purposes only. You can safely wipe or override the memo field on any created records.

The connector stores additional information in the memo field for a NetSuite record in the following cases:

If you modify a transaction date, the memo includes the original transaction date. This ensures successful translation of the record. For example, Original transaction date: 2023-04-01.
If a charge isn’t associated with an invoice or order, the customer payment memo includes the charge description. For example, Stripe description: charge for invoice 12345.
If an invoice increases a customer’s balance, the NetSuite invoice includes the amount.
If a credit memo represents an invoice payment from a customer’s balance, the credit memo includes the payment.

NetSuite external IDs

The external ID for every Stripe-created NetSuite record is set to the ID of the corresponding Stripe record. This allows you to retrieve a record from NetSuite using the Stripe record ID.

In some exceptions, the external ID is prefixed:

Credit memos: The external ID is prefixed with ns_memo:. For example, if the refund ID is re_abcd, the credit memo external ID is ns_memo:re_abcd.
Discount items for Stripe prices: The external ID is prefixed with the ID of the price object that the discount is applied to.

If you have other integrations in your NetSuite instance, make sure not to overwrite the external IDs that Stripe sets on records.

NetSuite record fields

The connector uses the NetSuite record fields listed below, by default. These fields must exist on the custom forms used for any records that the connector creates or uses.

Record	Fields	Notes
Invoice (read only)	amountRemaining status currency custbody_suitesync_authorization_code tranId memo createdFrom entity externalId	The `amountRemaining` is also called Amount Due.
Customer	externalId
CreditMemo	memo currency custbody_suitesync_authorization_code line items sub-list
CustomerPayment	memo currency paymentMethod account payment tranDate	Always set the `tranDate` to the exact date of the transaction in Stripe. Set the `paymentMethod` to the Stripe payment method (automatically created in your account). The connector sets the `account` to the undeposited funds account.
CustomerRefund	memo currency tranDate paymentMethod account	Always set the `tranDate` to the exact date of the transaction in Stripe. Set the `paymentMethod` to the Stripe payment method (automatically created in your account). The connector sets the `account` to the undeposited funds account.
Deposit	currency memo all sub-lists (payment list, other deposits, cash back)