ORALZY
Concept

Bank milaan ki teen file kya hain, Payment Tracker aur TmsBisTrack kahan milega?

Billing → Insurance & RGHS → Bank reconciliation me teen file: "1. Bank statement" (SBI netbanking → Account statement → Excel .xls; PDF bhi chalega), "2. RGHS Payment Tracker" (RGHS hospital portal → Payment Tracker → Excel — isme UTR hota hai) aur "3. TmsBisTrack" (RGHS portal → TmsBisTrack Excel — patient, CU approval, remark). File ka type app khud heading se pehchaanta hai; kram koi bhi.

Where in ORALZY: Billing → Insurance & RGHS → Bank reconciliation → Bank milaan · Mobile: Billing → Insurance & RGHS → Bank reconciliation

Kaun kya batata hai: bank statement me RGHS ki entry "TREASURY OFFICE" wali NEFT hoti hai — usme sirf UTR hota hai, patient ya claim nahi. Payment Tracker har paid claim ki row hai: TID, mila amount, TDS, UTR, remark (jaise 50% cut), credit date. TmsBisTrack har claim ki kahani hai: patient, type (OPD / Day-Care / IPD), submit aur CU approval date, approved amount — isme payment nahi. Isliye sirf bank statement daalne par RGHS entries "In bank, not in Tracker" me rehti hain (claim pata nahi) — app amount dekh kar andaza nahi lagata, Tracker maangta hai. TmsBisTrack ke bina "⏳ Not received" (approve hua par paisa nahi aaya) wali list nahi banti. Upload hote hi us file ka dabba hara "✓" ho jaata hai — bank statement aur Tracker par kis tareekh se kis tareekh tak ka data, TmsBisTrack par kitne claims; neeche "Last upload: …" me aakhri file, samay aur kisne daali. Har mahine nayi files daalte jao — purana data rehta hai.

Quick steps

  1. SBI netbanking se account statement Excel (.xls) download karo
  2. RGHS hospital portal se Payment Tracker aur TmsBisTrack Excel download karo
  3. Bank reconciliation me teeno chun kar "Upload" dabao
  4. Har dabbe par hara "✓" aur date range check karo

tmsbistracktrackerstatementsbiportalutrfilestreasurymilaandownload