Reconciliation in NetSuite: The 10-Minute Guide

Jul 4, 2023 by Zazil Martinez

What is NetSuite Account Reconciliation, and How Does It Work?

NetSuite account reconciliation is a critical accounting process that ensures the accuracy of your financial statements. It involves meticulously comparing your internal general ledger accounts within NetSuite with external bank statements or credit card statements from your financial institutions. This process verifies that all transactions in NetSuite accurately match the corresponding debits and credits reflected in your bank statements, identifying any discrepancies that may require further investigation. Account reconciliation best practices are essential for maintaining accurate financial records and ensuring the overall financial health of your organization.

netsuite best practices

What are the Steps for Account Reconciliation in Netsuite?

  • Set up Account Reconciliation. Enable the 'Use Match Bank Data and Reconcile Account Statement Pages' option within your NetSuite account settings. This unlocks the functionality to import bank statements and perform reconciliations.
  • Import Bank Data. Securely import your bank statements into NetSuite (CSV format is widely supported). This establishes a foundation for comparing your internal records with external bank data.
  • Utilize Intelligent Transaction Matching. Leverage NetSuite's automatic matching rules to streamline reconciliation within your balance sheet. These rules analyze your imported bank data and automatically match transactions with corresponding entries in your NetSuite general ledger based on pre-defined criteria like date, amount, and transaction ID. You can also create custom rules to address specific matching needs within your organization.
  • Manual Reconciliation. Carefully review any transactions NetSuite's Intelligent Transaction Matching couldn't reconcile automatically. This may involve investigating minor discrepancies, researching unmatched transactions, and creating journal entries to address differences.
    • Generate reports analyze reconciliation reports (Summary, Detailed, Historical) for valuable insights and audit trails. Summary reports provide a high-level overview of your reconciliation, including beginning and ending balances, reconciled and outstanding transactions, and any discrepancies.
    • Detailed reports offer a more granular view of each reconciled transaction, including category totals and itemized lists of unreconciled items.
    • Historical reports serve as an audit trail, listing all completed reconciliations within a specified timeframe.

Netsuite Cash Velocity

How do I View Reconciliation Reports on NetSuite?

To access your NetSuite account reconciliation reports, navigate to Reports > Banking/Budgeting > Reconciliation. Here, you'll find three report options tailored to your needs:

  • Summary Report: This report provides:
    • A concise overview of your reconciliation.
    • Highlighted key metrics like beginning and ending balances.
    • Reconciled and outstanding transactions.
    • Any discrepancies that may require further attention.
    • It's a great starting point to grasp your reconciliation status quickly.
  • Detailed Report: This report offers a more granular view by breaking down all reconciled transactions line by line. It includes category totals, insightful details about each reconciled transaction, and a list of unreconciled items that need addressing.
  • Historical Report: Primarily used for auditing, the historical report archives all your completed reconciliations within a specified date range. This report helps review past reconciliation activities and ensure the accuracy of your financial records over time.


Beyond the Basics: Streamlining NetSuite Account Reconciliation

While NetSuite simplifies reconciliation tasks, it can still involve manual work. Here's how to optimize your process:

  • Understand Systemic and User Rules. Use NetSuite's built-in matching rules and create your own to automate reconciliation, leading to more accurate financial statements.
  • Explore SuiteApps for Automation. Consider SuiteApps like Paystand, which offers ERP payment features to streamline reconciliation further, minimize manual tasks, and gain real-time data insights. Explore the NetSuite marketplace for other SuiteApps and integrations that enhance your reconciliation processes.
  • Train Your Team. Invest in NetSuite training or even consider NetSuite certification so your team members can fully leverage these powerful tools.
  • Optimize Related Business Processes. A smooth transition from Quickbooks to NetSuite migration and strong accounting practices will make your reconciliation process more accessible. Address any NetSuite accounting gaps early for cleaner records and streamlined processes.

netsuite payment integration

Stop spending hours on manual reconciliation tasks and focus on what matters most—growing your business. Download our comprehensive 'NetSuite Account Reconciliation Best Practices' eBook to transform your reconciliation processes.