Easy Parwaz
Cost Calculator
AD
Admin
Admin
Loading...

Active Bookings

0 of 0

Departing or In-transit (Next 14 Days)

Flights (48 Hours)

0 scheduled

Departing next 48 hrs

Pickups Today

0 sectors today

Ground logistics active

Active Hotel Stays

0 in-house

Checked in today

Pending Category:
Booking ID / Status Client & WhatsApp Flight Itinerary Hotel Accommodation Ground Transport Visa Processing Actions

Master Booking & Financial Operations

Finance Engine Active

Integrated Client Logistics (Operations & Vouchers) + Linked Supplier Purchasing (Revenue & Margin)

Client Profile & Basic Record
Confirmed

Confirmed booking date (editable for backdating)

Itemized Client Invoice Breakdown (Line Items)

Itemize packages, flights, hotels, and services. Automatically updates Gross Invoiced Price and syncs to Google Sheets Tab 8.

Line Items Total: 0.00 BHD
Selling Currency & Conversion Parameters (Client Invoice) Agency Base: BHD
Sale in Base: 0.00 BD
Received in Base: 0.00 BD
Balance Due: 0.00 BD
Total Invoiced 0.00 BD
Supplier Payables 0.00 BD
Net Profit +0.00 BD
Margin % 0.0%
Profit / Pax 0.00 BD

Admin Security Access

Enter Admin PIN to unlock Financial Operations

Add New Supplier

Register vendor in central Suppliers Directory

Active Status Enable to display in purchase dropdowns

Generate Voucher & Export A4 PDF & WhatsApp

Select voucher template and client to export official document
Voucher Preview
Ref: EP-1001
Client Invoice Preview
Ref: INV-EP-1001
Client Quotation & Itinerary Preview

Google Sheets & Calendar Sync Not Connected

Two-way live database sync & auto calendar event dispatcher

Google Sheet Database Ready to connect
Google Calendar Dispatch Auto (Flights, Hotels, Transfers)
Last Synced: Never
Step-by-Step 2-Minute Setup Guide ▼

1. Open Google Sheets: Create a new blank Google Sheet (e.g. named Easy Parwaz Bookings).

2. Open Script Editor: Click Extensions > Apps Script in the top menu.

3. Paste Script: Delete any code in Code.gs and paste the script provided in google_apps_script/Code.gs.

4. Deploy: Click Deploy (blue button top right) > New deployment.

5. Choose Web App: Under Select type, choose Web app.

6. Access settings: Set Execute as: Me and Who has access: Anyone.

💡 To update an existing Google Sheet to 47 columns:
1. Copy updated google_apps_script/Code.gs into Apps Script.
2. Select setupSheetHeaders from the function dropdown and click Run (or click menu Easy Parwaz Ops > ⚡ Upgrade / Setup 47-Column Headers in your sheet).
3. Click Deploy > Manage deployments > Edit (pencil icon) > Version: "New version" > Deploy.

Google Sheets Write Diagnostics Write Failed

Live HTTP request & response breakdown for Google Apps Script

Google Authentication or Permission Blocked

The write operation was rejected by Google Apps Script. Check deployment settings below.

Target Web App URL
(No URL configured)
HTTP Status
500 (or Network Error)
Target Booking ID
EP-931
Payload Sent (JSON) 

        


        
        

          

             Raw Server Response Body
            
          

          

            

          

        


        
        

          

             Required Google Apps Script Settings:
          

          
    
            
  1. Open Google Sheet > Extensions > Apps Script.
    2. 
            
  2. Paste updated google_apps_script/Code.gs and click Save.
    3. 
            
  3. Click Deploy > Manage deployments > Edit (pencil) > Version: "New version".
    4. 
            
  4. Ensure Who has access: Anyone (not "Only myself").
    5. 
          

        

      


      
      

        

        

          
          
        

      


    

  

  
  
  
  
    

      

        

          
        

        

          
