This article summarizes the steps to update the GL Matching reference.
GL matching suite app is used to match general ledger accounts’ debit and credit amounts in different transactions. It is a type of account reconciliation and is used for clearing GL accounts transaction amounts in Netsuite. In the GL matching dashboard, we can search for transactions posted to a particular account. The transactions can be filtered by using customer/vendor/employee name, memo, or matching references. Matching reference is the unique code that is updated in transactions to easily match the records( like Purchase order reference number can be updated for the Purchase order, item receipt, bill, and journals).
To update CSV Reference (Matching Reference in the GL Matching dashboard) for existing transactions, we can do it via CSV import. The GL Matching Reference field can be updated via CSV import for Journals. For Item Receipt, the update of the GL Matching Reference field for existing records and new records needs to do by using custom script.
Records that can be updated through CSV import:
- History Vendor bill records
- History Journal records
- New journal records
Records that need to update through scripts:
- History Item receipts
- New Item receipts (Auto update in record creation)
- New vendor bills (Auto update in record creation)
- New Journals (Auto update in record creation)
Matching Reference field is used as the reference in GL Matching Dashboard to match POs, Item Receipt, Vendor Bill and Journals. It is a unique value that can be a PO number or some specific values from the memo or in any other fields or any other unique values to identify the related transactions (PO number based on Created From field or description in the Memo field – creating a unique reference number for transactions to be matched).
To update CSV Reference for transactions, prepare a CSV file with the fields “Internal ID” and “GL Matching (Custom field)”. Internal ID will be the Internal ID of the transaction records. GL Matching (custom field) is the field where we have to update the matching reference. We have to create separate CSV files for each type of transaction (to update each type of transaction record separately).
Upload the prepared CSV file in NetSuite by following the below steps:
- Go to, Setup > Import/Export > Import CSV Records.
- Import type – Transactions
- Record type – Select the transaction record that is going to update.
- Select the CSV file and click “Next”.
- Select the Data Handling option – “Add” and Click “Next”.
- Map the fields “Internal id” and “GL Matching Reference” and then Click “Next”.
- Click “Save & Run”.
- Check the import status in Setup > Import/Export > View CSV Import status.
Create a saved search of the updated records and check the values in the “GL Matching reference” field.