{"id":5978,"date":"2025-08-06T11:35:59","date_gmt":"2025-08-06T11:35:59","guid":{"rendered":"https:\/\/railtravels.org\/?p=5978"},"modified":"2025-08-06T11:35:59","modified_gmt":"2025-08-06T11:35:59","slug":"steps-to-be-taken-to-generate-mis-reports-for-ticket-booking-through-point-of-sale-pos-machine","status":"publish","type":"post","link":"https:\/\/www.reilsolar.com\/train\/steps-to-be-taken-to-generate-mis-reports-for-ticket-booking-through-point-of-sale-pos-machine\/","title":{"rendered":"Steps to be taken to generate mis reports for ticket booking through point of sale pos machine"},"content":{"rendered":"
\n

Steps to be taken to generate MIS reports for ticket booking through Point of Sale (POS) machine<\/strong><\/p>\n<\/header>\n

\n

GOVERNMENT OF INDIA (BHARAT SARKAR)<\/strong>
\nMINISTRY OF RAILWAYS (RAIL MANTRALAYA)<\/strong>
\nRAILWAY BOARD<\/strong><\/p>\n

No.2025\/TG-I\/101PIPayment through electronic means Pt.II<\/p>\n

New Delhi, dated 12.01.2025<\/p>\n

Chief Commercial Managers,<\/strong>
\nAll Zonal Railways<\/strong><\/p>\n

Manager Director, CRIS,<\/strong>
\nChanakyapuri,
\nNew Delhi.<\/p>\n

COMMERCIAL CIRCULAR NO. 8 of 2025<\/strong><\/p>\n

Sub:\u00a0Steps to be taken to generate MIS reports for ticket booking through Point of Sale (POS) machine.<\/strong>
\nRef: Commercial Circular nos. 69\/2025 dated 10.12.2025 & 70\/2025 dated 23.12.2025.<\/p>\n

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\u2019s letters no. 2015\/TG-I\/10\/P\/Payment through electronic means Pt.II dated 10.12.2025 and 23.12.2025.<\/p>\n

However, for the purpose of generating MIS reports for the transactions through POS machines for the ticket booking) following procedure may be adopted:<\/p>\n

1. As and when, a POS is installed, the following information shall, be fed in the PRS\/UTS terminal connected with SBI POS-<\/p>\n

a) Bank Code (SB for State Bank)
\nb) Service Provider identification for the POS machine (World Line\/Hitachi)
\nc) 8 digit alpha-numeric identification number of the POS machine (POS machine ID number)<\/p>\n

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.<\/p>\n

2. For the proper MIS generation, while booking the tickets, following details shall be fed by the booking\/reservation clerk:-<\/p>\n

a) Last 4 digits of debit\/credit card no.
\nb) Payment Card Service Provider (MCIVCIRU for Master, VISA, RUPAy)- This is planned to be captured in PRS only.
\nc) Payment Card type (Debit\/Credit).
\nd) 12-digit Receiver Registration Number (RRN no.)
\n(RRN Number is the booking reference number printed on the \u2018charge slip\u2019 printed by the POS machine for every transaction).<\/p>\n

All Zonal Railways are requested to ensure compliance of these instructions.<\/p>\n

Sd\/-
\n(Amit Kumar Jain)<\/strong>
\nDirector Traffic Commercial (G)<\/strong>
\nRailway Board<\/strong><\/p>\n

Click To Download the Original Order<\/a><\/strong><\/p>\n

Source : http:\/\/www.indianrailways.gov.in\/<\/p>\n

To generate MIS (Management Information System) reports<\/strong> for ticket bookings through Point of Sale (POS) machines<\/strong> in Indian Railways, follow these structured steps. These reports help monitor transactions, reconcile refunds, track revenue, and audit sales.<\/p>\n

\n

\u2705 Steps to Generate MIS Reports for POS-Based Ticket Booking<\/strong><\/h2>\n