Delete Booking Record?

          
This action cannot be undone.

        

      


      

        Are you sure you want to permanently remove booking EP-1001 for client Client Name?
      


      

        
        
      

    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            

              
Supplier Payables & Vendor Dues Breakdown

              Reconciliation Engine
            

            
Itemized purchasing costs, due dates, settlement status, and vendor payables

          

        


        

          
          

          
        

      


      
      


        
        

          

            
              
              Vendor Owed Summary (Click vendor to filter):
            
            0 Active Vendors
          

          

            
          

        


        
        

          
          

            
            
            
          


          
          

            
            
            
          

        


        
        

          

            

              
                

                  Booking ID
                  Client Name
                  Service Item & Logistics
                  Vendor / Supplier
                  Due / Service Date
                  Cost (Supplier / Base)
                  Status
                  Action
                

              
              
                
              
            

          


          
          
        


      


      
      

        

          Tip: Click Mark as Settled to clear dues as vendor bank transfers are completed.
        

        

          
        

      


    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            

              
Vendor Statement & Profile

              Category
            

            
Comprehensive purchasing ledger, allocated bookings, and outstanding account balance

          

        


        
      


      
      


        
        

          

            Operating Currency
            SAR
          

          

            Payment Terms
            Direct BSP / 15 Days
          

          

            Contact Person
            Sales Desk
          

          

            

              Phone / WhatsApp
              +966 12 345 6789
            

            
              
            
          

        


        
        

          
          

            

              Bookings Volume
              
                
              
            

            

              0
              services booked
            

          


          
          

            

              Total Business Given
              
                
              
            

            

              0.00 BD
            

          


          
          

            

              Outstanding Balance Owed
              
                
              
            

            

              0.00 BD
            

          

        


        
        

          

            
            
          

          Service-level itinerary allocations
        


        
        

          

            

              
                

                  Booking ID
                  Client / Traveler
                  Service Type & Details
                  Service Date
                  Buying Cost
                  Settlement Status
                  Actions
                

              
              
                
              
            

          


          
          
        


      


      
      

        

          Account Statement: Live reconciliation based on confirmed booking logs
        

        
      

    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            

              
Client Statement & 360° Profile

              Standard
            

            
Comprehensive travel history, lifetime purchased services, and accounts statement

          

        


        
      


      
      


        
        

          

            Customer ID
            CUST-101
          

          

            Preferred Destination / Notes
            Umrah & Makkah
          

          

            

              Phone / WhatsApp
              +973 3912 3456
            

            
              
              WhatsApp
            
          

        


        
        

          
          

            

              Total Trips Booked
              
                
              
            

            

              0
              packages taken
            

          


          
          

            

              Total Revenue Given
              
                
              
            

            

              0.00 BD
            

          


          
          

            

              Current Balance Due
              
                
              
            

            

              0.00 BD
            

          

        


        
        

          

            

              
              All Purchases & Travel History
            

            0 bookings found
          


          

            

              
                

                  Booking ID & Dates
                  Destination & Pax
                  Services Bought Breakdown
                  Invoiced (BHD)
                  Cash Paid
                  Balance Due
                  Status
                  Actions
                

              
              
                
              
            

          


          
          
        


      


      
      

        

          Client 360° Profile: Integrated accounts and itinerary ledger
        

        
      

    

  

  
  
  
  
    

      

        
      

      

        
Install Easy Parwaz on iOS

        
Add to your iPhone or iPad home screen for an ultra-fast, full-screen standalone app experience.

      

      

        

          1
          Tap the Share icon  in Safari's bottom toolbar.
        

        

          2
          Scroll down and tap Add to Home Screen .
        

        

          3
          Tap Add in the top-right corner to install Easy Parwaz!
        

      

      
    

  
  
  
  
  
    

      
      
      

        

          

            
          

          

            

              
AI Passport Scanner (MRZ & OCR)

              ICAO 9303
            

            
