TIPS Calculator
Restaurant Tips, Pay Allocation & QuickBooks Export
đĩ Tips Input
đ Summary
Total Tips:
$0.00
Total Hours:
0.00
Tips per Hour:
$0.00
Cash Tip Rate:
$0.00/h
Credit Tip Rate:
$0.00/h
đŧ Payout Summary
| Name | Tier | Total Hours | Tips/Hour | Total Tips | Base Pay | Total Payout | Effective $/h | vs Living Wage |
|---|---|---|---|---|---|---|---|---|
| No data available. Add employees and enter hours to see payouts. | ||||||||
â° Hours Entry
Enter hours worked for each employee by shift type
| Employee |
|---|
| No employees added yet. |
đ˛ Hourly Rates
Set regular and overtime hourly rates per shift type
| Employee |
|---|
| No employees added yet. |
đĨ Employee Management
| Name | Tier | Status | Exclude | Actions |
|---|---|---|---|---|
| No employees added yet. Click "Add Employee" to get started. | ||||
đĻ Archive
Save and view historical snapshots
đ QuickBooks Export
Export data in QuickBooks-compatible format (grouped by pay rate)
| Employee Name | Pay Rate 1 | Hours at Rate 1 | Pay Rate 2 | Hours at Rate 2 | OT Rate 1 | OT Hours 1 | OT Rate 2 | OT Hours 2 | Cash Tips | Credit Tips |
|---|---|---|---|---|---|---|---|---|---|---|
| Click "Generate Export" to create QuickBooks data. | ||||||||||
đ Google Sheets Sync
Sync current tip calculator data to legacy Google Sheets workbook.
OAuth2 token expires after ~1 hour. Get from Google OAuth Playground.
đ Sync Status
Click "View Sync History" to load recent syncs...
âšī¸ What Gets Synced
â Synced (INPUT cells)
- Employee hours per shift
- Cash tip totals
- Credit tip totals
- Living wage rate
â NOT Synced (Calculated)
- Tip distributions (formulas)
- Wage calculations (formulas)
- Pool allocations (formulas)
- All derived values
â ī¸ Important: Only INPUT cells are updated. The Google Sheet's formulas will automatically recalculate based on the new data.