Steps to be taken to generate mis reports for ticket booking through point of sale pos machine
GOVERNMENT OF INDIA (BHARAT SARKAR)
MINISTRY OF RAILWAYS (RAIL MANTRALAYA)
RAILWAY BOARD
No.2025/TG-I/101PIPayment through electronic means Pt.II
New Delhi, dated 12.01.2025
Chief Commercial Managers,
All Zonal Railways
Manager Director, CRIS,
Chanakyapuri,
New Delhi.
COMMERCIAL CIRCULAR NO. 8 of 2025
Sub: Steps to be taken to generate MIS reports for ticket booking through Point of Sale (POS) machine.
Ref: Commercial Circular nos. 69/2025 dated 10.12.2025 & 70/2025 dated 23.12.2025.
Instructions regarding accounting procedure for remittance of traffic earnings received through POS machines installed by SBI have already been issued to Zonal Railways vide above referred commercial circulars under Board’s letters no. 2015/TG-I/10/P/Payment through electronic means Pt.II dated 10.12.2025 and 23.12.2025.
However, for the purpose of generating MIS reports for the transactions through POS machines for the ticket booking) following procedure may be adopted:
1. As and when, a POS is installed, the following information shall, be fed in the PRS/UTS terminal connected with SBI POS-
a) Bank Code (SB for State Bank)
b) Service Provider identification for the POS machine (World Line/Hitachi)
c) 8 digit alpha-numeric identification number of the POS machine (POS machine ID number)
The above information shall be fed by database console staff in PRS system and Chief booking Supervisor in UTS system. The POS machine attached to one PRS/UTS terminal shall not be changed or connected to any other terminal in normal course, It has to be ensured that if POS machine is changed the above details are updated by the respective staff and then only used for transactions. In case of PRS, the change in POS ID shall be effective only on next day. So, the change in POS machine, if required, shall be done after end of evening shift. It should be ensured that the location of SBT POS matches with that defined in terminal database of PRS/UTS application.
2. For the proper MIS generation, while booking the tickets, following details shall be fed by the booking/reservation clerk:-
a) Last 4 digits of debit/credit card no.
b) Payment Card Service Provider (MCIVCIRU for Master, VISA, RUPAy)- This is planned to be captured in PRS only.
c) Payment Card type (Debit/Credit).
d) 12-digit Receiver Registration Number (RRN no.)
(RRN Number is the booking reference number printed on the ‘charge slip’ printed by the POS machine for every transaction).
All Zonal Railways are requested to ensure compliance of these instructions.
Sd/-
(Amit Kumar Jain)
Director Traffic Commercial (G)
Railway Board
Click To Download the Original Order
Source : http://www.indianrailways.gov.in/
To generate MIS (Management Information System) reports for ticket bookings through Point of Sale (POS) machines in Indian Railways, follow these structured steps. These reports help monitor transactions, reconcile refunds, track revenue, and audit sales.
Contents
- 1 ✅ Steps to Generate MIS Reports for POS-Based Ticket Booking
- 1.1 📌 1. Access the Authorized Reporting Portal
- 1.2 📌 2. Login with Proper Credentials
- 1.3 📌 3. Navigate to POS Transactions or e-Payment Section
- 1.4 📌 4. Select Report Type
- 1.5 📌 5. Generate & Export the Report
- 1.6 📌 6. Verify with Bank Records
- 1.7 📌 7. Submit to Commercial Inspector or Accounts Department
- 2 🛠️ Tools Often Involved
✅ Steps to Generate MIS Reports for POS-Based Ticket Booking
📌 1. Access the Authorized Reporting Portal
- Use the CRIS (Centre for Railway Information Systems) portal or the Commercial Console provided by Indian Railways to authorized staff.
- URL: Typically an intranet link (used internally by railways staff); may differ by zone/division.
- POS machines (like SBI, HDFC, Axis) also have bank-specific dashboards for transaction data.
📌 2. Login with Proper Credentials
- Enter your username/password assigned to your ticket counter/station.
- Use 2FA or OTP if enabled.
- Select Station Code or POS ID if applicable.
- Choose
Reports>POS Transactionsore-Payment MIS. - Select:
- Date range (e.g., daily, weekly, monthly)
- Station name
- POS provider (SBI/Axis/etc.)
📌 4. Select Report Type
Common types of MIS reports available:
| Report Type | Purpose |
|---|---|
| Daily Booking Summary | Shows total number of tickets sold through POS |
| Revenue Collection Report | Shows gross and net revenue via POS transactions |
| Refund Report | Details all cancellations and refund statuses via POS |
| Transaction Reconciliation | Cross-checks successful payments vs settlements |
| POS Settlement Report (Bank-wise) | Used to reconcile payments with bank partners (SBI, HDFC, etc.) |
| TDR Report (if applicable) | Refunds processed offline where bank terminal wasn’t present |
📌 5. Generate & Export the Report
- Click
GenerateorRun Report. - You can view online or download the report in:
- Excel (
.xlsx) - CSV
- Excel (
Use filters such as Train No., Class, Counter Operator, etc., for granular analysis.
📌 6. Verify with Bank Records
- Cross-verify POS transaction logs with:
- Bank merchant statements
- IRCTC/CRIS backend data
- POS terminal slip summary
This ensures refunds, failed transactions, and chargebacks are correctly accounted.
📌 7. Submit to Commercial Inspector or Accounts Department
- Based on local Railway zone rules, MIS reports are:
- Reviewed daily/weekly
- Submitted to Senior DCM or Dy. Commercial Manager
- Audited periodically by Railway Accounts
🛠️ Tools Often Involved
- CRIS Ticketing Backend System
- UTS/PRS Console
- POS Dashboard (Bank-specific)
- Indian Railways Commercial Portal
- Tally / Internal ERP systems for revenue mapping (in some divisions)
If you’re looking to automate this reporting, integrate POS logs with CRIS APIs or internal systems through scripting tools (e.g., Python or Excel macros). I can help design a template or script if needed.
Would you like a sample report format or Excel template for this?