Financial Reports | Restaurant365 Customer Center

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

Parent Accounts & Child Accounts

GL Accounts can have a specified Parent Account (effectively making them a Child Account). Parent Accounts allow users to group Sub-Accounts under one main Summary Account for subtotal and visual grouping on Financial Reports. To assign a Parent Account to a GL Account, select the Account Name of the desired Parent Account on the GL Account Record A Parent Account can have as many Child Accounts as desired. Restaurant365 will support up to four levels of Parent/Child Accounts. For example: 1) Labor 2) –> Hourly Labor 3) –> –> BOH 4) –> –> –> Kitchen Child Accounts will be indented … Continued

Location Groups

Location Groups allow you to create different sets of locations and then you can filter reports by those location groups instead of having to select locations one at a time on each report. To create a new group follow these steps Open the Location Group window under Administration – Location Groups in the top ribbon Type the group name in the box above the Location Group Name grid and click ‘Add’. This will add the new location group to the list. Click the name in the list to show which locations are assigned to this group in the grid on the … Continued

Trial Balance

As of any date get balance of all accounts and drill down on any balance into the detailed transactions from which you can drill down into any transaction.

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

Trailing 12 Month Report

Displays the previous 12 months profit and loss in columns as of the date chosen to run the report. May filter by location(s), legal entity(s), or concept(s). Can expand the columns to show % of net sales for each month

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

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.

GL Types

GL Types, or rather General Ledger Types, are predefined groups for GL Account Records. GL Types are used for the sorting, grouping and subtotal of GL Accounts on Financial Reports (Balance Sheet and P&L). GL Type is a required field on the GL Account Record. GL Type Presets GL Types are customizable to meet the reporting needs of your organization. Restaurant365 has the following GL Type presets: Create GL Type To create a GL Type, a User with the Accounting Manager Security Role can hover over the Account options on the top ribbon and select ‘New GL Type’. This will open up a … Continued

Profit & Loss – Location Side by Side

Shows week, period, or YTD totals for any combination of locations side by side with a total column. Can drill down into any transaction to view source transactions.