Banking / Guide overview

NetSuite Bank Reconciliation: A Practical Guide

Start with the transactions in NetSuite. Then choose the path that fits how you handle your bank statement.

By Jack Ring

Bank statement beside a laptop for reviewing and reconciling bank transactions

Get the transactions right first

Bank reconciliation begins before you open a reconciliation screen. Deposits, payments, fees, and other activity need to be recorded in the right account and for the right amounts. A missing or duplicate transaction can look like a matching problem when the underlying record is the real issue.

If customer payments are held in Undeposited Funds, build the bank deposit to reflect what the bank actually received. That gives you a sensible starting point when you compare NetSuite with the statement.

If you import bank data

Work through the sequence: record deposits, import the statement, match bank activity to the transactions already in NetSuite, and reconcile the account statement. Matching connects an item from the bank with its NetSuite transaction. It is a useful check on the records, but it does not by itself confirm that the whole statement period balances.

  1. NetSuite Bank Deposits: Using Undeposited Funds Correctly
    Prepare deposits that reflect the amounts reaching the bank, especially when several customer payments arrive as one deposit.
  2. How to Import a Bank Statement into NetSuite
    Prepare bank data for import and check the account, date range, and transactions before moving on.
  3. How to Match Bank Data in NetSuite
    Compare imported activity with recorded transactions and work through items that do not line up.
  4. How to Reconcile an Account Statement in NetSuite
    Check the transactions included for the statement period against the statement balance and resolve differences.

If you do not import a statement

You can still reconcile against the bank statement by reviewing and clearing the recorded transactions manually. The objective is the same: confirm that the transactions included for the statement period agree with the statement balance.

How to Reconcile a Bank Account in NetSuite Without Importing a Statement
Follow the manual clearing path, identify outstanding items, and check the final difference before completing the period.

Before you finish

Reconciliation confirms that the transactions included for a statement period agree with the ending balance on that statement. If there is an unexplained difference, stop and investigate it. Check for missing entries, duplicate entries, incorrect amounts, and transactions assigned to the wrong period before completing the reconciliation.

Back to all insights