Client-Side Optical Recognition • Instant MRZ extraction & Birthday Intelligence

          

        

        
      


      
      

        
        
        

          
          
          
          

            

              
            

            
Click to capture photo with camera or browse image file

            
Supports JPG, PNG, WEBP (Keep MRZ lines at bottom clear)

          


          
          
        


        
        

          

            

              
              Extracted Passport Details (Editable)
            

            
          


          

            
            

              
              
            


            

              
              
            


            

              
              
            


            

              
              
            


            

              
              
            


            

              
              
            


            

              
              
            


            

              
              
            


            

              
              
            


          

        


      


      
      

        

        

          
          
        

      


    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            
Select Traveler from Passports Vault

            
Instantly pre-fill booking profile & client records

          

        

        
      


      
      

        

          
          
        


        

          
        


        
      


      
      

        
      


    

  

  
  
    

      

        

          
          
Google Gemini API Configuration

        

        
      

      

        

          Easy Parwaz AI Copilot connects directly from your browser to Google Gemini Pro. Your API key is stored safely in your local browser storage (localStorage) and is never shared, logged, or sent to external third parties.
        

        

          
          
          

            Get your key from Google AI Studio (aistudio.google.com).
          

        

      

      

        
        

          
          
        

      

    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            

              
Account Statement

              PKR
              Bank
            

            
Complete transaction history, running ledger balance, and multi-parameter audit drilldown.

          

        


        

          
        

      


      
      

        
        

          

            Opening Balance
            
          

          0.00
        

        

          Total Inflow (+)
          +0.00
        

        

          Total Outflow (-)
          -0.00
        

        

          Current Net Balance
          0.00
        

      


      
      

        
        

          Period:
          
          
          
          
          
          
        


        
        

        
        

          
          
        


        
        

          
          
        


        
        

          
          
        

      


      
      

        

          

            
              

                Date
                Transaction ID
                Booking ID
                Party / Entity
                Description
                Outflow (-)
                Inflow (+)
                Running Balance
                Reference
                Actions
              

            
            
              
            
          

        


        
        
      


      
      

        

          Total Transactions: 0
        

        

          
          
        

      


    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            

              
Edit Transaction

              TXN-000
            

            
Modify transaction details and automatically recalculate ledger balances.

          

        

        
      


      
      

        
        

        
        

          

            
            
          

          

            
            
            
              
          

        


        
        

          
          

            
            
          

        


        
        

        
        

          
          
        


        
        
        
        

          

            

              
              
            

            
            
          


          
          

            
            
          

        


        
        
        
        

        
        
        
        

        
        
        
        

        
        
        

        
        

          

            
            
          

          

            
            
          

        


        
        

          
          
        


        
        

          

            
            
          

          

            
            
          

        


      


      
      

        
        
      


    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            
Set Opening Balance

            
Define base float & recalculate ledger running balances.

          

        

        
      


      
      

        
        
        

          
          
        


        
        

          
          

            
            PKR
          

        


        
        

          
          
        


        
        

          
          
        


        
        

          
          
        


      

    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            
Record Inflow / Receipt

            
Deposit collection into master bank account & sync ledger.

          

        

        
      


      
      

        

          
          
        

      


      
      

        
        
        
        
        

          
          

            

              
              
            

            
            
            
            
          


          
          

            

              
              
            

            

              
              
            

          


          
          
        


        
        
        
        

        
        
        
        

          
          

            

              
              
            

            

              
              
            

          


          
          

            
            
          


          
          

            

              
              
            

            

              
              
            

          


          
          

            
            
          

        


      


      
      

        
        
      


    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            
Record Outflow / Payout

            
Disburse payout from master account & sync ledger.

          

        

        
      


      
      

        

          
          
        

      


      
      

        
        
        
        
        

          
          

            

              
              
            

            
            
            
          


          
          

            

              
              
            

            

              
              
            

          


          
          

            
            
          

        


        
        
        
        

        
        
        
        

          
          

            

              
              
            

            

              
              
            

          


          
          

            
            
          


          
          

            

              
              
            

            

              
              
            

          

        


      


      
      

        
        
      


    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            
