Transaction Matching Accounts

You can use the Account Reconciliation Sync SuiteApp to include transactions linked to accounts that you identified in NetSuite for the Account Reconciliation application Transaction Matching.

For information about Transaction Matching in the Account Reconciliation application, see the help topic Learning About Transaction Matching in the Oracle Help Center.

For information about including accounts in NetSuite in the Account Reconciliation application Transaction Matching, see the help topic Including Accounts in Transaction Matching.

Including Accounts in Transaction Matching

To include a NetSuite account record in the Account Reconciliation application Transaction Matching, you need to check the Include in Transaction Matching for Account Reconciliation box.

To include an account in Transaction Matching:

  1. Go to Lists > Accounting > Accounts.

  2. Click Edit next to the account of your choice.

  3. On the Account page, check the Include in Transaction Matching for Account Reconciliation box.

  4. Click Save.

Note:

The Include in Transaction Matching for Account Reconciliation box is used in a formula in the Criteria subtab of the following saved searches:

  • NSAR GL Transaction Lines

  • NSAR Profile Template

To view or add a formula, go to NetSuite EPM > Account Reconciliation > Manage Saved Searches, and click the saved search name. Then, go to the Criteria subtab.

You can also add a custom formula field in the Results subtab. Example:

WHEN(({type} IN ('Bank')) and ({custrecord_nsarcs_txn_matching} = 'T')) THEN 'Bank Reconciliation with TM'

For more information about custom formula fields, see Using a Custom Formula Field in a Search.

Related Topics

Account Reconciliation Sync SuiteApp Installation and Setup
Required Features for Installing the Account Reconciliation Sync SuiteApp
Installing the Account Reconciliation Sync Foundation SuiteApp
Installing the Account Reconciliation Sync SuiteApp
Role Permissions for Account Reconciliation Sync
Setting Up the Connection to Account Reconciliation
Loading Account Reconciliation Data into NetSuite
Account Reconciliation Data Export and Import
Setting Up Token-Based Authentication
Managing the Account Reconciliation Jobs
Saved Searches for Account Reconciliation Sync
Accounts for Group Reconciliation

General Notices