General Ledger - Reports

Available Reports for General Ledger

Consolidated Trial Balance Report (GL2100)

The GL Consolidated Trial Balance Report groups account types to display total amounts for opening balance, debits, credits, and ending balances for the specified range of accounts.

Cost Pools

The Schedule G Report is driven by control department to derive two report sets for DCA compliance.

Detail Transaction Report (GL1000)

The Detail Transaction Report is used to display transaction data within departments. The report is sorted by department and lists the debit and credit transactions for the post date range specified on this report’s Enter Parameters screen. If the Post Date fields are left blank, this report will display all transaction details for the company selected up to and including the current date.

Detail Transaction with Account Summary Report (GL1000A)

The Detail Transaction Report with Account Summary is used to display transaction data within departments. The report is sorted by department and further by accounts, and lists the debit and credit transactions for the post date range specified on this report’s Enter Parameters screen.

Financial Document Formatter (GL9000B)

The Financial Document Formatter 2.0 screen allows the user to design various custom financial document types about account balances beyond the balance sheet or income statement types. This screen is also used to print these documents either individually or as a group. These operations are performed via the four options in the process train that runs along the top of the screen.

G/L Transaction Summary Report (GL1000s)

The GL Transaction Summary Report displays all debit and credit transactions from the opening balance to the closed balance within a department against the GL, and is listed by account code or sequence (defaults to code).

GST Report (GL950)

The GST Report displays invoice, retainage, and net taxable amounts for specified customers and their GST business number, by batch number.

Journal Report (GL1003)

The Journal Report is a summary report which lists batches within specific journals, and their respective debit and credit transactions within the defined Post Date fields.

Preliminary Close Report (GL800)

The Preliminary Close Report lists the batch posting amounts within respective departments, accounts, and journals as per the selected year, period, and reporting currency. Source and reference descriptions as well as the user and reference dates are also listed on this report.

TAC Activity Report (By TAV) (GL2501)

The TAC Activity Report By Transaction Allocation Values (TAV) is used to display TAC activity within accounts in the GL.

TAC Activity Report (GL2500)

The Transaction Allocation Code (TAC) Activity Report is used to display data for one or all TACs, for one or all companies, sorted by department.

Transaction Edit List (GL310)

Transaction Edit List reports are used to verify batch details before posting, to prevent issues such as closed fiscal period, security privileges, and others. The report can be ordered by transactions, accounts, sources, or accounts/departments.

Trial Balance by Account Report (GL2000)

The Trial Balance by Account Report is a list of all accounts within the GL of the company selected, sorted by account for the selected fiscal year and period range.

Trial Balance by Account Excel (GL2000_EXCEL)

The Trial Balance by Account Report is a list of all accounts within the GL of the company selected, sorted by account for the selected fiscal year and period range, and printed in an Excel friendly format.

Trial Balance by Department Report (GL2000D)

The Trial Balance by Department Report lists all the GL accounts within the company selected, sorted by department and group code, for the selected fiscal year and period range.

Variance Report (GL5000)

The Variance Report is used to compare costs and revenues, and displays a +/- amount as well as a percent difference in current versus last year’s balance. This report is sorted by account for the defined year and period.

WIP Report (JC2700)

The JC Work In Progress (WIP) Report, which runs from a forms parameters screen, displays the range of selected jobs, by job number. Their contract amount and the total billed and incurred costs for each project are also listed, as are projected margin, percent complete, and recognized margin data. Accrued and total revenue, and accrued and total costs are also listed for each project.

Master File Listings

Chart Codes Listing (GL851)

This screen allows users to generate a list of all general ledger chart codes and their basic information for the given chart code range.

Chart of Accounts Listing (GL850)

This screen allows users to generate a list of all accounts for the given chart code in the general ledger.

Company Listing (GL854)

This screen allows users to generate a list of all companies in the general ledger.

Consolidation Codes Listing (GL852A)

This screen allows users to generate a list of all consolidation codes used in the general ledger.

Department Listing (GLM001)

This screen allows users to generate a list of all departments within a given company.

Detailed Consolidation Codes Listing (GL852B)

This screen allows users to generate a detailed list of all consolidation codes used in the general ledger.

Transaction Allocation Codes Listing (GL853)

This screen allows users to generate a list of all TAC codes for a given range of chart codes.