As of NetSuite 2019.2, there are two ways of reconciling bank and credit card accounts:
1. Reconcile Bank Statement or Reconcile Credit Card Statement (old way)
- Navigational path: Transactions > Bank > Reconcile Bank Statement or Reconcile Credit Card Statement
- Manual reconciliation of Bank Statement against the Bank/Credit Card Account Register
- Makes use of the Account Register to clear transactions and to identify cleared transactions that is up for reconciliation
- Has the History button to show all Periods reconciled and to check differences
2. Reconcile Account Statement and Confirm Transactions Matches (new way)
- Navigational path: Transactions > Bank > Reconcile Account Statement
- Makes use of importing the Bank Statement (CSV, BAI2, QFX files) via Import Online Banking Data page
- Imported Bank Statement data can be automatically or manually matched on the Confirm Transaction Matches page (it will automatically be matched depending on the Rules set on the Reconciliation Matching Rules page)
- Easier to use when reconciling huge number of transactions
For the Bank/Credit Card account to be available in the new way of reconciliation (Reconcile Account Statement and Confirm Transactions Matches), a user may follow the below:
- If using an Administrator role, navigate to Lists > Accounting > Accounts; if using a Custom Role, navigate to Chart of Accounts
- Click Edit link on the selected Bank/Credit Card Account
- Find and mark the 'Use Confirm Transaction Matches and Reconcile Account Statement Pages' checkbox (this may be left unmarked if the old way of reconciliation will be used)
- Click Save
SuiteAnswers References: 7587 Reconciling Bank Statements and 77455 Reconciling Account Statements