Trial Balance (Report)

Additional Information

The Trial Balance report is a summary of account values organized in classic accounting style by the account type, which includes Assets, Liabilities, Revenue, and Expense. The report displays the balance forward, current debits, current credits and current balance.

The report includes a summary and detail view option. The summary view provides high-level information with the ability to drill-down into each of the levels. The detail view displays each section expanded; it does not provide any drill-down or hide capabilities.

The report is primarily used to ensure that there are no unbalanced journal entries (the total of all debits equals the total of all credits) in preparation to generate accurate financial statements. Sample Report.

General

This General area provides options to configure the report.

Field Description
Comment

Enter any comments about the report instance. Comments will display on the report console and the banner page of the report.

Restrictions

The report includes the following default restrictions:

Field Description
Fiscal Calendar

Enter or select a fiscal calendar. This is the definition of the fiscal years and posting periods for a specified fiscal year. This field defaults to the default fiscal calendar.

From Fiscal Period Enter or select a fiscal period. This is the first date in the date range to include items. This field defaults to the current fiscal period.
To Fiscal Period Enter or select a fiscal period. This is the last date in the date range to include items. This field defaults to the current fiscal period.
Currency Type

Enter or select the type of currency to display on the report. This field defaults to Document Currency, but available options include Document Currency, Company Currency, and Base Currency.

Include Image

Select to include an image. This field defaults to the image defined for the Report Model or Theme.

Include Banner

Select to generate the banner page on the report. By default, this field is set to generate the banner page.

 

Include Retained Earnings

Select to generate retained earnings for the To Fiscal Period year entered.
Display Detail

Select to generate detail level information in the report. By default, this field is set to generate the summary version of the report.

Monetary Scale Select if the monetary values in the report should be scaled, or divided by a number, to reduce the amount of space used. By default, Ones is selected, but available options include None, Ones, Tens, Hundreds, Thousands, and Millions.
Monetary Nbr of Decimals Enter the number of decimal places to display for monetary values. By default two is selected, but the value can be between zero and three.
  Organization Map Enter or select an organization map. This is a hierarchical group of organizations in the system that is used to structure data on the report.
  General Ledger Select to include items from the general ledger. The default is true.
  Allocation Ledger Select to include items from the allocation ledger. The default is false.

The report includes the following optional restrictions:

  • Account
  • Company
  • Currency
  • Organization
  • Organization Map Level

Sorts

The report includes the following sorts:

  • Account Code
  • Account Name
  • Company Code
  • Company Name
  • Organization Code
  • Organization Name
  • Organization Map level 2 - 6 Name