Daily COGS Activity
Shows a running total of purchases by category for each day of the period. It also compares the actual spend by category to the budgeted amount for each category for the period.
Check Register Report
Displays all the ins and outs of a bank account with the ability to sort by reconciled amount.
My Reports: Report Roles Setup
Report Roles must be created in order to access the Reports located in ‘My Reports’. Click here for more information about My Reports Alternatively, if all users will need access to ‘All Reports’, this can be set on the User Record. Click here for more information on granting access to ‘All Reports’ Setup Report Roles Navigate to the Report Roles Setup screen to Create and View Report Roles Hover over the ‘Administration’ menu in the Top Ribbon, then hover over the ‘Users & Security’ sub-menu and select ‘Report Roles Setup’. The Report Roles Setup page will load in a new … Continued
Profit & Loss – Period & YTD v Budget & Prior Year
Displays the period v budget and prior year with variances and the YTD as of the period selected with YTD budget and YTD prior year with variances. Can filter by any combination of locations or legal entities.
COGS Analysis by Location
Purchasing transaction totals by location, then vendor, then each transaction with columns side by side of GL Account. Drill down to any individual transaction from the report. Filter by location and by COGS Type.
Forecasting
Forecasting is the window in the system where you can set a sales forecast by location by period and can enter daily values. This forecast can be referenced in the Business Analytics module in the Daily Sales Summary data set to compare to actual values (steps to create this view are listed later in the training). Since forecasting is commonly looked at weekly, this window is designed to work for companies that have their Operational Year setup as 13-4 week periods or 4/4/5 periods so that it can be based on weeks. Calendar periods don’t work well in this screen … Continued
My Reports: Using ‘My Reports’
In order to view and run Reports found in My Reports, a User must first have a Report Role assigned to their User Record. Click here for more information on My Reports Using My Reports Navigate to ‘My Reports’ by clicking on ‘My Reports’ in the left nav area of any Restaurant365 Module. Report Category Tabs Each Report is grouped in to a Category tab within My Reports. Click on the tab to navigate to the category and see and run reports within that group. Additionally, a User can search the entire Reports list (regardless of which Report … Continued
Profit & Loss – Period v Budget v Prior
Displays period, budget, and prior year totals with variance %’s for each. Can be run for any combination of locations, legal entities, or concepts. Can be run in detail or summary and has drill down into any source transaction.
Purchase Analysis by Vendor
Purchasing transaction totals by vendor and then individual transactions with columns for COGS Type side by side. Columns are clickable to see GL Accounts within those types side by side. Drill down to any individual transaction from the report.
Bank Balance vs GL Account Balance
To make sure your bank balances to the GL, you should verify that the “Statement Balance + Uncleared” value on the reconciliation report (circled in red in image below) and the GL account balance for that bank account as of the same date match. There are a few reasons these values may not match. When you approve a bank rec it takes a snapshot of the system as of that time so the “Statement Balance + Uncleared” value on the reconciliation report is showing the balance according to that snapshot. Reasons You Might Not Balance Example 1 “Entered a transaction after … Continued