Updating Imported Bank Data

On the Match Bank Data page, you can manually update your bank data for a financial institution account. Only do this if your NetSuite account doesn’t have the latest data from your bank, or there was an import error. Otherwise, wait for the next scheduled import. For details on automatic importing, see Automatic Bank Data Import.

Note:

To do this procedure, automatic bank data import must be set up for your financial institution. For details, see Creating Financial Institution Records.

Warning:

If you’re using an SFTP connection (like the Auto Bank Statement Import SuiteApp) to get data for multiple accounts, don’t do this procedure. The system only gets data for the account you select. Data from other accounts won’t be updated and may get lost.

To update imported bank data:

  1. Go to Transactions > Bank > Match Bank Data.

  2. From the Account list, select the bank or credit card account for which you want to update your data.

    Note:

    As of NetSuite 2021.1, all newly–created accounts automatically appear in the Account list. If your account does not appear, see Editing Accounts to Use the Match Bank Data and Reconcile Account Statement Pages.

    The following fields are populated:

    • Subsidiary (if applicable).

    • Bank Balance, if your most recent account statement contains an account balance and statement date.

    • Balance As Of, if the statement contains a statement date.

    If NetSuite failed to import data for the account, a popup messages displays the latest error. For more error details, go to Transactions > Bank > Banking Import History. See Banking Import History.

    If NetSuite imported data successfully, the grids fill with the latest imported bank lines and account transactions.

  3. At the top of the page, click Update Imported Bank Data.

    If successful, NetSuite displays a message that an import's in process and gets the latest data from your account. To view the processing status of your import, click Track your status.

    If unsuccessful, NetSuite updates your imported bank data at the next scheduled import. A manual update fails when:

    • You have not selected an account.

    • Your account data is up to date.

    • Your account is not configured with a bank connection.

    • You have imported bank data within the last 60 minutes.

      Note:

      In previous releases, the threshold was 30 minutes

    • There was an error during the data retrieval process.

  4. To see the latest data, refresh the Imported Bank Data grid by clicking the Refresh icon.

    If the import is done, the grid shows your latest data. Dimmed lines are still processing—you can’t select them yet. To check if they’re done, refresh the grid again. Processing takes longer with lots of imported lines.

    The Intelligent Transaction Matching feature automatically matches newly imported data with existing account transactions in NetSuite. To match and reconcile your data, see Reconciling Bank and Credit Card Statements.

Related Topics

General Notices