NetSuite Tips: Best Practices for Fixing Older or Locked Reconciliations

Fixing an already completed reconciliation in NetSuite can be tricky—especially when it’s not the most recent one and may date back several periods.

Fortunately, by using the deprecated “Reconcile Bank Statement” feature, you can correct these older or locked reconciliations without having to remove completed records. In this blog, we’ll a quick tip to help you navigate these situations efficiently, ensuring your financial data stays accurate and up to date.

Step-by-Step Guide

1. Disable the "Use Match Bank Data and Reconcile Account Statement Pages" option on the specific bank account record.

2. Use the old reconciliation page to find and correct the historical data.

NetSuite Deprecated Reconciliation tips

3. Include and/or remove missing transactions.

reconcile netsuite bank statement tips

4. Once saved, the already completed reconciliation will be adjusted without having to remove and redo an entire reconciliation process.

5. Re-enable the "Match Bank Data" feature after the corrections are made.

Automated Cash App – A Helpful Tool for Your Reconciliation Procedures

NetSuite’s Automated Cash Application is a built-in feature designed to simplify and speed up your reconciliation process. It automatically creates batches of customer payments and applies them to the appropriate open invoices—removing a lot of the manual matching your team may still be doing.

If you haven’t enabled or explored this feature yet, it’s a great time to take advantage of it. Using Automated Cash App can help reduce errors, clean up your AR faster, and make month-end reconciliation noticeably more efficient.