🧊 Cube Make

Scenarios Resources
← Back to Scenarios

✅ 2026 Staff End of Day Sales Report 1/2- Payroll

⚠️ Needs ID 10 modules

Settings

Flow (click modules to expand)

gateway Admin Logout Gravity Form
⚡ Admin Logout Gravity...
#1
▶
util time diff #48
name: time diff
scope: roundtrip
value: {{if(parseNumber(1.break_minutes; ) > 0; "aaa"; 0)}}
▶
util time diff #53
name: time diff
scope: roundtrip
value: {{if(parseNumber(1.break_minutes; ) > 0; (parseNumber(1.break_minutes) / 60); 0)}}
▶
util Set Variables #49
scope: roundtrip
variables:
builtin Basic Router #4 5 routes
route Branch 1
▶
xero Create Bank Transfer #3
Date: {{formatDate(1.`__submission`.updated_at; "YYYY-MM-DD")}}
Amount: {{1.`__submission`.user_inputs.cash_withdrawn}}
tenantId: e71d044c-d576-4a92-87c3-82208e0465ae
ToBankAccount: 28e2e7c2-8e69-4c47-9c5c-3d1d80f77dc3
FromBankAccount: e409778d-482f-4e20-8d9a-719b351f0226
route Branch 2
▶
xero Create Bank Transfer #6
Date: {{formatDate(1.`__submission`.updated_at; "YYYY-MM-DD")}}
Amount: {{1.`__submission`.user_inputs.cash_withdrawn}}
tenantId: e71d044c-d576-4a92-87c3-82208e0465ae
ToBankAccount: 28e2e7c2-8e69-4c47-9c5c-3d1d80f77dc3
FromBankAccount: 8f6c4f90-1c4e-4868-8284-93bf2b874f5c
route Branch 3
▶
google-sheets Sheet: To Process
✏️ To Process
#13
from: drive
mode: select
values:
1:{{1.names.first_name}}
2:{{formatDate(1.shift_datetime_end; "DD MMM YYYY")}}
3:{{1.shift_datetime_start}}
4:{{1.shift_datetime_end}}
5:{{1.`__submission`.user_inputs.Store}}
6:{{1.break_minutes}}
7:{{49.break_total_decimal}}
8:{{49.break_total_decimal_minus20}}
9:{{49.decimal_shifttime_end - 49.decimal_shifttime_start}}
10:{{49.decimal_shifttime_end - 49.decimal_shifttime_start - 49.break_total_decimal_minus20}}
13:{{1.`Assist Cuber`}}
14:{{1.`Assist Start Time`}}
15:{{1.`Assist End Time`}}
sheetId: To Process
spreadsheetId: /1VdJitf1JQuD--Nlb-7bElOFOHOIj8xDz/1FKSoVice4jsKxFCfhg7Pjth9PLflgELTXRQq3juz_TY
includesHeaders: true
insertDataOption: INSERT_ROWS
valueInputOption: USER_ENTERED
insertUnformatted: false
route Branch 4
▶
clickup send AChat Message #44
type: message
content: Daily Report for {{1.Store}} Team Member: {{1.names.first_name}} Start Time: {{1.shift_datetime_start}} End Time: {{1.shift_datetime_end}} Breaks: {{1.`__submission`.user_inputs.break_minutes}} {{1.Notesfortheday}}
team_id: 9003069646
channel_id: 8c9zw6e-26976
map_or_select: select
content_format: text/plain
route Branch 5
▶
clickup send AChat Message #45
type: message
content: Daily Report for {{1.Store}} Team Member: {{1.names.first_name}} Start Time: {{1.shift_datetime_start}} End Time: {{1.shift_datetime_end}} Breaks: {{1.`__submission`.user_inputs.break_minutes}} {{1.Notesfortheday}} Foot Traffic: {{1.`__submission`.user_inputs.foottraffic}} Day Totals Total Transactions: {{round(1.totaltransactions)}} Total Sales: ${{1.totalsales}}
team_id: 9003069646
channel_id: 8c9zw6e-26976
map_or_select: select
assign_message: user
content_format: text/plain