Vendor Accounting for Indian Travel Agencies — Full Accounting Suite

Why Vendor Accounting Is Where Spreadsheets Break

Most travel-agency software stops at quotes and customer invoices. The vendor side — DMC bills, B2B portal invoices, airline consolidator statements, hotel folios, transport vouchers — is left for the accountant to re-enter into Tally or a spreadsheet at month-end.

That gap is where Indian agencies lose money:

• •ITC on vendor bills missed because per-line CGST/SGST/IGST never got captured properly
• •TDS deductions on vendor commission either skipped or applied at the wrong section
• •Bank transfers paid against the wrong vendor account, breaking reconciliation
• •Vendor advances forgotten because they were tracked in a sheet, not a ledger
• •Trip-wise profit wrong because actual vendor cost never made it back to the booking

MoonTrip closes that gap by carrying every vendor transaction through to the books in the same product that handles your customer side.

MoonTrip

Manual Process✕Track advances in Excel cells✕Remember carry-forward balances✕Manual credit note creation✕Hope you don't forget a refund✕Month-end reconciliation nightmare

With MoonTrip✓Per-customer advance ledger✓FIFO auto-apply to bookings✓Credit notes auto-generated✓Running balance always visible✓PDF export with audit trail

Vendor Master — More Than an Address Book

The Vendor Master is the canonical record of every DMC, hotel, airline consolidator, or B2B portal you work with. Each vendor carries:

• •Identity: Vendor name, status (active / inactive), service tags (flight, hotel, transport, activity, visa, forex, etc.) — used to filter vendor selection on quotes.
• •GST: GSTIN with format validation (auto-derives PAN and state code), GST registration type. Hidden entirely when the tenant's GST toggle is off.
• •Contact & Address: Phone, email, billing address with state code (drives place-of-supply for CGST/SGST vs IGST on input).
• •Payment Terms: Net-15, Net-30, Net-45, or custom — feeds aged-payables.
• •Bank Accounts: Multiple bank accounts per vendor with IFSC validation, account-number masking to last 4 digits, and primary-bank flagging.
• •Accounting: Mapped to a vendor ledger under Sundry Creditors; carries an opening balance entry if migrated from another system.

Multi-Line Vendor Bills — One Invoice, Many Services

A DMC sends you a single invoice for a Goa package — but it covers 3 nights at a hotel, a round-trip transfer, and an activity day. That's one bill, three line items. Each line has its own service charge, its own GST split, and its own ITC eligibility.

What a multi-line bill carries

• •Bill header: Internal voucher number, voucher date, vendor invoice number, vendor invoice date, booking link, service-type, total net payable.
• •Per-line item: Service type, charges (or base fare + all-other-charges for flight), per-line CGST/SGST/IGST, ITC eligibility flag, narration, and an optional link back to one or more quote-service keys on the originating booking.
• •Per-line round-off: Each line can carry its own rounding adjustment for paise-level reconciliation against the vendor PDF.

The link from a bill line back to a quote service key is what makes trip-wise P&L accurate. When a vendor invoices for hotel + transport on a single bill, each line's Cost of Travel posts against the right service on the booking — not bundled.

Bill-Level Charges — Processing Fee, Commission, TDS

One mistake most travel-agency tools make: putting processing fee, commission, and TDS at the line level. DMCs and consolidators almost never invoice that way. They send one consolidated processing fee + one commission per invoice, regardless of how many services it covers.

MoonTrip captures these at the bill header — one each, per bill — with their own GST split where applicable.

• •Processing Fee + GST: Single amount per bill with separate processing_cgst / processing_sgst / processing_igst so input credit on the service fee posts cleanly, separate from input credit on the service charges.
• •Commission Earned: Single commission_gross per bill that credits Vendor Commission Income on the P&L. Captured net of TDS.
• •TDS Deductible: Single TDS deduction per bill with tds_section (194H for commission, 194C for contractors, 195 for non-resident), tds_rate, and tds_on_amount. Posts to TDS Payable for Form 26Q quarterly filing.
• •Bill Round Off: One final round-off line so the bill total matches the vendor PDF to the rupee.

Input Tax Credit (ITC) on Vendor Bills

