On-Demand Data Updates for NetSuite Connected Accounts

Managing your financial data in NetSuite has been taken a notch higher with the ability to update imported data for connected accounts on demand. This functionality is particularly useful for tasks involving bank reconciliation and corporate card expenses, providing real-time accuracy and efficiency in your financial processes. Starting in NetSuite 2026.1, new features have been added to enhance transaction matching and payment date predictions, further improving financial management capabilities.

Understanding On-Demand Updates

Previously, NetSuite users were limited to daily scheduled imports of transaction data available from their Account Information Service Provider (AISP). These AISPs include well-known names such as Yodlee, MX, Salt Edge, and American Express. With advancements in NetSuite plug-ins, users can now initiate data imports on demand, ensuring that transaction records are as up-to-date as possible. This is contingent on having the proper plug-in updates in place.

Note: For bank reconciliation, this feature only supports custom plug-in implementations. The Bank Feeds SuiteApp, for instance, does not currently support on-demand updates, although such support is anticipated in future releases by March 11, 2026.

Implementation Details

To utilize this feature, ensure that your system supports the required plug-in methods. Navigate to Setup > Accounting > Financial Institution, select a financial institution record, and view the Format Profile. A new Update Imported Bank Data button will be visible. This tool instigates an on-demand import for all connected accounts defined in the format profile, provided your plug-ins support it.

For an account-level update, the Update Imported Bank Data button on the Match Bank Data page is available, offering similar functionality for individual accounts.

Scheduled imports set at intervals of 6 or 12 hours have been improved to automatically prompt data updates if your system's plug-ins support such operations.

Enriched Bank Data for Transaction Matching

In addition to on-demand updates, the Enriched Bank Data feature improves the accuracy of matching imported bank transactions to your general ledger (GL) in NetSuite. Generative AI automatically extracts entity information from the memo and payee or payor fields of imported bank transactions, resulting in better matching for ambiguous transactions (transactions with multiple possible matches).

After all system and custom rules have been applied, any transactions that remain unmatched and have multiple potential matches with the same amount are eligible for enrichment-based matching. This process identifies matches with the same amount, a GL transaction date up to seven days before the bank transaction date, and similar extracted entity information. Enrichment-based matching runs during bank data import and when reconciliation rules are run manually. Transactions already matched by system or custom rules aren't considered.

Matched transactions display a multicolored vertical line next to them on the Match Bank Data and Reconcile Account Statement pages. The match details popup indicates when a match is enrichment-based.

This feature is enabled by default, and you need the same permissions required to access the Match Bank Data page and to import bank data. To change the feature's status, sign in as Administrator and go to the Accounting subtab under Setup > Company > Setup Tasks > Enable Features.

Payment Date Prediction for Invoices

Another exciting update in NetSuite 2026.1 is the Payment Date Prediction feature. You can now view predictions for when customers are expected to pay invoices. These predictions are generated using machine learning and are available on the Invoices page and invoice forms.

Note: Payment date predictions use machine learning models based on historical payment data. These predictions are estimates, not guarantees. Use this information as a helpful planning aid, but always consider additional business context and judgment.

To enable the Payment Date Prediction feature (disabled by default), go to Setup > Company > Setup Tasks > Enable Features and open the Accounting subtab (support activation no longer needed). The Administrator role is required. Predictions are updated periodically for all open invoices. The initial set of predictions may take up to one day to appear after enablement.

For more information about payment date predictions, see Payment Date Prediction for Invoices.

Limitations and Considerations

While this enhancement marks significant progress, there are limitations:

• The AMEX Corporate Card Integration SuiteApp uses a file-based import process. It only updates data if a new file is provided by American Express.
• Real-time updates or new file requests from American Express are not performed by the SuiteApp.
• In cases of update failure, account-level error messages may present themselves, providing feedback for troubleshooting.

Developer Insights

Plug-in developers should implement the refreshData(context) method in the Financial Institution Connectivity Plug-in to enable these on-demand updates effectively. For corporate card expenses, also implement getRefreshRequestStatus(context) to monitor and check the import status.

Here's a condensed example of the refreshData function:

1function refreshData(context) {
2    var configurationId = context.pluginConfiguration.getConfigurationFieldValue({fieldName: "configuration_id"});
3    var configuration = loadConfiguration(configurationId);
4    const accounts = JSON.parse(context.accountRequestsJSON);
5    accounts.forEach(account => {
6        const accountMappingKey = account.accountMappingKey;
7        if (accountMappingKey === '123456') {
8            context.addAccountError({
9                accountMappingKey: accountMappingKey,
10                errorCode: '2000001200'
11            });
12        }
13    });
14    // Corporate Card Expenses only
15    context.setRefreshRequestId({ refreshRequestId: '1' });
16}

Error Handling:

Should any data updates fail, the system will alert you with account-specific error messages, helping you diagnose and resolve issues quickly.

Key Takeaways

• On-Demand Updates: You can now refresh financial data from connected accounts in real-time using supported plug-ins.
• Enriched Bank Data: This feature enhances transaction matching accuracy using AI for ambiguous transactions.
• Payment Date Prediction: New predictions for when customers will pay invoices are now available, helping with cash flow management.
• Button Accessibility: The Update Imported Bank Data button facilitates quick updates, subject to plug-in support.
• Scheduled Imports: Automatic updates are possible under certain configurations and support scenarios.
• Developer Implementation: Essential for developers to implement refreshData and getRefreshRequestStatus for full functionality.
• Limitations: Be aware of the current restrictions and planned enhancements, particularly concerning SuiteApps like the Bank Feeds and AMEX Corporate Card Integration.

Ensure your NetSuite environment is primed for these updates to make the most of on-demand data refresh capabilities!