- 24 Jan 2025
- 4 Minutes to read
- Print
- DarkLight
- PDF
GL Account Detail
- Updated on 24 Jan 2025
- 4 Minutes to read
- Print
- DarkLight
- PDF
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.
- Navigate to My Reports.
At the top of the My Reports screen, select the Financial tab.
Locate the GL Account Detail report.
- 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.
|
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.
|
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.
|
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.