Searching for Matchable Transaction Lines

The GL Matching Dashboard contains different filters that you can use to search for matchable transaction lines.

All transaction lines that match your filters appear on the Search Results list, where you can match them. For more information, see GL Matching Search Results List. To match transaction lines, see Matching Transaction Lines.

To search for matchable transaction lines:

Go to Transactions > Financial > GL Matching Dashboard (Administrator). For roles that use the Accounting Center, go to Financial > Other Transactions > GL Matching Dashboard.
Fill in the search filters, and be sure to complete the required filters.

The other search filters are optional. For more information, see GL Matching Dashboard Search Filters.
Click Search to initiate the search for transaction lines. Click Reset to clear all filters and start a new search.
Go to the Search Results subtab to see a list of the transaction lines that match the filters you set. For more information, see GL Matching Search Results List.

GL Matching Dashboard Search Filters

Some filters are required and can't be left blank. Use the advanced filters to narrow down your search.

Filter	Description
Basic Filters
Subsidiary	Select a subsidiary you want to match transactions for. This filter is required. Note: This filter is only available in OneWorld accounts. See Introduction to NetSuite OneWorld chapter for more information.
Account	Select an account to search for matchable transaction lines. This filter is required. If you want to add account types besides Accounts Receivables and Accounts Payables to the list, you can manually include them in the filter on the Dashboard. For more information, see Including Accounts in GL Matching Note: If you've selected an accounting context at Home > Set Preferences, the Account filter only lists account names that match the accounting context and language defined in the account record. For more information, see Accounting Contexts.
Accounting Book	Select the accounting book you want to use to search for matchable transaction lines. You can't select multiple accounting books, and the Primary Accounting Book is selected by default. This filter is required. Note: This filter is only available in OneWorld accounts with the Multi–Book Accounting feature is enabled. For more information, see Multi-Book Accounting Overview.
Matching Status	Select the matching state of transaction lines you want to search for. You can choose one of the following matching statuses: None, Matched, or Partially Matched. None Matched Partially Matched For more information, see GL Matching Terminology. By default, Partially Matched and None matching statuses are selected. If you clear the default, the results list shows transaction lines with all matching statuses. To select more than one matching status, hold the Ctrl key and click the status names.
Advanced Filters
Matching code	Use this field if you want to search for transaction lines by their matching code. For more information about matching codes, see GL Matching Terminology. Note: Matching codes for Matched transaction lines use upper case letters. On the other hand, Partially Matched transaction lines use lower case letters. The GL Matching Dashboard matching code filter isn't case sensitive, so it doesn't matter if you enter ABC or abc in this field.
Matching reference	Use this field if you want to search for transaction lines with a specific matching reference. Unlike a matching code, a matching reference isn't created automatically. You can add it to any transaction line. It's a short description, which may include why the transaction line belongs to a group.
Memo	Use this field if you want to search for transactions by their memo. A memo's a short description of a transaction.
Transaction Line Memo	Use this field if you want to search for transaction lines with a specific memo. Some transaction lines may have their own memo, different from the header memo of the transaction they belong to. For example, you may use a memo to identify a journal entry in a list of other journal entries.
Customer	If you want to search for transaction lines that only apply to a certain customer, select the customer from the list. This filter only works for transactions with customer data. If you use the Vendor or Employee filter, this filter becomes unavailable.
Vendor	If you want to search for transaction lines that only apply to a certain vendor, select the vendor from the list. This filter only works for transactions with vendor data. If you use the Customer or Employee filter, this filter becomes unavailable.
Employee	If you want to search for transaction lines that only apply to a certain employee, select the employee from the list. This filter only works for transactions with employee data. If you use the Customer or Vendor filter, this filter becomes unavailable.
Billing Status	This filter is available when you search for Accounts Payables or Accounts Receivables account types. For these account types, you can select the billing status of the transaction lines that you want to filter: Closed – transaction lines with no outstanding balance. Open – transaction lines with an outstanding balance. By default, no billing status is selected, so both Closed and Open transaction lines show up in the Results list.
Transaction Types	Use this list to select one or more transaction types you want to search for. If you want to select more than one transaction type, hold the Ctrl key and click their names. If you don’t select a specific transaction type, the dashboard automatically searches for all supported transaction types. Important: If the Intercompany Journals feature is disabled, the Intercompany Journal Entries filter still shows up under the transaction type filter. However, using the filter will return an empty search result. For more information, see Making Intercompany Journal Entries. Only matchable transaction types available in your NetSuite account show up in this list.
Date From	Enter a date. GL Matching only searches for transactions issued on this date or later. Earlier transaction lines are ignored.
Date To	Enter a date. GL Matching only searches for transactions issued on or before this date, and ignores later transaction lines.
Minimum Amount	Enter the minimal amount (in base currency) for transactions. GL Matching only searches for transactions exceeding this amount.
Maximum Amount	Enter the maximum amount (in base currency) for transactions. GL Matching only searches for transactions that don't exceed this amount.
Department	If you want to search for transaction lines that only apply to a certain department or business area, select the department from the list.
Class	If you want to search for transaction lines that only apply to a certain class for an account type, select the class from the list.
Location	If you want to search for transaction lines that only apply to a certain company location, select the location from the list.
Note: The Department, Class, and Location filters are only available if you've enabled the Departments, Classes, and Locations features. For more information about these segments, see Classifications Overview.

