NetSuite Mapping to MineralTree

Audience: Netsuite Admin and Accounting Manager

Accounting System: Netsuite

Summary: Reviews mapping fields to show how each field is represented in MineralTree and in NetSuite.

Company

Category	NetSuite	MineralTree
Subsidiary	Subsidiary Name	Subsidiary
Subsidiary	Country	Country
Debit Accounts (Bank Accounts)	Name	Bank Account Name
	Bank Account Number	Account Number
	Bank Routing Number	Routing Number
	Currency	Account Currency
Debit Accounts (Credit Card Accounts)	Name	Card Account Name
Accounting Periods	Period Name	Posting Period
Vendor Categories	Category	Vendor Category
Departments	Department Name	Department
Locations	Location Name	Location
Classes	Class Name	Class
Terms	Payment Terms Description	Terms
	Discount Value	Discount Value
	Due Days	Due Days**
General Ledger Accounts	Accounts Payable Account Account – Types include: Other Current Asset, Fixed Asset, Other Asset, Credit Card, Other Current Liability, Long Term Liability, Equity, Income, Cost of Goods Sold, Expense, Other Income, Other Expense, Deferred Revenue, Deferred Expense, Unbilled Receivable	AP Account Account
Customers	Customer Name	Customer
Projects	Project Name	Project
Custom Fields	Custom Entity Fields	Expanded Dimensions
	Description	Attribute
	Custom Entity Options	Options (dependent upon field type, e.g. options for dropdown field, etc.)
Company Items	Item Type + Parent Item NAME + ITEM NAME/NUMBER	Item
Company Items	Cost	Cost
Amortization Schedules	SCHEDULE NAME	Amortization Schedule
	START DATE	Amort. Start
	END DATE	Amort. End

Vendors

Vendors / Employees are both named "Vendors" in MineralTree

NetSuite	MineralTree
-- If Vendor, COMPANY NAME. If COMPANY NAME is empty, then VENDOR ID is used. -- If Employee, then FIRST NAME + LAST NAME. If those fields are empty, then EMPLOYEE ID	Vendor Name *
ACCOUNT	Payment Preferences -> Account Number *
Category	Vendor Category *
E-MAIL	Contact Email *
ALT. EMAIL	Contact Email (add’l)
PHONE	Phone *
FAX	Fax *
Print on Check As	Name on Check *
ADDRESS 1	Address Line 1 *
ADDRESS 2	Address Line 2 *
CITY	City *
STATE	State/Province *
ZIP	Post Code *
COUNTRY	Country *
DEFAULT PAYABLES ACCOUNT	Default AP Account *
DEFAULT EXPENSE ACCOUNT (N/A for Employees)	Default Expense Account *
TERMS (N/A for Employees)	Default Payment Terms
Currencies (N/A for Employees)	Vendor Currencies
Subsidiary List (MineralTree custom field to retrieve subsidiary assocations)	Subsidiary

NetSuite	MineralTree
If Bill, then VENDOR If Expense Report, then EMPLOYEE	Vendor Name *
SUBSIDIARY	Subsidiary *
If Bill, then REFERENCE NO. If Expense Report, then EXP. REPT #	Invoice Number
DATE	Invoice Date *
DUE DATE (N/A for Expense Reports)	Due Date *
TERMS (N/A for Expense Reports)	Terms
DISC. AMT. (N/A for Expense Reports)	Discount Amount
DISC. DATE (N/A for Expense Reports)	Discount Date
CURRENCY	Invoice Currency *
If Bill, then AMOUNT If Expense Report, then EXPENSES TOTAL	Gross Amount *
ACCOUNT	AP Account *
POSTING PERIOD	Posting Period
DEPARTMENT (N/A for Expense Reports)	Department
CLASS (N/A for Expense Reports)	Class
LOCATION (N/A for Expense Reports)	Location
MEMO (N/A for Expense Reports)	Memo
Currency Code	Currency Code *
Exchange Rate	Exchange Rate *

* required field for outbound sync ("push") to NetSuite
** not visible in MineralTree UI but relevant to application functionality