Importing Bank Data Using Australia Bank Feeds SuiteApp

To import your financial institutions and bank accounts data using Australia Bank Feeds SuiteApp, you must first do the following tasks:

  1. Activating SISS Data Services

  2. Connecting to the Data Service Provider

  3. Importing Bank Data to Australia Bank Feeds

  4. Linking Bank Accounts to NetSuite GL Accounts

  5. Adding Bank Transaction Codes (Optional)

Activating SISS Data Services

The SISS Data Services is the data service provider for the Australia Bank Feeds SuiteApp.

To start the bank data import using the Australia Bank Feeds SuiteApp, you must first activate SISS Data Services in your account.

Important:

Using the Australia Bank Feeds SuiteApp in the NetSuite Sandbox environment only connects to SISS Sandbox, thus the bank data that will be imported are all fictitious.

To activate the SISS Data Services, you must perform the following tasks:

  1. Accepting the Terms of Service

  2. Granting Consent to SISS Data Services

Accepting the Terms of Service

To begin using the Australia Bank Feeds SuiteApp, you must first accept and the terms of service.

To accept the terms of service:

  1. Go to Transactions > Bank > Australia Bank Feeds.

  2. In the Available Connections section, the initial connection status for the SISS Data Services is set to Not Yet Activated. To start the activation, in the Actions column, click Activate.

    The Terms of Service popup window opens.

  3. Click OK to accept the terms of service.

After confirming and accepting the terms of service, the SISS Consent popup window opens where you should grant consent to SISS data services. The following section provides details for the same.

Granting Consent to SISS Data Services

In the SISS popup window, you must grant the consent to SISS Data Services to collect your bank information to share with NetSuite.

For the procedure on how to grant consent to SISS Data Services, refer to the SuiteAnswers article Granting Consent to SISS Data Services in Australia Bank Feeds.

Connecting to the Data Service Provider

To display your financial institutions and bank accounts data in the Bank Information section, you must connect to the SISS Data Services. SISS Data Services is the data service provider for this SuiteApp.

To connect to the data service provider:

  1. Go to Transactions > Bank > Australia Bank Feeds.

  2. On the Local Bank Connection page, in the Actions column, click Connect.

    The SISS Credentials popup window opens with the following credential fields automatically populated:

    • Client ID

    • Client Secret Key

    • Subscription Key

  3. In the Connection Name field, enter a name for your new connection.

  4. Click Login.

    After the SuiteApp is done with the bank imports, the connection status for SISS Data Services changes to Connected.

  5. To see the newly created connection, click the expand button (>) next to SISS Data Services.

    The newly created connection appears under SISS Data Services, and its status also shows Connected.

  6. To add another connection under SISS Data Services, perform steps 1 through 3.

After adding a connection, the bank accounts selected in the SISS Data Services activation appear on the Bank Accounts subtab in the Bank Information section.

Importing Bank Data to Australia Bank Feeds

After connecting to the service provider and establishing a connection, you can now begin importing bank data to Australia Bank Feeds.

Following are two SuiteAnswers articles about the ways you can import bank data to your bank feeds:

Linking Bank Accounts to NetSuite GL Accounts

To import bank accounts and transactions to NetSuite, you must link them to NetSuite GL accounts.

The SuiteApp enables you to select bank accounts that you want to link to a NetSuite GL account. If you do not want to link a particular bank account, you can leave it unlinked.

Linking bank accounts to NetSuite GL accounts will prompt you to create a new account profile.

To link a bank account to a NetSuite GL account:

  1. Go to Transactions > Bank > Australia Bank Feeds.

  2. In the Bank Information section, under the Bank Accounts subtab, click Update Account Profile.

  3. Expand the button for the bank where you want to link bank accounts to GL accounts.

  4. Select the account where you want to link a GL account and in the Linked GL Account column, select the GL account.

  5. Click Save Changes.

    You can either override an existing account profile or create a new one.

    1. To override the changes for the current account profile, click Override Changes.

    2. To create a new account profile, do the following steps:

      1. Click Create New.

      2. In the Account Profile field, enter a name for the account profile.

      3. Click Save.

        Saving the account profile triggers the bank import into your selected NetSuite GL accounts.

  6. To check the status of the bank import, go to the Bank Import History subtab.

    If the status of the recent bank import shows a green check, the import is complete.

After completing bank imports, you can perform bank reconciliation. For more information, see help topic Bank Data Matching and Reconciliation.

Adding Bank Transaction Codes (Optional)

The Australia Bank Feeds SuiteApp lets you map transaction codes for each transaction types. This enables NetSuite to correctly import and map your transactions.

Contact your bank for your specific bank transaction code. For more information about transaction codes also supported by this SuiteApp, see Supported Transaction Codes for Bank Statement Parsers SuiteApp.

To add a bank transaction code:

  1. Go to Transactions > Bank > Australia Bank Feeds.

  2. In the Bank Information section, click the Bank Transaction Codes subtab.

  3. In the Bank Transaction Code field, enter the bank transaction code that applies to your transaction.

  4. In the Description field, enter a description for the bank transaction code.

  5. From the Bank Data Type list, select the bank data type for the transaction.

  6. From the Credit/Debit field, select one of the following:

    • Credit if the transaction type is credit.

    • Debit if the transaction type is debit.

    • Not Applicable if the transaction is neither debit nor credit.

  7. Click Save Changes.

Related Topics

Australia Bank Feeds SuiteApp
Installing the Australia Bank Feeds SuiteApp
Roles and Permissions for Australia Bank Feeds SuiteApp
Availability of Foreign Currency Accounts
Viewing Reasons for Account Status Problems
Setting the Span of Bank Data Imports
Disconnecting to the Data Service Provider
Australia Bank Feeds FAQs

General Notices