Automated Tattoo Commission Report
Every Monday, WebRun opens Square Appointments, collects all completed transactions from the prior week, applies each artist's commission rate or booth-fee structure, writes a detailed breakdown to Google Sheets, and posts a summary to Slack so the studio owner can review before processing pay.
How do I automatically calculate tattoo artist commissions and booth fees each week?
WebRun pulls all completed Square Appointments transactions for the prior week every Monday, applies each artist's commission rate or booth-fee structure, and writes a detailed per-artist breakdown to Google Sheets. A Slack summary gives the studio owner the key figures for review before any payment is processed.
- The studio owner has a ready-to-review commission report in Google Sheets every Monday morning
- Each artist's payout is calculated accurately using their individual rate or booth-fee structure
- Significant week-on-week variances are flagged before payroll is processed
Built for tattoo studio owners · studio managers · multi-artist tattoo shops · tattoo booth renters
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
squareup.com/appointmentsin a real browser with your saved login - no setup, no API keys. -
1
Square Appointments - pull last week's transactions
squareup.com
WebRun opens Square Appointments to pull last week's transactions. - Open Square Appointments and filter for all appointments marked as completed in the previous seven days
- For each completed session, record the artist name, service type, transaction amount, and any tips
- Group transactions by artist and calculate the gross revenue each artist generated for the week
Done when All last-week transactions are collected and grouped by artist with gross revenue totals.
-
2
Google Sheets - write commission breakdown
google.com
WebRun opens Google Sheets to write commission breakdown. - Open the commission-tracking sheet in Google Sheets
- For each artist, apply the agreed commission rate or booth-fee amount from the rates tab to calculate net earnings or fees owed
- Write a new weekly row for each artist showing sessions, gross revenue, commission or booth-fee amount, and net payout
- Add a summary row with studio-wide totals for the week
Done when The Google Sheet has a complete weekly breakdown for every artist with commission and payout figures.
-
3
Slack - post weekly summary for review
slack.com
WebRun opens Slack to post weekly summary for review. - Post a Slack summary to the studio owner listing each artist's session count, gross revenue, and calculated payout for the week
- Include a link to the detailed Google Sheet for review
- Flag any artist whose figures differ significantly from their prior-week average so the owner can verify before processing payment
Done when The studio owner has a Slack summary and a link to the detailed commission sheet ready for payroll review.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it pay artists directly or process any transactions?
No. WebRun calculates and records the commission figures in Google Sheets and posts a summary to Slack. All payments are made separately by the studio owner after reviewing and approving the report.
Can it handle different commission rates or booth-fee structures for different artists?
Yes. Add each artist's rate or booth-fee amount to a rates tab in the Google Sheet and WebRun will apply the correct structure for each person when it calculates the weekly breakdown.
What if a transaction is voided or refunded after the report runs?
The report reflects Square's data at the time of Monday's run. Any refunds or voids processed during the week will appear as adjustments in the following Monday's report, with a note indicating the change.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.