Account Reconciliation in NetSuite: A Bookkeeper's Working Method

Reconciling accounts inside NetSuite is the same discipline as reconciling anywhere else: prove that the general ledger balance agrees with an independent source, and explain every difference. What changes in NetSuite is where the evidence lives and how the subledgers connect to the GL. This article walks through a working method.

Which accounts actually need reconciling?

Start with the accounts where an independent source exists. Bank and credit card accounts reconcile to statements. Accounts receivable and payable reconcile to their aging summaries. Payroll liabilities reconcile to the payroll register. Inventory reconciles to a count or a valuation report.

Then add the accounts with no external source but a high risk of silent drift: clearing accounts, suspense, intercompany, and accrued reversals. These are the ones that should be zero and rarely are.

Match the subledger to the GL, not the other way round

The core check in NetSuite is that each subledger total ties to its control account. Run the AR aging summary and confirm the total equals the GL balance in accounts receivable. Do the same for AP. If they disagree, the usual cause is a journal entry posted directly to the control account, bypassing the subledger.

Direct journals to control accounts are the single most common reconciliation breaker. Reserve control accounts for subledger postings, and route adjustments through the subledger module or a clearly labelled adjusting journal that you reconcile separately.

Work clearing and suspense accounts to zero

A clearing account that nets to zero can still hide offsetting errors. A payment matched to the wrong invoice, plus a duplicate that cancels it arithmetically, leaves a clean zero and a wrong AR. Review the constituent transactions, not just the balance.

Set a rule: any balance sitting in suspense at close gets an owner and a deadline. If an item has not cleared within two closes, it is probably not a timing difference and needs to be reclassified to where it belongs.

Handle foreign currency and rounding

Multi-currency accounts reconcile in two layers: the transaction currency and the base currency. Gains and losses from revaluation post automatically at period end. Check that the revaluation journal is posted before you reconcile, or the GL balance will not agree to the bank statement.

Small residual differences from rounding are legitimate but should be tiny and explained. A residual that grows each month signals a matching problem, not rounding.

Document the reconciliation as you go

Attach the reconciliation working paper to the account or store it in your close file: the GL balance, the independent source, the list of differences, and the resolution for each. NetSuite lets you attach files to records, which keeps the evidence next to the account.

Do the reconciliation before you mark the period closed, not after. A locked period with an unreconciled account means reopening it, and reopening periods is where audit trails get messy.

When does reconciliation work end and repair work begin?

If reconciliations keep failing because transactions post twice, vanish, or report differently in different views, that is no longer a bookkeeping difference. That pattern suggests data damage, and no amount of matching will fix it. Preserve the file and its backups exactly as they are, note what you observed and when, and stop. At that point the work belongs to a specialist; see our data repair service for damaged accounting files rather than attempting fixes yourself.

Done in this order, reconciliation stops being a month-end scramble and becomes the evidence that the ledger is right.