We're running into a reconciliation issue in NetSuite and would appreciate any guidance.
Background:
- January 2025: Implemented NetSuite and imported opening balances for 12/31/2024 (not broken down by investment)
- Successfully reconciled our accounts through 2/28/2026
- March 2026: Reimported/updated 12/31/2024 opening balances to add investment-level detail
- Important: Total account balances did not change—only the sub-ledger investment detail was added
Current Issue:
The March 2026 update to the 12/31/2024 opening balance entries has caused those transactions to show as "unreconciled" in our bank reconciliation module.
Key Points:
- These are opening balance entries (not actual bank transactions)
- The GL balances haven't changed—only investment detail was added
- This was a system enhancement, not an error correction
- Our bank reconciliations through 2/28/2026 remain accurate
Question:
How do we mark these updated 12/31/2024 opening balance transactions as reconciled so they no longer appear as outstanding in the bank reconciliation module, while preserving the investment-level detail we added?
We've already cleared them in the Match Bank Data screen, but they still appear as unreconciled since there's no corresponding bank transaction to match against.