Reports - Financial - GL Detail

Overview

The GL Detail report provides a detail of activity posted to the general ledger for a Legal Entity.

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 CSV Output

Selection Criteria

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

Example Report Output

Field Description Notes

Note about Beginning Balance: Beginning Balance will NOT be printed if the following selection criteria are selected:

• Project field

• Document Date other than BOT - EOT

• Document Type

• Posted Date other than BOT - EOT

• 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
• Credit - GL Credit Amount
• Ending Balance - If a debit balance account, then Beginning Balance + sum (debit – credit) otherwise Beginning Balance + sum (credit – debit)

PDF and CSV Output

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