We are excited that you have chosen to implement R365 Accounting and Operations! This reference guide contains a collection of Advantage reports that you may be familiar with and a comparable R365 report so that you don’t miss a beat.
Get started by learning about running reports in R365! View the support documentation for Using My Reports here.
Accounting Reports
Advantage | R365 |
Chart of Accounts Report
| GL Accounts Grid
The GL Accounts Grid is a versatile grid allowing Users to filter and export the list of GL Accounts as needed.
|
General Ledger
|
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 irregular.
|
Trial Balance
|
The Trial Balance Report enables a User to see all the final accruals for GL Accounts to make sure that they are in balance. This is usually run at the end of a period and can be helpful in the making of financial statements. If the debit and credit columns do not match, this can be the tool to figure out the accounts that need to be further analyzed.
|
Cash Flow
|
The Cash Flow Report shows the sources and uses of cash from operating, investing, and financing activities using the indirect method.
|
Balance Sheet
Profit & Loss
|
The Balance Sheet shows the financial position of a company, representing the balances of each account based on the configured 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.
The P&L Report allows the User to compare the total income and expenses at specified Locations as of a specific date and based on either their Fiscal or Operational Calendar structures.
This report provides the ability for your restaurant managers to see and compare the P&L numbers to all other Locations in your Restaurant Group.
|
Reconciliation Report
|
Detailed or summary view of cleared and outstanding transactions included on a bank reconciliation.
|
Voucher History
Vendor Payment Apply To
Vendor Payments
Email ACH Payment Summaries
| AP Transactions Grid
The AP Transactions Grid is a versatile grid allowing Users to review AP Transactions, including AP Invoices, AP Credit Memos, and AP Payments.
|
Vendor Aging
|
The AP Aging Report shows all open AP Transactions, including Credit Memos that have not been applied to an invoice yet, listed with day ranges to show which invoices are current or past due.
|
Customer Statements
|
The Customer Statement Report is an issued document made out to a customer. This statement tells the customer how much they still owe from an outstanding invoice or transaction.
If multiple customers are selected, the report will have a different page for each customer.
|
Customer Aging
|
The AR Aging Report provides a list of all open AR Transactions that have not yet paid their invoices. This report helps to keep companies in check and allows restaurants to notify other companies of their outstanding invoices.
|
Customer Transaction Detail
Payment Apply-to
| AR Transactions Grid
The AR Transactions Grid is a versatile grid allowing Users to review AR Transactions, including AR Invoices, AR Credit Memos, and AR Payments
|
Custom Financial Reports
If enabled, the Custom Financial Reports feature allows Users to create and share financial reports that are customized to your organization’s needs. To learn more about how CFR can enhance your R365 experience, contact your CSM.
Operations Reports
Advantage | R365 |
Price Variance – Last Purchase |
The Item Price Change Analysis Report shows the purchase price as of the start date of the report versus the average purchase price over the date range of the report. It also shows the COGS usage over the same date range and the COGS impact that the higher/lower price has made per item. This can be run for one or more Locations to compare item price changes across stores. |
Receiving by Inventory Item
Adjust Posted Vouchers
|
The Received by Purchased Item Report displays all of the items received by a certain Location over a period of time. This report can be helpful in seeing the information tied to Purchased Items sorted by Item Categories.
|
Pre-Post Report
Valuation Report | Inventory Count – Print Count Review
The Print Count Review Report is a printable PDF summary of an approved Inventory Count. This report allows the User to view the following summary information:
The P&L Report allows the User to compare the total income and expenses at specified Locations as of a specific date and based on either their Fiscal or Operational Calendar structures.
|
Inventory Count Variance Report
Controllable Cost of Goods
Inventory Count Variance
| Actual vs Theoretical Analysis
The Actual vs Theoretical Analysis Report shows actual vs theoretical numbers in terms of both quantities and dollars. The User can drill down into the transactions that make up the numbers, as well as roll up summary info by Category for a Controllable Cost of Goods approach to analysis.
|
Sales Mix
|
The Product Mix Report shows each Menu Item's percent of Sales for a selected period of time. This report can help show which menu items are driving Sales.
|
Menu Engineering
|
The Menu Item Analysis Report is most beneficial in analyzing a marketing strategy for a Location's Menu Items to help turn a higher profit. It shows the margin and quantities of Menu Items ranked against each other and recommends a call to action for each Menu Item.
|
Menu Item Contribution/Theoretical Cost |
The Menu Price Analysis Report shows the cost and selling price for each Menu Item, determines a profit from those metrics, and then calculates a variance and price needed to hit the target percentage, based on the User-supplied target percentage. |