Summary sheet me: Received in bank (matched) + usme TDS + cut after approval; Billed (total), Approved by RGHS, Not approved by RGHS, Not received yet, Sent by RGHS not found in statement, In bank but not in Tracker; patient entries ka hisaab; "What to do next" lines; aur notes — "Not approved" = RGHS ne bill se jo kaata, wo kabhi nahi milega (tax file karte waqt dhyan rakhein); "Cut after approval" = approval ke baad ka cut (jaise 72 ghante baad submit par 50%); "TDS is 10% and shows in Form 26AS." Screen ka filter / search Excel par nahi lagta — poora data jaata hai. Jitna upload hua utna hi Excel me, isliye pehle "What to do next" wali files daal do. CA khud bhi CA portal ke "Bank reconciliation" tab se ye Excel le sakta hai.
CA ke liye RGHS bank milaan ka Excel kaise nikalu?
Bank reconciliation me "Excel (for CA)" button (Hinglish: "Excel (CA ke liye)") — ek file "Bank-reconciliation-<date>.xlsx", 5 sheet: "Summary", "RGHS claims" (claim-wise Billed / RGHS approved / Not approved / Cut after approval / TDS / Received in bank / UTR / Status), "RGHS bank entries" (claim pata nahi), "Patient entries" (patient wali bank entry + matched payment) aur "Not found in bank" (app me hai, bank me nahi). Mobile par share hota hai.
Where in ORALZY: Billing → Insurance & RGHS → Bank reconciliation → Bank milaan · Mobile: Billing → Insurance & RGHS → Bank reconciliation
Quick steps
- Saare mahino ka statement + Payment Tracker + TmsBisTrack upload karo
- Bank reconciliation me "Excel (for CA)" dabao ("Preparing…" ke baad file download)
- Summary sheet CA ko do, "RGHS claims" sheet ITR / 26AS milaan ke liye