Connect NetSuite to Bookkeep for Payout Deposit Matching

This guide walks through connecting your NetSuite account so that Bookkeep can post your daily sales and reconcile your payouts into bank deposits. The setup takes about 25 minutes and requires a NetSuite Administrator.

info

Payout deposit matching needs a different set of NetSuite permissions than a standard sales-only connection. In particular, the role needs Deposit at level Full, view access to customer payment and refund transactions, and REST Web Services enabled. If you only need daily sales summaries posted, see How to Connect NetSuite to Bookkeep.

By the end you will have five values to paste into Bookkeep:

Value	Where you get it
Account ID	Step 6
Consumer Key	Step 7
Consumer Secret	Step 7
Token ID	Step 8
Token Secret	Step 8

1. Enable the NetSuite features

Go to Setup > Company > Enable Features and click the SuiteCloud subtab. Tick all three, then Save:

1. Under Manage Authentication: Token-Based Authentication
2. Under SuiteTalk (Web Services): SOAP Web Services
3. Under SuiteTalk (Web Services): REST Web Services

You can tick all three before saving.

2. Create the Bookkeep role

Go to Setup > Users/Roles > Manage Roles > New and name the role, for example bookkeep_sync. A dedicated role is required because NetSuite does not allow access tokens for the Administrator role.

On the Permissions > Transactions subtab, add each of these:

Record type	Level
Customer Deposit	View
Customer Payment	View
Customer Refund	View
Cash Sale	View
Cash Refund	View
Credit Memo	View
Return Authorization	View
Deposit	Full
Sales Order	View
Invoice	View
Find Transaction	Full
Make Journal Entry	Full

3. Add the list permissions

On the same role, open the Permissions > Lists subtab and add:

Permission	Level
Accounts	Full
Subsidiaries	View
Classes	View
Departments	View
Locations	View
Customers	View
Currency	View
Items	View
Tax Records	View
Contacts	View
Custom Record Entries	View
Documents and Files	View
Vendors	View

4. Add the setup permissions

On the same role, open the Permissions > Setup subtab and add the following, then Save the role:

Permission	Level
Access Token Management	Full
User Access Tokens	Full
SOAP Web Services	Full
REST Web Services	Full

5. Assign the role to a user

1. Go to Setup > Users/Roles > Manage Users.
2. Find the employee this connection will run as, and click Edit.
3. Open the Access > Roles subtab.
4. Choose the role you just created in the Role field and click Add.
5. Click Save.

6. Get your Account ID

1. Go to Setup > Integration > SOAP Web Services Preferences.
2. Copy the Account Number. This is your Account ID.

7. Create the integration record

1. Go to Setup > Integration > Manage Integrations > New.
2. Give it a name, for example Bookkeep.
3. Set State to Enabled.
4. Open the Authentication subtab and tick Token-Based Authentication. Also tick REST Web Services if it appears here. Untick OAuth 2.0 if it is on.
5. Click Save.
6. Copy the Consumer Key and Consumer Secret from the confirmation page and keep them somewhere safe.

tip

The Consumer Key and Consumer Secret are shown only once. If they are lost, you will need to generate a new set.

8. Create the access token

1. On your NetSuite home page, under Settings, click Manage Access Tokens.
2. Click New My Access Token.
3. Under Application Name, choose the integration you created in step 7.
4. The token name fills in automatically. You can change it.
5. Click Save.
6. Copy the Token ID and Token Secret.

tip

The Token ID and Token Secret are also shown only once. If they are lost, you will need to generate a new access token.

9. Connect in Bookkeep

1. In Bookkeep, go to Connections > Accounting.
2. Choose Connect to NetSuite.
3. Paste in all five values, then click Save.
4. Click Test. You should see NetSuite connection test successful.

Checklist

• Token-Based Authentication, SOAP Web Services and REST Web Services all enabled
• Role created with the transaction, list and setup permissions above
• Role assigned to a user
• Integration record and access token created
• Connection test successful in Bookkeep

Please contact support@bookkeep.com if you have any questions.