Create Ticket
Submit an Idea
Talk to an Expert
System Status
Contents
x
Getting Started
Frequently Asked Questions
How To Videos
Release Notes
Administration
Accounting
Smart Ops
Workforce
Hire
Reports
R365 Mobile
R365 Intelligence
Integrations
APS Payroll
ExpandShare
Channel Partners
Other
Powered by
Financial Reports
40 Articles
in this category
Share this
Print
Share
Dark
Light
Contents
Financial Reports
40 Articles
in this category
Share
Dark
Light
Financial Reports Overview
Financial Reports allow users to view account transactions and balances for their restaurants. While it is mainly Accounting users who utilize these reports, they offer many great benefits to Operators as well. Navigation ...
Updated on : 04 Jul 2024
Account Balance by Location
The Account Balance by Location report displays the totals for a specific GL Account for all Locations. The User is able to view the debits and credits of one or more account(s) across multiple Locations for a better look into account details. ...
Updated on : 04 Jul 2024
Account Balance by Location Export
The Balance by Location Export runs account balances by any Location Category selected. Unlike the Account Balance by Location Report, this report includes more details about the balances, including the accounts connected to each Legal Entit...
Updated on : 04 Jul 2024
Account Trx Summary by Location Export
The Account Trx Summary by Location Export displays the transactions made by each account at a chosen Location. This detailed report will enable a User to view and export an organized history of transactions with a certain account, showing its ...
Updated on : 04 Jul 2024
AP Accrual
The Accounts Payable Accrual report is used to gather the information entered regarding the Dates of Service for an expense and summarize it at month end so a journal entry can be recorded. Click here for more information on Dates of Service e...
Updated on : 04 Jul 2024
Asset Tag Printout
The Asset Tag Printout will run a document containing identifying information of all selected assets. This can be exported and printed out to place on those assets at the User's company. Navigation To navigate to the Asset Tag Printout, click ...
Updated on : 04 Jul 2024
Asset Value Report
The Asset Value report displays the values of all assets in the company as of a certain date. This report is helpful in viewing active, retired, depreciated, CIP, or draft assets along with asset classes and categories to understand how a company...
Updated on : 04 Jul 2024
Balance Sheet
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...
Updated on : 04 Jul 2024
Balance Sheet - Layout Format
The Balance Sheet - Layout Format allows the User to edit the layout of the Balance Sheet directly from this report by drilling into the GL Accounts and updating their GL Types and/or Parent Accounts. A User can then review this format to ensure ...
Updated on : 04 Jul 2024
Blackline Export
The Blackline Export will export GL Account data that can then be uploaded and used for accounting purposes in Blackline. Navigation To navigate to the Blackline Export, click 'My Reports' under 'Reports' in the left pane and select 'F...
Updated on : 04 Jul 2024
Cash Flow
The Cash Flow report shows the sources and uses of cash from operating, investing, and financing activities using the indirect method. This report is best to use during setup to make sure that all GL Accounts are set up correctly and that ...
Updated on : 04 Jul 2024
Restaurant Financial Reports List
Single Day Performance Overview Flash Report Daily Sales Report Multi-Day Performance Overview Profit and Loss (recommended formats are 'Period and YTD vs Budget and Prior Year' and 'Trailing Period Over Period') Balance Sheet GL Accou...
Updated on : 04 Jul 2024
Cash Flow Side by Side
The Cash Flow Side by Side report is similar to the Cash Flow report but has the added benefit of listing multiple years or Legal Entities side by side for an easier comparison. Check out the pulse of your organization by running this report. N...
Updated on : 04 Jul 2024
Daily Sales Report
The Daily Sales report compares this year's sales to sales from the previous year for each selected location. With this report, users can get a deeper look into Day Part Sales and Check Counts to better understand what is driving an increase or decr...
Updated on : 01 Aug 2024
Extended Daily Sales
The Extended Daily Sales report is an extension of the Daily Sales Report and includes the totals for all Sales and Check information. To get a closer look at how Sales for a day compare on a larger scale, a User can compare Actual Sales to Last...
Updated on : 04 Jul 2024
Fiscal Calendar
This report allows a User to view both the Fiscal and Operational Calendars for his/her restaurant. This can be extremely beneficial in clarifying the structure of your fiscal weeks and periods. Also, a User is able to change the Legal Ent...
Updated on : 04 Jul 2024
Fiscal Year Error Check
The Fiscal Year Error Check report displays any critical Fiscal Year errors that occurred during their creation. This is helpful prior to implementing Fixed Assets and to ensure that each fiscal year transitions correctly into the next. Navigat...
Updated on : 04 Jul 2024
Fixed Asset Activity - Depreciation
The Fixed Asset Activity - Depreciation report helps restaurant managers and accountants monitor and manage the depreciation of fixed assets. This report provides insights into depreciation activities for the specified year, including the asset's or...
Updated on : 30 Jul 2024
Fixed Asset Activity - Disposal and Retirement
R365's Fixed Asset Activity - Disposal and Retirement report provides information regarding the disposal and retirement of fixed assets within a business. This report helps users track the lifecycle of fixed assets. By effectively managing the e...
Updated on : 30 Jul 2024
Fixed Asset Activity - Place In Service
R365's Fixed Asset Activity - Place In Service report helps users track the activation of fixed assets within a business. This report provides detailed information about assets that have been placed into service, ensuring accurate financial records ...
Updated on : 30 Jul 2024
Franchise Invoicing Report - Summary View
The Franchise Invoicing Report - Summary View is ran against the items that were billed against a franchisee in a selected date range. This report shows a summary of all the AR Invoices in a selected period of time, including the Credits and Paym...
Updated on : 04 Jul 2024
GL Account Detail
The GL Account Detail report allows the User to drill into all transactions associated with a selected account. Reference numbers are hyperlinked to their respective transaction entries so that the User is able to view entry data that may be ir...
Updated on : 24 Oct 2024
GL Account Detail Export
The GL Account Detail Export allows the User to drill into all transactions associated with a specified account(s). This report also uses hyperlinked reference numbers that show their respective transaction entries in a new tab. Navigation ...
Updated on : 24 Oct 2024
GL Account Detail with Legal Entity
The GL Account Detail with Legal Entity Report runs the system for all General Ledger account details so that the balance of an account can be reconciled over a date range. Users who have access to this report have the ability to email, ...
Updated on : 24 Oct 2024
GL Account Detail with Legal Entity Export
The GL Account Detail with Legal Entity Export runs the system for all General Ledger account details so that the balance of an account can be reconciled over a date range. This export also includes the Running Total Net Change and Running Tota...
Updated on : 24 Oct 2024
Net Sales By Daypart
The Net Sales by Daypart Report breaks down the Net Sales by Item Categories and the day parts set for a Location. This report helps in scheduling by showing the highest and lowest peaks during the day. Navigation To navigate to the Net Sales ...
Updated on : 04 Jul 2024
Profit and Loss
The P&L report compares the total income and expenses at specified locations, as of a specific date, based on either their fiscal or operational calendar structures. With this report, users can see how all GL accounts and account types have dir...
Updated on : 16 Jul 2024
Profit and Loss - Custom Date
The P&L Custom Date Range Report allows the User to compare the total income and expenses at selected Locations across a period of time and based on either their Fiscal or Operational Calendar structures. The Custom Date option to this report a...
Updated on : 04 Jul 2024
Profit and Loss - Layout Format
The P&L - Layout Format Report allows the User to edit the layout of the P&L directly from this report by drilling into the GL Types and GL Accounts. A User can then review this format to ensure it is providing the most beneficial layout for...
Updated on : 04 Jul 2024
Profitability Report
The Profitability report is based on the Profit and Loss report and combines monthly Costs and Sales to calculate a single chosen Location's estimated Profit. This report combines actual data for the month up to the current day and the forecasted am...
Updated on : 16 Jul 2024
Transaction Detail Export
The Transaction Detail Export and the Transaction Detail Export - Ctuit display the transaction history from a specified date range, which can be exported from R365. This detailed report provides precise transactions that can be exported when trans...
Updated on : 04 Jul 2024
Trial Balance
The Trial Balance report enables a User to see all the final accruals for GL Accounts to make sure they are in balance. This is usually ran at the end of a period and can be helpful in the making of financial statements. If the debt and credit colum...
Updated on : 29 Jul 2024
Working Trial Balance
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 poten...
Updated on : 04 Jul 2024
GL Account Drill-Downs
With most Financial Reports and all Custom Financial Reports, Users have the ability to click any number within the report to drill-down into the number. Drill-downs open the GL Account Detail Report in a new tab. The GL Account Detail will run w...
Updated on : 04 Jul 2024
Synexus Sales Tax Export
The Synexus Sales Tax Export exports sales tax data from R365 into a .csv file, which can then be uploaded to Synexus for processing. Navigation To navigate to the Synexus Sales Tax Export, first open the Reports page clicking 'M...
Updated on : 04 Jul 2024
Spread Memorized Transaction List
The Spread Memorized Transaction List displays all spread and memorized transaction details from within a selected time frame. This enables a User to view the Locations associated with each spreading, the cost of each spread, the amount of times ...
Updated on : 04 Jul 2024
Controllable Profit and Loss Mapping Guide
The Profit and Loss, or Income Statement, compares all of the income from your Restaurant Organization against the expenses entered for each Location to view your net profit. Within this report, there are expenses that are controllable, meaning that...
Updated on : 26 Jul 2024
Troubleshoot an Out of Balance Balance Sheet
When your Balance Sheet is out of balance, it can be challenging to figure out the initial point when this may have occurred. This article reviews one way that you can decipher when and what caused your Balance Sheet to be out of balance. Step...
Updated on : 23 Jul 2024
Troubleshoot a P&L Report Missing Budget Data
If you run your P&L report and notice that it's missing budget data, first make sure that the budget record is specified as Reporting Budget . Then, before you run the P&L report, click Customize and examin...
Updated on : 26 Jul 2024
P&L Report v AvT Report
The Profit and Loss statement and the Actual vs Theoretical Analysis report are not intended to tie back to each other, but even further, the amounts on these reports may have a bigger variance due to the following reasons:&n...
Updated on : 26 Jul 2024