Financials wired straight to QuickBooks
An executive summary and a trailing-twelve-month P&L pulled directly from QBO, generating themselves overnight on the first of each month, with a banner so nobody mistakes a partial month for a closed one.
Enhance Aesthetics & Wellness/Medical Spa/Yuma, Arizona/2026
.
Building the operating system for a real medical spa.
AI AutomationSoftware DevelopmentBusiness Consulting
Live in productiondashboard-enhance-med.vercel.app ↗
dashboard-enhance-med.vercel.app
Executive Summary
Enhance Aesthetics & Wellness · Yuma AZ
May 2026
Aesthetics
$5,599
43%
Wellness
$7,275
55%
Total rev
$13,124
MRR
$13.9K
Members
88
Revenue by business unit
Aesthetics · Services$5,599
Wellness · BHRT · MMWL · Vitamins$7,275
Total MRR
$13.9K
Active members
88
New clients
1
The live command center · dashboard-enhance-med.vercel.app
Prologue
The problem on Marina's desk
Marina runs a medspa in Yuma, Arizona. She injects neurotoxin in the morning, signs off on hormone therapy in the afternoon, and used to spend most evenings reconciling spreadsheets.
Five sources of truth: QuickBooks for the books, Stripe for the terminal, RepeatMD for memberships, Jane for bookings, GoHighLevel for marketing. None of them talked to each other. By the time a month closed, the numbers were already a week stale, and "how did April actually go?" took two days to assemble.
This is the system that replaced all of it: twelve workflows quietly pulling, normalising and posting the spa's data every night into one dashboard that tells the truth fast enough to act on.
What shipped
Nineteen KPIs and per-SKU margins
Financial, operational and marketing KPIs recomputed nightly, plus a per-SKU margin view joined from Jane against the cost table, color-coded against thresholds Marina set herself.
Memberships, cash and CRM in one place
RepeatMD MRR charted live, a thirty-day cash forecast, and 1,683 GoHighLevel contacts whose pipeline instantly showed the bottleneck was conversion, not lead-gen.
A month that closes from a phone
Invoice Preview runs the close routine, builds a draft set of invoices and posts them to QBO. The process is idempotent, dry-run guarded, and fully audited. Marina now closes the month from her phone.
How it’s wired
Each tool writes into its own staging path, gets normalised, and lands in one canonical schema, so everything reads from a single, trustworthy source.
01 · Your tools
Sources
QuickBooksStripeRepeatMDJaneGoHighLevel
02 · Orchestration
n8n
Pulls, normalises, schedules
03 · One source of truth
Supabase
Every record, reconciled
04 · In your hands
Live dashboard
Real-time, always current
Built on
ReactNodeSupabasen8nQBOStripeRepeatMDGHL
Results
5
tools unified into one
19
KPIs tracked nightly
$13.9K
MRR tracked live
Field notes
The parts that were harder than they looked.
The token that broke things silently
Intuit's OAuth flow has separate verifier tokens for the Dev and Prod console tabs. Mixing them breaks HMAC validation silently: webhooks are rejected, with no error and no clear cause. The fix lived in one env variable but cost a week to find.
The bonus pool that had to be exact
The first three drafts of the staff bonus tracker were a few hundred dollars high. Marina caught it in a day; she had computed it by hand for six months. The fix excluded the owner's own revenue and employee-on-employee treatments, with both totals shown in a tooltip.
Surfacing the gap was the product
"272 of 388 items have no unit cost" used to read silently zero. An inner join filtered the missing-cost SKUs out before they were ever counted. Margin math falls apart silently without unit costs. The fix surfaced the gap. The fix was the product.
“It is the operating system for a medical spa, not a reporting tool bolted onto five other reporting tools.”