Advantage & R365 Report Comparison
  • 07 Nov 2024
  • 4 Minutes to read
  • Dark
    Light
  • PDF

Advantage & R365 Report Comparison

  • Dark
    Light
  • PDF

Article summary

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! Learn more about using My Reports. 


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

 

 

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

 

Trial Balance

 

 

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

 

 

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

Balance Sheet

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.

Profit & Loss

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.

P&L Comparison

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

Bank 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

AP 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

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

AR 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 tailored to their organization’s specific content, layout, and design needs.

To learn more about how CFR can enhance your R365 experience, contact your CSM. 


Operations Reports

Advantage

R365

Price Variance – Last Purchase

Item Price Change Analysis

 

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

 

Received by Purchased Item

 

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:

 

  • Inventory Count by Inventory Item

  • Current Values by Inventory Item and Storage Location

  • Previous Values by Inventory Item and Storage Location

  • Adjustments by Inventory Item, Storage Location, Inventory Account, and Cost Account

 

Profit and Loss

 

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

Product 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

Menu Item Analysis

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

Menu Price Analysis

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.

 


Was this article helpful?