Hidden Markups, Balance Settlements, and Dual Invoicing

The professional way to protect your margins, track off-platform settlements, and keep your books GST-compliant — without secret notebooks or double-entry spreadsheets.

March 2026 8 min read

How Most Agents Do It Today: The "Paper & Prayer" Method

A hidden markup is the profit margin added by a travel agent above the vendor net rate that is not visible to the customer on the invoice. Before dedicated software, travel agents managed these margins and off-settlement payments using a mix of improvisation and hope. If you recognize any of these, you're not alone — this is how most Indian travel agencies still operate:

The "Secret" Notebook

A manual register of what the client actually owes versus what appears on the official invoice. The vendor gave you a net rate of ₹8,000/night, you billed the customer ₹12,000/night, and the ₹4,000 difference lives in a notebook that you hope nobody else reads.

The Double-Entry Spreadsheet

One Excel sheet for "Customer View" — clean, professional, showing the total package price. Another sheet for "Reality" — with the actual vendor costs, your markup percentages, and the real profit. Two spreadsheets that you pray stay in sync.

The Memory Trap

A client settled ₹20,000 via a personal UPI transfer — an off-platform payment. That amount needs to be "adjusted" in the final bill without appearing as a discount on the official invoice. You make a mental note. Three weeks later, when the client's next booking comes up, you've forgotten.

The Real Cost of the "Paper & Prayer" Method — 200 customers, 50 bookings/month
Leakage SourceDetailMonthly Loss
Forgotten carry-forwardsavg ₹3,000 × 5/month₹15,000/month
Markup errors (manual tracking)2 incidents/month₹8,000/month
Off-settlements never reconciled₹12,000/month
Estimated Margin Leakage₹35,000/month
Annual loss₹4,20,000/year
Common Mistake
The biggest risk isn't just lost profit — it's compliance. If a tax auditor compares your bank entries against your invoices and the numbers don't match because of untracked off-settlements, you face penalties, interest charges, and potential notices under Section 73/74 of the CGST Act.
MoonTripMoonTrip
Manual ProcessTrack advances in Excel cellsRemember carry-forward balancesManual credit note creationHope you don't forget a refundMonth-end reconciliation nightmare
With MoonTripPer-customer advance ledgerFIFO auto-apply to bookingsCredit notes auto-generatedRunning balance always visiblePDF export with audit trail
Manual process vs MoonTrip — see the difference

The MoonTrip Way: Professional Profit Protection

MoonTrip replaces the notebook, the dual spreadsheets, and the memory trap with a system that's built for how travel agencies actually work — markups, off-settlements, and all.

1. Dual Invoicing: The "Clean" Way to Protect Hidden Markups

Travel agents need to provide a professional invoice to the customer while keeping vendor net rates private. MoonTrip generates two distinct views of the same booking — automatically, simultaneously, and both 100% GST-compliant.

MoonTripMoonTrip
Customer Invoice
Hotel (3N)     ₹36,000Cab            ₹4,500Sightseeing   ₹6,000Proc. Fee     ₹2,500GST @18%      ₹450Total         ₹49,450
Passenger sees this
VS
Internal EXT Invoice
Hotel (3N)     ₹36,000  Vendor ₹24,000 + Markup ₹12,000Cab            ₹4,500  Vendor ₹3,200 + Markup ₹1,300Sightseeing   ₹6,000  Vendor ₹4,800 + Markup ₹1,200Proc. Fee     ₹2,500GST @18%      ₹450Total         ₹49,450Net Profit    ₹14,500  Vendor Cost ₹32,000 · Margin ₹14,500
Agency sees this
One booking generates two invoices — customer pricing stays separate from agency margins

The Outward View: Customer-Facing Tax Invoice

This is what the passenger sees — a clean, branded invoice showing:

  • Service Package Total: The selling price you set — not the vendor's net rate
  • Processing/Service Charge: A transparent fee for your agency's service
  • GST: Correctly calculated based on your billing model (Pure Agent or Principal)
  • Your agency branding: Logo, GSTIN, contact details — professional and trustworthy

The Inward View: Internal Profit Dashboard

This is what only your agency sees — a comprehensive breakdown showing:

  • Vendor Net Rate: What you actually paid the supplier
  • Exact Markup: The difference between vendor cost and customer price, per line item
  • Markup Percentage: Your margin percentage on each service
  • GST Liability: Tax owed on the margin (Pure Agent) or full value (Principal)
  • Net Profit: Your actual earnings after all deductions
Dual Invoice in Action
Customer Invoice
Rajasthan Tour Package₹85,000
Processing Charge₹3,500
GST @18% on Proc. Charge₹630
Customer Pays₹89,130
Internal EXT Invoice
Vendor Net Cost₹62,000
Hidden Markup₹23,000 (37.1%)
Processing Charge₹3,500
Total Margin₹26,500
GST Liability (on margin)₹4,770
Net Profit₹21,730
MoonTrip dual invoice system showing customer-facing package invoice on the left and internal profit breakdown with vendor net rates and markup percentages on the right for Indian travel agencies
Customer sees the package price. Agency sees the vendor cost, markup, and net profit — simultaneously generated.
The MoonTrip Way
Both invoices are generated from the same booking data. Change a hotel price in the quote, and both the customer invoice and internal margin invoice update automatically. No manual reconciliation, no sync errors, no second spreadsheet.

2. Balance Settlements & "Roll Forward" Logic

In travel, clients don't always want the full amount reflected on a single tax invoice. Sometimes a portion was settled via an off-platform contra-adjustment. Sometimes the client paid an advance that needs to be applied. Sometimes a cancellation refund needs to roll into the next booking.

