The Balance Sheet shows the financial position of a company, representing the balances of each account based on the Fiscal Calendar structure. Selecting a report type can enable a User to compare the details about their company's GL Accounts as of a specific date from one Location or period to another.


To aid in understanding your company's financial position, R365 includes Retained Earnings for the date range selected based on net profit. Additionally, Users with access to this report can email, export, or print this report directly from the reporting window.


Report types vary but can allow for a more precise view of balances based on Period, Legal Entity, Location, and more. These report types include:


Article Topics


To navigate to the Balance Sheet, click 'My Reports' under 'Reports' in the left pane and select 'Financial' in the top header of the reporting window. Once opened, a listing of reports will be shown. 


Find 'Balance Sheet' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.


Back to Top

Report Parameters



1) Report Type - The organization of the Balance Sheet. Report types include:

2) Filter By - A listing of all Location categories

3) Filter - A listing of all Locations associated with the selected Location category

4) As of - The date the balances are labeled as of

5) Detail Level - 'Detail' breaks down Parent Accounts into their specified Child Accounts (ex. Inventory (P) --> Food (C), Produce (C), Dairy (C), ect.) while 'Summary' will include all Child Accounts in one Parent Account total amount

6) Account View - 'Name' will alphabetically organize GL Accounts while 'Number Then Name' will organize by GL Account number

7) Hide $0 Balances - Clicking 'Yes' will hide all balances and their GL Accounts that have a balance of zero

8) Rounding - Clicking 'No Rounding' will include decimal values while clicking 'Whole Numbers' will round decimal values to the nearest whole number

9) Show Unapproved - This will either show or hide Unapproved transactions

10) 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. Click here to learn more about this functionality 


Click here to learn more about Report Views and their added functionality.


Back to Top

Report Type Variations


Report columns vary depending on the Report Type that is selected in the report parameters.

 

YTD (Year to Date)



1) GL Type - A listing of all Assets, Liabilities, and Equity listed by the Parent Account and broken down by Child Account

2) YTD - The year to date balances of each Parent and Child Account




1) GL Type - A listing of all Assets, Liabilities, and Equity listed by the Parent Account and broken down by Child Account

2) Legal Entity Columns -  The Legal Entities and their amounts side-by-side

3) Total - The total line amount of all columns


Location Side by Side



1) GL Type - A listing of all Assets, Liabilities, and Equity listed by the Parent Account and broken down by Child Account

2) Location Columns -  The restaurant Locations and their amounts side-by-side

3) Total - The total line amount of all columns


YTD Periods Side by Side



1) GL Type - A listing of all Assets, Liabilities, and Equity listed by the Parent Account and broken down by Child Account

2) Period Columns -  The periods as of the selected date range and their amounts side-by-side

Trailing 12 Period Side by Side



1) GL Type - A listing of all Assets, Liabilities, and Equity listed by the Parent Account and broken down by Child Account

2) Trailing 12 Periods -  The twelve periods that follow the selected date range and their amounts side-by-side


Back to Top

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.


Back to Top