Before proceeding, make sure you are signed in as an Administrator on NetSuite and that you are a Bookkeeper or Admin on Ramp.
Step 1
- Begin in Ramp and open the Accounting tab - click “Get Started Now”.
- Click on “NetSuite” on the next page
Step 2
- Open up your NetSuite account in another tab or choose the hyperlink in the setup guide
- Copy your Account ID from the URL on your NetSuite account and enter it into the NetSuite ID field in Ramp
- Navigate to Setup->Company and see if the “Subsidiary Settings Manager” option is available. If it is, please select “No, I don’t see that option.”
-
NOTE: If Subsidiaries are enabled for your NetSuite account, DO NOT PROCEED. Instead, go to our multiple subsidiaries guide and follow the steps there.
- Click Continue when complete
Step 3
- On the next page, click the hyperlink or navigate in your NetSuite account to Setup -> Company and click Enable Features. Then click the SuiteCloud tab.
- Ensure that the checkboxes for SOAP WEB SERVICES, REST WEB SERVICES, and TOKEN BASED AUTHENTICATION are checked (note that the latter checkbox is under 'Manage Authentication, rather than SuiteTalk)
- Click Save in NetSuite and click Continue on the Ramp setup page.
Step 4
- Use the hyperlink in Ramp or navigate to Setup -> Integration -> Manage Integrations -> New
- Enter this information on the Integration Record:
- Name: Ramp Integration
- Check the boxes for Token-Based Authentication, TBA: Issuetoken Endpoint, and TBA: Authorization Flow
- Callback URL: https://ramp.com/tba/netsuite/complete
- Make sure the box is unchecked for the Authorization Code Grant
- Click Save - then copy the Client ID and Client Secret codes to input into Ramp
- Do Not click off of this page until you have moved on - if you do, you will not be able to access the secret codes again
- Click Continue in Ramp once this is complete
Step 5
- Use the Hyperlink or navigate to Setup > Users/Roles > Manage Roles
- Find the role called "Accountant" and click "Customize." (if you don't see this role, check "Show Inactives.")
- Call the role "Ramp Accountant"
|
Permission ID
|
Permission Name
|
Valid Levels
|
|
TRAN_PAYMENTAUDIT
|
Access Payment Audit Log
|
VIEW
|
|
ADMI_ACCTSETUP
|
Set Up Accounting
|
FULL
|
|
LIST_TAXDETAILSTAB
|
Tax Details Tab
|
FULL
|
|
TRAN_INVADJST
|
Adjust Inventory
|
EDIT
|
|
TRAN_PURCHORDBILL
|
Bill Purchase Orders
|
EDIT
|
|
TRAN_PURCHORDRECEIVE
|
Receive Order
|
EDIT
|
|
TRAN_VENDBILL
|
Bills
|
FULL
|
|
TRAN_BUILD
|
Build Assemblies
|
EDIT
|
|
TRAN_WORKORDBUILD
|
Build Work Orders
|
EDIT
|
|
TRAN_CASHSALE
|
Cash Sale
|
EDIT
|
|
TRAN_CHECK
|
Check
|
EDIT
|
|
TRAN_WORKORDCLOSE
|
Close Work Orders
|
EDIT
|
|
TRAN_INVCOUNT
|
Count Inventory
|
FULL
|
|
TRAN_ALLOCSCHEDULE
|
Create Allocation Schedules
|
EDIT
|
|
TRAN_CREATEINVCOUNT
|
Create Inventory Counts
|
FULL
|
|
TRAN_CARDCHRG
|
Credit Card
|
FULL
|
|
TRAN_CARDRFND
|
Credit Card Refund
|
FULL
|
|
TRAN_CUSTCRED
|
Credit Memo
|
FULL
|
|
TRAN_VENDAUTHCREDIT
|
Credit Returns
|
FULL
|
|
TRAN_FXREVAL
|
Currency Revaluation
|
EDIT
|
|
TRAN_CUSTDEP
|
Customer Deposit
|
EDIT
|
|
TRAN_CUSTPYMT
|
Customer Payment
|
EDIT
|
|
TRAN_DEPOSIT
|
Deposit
|
EDIT
|
|
TRAN_DEPAPPL
|
Deposit Application
|
EDIT
|
|
TRAN_INVDISTR
|
Distribute Inventory
|
EDIT
|
|
TRAN_WORKORDCOMPLETE
|
Enter Completions
|
EDIT
|
|
TRAN_OPENBAL
|
Enter Opening Balances
|
EDIT
|
|
TRAN_VENDCRED
|
Enter Vendor Credits
|
EDIT
|
|
TRAN_FIND
|
Find Transaction
|
FULL
|
|
TRAN_PRICELIST
|
Generate Price Lists
|
VIEW
|
|
TRAN_STATEMENT
|
Generate Statements
|
VIEW
|
|
TRAN_CUSTINVC
|
Invoice
|
EDIT
|
|
TRAN_CUSTINVCAPPRV
|
Invoice Approval
|
FULL
|
|
TRAN_SALESORDINVOICE
|
Invoice Sales Orders
|
EDIT
|
|
TRAN_WORKORDISSUE
|
Issue Components
|
EDIT
|
|
TRAN_JOURNAL
|
Make Journal Entry
|
EDIT
|
|
TRAN_WORKORDMARKBUILT
|
Mark Work Orders Built
|
EDIT
|
|
TRAN_WORKORDMARKFIRMED
|
Mark Work Orders Firmed
|
EDIT
|
|
TRAN_WORKORDMARKRELEASED
|
Mark Work Orders Released
|
EDIT
|
|
TRAN_VENDPYMT
|
Pay Bills
|
EDIT
|
|
TRAN_TAXPYMT
|
Pay Sales Tax
|
EDIT
|
|
TRAN_POSTVENDORBILLVARIANCE
|
Post Vendor Bill Variances
|
FULL
|
|
TRAN_POSTPERIODS
|
Posting Period on Transactions
|
FULL
|
|
TRAN_PURCHORD
|
Purchase Order
|
EDIT
|
|
TRAN_ITEMRCPT
|
Item Receipt
|
EDIT
|
|
TRAN_RECONCILE
|
Reconcile
|
EDIT
|
|
TRAN_INVREVAL
|
Revalue Inventory Cost
|
FULL
|
|
TRAN_SALESORD
|
Sales Order
|
EDIT
|
|
TRAN_SYSJRNL
|
System Journal
|
VIEW
|
|
TRAN_TIMEBILL
|
Track Time
|
EDIT
|
|
TRAN_TRANSFER
|
Transfer Funds
|
EDIT
|
|
TRAN_INVTRNFR
|
Transfer Inventory
|
EDIT
|
|
TRAN_TRNFRORD
|
Transfer Order
|
FULL
|
|
TRAN_TRNFRORDAPPRV
|
Transfer Order Approval
|
FULL
|
|
TRAN_UNBUILD
|
Unbuild Assemblies
|
EDIT
|
|
TRAN_VENDBILLAPPRV
|
Vendor Bill Approval
|
FULL
|
|
TRAN_VENDPYMTAPPRV
|
Vendor Payment Approval
|
FULL
|
|
TRAN_VENDAUTHAPPRV
|
Vendor Return Auth. Approval
|
EDIT
|
|
TRAN_VENDAUTH
|
Vendor Return Authorization
|
EDIT
|
|
TRAN_VENDAUTHRETURN
|
Vendor Returns
|
EDIT
|
|
TRAN_GATEWAYNOTIFICATION
|
N/A
|
VIEW
|
|
TRAN_PAYMENTEVENT
|
View Payment Events
|
VIEW
|
|
TRAN_WORKORD
|
Work Order
|
EDIT
|
|
TRAN_WOCLOSE
|
Work Order Close
|
EDIT
|
|
TRAN_WOCOMPL
|
Work Order Completion
|
EDIT
|
|
TRAN_WOISSUE
|
Work Order Issue
|
EDIT
|
|
REPO_ACCOUNTDETAIL
|
Account Detail
|
VIEW
|
|
REPO_AP
|
Accounts Payable
|
VIEW
|
|
GRAP_AP
|
N/A
|
VIEW
|
|
REPO_AR
|
Accounts Receivable
|
VIEW
|
|
GRAP_AR
|
N/A
|
VIEW
|
|
REPO_AMORTIZATION
|
Amortization Reports
|
VIEW
|
|
REPO_BALANCESHEET
|
Balance Sheet
|
VIEW
|
|
REPO_DEFERREDEXPENSE
|
Deferred Expense Reports
|
VIEW
|
|
REPO_REMINDEREMPLOYEE
|
Employee Reminders
|
VIEW
|
|
GRAP_EXP
|
N/A
|
VIEW
|
|
REPO_FINANCIALS
|
Financial Statements
|
VIEW
|
|
REPO_GL
|
General Ledger
|
VIEW
|
|
GRAP_INC
|
N/A
|
VIEW
|
|
REPO_PANDL
|
Income Statement
|
VIEW
|
|
REPO_INVENTORY
|
Inventory
|
VIEW
|
|
REPO_SNAPSHOTLEAD
|
Lead Snapshot/Reminders
|
VIEW
|
|
GRAP_NETWORTH
|
N/A
|
VIEW
|
|
REPO_PURCHASEORDER
|
Purchase Order Reports
|
VIEW
|
|
REPO_PURCHASES
|
Purchases
|
VIEW
|
|
REPO_CUSTOMIZATION
|
Report Customization
|
FULL
|
|
REPO_SCHEDULE
|
Report Scheduling
|
FULL
|
|
REPO_SALES
|
Sales
|
VIEW
|
|
REPO_SALES_PARTNER
|
Sales By Partner
|
VIEW
|
|
REPO_SALES_PROMO
|
Sales By Promotion Code
|
VIEW
|
|
REPO_SALESORDER
|
Sales Order Fulfillment Reports
|
VIEW
|
|
REPO_BOOKINGS
|
Sales Order Reports
|
VIEW
|
|
REPO_NONPOSTING
|
Sales Order Transaction Report
|
VIEW
|
|
REPO_ANALYTICS
|
SuiteAnalytics Workbook
|
EDIT
|
|
REPO_TAX
|
Tax
|
VIEW
|
|
REPO_TIME
|
Time Tracking
|
VIEW
|
|
REPO_TRAN
|
Transaction Detail
|
VIEW
|
|
REPO_TRIALBALANCE
|
Trial Balance
|
VIEW
|
|
LIST_ACCOUNT
|
Accounts
|
FULL
|
|
REGT_ACCTPAY
|
Accounts Payable Register
|
EDIT
|
|
REGT_ACCTREC
|
Accounts Receivable Register
|
EDIT
|
|
LIST_AMORTIZATION
|
Amortization Schedules
|
EDIT
|
|
REGT_BANK
|
Bank Account Registers
|
EDIT
|
|
LIST_BILLOFMATERIALSINQUIRY
|
Bill Of Materials Inquiry
|
VIEW
|
|
LIST_CRMGROUP
|
CRM Groups
|
EDIT
|
|
LIST_CALENDAR
|
Calendar
|
FULL
|
|
LIST_CHECKITEMAVAILABILITY
|
Check Item Availability
|
VIEW
|
|
LIST_CLASS
|
Classes
|
FULL
|
|
LIST_ORDER_REALLOCATION
|
Commit Orders
|
VIEW
|
|
LIST_COMPETITOR
|
Competitors
|
EDIT
|
|
LIST_COMPONENTWHEREUSEDINQUIRY
|
Component Where Used
|
VIEW
|
|
LIST_CONTACT
|
Contacts
|
FULL
|
|
LIST_COSTEDBOMINQUIRY
|
Costed Bill Of Materials Inquiry
|
VIEW
|
|
REGT_CREDCARD
|
Credit Card Registers
|
EDIT
|
|
LIST_CUSTJOB
|
Customers
|
FULL
|
|
LIST_DEPARTMENT
|
Departments
|
FULL
|
|
LIST_FILECABINET
|
Documents and Files
|
FULL
|
|
LIST_EMAILTEMPLATE
|
Email Template
|
EDIT
|
|
LIST_EMPLOYEE_RECORD
|
Employee Record
|
FULL
|
|
LIST_EMPLOYEE
|
Employees
|
EDIT
|
|
REGT_EQUITY
|
Equity Registers
|
EDIT
|
|
LIST_EVENT
|
Events
|
FULL
|
|
LIST_CATEGORY
|
Expense Categories
|
FULL
|
|
LIST_EXPORT
|
Export Lists
|
CREATE
|
|
REGT_FIXEDASSET
|
Fixed Asset Registers
|
EDIT
|
|
LIST_INVCOSTTEMPLATE
|
Inventory Cost Template
|
FULL
|
|
LIST_ITEMDEMANDPLAN
|
Item Demand Plan
|
FULL
|
|
LIST_ITEM_REVISION
|
Item Revisions
|
FULL
|
|
LIST_ITEMSUPPLYPLAN
|
Item Supply Plan
|
FULL
|
|
LIST_ITEM
|
Items
|
EDIT
|
|
LIST_LOCATION
|
Locations
|
FULL
|
|
REGT_LONGTERMLIAB
|
Long Term Liability Registers
|
EDIT
|
|
LIST_MFGCOSTTEMPLATE
|
Manufacturing Cost Template
|
FULL
|
|
LIST_MFGROUTING
|
Manufacturing Routing
|
FULL
|
|
LIST_MASSUPDATES
|
Mass Updates
|
EDIT
|
|
LIST_MEMDOC
|
Memorized Transactions
|
EDIT
|
|
REGT_NONPOSTING
|
Non Posting Registers
|
EDIT
|
|
LIST_HISTORY
|
Notes Tab
|
VIEW
|
|
REGT_OTHASSET
|
Other Asset Registers
|
EDIT
|
|
REGT_OTHCURRASSET
|
Other Current Asset Registers
|
EDIT
|
|
REGT_OTHCURRLIAB
|
Other Current Liability Registers
|
EDIT
|
|
LIST_OTHERNAME
|
Other Names
|
EDIT
|
|
LIST_FIND
|
Perform Search
|
FULL
|
|
LIST_CALL
|
Phone Calls
|
FULL
|
|
LIST_PLANNEDSTANDARDCOST
|
Planned Standard Cost
|
FULL
|
|
LIST_PROJECTTASK
|
Project Tasks
|
FULL
|
|
LIST_PROJECTTEMPLATE
|
Project Templates
|
VIEW
|
|
LIST_JOB
|
Jobs
|
EDIT
|
|
LIST_RESOURCE
|
Resource
|
CREATE
|
|
LIST_STANDARDCOSTVERSION
|
Standard Cost Version
|
FULL
|
|
LIST_SUBSIDIARY
|
Subsidiaries
|
FULL
|
|
LIST_TASK
|
Tasks
|
FULL
|
|
LIST_TAXITEM
|
Tax Records
|
EDIT
|
|
LIST_CRMMESSAGE
|
Track Messages
|
EDIT
|
|
REGT_UNBILLEDREC
|
Unbilled Receivable Registers
|
EDIT
|
|
LIST_UNIT
|
Units
|
EDIT
|
|
LIST_VENDOR
|
Vendors
|
FULL
|
|
LIST_CURRENCY
|
Currency
|
FULL
|
|
LIST_WORKCALENDAR
|
Work Calendar
|
VIEW
|
|
ADMI_MANAGE_OAUTH_TOKENS
|
Access Token Management
|
FULL
|
|
ADMI_ACCOUNTINGLIST
|
Accounting Lists
|
EDIT
|
|
ADMI_DELETEDRECORD
|
Deleted Records
|
FULL
|
|
ADMI_LOGIN_OAUTH
|
Log in using Access Tokens
|
FULL
|
|
ADMI_ACCTPERIODS
|
Manage Accounting Periods
|
VIEW
|
|
ADMI_MOBILE_ACCESS
|
Mobile Device Access
|
FULL
|
|
ADMI_EMPLOYEELIST
|
Other Lists
|
EDIT
|
|
ADMI_RESTWEBSERVICES
|
REST Web Services
|
FULL
|
|
ADMI_WEBSERVICES
|
SOAP Web Services
|
FULL
|
|
ADMI_SUBSIDIARYSETTINGSMANAGER
|
Subsidiary Settings Manager
|
VIEW
|
|
ADMI_BUNDLER
|
SuiteBundler
|
FULL
|
|
ADMI_CUSTBODYFIELD
|
Custom Body Fields
|
FULL
|
|
ADMI_CUSTCATEGORY
|
Custom Center Categories
|
FULL
|
|
ADMI_CUSTCENTER
|
Custom Centers
|
FULL
|
|
ADMI_CUSTCOLUMNFIELD
|
Custom Column Fields
|
FULL
|
|
ADMI_CUSTEMAILLAYOUT
|
Custom HTML Layouts
|
FULL
|
|
ADMI_CUSTENTITYFIELD
|
Custom Entity Fields
|
FULL
|
|
ADMI_CUSTENTRYFORM
|
Custom Entry Forms
|
FULL
|
|
ADMI_CUSTEVENTFIELD
|
Custom Event Fields
|
FULL
|
|
ADMI_CUSTFIELD
|
Custom Fields
|
FULL
|
|
ADMI_CUSTFIELDTAB
|
Custom Subtabs
|
FULL
|
|
ADMI_CUSTFORM
|
Custom Transaction Forms
|
FULL
|
|
ADMI_CUSTITEMFIELD
|
Custom Item Fields
|
FULL
|
|
ADMI_CUSTITEMNUMBERFIELD
|
Custom Item Number Fields
|
FULL
|
|
ADMI_CUSTLAYOUT
|
Custom PDF Layouts
|
FULL
|
|
ADMI_CUSTLIST
|
Custom Lists
|
FULL
|
|
ADMI_CUSTOMSCRIPT
|
SuiteScript
|
FULL
|
|
ADMI_CUSTOMSUBLIST
|
Custom Sublists
|
FULL
|
|
ADMI_CUSTOTHERFIELD
|
Other Custom Fields
|
FULL
|
|
ADMI_CUSTRECORD
|
Custom Record Types
|
FULL
|
|
ADMI_CUSTRECORDFORM
|
Online Custom Record Form
|
FULL
|
|
ADMI_CUSTSECTION
|
Custom Center Tabs
|
FULL
|
|
ADMI_CUSTTASKS
|
Custom Center Links
|
FULL
|
|
ADMI_CUSTTRANFIELD
|
Custom Transaction Fields
|
FULL
|
|
ADMI_CUSTTRANSACTION
|
Custom Transaction Types
|
FULL
|
|
ADMI_MANAGECUSTOMSEGMENTS
|
Custom Segments
|
FULL
|
- Click Save and Continue in Ramp
Step 6
- Use the Hyperlink or navigate in NetSuite to Transactions > Bank >Use Credit Card & click Customize Form
- Go to Screen Fields > New Field
- In the Label field, enter "ramp_receipt_url"
- In the ID field, enter "ramp_receipt_url"
- In the Type field, select Hyperlink
- In the Applies To tab, check PURCHASE and VENDOR PAYMENT
- In the Display tab, ensure that "Main" is selected in the Subtab dropdown
- In the Access tab, ensure that the Default Access Level is Edit
- Click Save and Continue in Ramp
Step 7
- Use the hyperlink or navigate to Setup → Users/Roles → Manage Users
- Find and Edit your Admin user
- Scroll down and click on the Access tab
- Add the Ramp Accountant role, click Save in NetSuite, and Continue in Ramp
Step 8
- First, go to https://assets.ramp.com/accounting/ramp_restlet.js. This should download a file onto your computer. If it doesn't, right-click anywhere on the page, click "Save As," and then save the file as ramp_restlet.js.
- In NetSuite, click on Documents -> files and click the SuiteScripts folder
- Click Add File in the top left, and select the ramp_restlet.js file you downloaded
- Click Continue in Ramp for the next step
Step 9
- Use the Hyperlink or navigate to Customization → Scripting → Scripts → New
- Select the file (ramp_reslet) that you added earlier, and click Create Script Record
- Name the script "Ramp Integration API", then click the arrow on the Save button and click Save & Deploy
- Click continue in Ramp to move to the next step
Step 10
- On the deployment screen, input this information:
- Status: Released
- Log Level: Error
- Under the Audience tab, check the “Select All” checkbox for Roles
- Click save, then copy the EXTERNAL URL, copy your account ID (the digits at the beginning, in this example, 1234567), and save for use later.
- Click Continue in Ramp to move on
Step 11
- Confirm Ramp access to NetSuite by clicking on the Approve access in NetSuite button. This opens up a screen to select the Ramp Accountant role using “Choose Role”, then click “Allow” at the top of the screen.
Step 12
- Once redirected back to Ramp, you will configure your multi-entity settings. If you receive a white screen, please contact your Account Manager or Customer Success Manager for assistance.
Extra set up: Custom segments
For each custom segment you want to view and code in Ramp, the segment must be viewable on the Credit Card, Bill, and/or Bill Payment Forms, and the following permissions set for the Ramp Accountant Role:
- Value Management Access: Full
- Record Access: Edit
- Search/Reporting Access: Edit.
To view custom segments, on NetSuite, go to Customization -> Lists, Records, & Fields -> Custom Segments. Then click edit next to the segment you'd like to view on Ramp and add the permissions in the Permissions tab laid out above (picture below).
Learn more about advanced configurations recommendations for NetSuite to take full advantage of Ramp and reduce sync errors.