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 allows the User to view the Net Profit of his/her company from a custom date range and compare it to another. This can be a beneficial tool when comparing similar dates from a previous month or even a previous year.
Navigation
To navigate to the Profit and Loss - Custom Date Report, click 'My Reports' under 'Reports' in the left pane and then select 'Financial' in the top header of the reporting window. Once opened, a listing of reports will be shown.
Find 'Profit and Loss - Custom Date' 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.
Report Parameters
Field | Description |
|---|---|
Report Type | A listing of all available report type, options include:
|
Detail Level | If Detail is selected, parent accounts are broken down to display data for each child account (ex. Inventory (P) → Food (C), Produce (C), Dairy (C), etc.). |
Filter By | A list of all filter categories. Filter categories will vary based by report. |
Filter | A list of filter options, determined by the 'Filter By' category selected. |
Custom Date Range | The start of the first date range |
To | The end of the first date range |
Custom Versus Range | The start of the comparison date range |
To | The end of the comparison date range |
Calendar | The option to run the report on the Operational or Fiscal Calendar |
Show Unapproved | These options will either include or exclude Unapproved transactions |
Rounding | Clicking 'No Rounding' will include decimal values while clicking 'Whole Numbers' will round decimal values to the nearest whole number |
Metrics | These options will either hide or show the 'Guest Check Average' and the 'Guest Count' on the top of the report |
Hide $0 Balances | Clicking 'Yes' would hide any zero balances |
Account View | 'Name' will alphabetically organize GL Accounts while 'Number Then Name' will organize by GL Account number |
Location View | 'Name' will alphabetically organize Locations while 'Number Then Name' will organize by Location number |
Custom Fields | A list of Custom Fields that have been added to R365. Both active and inactive custom fields are available for selection, and only one custom field can be selected at a time.
|
Custom Field Options | A list of options associated with the selected Custom Fields. Both active and inactive custom field options are available for selection. Report results are filtered to include only transactions with the selected options assigned. Selecting the ‘blanks’ options includes transactions where the custom field is present but no option is assigned, as well as transactions without the custom field.
|
View options | Provides the user with options to select, save, edit, or delete a report view. |
Run | Generates the report. |
Learn more about Report Views and their added functionality.
Report Columns
GL Accounts and GL Account Types - A listing of all GL Acccounts and GL Account Types broken down by Parent Account. The 'Guest Check Average' and the 'Guest Count' are included on this report when the 'Metrics' parameter is set to 'Show'
Actual - The Income and Expenses from the first date range selected in the report parameters. Next to each amount provided, a Variance percentage is given
Versus - The Income and Expenses from the second date range selected in the report parameters. Next to each amount provided, a Variance percentage of Income and Expenses is given
Variance B/-W - The variance of Sales and Costs between the two date ranges. This column displays both the variance amount and the variance percentage of Income and Expenses is given
Profit and Loss with Custom Fields
When Custom Fields and Custom Field Options are selected, they are displayed at the top of the Profit and Loss report. The report is filtered to only include transaction lines that have the selected custom field options assigned. Totals reflect only the amounts from those filtered lines.
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.