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

General Notices