Skip to main content

NetSuite Integration Guide

  • Updated

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.

Is this the right guide?

Use this guide if you're connecting Float to NetSuite for the first time. If you already have an active NetSuite integration and you're running into issues, such as export failures or sync issues, those are usually permissions-related. Head to the NetSuite Managed Role Migration Guide instead.

Please note: NetSuite integrations are available only to customers on the Professional Plan. For detailed instructions to update your plan, please review this article: Float Pricing and Plans

 

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 up your Clearing account in Float

What data syncs between Float and NetSuite

How to categorize transactions in Float

How to export transactions to NetSuite

Which NetSuite products can connect to Float?

 

What you need to do before connecting Float to NetSuite

Before connecting NetSuite to Float, make sure you have:

  • An 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 setup

    • 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

Update your NetSuite Bundle:

  1. Navigate to Settings in the left navigation panel 
  2. Click Accounting Sync > NetSuite
  3. At the top of the page, you will see a prompt for the NetSuite Bundle installation 
  4. Click Install Now > this auto-directs you to your NetSuite account
    • You may need to sign in to your NetSuite account first before you can proceed to the next step below
      Untitled.jpg
  5. Click Install in NetSuite
  6. Wait for the bundle status to show green

Some important considerations:

  • During installation, you may see the Installed from field display "Sandbox" or "Production"
  • This field does not affect your setup, so no action is required based on what appears on your screen

Connecting NetSuite to Float:

  1. Once your SuiteBundle is installed, in Float, go back 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 an Accounting ID:

  • Navigate to Setup > Integration > SOAP Web Services Preferences
  • Copy Account ID, paste into the Float form
    Screen Shot 2022-08-17 at 1.19.32 PM.png

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
    Screen Shot 2022-08-17 at 1.20.39 PM.png

Add the Float Integration Role (Managed) 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 (Managed)
  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

Screen Shot 2022-08-17 at 2.58.07 PM.png

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

Screen Shot 2022-08-17 at 2.59.02 PM.png

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 up 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 NetSuite to your Float account, you can set the Clearing account you created in NetSuite 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 and Bill Pay Clearing accounts 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 (also called the Internal ID, which is 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:

Screenshot 2024-12-18 at 11.18.57 AM.png

 

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

Please 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.

 

Which NetSuite products can connect to Float?

At this time, Float's integration with NetSuite only supports NetSuite OneWorld.
 

 

Related articles