#  Food Alcohol Tax & Tip calculator 

 



 ##  

  expand\_more  

 
  

 

This tool will aid in allocating the appropriate amount of tax and tip on a restaurant receipt that includes food, non-alcoholic beverages and alcohol charges. Instructions can be found on one of the worksheets within the file, as well as below:

**Single Tax + Tip Calculator**

Instructions to Calculate Prorated Food and Alcohol:

\[1\] Enter total (after taxes) amount from receipt into "Total with Tax" field.

\[2\] Enter total sales tax amount from receipt into "Tax" field.

\[3\] Enter gratuity (tip) amount from receipt into "Gratuity (Tip)" field.

\[4\] Enter total food amount (before taxes and tip) into "Food and Nonalcohol Beverages (Before Tax and Tip)" field.

\[5\] Enter total alcoholic beverages amount (before taxes and tip) into "Alcohol (Before Tax and Tip)" field.

Please note: Verify total amount paid from receipt reflects "Grand Total".

\*\*Optional: Save worksheet as a PDF and print out as supporting documentation for reimbursement request (e.g. Concur and B2P).\*\*

**Multiple Tax + Tip Calculator / Guest Breakout**

Instructions to Calculate Prorated Food and Alcohol:

\[1\] Enter unique receipt identifier, including the name of restaurant (or food establishment).

\[2\] Enter total (after taxes) amount from receipt into "Total with Tax" field.

\[3\] Enter total sales tax amount from receipt into "Tax" field.

\[4\] Enter gratuity (tip) amount from receipt into "Gratuity (Tip)" field.

\[5\] Enter total food amount (before taxes and tip) into "Food and Nonalcohol Beverages (Before Tax and Tip)" field.

\[6\] Enter total alcoholic beverages amount (before taxes and tip) into "Alcohol (Before Tax and Tip)" field.

\[7\] Enter guest food and alcohol amounts based on the number of guests attending business event and compare results to total receipt amounts for breakdown.

Please note: Verify total amount paid from receipt reflects "Receipt Total ERROR check".

\*\*Optional: Save worksheet as a PDF and print out as supporting documentation for reimbursement request (e.g. Concur and B2P).\*\*

[Click here for the Food and Alcohol Tax/ Tip Calculator](/file_url/123)

**Updated:** April 2023