The Balance Sheet displays a company’s financial position by presenting account balances according to the Fiscal Calendar structure. Users can select from the report type options to compare balance sheet details for a specific time frame, location, legal entity, or period.
Retained earnings are included based on net profit for the selected date to provide a clearer view of financial position.
The report types provide a more detailed view of balances by displaying data by period, legal entity, location and other criteria. Available report types include:
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
Parameter | Description |
|---|---|
Report Type | The organization of the Balance Sheet. Report types include: |
Filter By | Filter options for the report:
|
Filter | A list of filter options determined by the 'Filter By' category selected. |
As Of | The date the balances are labeled as of. |
Detail Level | Detail - breaks down Parent accounts into their specified child accounts (ex. Inventory (P) --> Food (C), Produce (C), Dairy (C), ect.) Summary- includes all child Accounts in one parent account total amount. |
Account View | Name -alphabetically organizes GL accounts. Number Then Name - includes the GL account number and organizes by GL Account number. |
Hide $0 Balances | No - Displays all accounts - including GL accounts that have a balance of zero. Yes - Hides all GL accounts that have a balance of zero. |
Rounding | No Rounding - Include decimal values. Whole Numbers - Rounds decimal values to the nearest whole number. |
Show Unapproved | No - Excludes unapproved transactions from the report results. Yes - Includes unapproved transactions in report results. |
View Options | This section provides options to select, save, edit, or delete a report view. |
Run | Generates the report. Click the down arrow to the right of the Run button to export, email, or print the report. |
Report Types
Report columns vary depending on the Report Type that is selected in the report parameters.
YTD (Year to Date)
Column | Description |
|---|---|
GL Type/GL Account | A list of GL Types and GL accounts with the following GL Types:
|
YTD | The year to date balances of each Parent and Child Account |
Legal Entity Side by Side
Column | Description |
|---|---|
GL Type/GL Account | A list of GL Types and GL accounts with the following GL Types:
|
Legal Entity Columns | The legal entities selected in the report parameters and the total balances for each GL Account. |
Location Side by Side
Column | Description |
|---|---|
GL Type/GL Account | A list of GL Types and GL accounts with the following GL Types:
|
Location Columns | The locations selected in the report parameters and the total balances for each GL Account. |
YTD Periods Side by Side
Column | Description |
|---|---|
GL Type/GL Account | A list of GL Types and GL accounts with the following GL Types:
|
Period Columns | The periods as of the selected date range in the report parameters and the total balances for each GL Account. |
Trailing 12 Period Side by Side
Column | Description |
|---|---|
GL Type/GL Account | A list of GL Types and GL accounts with the following GL Types:
|
Location Columns | The twelve periods that follow the selected date range and their amounts side-by-side. |
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.
