A free tip tracker spreadsheet template

The template

Paste this header row into row 1 of a new sheet. Put one shift per row beneath it, oldest at the top.

• date · job · start_time · duration_hours · wage_hourly · cash_tips · card_tips · tip_out · net_tips · wage_earnings · total_earnings · effective_hourly · sales · section · note · currency · timezone. These are exactly the columns Tillside exports, in the same order, so the two files line up.
• Row 2 formulas, with the columns above in A to Q: I2 = F2 + G2 − H2 (net tips), J2 = E2 × D2 (wage earnings), K2 = I2 + J2 (total), L2 = IF(D2 > 0, K2 / D2, "") (rate). Fill down. Leave start_time, section, note, currency and timezone blank if you do not need them.
• Weekly totals: =SUMIFS(K:K, A:A, ">=" & start, A:A, "<=" & end) for earnings and the same with D:D for hours; divide one by the other for the week's rate. Do not average column L.

Download the CSV

The same layout as a CSV file, with the header and two example rows, is at tillside-tip-tracker-template.csv. Open it in Sheets, Numbers or Excel and add the formulas from above. It uses the columns Tillside exports, so if you switch later the two files line up.

Rules that keep the sheet honest

• Enter tips before tip-out, and tip-out as its own amount. Net tips is a formula, never typed.
• Hours actually worked, to the quarter hour. Scheduled hours overstate your rate.
• One row per shift, even on a double. Two shifts on one day are two rows.
• Add the row the same night. A sheet that is three shifts behind becomes a sheet that is abandoned.

When a spreadsheet stops being worth it

Spreadsheets are good at the maths and bad at the entry. Adding a row on a phone at 1 a.m. means opening the app, finding the bottom, typing a date, and tabbing through ten cells with a keyboard that keeps switching between letters and numbers. That is why most tip spreadsheets have a great first month and a blank second one.

Tillside keeps the same fields and the same three formulas, but the date, start time, hours, wage and tip-out are already filled in from your job and your last shift. A normal night is cash, card, save. When you want the spreadsheet back, Settings then Export gives you a CSV of every shift, free, in exactly the columns above.