Report this item to Etsy

Server Tip Ledger | Restaurant Shift Log, Pay Stub Check (Google Sheets)

Price:$9.99

Includes Etsy Purchase Protection

  • You get a Google Sheets copy link and a setup guide. Nothing ships by mail.

    0/10

  • Etsy search, Pinterest, Google, a friend - whatever fits.

    0/100

  • Just yes or no - helps us welcome new customers.

    0/100

  • Tell us what you'd love a Ledger & Light tool for next.

    0/100

You can only make an offer when buying a single item

Highlights

  • Digital download

Form to sheet: log it in-the-moment on a Google Form on your phone, and the entry lands organized in your Google Sheet. No app, no re-typing. That's how every Ledger & Light tool works.

Every table you turn adds up. Your Server Tip Ledger keeps the running count.

After the last table is bussed, log the shift from your phone: the hours on the floor, cash left on the table, card tips from the checks, and the tip-out to bussers, the bar and hosts — whether you paid it in cash at the end of the night or the restaurant took it through payroll. The sheet does the arithmetic — net tips and dollars per hour for that shift — and builds your week, month and year from there. Lunch against dinner, weekday against weekend: the numbers show which sections and shifts earn most.

Payday gets a second look, too. The Pay Stub Check tab takes the card-tip figure printed on each stub and sets it beside what your own shift log says the restaurant owed you for those dates. When the two disagree by more than a dollar, that pay period is marked for you to raise with your manager.

✓ KEY FEATURES:
• A phone form for each shift, logged in-the-moment from the restaurant
• Net tips after tip-out, and the hourly rate that really came home with you
• Tip-out marked as cash or payroll, so nothing is subtracted twice
• A pay-stub comparison for every pay period, with mismatches flagged
• A shift-type breakdown (Lunch, Dinner, Double, Other) with average $/hour for each
• A Dashboard with the last 7 days, the month and the year side by side
• Qualified-tips cap check: this year's net tips against the $25,000 limit, and what's left
• Cash tips not reported to your employer, totaled for Form 4137
• Correct any entry directly in the Tip Log — totals update on their own
• Past years stay put; switch the year on the Dashboard to review one
• Runs on phone, tablet or laptop with a free Google account

✓ WHAT YOU GET:
• Your Server Tip Ledger for Google Sheets — your private access link arrives in your instant download
• Setup instruction PDF — delivered with your Etsy download
• A mobile-friendly "Log a Shift" form (opens in any browser, no app required)
• Email tips sequence: short setup guides delivered after you complete setup

✓ HOW IT WORKS:
1. Buy it — your instruction PDF downloads from Etsy immediately
2. Follow the link in the PDF and Make a Copy of your Tip Ledger
3. Save the Log a Shift form to your home screen; log before you clock out

✓ MADE FOR:
• Servers, waitresses and waiters in diners, bistros, steakhouses and banquet halls
• Anyone splitting tips with bussers and the bar who wants an honest take-home number
• Servers who want the shift-by-shift record the qualified-tips deduction relies on

Instruction PDF ready the moment you check out.

Your Server Tip Ledger keeps the record; it does not file, claim or calculate your taxes. The qualified-tips deduction applies to tax years 2025 through 2028, up to $25,000 a year, for tips in an occupation on the IRS list of tipped occupations, and phases out above $150,000 of modified adjusted gross income ($300,000 filing jointly). Only tips reported on a W-2, a 1099 or Form 4137 count. I'm not a tax professional and nothing here is tax advice — confirm your situation with one.

The spreadsheet system, formulas, and tax categories are my own original design; AI tools assisted with the decorative illustrations.

Made-to-order download

Files will be available after the seller completes your order.  Here's how.

Made-to-order digital items don’t accept returns or exchanges. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more

Explore related searches

Tip Log Template

Bartender Tip Tracker

Tip Log

Listed on Oct 2, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates