ITC ready to claim
₹74,820
matched to GSTR-2B
18% vs Mar
IRN capture rate
28 / 29
96.6%
2.3% vs Mar
Books closed ?
Tue 3:40
target: Wed EOD
1.4 days earlier
Total spend · Apr
₹7,83,325
29 bookings
9% vs Mar
Action needed
3 items
see anomalies below
▲ from 1 in Mar
IRN pending · 23 days ₹2,640 ITC at risk
Vistara IRN delayed for Apr 22 booking — auto-chasing the airline
Hardware 01 · BLR → BOM · NF90130368717664
Self-approval flagged ₹14,643 cancellation
People Lead approved her own cancellation — policy requires CFO/peer review
Cancelled BLR → BOM · 24 Apr · NF91152368798608
Department over budget ₹2.18L · 109%
Sales spent ₹18,420 over the ₹2L monthly travel budget — trend started Apr W2
Driven by 5 client visits to BOM in the last 10 days
Views
What you see in MMT today Added by Traviq
0 selected
Booking Traveller Purpose Type Dept · GL Route Dates Approver Channel Ref / IRN Policy+ traviq GST+ traviq Status+ traviq Comments Debit Refund
Apr 2026 totals · 29 bookings ₹7,83,325 ₹27,230
Wallet movement · 30 Apr 2026 · 23:59 IST · closing balance ₹4,73,095
IRN Date Supplier Supplier GSTIN Recipient GSTIN PoS Tx type Taxable CGST SGST IGST Gross 2B match
ITC ready to claim
₹74,820
● matched to GSTR-2B portal
ITC pending
₹2,640
1 IRN delayed · auto-chasing
ITC blocked
₹0
0 Section 17(5) cases

By transaction type

Transaction type Bookings Taxable value CGST SGST IGST ITC eligible
Inter-state (IGST) — supplier outside Karnataka225,84,00065,52065,520
Intra-state (CGST + SGST) — BLR hotels & KA suppliers448,0004,3204,3208,640
International / zero-rated — DXB, no GST2N/A
IRN pending — in chase queue114,6672,6402,640 ⏳
Total 29 6,46,667 4,320 4,320 68,160 ₹74,820 + ₹2,640 pending

By supplier state

Supplier registered in State code Bookings Taxable ITC eligible
Haryana (IndiGo, Vistara)HR-06143,12,80028,152
Maharashtra (Air India entities, OYO BOM)MH-2761,42,40012,816
Delhi (Vistara legacy, Treebo DEL)DL-07282,4007,416
Karnataka (Treebo BLR, ITC Windsor)KA-29448,0008,640
Tamil Nadu (Sangam CHE)TN-33236,4003,276
International (Emirates)991N/A

GSTR-2B reconciliation · 3-step flow

connected
Drumworks GSTN account linked via GST Suvidha Provider (GSP). Read-only access to GSTR-2B file fetch.
GSTIN · 27AASFD4920E1ZE · linked 14 Mar 2026
fresh
GSTR-2B for Apr 2026 fetched from GSTN portal. 247 supplier invoices including 28 travel invoices.
Last fetch · 1 May 06:00 IST · auto-refresh on 1st of every month
28 / 29 ✓
28 IRNs matched against GSTN portal · 1 pending (Vistara, chase day 25/25 SLA) · 0 mismatched.
Karthik (CFO) workflow: log in Monday 06:00, view this report, click "Share with CA / auditor" → RK & Associates gets a 30-day read-only link. Tally XML auto-imports overnight. By Tuesday 3:40 pm the books are closed.

Spend by department · Apr 2026 vs monthly budget

Cash flow · Apr 2026

Opening (1 Apr)₹2,29,190
topup02 Apr · UPI+ ₹5,00,000
Total debits (29 bookings)− ₹7,83,325
Total refunds (1 cancellation)+ ₹13,045
Closing (30 Apr · 23:59)₹4,73,095
May runway: at the Apr burn rate of ~₹26K/day, the current balance covers ~18 days. Cash-flow alert routed to Priya on 12 May.
Heads up: Sales spent ₹2.18L vs ₹2L monthly cap — 109% of budget. Pattern started Apr W2 with 5 BOM client visits.

