The Amreli Jilla Madhyastha Sahakari Bank Ltd. statement PDF to Excel & Tally XML

Convert The Amreli Jilla Madhyastha Sahakari Bank Ltd. (Amreli Sahakari) 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.

The Amreli Jilla Madhyastha Sahakari Bank Ltd. prints internal interest-rate and account-type change logs inside the same table as real money rows. If those logs become Tally vouchers, Day Book fills with CR RT CHG noise. Jemsky drops rows whose amounts are ‘-’ while keeping actual debits and credits.

Identity is the full bank title, GSCB0AMR007, and Sahakar Bhavan Amreli Road — important because Amreli appears in other banks’ addresses.

Sampled 36-transaction files reconcile 22 debits and 14 credits to the printed close at 100% audit. Hybrid Gujarati/English tokens stay in narration. Excel/CSV/Tally XML; RAM only.

Statement formats the Amreli Sahakari parser recognizes

• GSCB0AMR007 / Sahakar Bhavan Amreli statement: Post Date, Value Date, Narration, Cheque Details, Debit, Credit, Balance Cr/Dr

Parser quirks specific to Amreli Sahakari

• Core-banking audit-log rows (CR RT CHG 3.000 - 2.750 -, ACCOUNT MAI .0000 - 3.0000 -) sit in the grid with ‘-’ amounts and must be dropped.
• Detection uses THE AMRELI JILLA MAD.SAH.BANK, GSCB0AMR007, Sahakar Bhavan — not generic ‘Amreli’ in an address.
• BROUGHT FORWARD: 20699.00Cr is the opening, not a transaction.
• UPI wraps below the date line are concatenated in visual order.

Example narrations and how they export

• CR RT CHG 3.000 - 2.750 - — Filtered; not a debit voucher.
• BROUGHT FORWARD: 20699.00Cr — Opening ₹20,699.00.

CA workflow on Amreli Sahakari files

After convert, scan Excel for leftover ‘CR RT CHG’ — those should be gone. Opening should match BROUGHT FORWARD, not the first UPI. Then map local UPI merchants in Tally Party Ledger Masters.

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.

1. Open the converter and upload the Amreli Sahakari PDF.
2. Leave Auto Detect on unless you know the exact layout name.
3. Confirm the financial audit equation matches the printed closing balance.
4. Export Excel for the working paper and/or Tally XML.

Frequently asked questions

How do I convert a The Amreli Jilla Madhyastha Sahakari Bank Ltd. statement PDF to Excel?

Upload the Amreli Sahakari e-statement on jemsky.com/app. Auto Detect should pick the Amreli Sahakari plugin. Review Opening + Deposits − Withdrawals = Closing, then download Excel, CSV, or Tally XML. The PDF is parsed in RAM and discarded.

Can I import The Amreli Jilla Madhyastha Sahakari Bank Ltd. statements into TallyPrime?

Yes. Export Tally XML and use Import → Transactions. Optional: import Master.json/xml and enable ledger suggest so Amreli Sahakari UPI/NEFT rows map to party ledgers instead of Suspense A/c.

Does Jemsky store The Amreli Jilla Madhyastha Sahakari Bank Ltd. statement data?

No. The Amreli Jilla Madhyastha Sahakari Bank Ltd. PDFs are not archived. Passwords unlock in memory only.

What is unique about the Amreli Sahakari parser versus other banks?

Core-banking audit-log rows (CR RT CHG 3.000 - 2.750 -, ACCOUNT MAI .0000 - 3.0000 -) sit in the grid with ‘-’ amounts and must be dropped. After convert, scan Excel for leftover ‘CR RT CHG’ — those should be gone. Opening should match BROUGHT FORWARD, not the first UPI. Then map local UPI merchants in Tally Party Ledger Masters.

Related: All banks · User Guide · Security · Free Excel · Tally