Event invoices stack a service charge and gratuity on the subtotal — and tax often applies to the service charge too. Layer the percentages correctly to get the real total.
The example
$7,800 food + 22% svc, 8% tax, 18% tip.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Subtotal | 7800 |
| 3 | Grand total | → ~$11,690 |
The formula
The formula:
How it works
How it works:
- Service charge (often 18–24%) is added to the subtotal — and is frequently taxable.
- Tax applies to the subtotal plus the service charge in many states.
- Gratuity for staff is usually a separate line, calculated on the pre-tax subtotal.
- Read the contract — whether the service charge is the gratuity varies, so confirm to avoid double-tipping.
“Service charge” is not always gratuity. Some venues keep the service charge as a house fee and expect an additional tip; others distribute it to staff as the gratuity. Tipping again on top can add hundreds. Confirm in writing what the service charge covers before adding a separate gratuity line.
Try it: interactive demo
Subtotal, service %, tax %, gratuity %.
Variations
Service charge amount
House fee:
Tax on sub + service
Compounded tax:
Gratuity (pre-tax)
Staff tip:
Pitfalls & errors
Tax on service charge. Many states tax it — don’t omit it.
Service charge ≠ tip. Confirm whether staff get the service charge before adding gratuity.
Layer order. Service and tax compound; gratuity is usually a separate pre-tax line.
Practice workbook
Frequently asked questions
How do I calculate event gratuity and service charge in Excel?
Is the service charge the same as a tip?
Is the service charge taxable?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class