Bartender Tip Ledger | Cash, Card, Tip-Out Log (Google Sheets)

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.

Behind the bar, the night moves fast — the record of it shouldn't slip.

Close out, open the form on your phone, and log the shift before you leave the building: hours, cash from the well, card tips off the batch, and what you tipped out to barbacks and food runners — handed over in cash or taken through payroll. Your Bartender Tip Ledger turns every shift into net tips and a real hourly rate, then rolls them into week, month and year totals — so you always know what a Friday double is actually worth.

Then it checks the paycheck. Type in the card tips your pay stub shows for the period, and the sheet lines them up against the card tips you logged behind the bar on those dates, less any tip-out payroll already took. A period that comes up short gets flagged, so a tip-pool or payroll slip is caught on the next payday instead of never.

✓ KEY FEATURES:
• Net tips per shift: cash + card − tip-out, worked out the moment you log it
• Tip-out paid in cash or through payroll — each one counted once, never twice
• Pay Stub Check: each paycheck's card tips against your own shift record, with any period that doesn't match flagged
• Your true $/hour, per shift and for the year
• Tips by shift type (Lunch, Dinner, Double, Other) — see which shifts pay best per hour
• Last 7 days, this month and year-to-date totals on one Dashboard
• Year-to-date net tips against the $25,000 qualified-tips deduction cap, with the room left
• An unreported cash tips total — the figure Form 4137 asks for — kept shift by shift
• Fix any shift later right in the Tip Log; everything recalculates
• Every past year kept — pick any year on the Dashboard
• Works on any device with a free Google account

✓ WHAT YOU GET:
• Your Bartender 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. Purchase — download your instruction PDF from Etsy right after checkout
2. Open your Tip Ledger (link in the PDF) and click Make a Copy into your Drive
3. Bookmark the Log a Shift form on your phone and log each shift in-the-moment

✓ MADE FOR:
• Bartenders at restaurants, hotel bars, breweries, clubs and event venues
• Anyone in a tip pool, or tipping out barbacks, who wants their real take-home on record
• Bartenders keeping the record the qualified-tips deduction and Form 4137 rely on

Your instruction PDF is available immediately after purchase.

Your Bartender 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.