V.P. Form No.7 (Taxes and Miscellaneous Items Collection Register), V.P. Form No.9
(V.P. Fund Chitta) and the double-entry SNA Cash Book — filled from your own VPTax and
OnlinePPA logins, balanced against the bank statement day by day, with cash in hand at
any point of time. One workbook.
💡எளிய வழிகாட்டி · Quick Guide
1️⃣ District → Block → Panchayat + நிதியாண்டு தேர்வு செய்யவும்
4️⃣ OnlinePPA login — கட்டட அனுமதி வருவாய் இல்லையெனில் Skip
5️⃣ Grant/Interest & V12.6 override files — தேவையெனில் மட்டும்
✅ Form 7 + Form 9 + SNA Cash Book + தினசரி ரொக்க இருப்பு + Reconciliation — ஒரே xlsx-இல்
Fetch with my logins
I already have the exports
These three names are printed on the Form 7 / Form 9 headings.
Opening and closing balances are read from the statement itself. The header row is detected automatically.
Override files · optional
Download a blank one, fill it, upload it back. Same formats as the SNA and Cash FIFO tools —
a file you already keep works here untouched.
Interest, Finance Commission and other government credits. They go to the Other / Misc. column of Form 7.
Use when cash was banked without a “CASH DEP” narration — a POS-UPI, IMPS or NEFT credit paid in from a staff account.
Don't have the override files? Draft them from the statement
Attach the VPTax export and the bank statement above, then press
Prepare draft templates. Those two files 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 — every person-to-account credit is pooled, the VPTax
UPI + POS-UPI receipts are settled out of it first, and what is left 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 the boxes above.
Monthly F7 / F9 sheets
Opening cash is last year’s closing cash in hand. Leave it 0 if the cash book closed nil — the bank opening balance is taken from the statement, not from here.
Skip OnlinePPA (no building-plan income this year)
1 · VPTax
2 · OnlinePPA
3 · Register
VPTax login
An OTP has been sent to your registered mobile. Enter it to finish logging in.