Deprecation of Reconcile Bank Statement and Reconcile
Credit Card Statement Pages
The Reconcile Bank Statement and Reconcile Credit Card Statement pages are now deprecated. Although these pages are still accessible, they are scheduled for removal in a future release. Therefore, you should adopt the redesigned bank reconciliation feature, Account Reconciliation, which includes the Match Bank Data and Reconcile Account Statement pages. These pages enable you to match and reconcile transactions without requiring Microsoft Excel or other third-party tools. To use the redesigned bank reconciliation feature, check the Use Match Bank Data and Reconcile
Account Statement Pages box on each existing account record. If an account contains any held
statements that you have begun to reconcile but chosen to complete later, you have two options: Note: NetSuite automatically checks the Use Match Bank Data and Reconcile Account Statement Pages box for all newly-created accounts in 2021.1.
- Before migrating to the new feature, reconcile all held statements for the account. See the help topic Reconciling Bank Statements.
- Proceed with migrating to the new feature, and let NetSuite delete the held statements. NetSuite moves the previously-cleared transactions to the new Match Bank Data page. Note: This option is new for NetSuite 2021.1. To enable the redesigned bank reconciliation feature for each existing account, see the help topic Editing an Account. For details about adopting the redesigned bank reconciliation feature, see the help topic Bank Data Matching and Reconciliation.
Enhancements to Bank Import
In NetSuite 2020.2, an import failure for one bank or credit card account during the import process caused the entire import to fail. Also, the error logs did not provide clear indicators to identify which account caused the issue. NetSuite 2021.1 includes enhancements to the import and troubleshooting process. Bank data imports can now be partially complete, even when the import fails for some accounts. You can see account- specific errors and which accounts are affected.
Partially Completed Import Status
On the Banking Import History page, there is a new import status, Partially Completed. This status
applies to imports in which NetSuite did not successfully retrieve data for all bank or credit card accounts. You can troubleshoot import errors on the Banking Import History page. For more information about the Partially Completed status, see the help topic Banking Import History.
Account-Specific Import Errors
You can now view account-specific errors for an import on the following pages:
- Banking Import History – This page displays failure reasons and the list of accounts affected for an import with a Partially Completed or Failed status. You can expand each row to view the import error details. See the help topic Banking Import History.
- Format Profile – In a format profile record configured for bank reconciliation, the Account Linking subtab displays warning icons next to accounts with errors. You can see account-specific errors by clicking the warning icon. See the help topic Bank Account Linking.
- Match Bank Data – If you select an account for which NetSuite failed to import data during the latest import, a popup message displays the most recent import error. See the help topic Matching or Clearing Bank Data. For permission details, see the help topic Permissions for Banking Features.
Enhancements to Import Process Performance
Previously, imported data was not visible until processing was complete. Now, NetSuite completes the import process, and then processes the bank lines separately. On the Match Bank Data page, you can view imported bank lines that are currently being processed. These lines are dimmed and you cannot select them for matching until processing is complete. To see if processing is complete, you can refresh the Imported Bank Data grid or the page. For more information, see the help topic Matching or Clearing Bank Data.
New Email Notification
NetSuite now sends a notification for a partially completed import. A partially completed import is an
import in which NetSuite did not successfully retrieve data for all bank or credit card accounts. The email message contains troubleshooting information, including the following next steps:
- Match and reconcile data on the Match Bank Data and Reconcile Account Statement pages.
- View accounts that failed and troubleshoot issues on the Banking Import History page.
NetSuite sends all bank data import email notifications to the user who configured the associated
format profile record, if one was created. If a statement file was imported using NetSuite’s default parser functionality, the user who imported the file receives an email notification that the import was completed or failed. NetSuite also sends email notifications for failed and partially completed imports to the email address listed in the Return Email Address field at Setup > Company > Company Information.
Clear Account Transactions
On the Match Bank Data page, you can now mark account transactions that do not have imported bank
lines to match as cleared pending submission. This functionality was previously only possible in the bank register when using the deprecated Reconcile Bank Statement and Reconcile Credit Card Statement pages.
Transactions that are marked as cleared pending submission appear on the Review subtab (previously
called Matches to Submit) on the Match Bank Data page. When you click Submit, the transactions appear in the Reconcile subtab on the Reconcile Account Statement page and NetSuite automatically selects them for reconciliation. For more information, see the help topic Marking Transactions as Cleared. If you have marked a transaction as cleared pending submission that now has a matching imported bank line, you can undo the cleared status if the transaction is unreconciled. You can do so from the
Review subtab on the Match Bank Data and Reconcile Account Statement pages. NetSuite then moves the
transaction back to the To Be Matched subtab on the Match Bank Data page. See the help topics Undoing the Cleared Status of Transactions and Undoing the Cleared Status of Submitted Transactions. For information on matching and reconciling data, see the help topic Reconciling Bank and Credit Card Statements.