Varachha Co-Op Bank statement PDF to Excel & Tally XML
Convert Varachha Co-Op Bank (Varachha) bank statement PDFs with Jemsky’s dedicated parser — not a renamed homepage and not generic OCR. This page documents the layouts we actually ship, the quirks that break other converters, and examples CAs see in the wild.
Varachha Co-Op Bank issues at least four PDF families that look unrelated in a viewer: A4 current, narrow CA, Detail (TRN/Value date), netbanking ‘statement of transactions in account’, and mobile-app statements. Jemsky has a dedicated strategy for each. Forcing one bound set on all four is how Surat CA firms get garbage Excel.
Standard vs CA width is decided from early pages and then locked — later pages with a wider crop must not retarget columns. Detail keys trn. date + value date + chq/ref.no. Netbanking keys customer information. Mobile keys closing bal / mobile app generated statement.
BoB customers in Mota Varachha still belong on the Bank of Baroda page. Varachha identity is VCBL layouts, not the locality string alone.
Exports: Excel/CSV/Tally XML. Passwords never logged. PDF discarded.
Statement formats the Varachha parser recognizes
- Standard A4 Current: Date, Particulars, Cheque No, Debit, Credit, Balance
- Narrow CA OCR layout (page width < 560) detected once from early pages so later wider crops do not switch bounds
- Detail: TRN. Date, Value Date, Narration, Chq/Ref.No, Debit, Credit, Closing Bal
- Netbanking: statement of transactions in account / customer information
- Mobile app: closing bal + value date / mobile app generated statement footer
Parser quirks specific to Varachha
- Four plugins: standard, detail, netbanking (transaction), mobile — mutually exclusive via header keys.
- Password-protected Detail and Netbanking files (numeric or JANA/JIGN-style tokens) unlock in RAM.
- Not Bank of Baroda even if the customer lives in Mota Varachha (BoB uses BARB0).
- Standard CA narrow layout is chosen from early pages and locked for the whole statement.
Example narrations and how they export
- VCBL_Detail_… with TRN. Date / Value Date — Detail plugin, not standard A4.
- Mobile app generated statement — Mobile plugin; value date + closing bal.
- Narrow CA OCR width < 560 — CA path locked so later pages cannot flip to A4 bounds.
CA workflow on Varachha files
Look at the header before you assume ‘Varachha’. If you see TRN. Date, it is Detail. If you see mobile app generated statement, it is the mobile plugin. Auto Detect is safer than picking Standard for everything.
Exports and privacy
Every successful convert can download Excel (.xlsx), CSV, and TallyPrime / Tally.ERP 9 Payment and Receipt XML. Customer statement bytes never land in Jemsky’s database. Optional Tally Party Ledger Masters store ledger names you import — not this bank’s PDF.
- Open the converter and upload the Varachha PDF.
- Leave Auto Detect on unless you know the exact layout name.
- Confirm the financial audit equation matches the printed closing balance.
- Export Excel for the working paper and/or Tally XML.
Frequently asked questions
How do I convert a Varachha Co-Op Bank statement PDF to Excel?
Upload the Varachha e-statement on jemsky.com/app. Auto Detect should pick the Varachha plugin. Review Opening + Deposits − Withdrawals = Closing, then download Excel, CSV, or Tally XML. The PDF is parsed in RAM and discarded.
Can I import Varachha Co-Op Bank statements into TallyPrime?
Yes. Export Tally XML and use Import → Transactions. Optional: import Master.json/xml and enable ledger suggest so Varachha UPI/NEFT rows map to party ledgers instead of Suspense A/c.
Does Jemsky store Varachha Co-Op Bank statement data?
No. Varachha Co-Op Bank PDFs are not archived. Passwords unlock in memory only.
What is unique about the Varachha parser versus other banks?
Four plugins: standard, detail, netbanking (transaction), mobile — mutually exclusive via header keys. Look at the header before you assume ‘Varachha’. If you see TRN. Date, it is Detail. If you see mobile app generated statement, it is the mobile plugin. Auto Detect is safer than picking Standard for everything.
Related: All banks · User Guide · Security · Free Excel · Tally