This is one of a series of pre-configured and customizeable Microsoft Excel spreadsheets authored by a leading restaurant accounting consultant.
This product is downloadable for immediate free delivery.
This spreadsheet takes this spreadsheet 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.
Use this spreadsheet to organize and analyze critical data from your POS system. But most of all, use it to ensure that opportunities for proactive management don't pass you by. All too often, POS data is automatically posted to accounting software without critical review by a manager, and then the ability to make timely decisions is lost.
This spreadsheet comes with detailed instructions that tell you where to input your information. It even helps you to take action based on the results.
It can easily be customized by an experienced Excel user. Simply unprotect the worksheet, make your changes and then re-protect it again.
Click to Enlarge
Microsoft Excel is required for this product and is not included.