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:

1. Select the Account Type and Account Name.

2. Enter an Account Number, if required.

3. Select the required Period and specify the From and To dates.

4. Click Refresh to generate the report.

The report displays all matching General Ledger transactions for the selected criteria

Report Filters

Field	Description
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.

1. 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.

1. Tools

Provides report-related utilities and additional processing options, where available.

1. 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.

Field	Description
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.