TipSplit: Tip-Pool Calculator & Payout Sheet
TipSplit: Tip-Pool Calculator & Payout Sheet ships as a ready-to-import n8n automation package: load the bundled workflow JSON, connect the credentials listed on this page, and activate it on self-hosted n8n or n8n Cloud.
Turn a week of shifts into an auditable tip-pool payout: role-based percentages calculated to the cent, a per-employee audit row in your sheet, and a breakdown emailed to payroll.
- Calculate role-based tip pools to the cent — percentages, tip-out rates and weighted hours, all from one sheet
- Prove every payout with a per-employee audit row appended to your Payouts tab each pay period
- Catch tip-law mistakes before payday: percentages that miss 100, duplicate roles and unknown job titles block the run
- Email payroll a breakdown staff can read — what each person paid in, kept, and earned back
- Split remainders with the largest-remainder method so pennies are never created or lost
- Skip nobody quietly: out-of-period rows, bad dates and under-hours staff are counted and reported
- Never double-pay a period — the run is deduped and only marked paid after the email actually sends
Setup Service — optional live install and test. Choose your tier at checkout (not tied to this template's price).
Paste the license key from your receipt. It must match this template.
Workflow summary
One workflow handles everything end-to-end.
- 1Runs every payday on a schedule in your timezone, or on demand via a webhook for previews and re-runs
- 2Reads the role rules and the pay period's shifts from the Google Sheet your POS exports into
- 3Pools the tips from contributing roles and splits them by each role's percentage, then by hours, equally, or by what each person collected
- 4Blocks the payout and lists the problems instead when rules are broken, a role is missing, or a manager is taking a share
- 5Appends one audit row per employee to the Payouts tab so every number can be reproduced later
- 6Emails payroll the payout sheet showing each employee's hours, tips, payout, tip-out, and the exact formula used
- 7Marks the period paid only after the email succeeds, so the same period can never be paid twice
What's included with your purchase
Every checkout includes the same practical package so you are never hunting for missing files mid-setup.
- 01Workflow JSON exports ready to import into your n8n workspace (self-hosted or n8n Cloud).
- 02Step-by-step guide that walks credential creation, node-by-node checks, and activation.
- 03Credential checklist for Google Sheets, SMTP. Email support@n8ntemplatestore.com if you get stuck — replies within 24 hours (SLA).
- 04Perpetual (lifetime) use license Your one-time purchase includes an ongoing right to use this template package on n8n instances you control for your own automation — not for resale or public redistribution of the files as a product. Terms & conditions.
- 05We keep the copyright Workflow JSON, guides, screenshots, and bundled assets stay our copyrighted works (or our licensors'). Payment grants the limited license in our Terms only — it does not transfer ownership.
Need a second opinion before buying? Compare the full catalog, browse more Finance templates, see how n8n compares to Zapier and Make, or read the support policies.
Three steps to a running n8n automation
Import the workflow into n8n
Paste your API keys into the credentials panel
Press ‘activate’ — you’ll get your first report tomorrow morning
Need help setting up this n8n template?
Beginner-friendly guidance is included. Our support team will help you if you get stuck — email support@n8ntemplatestore.com or visit support.
About this template
How long does it take to set up TipSplit: Tip-Pool Calculator & Payout Sheet?
What if I get stuck?
Do I need to pay for Google Sheets?
Can I customize the workflow?
What if it doesn’t work for me?
Related n8n workflow templates
BillingBridge: Stripe Invoice → CRM Sync
Pre-built n8n workflow template that automates finance with Stripe. Live in about 10 minutes.
InvoiceAudit: Vendor Price-Creep Watchdog
Pre-built n8n workflow template that automates finance with Gmail. Live in about 10 minutes.
UpdateDeck: Monthly Investor Update Autopilot
Pre-built n8n workflow template that automates finance with Stripe. Live in about 10 minutes.