> For the complete documentation index, see [llms.txt](https://docs.xorosoft.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xorosoft.com/xoroerp-1/reports/accounting/gl-analytics.md).

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

{% hint style="info" %}
To access the GL (Analytics) report, go to **Menu > Reports > Accounting > GL (Analytics).**
{% endhint %}

### 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

<figure><img src="/files/aMDWeXdnoGRyFIy3u1xZ" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/hqumdtFmZ4gJyMgdy9wU" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/v5KL1YqOT02K0AOGN5jW" alt=""><figcaption></figcaption></figure>

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

2. **Tools**

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

3. **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.

<figure><img src="/files/YPzK6xL9arELjvltYkfW" alt=""><figcaption></figcaption></figure>

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

<table data-search="false"><thead><tr><th>Field</th><th>Description</th></tr></thead><tbody><tr><td>Txn Date</td><td>Displays the transaction date.</td></tr><tr><td>Txn Type</td><td>Displays the type of General Ledger transaction.</td></tr><tr><td>Txn Number</td><td>Displays the unique transaction number.</td></tr><tr><td>Entity Name</td><td>Displays the customer, vendor, or entity associated with the transaction.</td></tr><tr><td>Ref</td><td>Displays the reference number associated with the transaction.</td></tr><tr><td>Ex Rate</td><td>Displays the exchange rate used for foreign currency transactions.</td></tr><tr><td>Currency</td><td>Displays the transaction currency.</td></tr><tr><td>Account Id</td><td>Displays the unique identifier of the General Ledger account.</td></tr><tr><td>Account</td><td>Displays the General Ledger account name.</td></tr><tr><td>Account Type</td><td>Displays the type of General Ledger account.</td></tr><tr><td>GL Code</td><td>Displays the General Ledger account code.</td></tr><tr><td>Vendor Bill</td><td>Displays the associated vendor bill, if applicable.</td></tr><tr><td>Project Class</td><td>Displays the project or class associated with the transaction.</td></tr><tr><td>Amount Home Cur</td><td>Displays the transaction amount in the home currency.</td></tr><tr><td>Debit Home Cur</td><td>Displays the debit amount in the home currency.</td></tr><tr><td>Credit Home Cur</td><td>Displays the credit amount in the home currency.</td></tr><tr><td>Running Total Home Cur</td><td>Displays the cumulative running balance in the home currency.</td></tr><tr><td>Foreign Amount</td><td>Displays the transaction amount in the foreign currency.</td></tr><tr><td>Running Total Foreign</td><td>Displays the cumulative running balance in the foreign currency.</td></tr><tr><td>Amount (Home Curr)</td><td>Displays the transaction amount calculated in the home currency.</td></tr><tr><td>Memo</td><td>Displays any notes or remarks entered for the transaction.</td></tr><tr><td>Month_Name</td><td>Displays the month in which the transaction was recorded.</td></tr><tr><td>Parent Account</td><td>Displays the parent account associated with the selected General Ledger account.</td></tr><tr><td>Store</td><td>Displays the store associated with the transaction.</td></tr></tbody></table>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.xorosoft.com/xoroerp-1/reports/accounting/gl-analytics.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.