Review general ledger account balances and activity for combinations of account segment values with the values of a secondary segment you specify. You also specify a range of values for a third segment, which are used to control report page breaks.
General Ledger prints a line for each combination of account and secondary segment value and sorts first by secondary segment values, then by account segment values in ascending order. Totals are provided for both your secondary segment and your pagebreak segment.
You can run this report for actual, budget and encumbrance balances for activity in your ledger currency, foreign currency or STAT. You can also use this report to review your translated balances and activity by specifying a balance-level reporting currency.
When run in YTD mode, the Beginning Balance column lists beginning balances as of the first period of the fiscal year, irrespective of the period for which the report is run. When run in PTD mode, the Beginning Balance column lists beginning balances as of the beginning of the period for which the report is run.
Suggestion: Use this report as an easy way to review summary amounts without having to define summary accounts.
When you request this report, General Ledger prompts you to enter the following:
Ledger/Ledger Set: Choose a single ledger, reporting currency, or a ledger set to run this report for multiple ledgers at once.
To view translated balances, choose the Balance-level reporting currency that was used as the target ledger during translation.
Balance Type: Choose to report on Actual, Budget, or Encumbrance balances. If you select budget balances, you must choose the Budget Name on which to report. If you select encumbrance balances, you must choose the Encumbrance Type on which to report.
Note: If you specified a ledger set, you can only report on actual or encumbrance balances. To report on budget balances, a single ledger must be specified.
Ledger Currency: If you chose a ledger set in the Ledger Set field, choose the currency of one of the ledgers or reporting currencies in the ledger set. The Ledger Currency filters the data in the report to only report on those ledgers or reporting currencies for which the currency matches the ledger currency specified.
If you chose a ledger or reporting currency, its currency will default and cannot be changed.
Currency Type: Choose Total, Entered, or STAT as follows:
Choose Total to view the ledger currency total balances or to view translated balances that were translated to a balance-level reporting currency.
By specifying a ledger and the Currency Type Total, all balances that were entered using the ledger currency, as well as any foreign entered balances that were converted to the ledger currency will be retrieved.
By specifying a balance-level reporting currency and the Currency Type Total, you can view Translated average balances.
By specifying a reporting currency and the Currency Type Total, all balances that were entered using the currency of the reporting currency, as well as any foreign entered balances that were converted to the reporting currency will be retrieved.
Choose Entered and specify a currency in the Entered Currency field to report on average balances that were entered in a specific currency.
Choose Statistical to report on Statistical average balances.
Entered Currency: If you chose the Entered Currency Type, choose a currency.
Budget or Encumbrance Type: If you specified a Balance Type of Budget or Encumbrance, specify the Budget or Encumbrance Type.
Pagebreak Segment: General Ledger starts a new page for every different value of this account segment. And, General Ledger prints a total of the balances for each segment value.
Pagebreak Segment Low/High: Enter the low and high segment values on which to report.
Secondary Segment: Choose an additional account segment for which you want to review account balance information. You cannot choose your natural account segment or your pagebreak segment.
Period Name: Choose any open accounting period in your calendar.
Budget Start Period: If you selected budget balances, choose a period within the range of periods for the budget you specified.
Amount Type: Choose QTD (quarter-to-date), PTD (period-to-date), YTD (year-to-date), or PJTD (project-to-date).
Refer to the selected heading descriptions below for additional information.
Account: a line for each value of your account segment. Amounts for each line represent the sum of all accounts that have this account segment value, secondary segment value, pagebreak segment value, and ledger combination.
Account Description: description of your account segment value.
Beginning Balance: sum of the beginning balances of all accounts that have this account segment value, secondary segment value, pagebreak segment value, and ledger combination. Balances are calculated from the beginning of the time period corresponding to the amount type you specify. General Ledger reports debits as positive amounts and credits as negative amounts.
Period Activity: net of all debit and credit transactions for the time period corresponding to the amount type you specify. Note that for project-to-date reports, General Ledger prints period activity for balance sheet accounts only. The project-to-date balances for income statement accounts are the same as their year-to-date balances. General Ledger reports debits as positive amounts and credits as negative amounts.
Ending Balance: sum of the ending balances of all accounts that have this account segment value, secondary segment value, pagebreak segment value, and ledger combination. Balances are calculated to the end of the accounting period you specify. General Ledger reports debits as positive amounts and credits as negative amounts.