Reports - Financial - GL Summary (Trial Balance)

Overview

The GL Summary (Trail Balance) report provides a view of general ledger activity for a Legal Entity at a summarized level.  Note that the Credit and Debit amounts on this report can be clicked on to display the GL Details that contributed to that amount.

Roles

This report is available to users having any of the following roles:  Administrator and GL Viewer.

License

This report is available with the Project Financials family of Unanet licenses.

Topics covered on this help page include:

• Selection Criteria   (options available to tailor report output)

• Example Report Output

• PDF and Excel Output

Selection Criteria

Field Descriptions (click on a link below for additional information)

Example Report Output

Field Description Notes

• Account – Details will be Included for all accounts having transactions in the General Ledger for the selected legal entity and fiscal period.
• Organization – Only displayed when the Sub-total Transactions by Organization option is selected.
• Project –  Only displayed when the Sub-total Transactions by Project option is selected.
• Fiscal Period - Fiscal Period to which the transactions were posted.
• Person -- Only displayed if a transaction is associated with time or expense.

• Quantity – Optional value, displays sum of person’s timesheet hours.
• Beginning Balance - This is sum of the activity for the account and/or organization through the end of the period preceding the From Fiscal Period.
• • Optional – shows only if it has a non-zero value
  • This is the sum of the activity for the account prior to the From Period. The balance is calculated differently based on whether the account is a balance sheet account (Account Type of Asset or Liability) or an income statement account (Account Type of Income or Expense) and whether the natural balance of the account is a debit balance (Account Type of Asset or Expense) or credit balance (Account Type of Liability, Equity or Revenue).
    
    The calculations are as follows:
    • Asset -      sum(debit - credit) for all general ledger transactions with post date prior to the begin date of the From Period
    • Liability -   sum(credit - debit) for all general ledger transactions with post date prior to the begin date of the From Period
    • Revenue - sum(credit - debit) for all general ledger transactions with post date prior to the begin date of the From Period and greater than or equal to the begin date of the fiscal year of the From Period
    • Expense - sum(debit - credit) for all general ledger transactions with post date prior to the begin date of the From Period and greater than or equal to the begin date of the fiscal year of the From Period
• Debit - GL Debit Amount
  Drill Down Note:  The value in this field can be clicked on to display the GL Details that contributed to this entry
• Credit - GL Credit Amount
  Drill Down Note:  The value in this field can be clicked on to display the GL Details that contributed to this entry
• Ending Balance - If a debit balance account, then Beginning Balance + sum(debit – credit) otherwise Beginning Balance + sum(credit – debit)

PDF and Excel Output

On this report you will notice the pdf () and Excel () icons, which can be used to produce the report output in these alternative formats.