Curryblossom Ops Dashboard

Vimala’s Curryblossom Cafe Sales & Operations · six SpotOn exports, Aug 2024 – Sep 2026

Compare to

Overview

Every export, one connected picture

This pulls together the Order List, line-item ITEMS export, PAYMENTS, employee timecards, Deposits and BatchList — six separate SpotOn files reconciled against each other. Salaried owners (Travis, Rush, Vimala) are excluded from labor math; terminal/cash-station detail is intentionally left out.

Charts below are clickable — click a bar, cell or point to drill into the detail behind it.

Sales

Trend, down to the hour

Net sales across the selected range. Click a point, then a day within it, for the hour-by-hour and order-type breakdown.

Net sales over time

Click a point on the line to see the breakdown.

Channels & Tips

In-person vs. online ordering

“In-Person” = Dine In, Dine In QR, Carryout. “Online” = Online Pickup, 3rd-Party Delivery, DoorDash Drive.

Sales by channel

Click a bar to see that period's channel split and tip rates

Click a bar to see the numbers behind it.

Tip rate: Dine-In QR vs. server-paid

All-time, from the Payments export — not affected by the date range above

Timing & Traffic

When the cafe gets busy

Average net sales by hour and day of week for the selected range (Sunday excluded — see Data Notes). Darker green = busier; red = slow. Hours outside the cafe's posted hours are dimmed. Click a cell for its top items and order-type mix (all-time pattern).

Average sales by hour & day

Monday–Saturday, 11:30am–8pm (Mon–Wed) / 11:30am–9pm (Thu–Sat) highlighted

Slow

Busy

Click a cell above to see what's actually selling then.

Team & Labor

Staffing cost against sales

Timecards for hourly staff only — Travis, Rush and Vimala (salaried) are excluded from all labor-cost figures. Selvin and Silvia are always prep, regardless of what their SpotOn job title says on any given shift.

Labor cost as % of sales, by week

Click a point for that week's role breakdown — weekly, not monthly, because prep hours run on their own schedule regardless of how sales land across the week

Click a point to see that week's hours, pay and role split.

Hours & pay by role

Hourly staff, selected range

Top earners by pay

Hourly staff, selected range, top 12

Cashflow

What actually hits the bank

Net deposits, processing fees and reserved-funds holds from the Deposits export. Click a month to see the daily batches behind it — no terminal/register breakdown, by design.

Monthly net deposits

Click a month to see the daily batches behind it.

Data Notes

What to trust, what's excluded on purpose

Fixed: corrupted tip values

Sunday is excluded

Salaried owners excluded

Travis, Rush and Vimala are salaried and are left out of every labor-cost, hours and role figure above — those numbers reflect hourly staff only.

No terminal/station breakdown

The BatchList export ties each batch to a card terminal, but that dimension isn’t useful here and is left out entirely — cashflow is shown by day and month only.

Prep role is corrected

Selvin (Ordonez) and Silvia (Franco) are the only prep staff, always — SpotOn's own job field on their shifts hasn't always said so, and old shifts can't be relabeled at the source, so every one of their hours is counted as Prep here regardless of what SpotOn logged.