Pre-Allocation Expanded General Ledger

Access this report using Reports>Allocation Management>Pre-Allocation Expanded General Ledger.

Use this report to print all posted transactions and any unposted allocation transactions. This allows allocations to be reviewed, which were created using Activities>Processing Allocations, before they are posted (Activities>Post Transactions). This report:

• Contains opening balance and complete detail for any report range selected and for all account codes selected.
• Displays each account segment in its own column. In addition, it allows you to select transaction information columns (such as Transaction Source and Transaction Description) that are not available on the Standard General Ledger.
• Does not include sessions with a status of Batch-to-Suspend. However, it does contain any unposted transactions for allocation sessions (JVA).
• Displays currency fields with the formatting of the organization's functional currency. The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).

 

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Specify the date range for the data included in the report by entering Balances Dates and Current Transaction Dates. The Account Balances Begin date and Current Reporting Year Begins date are used to obtain the beginning balances for the Opening Balances date.

The Cross Year Reporting feature (A Year-End Close will be simulated for this report) allows reports to be run for closed years and cross years at the same time.

Use this tab to determine what data to include in the report and to define the report layout.

• By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
• By selecting Available Columns, the data that appears in the body of the report is determined.

Column	Description
{Segment Name} Code	This is the code assigned to the segment. The report prints the account code, such as 201, 05, or 45001. The system displays one column for each of these code types, such as Fund Code or GL Code.
{Segment Name} Title	The title associated with each code above. The system displays one column for each of these code types, such as Fund Title or GL Title.
{Segment Name} Short Title	The short title for the title above (15 characters or less).
{Segment Name} Group Code	The group code assigned to the segment. The report prints the group code in the heading.
{Segment Name} Group Title	The title associated with the group code above. The report prints one column for each group segment.
{Segment Name} Group Short Title	The short title for the group title above (15 characters or less).
Transaction Source	The transaction type for the document, such as CR, CD, API, APC, ARB, ARC, JVA, or JV.
Session ID	The Session ID associated with the documents.
Session Date	The date of the session.
Session Description	The description of the session.
Document Number	The number associated with the document.
Document Date	The date associated with the document.
Document Description	The description associated with the document.
Document Amount	The amount entered for the document during transaction entry. For allocations, this amount is calculated for you.
Effective Date	The document's effective date.
Entry Type	The entry type chosen during transaction entry—Normal, End of Year Adjustment, Adjust Opening Balances, or Beginning Balance. The system prints an N, A, AO, or UO.
Transaction Description	The description for the transaction line item.
Posted	A designation of Yes or No, depending on if the detail transaction was posted or unposted.
Debit	The amount entered for the debit during transaction entry. For allocations, the system automatically creates the debit amount.
Credit	The amount entered for the credit during transaction entry. For allocations, the system automatically creates the debit amount.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to designate the Group Sets for the report. Groups provide an alternate way of reporting summarized accounting data. Selecting a group code on the report is the same as filtering by group code on the entire report. Any accounts not included in a Group Set will not be included in the report. In order for groups to be applied to the report, the group selected on the Groups tab must also be selected in at least one of the following: Content tab or Filter tab.

Use this tab to set up any Available Options for the report.

Options	Description
Year-End Adjustments	Select this option to include year-end adjustments on the report. This entry type was designated during transaction entry.
Opening Entries in Detail	Select this option to include opening balances (system or user opening entries) in detail. This entry type was designated during transaction entry.
Summarize Amounts	Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.
Suppress Lines with All Zeros	Select this option, along with the Summarize Amounts option, so that documents with zero amounts do not print. If the debit and credit on the same line nets to zero then it is suppressed. For example, there is a GL code with a debit of $100 (USD) and a credit of $100 (USD) and it is on the same line with no other entries. The GL code will not appear on the report.
Subtotal Detail by Calendar Month	Select this option to subtotal the detail by a calendar month. This subtotal always calculates according to calendar month end, (1-31) not the month end of the Fiscal Year.

Use this tab to change the font and page setup for a report.

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.