Dashboard and Ad Hoc Reporting Overview

Dashboard and Ad Hoc Reporting Overview

Summary Restaurant365 comes with a powerful ad hoc report viewer that allows users to slice and dice data.  These ad hoc reports and charts can also be shown in dashboards so users can make decisions that increase productivity and reduce costs.  Security roles determine who can see and modify these elements.  Ad hoc reports and dashboards are accessed in the left hand navigation under Operations – Reports – Ad Hoc Reports or Dashboard respectively and users with access to the accounting module can also see them under Accounting – Reports. Reporting Elements Defined Below is a description of the different elements of the … Continued
DSS Journal Entries

DSS Journal Entries

For POS Integrated Locations, a Daily Sales Summary (DSS) file will be imported each day for the prior day’s Sales and Labor.  Click here for more information on the Daily Sales Summary.  In addition to the DSS file being imported each day, two DSS Journal Entries are created from the data on the DSS. DSS Journal Entry Walkthrough To demonstrate where DSS Journal Entries are located, how you can view them, and how you can update and approve them, please read the following walkthrough:   Record Locations: Daily Sales Summary Before any DSS Journal Entries will appear, the DSS must be imported.  This is … Continued
Balance Sheet – Location Side by Side

Balance Sheet – Location Side by Side

Available in summary or detail, displays selected legal entities side by side with a total column. Can drill down into any balance to view transactions.
Stock Usage Report

Stock Usage Report

Upon completing a Stock Count, the User can run the Stock Usage report via My Reports to see metrics on Inventory Usage, Purchases, Sales and Inventory Turns.  To run the report, navigate to ‘My Reports’ and select the ‘Stock Usage’ report and click ‘Run’: Sample Report:   Click here for more information on Stock Counts in Restaurant365
PDF Report/Check Now Prompting You to Save

PDF Report/Check Now Prompting You to Save

Each time you create a PDF in the system such as running a report or printing a check, that PDF is saved by default in your downloads folder. For example if you print a check, it saves in the downloads folder as Check. If you print another check it saves as Check (1), the next time as Check (2), then Check (3) etc. The limit to these files being downloaded is 101. Consequently, when you reach Check (100), a new dialog box will appear prompting you to save the file instead of downloading it as it did before. The same … Continued
System Preferences: Miscellaneous

System Preferences: Miscellaneous

Overview The ‘Miscellaneous’ tab resides on the System Preferences screen and contains various system settings that effect how data is displayed, created, and updated throughout Restaurant365.  Click here for more information on System Preferences. 1) Sales Tax Rate – Set the default Sales Tax Rate for AR Transactions.  Sales Tax Rates for each Location can be set on the Location Record 2) PL Report Percent Of – Sets the default ‘Percent of’ option on all GL Accounts that have GL Types on the Profit and Loss statement.  Click here for more information on Report Settings.  System Default is ‘Net Sales’.  Options include: … Continued
GL Account Detail Report

GL Account Detail Report

This report shows each transaction that has hit an account (or multiple accounts) within a selected date range.  This report can be run from My Reports and is also the report that the P&L, Trial Balance, and Balance Sheet drill down to when you click on an amount on those reports to see more details.  Clicking on the blue link in the Ref. Number column of this report will open that transaction. Once the report is opened there are some parameters at the top the user can set that will change how the data is displayed: Account – select which … Continued
Period Purchases Analysis by Vendor

Period Purchases Analysis by Vendor

Displays total purchases by Vendor and then by GL Account for any given period for any combination of locations.  Breaks out the purchases by week during the period and has totals for each week, each vendor, and the period.  Drill down  into any source transaction.
Comparable Stores

Comparable Stores

A grouping some restaurant companies use to analyze similar stores often vs a prior year is accomplished in the system with the Comparable (Comp) Stores feature.  This allows a company to state which dates each location should be included in the comp store group for reporting.  There are many reports that can be filtered to run only for comp stores or non-comp stores. Setup When a restaurant first opens many restaurant companies don’t want to include it in some reports because of its lack of historical sales and the variability of sales in the first few months so its considered non-comparable.  Often … Continued
Profit & Loss – Actual Plus Forecast

Profit & Loss – Actual Plus Forecast

Displays each month of the year with actual values for past months and budget values for future months.  Totals these two together to show what the company is ‘on-track’ to do for the year verses the original budget.  Displays variance and % columns. May be filtered by location(s) or legal entity.