Free Excel Templates for Umrah & Hajj Agencies

One row per pilgrim with the passport details every later list is built from.

What’s inside: Passport number and expiry, date of birth, nationality and contact details — and it imports straight into Ziyara, so nothing is typed twice.

A hotel-ready rooming list for Makkah or Madinah, one row per bed.

What’s inside: Room-type and gender drop-downs, a red warning when a room holds more pilgrims than its type allows, an orange one when a room mixes genders, and live headcounts.

A group passenger manifest in the column order airlines ask for.

What’s inside: Names as in the passport, date of birth, nationality, passport details, ticket and seat — and passport expiry turns red when it is less than six months after the flight date.

The pricing method from our guides as a working spreadsheet.

What’s inside: Hotel costs split by room occupancy, fixed costs per pilgrim, buffer and margin, the selling price per room type and a break-even table for smaller groups.

A package offer you can send the same day someone asks for a price.

What’s inside: Dates, both hotels and nights, a price per person for quad, triple and double, what is and is not included, the deposit — and a warning when the room split does not match the number of pilgrims.

An invoice for one pilgrim or one family, with the payment history on the same page.

What’s inside: Package and extras as line items, VAT if you charge it, a table for the deposit and installments, and a balance that is calculated for you and turns red once the due date has passed.

A one-page financial plan for your first year: what one pilgrim earns you, what the agency costs to run, and where the two meet.

What’s inside: Margin per pilgrim, running costs, net profit for the year, the number of pilgrims and groups you need to break even, a table for two to eight groups a year, and the cash you need before the first payments arrive.