Scenario
When a user edits a Bank or Credit Card Account and unmarks Use Match Bank Data and Reconcile Account Statement Pages checkbox, the user gets the error: "Warning: This account has one or more cleared transactions pending. Before disabling this option, you must submit these transactions on the Match Bank Data page. Alternatively, you can undo the match or undo the cleared status of pending transactions from the Review subtab."
Solution
-
Go to Transactions > Bank > Match Bank Data
-
Account: Select Account
-
Mark two transactions with the same Amount
-
Click Match
-
Click Submit
-
Go to Transactions > Bank > Reconcile Account Statement
-
Account: Select Account
-
Go to Review tab
-
Click Matched link
-
Click Undo Match button
-
Go to Lists > Accounting > Accounts
-
Account: Click Edit
-
Use Match Bank Data and Reconcile Account Statement Pages: Remove Checkmark
-
Click Save
Alternatively, if there are no available transactions to be matched, the user may manually import a CSV file which has the same Amount to one of the transactions on the NetSuite side and contains the following fields at least:
| Date (MM/DD/YYYY) | Payer/Payee Name | Transaction Id | Transaction Type | Amount | Memo | NS Internal Customer Id | NS Customer Name | Invoice Number(s) |
|---|---|---|---|---|---|---|---|---|
| 4/10/2021 | DEBIT | 1234.56 | TEST CSV BANK |
-
Go to Transactions > Bank > Banking Import History > Upload File
-
Choose a file: Select the CSV file created
-
Import Options: Select Import with a default parser (CSV, OFX, QFX, BAI2, or CAMT.053)
-
Account: Select Account
-
Click Import
-
Upper right corner: Click the Track your status link
Note: You may go to Transactions > Bank > Banking Import History > Click the Expand (+) button to delete the imported CSV file used for testing.