In the notebook world, these "rolled forward" amounts get lost. In MoonTrip, they're tracked to the rupee.

How Roll-Forward Works

Balance Roll-Forward — Linked to Original Invoice
BookingDetailAmount
#102 — Goa TripInvoice Amount₹55,000
Customer Paid₹55,000
Off-Platform Adjustment₹15,000
Billed on Invoice₹40,000
Carried Forward₹15,000
#115 — Rajasthan TripInvoice Amount₹85,000
Balance Applied (from #102)−₹15,000
Customer Still Owes₹70,000
  • Every carry-forward is linked: Unlike a notebook entry, MoonTrip links every rolled-forward amount back to the Original Invoice (OG) for complete traceability
  • Apply on demand: When creating or editing a booking, you can check available balances and choose to apply them — fully or partially — to any future invoice, or create a new settlement invoice just for the balance
  • Partial application: A ₹15,000 balance can be split — ₹10,000 to one booking, ₹5,000 to another
  • PDF audit trail: Export the complete ledger with every credit, debit, and running balance per customer
MoonTripMoonTrip
DateDescriptionCreditDebitBalance
Jan 5Advance via UPI₹50,000₹50,000
Jan 12Goa Booking #102₹42,000₹8,000
Feb 20Kashmir Cancellation Refund₹50,000₹58,000
Mar 1Rajasthan Booking #115₹55,000₹3,000
How customer advances flow through the ledger — deposits, auto-applications, and running balance

3. Managing "Off-Settlements" Without the Mess

An off-platform settlement is a payment or credit applied to a booking that is settled outside the standard banking flow — via personal UPI, contra-entry, or cash adjustment. A customer settles a portion of the booking this way, and in the manual world, it breaks the accounting chain completely.

The Problem with Untracked Off-Settlements

  • Invoice shows ₹85,000 pending, but ₹20,000 was already settled off-platform
  • Your app shows the customer still owes ₹85,000 — triggering false payment reminders
  • Your bank records show ₹65,000 received, but the invoice says ₹85,000 — audit mismatch
  • At month-end, you can't explain the ₹20,000 gap without digging through WhatsApp messages

How MoonTrip Handles It

MoonTrip allows you to mark a portion of the booking as "Settled via Off-Platform Adjustment":

Off-Platform Settlement FlowBooking Total = ₹85,000 Payment Received (Bank) = ₹65,000 Off-Platform Adjustment = ₹20,000 ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Customer Pending Balance = ₹0 ✓ Official GST Invoice = ₹85,000 (unchanged) Bank Receipt = ₹65,000 (matches bank statement) Off-Platform Record = ₹20,000 (internal tracking) Result: ✓ Customer's balance is closed — no false reminders ✓ GST invoice stays at ₹85,000 — compliant ✓ Bank records match actual receipts — audit-ready ✓ ₹20,000 adjustment is tracked internally with source & date
  • Balance closure: The customer's pending amount drops to zero — no more incorrect "Unpaid" reminders going out via WhatsApp
  • Invoice integrity: The official GST invoice remains unchanged at the full amount — your GSTR-1 and GSTR-3B filings stay clean
  • Internal tracking: The off-platform amount is recorded with a date, reference, and notes — visible on the customer's ledger but not on the tax invoice
  • Reconciliation: At month-end, you can see exactly which bookings had off-platform adjustments and verify them against your records
MoonTrip off-platform settlement interface showing booking total, bank payment received, off-platform adjustment amount, and customer balance reconciliation for travel agency accounting
Off-platform adjustment recorded — customer balance closed, GST invoice unchanged, fully traceable
The MoonTrip Way
MoonTrip doesn't judge how your clients settle — it just makes sure every rupee is tracked. Off-platform adjustments, contra-entries, voucher-based settlements — all recorded with full traceability so your official accounts stay clean and your actual profits are always accounted for.

Why This Matters for Your Business Growth

By using Dual Invoicing and Smart Settlements, travel agencies achieve three things that the "Paper & Prayer" method can never deliver:

1. Professionalism

Your customer receives a clean, branded PDF invoice without seeing your behind-the-scenes math. The vendor net rate, your markup percentage, and internal margin calculations are invisible. This builds trust and positions your agency as organized and reliable.

2. Accuracy

You never lose track of a carried-forward balance. Every ₹500 advance, every ₹15,000 off-platform adjustment, every cancellation refund — all linked back to the original invoice with a complete audit trail. Your Actual Profit is always collected because the system remembers what you can't.

Accuracy Impact — Before vs After MoonTrip
MetricBefore (Manual)After (MoonTrip)
Forgotten carry-forwards~5/month0
Avg lost amount per incident₹3,000
Balance visibilityScattered across sheetsApply on demand
Off-settlement trackingNot trackedTracked to source
Annual margin leakage₹1,80,000₹0

3. Compliance

Your official accounts remain 100% GST-ready. The system handles the tax math separately from the settlement method. Whether a customer pays via bank transfer, UPI, or an off-platform adjustment, the GST invoice stays correct and your GSTR-1/GSTR-3B filings are always accurate.

  • GST invoices reflect the full taxable value — regardless of how payment was collected
  • Credit notes are auto-generated for cancellations and refunds with correct tax reversals
  • GSTR-1 data is exportable with B2B/B2C categorization and HSN/SAC codes
  • Audit trail shows every payment, adjustment, and carry-forward with dates and references
Tip
The difference between a "secret notebook agent" and a "professional agency" isn't the size of the markup — it's the quality of the tracking. Customers trust agencies that provide clean documentation. Auditors respect agencies with traceable records. MoonTrip gives you both.

Stop calculating manually

MoonTrip automates GST, invoicing, and profit tracking for Indian travel agencies.

Get Started Free