Restaurant Financial Reports

Restaurant Financial Reports

Click on the links to view the Restaurant Financial Reports: Balance Sheet Balance Sheet – Side by Side Bank Reconciliation Report Cash Flow Statement Check Register Report GL Account Detail Report Profit & Loss – Trailing 12 Month Report Profit & Loss – Actual Plus Forecast Profit & Loss – Custom Date Range Profit & Loss – Location Side by Side Profit & Loss – Operations Statement Profit & Loss – Period & YTD v Budget Profit & Loss – Period & YTD v Budget & Prior Year Profit & Loss – Period v Budget v Prior Year Trial Balance
Trial Balance

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.
Item Cost % Breakout

Item Cost % Breakout

Calculates the % of the total COGS for each item and recommends items to be flagged as Key Items.  Can be filtered by location, item category, and date range. *** Use this report to determine the Key Items.  For Key Items, you will want to make sure you are counting regularly, they are included on all recipes, waste logs are kept for them, transfers are recorded, and invoices include item level invoicing.
Item Cost Analysis – Location Side by Side

Item Cost Analysis – Location Side by Side

COGS totals and average by COGS type, then GL Account, then Item and % of net sales for each with Locations side by side.  You can drill down to any item to see the item price graph chart and purchase history. Typically used by companies who are not tracking recipes in the system.
Recipe Cost Breakout Report

Recipe Cost Breakout Report

Shows Cost breakdown of each menu item by COGS categories. This report is very helpful with the set-up of Recipes. It will identify any recipe that was set-up incorrectly.
Item Theoretical Quantity Analysis

Item Theoretical Quantity Analysis

Items used totals for any span of periods, then broken down by locations.  The report utilizes purchases, stock counts, and budgets based on the quantity 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 quantity 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.
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.
Item Price Verification

Item Price Verification

Displays the average price paid for key items over a period of time and compares those to the contracted price and also the high and low for the time period.  Use this report to ensure that the price paid for items is the same across all your stores
Item Price Change Analysis

Item Price Change Analysis

Displays all items where a vendor price has fluctuated during the period chosen.  It is used to pin-point which items are experiencing price changes and to what extent those fluctuations are having on the business based on how much those items are used.  Can be run for one or many locations. Note: Report will display items based on the ‘Percent Difference’ filter.  To display all items, including items with no price change, select ‘0’ in the Percent Difference Filter.
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.