Frankie — Electrical Operations Intelligence

How the data gets here

① Ingestion — what you already send

💬WhatsApp — crew threads

📱iMessage — supplier texts

📄Supplier invoices — PDF

📗QuickBooks — export

📋Job sheets — paper, photos

⏱Crew time — however you log it

② Frankie — parse & structure

🔎Reads unstructured text & PDFs

🧱Normalizes into canonical records

🗄Writes to BigQuery

🔗Every row keeps its source link

🚩Bad or missing data flagged, not hidden

📈Learns your rates job over job

③ Outcomes — what you get

✓Labor gap per job — bid vs actual

✓Material over-orders caught pre-ship

✓Unbilled change orders surfaced

✓Crew performance, side by side

✓One-page report, every Friday

✓Real-time alerts before it costs you

Nothing new to install. No new logins. Your crew keeps texting exactly the way they text today — Frankie reads it.

This month

Found this month

$5,896

Surfaced by Frankie

Labor gap

$2,340

Actual hours over bid

Material flags

$1,416

Over-orders + off-estimate

Unbilled items

$1,840

Change orders not invoiced

Invoice aging

18 days

Avg. days to invoice

Jobs — actual vs bid

Hours: actual vs bid — by job type

Panel upgrade — 200A−20%

Service call — residential+3%

Rough-in — new construction−11%

Lighting retrofit — commercial−17%

Troubleshoot / repair+1%

EV charger install−8%

Your last 4 panel upgrades averaged 19.2 hours. You're bidding 16. That's the gap.

Jobs — status today

Job	Crew	Status
Panel upgrade · Heights	Marcus + 1	Over bid
Retrofit · Midtown office	Crew B	At risk
Rough-in · Katy build	Crew A	Permit hold
Service · Bellaire	Solo	On bid
EV install · Sugar Land	Crew B	On bid
Repair · Galleria	Solo	Not invoiced

What Frankie caught — and where it came from

Finding	Source	What Frankie saw	Impact	Status
Bid below actual	📗 QuickBooks + job sheets	Last 4 panel upgrades averaged 19.2 hrs. This quote assumes 16.	$570–$950	Leak
Material over-order	💬 WhatsApp order thread	200 ft conduit ordered — job scope calls for 140 ft.	$84	Leak
Verbal PO drift	📄 Graybar invoice PDF	3 items on the invoice never appeared on the estimate.	$146	Leak
Short delivery	📱 Crew text + delivery slip	2 of 5 line items missing. Second supply run likely.	$190	Risk
Permit standby	📋 Permit log	Rough-in inspection not scheduled. Avg delay when unbooked: 3.2 days.	$300	Risk
Unbilled change order	💬 WhatsApp — site photo + "add 2 circuits"	Agreed on site. Never reached the invoice.	$1,100	Leak
Inventory already owned	🗄 Prior job material actuals	Ordered 3 breakers already sitting from the Katy job.	$212	Leak
Missing supplier invoice	⚠️ No source found	PO referenced in a text — no matching invoice in the system.	Unknown	Flagged, not hidden

The last row is the point. When the data isn't there, Frankie says so — it doesn't quietly guess a number and roll it into a total.

Crew & decisions

Crew performance — hours vs bid, 4-week avg

Crew A

Rough-in, new construction

+2%

Crew B

Retrofit, commercial

−14%

Solo — service calls

Residential, troubleshoot

+4%

Gap, A vs B

Per week, at your billing rate

$627

You've never had the number to have that conversation. Now you do — and so does Crew B.

Decisions log

ID	Finding	Recommendation	Decision
DEC-0031	Panel bid	Add 3-hr buffer clause	Pending
DEC-0028	Change order	Invoice the 2 circuits	Approved
DEC-0024	Conduit order	Cut to 140 ft	Approved
DEC-0021	Crew B pacing	Review Friday	Modified
DEC-0019	Breaker order	Freeze — already in stock	Approved

Frankie recommends. You decide. Nothing moves money on its own.

The Friday report

Your week — one page

Friday · Sample Electrical Co. · Houston, TX

Frankie

Labor gap — before the GC call

Midtown retrofit is tracking 14% over bid. Catch it now, not at invoice.

$475

Material over-order — stopped repeating

Same conduit over-order showed up on 3 jobs. Corrected at the order stage.

$940/mo

Recovered on invoice night

Two change orders agreed on site, never billed. From data — not memory.

$1,100

Crew performance gap

Crew B running 14% over bid on retrofits. Worth $627/week.

$627/wk

Inventory already owned

Breakers ordered that were already sitting from the Katy job.

$212

Two decisions before Monday

Invoice the Galleria change orders — $1,100 sitting there.
Add a 3-hour buffer to the panel-upgrade template before the next bid goes out.

Found this month$5,896

Every number, traced

Trust contract — source → transform → result

Source

WhatsApp: "add 2 circuits"

→

Transform

Matched to job, priced at your rate

→

Result

$1,100 unbilled — defensible

→

Bad input

Missing invoice — flagged, not hidden

Tap any figure in your live account and it opens the text, the photo, or the invoice it came from. You can defend every number in front of a GC.