Banquet Hall Booking System – Google Sheets Apps Script

If you run a banquet hall, wedding lawn or co-working space you know the failure mode: bookings in a paper register, advances noted somewhere in WhatsApp, quotations retyped every time — and then the nightmare, two events booked on the same hall for the same date. This puts the whole operation in one dashboard, running on Google Sheets with no hosting and no subscription.

What it does

Customers open a public link, pick a room, choose a date and guest count, and see the time slots that are genuinely free — anything already booked simply is not offered, which is what stops the double booking. They confirm, and the system emails them, creates their customer account, and (if you have wired up the WhatsApp API) messages them too. Inside, the booking carries its facilities, its payments, its timeline and its actions, so collecting a balance or cancelling is one click from the booking itself.

Highlights

• Calendar view with drag-and-drop rescheduling — move a booking to another date and the sheet updates with it
• Facilities priced per person or per event: food packages, tea service, decoration, projector and anything else you define
• Quotations for walk-ins or existing customers, with discounts, validity dates and terms, sent by WhatsApp or email
• Payments recorded as partial, advance or refund across cash, card, UPI or bank transfer, moving the status to paid automatically
• Promo codes with fixed or percentage discounts and usage limits
• Invoices generated from a booking, printable receipts, and expenses tracked by category
• Reports covering income versus expense, receivables, revenue by room, payment methods and a monthly profit and loss

Who it is for

Banquet halls, marriage lawns, conference and meeting rooms, and co-working spaces — anywhere a fixed number of spaces is sold in time slots and the money arrives in instalments.