● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Payroll & HR›Tip Tracker Spreadsheet for Servers and Bartenders
Tip Tracker Spreadsheet main view of the shift tips workbook
PAYROLL & HR

Tip Tracker Spreadsheet for Servers and Bartenders

Cash tips are the easiest money to lose track of, a few dollars here and there until the month is a blur. This tip tracker spreadsheet counts every shift, cash and card separately, so you know what you really earned.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Know what you earned, and whether the paycheck was right

Tip income feels good in the moment and fuzzy by payday. A busy Friday, a quiet Tuesday, cash in the apron and card tips on the stub, and nobody can say what the month actually paid per hour. This tracker fixes that with one habit: log each shift the night you work it, cash and card separately, and the workbook does every bit of adding up from there.

The Shift Log holds one row per shift with the job, hours, sales, cash tips, card tips and tip-out. Total tips, take-home and dollars per hour calculate themselves. Your tip-out rules are set once on the Tip-Out Setup tab, whether the share is of sales, of tips or a flat amount per shift, and the log applies them before working out your take-home. Weekly and Monthly Summaries then roll the shifts up so a slow week shows early.

Two tabs protect you at payday and tax time. Paycheck Check adds your wages to your logged take-home tips and compares the result with the actual paycheck from your stub, flagging any difference so a short check never slips by. The Tax-Ready Summary totals the year by month with a set-aside figure from your rate, and Goals and Savings tracks what you are putting away from the good shifts.

Inside the workbook: 9 tabs

What you receive

  • Google Sheets Access PDF with a 1-click copy link for the full 9 tab workbook
  • BLANK Excel workbook, your fresh start with all formulas ready
  • EXAMPLE Excel workbook filled with demo data for a server and a bartender
  • Quick Start Guide PDF that walks through setup in about five minutes
  • Four separate files, delivered individually, no ZIP

Good to know

  • Runs in Google Sheets with a free Google account
  • Also runs in Excel 2016 and later
  • Works for two jobs at once, each with its own wage and tip-out rules
  • You only type in the yellow cells, everything else calculates
  • A personal planning record, not tax advice

Questions about this template

The things buyers ask us most.

Can I track two jobs with it?

Yes. The example workbook follows a server job and a bartender job at once, each with its own hourly wage and its own tip-out rules. The Dashboard compares the two by dollars per hour, so you can see which shifts are really worth picking up. Job names can be changed for barista, delivery or styling work too.

How do I handle cash tips?

Log them in the Cash Tips column on the Shift Log the night you earn them, separately from card tips. It takes seconds while the shift is fresh, and it matters: the Dashboard shows your cash share of income, and the Tax-Ready Summary keeps the daily record of cash and card tips across the whole year.

How does the Paycheck Check work?

The tab adds your wages for the pay period to your logged take-home tips, then compares that figure with the actual paycheck amount you copy from your pay stub. A difference of zero means the check matches. If the real paycheck comes in short, the tab flags it so you can raise it while the shifts are still easy to prove.

Do I need to know formulas?

No. You only type in the yellow cells: the shift details, your tip-out rules and the paycheck figures. Every total, take-home amount, dollars per hour figure and summary is calculated for you. Setup takes about five minutes with the Quick Start Guide, and after that it is one row per shift, logged the night you work it.

More in Payroll & HR

All templates in this category →

Three more workbooks from the same shelf.

Performance Review Tracker

Review dates, goals and feedback in one place, with overdue flags built in.

$2.50 $1.00
View on Etsy
New Hire Onboarding Tracker

Run the same calm onboarding checklist for every new hire, with training and progress tracked.

$2.50 $1.00
View on Etsy
Time Off Tracker

Leave requests, approvals and balances in one sheet, days counted for you.

$2.50 $1.00
View on Etsy
View on Etsy · $3.00