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
My Reports: Assigning Report Roles
Report Roles grant access to specific Reports found in ‘My Reports’. Click here for more information on My Reports Assign Report Roles Report Roles can be be assigned using two different methods: Manually on the User Record Using ‘Mass Role Update’ Assign on User Record User Records are located in the ‘Users’ list in the ‘Administration’ subsection of the Accounting Module. Open the User Record of the User that will have the Report Role assigned and navigate to the ‘User Roles’ tab. User Report Roles are located in the section located to the right of the tab. … Continued
Profit & Loss – Operations Statement
Shows weekly profit and loss for any combination of locations for one period with comparison to period budget (with variances) and comparison to period prior year (with variance.)
Item Theoretical Cost Analysis
COGS totals for any span of periods, then broken down by locations. The report utilizes purchases, stock counts, and budgets based on the cost of menu items sold (Pmix) to come up with a difference between actual and expected. It then breaks down how much of the difference is attributable to item price increases/decreases, waste & spoilage, and all other reasons. From this report the user can easily see where to focus time and energy tightening the control of food costs.
Location Reporting Categories
Reporting Categories provide you 10 user defined categories you can assign to locations to group them on reports. For example, if your company is separated into regions, then you can name 1 of the 10 categories as Region and then setup your regions in the system and assign them to locations. Then when running reports you’ll have the option to filter by region and can select which regions you want to see on the report. You can use all 10 of the categories or none of them, however you choose to set it up. To Setup Categories Open Preferences and go … Continued