GL matching suite app is used to match general ledger accounts’ debit and credit amounts in different transactions. 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.
Once the GL matching reference is updated, we can do the matching process. For executing matching process,
- Go to, Transactions> Financial> GL Matching Dashboard.
- Select the subsidiary to do the matching.
- Select the account for GL matching.
- Provide GL matching reference in the “Matching Reference” field.
- Select the matching status.
- Click on “Search”. The page will show all the records with the provided matching reference. One page will show a maximum of 500 lines. We can change the number of lines in the “Results per page” field.
- Once the page loads the results, select the records manually or click on “Select all”.
- Click on “Match” to match the selected records.
- Once matched, it will show under “Matched” status.
Note: We need to make sure that the marked records are fully matching, before triggering the matching process. (Debit and Credit values MUST be equal and balance be equal to 0.00)