Tips split and payroll export

AirQR helps you pay staff fairly, using the clock-ins from the time clock. Team → Tips split shares the tips collected in a period by hours worked, and Team → Attendance downloads a Payroll CSV of hours and labour cost for your accountant. Both are reports only: AirQR doesn't pay anyone or move any money. You pay tips and wages the way you do today.

Tips split and payroll are part of staff roster & attendance, included in the Growth plan and above, and in the free trial. Only owners and managers can open them.

How the Tips split page works

Team → Tips split shows, for the current outlet and the chosen period:

• Tips collected: the tips added to payments on bills in the period, and how many payments had a tip.
• Hours in the pool: the hours worked by the people included.
• Per hour: tips per hour worked, before any position weights.

Choose the period at the top: Today, This week, Last week, This month, Last month, or custom From / To dates, then Show. Use the same period you pay tips for.

Hours come from clock-ins, so the split only fills in once staff use the time clock. If nobody clocked in, you'll see "No hours worked in this period". Fix missing or wrong clock-ins on Attendance first (see Time clock and attendance).

Choosing how tips are shared: by hours or by position

Pick the method with the toggle:

• By hours: everyone in the pool gets the same amount per hour worked. Someone who worked 40 hours gets twice the share of someone who worked 20.
• Hours × position weight: each position gets a weight, and a person's share is their hours × the weight. For example waiters 1 and kitchen 0.5 means an hour in the kitchen counts half. A weight of 0 leaves that position out.

A person's position comes from the Position on their roster shift (for example Waiter, Tandoor, Bar). Hours worked without a shift, or on a shift with no position, use the person's role (Waiter, Kitchen and so on). Someone who worked in two positions has hours in both.

Leaving people out of the tip pool

The table lists everyone who worked, with Positions, Hours, Share and Tips. Untick In pool for anyone who isn't part of the tip pool. Their share goes to everyone else.

Owners are left out by default; tick them in if they share tips. The shares always add up exactly to the tips collected, to the paisa.

Downloading the tips CSV

Tap CSV to download the split for your records. It includes the period, the method (and the position weights, if used), each person's positions, hours, weighted hours, share %, tip amount and whether they were in the pool. Pay the amounts out as usual (cash, UPI or with wages), then keep the CSV.

Tips collected on bills are held in the Tips Payable ledger in the Tally export until paid out (see Tally Prime export).

Downloading the payroll CSV from Attendance

1. Go to Team → Attendance and choose the period, for example Last month.
2. Clear every entry marked Forgot to clock out or needing a check first, so hours are right.
3. Review late arrivals, absences and overtime with each person.
4. Tap Payroll CSV.

The payroll CSV has one row per clock-in (date, staff, position, clock in, clock out, break, hours, late minutes, overtime, hourly rate, cost, how it was recorded, flags and note) and a totals row per person (scheduled hours, shifts, hours, late count, overtime, cost and absences). Send it to your accountant or payroll provider.

Costs need an hourly rate for each person: Staff → ⋯ → Time clock PIN & pay rate → Hourly rate. Only owners and managers see rates.

Common questions about tips and payroll

• Does AirQR pay staff or transfer tips? No. Both pages are reports to help you pay out fairly.
• Tips collected looks too low. Only tips recorded on payments at this outlet in the period count. Tips given in cash outside a bill aren't in AirQR.
• Someone is missing from the tips list. They have no clock-ins in the period. Add their entry on Attendance, with a note.
• Hours in the payroll CSV are zero for a day. An entry open for more than 16 hours counts as 0 until a manager fixes it.
• Cost column is empty. Set the person's hourly rate on the Staff page.