Streamlining Your Financial Processes: Tips for NetSuite Credit Card Reconciliation

Key Takeaways

• NetSuite’s reconciliation process has three core stages: Import bank data, match transactions using Intelligent Transaction Matching, and reconcile the statement. Each stage has configurable automation.
• Two rule types control automated matching: Systemic Rules (fixed, non-modifiable) match on transaction number, amount, and date within 90 days of import. User Rules let you define custom matching logic for your specific transaction patterns.
• Credit card and bank reconciliation follow the same three-stage process: The navigation paths differ slightly, but the matching and reconciliation mechanics are identical.

Introduction

Bank and credit card reconciliation is one of the most repetitive tasks in the monthly close. The process is conceptually simple: compare what your GL says happened with what the bank says happened, investigate differences, and confirm they agree. In practice, it involves hundreds or thousands of transactions, multiple accounts, timing differences, and the risk of human error that compounds into audit findings.

NetSuite’s bank and credit card reconciliation tools accomplish this through Intelligent Transaction Matching, configurable user rules, and a structured three-stage workflow that handles most matching automatically and routes only genuine exceptions to manual review.

This guide covers the complete reconciliation workflow in NetSuite: how to set up accounts, how Intelligent Transaction Matching works, how to create custom rules, how to run the reconciliation, and how to use the reconciliation reports.

The Three-Stage Reconciliation Workflow in NetSuite

NetSuite bank and credit card reconciliation runs in three sequential stages. Each stage feeds the next, and the process can be partially automated or fully manual depending on your account volume and rule configuration.

Stage 1: Import Bank Data

Bank statement data enters NetSuite in one of three ways:

• Manual CSV upload: Download a statement from your bank’s portal, format it as a CSV, and upload via Transactions > Bank > Import Bank/Statement. This is the most common method and works with any bank.
• OFX or BAI2 file import: Some banks provide downloadable statement files in these formats, which NetSuite accepts natively.
• Bank Connectivity plugin (automated feed): NetSuite’s Bank Connectivity SuiteApp establishes a direct connection to your financial institution, automatically pulling statement data on a schedule without manual download.

Supported import formats are CSV, OFX, BAI2, and CAMT. QIF format is no longer supported. Whichever import method you use, the statement data lands in the Match Bank Data page as a set of unmatched bank lines waiting to be reconciled against your GL transactions.

Stage 2: Match Bank Data Using Intelligent Transaction Matching

Once bank data is imported, NetSuite runs its matching rules automatically. Navigate to Transactions > Bank > Match Bank Data to see the results. The page shows two side-by-side grids: imported bank lines on one side and GL transactions on the other. Matched pairs are highlighted; unmatched items appear in each column separately.

For a complete step-by-step walkthrough of the Match Bank Data interface including how to handle exceptions, see our guide to matching bank data in NetSuite for period reconciliation.

Stage 3: Reconcile the Statement

After matching is complete, the reconciliation confirms that your GL balance equals the bank statement ending balance after accounting for outstanding items (timing differences). Navigate to Transactions > Bank > Reconcile Bank Statement. Enter the statement end date and the ending balance from the bank statement. NetSuite calculates the difference between matched transactions and the statement balance. When the difference is zero, the reconciliation is complete and can be locked for the period.

Setting Up Accounts for Reconciliation

Before any account can be reconciled in NetSuite, it must be enabled for bank data matching. This is a one-time setup step per account.

1. Navigate to Lists > Accounting > Accounts
2. Click Edit next to the account you want to configure
3. Check the box labeled ‘Use Match Bank Data and Reconcile Account Statement Pages’
4. Click Save

This setting must be enabled on both bank accounts and credit card accounts before reconciliation is possible. If you begin a reconciliation and receive a prompt about matching not being enabled, the system will ask whether to delete incomplete statements or continue without matching. Enable the setting first to avoid this.

Intelligent Transaction Matching: How the Rules Work

NetSuite’s matching engine operates two types of rules in sequence. Systemic Rules run first and cannot be modified. User Rules run second and are fully configurable.

Systemic Rules (Non-Modifiable)

NetSuite applies these rules to all accounts automatically. They match bank lines to GL transactions based on three criteria, all of which must align:

• Transaction number: The reference number on the bank line matches the transaction number in NetSuite
• Amount: The amounts match (or differ only by minor formatting differences such as leading zeros or prefixes)
• Date: The transaction date falls within 90 days of the import date

Important constraint: Systemic Rules only match transactions dated within 90 days of import. Transactions older than 90 days will not be auto-matched by systemic rules and require manual matching or a user rule.

User Rules (Configurable)

User Rules let you define additional matching criteria for transaction patterns that systemic rules do not cover. For example, if your bank formats reference numbers with a prefix that does not appear in your NetSuite transaction numbers, or if certain transactions consistently match on amount alone without a reference number, user rules handle those patterns.

