DCB Bank statement PDF to Excel & Tally XML

Convert DCB Bank (DCB) 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.

DCB Bank e-statements are compact portrait grids. The failure mode on generic converters is UPI text spilling into the cheque column and negative balances losing their sign. Jemsky’s DCB plugin keeps particulars, cheque, withdrawal, deposit, and signed balance as separate typed fields.

Detection uses DCBL0 and statement-of-account language. The ledger equation is run on the full file (hundreds of rows on sampled CA files).

Excel filters and Tally Payment/Receipt mapping need those typed columns. PDF discarded after export.

Statement formats the DCB parser recognizes

• Portrait statement of account (DCBL0): compact Date, Particulars, Cheque, Withdrawal, Deposit, Balance (negative with leading minus)

Parser quirks specific to DCB

• IFSC DCBL0 or dcb bank + statement of account.
• Negative balances keep the minus (same class of bug as Axis OD if double-negated).
• Sampled 353/353 rows with 100% financial audit.
• Compact grid — particulars band is wide (55–270 pt) so UPI does not overflow into cheque.

Example narrations and how they export

• Negative closing with leading minus — Exported as a negative number for OD-style DCB books.
• DCBL0 header — Identity isolated from DCB appearing inside other banks’ UPI narrations.

CA workflow on DCB files

DCB month-end: convert, sort Excel by withdrawal for charges, then Tally XML with mapping rules. If the account is OD, check the first negative balance against the PDF.

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 DCB 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 DCB Bank statement PDF to Excel?

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

Can I import DCB Bank statements into TallyPrime?

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

Does Jemsky store DCB Bank statement data?

No. DCB Bank PDFs are not archived. Passwords unlock in memory only.

What is unique about the DCB parser versus other banks?

IFSC DCBL0 or dcb bank + statement of account. DCB month-end: convert, sort Excel by withdrawal for charges, then Tally XML with mapping rules. If the account is OD, check the first negative balance against the PDF.

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