In addition to recording the current week's sales information and payroll expenses, this spreadsheet takes the "series" to its logical conclusion by also accounting for your weekly food and beverage purchases as well as beginning and ending food and beverage inventories. The result is a weekly COST OF GOODS SOLD (COGS) SUMMARY and a PRIME COST report which indicate your restaurant's total F&B usage plus Gross Labor in both total dollars and as a percentage of the current week's sales. Use this report to manage both your labor and your purchases and to keep expenses in line with sales budgets.

Summarize your daily food and beverage purchases on a single weekly log sheet. Includes Vendor Name, Invoice Number, Date, and Breakout by Food & Beverage Category. Use the summarized totals to 1) make direct entries into QuickBooks or other accounting software, 2) have a one page, easy to read summary of weekly purchase totals to compare with your budget (based on reordering to specified par levels).

A powerful and fully automated tool to assess the profitability of your menu items based on their food cost, selling price and popularity. Includes five worksheets to assess all your menu categories from appetizers to desserts. A simple set of instructions tells you where to input your information, and even helps you to take action based on the results!

An easy to use tool to help project daily and weekly sales by day-part. Simply input your estimates of the customer (cover) counts and check average for each meal period and the worksheet will auto calculate the sales totals as well as provide the daily percentage contribution. Use this tool in reverse to determine how many covers and/or check averages are required to generate specific total sales.
 

Accruing payroll at the end of each month is unquestionably the most important task that 99% of independent restaurant operators ignore.

More importantly, it results in accurate payroll totals in your all important Profit and Loss Statement! This workbook makes the accrual easy with detailed instructions to guide every step. It also automatically creates the necessary journal entry's (both the accrual and the reversal) to make into your accounting software.