06 General Ledger Reports

GL Reports: GL Detail

GL Detail: This report shows general ledger transaction details. The report also includes account

information, transaction dates, descriptions, amounts and account type info.

1. Click on Reports

2. Click on the General Ledger drop-down (top)

3. Select the GL Detail report from the drop-down

Note: If you do not see the Reports desktop, ensure that you have access to it by going to Configure → Security → Configure Roles → Select Role → Desktop Security tab → Reports checkbox. Also, ensure that your role has access to these specific payroll reports by clicking on the Reports tab from the selected role and ensuring that checkboxes are selected for each of these reports under the “Can Run” column.

GL Summary Trial Balance: This report provides a summary of all GL account information w/ descriptions and the associated beginning and ending balances. Additionally, the report includes a summary page with the totals for all credits and debits with beginning, current and ending balances (bottom of report).

1. Click on General Ledger Entries

2. Click on the GL Summary Trial Balance button (top)

Note: If you do not see the GL Summary Trial Balance button, you can enable access to the report by going to Configure → Security → Configure Roles → Select your role → Desktop Security tab → Expand GL Entries → ”Summary Trial Balance Report” checkbox.

GL Reports: GL Detail Trial Balance

GL Detail Trial Balance: This report provides the details of all GL account information with descriptions; including the individual transaction details with amounts and the associated beginning and ending balances per account. Additionally, the report includes a summary page with the totals for all credits and debits with beginning, current and ending balances (bottom of report).

1. Click on General Ledger Entries

2. Click on the GL Detail Trial Balance button (top)

Note: If you do not see the GL Detail Trial Balance button, you can enable access to the report by going to Configure → Security → Configure Roles → Select your role → Desktop Security tab → Expand GL Entries → ”Detail Trial Balance Report” checkbox.

GL Detail Trial Balance Example

Account Analysis

Account Analysis provides a way of looking at GL journal entry credits and debits along with the distribution total and other important information in a report format. Note: Account Analysis is a secured report in the system. If you don’t have access to this report, go to Configure → Security → Configure Roles → Select your Role → Desktop Security tab → GL Entries (expand) and select the “Query Account Analysis” checkbox to allow access.

1. From the General Ledger Entries search grid, search for the journal entries that you want to be included in the analysis.

Helpful Hint: Use the Transaction Date/Journal Number Filters or any of the other filters to locate the entries to be included in the analysis.

2. Run the Account Analysis report by selecting "From All" or select individual journal entries to be analyzed and choose the "From Selected" option.

3. Review the report and click the Export button for export options

Acct Analysis Report Example

Print Complete Journal

Print Complete Journal provides a complete Posting Journal report. In addition to showing GL journal entry credits, debits and the journal transaction total, this report provides full account description info., amounts and Transaction/GL Dates.

1. From the General Ledger Entries search grid, search for the journal entries that you want to be included in the report. Note: If multiple journal numbers are selected for reporting, the system will automatically break the information into separate report files.

Helpful Hint: Use the Transaction Date/Journal Number Filters or any of the other filters to locate the entries to be included in the report.

2. Run the Complete Posting Journal report by selecting "From All" or select individual journal

entries to be analyzed and choose the "From Selected" option. Note:

3. Review the report and click the Export button for export options

Helpful Hint: Complete Posting reports for AP Journals also include a vendor summary with corresponding vouchers info.

Print Complete Journal Example

This is an example of a Complete Posting report for an AP Journal. Since the journal is for Accounts Payable, the report displays both Vendor Summary/Voucher info (top) as well as a GL Transaction Summary (bottom).