﻿HotelSimplify onboarding pack: blank files

Fill in these files with the property's set-up and import the ZIP in HotelSimplify (Set up > Import and export).
The rows in them are examples for a sample hotel: replace them with your own. Delete the files you do not need.

Rules for every file
- Keep the first row (the column headings). Other column orders and extra columns are fine; unknown columns are ignored.
- Dates: dd-mm-yyyy (31-12-2026). Times: hh:mm (12:00). Yes/no columns: yes or no. Amounts: plain numbers (3500), before GST.
- Codes (room type, rate plan, policy, amenity) use letters, digits, - or _. Lists use | between items (DLX|STE).
- Save as CSV UTF-8 (Excel: File > Save As > CSV UTF-8) or as .xlsx.
- Nothing is saved until every file is clean: Check shows each problem with its file, row and column.
- Rows already in HotelSimplify are skipped, or updated when "Update what is already here" is on. Nothing is deleted.

Files, in import order
01-property.csv  Property profile: Name, kind, address and contact details of the property. Printed on vouchers, receipts and invoices. One row.
    Property name (required)
    Property type (required): Hotel, Lodge, Homestay, Resort, ServiceApartment, Hostel, Guesthouse, Villa
    Star rating: 1 to 7, or leave empty.
    Address line 1 (required)
    Address line 2
    City (required)
    District
    State (required): The state's name (Rajasthan) or its 2-digit GST code (08).
    PIN code (required)
    Phone
    Mobile
    Email
    Website
02-tax-profile.csv  GST profile: GSTIN, legal and trade name, PAN and how GST is shown. Decides CGST+SGST or IGST and the invoice header. One row.
    GSTIN: Leave empty if the property is not registered for GST.
    Legal name (required)
    Trade name
    PAN: Must match the PAN inside the GSTIN.
    Composition scheme
    Specified premises: yes when any room's tariff in the last year was above Rs 7,500 (restaurant GST 18% with credit).
    E-invoice applicable
    Prices shown with GST
    Invoice footer
03-buildings.csv  Buildings: Blocks or wings, for properties with more than one building (leave empty otherwise).
    Building (required)
    Sort order
04-floors.csv  Floors: Floors (and the building each is in). Rooms are listed floor by floor.
    Floor (required)
    Level: 0 ground, 1 first, -1 basement.
    Building
    Sort order
05-check-in-policies.csv  Check-in policies: When a stay-day starts and ends: fixed times (12:00 in, 11:00 out) or 24-hour check-out, with grace periods.
    Code (required)
    Name (required)
    Mode (required): Fixed (set check-in and check-out times) or Rolling24 (24 hours from check-in).
    Check-in time: Fixed only, e.g. 12:00.
    Check-out time: Fixed only, e.g. 11:00.
    Stay-day hours: Rolling24: length of a stay-day, usually 24 (1 to 48).
    Early check-in grace (min): Minutes early that cost nothing (0 to 720).
    Late check-out grace (min): Minutes late that cost nothing (0 to 720).
    Part-day rule: How early/late beyond grace is charged: Slabs (early/late charges file), HalfDay or FullDay.
    Default
    Active
    Description
