Upload your statement (xlsx/csv) → keyword categorization + monthly/daily pivots → download the multi-sheet report.
💡எளிய வழிகாட்டி · Quick Guide
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.
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.