Friday, April 27, 2012

Hospitality Calculation Spreadsheet

A helpful tool for splitting alcohol and food costs.   
Sheila Jurgens and Katherine Lindsay created the attached spreadsheet to simplify splitting out the tax and tip when a bill includes food and alcohol.  By entering (in the yellow cells) 4 numbers off the receipt, it apportions the tax and tip appropriately to food and alcohol.  Two things to keep in mind.  If a bill includes an alcohol-specific tax, you need to adjust to make sure that is handled appropriately.  And, if someone has tipped over the allowable 20%, you'll need to make manual adjustments.  Thanks for sharing this Katherine and Sheila.  DJP

Tip Calculation.xlsx