On this page
- Why is travel agency accounting different?
- Which accounts does a travel agency need?
- Worked example: one Umrah package in PKR
- Excel vs travel agency accounting software
- Signs you have outgrown Excel
- What should a travel agency invoice include?
- What to look for in travel agency accounting software
- How does Safar Studio handle agency accounting?
- Summary
Travel agency accounting means tracking three things for every booking: what the customer owes you, what you owe each supplier (the airline or consolidator, hotels, the Umrah company, transport) and the profit left in between. Excel can handle this for a small agency. Once you have instalments, groups and several suppliers per booking, travel agency accounting software is safer and faster.
This guide covers the accounts every agency needs, a worked Umrah example in PKR, a fair comparison of Excel and accounting software, and the signs that you have outgrown your spreadsheet.
Why is travel agency accounting different?
- Money arrives before costs: customers pay deposits weeks before you pay hotels and airlines.
- One sale, many suppliers: an Umrah package mixes tickets, hotels, visa, transport and ziyarat.
- Profit hides inside bookings: you only know the margin once every supplier cost is recorded against the booking.
- Instalments and committees: families pay over months, and every payment needs a receipt.
- Changes after the sale: refunds, reissues and cancellations change the numbers long after the invoice.
Which accounts does a travel agency need?
| Account | Type | What goes in it |
|---|---|---|
| Cash in hand | Asset | Cash received at the counter |
| Bank accounts | Asset | Transfers, cheques and mobile wallet collections |
| Customer receivables | Asset | Amounts customers still owe you |
| Supplier payables | Liability | Amounts you owe airlines or consolidators, hotels, Umrah companies and transporters |
| Sales by service | Income | Tickets, Umrah packages, visas, hotels and other services, kept separate |
| Commission income | Income | Commissions earned from airlines or suppliers |
| Cost of sales | Expense | What each service cost you from suppliers |
| Office expenses | Expense | Rent, salaries, utilities and marketing |
Worked example: one Umrah package in PKR
A family of four books an Umrah package for PKR 1,200,000 and pays a deposit of PKR 600,000. Your costs are air tickets for PKR 640,000 from a consolidator, hotels for PKR 360,000, and visa and transport for PKR 100,000 through the Umrah company. The figures are illustrative.
| Step | Debit | Credit | Amount (PKR) |
|---|---|---|---|
| 1. Invoice the family | Customer receivable | Sales: Umrah packages | 1,200,000 |
| 2. Deposit received | Bank | Customer receivable | 600,000 |
| 3. Tickets issued | Cost of sales: tickets | Payable: consolidator | 640,000 |
| 4. Hotels confirmed | Cost of sales: hotels | Payable: hotel supplier | 360,000 |
| 5. Visa and transport | Cost of sales: visa and transport | Payable: Umrah company | 100,000 |
After these entries the family still owes PKR 600,000, you owe suppliers PKR 1,100,000, and the booking shows a gross profit of PKR 100,000 (1,200,000 minus 1,100,000), about 8.3%. A simple cash sheet would show PKR 600,000 in the bank, with no hint that suppliers are owed almost twice that amount.
When the family pays the balance, debit Bank and credit Customer receivable. When you pay the consolidator, debit Payable: consolidator and credit Bank. Every entry has an equal debit and credit, which is why a correct trial balance always comes back to zero.
Excel vs travel agency accounting software
| Excel | Accounting software | |
|---|---|---|
| Cost | Free or already owned | Monthly, yearly or one-time |
| Double entry | Manual and easy to break | Automatic from each invoice and payment |
| Profit per booking | Only if you build it yourself | Built in |
| Customer and supplier balances | Separate sheets, often out of date | Always current, with ageing |
| Instalment receipts | Typed by hand | Printed from the payment |
| Audit trail | None; anyone can change a cell | Shows who did what, and when |
| Several staff | Conflicting copies of the file | One database with permissions |
| Backups | Manual | Automatic |
Excel is fine when one careful person handles a few bookings a week and reconciles regularly. The real cost of Excel is not the licence; it is the errors nobody notices.
Signs you have outgrown Excel
- You cannot say today how much each customer owes you.
- Supplier statements never match your sheet.
- You find out a package lost money after the group has returned.
- Two staff members keep different versions of the same file.
- Instalment receipts are still written by hand.
- Month-end takes days instead of minutes.
What should a travel agency invoice include?
Whether you use Excel or software, every invoice should show:
- Your agency name, address and DTS licence number (the Department of Tourist Services licenses travel agencies)
- Your NTN, and your sales tax registration if you are registered
- Invoice number and date
- Customer name and phone number
- Passenger names exactly as on their passports
- Service lines (ticket, package, visa, hotel) with travel dates
- Total, payments received and balance due
- Payment terms and your refund policy
What to look for in travel agency accounting software
- Invoices and receipts that post to the ledger automatically
- Supplier accounts for airlines, consolidators, hotels and Umrah companies (Maktabs)
- Profit per booking and per package
- Receivables ageing, so you know who to chase first
- Instalments and committees
- Daily cash desk and bank reconciliation
- Trial balance, profit and loss account and balance sheet
- Staff roles and an admin PIN for voids and refunds
- Export of all your data to Excel
- Works offline at the counter
How does Safar Studio handle agency accounting?
Safar Studio posts every invoice, receipt and supplier bill to a double-entry general ledger, tracks supplier and Maktab payables, and reports package profitability, receivables ageing, the trial balance, profit and loss and the balance sheet. It runs offline on Windows in English and Urdu, and a one-click master Excel export keeps your data portable.
Still comparing systems? Use our checklist of 12 travel agency software features. And if typing passports for groups eats your time, Passport Extractor turns a folder of passport photos into an Excel sheet.
Summary
Good travel agency accounting in Pakistan comes down to recording both the customer side and the supplier side of every booking, so receivables, payables and profit are always visible. Excel works for small volumes if you are disciplined. As soon as you handle groups, instalments and several suppliers, travel agency accounting software pays for itself in the errors it prevents.
