Skip to content
The title slide and first slides of the Tip Income Log template

Tip Income Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 15, 2026

Every slide (5)

Overview

Servers, bartenders, hosts and other tipped workers use this tip income log to keep their own record of what they earned. The Shifts tab records every shift in one row, with hours, cash tips, card tips and tip-outs, and it works out the tips kept and the tips per hour. The Monthly report tab compares what you reported to your employer with the tips you logged. The Dashboard shows tips by month, by shift type and by role.

Write the cash number down at the end of the shift. A tip log kept in the moment is far more accurate than one rebuilt from memory in April. Compare your card tips with your pay stub, and use the Not yet status to catch shifts you have not reported. This sheet is a personal record, so follow your employer's process and check with a tax professional on reporting tips.

Useful for

  • Keep your own record of cash and card tips
  • Find which shifts and roles pay the best per hour
  • Check what you reported against what you earned each month

What's included

  • 4 tabs: Dashboard, Shifts, Monthly report, How to use
  • Dashboard: a dashboard with 6 summary figures
  • Shifts: a table
  • Monthly report: a table
  • 3 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Shifts tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I track tip income?

Add a row after each shift with the date, hours, cash tips, card tips and any tip-out. The sheet adds them up by month, shift and role, and shows tips per hour.

Should I write down tips every day?

Many tipped workers are asked to keep a daily record and to report tips to their employer by a set date each month. Read the latest IRS guidance, or ask your employer how to report them. This log can serve as your own copy.

What is a tip-out?

A tip-out is the share of tips you pay to coworkers such as bussers, hosts or bar staff. Enter it in its own column, and the sheet subtracts it from your cash and card tips to show what you kept.

  • #tax-tracker
  • #tip-income-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…