GL Account Detail
  • 24 Jan 2025
  • 4 Minutes to read
  • Dark
    Light
  • PDF

GL Account Detail

  • Dark
    Light
  • PDF

Article summary

The GL Account Detail Report provides a detailed view of all transactions posted to a selected General Ledger (GL) account within a specified time frame. It includes transaction dates, descriptions, debit and credit amounts, and a running balance.


Navigation

The GL Account Detail report is found on the Financial tab of My Reports.

  1. Navigate to My Reports.
  2. At the top of the My Reports screen, select the Financial tab.

  3. Locate the GL Account Detail report.

  4. Select Customize to adjust the report parameters before running the report.
    - or -
    Select Run to run the report with the default report parameters.


Report Parameters

Button/Field

Description

1

Account

A listing of all GL Accounts. Users can select one or multiple accounts to include in the report.

2

Parent

This Account Only: When selected, child accounts will not be included in the report.

Include Subaccounts: When selected, child accounts will be included in the report.

3

Filter By

Filter options for the report:

4

Filter

A list of filter options, determined by the 'Filter By' category selected (#3).

5

Start Date

First date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates.

R365 Best Practice

Due to the large volume of data in the GL Account Detail report, 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 for flexible data extraction and reporting.

6

End Date

Last date for which to pull data for the report. The 'Start' and 'End' parameters create the date range for which data is generated. The report then displays data for all dates within the date range, including the start and end dates.

7

Show Unapproved

Yes: Unapproved transactions will be included in the report.

No: Unapproved transactions will not be included in the report.

8

Calendar

Displays GL Account details based on the selected calendar: Fiscal or Operational.

Learn more about Fiscal Years.

9

Sum by Transaction

Yes: Transactions will be summed and displayed as one line on the report. When selected, the header comment of the transaction will be displayed instead item/line comments.

No: Transactions will not be summed and each line item from each transaction will be displayed individually on the report. When selected, the report will use the setting selected for the ‘Show Comment or Item’ (#17) to determine what details to display.

10

Subtotal By

Location: Transactions will be displayed and subtotaled in groups by location.

Company: Transactions will be displayed and subtotaled in groups by company (vendor and/or customer).

None: Transactions will not be grouped or subtotaled.

11

Show Comment / Location / #

Abbreviates or shows the full name for each field.

12

Balance

The Typical option will show a positive balance, while the DR (+)/ CR (-) will show the true balance.

13

Include Stat Accounts

Yes: Statistical accounts will be included in the report.

No: Statistical accounts will not be included in the report.

14

Exclude GL W/Out Activity

Yes: GL accounts without activity will not be included in the report.

No: GL Accounts without activity will be included in the report.

15

Hide Zero Balances

Yes: GL accounts with a 0.00 balance will not be displayed.

No: GL accounts with a 0.00 balance will be displayed.

16

Calculate to 4 Decimals

Yes: The debit, credit, and balance columns will be calculated to four decimal points.

No: The debit, credit, and balance columns will be calculated to two decimal points.

17

Show Comment Or Item

When Sum by Transaction - No (#9) is selected, this setting is used to determine whether to display the detail line item or detail line comment.

18

View Options

This section provides options to select, save, edit, or delete a report view.

19

Run

Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report.


Report Layout

Column

Description

Date

The GL date of the transaction.

Type

The type of transaction.

Ref. Number

The identifying number of the transaction. Users can click the hyperlink to open the transaction in a new tab.

Company

The name of the vendor or customer associated with the transaction.

Location

The location associated with the transaction.

Comment/Item

The comment or item associated with the transaction.

When sum by transaction is set to yes, the header comment of the transaction will be displayed in this column.

When sum by transaction is set to no, the detail line item or comment will be displayed in this column.

Debit

The amount posted to the selected GL account as a debit.

Credit

The amount posted to the selected GL account as a credit.

Balance

The running total of the selected GL account based on the debit and credit entries within the specified reporting period. The balance reflects the account’s financial position at a given point in time, considering its starting balance and subsequent transactions.

When a Retained Earnings account is included in the report, the value of the account from within the selected date range will appear as a line item similar to other accounts.


Default GL Account Drill-Downs

With most Financial Reports and all Custom Financial Reports, Users have the ability to click any number within the report to drill-down into the number. Drill-downs open the GL Account Detail Report in a new tab.

The GL Account Detail will run with the system default Report Parameters. However, when Users set customized default parameters, the GL Account Detail Report will run with the parameters set by the User.

learn more about GL Account Drill-Downs


Email, Export, or Print the Report

This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.



Was this article helpful?