Working Trial Balance

Prev Next

The Working Trial Balance report produces a running balance of GL accounts for a selected date range and displays amounts for both Approved and Unapproved transactions. A user can use this report to easily review these balances and identify potential adjustments.


Navigation

The My Reports search bar can be used to search R365's entire catalog of reports.

  1. Open the Reports app. 
  2. Navigate to My Reports
  3. Enter all or part of the report name in the search bar.
  4. The Results tab will open with the list of search results.
  5. From beneath the report name, click Run to run the report with the selected report view.
    -OR-
    Click Customize to adjust the report parameters and run the report. 



Report Parameters

Field/Column

Description

Account

A listing of all GL accounts.

Legal Entity

A listing of all legal entities.

Location

A listing of all locations tied to the selected legal entities.

Start

A beginning balance date for the report.

End

An ending balance date for the report.

Hide Debit And Credit

The option to hide the debit and credit columns in the report.

Hide Adj Ending Balance Is 0

The option to hide the rows when their adjusted ending balance is $0.00.

Run Button

Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action.


Report Columns

Field/Column

Description

Account Number

The GL account number.

Account Name

The GL account name.

Beginning Balance

The summary balance for the GL account up to the parameter date entered. This includes only approved transactions.

Debit

For balance sheet accounts, this is the sum of all debit entries from the beginning balance date. For P&L accounts, this is the sum of all debit entries from whichever date is more recent: the beginning balance date or fiscal year start date. This includes approved transactions only.

Credit

For balance sheet accounts, this is the sum of all credit entries from the beginning balance date. For P&L accounts, this is the sum of all credit entries from whichever date is most recent: the beginning balance date or fiscal year start date. This includes approved transactions only.

Net Change

The difference between the debit amount and the credit amount.

Ending Balance

The sum of the beginning balance amount and the net change.

Unapproved

The sum of all unapproved transactions from the beginning balance date to the ending balance date.

Adjusted Ending Balance

The sum of the ending balance and the unapproved transaction amount.

Notes

A printed line to enable written notes, if printed.


Email, Export, or Print the Report

This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Learn more about how to send, export, or print this report.