Profit & Loss – Period & YTD v Budget & Prior Year

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

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

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’

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

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

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

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

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

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

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.