Operations Dashboard

A working surface for CRM, jobs, schedule, billing, callbacks, import readiness, and Cyclone handoffs.

Demo business May 13, 2026
Prototype data is synthetic and masked. No import is running. Review trigger: manual only

Jobs Today

14

9 scheduled, 3 active, 2 ready to invoice

Open Work Orders

38

11 unscheduled, 6 awaiting confirmation

Month Revenue

$84.2k

Imported history plus new cloud work

Receivables

$19.8k

6 invoices over 30 days

Callbacks Due

27

Retention, quality, and reminder queue

Daily Command Center

The first login screen should show work that needs an office decision.

6 decisions
Quote8
Q-1190
Aster Home Care - review line items
Q-1194
Prospect from Sales Funnel
Work Order38
WO-2418
Route North - callback visit
WO-2426
Commercial crew assignment
Schedule11
Need route
3 jobs without drive window
Need confirmation
6 customers not confirmed
Invoice7
WO-2430
Completed, generate invoice
Tax check
5 imported totals need review
Review12
INV-3184
Paid, consent status unknown
Manual only
No automatic sends in MVP

Operating Health

Decision-grade dashboard signals, not marketing widgets.

Dispatch load82%
Quote follow-up61%
Billing review48%
PII guardrails94%
Import mapping58%

Review Funnel Readiness

Manual trigger first.

EligiblePaid invoices can expose a disabled review request action.
CheckConsent, suppression, and product entitlement must pass first.
ReturnReview outcomes come back to customer and job timelines.

Sales Funnel Intake

Accepted proposal becomes quote first.

LeadSales Funnel captures prospect and proposed work.
QuoteMistral creates or links customer, then drafts a quote.
OpsOffice schedules, completes, invoices, then can trigger Review Funnel.

Import Status

Safe visual state.

ProfileNo-PII profiler slice is represented as complete.
NextMapping and reconciliation need approval before deeper diagnostics.
CommitCloud writes stay disabled until explicit approval.

Customer CRM

Operational customer truth stays in Mistral. Click any customer to view details.

0 records
Customer Type Route Last service Balance Status

Document Lifecycle Board

A modern workflow around Mistral 2000 quote, work order, and invoice concepts.

Documents

Click a document to inspect lines, status, and handoff eligibility.

0 records
Document Customer Status Service Date Total

Schedule / Dispatch Board

Drag any job between crews and time slots to reschedule. Imported and cloud blocks share one board.

Day view Drag a job to reschedule

Unscheduled

11

Need route, duration, or crew.

Crew Capacity

82%

Visual only, no optimization running.

Confirmed

71%

Remaining jobs need office confirmation.

Imported Blocks

Mixed

Old and new schedule records share one board.

Quotes, Invoices, Payments, And Receivables

Manual payment tracking first. Online payments can come later.

Open Quotes

8

Sales handoff lands here first.

Work Orders

38

Ready for schedule or completion.

Paid

$64.4k

Month to date.

Aging

$19.8k

6 invoices over 30 days.

Reconcile

5

Imported totals need review.

Billing Worklist

Dummy documents, but realistic operational states.

Document Customer Status Issue Total Action
INV-3184Northstar BakeryPaidReview eligible, consent unknown$1,840.00
INV-3188Cedar Ridge Condo BoardOverdue42 days aging$4,260.00
Q-1190Aster Home CareQuoteWaiting on acceptance$2,430.00
WO-2426Harborview DentalScheduledComplete before invoice$980.00

Callback And Retention Queue

Mistral 2000 callback history stays useful in the cloud workflow.

Due And Upcoming

No customer phone or private notes are shown.

Due Customer Reason Source Status Action
TodayMaple Finch ResidenceSeasonal service reminderImported callbackDue
TodayNorthstar BakeryQuality check after paid invoiceCloud invoiceReview eligible
May 15Aster Home CareQuote follow-upSales handoffScheduled
OverdueCedar Ridge Condo BoardReceivable follow-upInvoice agingOverdue

Reports

Reports prove trust after migration: counts, totals, receivables, history, and callbacks.

Financial

  • Sales by date rangeMVP
  • Receivables agingMVP
  • Tax summaryValidate
  • Payment method summaryManual first

Operations

  • Customer listMVP
  • Service historyMVP
  • Employee job activityMVP-lite
  • Callback reportMVP

Import Audit

  • Source table countsNo PII
  • Money reconciliationNext
  • Orphan and duplicate warningsNext
  • Legacy field coverageNo PII

Migration Center

Access 97 MDB plus companion files, with private diagnostics kept out of docs and screenshots.

No import running
No private customer names, addresses, phones, notes, or raw rows are shown.Commit disabled
1
Package intake
Full company data folder, not MDB alone.
Planned
2
Read-only profile
Tables, fields, counts, config, templates, reports.
Safe slice
3
Mapping review
Customers, sites, documents, payments, schedule, callbacks, settings.
Next
4
Dry-run reconciliation
Counts and financial totals must reconcile before commit.
Requires approval
5
Commit import
Cloud writes only after explicit approval and privacy checks.
Disabled

Database Objects Required

Mistral tables are scoped by shared business_id.

  • mistral_import_batches, files, raw rows, legacy ID mapimport
  • mistral_customers, sites, shared contact linksCRM
  • mistral_jobs, job lines, document lifecycle, employee allocationswork
  • mistral_payments, callbacks, schedule blocksops
  • mistral_services, categories, settings, templates, reportssetup
  • product events, external references, contact interactionsCyclone

Settings

Legacy settings initialize cloud defaults. Admins can modernize after import.

Services

  • Residential serviceActive
  • Commercial serviceActive
  • Maintenance add-onTaxable
  • Legacy custom lineMap

Employees And Routes

  • Crew AlphaRoute North
  • Crew BravoCommercial
  • Crew GammaRoute West
  • Imported inactive staffNo login

Business Defaults

  • Workday08:00-17:00
  • Tax profileImported + editable
  • Review triggerOff by default
  • Document numberingContinue sequence

Setup Checklist

First safe setup steps before engineering implementation.

1. Business shell
Create Cyclone business and product entitlement.
2. Import profile
Run local read-only profile and privacy lint.
3. Settings map
Confirm tax, numbering, templates, and workday defaults.
4. Reconcile
Validate counts and totals before commit.

Shared Account Model

Do not create a separate Mistral account universe.

  • accountsbilling owner
  • businessestenant boundary
  • business usersroles
  • product subscriptionsentitlements

Review Funnel

Manual, consent-checked trigger first.

SourceMistral invoice paid or completed.
CheckEntitlement, consent, suppression, and business setting.
ResultReview outcome appears in customer timeline.

Sales Funnel

Accepted proposal becomes quote first.

LeadShared contact and proposed work.
QuoteMistral creates quote, site, and origin metadata.
OpsOffice converts, schedules, invoices, and follows up.

Event Boundary

Products communicate through events and APIs, not internal table mutations.

Event Producer Consumer Guardrail
quote.acceptedSales FunnelMistral CloudPlatform IDs first, legacy IDs as metadata only.
invoice.paidMistral CloudReview FunnelConsent and entitlement required before any send.
review.completedReview FunnelMistral CloudTimeline event, not direct operational mutation.
callback.createdMistral CloudShared timelineAppend-only event scoped by business_id.
Prototype-only control. No data changed.