Match Bank Data for Efficient Transaction Reconciliation

The Match Bank Data page in NetSuite allows users to view and manage bank or credit card lines from imported statements that require manual matching. This functionality is essential for ensuring accurate financial records and streamlined reconciliations.

Overview of the Match Bank Data Page

On the Match Bank Data page, imported transactions are displayed, categorized into transactions that need manual matching and those that NetSuite has automatically matched. If you need to view transactions awaiting your input, here’s how to navigate:

1. Accessing the Match Bank Data Page

   • Navigate to Transactions > Bank > Match Bank Data.
   • Ensure your role has the requisite Reconcile permission to access this feature. This is important for viewing the necessary financial data.

2. Select the Relevant Account

   • From the Account list, choose the bank or credit card account associated with the data you wish to view.
   • For existing accounts, confirm that the Use Match Bank Data and Reconcile Account Statement Pages checkbox is enabled.

Viewing Imported Data on the Match Bank Data Page

Once you have accessed the page and selected your account, various subtabs will display different categories of transactions:

• To Be Matched Subtab: Here you can find a list of imported bank lines that require reconciliation. It’s vital to monitor this to resolve discrepancies quickly.
• Review Subtab: Displays transactions that have been automatically matched by the system. If you need to confirm their accuracy, review details such as:
  • Date: Transaction occurrence date or posting date if not available.
  • Type: Type of transaction (e.g., Check, Payment).
  • Tran No.: The transaction ID.
  • Name: Payee or merchant name.
  • Memo: Additional details if provided.
  • Amount: Total transaction amount.

Handling Excluded Data

If any transactions are identified as duplicate entries, they will move to the Excluded subtab. NetSuite uses specific criteria to define duplicates, such as identical transaction fields across multiple imports. If you find a transaction listed here but believe it to be a valid entry, options are available to restore it for review.

To facilitate the reconciliation process, always click the Refresh icon to ensure the Imported Bank Data grid is up to date with the latest information.

For more details on how to match and reconcile your data, refer to additional documentation on Bank Data Matching and Reconciliation.

Key Takeaways

• The Match Bank Data page provides a crucial step in manually reconciling bank transactions.
• Automatic matching helps streamline the bank reconciliation process, but manual oversight is essential.
• Specific subtabs categorize transactions, aiding in efficient data management.

Source: This article is based on Oracle's official NetSuite documentation.