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.
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.
File
Toast tips by shift
CSV export · 14 rows
File
Toast timesheet
CSV export · 43 rows
Step
Standardize tip shifts
Step 1
Step
Prepare front of house shifts
Step 2
Join
Bring in shift tips
37 of 37 paired
Step
Share tips by hours
Step 4
Result
Weekly Tip Shares
5 rows
Schedule
Runs when you say
Proposed
- FileToast tips by shiftCSV export · 14 rows
- FileToast timesheetCSV export · 43 rows
- StepStandardize tip shiftsStep 1
- StepPrepare front of house shiftsStep 2
- JoinBring in shift tips37 of 37 paired
- StepShare tips by hoursStep 4
- ResultWeekly Tip Shares5 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 5 rows came out, and the join paired 37 of 37 rows.
- Download Toast tips by shift sample (14 rows)Toast: Tips > Tips by Shift > Export
- Download Toast timesheet sample (43 rows)Toast: Labor > Timesheets > Export
What you get back
The result of that run, the rows to look at first.
Weekly Tip SharesSample data5 rows
| Employee | Tip share | Hours worked |
|---|---|---|
| Ava Chen | 636.66 | 44.50 |
| Ben Ortiz | 422.36 | 31.75 |
| Chloe Park | 384.74 | 29 |
| Diego Ruiz | 1,082.03 | 38.50 |
| Emma Foster | 1,035.21 | 37 |
How it works
How to use the Weekly Tip Shares workflow
- 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.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 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.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent