GL Matching Dashboard Management
The GL Matching Dashboard lets you search for matchable transaction lines using different filters. You can view, edit, match, or unmatch the transaction lines in the Search Results list. When you complete a match, the SuiteApp assigns a matching code and status (Matched or Partially Matched) based on the total balance of the group.
If you're using an Administrator role, go to Transactions > Financial > GL Matching Dashboard to access the GL Matching dashboard. If your role uses the Accounting Center, go to Financial > Other Transactions > GL Matching Dashboard.
To use the GL Matching Dashboard, read the following topics:
GL Matching Terminology
The following terms are used when referring to GL Matching:
-
Group – A group of transaction lines that the SuiteApp matches and assigns a matching code.
-
Transaction Lines – The lines in a transaction record. Each transaction line has a debit or credit value. The GL Matching SuiteApp matches transaction lines, not transactions as a whole.
-
Matching Status – The current state of the matching process. The matching status can be one of the following:
-
None – These transaction lines haven't been matched yet, so these transaction lines don't have a matching code.
-
Matched – These transaction lines are already in a group where the total credits is equal to the total debits. Each group has a matching code assigned.
-
Partially Matched – These transaction lines are in a group and have a matching code, but the group isn't complete yet.
The total credits is not equal to the total debits, so additional transaction lines have to be added to get a zero balance.
-
-
Matching Code – A unique string of letters for each combination of account, subsidiary, and accounting book, assigned to Matched or Partially Matched groups.
-
Match – The action of reconciling or evaluating the debit and credit values of transaction lines to form a group with a matching code.
-
Unmatch – The action of undoing a group. The SuiteApp removes the matching code and matching status.
-
Unmatched Debit/Unmatched Credit – Debit and credit amounts that haven't been reconciled yet.
Matchable Transactions
The GL Matching SuiteApp can match the following transaction types:
|
|
|
|
|
The GL Matching SuiteApp doesn't match transactions as a whole, it matches transaction lines. Each transaction has multiple transaction lines. The GL Matching Dashboard shows each line as a separate search result, so you can match different lines from the same transaction separately.
Including Custom Transactions in GL Matching
The GL Matching SuiteApp also lets you match custom transactions. To learn more about the custom transactions in NetSuite, see the help topic Custom Transactions.
To make a custom transaction matchable:
-
Go to Customization > Scripting > Scripts.
-
Next to the GLM - UE - Custom Transaction script, click Edit.
-
On the Scripts page, click the Deployments subtab.
-
From the list in the Applies To column, select your custom transaction, and then click Add.
-
Click Save. Your custom transaction now appears in the Applies To column.
-
Click the custom transaction. The Script Deployment page appears.
-
Set the Audience for your custom transaction to All roles.
Important:If you limit the Audience to certain roles, it can cause inconsistencies in matching data.
-
Set the Status of your custom transaction to Released.
-
Click Save.
It takes up to 10 minutes for your new custom transaction to show up in the Transaction Types list of the GL Matching Dashboard.
Including Accounts in GL Matching
By default, the Accounts filter on the GL Matching Dashboard only includes Accounts Receivables (A/R) and Accounts Payables (A/P). GL Matching is mainly used to reconcile these account types, which is needed for a complete and orderly accounting. For this reason, you can't exclude A/P and A/R accounts from GL Matching.
If you want to match other account types besides A/P and A/R, you can add them to the Accounts filter on the GL Matching Dashboard.
To include an account in GL Matching:
-
Go to Setup > Accounting > Manage G/L > Chart of Accounts.
-
Click Edit next to the Account name that you want to include in GL Matching.
-
Check the Include in GL Matching box on the right side of the page.
-
Click Save.
You can include or exclude an account from GL Matching by checking or clearing the Include in GL Matching box.
You can't include the nonposting account type in GL Matching. The Include in GL Matching box is also disabled for A/P and A/R accounts because they're included in GL Matching by default.