Indian travel agencies registered under GST are entitled to claim Input Tax Credit on services purchased from GST-registered vendors. To claim it cleanly, three things must be true: the vendor invoice carries a valid GSTIN, the CGST/SGST/IGST is captured per line, and the input ledgers reconcile against GSTR-2B downloaded from the GST portal.

MoonTrip handles all three:

• •GSTIN on the vendor: Captured + validated on the Vendor Master. Without it, the bill cannot post ITC.
• •Per-line GST split: Place of supply (derived from vendor + agency state codes) decides CGST/SGST vs IGST. Multi-line bills split correctly even when one bill mixes intrastate and interstate lines.
• •Input ledgers under Duties & Taxes: Input CGST, Input SGST, Input IGST — each posted from the purchase journal. The Input GST report aggregates by period and exports for GSTR-2B reconciliation.

Multi-Bill Vendor Payments — One Transfer, Many Bills

When you pay your DMC ₹1,20,000 by NEFT, that single bank transfer often clears multiple open bills. The Tally-grade way to record it is one payment with explicit per-bill allocations — not a guess at which bill it cleared.

Allocation modes

• •Allocate to specific bills: Pick the open bills + enter per-bill amounts. Sum must be ≤ total payment amount.
• •Full advance: Pay the vendor with no specific bill allocation. The full amount sits as vendor advance (unallocated_amount), ready to apply to future bills.
• •Partial allocation: Allocate part of the payment to specific bills; the surplus becomes vendor advance.

Bank-Account-Aware Journals

A common cause of broken bank reconciliation: payments posted against a single default Bank ledger when the actual transfer went out from a specific account. If you operate two current accounts and a CC, your default-bank-only journals will never reconcile to either statement.

Every vendor payment in MoonTrip carries a bank_account_id at creation time. The journal credits the actual bank ledger picked — HDFC Current, ICICI Current, Cash, etc. Bank statement reconciliation then runs per-account, against the right ledger.

Void with Reason — The Right Way to Undo

Vendor bills and payments accumulate. Sometimes a bill is entered against the wrong vendor, or a vendor cancels a service after billing. The accounting-grade way to undo is void with reason — never delete.

• •Active bill, no payments: Can be deleted outright (hard delete, removes journal + lines + bill row).
• •Active bill, has payments: Delete is blocked. Void instead — flips status to voided, captures void reason + voided_at + voided_by, posts a reversal journal (Dr/Cr flipped, source_booking_id preserved). Each allocated bill's amount_paid is reversed automatically.
• •Voided bill: Renders muted with a "voided" pill on the booking page and vendor ledger. Audit trail intact.

Vendor Opening Balance — Migrating from Tally

Most agencies don't adopt MoonTrip on Day 1 of the financial year. They migrate mid-year carrying open bills with vendors. The opening balance entry captures that starting state cleanly without polluting the purchase journals.

• •Simple mode: Single Dr/Cr amount. Useful when you only know the net closing balance from your prior system.
• •Bill-wise mode: Multiple opening bills with vendor invoice number, date, and amount each. Useful when aged-payables should reflect actual bill dates.
• •Voucher number = NULL: Opening entries post with no voucher number (they aren't vouchers — they're seed balances), and they're excluded from voucher numbering.
• •Reversible: Only while the vendor has no other activity. Once a real bill or payment lands, the opening entry is locked.

Vendor Ledger Statement with Drill-Down

The Vendor Ledger Statement is the single screen that proves vendor accounting works end-to-end. Per-vendor, date-range filtered, with every Dr/Cr line, running balance, opening, totals, and closing.

• •Row types: Purchase, Void, Payment, Opening, Credit Note, Debit Note — colour-coded.
• •Click-through: Bill rows open the multi-line Bill View modal; payment rows open the payment detail with allocation breakdown.
• •Date range: Defaults to current Indian financial year (Apr 1 → today). Custom ranges supported.
• •Export: PDF + Excel — clean enough to hand to your auditor.

How Vendor Data Feeds Trip-wise + Company P&L

Vendor accounting isn't an island. Every vendor bill line that's linked to a quote-service key on a booking updates that booking's actual Cost of Travel. If the actual differs from the estimated cost in the quote, the variance auto-posts to Provisional Hidden Markup.

Vendor commission income credits the P&L. Processing fees flow to Vendor Service Fees. TDS deducted on vendor commission credits TDS Payable for the quarterly return.