06-check-in-charges.csv  Early / late charges: Early check-in and late check-out charges of each policy, by how many minutes early or late.
    Policy code (required)
    Applies to (required): EarlyCheckIn, LateCheckOut
    From minutes (required): Minutes early or late, from (1 to 2880).
    To minutes: Up to (empty = no upper end).
    Charge type (required): Percent (of the day's tariff), Amount (rupees), HalfDay or FullDay.
    Charge value: Percent or rupees; empty for HalfDay and FullDay.
07-room-types.csv  Room types: Kinds of room sold: occupancy, beds, view, size, sold by the room or by the bed (dormitory).
    Code (required)
    Name (required)
    Base occupancy: Guests the room price covers (usually 2). Extra adults/children are charged beyond it.
    Max adults
    Max children
    Max occupancy
    Extra bed allowed
    Bed type
    View
    Area sq ft
    Description
    Max extra beds: 0 to 5.
    Check-in policy code: Empty = the property's default policy.
    Sell by: Room, or Bed for a dormitory (each bed is sold on its own).
    Dormitory for: Bed only: Mixed, Male or Female.
    Show on booking page
    Active
    Sort order
08-rooms.csv  Rooms: Every room (or dormitory bed) with its room type and floor.
    Room no (required)
    Room type code (required)
    Floor
    Room label: Optional name shown with the number (Maharaja Suite).
    Smoking
    Wheelchair accessible
    Max occupancy (this room): Only when this room differs from its room type.
    Notes
    Active
    Sort order
    Dormitory: Beds of a dormitory room type: the dormitory's short name (D1). Beds are numbered D1-B1, D1-B2 ...
09-meal-plans.csv  Meal plans: EP, CP, MAP, AP and their price per adult and child per night.
    Code (required)
    Name (required)
    Breakfast
    Lunch
    Dinner
    Price per adult: Per night, before GST.
    Price per child
    Active
10-cancellation-policies.csv  Cancellation policies: Cancellation policies and their no-show charge.
    Name (required)
    Description
    No-show charge: None, FirstNight, Percent, Amount or FullStay.
    No-show value: Percent or rupees, for Percent and Amount.
    Active
11-cancellation-rules.csv  Cancellation charges: What a cancellation costs, by how many hours before arrival.
    Policy name (required)
    Hours before arrival (required): Cancelled less than this many hours before arrival (0 to 8760).
    Charge type (required): Percent (of the stay), Nights or Amount (rupees).
    Charge value (required)
12-seasons.csv  Seasons: Peak, festival and off seasons (date ranges) used by the rate grid.
    Season (required)
    Start date (required)
    End date (required)
    Priority: Higher wins where seasons overlap.
    Colour: #RRGGBB, e.g. #E07A1F.
13-rate-plans.csv  Rate plans: Rate plans (BAR, corporate, packages, OTA): meal plan, cancellation and check-in policy, room types sold.
    Code (required)
    Name (required)
    Kind: BAR, Corporate, Package, Promo, Agent, OTA, LongStay, Complimentary or Hourly.
    Meal plan code
    Cancellation policy
    Check-in policy code
    Based on plan code: A plan priced from another one (BAR less 10%).
    Price rule: With a base plan: PercentOff, AmountOff, PercentUp or AmountUp.
    Price rule value
    Refundable
    Min nights
    Max nights
    Public
    Active
    Sort order
    Room types: Room type codes separated by | (DLX|SUP), or All / empty for every room type.
14-rate-grid.csv  Rate grid: Base prices of each rate plan and room type for a date range (and season, weekdays): 1 adult, 2 adults, extra adult, extra child.
    Rate plan code (required)
    Room type code (required)
    Season
    From date (required)
    To date (required)
    Days: All, Weekdays, Weekends, or days such as Fri,Sat.
    Price (1 adult)
    Price (2 adults) (required)
    Extra adult: Per adult beyond the base occupancy, bed included.
    Extra child: Per child beyond the base occupancy, bed included.
    Sales channels: Pass RPS-3: All (or empty), or Counter|Website|Agents|OTAs: the channels this price is for.
15-rates.csv  Daily prices: Prices for particular dates on the rates calendar (overrides the grid).
    Room type code (required)
    Rate plan code
    From date (required)
    To date (required)
    Price (2 adults) (required)
    Price (1 adult)
16-room-prices.csv  Room price differences: Rooms priced above or below their room type (a corner room, a room without a view).
    Room no (required)
    Price by (required): Amount (+/- rupees), Percent (+/- percent) or Fixed (rupees a night).
    Value (required)
    Note
17-amenities.csv  Amenities: Amenities and services: free or chargeable, price and how it is counted, and the GST revenue head.
    Code (required)
    Name (required)
    Category: Room (in the room), Property (pool, parking) or Service (laundry, pick-up).
    Icon: Optional icon name (wifi, tv, ac ...).
    Charge: Free, Chargeable
    Price: Chargeable only, before GST.
    Charged per: PerStay, PerNight, PerPerson, PerPersonNight or PerItem.
    Revenue head: Chargeable only: the revenue head's code or name (LAUNDRY, TRANSPORT, MISC).
    Guests can ask
    Active
    Sort order
    Notes
18-room-type-amenities.csv  Amenities by room type: Which amenities each room type has, and whether they are included in the price.
    Room type code (required)
    Amenity code (required)
    Included in price: yes (default) or no (charged, like a minibar).
19-room-amenities.csv  Amenities by room: A room's own exceptions to its room type (this room also has a bathtub, this one has no balcony).
    Room no (required)
    Amenity code (required)
    Room has it (required): Add (yes: this room also has it) or Remove (no: this room does not).
20-companies.csv  Companies: Corporate accounts: GSTIN, contact, credit limit and days, contract rate plan.
    Name (required)
    Code
    GSTIN
    PAN
    Address
    City
    GST state code
    PIN code
    Contact name
    Email
    Phone
    Credit limit
    Credit days
    Bill to company
    Address line 2
    Contract rate plan code: The company's own rate plan (a Corporate plan).
    Notes

Guests and future bookings (moving from another system) are imported one file at a time and are never exported.
