Why Automate Bank Reconciliation?
Manual bank reconciliation is error-prone, time-consuming, and often a bottleneck at month-end close. NetSuite's bank feed and matching features can automate most of the work—importing statement lines from your bank, suggesting matches to existing transactions, and flagging exceptions for review. A well-configured setup can reduce reconciliation time from hours to minutes while improving accuracy and auditability.
This guide covers the complete setup process: prerequisites, bank account configuration, feed connection, matching rules, the reconciliation workflow, and handling common exceptions. We also include best practices for multi-currency accounts and high-volume environments.
Prerequisites and Enablement
Ensure Bank Feeds and Bank Reconciliation are enabled in your NetSuite account. Go to Setup > Company > Enable Features and enable the Banking tab options. You'll need the appropriate banking integration (e.g., bank connection feature) depending on your NetSuite bundle and geographic region. Not all banks support direct integration—check with your account manager or NetSuite support for compatibility. For banks without native feeds, you can still use manual statement import (CSV) and leverage matching rules.
Step 1: Configure Bank Accounts
Create or edit bank account records under Lists > Accounting > Accounts. Set the account type to Bank and link to the correct subsidiary and currency. For multi-currency accounts, ensure the currency is set. The bank account record is the anchor for both the feed and the reconciliation. Include the bank's routing and account numbers if required for feed setup. Verify the opening balance and statement date align with your last reconciled period.
Step 2: Connect Bank Feeds
Navigate to Banking > Bank Feeds and add a new connection. Follow the wizard to link your bank—you may need to provide credentials or use OAuth depending on the bank. NetSuite will fetch transactions based on the frequency you configure (daily is typical). Ensure your bank is supported; the list of supported banks varies by region. After connection, verify that statement lines appear. If feeds fail, check credentials, firewall rules, and bank-side enrollment for the integration.
Step 3: Set Up Matching Rules
Matching rules tell NetSuite how to automatically match bank statement lines to existing transactions. Go to Setup > Accounting > Matching Rules. Create rules that match on: reference number, amount (exact or within tolerance), date range, and transaction type. For example, match a bank debit to a vendor bill payment when the reference contains the bill ID and the amount matches. Order rules by specificity—more specific rules first, so a rule for "ACH payment from Vendor Bill" runs before a generic "amount and date" rule.
| Match Type | Use Case | Notes |
|---|---|---|
| Reference + Amount | Payments with check/ACH reference | Highest match confidence |
| Amount + Date Range | Deposits, generic debits | Wider date range = more false positives |
| Amount Only | Fallback | Use narrow date range to reduce duplicates |
Step 4: Run Reconciliation
Open Banking > Reconcile Account and select the bank account and statement period. NetSuite will display imported statement lines and open NetSuite transactions. Use "Match" to pair them. For suggested matches, review and accept. Unmatched items need manual resolution—either create a new transaction (e.g., bank fee, interest, unknown deposit) or adjust the match. The reconciliation screen shows running totals; when statement balance equals your NetSuite balance and all items are matched, you're done. Save and close the reconciliation.
Step 5: Exception Handling
Common exceptions: duplicate transactions (bank shows same payment twice), timing differences (check cleared before you recorded it), bank fees, interest, unauthorized transactions. Create a defined process: who reviews exceptions, how often, and what to do with unapplied bank fees. For bank fees, create a Bank Fee or General Journal Entry and match to the statement line. Consider a custom record or checklist to track recurring adjustments (e.g., monthly service fee). Document exceptions in memo fields for audit trail.
Best Practices
- Reconcile at least weekly; daily for high-volume accounts
- Document matching rules so others can maintain them
- Use memo or memo fields on payments to improve match rate (include check number or reference)
- Review and clear old unreconciled items periodically—stale items often indicate data issues
- For multi-bank setups, reconcile each account separately
- Consider role-based access so only authorized users can post reconciliations
YRK Consulting helps configure bank feeds and reconciliation for clients in the US, Canada, and Europe. Contact us.