Balance Sheet

Prev Next

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.

  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

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 (#1).

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.
Yes Show $0 Parents - Displays parent accounts with a balance of zero, but hides all other 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:

  • Assets

  • Liabilities

  • Equity

The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

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:

  • Assets

  • Liabilities

  • Equity

The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

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:

  • Assets

  • Liabilities

  • Equity

The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

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:

  • Assets

  • Liabilities

  • Equity

The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

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:

  • Assets

  • Liabilities

  • Equity

The GL accounts displayed are determined by the options selected for ‘Detail’ and ‘Hide $0 Balances’ in the report parameters.

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. Click here to learn how to send, export, or print this report.