This report is produced when Trial Balance is selected from the Reports drop-down list. This report presents a summary of Debits and Credits, by Ledger Account, that have been made since the last General Ledger Posting Date. The balance "as of" the last posting date is displayed for each ledger account, as is the balance as of the "Through" date of the report. Please note that only those ledger accounts that had either posted amounts and/or Debit/Credit amounts during the reporting period (based upon the input parameters) will be displayed.
Totals of the Balance, Debit, and Credit amounts are provided at the report level.
When Trial Balance is selected, the top portion of the Reports screen is replaced with a parameter entry window as shown in the following example:
The parameter values that are entered will restrict the scope of the report as follows:
Campus: Required parameter. Restricts the record selection to ledger records associated with loans for the selected campus.
Loan Type: Required parameter. Available selections include Loan Type (such as Federal, Institutional, etc.), Loan Name, or Loan Name/Loan Sub Name. Restricts the record selection to ledger records associated with loans of the selected type, name, or name/sub name.
From Date: Optional parameter. If provided, only unposted ledger records having a transaction date greater than or equal to the supplied date value will be selected. If no value is provided, all unposted ledger records will be selected.
Through Date: Required parameter. All unposted ledger records having a transaction date less than or equal to the supplied date value will be selected. Defaults to the current date.
The user should enter the desired parameter values and then click the Submit button to generate the report. If a "Through" date value is not entered, or an invalid date is entered, the following error message will be displayed:
The following is a sample Trial Balance report:
The data elements which comprise the Trial Balance report are described in the following table:
|
Column Name |
Description |
|
Page Heading |
|
|
Loans Reported |
This is the Loan Type or Loan Name/Loan Sub Name that was selected from the parameter screen. |
|
Campus |
This is the Campus Code selected from the parameter screen. |
|
From Date |
This is the From Date (if any) that was provided on the parameter screen. IF no value was provided, the report defaults to the "earliest" unposted ledger record transaction date. |
|
Through Date |
This is the Through Date parameter value supplied by the user. |
|
Column Headings |
|
|
Balance at (date value) |
Third column from the left. The date value displayed is the "latest" General Ledger posting date that was found for the ledger record set identified by the selection parameters. |
|
Balance at (date value) |
Right-most column. The date value displayed is the "Through" date value identified by the selection parameters. |
|
Ledger Account Detail Lines |
|
|
Ledger Account Number |
The CLM ledger account identifier. |
|
Description |
Description of this Ledger Account as recorded in the Coded Data Value table. |
|
Balance at (date value) |
The sum total of all ledger record Debit transaction amounts minus the sum total of all ledger record Credit transaction amounts, for ledger records that have been posted to the General Ledger. |
|
Month-to-Date Debits |
The total amount of all (unposted) Debit transactions for this ledger account, that occurred between the From and Through dates. |
|
Month-to-Date Credits |
The total amount of all (unposted) Credit transactions for this ledger account, that occurred between the From and Through dates. |
|
Balance at (date value) |
This value reflects the sum of the Balance at (date value) amount (GL Posted), plus the Month-to-Date Debits amount, minus the Month-to-Date Credits amount. |
|
Grand Totals Line |
|
|
Total Amounts |
Grand totals of the preceding corresponding amount fields. |
This report retrieves all Ledger (and associated Loan) data from the CLM database that meets the following conditions:
The Campus code of the associated Loan record matches the specified Campus Code value.
The Loan Type, Loan Name, or Loan Name/Sub-Name matches the specified Loan Type, Loan Name, or Loan Name/Sub-Name value.
The Ledger record transaction date (if the ledger record has not been posted to the General Ledger) occurs within the specified date range.
A separate report detail line is created for each ledger account.