---
title: "GL Account Detail with Legal Entity Export"
slug: "gl-account-detail-with-legal-entity-export"
description: "Download GL account detail filtered by legal entity and date range for reconciliation, including running total net change."
updated: 2025-08-27T22:25:22Z
published: 2025-08-27T22:25:22Z
canonical: "docs.restaurant365.com/gl-account-detail-with-legal-entity-export"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# GL Account Detail with Legal Entity Export

The GL Account Detail with Legal Entity Export runs the system for all General Ledger account details so that the balance of an account can be reconciled over a date range. This export also includes the Running Total Net Change and Running Total by Period numbers for further data analysis.

---

## Navigation

The My Reports search bar can be used to search R365's entire catalog of reports.

1. Open the **Reports** app.
2. Navigate to **My Reports**.
3. Enter all or part of the report name in the **search bar**.
4. The **Results** tab will open with the list of search results.
5. From beneath the report name, click **Run** to run the report with the selected report view. -OR- Click **Customize** to adjust the report parameters and run the report.

![Overview of report options in Restaurant365 with highlighted run and customize buttons.](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/report.png)

---

## Report Parameters

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image-SBTN4FG0.png)

| **Field/Column** | **Description** |
| --- | --- |
| **Legal Entity** | A listing of all legal entities. |
| **Location** | A listing of all locations within the selected legal entity. |
| **Start Date** | The beginning date of this report. > [!TIP] > **R365 Best Practice** Due to the large volume of data in the GL Account Detail with Legal Entity Export, it is recommended to run this report in quarterly segments to prevent timeouts and ensure successful exporting of data. > > Users can also use the [OData connector](/doc/docs/restaurant365-odata-connector) for flexible data extraction and reporting. |
| **End Date** | The end date of this report. |
| **Accounts** | A listing of all GL accounts. |
| **Show Unapproved** | This will either show or hide unapproved transactions. |
| **Include Stat Accounts** | This will either include or exclude statistical accounts in the report. |
| **Download Button** | Downloads the report. |

---

## Report Columns

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/d98abd27-cacd-40b1-9676-c465cbdddf58.png)

| **Field/Column** | **Description** |
| --- | --- |
| **Account** | The GL account name and number. |
| **Beg Bal Date** | The date that the beginning balance was set. |
| **Beg Bal Amount** | The amount put in as the beginning balance. |
| **Account Nbr** | The number affiliated with the GL account. |
| **Account Name** | The name of the GL account. |
| **GL Date** | The date the transaction was posted to the general ledger. |
| **Legal Entity Name** | The name of the legal entity that is tied to the location. |
| **Location Number** | The uniquely-created number of the location affiliated with the transaction. |
| **Location Name** | The name of the location affiliated with the transaction. |
| **Status** | This is the status of the transaction (approved or unapproved). |
| **Type** | The type of transaction (journal entry, AP invoice, etc.). |
| **Document Number** | The R365 assigned number listed on the transaction. |
| **Vendor Customer** | The vendor or customer name that connects to the AP or AR transaction, respectively. |
| **Line Comment** | The comment from the detail line of a transaction. |
| **Header Comment** | The comment from the header of the transaction. |
| **Net Change** | The amount of the detail line. Debits are displayed as 0.00 while credits are displayed as (0.00). |
| **Running Total** | A sum of the detail lines grouped by GL account number. |
| **End of Month** | The date of the month the account is subtotaled by. |
| **Running Total Net Change** | The running total net change since the GL date. |
| **Running Total By Period** | The running total for each period. |