Setting up the NetSuite Expense and Bills Data Integration

How do I set up the NetSuite Expense and Bills Data integration?

How do I create a default vendor?

How do I set up the NetSuite Expense and Bills Data integration?

  1. Click on the "Account" tab on the left-hand navigation bar and select "Connections"
  2. Click on NetSuite connection tile under "Accounting service", and click on "Get started" on Bank Feed

    NetSuite_e&b.png
  3. Select the NetSuite Expense and Bills Data tile to open the NetSuite Expense and Bills Data home page. Click the connect button in the top right

    NetSuite_e&b_homepage.png

  4. You will be asked to provide your NetSuite account details to authorise the connection such as Consumer key and secret, Access token and secret, Script ID, and Account ID. Please refer this article for instructions to locate these details.

    Screenshot

  5. After authorising your connection, you will need to select a NetSuite subsidiary to map to your Airwallex account

    Screenshot

  6. Once you’ve selected your NetSuite subsidiary, you will need to map your Airwallex wallet currency accounts with corresponding NetSuite bank accounts. Note you may need to create NetSuite bank accounts for currencies in which you expect to incur expenses, if these do not already exist.

    Screenshot

  7. After reviewing and updating your currency connection, you can import your NetSuite vendors to Airwallex, making it possible for cardholders and payers to select existing NetSuite vendors when coding expenses and bills.
  8. Additionally, you will need to select a default vendor during this step. This is a vendor to which expenses and bills will be coded in NetSuite if an existing vendor is not selected. We recommend creating a default vendor in NetSuite to specifically use for this purpose.

    Screenshot

  9. Finally, you can import and rename your NetSuite accounting data in Airwallex. This includes your chart of accounts (expense accounts and asset accounts), classes, departments, locations, tax codes, and vendors. You can choose to import all or a subset of the data.

    Screenshot

  10. Once you’ve successfully imported your expense and bills data, you can customise which fields you want your employees to submit for their expenses and bills.

    Screenshot

How do I create a default vendor?

A default vendor is a regular NetSuite vendor created for the express purpose of grouping together expenses and bills that are not categorised to an existing vendor. If you do not have a vendor explicitly for this purpose – e.g., an “Airwallex expenses” vendor – we highly recommend you create one at this step in the onboarding process and then click the “refresh vendor list” button in Airwallex to reflect changes.

This selection can always be edited at a later time in “your connection settings”

Screenshot 144.png