Creating a User Rule

1. Navigate to Transactions > Bank > Reconciliation Rules
2. Click New Rule
3. Add a Rule Name (descriptive because you will have multiple rules over time)
4. Filter the Account the rule applies to
5. Add Conditions: Transaction Type, Primary Field, Operator, Value Input, Second Transaction Type, and Compare Field
6. Add or remove additional conditions as needed
7. Click Save

When multiple user rules exist, they can be prioritized by dragging and dropping in the rule list. The matching engine applies rules in order and stops at the first rule that produces a match for each bank line.

Running a Bank Reconciliation

After matching is complete, the reconciliation confirms your net position for the period.

1. Navigate to Transactions > Bank > Reconcile Bank Statement
2. Select the bank account and enter the statement end date
3. In the Deposits and Credits sub-tab, select the transactions to reconcile for this period
4. In the Checks and Payments sub-tab, select the outgoing transactions
5. If there are charges not yet in NetSuite, click New Charges, fill in the details, and click Add
6. For deposits not yet in NetSuite, click New Deposits, fill in the details, and click Add
7. Choose Save and Print, Save, or Complete Later

Note on saving incomplete work: NetSuite retains only one in-progress reconciliation per period. If you change the account selection on an open reconciliation, the prior work on that file is deleted. Complete or save before switching accounts.

Running a Credit Card Reconciliation

Credit card reconciliation follows the same three-stage process as bank reconciliation. The navigation path differs at the reconciliation stage:

• Import: Same import process via Transactions > Bank > Import Bank/Statement
• Match: Same Match Bank Data page at Transactions > Bank > Match Bank Data
• Reconcile: Navigate to Transactions > Bank > Reconcile Credit Card Statement (not Reconcile Bank Statement)

All steps, including account setup, rule configuration, and report generation, are identical between bank and credit card reconciliation.

Deleting a Reconciliation

Reconciliations can be deleted if an error is discovered after the statement is saved. The process is the same for both bank and credit card accounts:

1. Navigate to Transactions > Bank > Reconcile Bank Statement (or Reconcile Credit Card Statement)
2. Enter the statement date of the reconciliation to delete
3. Click the Actions menu
4. Select Delete
5. Confirm by clicking Yes

To confirm the deletion was successful: navigate to Reports > Banking/Budgeting > Reconciliation and search for that date. If nothing appears, the deletion was completed.

Reconciliation Reports in NetSuite

NetSuite generates two reconciliation reports: Summary and Detailed. Both are accessed at Reports > Banking/Budgeting > Reconciliation.

Summary Report

The Summary Report provides the high-level reconciliation result:

• Transaction balances and totals: Cleared and outstanding amounts
• Previous bank balance: The ending balance from the prior period’s reconciliation
• Ending and current balances: The statement ending balance and the current GL balance
• Difference: The gap between the reconciled balance and the unreconciled total — should be zero when reconciliation is complete

Use this report for executive review, period close sign-off, and audit evidence. It shows the reconciliation conclusion without transaction-level detail.

Detailed Report

The Detailed Report provides transaction-level visibility:

• All reconciled transactions: Listed individually with amounts and transaction dates
• Category totals: Subtotals by transaction type (deposits, checks, fees, etc.)
• Unreconciled transactions: Itemized list of transactions that remain open — the starting point for exception investigation
• Balance history: Previous and current reconciled statement balances and the difference between them

Use this report when investigating discrepancies, preparing audit packages, or reviewing why the difference in the summary report is not zero.

When to Consider NSAR for Higher-Volume Reconciliation

NetSuite’s native bank and credit card reconciliation tools handle standard monthly close reconciliation for most organizations. For organizations with higher transaction volumes, multiple bank accounts, or reconciliation requirements beyond bank and credit card (AR subledger, AP subledger, intercompany, accruals), the NetSuite Smart Account Reconciliation (NSAR) module provides more automated matching capabilities, compliance dashboards showing reconciliation status across all accounts, and a secure document repository for audit-ready evidence storage.

For a full breakdown of NSAR capabilities and how they compare to the native reconciliation tools covered in this guide, see our overview of NetSuite NSAR for automated account reconciliation across all account types.

Conclusion

NetSuite’s bank and credit card reconciliation tools address the most time-consuming parts of the monthly close: importing bank data, matching transactions automatically through Intelligent Transaction Matching, and generating the reports that confirm your accounts are reconciled.

The key levers for reducing reconciliation time are account setup (done once), user rule configuration (ongoing as transaction patterns emerge), and the Bank Connectivity plugin (for organizations that want automatic data import). Together, these reduce the manual work to reviewing and resolving genuine exceptions rather than matching transactions one by one.

For the broader context of how bank reconciliation fits into the account reconciliation process, including GL account types beyond bank and credit card, see our guide to NetSuite account reconciliation best practices and SOX compliance implications.