\ud83d\udccc 1. Access the Authorized Reporting Portal<\/strong><\/h3>\n
    \n
  • Use the CRIS (Centre for Railway Information Systems)<\/strong> portal or the Commercial Console<\/strong> provided by Indian Railways to authorized staff.<\/li>\n
  • URL: Typically an intranet link (used internally by railways staff); may differ by zone\/division.<\/li>\n
  • POS machines (like SBI, HDFC, Axis) also have bank-specific dashboards<\/strong> for transaction data.<\/li>\n<\/ul>\n
    \n

    \ud83d\udccc 2. Login with Proper Credentials<\/strong><\/h3>\n
      \n
    • Enter your username\/password<\/strong> assigned to your ticket counter\/station.<\/li>\n
    • Use 2FA or OTP<\/strong> if enabled.<\/li>\n
    • Select Station Code or POS ID<\/strong> if applicable.<\/li>\n<\/ul>\n
      \n

      \ud83d\udccc 3. Navigate to POS Transactions or e-Payment Section<\/strong><\/h3>\n
        \n
      • Choose Reports<\/code> > POS Transactions<\/code> or e-Payment MIS<\/code>.<\/li>\n
      • Select:\n
          \n
        • Date range<\/strong> (e.g., daily, weekly, monthly)<\/li>\n
        • Station name<\/strong><\/li>\n
        • POS provider<\/strong> (SBI\/Axis\/etc.)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
          \n

          \ud83d\udccc 4. Select Report Type<\/strong><\/h3>\n

          Common types of MIS reports available:<\/p>\n\n\n\n\n\n\n\n\n\n\n
          Report Type<\/th>\nPurpose<\/th>\n<\/tr>\n<\/thead>\n
          Daily Booking Summary<\/td>\nShows total number of tickets sold through POS<\/td>\n<\/tr>\n
          Revenue Collection Report<\/td>\nShows gross and net revenue via POS transactions<\/td>\n<\/tr>\n
          Refund Report<\/td>\nDetails all cancellations and refund statuses via POS<\/td>\n<\/tr>\n
          Transaction Reconciliation<\/td>\nCross-checks successful payments vs settlements<\/td>\n<\/tr>\n
          POS Settlement Report (Bank-wise)<\/td>\nUsed to reconcile payments with bank partners (SBI, HDFC, etc.)<\/td>\n<\/tr>\n
          TDR Report (if applicable)<\/td>\nRefunds processed offline where bank terminal wasn\u2019t present<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
          \n

          \ud83d\udccc 5. Generate & Export the Report<\/strong><\/h3>\n
            \n
          • Click Generate<\/code> or Run Report<\/code>.<\/li>\n
          • You can view online<\/strong> or download<\/strong> the report in:\n
              \n
            • Excel (.xlsx<\/code>)<\/li>\n
            • CSV<\/li>\n
            • PDF<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

              Use filters such as Train No.<\/strong>, Class<\/strong>, Counter Operator<\/strong>, etc., for granular analysis.<\/p><\/blockquote>\n

              \n

              \ud83d\udccc 6. Verify with Bank Records<\/strong><\/h3>\n
                \n
              • Cross-verify POS transaction logs with:\n
                  \n
                • Bank merchant statements<\/strong><\/li>\n
                • IRCTC\/CRIS backend data<\/strong><\/li>\n
                • POS terminal slip summary<\/strong><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                  This ensures refunds, failed transactions<\/strong>, and chargebacks<\/strong> are correctly accounted.<\/p><\/blockquote>\n

                  \n

                  \ud83d\udccc 7. Submit to Commercial Inspector or Accounts Department<\/strong><\/h3>\n
                    \n
                  • Based on local Railway zone rules, MIS reports are:\n
                      \n
                    • Reviewed daily\/weekly<\/li>\n
                    • Submitted to Senior DCM or Dy. Commercial Manager<\/li>\n
                    • Audited periodically by Railway Accounts<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
                      \n

                      \ud83d\udee0\ufe0f Tools Often Involved<\/h2>\n
                        \n
                      • CRIS Ticketing Backend System<\/strong><\/li>\n
                      • UTS\/PRS Console<\/strong><\/li>\n
                      • POS Dashboard (Bank-specific)<\/strong><\/li>\n
                      • Indian Railways Commercial Portal<\/strong><\/li>\n
                      • Tally \/ Internal ERP systems<\/strong> for revenue mapping (in some divisions)<\/li>\n<\/ul>\n
                        \n

                        If you\u2019re looking to automate<\/strong> 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.<\/p>\n

                        Would you like a sample report format or Excel template for this?<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                        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 […]<\/p>\n","protected":false},"author":102,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,51,1],"tags":[4,50,6],"class_list":["post-5978","post","type-post","status-publish","format-standard","hentry","category-irctc","category-ministry-of-railways","category-uncategorized","tag-irctc","tag-ministry-of-railways","tag-railway"],"_links":{"self":[{"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/posts\/5978","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/users\/102"}],"replies":[{"embeddable":true,"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/comments?post=5978"}],"version-history":[{"count":1,"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/posts\/5978\/revisions"}],"predecessor-version":[{"id":13091,"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/posts\/5978\/revisions\/13091"}],"wp:attachment":[{"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/media?parent=5978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/categories?post=5978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.reilsolar.com\/train\/wp-json\/wp\/v2\/tags?post=5978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}