How to Automate Payment Reminders for Tour Bookings

Chasing customers for overdue payments is one of the most stressful parts of running a tour business. It's awkward, time-consuming, and damages relationships. Automated payment reminders eliminate the problem entirely — sending professional reminders before payments are due, without any manual effort.

Why Manual Payment Follow-Ups Fail

Most tour operators rely on a mental note or a calendar event to chase outstanding payments. This approach fails because:

• You forget — especially when managing multiple bookings simultaneously
• It feels awkward to ask for money — so you delay, and the customer delays further
• Inconsistency — some customers get 3 reminders, others get none
• No record — if a dispute arises, there is no proof a reminder was sent

Automated reminders solve all of these problems while maintaining a professional, friendly tone.

How TourRova's Automatic Payment Reminder System Works

TourRova uses a daily cron job (automated task) that runs every morning at 8 AM and checks all pending payments. For each payment with a due date, it sends reminders at these intervals:

When	Message	Channel
7 days before due	"Payment due in 7 days"	Email + WhatsApp
3 days before due	"Payment due in 3 days"	Email + WhatsApp
Due today	"Payment due TODAY ⚠️"	Email + WhatsApp
1 day overdue	"Payment OVERDUE 🚨"	Email + WhatsApp
3 days overdue	"URGENT: Payment Overdue"	Email + WhatsApp

Each reminder email includes a Pay Online Now button linking to the customer portal where they can pay their balance directly. The WhatsApp message includes the same link.

Step-by-Step: Setting Up Automatic Payment Reminders

Step 1 — Record the Payment with a Due Date

When recording a payment in TourRova (from any booking view), always set the Due Date field. This is the date you expect to receive the payment. Without a due date, no reminder is sent.

Step 2 — Set Up the Cron Job (One-Time Setup)

For self-hosted installations, add this cron job in Hostinger hPanel → Advanced → Cron Jobs:

Schedule: Minute 0, Hour 8, Day/Month/Weekday: * (runs daily at 8 AM)

Command: php /home/u320688752/domains/tourrova.com/public_html/cron/payment_reminders.php

For TourRova cloud users, this is already configured automatically — no action needed.

Step 3 — Connect WhatsApp (Optional but Recommended)

For reminders to also go via WhatsApp, connect your WhatsApp Business API in Settings → WhatsApp Setup. See the WhatsApp setup guide for instructions.

Step 4 — View the Reminders Dashboard

Go to Payments → Reminders to see all pending payments, their due dates, and the full reminder log showing every reminder sent with timestamp and channel.

The Result: Getting Paid on Time, Every Time

Tour operators using automated payment reminders report significant improvements:

• Overdue payments drop from 30-40% to under 5%
• Customers actually thank you for the reminder — it's a professional service, not nagging
• Your cashflow becomes predictable — you know exactly when money will arrive
• Time saved: 30-60 minutes per week that used to be spent on manual follow-ups