How a 32-Room Hotel Replaced Excel, Paper Bills, and a Separate POS with HostFlow
    Hospitality · Hotel Software (HostFlow PMS)

    How a 32-Room Hotel Replaced Excel, Paper Bills, and a Separate POS with HostFlow

    HostFlow, a product of Codextroop Technologies Pvt Ltd

    Duration: 18 days go-liveTeam: Front desk 2, housekeeping 4, F&B 6

    At a Glance

    Property32-room highway hotel (representative deployment)
    LocationPune-Mumbai Expressway (NH-48), Maharashtra, India
    Property typeHighway hotel / lodge / guest house
    Rooms32 (Standard, Deluxe, Family)
    RestaurantYes: dine-in, takeaway, and limited room service
    TeamFront desk 2, housekeeping 4, F&B 6
    Previous setupExcel room register, handwritten GST bills, standalone restaurant POS
    SolutionHostFlow (product of Codextroop Technologies Pvt Ltd), Code + Support & AMC
    Go-live18 days from kickoff to front-desk live
    HostingSelf-hosted on customer VPS (Codextroop-managed setup)

    The Challenge

    This 32-room highway hotel sits on NH-48 between Pune and Mumbai, one of the busiest routes in western India. Most guests arrive late at night and leave early the next morning. The front desk handles short stays every day, and every minute at the register counts. For years, the hotel ran on Excel, WhatsApp, and a separate restaurant billing machine. It worked until weekend rush or GST audit day.

    Like many small and mid-size hotels in India, this property had outgrown manual tools but did not want an expensive chain-grade PMS.

    • Room availability lived in Excel. Double bookings on busy weekends meant refunds, upgrades, or angry guests.
    • The restaurant used its own POS. Room charges were written on paper and re-entered at checkout.
    • GST billing was inconsistent. Some bills had CGST/SGST split; others were handwritten and rejected by company guests and travel agents.
    • Guest history was missing. Repeat fleet drivers and corporate travelers came often, but the desk had no record of past stays.
    • Cloud PMS quotes were per room per month. For a 32-room hotel with tight margins, the cost did not add up.

    What They Needed

    The owner did not need a 500-room chain system. He needed hotel register software built for how small hotels actually work: fast check-in, clear GST billing, restaurant linked to room folio, Razorpay/UPI at the desk, and full control over guest data on his own server.

    Why They Chose HostFlow

    After a 15-minute demo with Codextroop Technologies Pvt Ltd, the owner's checklist was simple.

    • Self-hosted on own VPS: guest records and folios stay on infrastructure the hotel controls
    • Register-first workflow: reservation, room status, check-in, folio, GST invoice, checkout in one flow
    • Hotel PMS and restaurant in one system: POS orders post directly to guest folios
    • GST-ready billing: proper tax invoice with CGST/SGST line items at checkout
    • Full setup support: Code + Support & AMC covers server install, room setup, staff training, and one year of updates
    • Clear roadmap: OTA sync (Staah) available as add-on when ready, not required to replace Excel today

    Implementation: What Codextroop Delivered

    The hotel went live in 18 days from signed agreement to daily front-desk use. Codextroop stayed on remote support through the first weekend, the busiest period, to handle real check-in traffic.

    • Week 1, foundation: VPS setup (PHP 8.3, MySQL 8, Redis, SSL), 32 rooms across three types, GST tax config, staff login roles
    • Week 2, operations and F&B: restaurant menu, dine-in and takeaway orders, POS terminal, KDS for kitchen, HK board, website inquiry form
    • Week 3, training and go-live: front desk and F&B training, Razorpay for card/UPI, two-day parallel run with Excel, then full switch

    What Changed Day to Day

    In the first 90 days on HostFlow, each team saw a clear shift at the register, in the kitchen, and at checkout.

    • Room grid replaced the Excel sheet. Live occupancy, quick room change, and HK status on one screen.
    • Checkout became simple. Room and restaurant charges on one folio, GST breakdown printed, Razorpay at the desk.
    • Housekeeping kept up with turnover. Status updated on tablet; front desk sees dirty rooms turn vacant without walking the floor.
    • Repeat guests were recognized. Profiles store stay history, company billing, and staff notes.
    • Website inquiries stopped getting lost. Leads from the hotel website enter CRM instead of unread WhatsApp messages.

    Results

    Figures below reflect the hotel's first 90 days on HostFlow. Results vary by property size, staff adoption, and booking mix.

    MetricBefore HostFlowAfter HostFlow
    Average check-in time~8 minutes~3 minutes
    Night audit and reconciliation~2 hours~45 minutes
    Double-booking incidents2 to 3 per monthZero
    Restaurant-to-room charge errorsFrequent manual fixesAutomatic folio posting
    Website inquiries trackedLost in WhatsApp or email100% captured in CRM
    GST invoice formatInconsistentStandard on every checkout

    ~8 min to ~3 min

    Average Check-in Time

    ~2 hr to ~45 min

    Night Audit Duration

    Zero

    Double-booking Incidents

    Automatic folio posting

    Restaurant-to-Room Charges

    Modules in Daily Use

    ModuleHow the hotel uses it
    Reservations and room gridWalk-in, phone, and WhatsApp bookings with live availability
    Check-in / check-outExpress flow for short highway stays
    Folios and GST invoicesRoom plus F&B on one bill with CGST/SGST at checkout
    Housekeeping boardRoom status updated on tablet in real time
    Restaurant POS and KDSDine-in, takeaway, room service with kitchen display
    Guest CRMStay history, company accounts, and guest notes
    Leads and booking formsWebsite inquiry capture and follow-up
    Night auditEnd-of-day posting and shift handover reports

    Before vs After

    Before HostFlow

    • Excel sheet for rooms, double bookings on busy nights
    • Separate restaurant POS, no link to room bill
    • Handwritten or partial GST bills rejected by company guests
    • Night audit past midnight on weekends
    • Guest history in notebooks and staff memory
    • Monthly cloud PMS pricing too high for a 32-room hotel

    With HostFlow

    • Live room grid with one-click check-in and express checkout
    • Integrated POS: orders post to guest folio automatically
    • Auto GST invoice with CGST/SGST on every checkout
    • Night audit done in under one hour
    • Guest CRM with inquiry-to-booking pipeline
    • Perpetual license on own server, no per-room SaaS lock-in

    In Their Words

    Representative quote. Replace with approved owner testimonial when available.

    We did not want another monthly subscription with our guest data on someone else's cloud. HostFlow runs on our server. Our team picked it up in two training sessions, and the restaurant finally connects to the front desk. For a small hotel on the highway, that alone was worth it.

    Rajesh Kulkarni, Owner, Hotel owner

    What's Next

    The hotel is running HostFlow in daily operations. Planned next steps:

    • OTA channel setup via Staah when ready to reduce manual Booking.com / MakeMyTrip entry
    • WhatsApp pre-arrival messages for confirmed bookings
    • Loyalty offers for repeat fleet and corporate guests

    The register works fully today. Add-ons like OTA sync can come later when the business is ready.

    Could HostFlow work for your hotel?

    HostFlow is a hotel management software product by Codextroop Technologies Pvt Ltd. It is built for guest houses, highway hotels, and independent properties up to ~100 rooms that want a proper front desk register on their own server. GST billing, Razorpay/UPI, and Form C/FRRO workflows are included for properties that need them.

    Typical fit

    • Hotels and guest houses with 10 to 50 rooms
    • Register-first daily operations at the front desk
    • Optional restaurant or F&B outlet on the same property
    • GST billing (CGST/SGST) and Razorpay/UPI at checkout
    • No in-house IT team (Codextroop handles VPS setup)

    Typical go-live: 2–3 weeks with Code + Support & AMC

    Technologies Used

    HostFlow PMS
    Codextroop Technologies Pvt Ltd
    PHP 8.3
    MySQL 8
    Redis
    Self-hosted VPS
    SSL
    Razorpay
    Restaurant POS + KDS
    GST Folio Billing

    This case study describes a representative deployment of HostFlow, a product of Codextroop Technologies Pvt Ltd. Property details and metrics are illustrative until an approved client testimonial is published.