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
- Update your NetSuite Bundle
- Attach the Float Integration Role (Managed) to Your User
- Connect to NetSuite
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:
- Head into Lists > Accounting > Accounts > New > click Continue
- 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
- 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:
- Navigate to Settings in the left navigation panel
- Click Accounting Sync > NetSuite
- At the top of the page, you will see a prompt for the NetSuite Bundle installation
- 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
- You may need to sign in to your NetSuite account first before you can proceed to the next step below
- Click Install in NetSuite
- 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
Attach the Float Integration Role (Managed) to Your User:
- In NetSuite, go to Setup > Users/Roles > Manage Users
- Click on your user and wait for the page to load
- Click Edit > navigate to the Access tab in the bottom navigation bar
- Navigate to Roles > add the Float Integration Role (Managed)
- Click Save
Please note: Attach the role before you connect. You'll need to select it when Float prompts you for a role.
Connect to NetSuite:
- Return to Float and go to Settings > Accounting Sync > NetSuite
- Click Connect
- When prompted to select a role, select Float Integration Role (Managed)
- Click Continue
That's it. You're 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:
Go to Settings > Accounting Sync
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:
- Ensure you have the correct permissions set up
- Add a new Custom Segment
- Enter the Segment ID (also called the Internal ID, which is found in NetSuite)
- Click Save
- Click Sync
- 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
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.