Do this
Your garage
This month
Inquiries, bookings started & deposits paid
Booking funnel
Top cars — viewed vs booked
Where inquiries come from
Cars out per day
How deposits were paid
Why people dropped off
Promos
At a glance
Inquiries
Settings
Texts
Emails
Timeline
The last 50 texts, emails and alerts, newest firstTexts per day
By text
Sent and failed in the days shown
What’s winning
Texts with two or more versions: the one ahead, its conversion rate against the next best, and how the sends are split
The whole journey
Every text and email, from the first visit to the return — shown for a sample client
The flow at a glance
What goes out at each step, from your switches and timing
How the 3- and 7-day prices are worked out
The starting-at price is the per-day rate for 7+ days — the floor, and what the website shows (“from $1,500/day”). The 3–6 day and 1–2 day prices are worked out up from it, ending in 9. You can still type any price on a car. The percentages are kept on this device for now.
Apply tiers to every car
For every car that has no 3- or 7-day price yet, today’s price becomes its starting-at (7+ days) price and the other two are worked out up from it — no car ends up below today’s price. Cars that already have tiers are left as they are. You see the whole table before anything changes.
| Car | Today | Starting at (7+ days) | 3–6 days | 1–2 days |
|---|
QuickBooks
Google Sheet
Checking…Held back
These rows in the sheet look like a deal that’s already here, so they weren’t added — that way nothing is counted twice. If one really is a different deal, tell Andres.
Cars kept together
Recent syncs
Notes for Andres
How it works
Your Google Sheet copies itself into the portal every 15 minutes (from Andres’s Mac). If you edit a deal here, your version stays — the sheet won’t overwrite it. A deal deleted from the sheet is removed here too.
What to doUnlock the Mac, click OK on the ‘python3 wants to control Messages’ box (or System Settings → Privacy & Security → Automation → python3 → Messages ON), then Settings → Texts → Send test.
Things we need from you
Done
Bookings
People who picked a car and gave their name and phone, but didn’t pay the deposit within 45 minutes. You get a “Client drop off” email for each one.
Sent from the form on the website. Each new one is emailed to you too.
Fleet
Books
The garage
Where the month’s costs go
What the cars pay for
This month vs …
Your advisor
13 months
Which days cars go out
Cars out each day
Clients
Who sends you clients
The last 3 months and this one.
Your cars vs partner cars
How clients paid
Still owed, by age
| VIN / OWNER | VEHICLE | PICK UP | DROP OFF | AMOUNT | DAYS | TL W/TAX | DEPOSIT KEPT | TOLLS | TAXES | NETTolls come off the net here | $/CC | INFO | PHONE NUMBER | MILES OUT | MILES IN | TOTAL MILES | Row |
|---|
| Car | Dates | Days | Gross | Net | Paid via | Client | Owes | Source |
|---|
| Date | For | Amount | Note |
|---|
Recurring charges
Car payments and insurance — each one posts itself as an expense on its day of the month.
Month by month
Cars
Months
| Month | Gross | Net | Days | Expenses | Profit | Owes | Deals |
|---|
How they paid
By type
Open balances
Site bookings
Your cars
Plates, payments and insurance for the cars you own.
| Car | Plate | Plate expires | VIN | Received | On the website | Payment / mo | Insurance / mo | Status |
|---|
Sheet names → cars
How each vehicle name from the Google Sheet is counted. Change one and the next import files those deals under that car.
| Name on the sheet | Counts as |
|---|
| Client | Phone | Deals | Gross | Last deal | Sent by |
|---|
Goal
Money by month
Utilisation per car
Your cars, over the months each was on the road. The dashed line is 70 %, where a car is doing its job; below 50 % it sits more than half the month.
Car cost vs earnings
The cars, read
| Car | Net total | Deals | Days | Busy | Median $/day | Net / month | Payment | Read |
|---|
Working ≥ 65 % busy · Half idle ≥ 48 % · Sits below.
Seasonality
Average net by calendar month, over the full months in the range. The dashed line is break-even.
Weekdays
Pick-ups by day of the week; the busiest day stands out.
Deal length
Clients and repeat business
Top clients by net
| Client | Deals | Net | Last deal |
|---|
Referrals
Referral sources by net
| Who sent them | Deals | Net |
|---|
Only deals where someone was named as sending the client. The true share is higher.
Owes and leaks
Balances still marked as owed
Expenses by kind
How clients paid
Where to focus
Ranked by how much money each one moves, with the number behind it.
Damage Log
Calendar
Links & promos
| Link | Goes to | Clicks 7d | Clicks 30d | People 30d | Leads | Deposits | Revenue | Commission | Partner · code | Status |
|---|
| Code | Discount | Uses | Valid | Cars | Partner | Revenue | Discount given | Status |
|---|
A code takes money off the rental price only — never the $100 reservation deposit or the security deposit. A use counts once the deposit is paid.
| Partner | Phone | Earns | Links · codes | Deals | Net | Owed | Paid |
|---|
A partner earns on every deal from their links or codes once its deposit is paid. Nobody is paid automatically — “Mark paid” records it and files the commission in Books.
Content
One card per post: the idea, the cars it’s about, the photos and clips it uses, Higgsfield requests, the engine’s versions and your feedback.
The engine quotes every request first; nothing is generated until you approve the credits here.
Tap a car for its posts, photos and videos. “All cars” = posts about the whole fleet.
Reels so far
By content type
By hook
Followers
Mix
Top 3 posts
Bottom 3 posts
This week
What to film, one card per video. Shoot days Wed–Fri; a car is filmed when it’s washed and going out on a rental.
Open a shot for an example, the outline and the tips. Film in the iPhone Camera app (4K, vertical, HDR off), then Upload — the phone checks the clip first, then Upload saves it and ticks the shot (up to 95 MB here; This week takes up to 2 GB). Usable = level, steady, no strangers, at least 5 seconds.
Shots the engine is asking for, from this week’s ideas and briefs.
Growth
Edit links & Instagram starting count
| Phrase | Location | Page | Volume | Competition | Impr. / clicks | Status | Advice |
|---|
Add a term
Add a prompt
Google Ads
What happened
Suggestions — what to cut / change
Spend by day
Daily table
| Date | Impressions | Clicks | Cost | Conv | Business Profile |
|---|
Where the money went
Conversions
Only real conversions come from the ads. The Business Profile rows are Google’s own local actions (calls and direction taps on the Maps listing) — they are not ad results.
Site side
Leads and bookings on the site that came in through a Google Ads click.
Leads
| Date | Name | Phone | Popup | Page |
|---|
Bookings
| Date | Name | Car | Status | Total |
|---|
Ads
| Ad | Status | Strength | Approval | Impr. | Clicks | Cost | Conv |
|---|
Settings snapshot
| Counted | Name | Code | Car | Credited |
|---|
| Pickup | Client | Car | Lane | Rental fee | Rate | Due |
|---|
| Dates | Client | Car | Status | Client price | House price | Spread | Source |
|---|