Filter

Description

Basic Filters

Subsidiary

Select a subsidiary you want to match transactions for. This filter is required.

Note:

This filter is only available in OneWorld accounts. See Introduction to NetSuite OneWorld chapter for more information.

Account

Select an account to search for matchable transaction lines. This filter is required.

If you want to add account types besides Accounts Receivables and Accounts Payables to the list, you can manually include them in the filter on the Dashboard. For more information, see Including Accounts in GL Matching

Note:

If you've selected an accounting context at Home > Set Preferences, the Account filter only lists account names that match the accounting context and language defined in the account record. For more information, see Accounting Contexts.

Accounting Book

Select the accounting book you want to use to search for matchable transaction lines. You can't select multiple accounting books, and the Primary Accounting Book is selected by default. This filter is required.

Note:

This filter is only available in OneWorld accounts with the Multi–Book Accounting feature is enabled. For more information, see Multi-Book Accounting Overview.

Matching Status

Select the matching state of transaction lines you want to search for. You can choose one of the following matching statuses: None, Matched, or Partially Matched.

None
Matched
Partially Matched

For more information, see GL Matching Terminology.

By default, Partially Matched and None matching statuses are selected. If you clear the default, the results list shows transaction lines with all matching statuses. To select more than one matching status, hold the Ctrl key and click the status names.

Advanced Filters

Matching code

Use this field if you want to search for transaction lines by their matching code. For more information about matching codes, see GL Matching Terminology.

Note:

Matching codes for Matched transaction lines use upper case letters. On the other hand, Partially Matched transaction lines use lower case letters.

The GL Matching Dashboard matching code filter isn't case sensitive, so it doesn't matter if you enter ABC or abc in this field.

Matching reference

Use this field if you want to search for transaction lines with a specific matching reference.

Unlike a matching code, a matching reference isn't created automatically. You can add it to any transaction line. It's a short description, which may include why the transaction line belongs to a group.

Memo

Use this field if you want to search for transactions by their memo. A memo's a short description of a transaction.

Transaction Line Memo

Use this field if you want to search for transaction lines with a specific memo.

Some transaction lines may have their own memo, different from the header memo of the transaction they belong to. For example, you may use a memo to identify a journal entry in a list of other journal entries.

Customer

If you want to search for transaction lines that only apply to a certain customer, select the customer from the list. This filter only works for transactions with customer data. If you use the Vendor or Employee filter, this filter becomes unavailable.

Vendor

If you want to search for transaction lines that only apply to a certain vendor, select the vendor from the list. This filter only works for transactions with vendor data. If you use the Customer or Employee filter, this filter becomes unavailable.

Employee

