The simplest way to connect Netsuite to Drivepoint is to enable nightly automated email reports to an email address specifically created for import into Drivepoint. The below guide details how to configure and enable this connection. If you are interested in a more custom approach utilizing FTP or a Cloud Storage Bucket, please see the guides below and contact your CSM team for support.
Integration Methods
Email Method (Recommended)
Step 1 - Obtain your dedicated Drivepoint x Netsuite email address
Your account manager can provide you with your unique Drivepoint x Netsuite email address. Please reach out to them directly if you didn't receive this during your onboarding process.
Step 2 - Configure Custom Reports
Configure two new custom reports, based on Netsuite Standard Reports. You will need to customize each report to use a ‘monthly’ date breakdown. The reports that need customization are:
Income Statement report file should be in CSV format named income_statement
Balance Sheet report file should be in CSV format named balance_sheet
Step 3 - Set Up Nightly Delivery to your Drivepoint x Netsuite email address
We will walk you through each of the steps in detail below.
FTP Method
You’ll need to create a destination on your FTP server where reports will be uploaded from Netsuite. Make sure uploaded report files have proper name and format and are replaced with a fresh ones at the desired frequency:
Income Statement report file should be in CSV format named income_statement
Balance Sheet report file should be in CSV format named balance_sheet
Provide us with the following data to access FTP for those reports:
FTP host
FTP port
username
password
directory path on FTP with reports
Direct Delivery via Upload to Cloud Storage Bucket
We will create netsuite_reports bucket in your Cloud Storage storage and prepare service account JSON access key that will have access only to that bucket.
You can then use provided key to connect your service to netsuite_reports bucket.
You can then set up Netsuite reports upload, make sure uploaded report files have proper name and format and are replaced with a fresh ones at the desired frequency:
Income Statement report file should be in CSV format named income_statement
Balance Sheet report file should be in CSV format named balance_sheet
Email Method - Setting up Custom Reports in Netsuite
💡Custom reports will ensure that the Drivepoint forecasts incorporate the correct Netsuite data and data is synced daily.
Step-by-step Balance Sheet Setup Guide
The balance sheet should look like this sample Balance Sheet. Feel free to keep it open while you are going through the setup guide to compare.
Open Netsuite in your browser
Click on “Reports” field in the top navigation bar
Select “New Financial Report”
Select “Balance Sheet” in the view list of all reports
This should open up the “Financial Report Builder” View
Name “Drivepoint Balance Sheet”
Click on “Edit Columns” in the header next to “Edit Layout”
This should open up the “Reports Review” View
Select “Accounting Period” in “View by Columns Field”
This should now show “Financial Row” in the first column
Click on “Preview” to see the balance sheet
This should open up the balance sheet view (it can take a few seconds to load!)
Navigate to the footer of the balance sheet preview to set the periods:
“End Of”: should say "Custom:
No need to select anything here, it will automatically adjust when you set the time period in the next step
“As of”: set to earliest month of financial records
❗️If “As of” is not available, select From: Earliest month of financial records: To: “The furthest point in the future, (likely the last month of this year)
💡This will help us to receive all historical financial information as well as all future financial information. We will set up a maintenance call to expand the period if you selected “From” - “To” period at the end of the year.
“Column”: should say “Accounting period”
You should see the full balance sheet starting from your first financial accounting period to the most recent one (navigate to Step 13 if you do - we are halfway there!)
💡If you are unable to see the full balance sheet. You can try the following hacks:
Select specific subsidiary in the footer of the “preview”
Click “Save” in the Financial Report Builder
This should open up the “Balance Sheet” preview again
Navigate to the right footer of the balance sheet
Click on the “Calendar icon” (🗓️)
Should be the icon on the outside (next to the ✉️icon)
Should open up a window called “Schedule Report”
Select the date of tomorrow as the first day of sending it
Select a time at night (2-5am) to send the report to the Drivepoint team
Click on the check box: “Run report more than once”
Select “Daily Event”; Repeat every “1” day
NO end date
Insert Drivepoint email address in the “Email” field
This can be found in the 3rd column of the table
You can find the email address in your inbox or on the Netsuite setup page in the Drivepoint web-app
The email address should look similar to the following: companyname-netsuite@bainbridgegrowth.com
Click on “Message” in the blue navigation bar next to “Recipients”
Type in “balance_sheet” in the message text box
Select “CSV” from drop-down menu below the message text box
This ensures Drivepoint receives your data in the correct format
Hit save
Double check the scheduled report is showing up by navigating to “Reports” (top header) → “ Scheduled Reports”
Congrats🎉 - you set up the balance sheet report! Let’s move to the income statement.
Step-by-step Income Statement Setup Guide
💡 Most of our clients have additional dimensions segmenting the financial rows from the account periods. Here is a template of how the income statement with classes should look like. Feel free to keep it open while you are going through the setup guide to compare.
Open Netsuite in your browser
Click on “Reports” field in the top navigation bar
Select “New Financial Report”
Select “Income Statement” in the view list of all reports
This should open up the “Financial Report Builder” View
Name “Drivepoint Income Statement”
Click on “Edit Columns” in the header next to “Edit Layout”
This should open up the “Reports Review” View
Select “Accounting Period” in “View by Columns Field”
This should now show “Financial Row” in the first column
Search for your desired dimension in the search box on the left
❗️Some of our clients use classes, customer, sales channel, business units or cost centers to further segment their financials. You can add whatever feels appropriate up to two additional dimensions💡Sometimes dozens of classes show up with the same name. Some of them are only available for the parent company so it is important to continue checking whether the data shows up through the “Preview” capability.
Drag the class you are selected into the table on the right
Move left or right to place them in between the financial rows and accounting period
Or click remove if you accidentally selected the wrong class
Click on “Preview” to see the income statement
This should open up the income statement view (it can take a a few seconds to load!)
Double check that you have selected the correct classes
Some of our customers have classes with the same title but only one with the correct values
Navigate to the footer in the income statement preview to set the periods
“End Of”: should say "Custom"
No need to select anything here, it will automatically adjust when you set the time period in the next step
“As of”: set to earliest month of financial records
❗️If “As of” is not available, select: From: Earliest month of financial records: To: ‘The furthest point in the future’, (likely the last month of this year)
💡This will help us to receive all historical financial information as well as all future financial information. We will set up a maintenance call to expand the period if you selected “From” - “To” period at the end of the year.
“Column”: should say “Accounting period”
Click “Refresh” and see any potential updates if not updated automatically
Click “Save” in the Financial Report Builder to save the “Drivepoint Income Statement”
This should open up the full income statement view again
Navigate to the right footer of the income statement
Click on the “Calendar icon” (🗓️)
Should be the icon on the outside (next to the ✉️icon)
Should open up a window called “Schedule Report”
Select the date of tomorrow as the first day of sending it
Select a time at night (2-5am) to send the report to the Drivepoint team
Click on the check box: “Run report more than once”
Select “Daily Event”; Repeat every “1” day
NO end date
Insert Drivepoint email address in the “Email” field (3rd column of the table)
You can find the email address in your inbox or on the Netsuite setup page in the Drivepoint web-app
The email address should look similar to the following: companyname-netsuite@bainbridgegrowth.com
Click on “Message” in the blue navigation bar next to “Recipients”
Type in “income_statement” in the message textbox
Select “CSV” from drop-down menu below the message textbox
This ensures Drivepoint receives your data in the correct format
Hit save to save the scheduled daily report
Double check the scheduled report is showing up by navigating to “Reports” (top header) → “ Scheduled Reports”
Congrats🎉 - you set up the income statement report!
❗️LAST IMPORTANT STEP: Navigate to the Drivepoint web-app and click on “Connect Netsuite” on the bottom right. You should see a field that is toggled on to show the live Netsuite integration🤝!
Frequently Asked Questions
Which email should I use for setting up the email integration?
Get access to Drivepoint via the email invite from your Drivepoint Representative or no-reply@drivepoint.io in your inbox.
Make sure to check your spam folder as well.
The format of the email you will need to schedule Netsuite reports to should look like the following: companyname-netsuite@bainbridgegrowth.com
Did not receive an email? Please email support@drivepoint.io with the subject line: “Missing Drivepoint Login for Netsuite”.
I am not sure where to start with this. What are the basics I should do?!
All you really need to get started is to create 2 reports:
You can always add other reports later and adding extra dimensions for the P&L including class, sales channel, etc., it is not needed for the stage of setting up the integration.
My data is not showing up in my add-in. What should I do?
Your data will only show up after the first email has been sent from Netsuite. It could therefore take some time to show up. If you still have concerns after 48h, email support@drivepoint.io or speak to your Drivepoint Representative.
I would like to have extra granularity in my forecasting. What should I do?
💡Some of our clients create extra reports for incorporating granular data from various channels
If you would like to have extra granularity in your financial model Drivepoint supports two extra dimensions (columns) for a Netsuite report
You will need to:
Prepare the report in Netsuite in the format similar to the image below with column B being “Class” and column C being any other extra dimension. Or find the link to the sample Income Statement here.
Send the report sample via email (support@drivepoint.io with the subject: “Custom Netsuite Report”), slack your Drivepoint representative or bring it up in the next call with the Drivepoint team so we can properly map those columns to the internal fields.
Schedule the report delivery in Netsuite to your custom Netsuite-Drivepoint integration email.
