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:

Step 3 - Set Up Nightly Delivery to your Drivepoint x Netsuite email address

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:

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

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” 💡 We CANNOT process the Balance Sheet if it's not called exactly "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:

Click “Save” in the Financial Report Builder This should open up the “Balance Sheet” preview agai

Navigate to the right footer of the balance shee

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 i

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: [email protected]

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.

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” 💡 We CANNOT process the Income Statement if it's not called exactly "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

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)
&#xNAN;��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: [email protected]

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!