About the Trial Balance report

Use the Trial Balance report to view balances of all accounts. You can use report filters to specify what information is included in the report. For example, you can do the following:

  • Include or exclude statistical accounts.

  • Filter the list to specific locations or departments.

  • Include accounts with a zero balance or just those zero-balance accounts that have had activity.

  • Select the Retain YTD Balances check box to show accumulated balances for income statement accounts that close into retained earnings at year-end.

After you've generated the report, you can drill down through accounts to the general ledger, and then to individual transactions.

Slide-in functionality is disabled when you restrict subledger transactions at the top level.

To open the trial balance, go to General Ledger > All > Reports > Trial balance. If you do not see this report on the Reports menu, see your system administrator to add it to your application.

Subscription

General Ledger

Regional availability

All regions

User type Business
Permissions Run Trial Balance report

Who typically needs this report

Anyone who needs to ensure that the balance sheet will balance. Use the Trial Balance report to view the account balances and make any needed corrections before running reports that need to balance properly.

You can use trial-and-error to get the precise results you want. Just fill in the desired fields, and select View to see the report. If the results aren't what you want, select Customize to return to the report setup page and refine the report further. Repeat this process until you're satisfied.

For complex financial reports that will be run regularly, save the report after you're done setting it up. The next time you're ready to run the report, you only have to change the As of date before running the report.

What's in this report?

The default Trial Balance report consists of the following columns:

Report Column Heading Description

Account number

  

Account name

  

Opening balance

The amount of the account's balance on the date shown.

If you select the Show opening and closing balances as debits and credits checkbox, opening balances are shown in two columns: one for debits and one for credits.

Debit

The charges posted to the account for the selected period.

Credit

The payments posted to the account for the selected period.

Adj Credit

Adjustments made to the payments posted to the account for the selected period.

This column does not appear on the report in the following situations:

  • There are no adjustment journals.
  • There are adjustments but you selected the Exclude adjustments checkbox.

Adj Debit

Adjustments made to the charges posted to the account for the selected period.

This column does not appear on the report in the following situations:

  • There are no adjustment journals.
  • There are adjustments but you selected the Exclude adjustments checkbox.

Closing balance

The total amount of the account's balance after adjustments.

If you select the Show opening and closing balances as debits and credits checkbox, closing balances are shown in two columns: one for debits and one for credits.

You can select any link to drill down to the details.