Skip to content
Workflow · Finance close · Opening soon

Restaurant tip pool

Export the week's tip shifts and timesheet data from Toast. Then standardize the shifts, prepare the front of house hours, bring in the tips, and share them by hours worked.

Early access opens shortly. Check back soon.

Someone typed

“split the week's pooled tips among front of house staff by hours worked, and show each person's share”

The agent read it as

Split the week's pooled tips from Toast tips by shift among front of house staff in Toast timesheet by hours worked, and show each person's share.

What the agent built

4 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Toast tips by shift
    CSV export · 14 rows
  2. File
    Toast timesheet
    CSV export · 43 rows
  3. Step
    Standardize tip shifts
    Step 1
  4. Step
    Prepare front of house shifts
    Step 2
  5. Join
    Bring in shift tips
    37 of 37 paired
  6. Step
    Share tips by hours
    Step 4
  7. Result
    Weekly Tip Shares
    5 rows
  8. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 5 rows came out, and the join paired 37 of 37 rows.

What you get back

The result of that run, the rows to look at first.

Weekly Tip SharesSample data5 rows
EmployeeTip shareHours worked
Ava Chen636.6644.50
Ben Ortiz422.3631.75
Chloe Park384.7429
Diego Ruiz1,082.0338.50
Emma Foster1,035.2137
5 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Weekly Tip Shares workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Weekly Tip Shares: questions

How do you split a tip pool by hours worked?
Export the week's tip shifts and timesheet data from Toast. Then standardize the shifts, prepare the front of house hours, bring in the tips, and share them by hours worked. You get each person's tip share at the end.
What file should you export first?
Export the tip data and the timesheet data from Toast for the same week. Use the files that list shifts, hours, and staff names.
What happens if a row does not match?
Rows that do not match stay out of the split until you fix them. You can check the names, dates, or shift details and run the workflow again.
How do you change the split rules?
You change the rules in words, like how to group shifts, which staff to include, or how to divide tips by hours worked. Then you run the updated workflow again.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →