📝 Card & ATM Template
Guides Complete Name
Name on Debit card (if not using their own)
ATM WITHDRAWS
Amount Withdrawn
Currency Withdrawn in
Breakdown of withdraw
Date of Transaction
Supplier Name / Bank Name / Location
Pax
📤 Distribute This ATM Withdrawal
ℹ️ Instructions
Check this to have the Python app run its own Save ATM button using the
Amount / Pax / Date / Bank-Location / Breakdown above, once you Import from Drive.
Leave unchecked to just send the template text.
PAYMENTS ON CC
Amount Paid
Currency Paid
Breakdown of Payment
Date of Transaction
Supplier Name
Pax
Price / Person (site price)
📤 Distribute This CC Payment
ℹ️ Instructions
Check how this Payments on CC entry above (Amount / Pax / Date / Supplier / Breakdown)
should be handled. When the Python app imports from Drive, it will fill those fields into its
Card & ATM panel and ask you to confirm before running the matching action(s) below.
Leave all unchecked to just send the template text.
💧 Pax & Water Count
ℹ️ Instructions
Synced from the Python app's 🎫 Vouchers tab. Tap Today (or pick a day
manually), check the service, then enter Pax and Water counts and tap Export.
The Python app will apply it back onto that day's Vouchers row next time you
Import from Drive there.
👥 PAX
💧 WATER
No photos added yet.
🛂 Passport Photos
ℹ️ Instructions
Snap or upload passport photos here as you collect them. They stay on this device — tap
📲 Send via WhatsApp whenever you're ready to send the batch, and they'll stay right here
afterward so you can send again or keep adding more.
No passport photos added yet.
🛍️ Shops
ℹ️ Instructions
Synced from the Python app's Shops tab. Tap a shop to select it, or
double-tap it to select it and stamp today's date in one go. Fill in
Total Sales and Commission, then tap Export. The Python app will apply it onto
that shop's row next time you Import from Drive there.
💰 TOTAL SALES
🏷 COMMISSION
📜 Log
ℹ️ Instructions
Every entry sent with ☁ Export (Template, Pax & Water, Shops) is recorded here, newest first,
and so is every Meals report you generate. Tap 👁 View on any entry to expand it and
see everything that was saved — not just the summary line. Double-tap an entry (or long-press
on mobile) to reload it — Template/Pax & Water/Shops entries reload into their tab so you can
review, tweak, and Export again; Meals entries reopen the saved report (read-only) in the Meals tab.
🏦 TourBank
ℹ️ Instructions
Mirrors the Python app's TourBank tab, refreshed every time you tap
Import from Drive. Rows highlighted gold are marked CARD, and blue rows are
SITE — sightseeing names pulled in from the Handover tab that weren't already in
TourBank. Both CARD and SITE rows are offered in the Supplier dropdown above, along with
their Price/Person. Double-tap (or double-click) a row to flip it between CARD and
CASH — flipping a row to CARD also drops it straight into the Supplier field in the
Payments on CC block above.
| Date | Site | Price/Pax | Pax | Tour Total | Paid | Pay By |
|---|
🎯 Missed Visits
ℹ️ Instructions
Synced from the Python app's Missed tab. Scroll sideways to see every site —
the Traveller column stays frozen. Double-tap (or double-click) a cell to
mark/unmark a missed visit (🟡). Tap Export Missed Visits to send your marks back;
the Python app applies them the next time you Import from Drive there (existing
marks on the desktop are never removed by this — only new ones are added).
📌 Trip Assignment — your own notes, never exported to the Python app
Builds up automatically every time you Import from Drive: each traveller you've
ever synced gets a row, each Tour Code you've ever synced gets a column. Tap a cell to
tick which trip a traveller is on — purely a personal reminder that stays on this phone.
🎫 Final Optional Summary
ℹ️ Instructions
Synced from the Python app's Final Optional Summary tab. Double-tap (or
double-click) a cell to cycle its payment status: blank → Pre-Paid →
Cash → Credit → blank. Cells with a blue outline were auto-filled from the
manifest. Tap Load Manifest File and pick the Gate1 manifest PDF for this tour
code (—) from your Downloads folder — phone or
computer — to fill in anything still blank; it never overwrites a cell that already
has data. Tap Export Final Optional to send everything back; the Python app
applies it the next time you Import from Drive there (existing desktop data is
never overwritten).
📋 Itinerary
ℹ️ Instructions
Synced from the Python app's Itinerary tab. The window below shows the original
Technical Itinerary PDF — the exact file loaded in the Import tab's Itinerary slot,
uploaded to Google Drive from Export PDF + QR to Drive — and appears automatically
as soon as you Import from Drive, no button needed. Open in Drive opens the same file
in a new browser tab using Google Drive's own viewer, if you'd rather see it full-screen there.
Show Day Notes lists each day's number, date and title together with its note — the
text pulled from the right-hand notes column of the source itinerary PDF, which is separate
from the left-hand time/activity list.
No Technical Itinerary synced yet — in the Python app's Itinerary tab, load the PDF in the Import tab, tap 'Export PDF + QR to Drive', then Import from Drive here.
📞 Contact
Every phone number found in the Itinerary tab's day notes, with the place (hotel, restaurant, etc.)
and name written closest to it, plus any you add manually below. Tap Call or WhatsApp to reach them.
➕ Add a Contact
⚡ Quick Call / Log Number
For a driver or restaurant you'll only need for a day or two: open your phone's own Call Log,
copy the number (long-press it, or open the contact and copy), paste it below and tap Add —
you'll get big Call & WhatsApp buttons right away, with +20 added automatically if it's missing.
No quick numbers yet — paste one above.
🛏 Rooming
ℹ️ Instructions
Synced from the Python app's Rooming tab — traveller names down the side,
one column per hotel/cabin across the top. Tap a hotel's column header to
select it below, then add the hotel's room list as a PDF, one or more
photos, or a camera shot — Gemini reads it and matches room numbers
to the right traveller by name automatically. Double-tap (or double-click)
a cell to correct a single room number by hand.
Requires a Gemini API Key set in Settings.
📥 Import Room Numbers Into a Hotel Column
No files added yet.
🍽 Meals
ℹ️ Instructions
📷 Take Photo or 🖼 Upload Photos to add every page of the meal-choice sheet —
add as many pages as you need for a large group; the meal names in the 1st row can
repeat on every page and that's fine. Tap 🔎 Process Meals and each page's table is
read (name column + one column per meal) to find, per person, which meal's column is marked —
a highlighter stroke, tick, circle, or typed choice all count. Pages are combined into two
reports: pax count per meal, and the list of names per meal. Detection is approximate —
always check the results against the photos, especially near sheet edges or faint marks.
Setting Meal Options in Settings to match the header text exactly (e.g. "Meat lunch,
Chicken or fish Lunch, Vegetarian lunch") makes detection more reliable across multi-page
sheets.
If a Gemini API Key is set in Settings, photos are sent to the Gemini API to read the sheet (usually much more accurate, especially for coloured marks) — otherwise everything runs on-device with no photos leaving your phone.
If a Gemini API Key is set in Settings, photos are sent to the Gemini API to read the sheet (usually much more accurate, especially for coloured marks) — otherwise everything runs on-device with no photos leaving your phone.
Meal options (read from 1st row): —
🍽 Restaurant Name — read automatically from the top of the sheet when using Gemini; edit/enter it here otherwise. Shown at the top of both reports and the WhatsApp message.
No photos added yet.
☁️ Meals Drive — Live Choices
ℹ️ Instructions
This reads straight from the Google Drive folder the desktop app's
☁ Export to Drive button set up for this tour — nothing to import,
nothing printed. Tap 🔄 Refresh to pull the restaurant Choices sheets and
the live report for the Tour Code in Settings. Tap any restaurant to open
its Choices sheet in Google Sheets. The 🔔 switch below turns Telegram
notifications for every choice edit on or off — it's one shared switch
for the whole script, not per tour.
…
…
Tap 🔄 Refresh to load this tour's Drive folder, Choices sheets, and live report.