Food Alcohol Tax & Tip calculator

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

Updated: April 2023