Register 7 & 9 · பதிவேடு 7 & 9

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 + நிதியாண்டு தேர்வு செய்யவும்

2️⃣ Bank Statement (.xlsx) upload செய்யவும்

3️⃣ VPTax login (username · password · captcha · OTP)

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

District

Block

Panchayat

These three names are printed on the Form 7 / Form 9 headings.

From (dd-mm-yyyy)

To (dd-mm-yyyy)

Financial Year

Bank statement (.xlsx from the TNPASS Account Statement)

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 / Grants ⬇ blank template

Interest, Finance Commission and other government credits. They go to the Other / Misc. column of Form 7.

V12.6 cash-split ⬇ blank template

Use when cash was banked without a “CASH DEP” narration — a POS-UPI, IMPS or NEFT credit paid in from a staff account.

Opening cash in hand (₹)

Bank header row (blank = auto)

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)