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.
The worksheet tracks your sales data from cash register or POS reports and organizes daily and week-to-date results. Print the report at the close of each day and share with key management. Monitor sales by category and track weekly trends.
Labor expenses are also tracked by department against the sales so you can monitor your daily and week-to-date labor costs as a percentage of sales. The spreadsheet allocates your labor costs by department (e.g. Kitchen, Front of House, Managers, etc.) utilizing the labor report information from your POS report and salaried employee inputs. The report also accounts for estimated employer tax expenses. Monitor your daily and weekly labor expenses as compared to labor targets that you choose. A very powerful tool!
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.