Financial Reports

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 ...

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. ...

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...

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 ...

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...

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 ...

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...

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...

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 ...

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...

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 ...

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...

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...

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...

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...

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...

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...

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...

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...

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 ...

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...

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 irre...

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 To...

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, ex...

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...

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 ...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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...