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. |
Filter by | Filter options for the report: |
Filter | A list of filter options determined by the 'Filter By' category selected. |
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. |
Hide Zero Balances | When set to Yes, accounts with a $0 balance are hidden from the report. |
Exclude GL W/Out Activity | Includes or excludes GL accounts in the report that do not have activity for the date range selected. |
When set to Yes, location balances are listed under each account section. | |
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. |
Show by Location Example
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.