If you want to search for transaction lines that only apply to a certain employee, select the employee from the list. This filter only works for transactions with employee data. If you use the Customer or Vendor filter, this filter becomes unavailable.

Billing Status

This filter is available when you search for Accounts Payables or Accounts Receivables account types. For these account types, you can select the billing status of the transaction lines that you want to filter:

Closed – transaction lines with no outstanding balance.
Open – transaction lines with an outstanding balance.

By default, no billing status is selected, so both Closed and Open transaction lines show up in the Results list.

Transaction Types

Use this list to select one or more transaction types you want to search for.

If you want to select more than one transaction type, hold the Ctrl key and click their names.

If you don’t select a specific transaction type, the dashboard automatically searches for all supported transaction types.

Important:

If the Intercompany Journals feature is disabled, the Intercompany Journal Entries filter still shows up under the transaction type filter. However, using the filter will return an empty search result. For more information, see Making Intercompany Journal Entries.

Only matchable transaction types available in your NetSuite account show up in this list.

Date From

Enter a date. GL Matching only searches for transactions issued on this date or later. Earlier transaction lines are ignored.

Date To

Enter a date. GL Matching only searches for transactions issued on or before this date, and ignores later transaction lines.

Minimum Amount

Enter the minimal amount (in base currency) for transactions. GL Matching only searches for transactions exceeding this amount.

Maximum Amount

Enter the maximum amount (in base currency) for transactions. GL Matching only searches for transactions that don't exceed this amount.

Department

If you want to search for transaction lines that only apply to a certain department or business area, select the department from the list.

Class

If you want to search for transaction lines that only apply to a certain class for an account type, select the class from the list.

Location

If you want to search for transaction lines that only apply to a certain company location, select the location from the list.

Note:

The Department, Class, and Location filters are only available if you've enabled the Departments, Classes, and Locations features. For more information about these segments, see Classifications Overview.

GL Matching Search Results List

All found transaction lines appear in the Search Results tab. Every transaction line in the search results appears in a separate row with several columns of additional information:

All found transaction lines show up in the Search Results tab. Each transaction line in the search results has its own row with several columns of additional information:

Type – The transaction type (for example, Journal).
Number – Automatically generated for each transaction line. In the search results, you can click this number to open the transaction and see its details.
Date – The date the transaction was issued.
Entity – Only shows if the transaction applies to a specific customer, vendor, or employee.
Transaction Currency – The currency used for the transaction.
Debit()/Credit() – Debit and credit values in base currency, shown with the three-letter ISO code in parentheses. The GL Matching SuiteApp matches transaction lines based on these values. For more information, see Currency Management.
Debit(fx)/Credit(fx) – Debit and credit values in the transaction currency, shown with the ISO code in the Transaction Currency column.
Memo – Shows the memo for the transaction, usually a short description.
Matching Code – A combination of etters unique to each account, subsidiary, and accounting book, assigned to every group of transaction lines. NetSuite uses uppercase for matched lines and lowercase for partially matched lines.
Matching Status – If this is blank, the line hasn’t been matched. For more information, see GL Matching Terminology.

Important:
Matching Status and Matching Code show Processing when at least one transaction line is being handled by the SuiteApp. You can check their status in the Matching In Progress subtab. You can't take any action on transaction lines that are in Processing or Pending status.
Matching Date – When the SuiteApp matched or unmatched this transaction line.
Matching Reference – A short description of the line that might include why it’s part of a group. You can add, edit, or delete a reference here. After making changes, press Enter and confirm the changes in the window.

Note:

Click any column header to sort the Results list by text (A to Z or Z to A) or by numbers (smallest to largest or largest to smallest) for that column.

Exporting GL Matching Search Results to CSV

You can export the search results to CSV and open the file in external applications.

Click Export to CSV to save your current search results in CSV format. The exported data only covers one combination of account, subsidiary, and accounting book.

To search for matchable transaction lines:

GL Matching Dashboard Search Filters

GL Matching Search Results List

Exporting GL Matching Search Results to CSV

Related Topics