Already booked · May 2026

₹3,42,600
11 bookings · 7 travellers · 4 routes

Probable additional · based on Apr pattern

₹4,82,000 ± ₹68K
forecast range · 80% confidence

Projected May total

₹8,24,600
▲ 5% vs Apr · tracking budget

Cash needed by 15 May

₹3,50,000
topup recommendation · Razorpay invoice ready

This week's travel · 11-17 May 2026

Mon
11
Tue
12
Wed · today
13
Thu
14
Fri
15
Sat
16
Sun
17
✈ Sales 01 · BLR→SIN
QBR · +1 colleague
⏳ Engineering Lead · BLR→SFO
Onsite · key account
✈ Sales 01 · SIN→BLR
↩ Engineering Lead · SFO→BLR
Returns from US
4 trips this week · 3 travellers · 1 awaiting approval
Hover a chip for route & status · click to open trip

Upcoming trips needing approval

Traveller Route Date Reason Est. cost Policy Status
Engineering Lead
Engineering · GL 60702
BLR → SFO 06–14 May Customer onsite · key account ₹1,38,400 soft exception ⏳ awaiting CFO
Engineer 01 · +1
Sales · GL 62103
BLR → SIN 12–14 May Quarterly customer review ₹84,200 in policy ✓ auto-approved
People Lead
People Success · GL 61501
BLR → BOM hotel 19–22 May New hire orientation ₹38,500 in policy ✓ auto-approved
Hardware 01 · +2
Device · GL 60504
BLR → CHE 23 May Vendor site visit ₹16,200 in policy ✓ auto-approved

Department forecast · May

Department Apr actual May committed May probable add May projected Budget vs budget
Sales2,18,4201,24,0001,38,0002,62,0002,00,000▲ 131%
Engineering1,68,2001,38,40042,0001,80,4001,80,000▲ 100%
Product1,12,40042,00068,0001,10,0001,20,000▼ 92%
Corporate Operations84,92022,00058,00080,00090,000▼ 89%
People Success68,44038,50032,00070,50080,000▼ 88%

Apr 2026 exports

MakeMyTrip-format CSV
Drop-in replacement for your current MMT monthly sheet — same column headers, same row order, same totals row, same closing balance.
GSTR-2B-ready CSV
IRN, supplier GSTIN, taxable value, CGST/SGST/IGST, PoS. Drop next to GSTN portal file; row-by-row IRN match.
Tally XML voucher pack
29 vouchers, auto-numbered against Bureau's voucher series, GL-coded against chart of accounts. One-click import.
Zoho Books CSV
Native Zoho Books format with cost-center mapping. Imports without remapping.
ClearTax reconciliation pack
CSV optimised for ClearTax's GSTR-2B match workflow + a per-supplier summary.
Audit trail PDF
One PDF, one page per booking (~30 pages for Apr) — approval thread links, IRN + GSTIN + cost-center, for IT scrutiny defence.
Auto-export schedule: All six formats land in Priya’s inbox at 06:00 IST on the 1st of every month. Tally XML also syncs directly to your Tally Server if connected.

Recent exports

Run atPeriodFormatByRowsFile
01-05-2026 06:00 ISTApr 2026Audit trail PDFauto29apr-2026-audit-trail.pdf · 412 KB
01-05-2026 06:00 ISTApr 2026Tally XMLauto29apr-2026-tally.xml · 18 KB
01-05-2026 06:00 ISTApr 2026GSTR-2B CSVauto28apr-2026-gstr2b.csv · 4.3 KB
28-04-2026 15:22 ISTApr 2026 (mid-month)MMT CSVadmin2@avgeek.in22apr-mid-month.csv · 3.1 KB
01-04-2026 06:00 ISTMar 2026Audit trail PDFauto24mar-2026-audit-trail.pdf · 348 KB
Traviq · operated by Drumworks Ventures · GSTIN 27AASFD4920E1ZE · IATA via TravClan + Tripjack · Payments via Razorpay (RBI-PA licensed)