Branch-wise figures captured at each day's Publish — not the live book above
Daily PNPA — Potential NPA Watch
Hathras Region · KCC / KCC-AH / Other, branch-wise · Data as on
KCC Overdue
Hathras Region · KCC / KCC-AH / OD-023 (Tatkal) · Data as on
SMA Dashboard
Hathras Region · Special Mention Accounts (RBI early-warning) · Data as on
Download
Data updated as on
PNPA Slippage
Accounts recently classified NPA · KCC and Non-KCC
Slippage During Current Month
Accounts tracked daily in between NPA uploads · never alters the main NPA Dashboard's Outstanding
Branch Profile
Monthly branch-level business performance · uploaded separately from daily NPA data
UPGB OTS Calculator
One-time settlement
Report Date:
Utility Hub
Every extra tool, kept in one place — grouped so the right one is never far
14 TOOLS
Converters3 tools
Summaries & Reports6 tools
Directory & Reference2 tools
Documents & Letters3 tools
Notices1 tool
No tools match “”.
OneDrive Files
Browse & download only — nothing from this app is ever uploaded to OneDrive
Sign in with your personal Microsoft account to browse and download files from your own OneDrive. Nothing from this app is ever uploaded there.
PassSheet (HMSTRP)
Passbook PDF → structured Excel ledger, read entirely in your browser
NPA Region Summary
Whole-bank NPA file → Region/Branch-wise KCC & Slippage summary, read entirely in your browser
Daily PNPA Summary
Whole-bank Daily PNPA file → Hathras SOL ID-wise KCC & Total, read entirely in your browser
Telephone Directory
Hathras region staff directory — search by name, branch, designation or number
HBR Report
GL Balancing Report PDF → branch-wise & account-wise summary, read entirely in your browser
NPA SOL Summary
NPA Accounts report (.txt) → SOL ID-wise Debit Balance summary, read entirely in your browser
Branch Map
All 57 branches, plotted from their own site GPS — roads, names, Google Maps directions
Branch Split
Daily NPA export → one workbook per branch, region-aware, address-enriched, read entirely in your browser
KCC Overdue Summary
Daily KCC "Data" export → F.Y./Month bifurcation, single-branch drill-down, all-branch overview — read entirely in your browser
Application Form
Search any account → auto-filled Hindi settlement application letter, Print/Save-as-PDF/WhatsApp Share
NPA Target Tracker
Branch/Region FY Target vs live Actual, month-wise, with Ahead/Behind filters
NPA Notice
Branch-wise 15-day recall notice, one combined PDF, editable Hindi template
PDF Page Manager
Reorder, rotate, merge, extract and split PDF pages, entirely in your browser
Universal Letter Generator
Upload any Excel/CSV + a template with your own fields, get one combined personalized-letter PDF
Crafted by Alok Mittal
ESC
↑↓ navigate↵ openEsc close
✕
Total OTS Amount—
P&L Impact—
Total OTS Amount—
Total Dues—
Total Sacrifice—
Update Data
Upload your daily NPA export (the HO "e-AB NPA AC WISE" .csv/.xlsx) — it's parsed automatically. Optionally also upload the Customer Master (Address/Aadhar/PAN) whenever it refreshes; it's remembered between updates so you don't need to re-upload it daily.
.xlsx or .csv — Customer ID, Name, Address, Mobile, Aadhar, PAN
This is the single source for every account's address, app-wide — matched by Customer ID, merged straight into the daily NPA book, and carried forward automatically into every later day's upload for a customer not present in that day's fresh file, so an address captured once keeps showing everywhere (Dashboard, KCC Overdue, Branch Split and every other Utility Hub tool, the Recovery Dashboard portal) without needing re-uploaded alongside every daily file. Uploading replaces the previous list entirely. Goes live the next time you hit Publish.
Tap to choose the Head Office Daily NPA Projection workbook or the Branch Advance file
.xlsx (Daily Follow-up Sheet) or .csv — Sol ID, Advance (₹ Lakhs), optionally NPA March/June (₹ Lakhs)
Upload the Head Office Daily NPA Projection workbook as-is, or the Branch Advance template filled in by hand — the Sol ID and Advance columns are read automatically (from the "Daily Follow-up Sheet" for the HO workbook). If the file also has "NPA MARCH 26"/"NPA JUNE 26" columns (₹ Lakhs), those power a Mar/Jun comparison shown in the Dashboard's Total Outstanding card. Branches are matched by Sol ID, not name, so this stays correct even where branch name spellings differ between reports. Uploading replaces the previous figures. Goes live the next time you hit Publish.
Branch/Region NPA Target (FY) — not loaded yet
Tap to choose the Branch/Region NPA Target workbook
.xlsx or .csv — Sol ID, Branch Name, monthly "Target <Month>'<YY>" columns (₹ Lakhs)
Branches are matched by Sol ID, not name. If the sheet has a separate Region/Head-Office row (no Sol ID of its own, just a label like "TARGET GIVEN BY HO to Regional office"), that row's figures are read as the Region's own target — in ₹ Crores, since Head Office's row uses a different unit than the branch rows (₹ Lakhs) — and are never added up from the branch rows below it, since the Region's own target is a separate commitment from Head Office, not a total of what the branches individually commit to. Powers the new NPA Target Tracker (Utility Hub → Summaries & Reports) and Recovery Dashboard's own per-branch target tile. Uploading replaces the previous figures. Goes live the next time you hit Publish.
Interest Reversal (master list) — not loaded yet
Tap to choose the Interest Reversal file
.xlsx or .csv — Account_Number, Interest Reversal amount (₹)
This is now the permanent source for the Interest Reversal figure — every future daily NPA upload will automatically apply it by Account Number, overriding whatever (if anything) Head Office's own file carries that day, so it never silently resets to 0 again. Only re-upload this when you have an updated/corrected list; you do not need to upload it alongside every daily NPA file. Goes live the next time you hit Publish.
Branch Contacts (Manager / Recovery Officer) — not loaded yet
Tap to choose the Branch Contacts file
.xlsx or .csv — Sol ID, Branch Manager, Recovery Officer, and whatever else has been collected
The downloaded template already has every branch's Sol ID, Old Sol ID and Branch Name filled in (and carries forward anything already collected) — just fill in the rest and re-upload. Branches are matched by Sol ID. Powers the Branch/Sol ID panel: each row shows the Manager and Recovery Officer's name with a tap-to-call number, and tapping the row opens a full card with everything on file for that branch. Uploading replaces the previous records. Goes live the next time you hit Publish.
Branch Profile (monthly business performance) — not loaded yet
Tap to choose the Branch Profile file
.xlsx — Regional Office's own monthly "Branch Profile" report, exactly as received (the "MASTER" sheet is read automatically)
Upload the Regional Office's own report as-is — its "MASTER" sheet is detected and read automatically, Sol ID by Sol ID, and since that report already carries several months side by side, one upload backfills the Branch Profile tab's whole MoM/YoY history in a single step. The fallback template above (a simpler, one-month, hand-fillable sheet) is only for when that report isn't available — deposit/advance/NPA figures there go in ₹ Lakhs, matching the Branch Advance upload's own convention elsewhere in this app. Uploading replaces the previous month's figures. Goes live the next time you hit Publish.
Branch Profile Targets (monthly, per branch) — not loaded yet
Tap to choose the Branch Profile Targets file
.xlsx or .csv — Sol ID plus the monthly target columns
Branches are matched by Sol ID. Not yet connected to the Branch Profile tab itself (no real targets file exists yet) -- uploading just stores the figures for later, once there's a real target report to wire up. Goes live the next time you hit Publish.
Daily PNPA — Potential NPA (Hathras) — not loaded yet
Tap to choose the Daily PNPA file
.xlsb/.xlsx/.csv — the whole-bank Daily PNPA export as received from Head Office; Hathras rows are picked out automatically
Read entirely in your browser. Even though the file covers the whole bank, only Hathras region's rows are kept, and zero-balance accounts are dropped automatically. Powers the separate "Daily PNPA" tab — branch-wise summary split into KCC (CC004), KCC Animal Husbandry (CC043), Limit Review (any scheme flagged for a limit review) and all other schemes, sorted highest first, with a tap-through account list per branch (Account No, Name, O/S, CADU, Limit, Review Date, Reason). Also now captures each account's Cust NPA Date, powering the Recovery Dashboard portal's "PNPA Slippage" tracker's "Today" tab. Uploading replaces the previous figures. Goes live the next time you hit Publish, same commit as the daily NPA data.
Weekly PNPA — Potential NPA, this week (Hathras) — not loaded yet
Tap to choose the Weekly PNPA file
.xlsb/.xlsx/.csv — same layout as Daily PNPA, already scoped by Head Office to this week's slippage; Hathras rows are picked out automatically
Read entirely in your browser, parsed exactly like Daily PNPA (same columns, same Hathras/zero-balance filtering) but published as its own separate file. Powers the Recovery Dashboard portal's "PNPA Slippage" tracker's "This Week" tab -- shown as-is (already scoped to this week by Head Office, no extra date filtering applied on this end). Uploading replaces the previous figures. Goes live the next time you hit Publish, same commit as the daily NPA data.
Monthly PNPA — Potential NPA, this month (Hathras) — not loaded yet
Tap to choose the Monthly PNPA file
.xlsb/.xlsx/.csv — same layout as Daily PNPA, already scoped by Head Office to this month's slippage; Hathras rows are picked out automatically
Read entirely in your browser, parsed exactly like Daily PNPA (same columns, same Hathras/zero-balance filtering) but published as its own separate file. Powers the Recovery Dashboard portal's "PNPA Slippage" tracker's "This Month" tab -- shown as-is (already scoped to this month by Head Office, no extra date filtering applied on this end). Uploading replaces the previous figures. Goes live the next time you hit Publish, same commit as the daily NPA data.
KCC Overdue (Hathras) — not loaded yet
Tap to choose the daily KCC "Data" file
.xlsx/.xlsb/.csv — the daily KCC "Data" export (Sol, Region, Branch, Account No, Scheme Code, Balance Amount, Cust NPA Date, F.Y., etc.); only Hathras rows and the 3 known scheme codes are kept
Read entirely in your browser. Powers the "KCC Overdue" tab — filterable by Branch, F.Y., Cust NPA Date (month or a custom date range), and scheme (KCC/CC004, KCC Animal Husbandry/CC043, OD-023 Tatkal), with branch-wise summaries, a tap-through account list, and an F.Y./Month Bifurcation, Branch Report, and All Branches Overview breakdown. Uploading replaces the previous figures. Goes live the next time you hit Publish, same commit as the daily NPA data.
SMA — Special Mention Accounts (Hathras) — not loaded yet
Tap to choose the SMA export file
.txt (pipe-delimited) — the SMA early-warning export from Head Office; covers every loan scheme, not just KCC
Read entirely in your browser. Powers the "SMA Dashboard" tab — SMA-0/SMA-1/SMA-2 buckets (customer-level classification), a Non-Financial flag overlay, branch-wise and reason-wise breakdowns, and Top 20 Accounts / Top 10 High-Risk Customers tables. Uploading replaces the previous figures. Goes live the next time you hit Publish, same commit as the daily NPA data.
Slippage During Current Month — not loaded yet
Tap to choose today's Slippage file
.xlsx/.csv — same HO "e-AB NPA AC WISE" layout as the Daily NPA file. Upload once a day, every day this month — each upload adds to the running total, it never replaces it.
Read entirely in your browser. Powers the "Slippage (Current Month)" tab and the Download tab's Slippage card, and these accounts become immediately searchable in OTS Calculator and the Application Form — without ever touching the main NPA book, so the Dashboard's Outstanding figures never change. Only clear this once the next month's NPA file (which will now include these accounts for real) has been uploaded and published. Goes live for everyone else the next time you hit Publish, same commit as the daily NPA data.
Special Note (per Account No.) — none saved
Type an existing Account No. to see the borrower's name and branch, then type a note and Save — no file upload needed, one account at a time. Shown to every viewer, not just Admin, at the top of that account's Loan Detail screen. Stays on the account across daily NPA updates until removed. Goes live the next time you hit Publish.
OTS Calculator Book
The OTS Calculator normally stays pinned to the last upload's accounts and only grows between month-ends — an account that drops out of a later daily upload is deliberately kept here until the next month-end, so it doesn't vanish over a routine one-day gap. If accounts were pushed here by mistake and you've already re-published the corrected file, use this to remove them right now instead of waiting for month-end.
Lok Adalat — Token Already Received — not loaded yet
Proposed-OTS accounts where token money has already been collected ahead of a Lok Adalat, so a viewer opening that account's Loan Detail sees a banner and doesn't collect the token a second time. OTS Amount can be left blank until it's fixed — the banner then shows Token Amount only. Matched by Account No., not Sol ID. Each upload fully replaces the previous list — only the accounts in your latest file are shown. "Clear List" empties it without needing a fresh file. Goes live the next time you hit Publish.
Version History
Sign in with GitHub
Open github.com/login/device in any tab (on this device or your phone) and enter the code below to sign in as Administrator.
The bank's official ONE PAGER compromise-proposal format, auto-filled from this account's settlement figures. A few details below aren't in the NPA data and need a quick type-in.
OTS Worksheet
Account
Customer
Branch
Asset
O/S Balance
OTS Amount
Total Sacrifice
Impact on P&L
Saved on this device only. Nothing is uploaded — take a Backup before clearing browser data or changing phone.