NetSuite Integration Guide

You can connect Float to NetSuite to sync your chart of accounts, vendors, tax codes, and other accounting data. This guide walks you through setting up the integration, configuring your clearing account, and preparing transactions for export.

Please note: NetSuite integrations are available only to customers on the Professional Plan. Please reach out to support@floatfinancial.com to upgrade!

Guide Overview

What you need to do before connecting Float to NetSuite

How to create a Clearing account in NetSuite

How to connect NetSuite to Float

How to set your Clearing account in Float

What data syncs between Float and NetSuite

How to categorize transactions in Float

How to export transactions to NetSuite

What you need to do before connecting Float to NetSuite

Before connecting Xero to Float, make sure you have:

• Administrator-level user on NetSuite to enable the connection

• Either an Administrator or Bookkeeper user role in Float

  • This is required to be able to connect NetSuite to Float and manage the Clearing Account set up

  • For more details on user roles and their permissions, see: User Roles

• A Float Clearing Account created in NetSuite (instructions below)

   

How to create a Clearing account in NetSuite

Float uses a Clearing account in NetSuite to record the two entries created for every exported transaction.

How to create a Clearing account in NetSuite:

1. Head into Lists > Accounting > Accounts > New > click Continue
2. Type in the following details:
   • Bank Name: Float Bank Account (or any name you prefer)
   • Account Name: Float Balance CAD/USD (or any name you prefer)
   • Account Type: Bank or Credit
   • Account Number: It can be any number (e.g., 123456)
   • Currency: CAD/USD
3. Click "Save and Close" to save

Please note: You will need to create both CAD and USD clearing accounts in NetSuite if you spend in CAD and USD.
 

How to connect NetSuite to Float

Connecting NetSuite to Float:

1. In Float, go to Settings > Accounting Sync

2. Select NetSuite

3. Sign in using your NetSuite credentials

4. A Float form will open where you will paste credentials and identifiers from NetSuite throughout the process, so keep it open in a separate tab while you navigate to your NetSuite account

Get Accounting ID:

• Navigate to Setup > Integration > SOAP Web Services Preferences
• Copy Account ID, paste into the Float form
• 

Enable Web Services:

• Navigate to Setup > Company > Enable Features
• Click the SuiteTalk tab
• Navigate to SuiteTalk (Web Services) section > check the box SOAP WEB SERVICES
• Navigate to Manage Authentication section > check the box TOKEN BASED AUTHENTICATION
• Scroll to the bottom and hit Save
• 

Create an Integration Role:

1. Go to Setup > Users/User Roles > Manage Roles > New
2. For name, enter Float Integration Role
3. Under Subsidiary Restrictions, check All
4. Under Authentication, check Web Services Only Role
5. Under Permissions, please grant the following as per the Permission Table below
6. Once all permissions are added, click Save

Please note: 

• Classes and Departments can be renamed in Netsuite. If you have renamed Classes, then the permission-associated Classes will be renamed as well. For example, if Classes were renamed as Cost Centres, you'll need to select the Lists > Cost Centres permission.
• These permissions are optional and only necessary if you want to sync and track Custom Segments with Float.

Custom Segments: 

1. For each custom segment, go to Customization > Custom Segments > Permissions
2. Set the DEFAULT RECORD ACCESS LEVEL to Edit or set RECORD ACCESS LEVEL to Edit for the Float integration role only
3. Mark down the ID of the Custom Segment as you'll need this once NetSuite has synced to finish creating the Custom Segment

Add the New Role to Your User:

1. Go to Setup > Users/Roles > Manage Users
2. Click on your User and wait for the page to load
3. Click Edit > navigate to the Access tab in the bottom navigation bar
4. Navigate to Roles > add the Float Integration Role
5. Click Save

Create an Integration:

1. Go to Setup > Integrations > Manage Integrations > New
2. Under Name, type in Float Integration
3. Under Authentication
   1. Check Token Based Authentication
   2. Uncheck TBA: Authorization Flow
4. Under Oauth 2.0, uncheck Authorization Code Grant
5. Click Save and do not navigate away from the page
6. Copy the Consumer Key and Consumer Secret, and paste them into the Float form

Create an Access Token:

1. Go to Setup > Users/Roles > Access Tokens > New
2. For Application Name, select the integration you just created (e.g., "Float Integration")
3. For User, select your user
4. For Role, select the role you just created (e.g., "Float Integration Role")
5. The Token Name will be generated automatically
6. Click Save and do not navigate away from the page
7. Copy the Token Key and Token Secret > paste them into the Float form

Submit the Float Connection Form:

1. Go back to the Float form > click Connect and wait a few seconds for the connection to finish 
2. Once connected, hit the blue Sync button and wait for your NetSuite data to flow into Float

How to set your Clearing account in Float

Once the initial data sync completes, the next step is to configure the NetSuite Integration by selecting a Subsidiary and Clearing Account.

The Subsidiary chosen should reflect the Business that has been set up in the Float account, while the Clearing Account will be used as the credit account for all transactions exported to NetSuite

Setting your NetSuite clearing account in Float:

After connecting Xero to your Float account, you can set the Clearing account you created in Xero in your Float settings. To do so:

1. Go to Settings > Accounting Sync

2. In the CAD Clearing Account section, select the Float Clearing Account you created from the dropdown list

Please note: NetSuite users also set up their Reimbursements Clearing account from here if you use the feature. For more information on your Reimbursement Clearing account setup, please review this article: Reimbursements & NetSuite

Setting up Custom Segments in Float:

1. Ensure you have the correct permissions set up
2. Add a new Custom Segment
3. Enter the Segment ID (found in NetSuite)
4. Click Save
5. Click Sync
6. Once synced, the Custom Segment Name will be synced from NetSuite, and your Custom Segment will be available in Synced Accounting Fields

What data syncs between Float and NetSuite

Once you connect your NetSuite Account, you can initiate the data sync by navigating to Settings > Manage Accounting Connection and clicking the Sync button.

This will pull in the following records from your NetSuite account:

How to categorize transactions in Float

Once your NetSuite data is synced into Float, you can begin categorizing transactions.

Required fields to export transactions to NetSuite:

• GL Code:
  • Imported from NetSuite
  • This is a required field to export your card transactions to NetSuite

Optional fields (not required) to export transactions to NetSuite:

• Receipts:
  • Exported as native attachments in NetSuite
  • Note that "Additional Attachments" are not exported to NetSuite 
• Description:
  • Add a description to describe the transaction
• Tax Code:
  • Imported from NetSuite
• Tax Amount:
  • If a Tax Code is added to a transaction, the Tax Amount will update based on the Tax Code
  • A custom Tax Amount can be added
  • If a receipt is added, you can select the Tax Amount from the receipt
• Tax-Exempt Amount:
  • Can be used to identify a non-taxable part of the expense
  • Ex: A tip from a transaction from a restaurant 
• Vendor:
  • Imported from NetSuite
• Classes/Departments/Locations & Custom Segments (i.e., Custom Fields):
  • Imported from NetSuite

Note, you can update which field Spenders are required to categorize on their transactions through Card Submission Policies.

How to export transactions to NetSuite

Once transactions have been categorized with the required and optional fields, you can export them into NetSuite from the Transaction Exports page. For details, see: Transaction Export Overview.