Description

The Trial Balance report is used for reviewing activity by debit, credit, and resulting balance against each Ledger Account at each location level, as well as at all consolidating location levels. The report provides a clear financial snapshot as of a specific date.

Caution: The Trial Balance will only balance in current years when prior fiscal accounting years have been closed. PLease close all previous fiscal years under Admin>Acc Periods for accurate results.

• Report Balances
  • Balance Drill-Downs
• Report Configuration Settings
  • Location
  • Date
  • Consolidation
  • Hide Zero Balance
  • Journal Status
• Report Filters
• Report Columns
• Saving and Sharing
• Exports

Report Balances

For guidance in how balances are displayed according to Ledger Account Type:

• Balance Sheet Ledger Accounts (Asset | Liability | Equity) include all journal lines through the end date of the report.
  • Closing entries are only included for Balance Sheet type accounts.
• Income Statement Ledger Accounts (Revenue | Expense) include all journal lines from start of accounting year until the end date of the report.

Balance Drill-Downs

By clicking into the Balance on a given line in this report, you can see all of the journal lines that make up that balance. Additionally, you can further click into a Journal Number to see a detailed view of the Journal Entry, its associated details, and its audit logs.

Report Configuration Settings

The available report configurations to customize the view and balances delivered for the Trial Balance report can be adjusted on the right slider tab of the report:

Location

• Select the location to run the trial balance report for.
• If running a consolidated report, the balances from the selected location and all its child locations will be included.
• Defaults to the Location Context Picker

Date

• Select the date to run the report through (this allows you to see cumulative balances for all accounts as of the selected date).
• Defaults to the Current System Date

Consolidation

• Features:
  • Includes journal lines from the specified Location and all children Locations.
  • Incorporates elimination journal lines.
  • Mandates setting consolidation rates for child-parent Location pairs with differing currencies.
  • Translates and consolidates all balances to the currency of the specified Location's reporting currency.
  • Utilizes spotRate for Balance Sheet accounts and Weighted Average Rate for Income Statement accounts during currency consolidation.
  • Applies historicalRate for Equity Ledger Accounts that have been designated for historical rates (set at Ledger Account level).
  • Provides a translation adjustment figure, calculated as the sum of Balance Sheet account balances minus the sum of Income Statement account balances that is displayed in the Cumulative Translation Difference report section.

• Features:
  • Excludes elimination journal lines.
  • Consolidation Rates are not required.
  • Returns balances in the currency of the specified Location's reporting currency.
  • Processes transactions exclusively from the specified Location.

Hide Zero Balance

• Defaults to toggle ON
• Hides Ledger Accounts where the resulting balance is zero.
• Ledger Accounts with no activity are never included.

Journal Status

• Options: Dropdown filter to include All journal lines, Draft journal lines, or Posted journal lines
  • Defaults to All

Report Filters

The Trial Balance can be filtered to find the right Ledger Account or set of Ledger Accounts based on the below Ledger Account fields (case-insensitive):

• Name
• Number
• Type
• Report Group
• Subtype

Report Columns

Saving and Sharing

When a Trial Balance report is saved,  the following configuration is saved:

• Visible Columns
• Column Order
• Column Width
• Pinned Columns
• Location
• Date
• Consolidated ON/OFF
• Hide Zero Balance ON/OFF
• Journal Status All/Posted/Draft

Exports

The Trial Balance Report will be exported in xlsx format, and can be done so by clicking export and then export detail: