GL (Analytics)
What is GL (Analytics)?
The GL (Analytics) report provides a detailed view of all General Ledger transactions recorded within a specified period. It enables users to analyze journal entries, account activity, debit and credit movements, running balances, currencies, and related transactional information for individual GL accounts. The report helps users review financial postings, audit account activity, and investigate accounting transactions across different account types.
To access the GL (Analytics) report, go to Menu > Reports > Accounting > GL (Analytics).
Running the Report
The GL (Analytics) report allows users to retrieve General Ledger transactions based on account and date criteria.
To generate the report:
Select the Account Type and Account Name.
Enter an Account Number, if required.
Select the required Period and specify the From and To dates.
Click Refresh to generate the report.
The report displays all matching General Ledger transactions for the selected criteria


Report Filters
Account Type
Filters transactions based on the selected account type.
Account Name
Filters transactions for a specific General Ledger account.
Account Number
Allows users to search using the account number.
Period
Selects a predefined reporting period.
From Date
Specifies the starting date for the report.
To Date
Specifies the ending date for the report.

Toolbar
The toolbar provides several options for managing, exporting, and customizing the report.
File
Save My Layout: Saves the current report layout for future use.
Restore Layout: Restores the previously saved report layout.
Restore Filters: Removes all applied filters and restores the default filter settings.
Save as New: Saves the customized report layout with a new name.
Tools
Provides report-related utilities and additional processing options, where available.
Export
Exports the report in supported formats such as Excel, CSV, or PDF.
Grid: Displays the report in a tabular format for reviewing transaction details.
Charts: Display graphical representations of the report data, where applicable.
Layout and Formatting Options
The right side of the toolbar provides options for customizing how the report is displayed.
Format
The Format option allows users to customize the appearance of the report, including number formatting, date formatting, decimal separators, thousand separators, text alignment, and conditional formatting.
Options
The Options window allows users to configure report display preferences such as row appearance, grouping behavior, filtering options, and other grid settings.
After selecting the required options, click Apply to update the report layout or Cancel to discard the changes.

Fields
The Fields option allows users to control which columns are displayed in the report. Users can select or clear individual fields, rearrange their order using drag-and-drop, and click Apply to update the report or Cancel to discard the changes.
Txn Date
Displays the transaction date.
Txn Type
Displays the type of General Ledger transaction.
Txn Number
Displays the unique transaction number.
Entity Name
Displays the customer, vendor, or entity associated with the transaction.
Ref
Displays the reference number associated with the transaction.
Ex Rate
Displays the exchange rate used for foreign currency transactions.
Currency
Displays the transaction currency.
Account Id
Displays the unique identifier of the General Ledger account.
Account
Displays the General Ledger account name.
Account Type
Displays the type of General Ledger account.
GL Code
Displays the General Ledger account code.
Vendor Bill
Displays the associated vendor bill, if applicable.
Project Class
Displays the project or class associated with the transaction.
Amount Home Cur
Displays the transaction amount in the home currency.
Debit Home Cur
Displays the debit amount in the home currency.
Credit Home Cur
Displays the credit amount in the home currency.
Running Total Home Cur
Displays the cumulative running balance in the home currency.
Foreign Amount
Displays the transaction amount in the foreign currency.
Running Total Foreign
Displays the cumulative running balance in the foreign currency.
Amount (Home Curr)
Displays the transaction amount calculated in the home currency.
Memo
Displays any notes or remarks entered for the transaction.
Month_Name
Displays the month in which the transaction was recorded.
Parent Account
Displays the parent account associated with the selected General Ledger account.
Store
Displays the store associated with the transaction.
Last updated
Was this helpful?