Revenue
—
total in range
Cars Washed
—
—
Recurring Revenue
—
actual recurring revenue collected in range (from the Daily Financial Report)
New Memberships
—
sold in range
Member Cars Redeemed
—
monthly plan redemptions
Retail Cars & Conversion
—
—
Membership
—
active members
All Sites
| Site | Status | Revenue | Cars | Avg Ticket | Recurring | New Members | Member Cars | Rewash | Retail Cars | Conversion | Days |
|---|
Import Verification
Daily reports (Financial, Family Membership, Membership Data, Cancellations) should be imported every day. Employee Info and Labor Hours are weekly, due every Monday.
Daily Reports — Last 7 Days
| Date | Financial | Family Membership | Membership Data | Cancellations |
|---|
Weekly Reports — This Week
| Report | Status | Detail |
|---|
or drag and drop .xlsx file(s) here
Financial reports: you can select multiple files at once (one per site) — hold Ctrl (or Cmd) while choosing files, or drop them all in together.
Data Coverage
What dates/weeks are currently imported for each report type.
Family Plan Pricing
The TRUE full (non-discounted) price for each family plan -- the Family Plans page compares every member's actual price against this to decide who's discounted. Editable inline, saved as you go. A blank price here means members on that plan can't be classified as discounted or full-price yet.
| Plan Name | Tier | Members (latest snapshot) | Full Price |
|---|
Site Names & Locations
Friendly names per site, and mapping the raw location text from payroll/Labor data to real site codes. Both editable inline, saved as you go.
Site Names
| Site Code | Name |
|---|
Work Location Mapping
Every car wash "Work Location" value found on the employee roster (dealerships and laundromats excluded) -- map each to the real site it belongs to.
| Work Location (from payroll) | Mapped Site |
|---|
Manage Users
| Username | Display Name | Role | Sites | Status | Last Login | Actions |
|---|
Labor
| Site | Employees | Hours |
|---|
| Employee | Site | Classification | Hours |
|---|
Classification Review
| Employee | Site | Current | Avg weekly hours | Weeks of data | Suggested | Flag |
|---|
Scheduled vs Actual
Site is taken entirely from the Schedule, never from the Labor report's own location field -- see Needs Review below for hours that couldn't be matched to a schedule. Click a site row for a day-by-day breakdown.
| Site | Employees | Scheduled Hrs | Actual Hrs | Variance | Variance % |
|---|
Daily Detail
| Date | Employees | Scheduled Hrs | Actual Hrs | Variance | Variance % |
|---|
Needs Review
Actual hours with no matching Schedule entry for that date -- assign a site manually. Only applies to this specific date, not future weeks.| Employee | Date | Hours | Assign Site |
|---|
Total Cancellations
—
in selected range
Top Reason
—
Top Site
—
Most Cancellations Processed
—
Cancellations Over Time
Per-Site Breakdown
| Site | Cancellations |
|---|
Employee Ranking
Excludes system/automated processing (see below)| Employee | Cancellations Processed |
|---|
System / Automated
Integration Admin, LWReports, etc. -- e.g. auto-cancelled 60-day free membershipsCancellation Detail
| Date | Name | Barcode | Site | Reason | Processed By |
|---|
Total Active Members
—
Recurring Members
—
Non-Recurring (Comps)
—
Projected MRR
—
projected -- not actual collected
Avg Projected Per Member
—
Snapshots In Range
—
Active Members By Tier
By Site
| Site | Total | Recurring | Non-Rec | Silver | Gold | Platinum | Diamond | Projected MRR |
|---|
New Memberships
—
sold in range
Member Cars Redeemed
—
monthly plan redemptions
Recurring Revenue
—
actual recurring revenue collected in range (from the Daily Financial Report)
Days With Data
—
Avg New / Day
—
Avg Redeemed / Day
—
Unlimited Reactivations
—
Non-Recurring Signups
—
New Memberships Sold
Member Cars Redeemed
Recurring Billing Revenue
Tier Breakdown
"Family Sold" is included within "New Sold," not additional to it -- e.g. 300 New Sold with 9 Family Sold means 300 total, 9 of which were family plans.
| Tier | New Sold | Family Sold (of New Sold) | Sales Revenue | Cars Redeemed | Recurring Qty | Recurring Rev |
|---|
By Site
| Site | New Members | Member Cars | Recurring Rev | Top Selling Tier |
|---|
Family Plan Members
—
every customer listed on the report
—
Projected MRR
—
projected -- not actual collected
—
Avg Per Discounted Member
—
Projected MRR ÷ members receiving a discount only
Snapshots Stored
—
Family Plan Members By Tier
Price Breakdown — Network
| Tier | Price | Status | Members | Projected MRR |
|---|
By Site
| Site | Family Plan Members | Discounted | Silver | Gold | Platinum | Diamond | Proj. MRR | Discounted MRR |
|---|
Discounted Vehicles Per Account — Reference
For evaluating plan structure -- how many discounted vehicles are attached to each account.
| Discounted Vehicles On Account | Number Of Accounts |
|---|
Hour Target:
—
Schedule
Promotions Catalog
Create promotions here once, then check them on for whichever sites are currently running them below.