Scenario: If imported bank data is being auto-matched to older NetSuite transactions (e.g., April transactions instead of May), it’s likely due to the bank data being imported before the corresponding NetSuite transaction was posted. Solution: To prevent this, you can create a Reconciliation Rule that limits matching to transactions within a specific date range. Go… Continue reading Prevent Auto-Matching of Imported Bank Data to Older NetSuite Transactions
Tag: Bank reconciliation
Imported Bank statement deletion
How do you know if the imported bank statement can be deleted? Here are the criteria that must be met: 1. The import was successful, 2. The account statement is unreconciled, and 3. The import was manual To elaborate on the third criteria: The bank statement should have been imported manually through Transactions > Bank >… Continue reading Imported Bank statement deletion
Allow multi select in bank reconciliation
In the console, we can type the below. document.querySelectorAll(‘.uif1506.uif1510.uif1513.uif1515.uif1438’).forEach(el=>el.click()) It will multi-select 111 records at a time
Configuring SFTP Connection for Auto Bank Statement Import
When using the Auto Bank Statement Import (ABSI) SuiteApp, an SFTP connection is required to connect NetSuite to your financial institution’s server. You can configure your SFTP connection in NetSuite by providing one or both information : Digital Certificate or Private Key Password If your financial institution requires two-factor authentication, be sure to provide both… Continue reading Configuring SFTP Connection for Auto Bank Statement Import
Modifying Cleared / Reconciled Transactions
If the transaction is still valid and only requires a modification (e.g., change in amount, payee, or memo), it is not recommended to void the transaction. Instead, the user should take the following steps: 1.Unmatch or remove the cleared status of the transaction. Make the necessary modifications to the transaction.Edit the check or payment as needed (e.g.,… Continue reading Modifying Cleared / Reconciled Transactions
Resolve Error:“Clear Failed. One Or More Account Transact…” in Match Bank Data
Clearing NetSuite account transactions is a valuable feature provided by Match Bank Data, enabling users to manage transactions that lack corresponding imported bank data. Users have the option to mark these account transactions as cleared, bypassing the matching process. Similar to matched transactions, user-cleared transactions are directed to the Review tab for verification before proceeding… Continue reading Resolve Error:“Clear Failed. One Or More Account Transact…” in Match Bank Data
Select all bank statement lines [left side] in match bank data page
Scenario: In the Match Bank data page, we have the option of select all for the NetSuite bank transactions. However, the same is not available for the bank statement lines on the left side and we need to manually select each box. Solution: In the match bank data page, right click and select ‘Inspect’.… Continue reading Select all bank statement lines [left side] in match bank data page
Bank statement import is empty in reconciliation when using financial institution connectors.
When performing bank reconciliations in NetSuite using the match bank data feature, it’s crucial to ensure that the transaction dates in your imported data align correctly with the “as of” date specified during the import process. If this alignment is not maintained, NetSuite will automatically remove the imported data, which can cause confusion and disrupt… Continue reading Bank statement import is empty in reconciliation when using financial institution connectors.
Auto-Match Reconciliation Rules for Date Not Working in Match Bank Data
User created Auto-Match Reconciliation Rules to match Imported Transactions to NetSuite Transactions with same Check Number and with Date within 3 previous days. When running the rule in Match Bank Data, the transactions are not automatically matched. Solution User needs to rearrange the Date condition of the rule: 1. Navigate to Transactions > Bank > Reconciliation Rules 2. Click the Matching… Continue reading Auto-Match Reconciliation Rules for Date Not Working in Match Bank Data
Bank Reconciliation
Bank Reconciliation in NetSuite is a crucial accounting process used to ensure that your company’s bank account records match the records in your NetSuite system. This process helps identify discrepancies between your bank statement and your accounting records, such as missing transactions or errors, and ensures that your financial statements are accurate. Navigation Navigate to… Continue reading Bank Reconciliation