Comparative Trial Balance

Access this report using Reports>General Ledger Analysis>Comparative Trial Balance.

Use this report to print a trial balance with comparative information representing the beginning year balance, beginning report period balance, and the current balance. It 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.

Additional items and filters are available if any user defined fields were created by the Administrator using Organization>Set Up User Defined Fields. Only user defined fields with a field type of String, Editable Drop-Down List, or Non-Editable Drop-Down List are available in the Items by Page group box on the Content tab and are listed as an available filter.

 

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. The Account Balances Begin date and Current Reporting Year Begins date are used to obtain the beginning balances for the Opening Balances date. Additionally, Current Period Dates are also required to specify the reporting period for this report.

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

Account Code

The code and group 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.

Account 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.

Account Short Title

The short title for the title above (15 characters or less). The system displays one column for each code types, such as Fund Short Title.

Begin Year Balance

The balance from the Account Balances Begin date through the day before the Current Reporting Year Begins date.

Begin Report Period Balance

The balance from the Account Balances Begin date through the day before the Report Begins date.

Current Balance

The balance from the Account Balances Begin date through (and including) the Report Ends date.

Net PTD Change

The monetary difference between the Begin Report Period Balance and the Current Balance.

Net PTD % Change

The percentage difference between the Begin Report Period Balance and the Current Balance.

Net YTD Change

The monetary difference between the Begin Year Balance and the Current Balance.

Net YTD % Change

The percentage difference between the Begin Year Balance and the Current Balance.

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.

If the report is printed using groups rather than individual account codes, only account codes included in the groups created for this Group Set print on the report. If there are account codes not included in a group, they do not print on the report.

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.

Suppress Lines with All Zeros

Select this option so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value.

This option only works with transaction line type user defined fields with a field type of currency.

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.

  • Use balances for Assets, Liabilities, and Net Assets. Revenue and Expense accounts always have a zero balance at the beginning of the year. When an organization's fiscal year is closed, the balance sheet account is carried forward to the new year, but new net assets balances are calculated based on the prior year.
  • When any option from the Date Items drop-down list (except Custom) is selected, report dates are automatically adjusted each time the report is processed. For example, choose a Report Date of This Month and process the report on 10/15/20xx; you get a report with the month of October. If the report is processed on 11/15/20xx, you get a report with the month of November. In other words, you do not have to return to this tab each month to change the Current Period Dates.
  • If Custom is chosen as the Date Item, you are required to enter the dates MM/DD/YYYY through MM/DD/YYYY on this tab. These Opening and Ending Balances dates do not change each time the report is processed.
  • To print totals for each account code combination, select the Show Totals box on the Content tab.
  • Currency columns follow 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).