Popular reconciliation template
IRCTC Reconciliation
Reconcile IRCTC bookings with payments, cancellations, refunds, commissions, settlements, and bank receipts in one structured workflow.
View demo reportReconcile IRCTC bookings with payments, refunds, and settlements
IRCTC-related reports can include ticket bookings, passenger references, PNRs, payment status, cancellations, refunds, TDR adjustments, commissions, settlement amounts, and bank receipts. Cointab helps bring these into a clear reconciliation report.
The IRCTC reconciliation workflow helps finance teams compare ticket booking records with payment, refund, settlement, and bank data.
This helps finance teams answer questions such as:
- Which IRCTC bookings were successfully paid?
- Which bookings are present internally but missing in payment or settlement data?
- Which payment records do not have a matching booking?
- Which cancelled tickets were refunded correctly?
- Which TDR, cancellation, refund, or adjustment entries explain the difference?
- Which commissions, service charges, or deductions affect the final settlement?
- Which settlement amounts match bank receipts?
- Which items need follow-up or internal review?
This template is useful for travel companies, ticketing platforms, finance teams, accounting teams, and businesses that need a repeatable IRCTC reconciliation process.
Required files for this template
Cointab's ready-made workflow is designed around IRCTC booking records and related payment, refund, settlement, and bank reports used for ticket reconciliation.
| Data source | Example records |
|---|---|
| IRCTC Booking Report | Used as the transaction-level report containing booking references, PNRs, ticket details, passenger or customer references, booking dates, fare amounts, and ticket status. |
| Payment Report | Used to compare booking records with payment transactions from payment gateways, internal payment systems, collection reports, or partner payment data. |
| Settlement Report | Used to compare booking and payment activity with settlement-level data, payout records, commission entries, deductions, or final receivable amounts. |
| Cancellation / Refund Report | Used where cancelled tickets, refunds, partial refunds, failed bookings, or refund adjustments need to be reconciled separately or enriched into the workflow. |
| TDR / Adjustment Report | Used where TDR claims, ticket adjustments, delayed refunds, or railway-side adjustments need to be reviewed in detail. |
| Bank Statement | Optional, but useful if the finance team also wants to compare settlement or payout amounts with actual bank credits. |
| Internal ERP / Books Report | Optional, but useful if the finance team wants to compare IRCTC booking and settlement data with accounting, ERP, receivable, or revenue records. |
| Supporting Data | Optional supporting files can be used for PNR mapping, booking reference mapping, route or travel-date enrichment, customer mapping, commission logic, tax logic, or other enrichment. |
What Cointab matches in IRCTC reconciliation
Cointab compares booking, payment, cancellation, refund, adjustment, settlement, and bank information across IRCTC and internal reports.
Booking and payment records
Match IRCTC bookings, PNRs, or ticket references with corresponding payment transactions.
Cancellations and refunds
Identify whether cancelled tickets, failed bookings, and refund transactions are correctly reflected across booking, payment, and refund reports.
TDR and adjustment records
Review TDR claims, delayed refund adjustments, partial refund differences, or other ticket-related adjustments where available.
Commissions and deductions
Track commissions, service charges, payment charges, taxes, deductions, or settlement adjustments where available.
Settlement and receivable amounts
Compare expected settlement or receivable amounts with actual settlement records and bank credits.
Bank and books records, if added
If bank statements, ERP, or books data are included, Cointab can also compare IRCTC settlement records against bank receipts and accounting entries.
Common IRCTC reconciliation exceptions
Cointab helps finance teams focus on differences instead of manually reviewing every booking, payment, refund, and settlement entry.
Booking not found in payment report
A booking appears in the IRCTC or internal booking report but is not found in the payment report for the selected period.
Payment without matching booking
A payment entry appears without a clear matching PNR, ticket, booking reference, or internal order record.
Amount mismatch
The booking or payment reference matches, but the expected fare amount and collected or settled amount are different.
Refund difference
A cancellation or refund appears in one report but does not match the expected refund record in another report.
TDR or adjustment difference
A TDR claim, ticket adjustment, delayed refund, or partial refund creates a difference that needs review.
Commission or deduction difference
Commissions, service charges, payment charges, taxes, or other deductions explain part of the difference between booking value and settlement value.
Settlement timing difference
A booking, refund, or adjustment belongs to one period but is settled or received in a later cycle.
Bank receipt mismatch
The settlement amount does not match the amount received in the bank statement.
Duplicate or repeated entry
The same booking, PNR, payment, refund, or settlement entry appears more than once or is included in multiple files.
Missing or unclear reference
PNR, ticket number, booking ID, payment reference, settlement ID, or bank reference is missing, incomplete, or appears inside a description field.
Skipped record
A row cannot be reconciled because required data is missing, invalid, duplicate, incomplete, or unusable.
How this ready-made reconciliation works
Cointab pre-configures the workflow so your team does not need to rebuild the IRCTC reconciliation setup every period.
Select the template
Choose IRCTC Reconciliation from popular reconciliations.
Select the period
Choose the day, week, month, quarter, year, lifetime period, or custom period you want to reconcile.
Upload IRCTC and payment reports
Upload your IRCTC booking report, payment or settlement report, and any required cancellation, refund, TDR, bank, or supporting files.
Validate file format
Cointab checks whether the uploaded files match the expected structure and highlights missing or incorrect columns.
Run reconciliation
Cointab applies predefined data preparation and matching logic for IRCTC booking, payment, refund, and settlement data.
Review output
View fully matched, partially matched, unmatched, and skipped records.
Download or automate
Download the Excel report, or automate future data input and output through email, SFTP, or APIs.
Structured matching first, AI assistance for difficult cases
Cointab applies structured reconciliation logic first, then uses AI to help with difficult open transactions where fixed rules are not enough.
Structured matching
Structured matching can use:
Matching scenarios
One-to-one
One IRCTC booking matches one payment, refund, or settlement entry.
One-to-many
One booking maps to multiple records such as payment, commission, cancellation, refund, TDR, adjustment, or settlement entries.
Many-to-one
Multiple bookings are grouped into one settlement or bank receipt.
Many-to-many
Multiple booking records and multiple payment or settlement records are grouped and compared.
Partial matching
Identifiers match, but amounts differ.
Net and contra matching
Bookings, cancellations, refunds, commissions, deductions, adjustments, and settlements are netted where required.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- References are incomplete
- PNR or booking references are missing or inconsistent
- Descriptions contain embedded ticket, payment, or settlement references
- Refund or TDR entries do not directly map to bookings
- Amounts require contextual understanding
- Booking and settlement dates fall in different periods
- Multiple possible matches exist
AI exception analysis
For transactions that remain open, AI can help identify possible reasons such as:
AI assists matching and exception review, but Cointab keeps reconciliation transparent, reviewable, and audit-friendly.
Audit-ready IRCTC reconciliation reports
Cointab gives your team a clear report showing which IRCTC bookings, payments, refunds, and settlements matched, partially matched, remained unmatched, or were skipped.
Report categories
Fully matched
IRCTC booking, payment, refund, or settlement records where identifiers and amounts match.
Partially matched
Records where identifiers match but amounts differ.
Unmatched in booking report
Payment, refund, settlement, or bank records that do not clearly match IRCTC booking records.
Unmatched in payment or settlement report
IRCTC bookings, cancellations, or refund records that are not found in payment or settlement data.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.
Report capabilities
- Summary cards
- Transaction-level details
- Filters for review
- Difference amounts
- Matched transaction drill-down
- Manual match
- Undo manual match
- Excel export
- Audit-friendly output
Automate recurring IRCTC reconciliation
Once this workflow is stable, Cointab can automate file input, reconciliation runs, and output delivery.
Bring data into Cointab
Data can be received or pulled through:
Run automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- Matched IRCTC bookings
- Unmatched booking records
- Unmatched payment records
- Refund differences
- TDR or adjustment differences
- Commission or deduction differences
- Settlement differences
- Bank receipt differences
- Open items
- Suggested actions
- Excel reconciliation report
- Structured API output
View an IRCTC reconciliation demo report
See how Cointab presents IRCTC reconciliation output with matched, partially matched, unmatched, and skipped transactions.
IRCTC Reconciliation Demo
Explore a sample report showing bookings, payments, cancellations, refunds, TDR adjustments, settlements, bank receipts, and open items.
View demo reportExplore related travel and payment reconciliations
Cointab supports other booking, payment, settlement, and bank reconciliation workflows.
Sales vs Payment Gateway
Reconcile website or app sales with PSP payments, refunds, fees, and settlements.
View templateBank Statement vs Sales Receipts
Match bank credits with expected sales or collection records.
View templateSales vs Returns vs Refunds
Reconcile sales, cancellation, return, and refund transactions together.
View templateBuilt for teams reconciling IRCTC bookings, refunds, and settlements
This template is useful for teams that regularly reconcile ticket bookings, payments, cancellations, refunds, settlements, and bank receipts.
Travel companies
For travel businesses handling IRCTC-related booking, payment, refund, and settlement data.
Ticketing platforms
For platforms that need to reconcile ticket bookings with payment, cancellation, refund, and settlement records.
Finance teams
For teams handling high-volume booking records, payment reports, refund reports, and settlement differences.
Accounting teams
For teams preparing reconciliation reports for month-end close, books, receivables, revenue review, and audit.
Operations teams
For teams that need visibility into booking status, payment status, refund status, and open exceptions.
Outsourced finance teams
For accounting firms or finance operations teams handling ticketing or travel reconciliation for multiple clients.
Trusted by teams handling travel and payment reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across bookings, payments, refunds, banks, partners, and internal systems.
“We have worked on many softwares but we love the ease of using cointab. The staff and support is very instant. They are approachable, proficient and patient. Team is very cooperative with the customisations. The experience of using cointab was nice.”
IRCTC Reconciliation FAQs
Start IRCTC reconciliation
Use Cointab's ready-made IRCTC reconciliation workflow to match bookings, identify payment and refund differences, review exceptions, and export audit-ready reports.
View demo reportReady-made workflow · Reusable every period · Manual upload and automation supported