Scenario

Reconcile Bank Statement will soon be fully replaced by Reconcile Account Statement. However, as there are previous reconciliations made in Reconcile Bank Statement, there are still instances when users will need to re-open old reconciliation upon discovering that they have Custom Transactions that were not reconciled in the previous periods. Custom Transactions usually come from bundles or after enabling some features. Example of Custom Transaction is a Vendor Prepayment, which is not visible in the Reconcile Bank Statement page by default, so users have to enable below described preference first.  

 

Solution

Show All Transaction Types in Reconciliation.

Enable this preference to show custom transactions on the Reconcile Bank Statement page.

1. Navigate to Setup > Accounting > Accounting Preferences
2. Navigate to the General tab
3. Show All Transaction Types in Reconciliation: Insert Checkmark
4. Click Save

Note: When the Account is set to Reconcile Account Statement, NetSuite prevents the user from reopening a statement if incompatibility errors will prevent user from closing the statement again.

 

Temporarily Re-open the Reconciliation using Reconcile Bank Statement 

1. Navigate to Setup > Accounting > Chart of Accounts
2. Click Edit beside the Bank Account
3. Use Confirm Transaction Matches and Reconcile Account Statement Pages: Remove Checkmark
4. Click Save

 

Reconcile Bank Statement

The custom transaction will now be available for reconciliation using the old interface. Make sure to set the Statement Date to one of the previous reconciliations. To verify:

1. Navigate to Reports > Banking/Budgeting > Reconciliation
2. Account: Select the Bank Account
3. Note the available Statement Date

Once reconciled using the Reconcile Bank Statement, enable the field Use Confirm Transaction Matches and Reconcile Account Statement Pages again to continue using Reconcile Account Statement moving forward.