The GL Detail Report screen is divided into two sections; System Parameters and User Parameters. In the System Parameters section, the user must specify details for the format of the report; in the User Parameters section, the user must specify details pertaining to the content of the report. For general information on running reports and on defining System Parameters, please refer to the Running Reports help document.

Report Description

The GL Detail Report is generated based on a user specified range of General Ledger Accounts, range of Timekeeper or Matter Departments, and a range of Accounting Months. For each General Ledger Account, details for each transaction that took place within the specified range of Accounting Months are displayed. Transaction details include Accounting Month and Year, Timekeeper and Matter Department, Posting Date, Entered Date, Journal Type, Journal Number, Transaction Description, Debit Amount, and Credit Amount. The following balances are provided for each Account: Opening Balance (i.e. balance before the transactions occurred), Closing Balance (i.e. balance after the transactions occurred), and Balance Change (i.e. the difference between the Opening and Closing Balances). A Report Closing Balance is also provided.

User Parameters GL Account No X to X From the lists provided, the user must select range of General Ledger Accounts for which the report will be produced. The user also has the option to manually enter the Account Numbers. These fields default to the first and last General Ledger Accounts in the list. Office Number X to X From the lists provided, the user must select the range of Offices to be included in the report. The user also has the option to manually enter the unique identifiers of the Offices. These fields default to the the first and last Offices in the list. Department Type From the list provided, the user must select the type of Department for which the report will be generated. Valid options are Matter Department and Timekeeper Department. This field defaults to the Matter Department option. Department Number X to X From the lists provided, the user must select the range of Departments to be included in the report. The user also has the option to manually enter the unique identifiers of the Departments. These fields default to the the first and last Departments in the list. Accounting Month X to X From the lists provided, the user must select the range of Accounting Months for which the report will be produced. The user also has the option to manually enter the Accounting Months. These fields default to the current Accounting Month. Accounting Year The user must manually enter the Accounting Year for which the report will be produced. This field defaults to the current Accounting Year. Suppress Zero To include in the report those accounts or transactions carrying a zero balance, the user must select the "N" option from the list. To not include those accounts or transactions carrying a zero balance, the user must select the "Y" option from the list. This field defaults to the "Y" option. Create Excel Output To send the report contents to an Excel spreadsheet file, the user must select the "Y" (i.e. Yes) option form the drop down list provided. This field defaults to the "N" (i.e. No) option. Keep in mind that this report can be generated in the manner selected in the System Parameters section AND generated to an Excel file at the same time; there is no need to run the report twice if the user wishes to have Excel output as well as output in another format. Excel Destination If the user has selected to send the report contents to an Excel spreadsheet file, they must then specify the exact path and name for that file (i.e. c:\My Documents\Sample_GL_Detail.xls).