NetSuite Historical Reconciliation Cleanup

The historical bank reconciliations in our NetSuite environment have drifted out of balance and now prevent accurate month-end closes. I need someone who can dive into the system, identify the root causes of the mismatches, correct the underlying transactions, and deliver a clean, fully reconciled general ledger that lines up to the original bank statements.

Scope of work
• Review all prior-period bank reconciliations that currently do not tie out.
• Trace and correct mis-posted or duplicated transactions directly in NetSuite, using native tools such as Reconciliation Status, Match Bank Data, and Saved Searches where appropriate.
• Re-run each reconciliation until the book balance equals the statement balance and the variance is zero.
• Spot-check related modules (cash management, GL impact) to be sure fixes flow through reliably to financial reports.

Deliverables
1. Updated, balanced bank reconciliations for every affected period.
2. A brief change log noting each material adjustment made and its rationale.
3. Confirmation that the corrected balances roll forward correctly into current-year financials.

Acceptance criteria
• All reconciliations show zero variance in NetSuite.
• Ending GL cash balance matches the cumulative bank statement balance.
• No new out-of-balance conditions appear in subsequent periods.

When you respond, please reference past work where you successfully resolved NetSuite reconciliation issues—screenshots or a concise summary of the challenge and outcome is ideal. A short outline of the steps you typically follow will also help me gauge fit.

The engagement can start immediately once access is arranged and is expected to be project-based until every period is cleared. I will be available for quick questions throughout so you have the background information you need to move swiftly.