All-In-One Panchayat Audit — ஒரே கருவி

Five files in, six reports out. Upload your VPTax export, OnlinePPA report and bank statement (plus the optional V12.6 and Interest/Grants templates) once — this runs the Bank Analysis, Cash FIFO, UPI, Non-Cash FIFO, PPA-Bank and SNA Cash Book engines off the same inputs, cross-checks their figures against each other, and hands back a Master workbook plus a ZIP of all six individual reports.
💡 எளிய வழிகாட்டி  ·  Quick Guide
1 📥 VPTax (All_Transactions)  +  🏛️ OnlinePPA  +  🏦 TNPASS Bank Statement
2 📄 நிரப்பிய V12.6  +  Interest/Grants Template (விரும்பினால்)
3 ⚙️ ஆறு கருவிகளும் ஒரே முறையில் இயங்கும்
✅ Master Report + 6 தனித்தனி Report (ZIP) தயார்
Upload VPTax export — click to choose or drop here
Upload OnlinePPA report — click to choose or drop here
Upload bank statement — click to choose or drop here
Upload filled V12.6 template — optional, click or drop
Tells the Cash FIFO engine which bank credits are really cash deposits. The Master workbook also uses it to explain the UPI engine's "excess" — those are usually the very same credits, counted twice by two tools that cannot see each other. ⬇ Download the blank V12.6 template
Upload filled Interest/Grants template — optional, click or drop
Feeds the SNA cash book — and fills the Fitment Table rows the standalone Bank tool has to leave blank (CFC/SFC/MGNREGS, Ungaludan Stalin, Mines Fund, TASMA), which is what lets "Excess In Bank" actually be explained. ⬇ Download the blank Interest/Grants template
Don't have files 4 and 5? Draft them from the statement
Attach the VPTax export (box 1) and the bank statement (box 3), then press Prepare draft templates. Those two decide both drafts between them — nothing else is needed. You get a ZIP with a draft V12.6 and a draft Interest/Grants file.
Excess UPI is cash — person-to-account credits are pooled, the VPTax UPI + POS-UPI receipts are settled out of it first, and the remainder goes to V12.6. NEFT without NDPS / ICIC is a grant; interest stays interest.
⚠ DRAFT ONLY. The statement never says whose money a credit was. Tick every row against the chalan / receipt book, delete what is wrong, add what was missed — and only then upload it in boxes 4 and 5.
Register 7 & 9 now runs here too
Tick Register 7 & 9 below and this run also produces V.P. Form No.7, V.P. Form No.9, the SNA Cash Book (Form 11) and the Daily Cash Book — from the very same files, in the same bundle ZIP. The Master workbook then cross-checks its closing cash in hand against the Cash FIFO engine's, which is the check that catches a bank narration being read two different ways.
The standalone tool is still there if you want the registers on their own, with the portal login built in: reg79.panchayatreports.in
Engines whose required files you did not upload are skipped automatically and reported as such — nothing fails silently.
Leave the header row blank and it is detected from the file, then shared by every engine. This matters: run separately, the PPA-Bank tool defaults to row 0 while the others default to row 8, so their totals can quietly disagree.