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:

Type – The transaction type (for example, Journal).
Number – This number is automatically generated for every transaction line. In the GL Matching search results list, you can click this number to open a transaction’s record and view the details.
Date – The date the transaction was issued.
Entity – Only appears if transaction applies to a particular customer, vendor, or employee.
Transaction Currency – The currency used for this transaction.
Debit()/Credit() – Debit and credit value of this transaction in base currency as indicated by the three–letter ISO code inside the parenthesis. The GL Matching SuiteApp matches transaction lines based on these values. For more information, see Currency Management.
Debit(fx)/Credit(fx) – Debit and credit value of this transaction line in the currency used for this transaction, which is indicated by the ISO code in the Transaction Currency column.
Memo – Displays the memo for this transaction. It is usually a short description.
Matching Code – A combination of letters (unique for every account, subsidiary, and accounting book) assigned to every group of transaction lines. NetSuite uses upper case letters for Matched transaction lines and lower case letters for Partially Matched transaction lines.
Matching Status – If empty, this transaction line has not been matched. For more information, see GL Matching Terminology.

Important:
Matching Status and Matching Code display Processing when one or more transaction lines of a transaction is being processed by the SuiteApp. You can check their status in the Matching In Progress subtab. You cannot perform any action on transaction lines that are in Processing or Pending status.
Matching Date – The date and time when the GL Matching SuiteApp matched or unmatched this transaction line.
Matching Reference – A short description of the transaction line which may include the reasons why it belongs to a group. You can use this field to insert, edit, or delete a matching reference. After making your changes, press Enter and confirm the changes in the popup window.

Note:

When you click the header of any column, you can sort the data in the Results list either by text (A to Z or Z to A) or by numbers (smallest to largest or largest to smallest) in that particular column.

Exporting GL Matching Search Results to CSV

You can export the search results list to CSV. The CSV file will contain the information in the GL Matching Search Results list. You can open the file using external applications.

Click Export to CSV to generate a copy of your current search results in CSV format and save it to your computer. Note that the exported data is only associated with one combination of an account, a subsidiary, and an 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