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.
- Open the Reports app.
- Navigate to My Reports.
- Enter all or part of the report name in the search bar.
- The Results tab will open with the list of search results.
- 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.