Pre-Allocation Normal Trial Balance
|
Access this report using Reports>Allocation Management>Pre-Allocation Normal Trial Balance. |
Use this report to print unposted pre-allocation transactions. (Pre-allocation transactions were set up using Activities>Processing Allocations.) Run this report before posting transactions using Activities>Post Transactions. This report:
- Prints in a stair-step format: all the account codes are in one column, all the account titles in another column, and all the account short titles in yet another column if selected. Since a trial balance shows account balances at a specific point in time, it is useful as a quick reference or analytical tool.
- 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).
- The Drill Down feature, which allows you to view report data from the report balances level, down to the individual debits and credits that make up the balance.It is based on the report setup criteria that was entered for this report. However, Drill Down does not offer report totals, such as, "Show Totals Fund Code," but report totals like these are available in the printed report.
Advanced Security Users
Account Level Security is available for this report. This feature allows the Administrator to define the account codes and related amounts a user can view in the report. When account level security is activated by the Administrator for the organization (Security>Set Up Account Level Segments) and enabled for a user or group (Security>Set Up Account Level Security), the report will only print account information the user is allowed to see. Note that if a user does not have Account Level Security enabled, the user will see all account codes.
If the "Print Disclaimer on Report" check box is selected on the Security>Set Up Account Level Segments form, "This report may be affected by Account Level Security" prints in the header of this report. In that case, an * also prints after the report title.
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 Period 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 |
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 |
|
Debit Balance |
The debit balance from transaction entry. For Allocations, this balance was created using the Activities>Process Allocations form. |
|
Credit Balance |
The credit balance from transaction entry. For Allocations, this balance was created using the Activities>Process Allocations form. |
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. |
|
Replace total debits and credits with Balance. |
Select this option to show the net amount for each segment where totals have been requested. Otherwise, the report displays the total debits and total credits for each segment. |
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.