Introduction to G/L Tags
At the end of each month, the accounting team must log all cash transactions as inflows and outflows in the ERP through journal entries. As companies grow, this becomes harder to manage due to the increasing number of transactions, all of which need to be processed within a tight 3-5 day window. Accuracy is essential because financial audits depend on a clean and precise close, as required by GAAP and AICPA standards.
To make this easier, we’ve created an automated tagging system that lets users quickly categorize transactions based on custom rules and link them to the correct credit and debit G/L codes. This simplifies exporting and mapping transactions in the ERP, making the month-end close faster and more efficient.
G/L Tag Creation Process
Our G/L tagging module runs completely separately to our regular tagging module and only allows each transaction to have one G/L tag applied to it.
G/L Codes : Upload your chart of accounts
To apply G/L Tags with the relevant credit and debit G/L codes specific to your business, you’ll need to upload your company’s chart of accounts into the ERP. This is a one-time setup step that typically occurs during the initial use of the G/L tagging feature.
Steps to upload your chart of accounts:
From the menu, go to Transactions, select G/L Tags, and open the G/L Codes tab.
In the G/L Codes tab, you can either:
Click the Upload button to add a list of G/L codes in bulk.
Or, click the + sign to manually add individual G/L codes.
For Bulk Upload:
Prepare your G/L codes in a spreadsheet with two columns: G/L Code on the left and Description on the right.
Copy the values (not the headers) from your spreadsheet.
Click the upload icon to view the Bulk Entry dialog.
Paste them into the interactive table in the Bulk Entry dialog.
Click Save—you’ll receive a confirmation once your codes have been successfully uploaded.
G/L Tag Admin : Defining automated tagging rules
After uploading your chart of accounts, the next step is to set up automated G/L Tags. Each transaction can only have one G/L tag, so these rules determine when a tag is applied to an untagged transaction.
Each G/L Tag consists of:
A TQL search statement that selects transactions based on metadata criteria.
A credit G/L code and a debit G/L code that will be applied to the tagged transaction.
Rule Execution Order: Tags are applied in the order they appear, from top to bottom. You can easily adjust the order by clicking and dragging tags higher or lower on the list.
You also have the option to disable automatic tagging using this toggle if you prefer to manually tag transactions.
Steps to create a G/L tag:
From the menu, go to Transactions, select G/L Tags, and open the G/L Tag Admin tab.
Click the New G/L Tag button located in the top left corner of the screen to open the tag creation dialog.
Enter the desired name and description in the respective fields.
From the dropdown menus, select the appropriate debit and credit G/L codes that will be linked to the tag and its associated transactions.
Use the search bar to save TQL parameters that will be used to define tagging rules.
Toggle the Automatically Tag switch to enable the tag to be automatically applied to matching transactions overnight.
Click the Save button to finalize the creation of the G/L tag. This action will store the tag in the system and automatically apply the configured rules overnight.
G/L Tagging : Manually categorize untagged transactions
The purpose of the G/L Tagging tab is to allow users to easily identify and manually assign G/L tags to transactions that are missing them.
By default this tab will only return a table of transactions without G/L tags.
Users can query these untagged transactions or inject parameters from already created G/L tags by clicking the tag button on the far right side of the search bar and selecting a tag from the dropdown.
To manually apply a tag to a transaction, check the box next to the transactions you want to tag, then click 'Assign G/L Tag' and choose the tag you'd like to apply.
