1🏦 TNPASS-ல் Download செய்த Bank Statement-ஐ அப்படியே (as-is) Upload செய்யவும்
2📊 Keyword வகைப்பாடு + Monthly/Daily Pivots
✅ Multi-sheet Report தயார்!
Upload your Statement — click to choose or drop the file here
Upload VPTax All_Transactions export — optional, click or drop
If you attach this, the report gets an extra sheet reconciling all 9 VPTax payment modes (Cash, Cheque, DD, ECS, Online, POS-Credit/Debit/Cash/UPI) against the matching bank keyword categories — Collected vs Remitted vs Variance. It also copies the Tax×Mode Pivot and a Fitment Table (Deficit/Excess) into the Summary sheet.
Upload OnlinePPA report — optional, click or drop
If you attach this alongside the VPTax export, building-plan/self-cert fee collections are folded into the Fitment Table too — Online Deficit and Excess In Bank resolve fully instead of showing the OnlinePPA amount as unexplained.
🆕 Non-Tax Credits sheet — every bank credit that is not a tax remittance is now split automatically from the narration: CFC / SFC / MGNREGS component funds, Ungaludan Stalin scheme, Mines Fund, TASMA, and whatever is left as To be identified. Those Fitment Table rows fill themselves, and each figure is backed by the transactions listed on the new sheet. Cash Dep / Clearing / UPI / NDPS / NEFT-ICIC / POS Settlement are excluded, so nothing is double-counted.
Create a detail sheet per keyword
Include monthly pivots (Credit + Count)
Include daily pivot (Keyword × Date)
Required columns in your file: CREDIT and NARRATION (auto-detected if named slightly differently). A DATE column enables the pivots.