Internal Contra Transfer

            
Transfer funds between internal accounts with auto-balancing ledger entries.

          

        

        
      


      
      

        
        
        

          
          
        


        
        

          
          
        


        
        

          

            
            
          

          

            
            
          

        


        
        

        
        

          

            
            
          

          

            
            
          

        


      


      
      

        
        
      


    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            
Direct Bank / Cash Transaction

            
Log miscellaneous income, office expense, or direct bank fee.

          

        

        
      


      
      

        
        
        

          
          

            
            
          

        


        
        

          

            
            
          

          

            
            
          

        


        
        

          

            
            
          

          

            
            
          

        


        
        

          

            
            
          

          

            
            
          

        


        
        

          

            
            
          

          

            
            
          

        


      


      
      

        
        
      


    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            
🏢 Log Office Operating Expense

            
Record rent, salaries, utilities, marketing, or general OPEX.

          

        

        
      


      
      

        
        
        

          

            
            
          

          

            
            
          

        


        
        

          

            
            
          

          

            
            
          

        


        
        

          
          
        


        
        

          
          

            
            BHD
          

          
Deducted from Booking Gross Profit to compute True Net Profit.

        


      


      
      

        
        
      


    

  

  
  
  
  
    

      
      
      

        

          

            
          

          

            
👥 New Client Profile

            
Save client to directory with 2-way Google Sheets synchronization.

          

        

        
      


      
      

        
        
        

          

            
            
          

          

            
            
          

        


        
        

          
          

            
            
          

        


        
        

          

            
            

              
              
            

          

          

            
            

              
              
            

          

        


        
        

          
          
        


      


      
      

        
        
      


    

  

  
  

  
  
  
  

    
    

      

    


    
    

      
      

        

          
        

        

          Easy Parwaz Operations
        

        

          Executive Employee Portal • Secure Access
        

      


      
      

      
      

        
        

          
          

            
              
            
            
          

        


        
        

          
          

            
              
            
            
            
          

        


        
        
      


      
      

        

          
          Role-Restricted Multi-Branch Workspace
        

      

    

  


  
  
  

  
  
    

      

        

          
        

        

          
Operational Task & Meeting Desk

          
Record actionable reminders, meeting follow-ups, passport collection & client deadlines

        

      

      
    

    

      
      

        
        
      

      

        

          
          
        

        

          
          
        

        

          
          
        

      

      

        
        

          

            
          

          

            
          

        

      

      

        
        
      

    

  

  
  
    

      

        

          
        

        

          
Enter Hotel Confirmation (HCN)

          
Attach confirmed voucher confirmation number

        

      

      
    

    

      

        
Booking ID: --

        
Client: --

        
Hotel: --

        
Dates: --

        
Supplier Ref: --

      

      

        
        
      

      

        
        
      

    

  

  
  
    

      

        

          
        

        

          
Enter Flight PNR / Ticket Ref

          
Attach airline GDS PNR or e-ticket number

        

      

      
    

    

      

        
Booking ID: --

        
Client: --

        
Sector / Airline: --

        
Departure: --

      

      

        
        
      

      

        
        
      

    

  

  
  
    

      

        

          
        

        

          
💵 Record Partial Payment

          
Log installment payment and recalculate balance

        

      

      
    

    

      
       
      
      

      
      

        

          
Total Invoiced / Cost

          
--

        

        

          
Already Paid

          
--

        

        

          
Current Balance Due

          
--

        

      


      
      

        Payment Breakdown:
        
      


      

        
        

          
          BHD
        

      


      

        

          
          
        

        

          
          
        

      


      

        
        
      


      

        
        
      

    

  

  
  
    

      

        

          
        

        

          
Add Channel / Supplier

          
Add an ad-hoc supplier or DMC rate channel