Private

Convert IDBI Bank statements to Tally vouchers

Greenote reads IDBI Bank statement PDFs on your own PC and gives you either a formatted Excel workbook or clean, dated vouchers posted into Tally Prime or ERP 9. 2 different IDBI Bank layouts are handled, because IDBI does not print just one.

What does a IDBI Bank statement look like?

IDBI Bank does not issue a single statement format. These are the 2 layouts Greenote recognises, and the differences between them are exactly what a one-size converter gets wrong.

IDBI Bank statement layouts Greenote recognises, with their columns and date formats
LayoutColumns printedDate format
Single amount with CR/DR columnSr, Value Date, Description, Cheque No, CR/DR, Currency, Amount (INR), BalanceDD-MM-YYYY
Split debit and credit columnsValue Date, Description, Debit, Credit, BalanceDD-MM-YYYY

Why do IDBI statements break generic converters?

These are the specific things that go wrong when a IDBI Bank statement is run through a general purpose PDF to Excel tool, or typed by hand at the end of a long day.

  • 1

    In the first layout direction lives in a separate CR/DR column whose value is written "Cr." with a trailing dot. An exact match against "Cr" fails and every credit is booked as a debit.

  • 2

    In the second layout, rows with no value date are description continuations of the row above rather than transactions in their own right.

  • 3

    A currency column sits between the direction flag and the amount, which shifts the amount position relative to the other layout.

How Greenote turns it into Tally vouchers

If all you want is the spreadsheet, stop after step two and export it to Excel. That is a complete use of Greenote and plenty of people never go further.

  1. 1

    Detect the IDBI layout

    Greenote identifies the bank from the statement itself and picks the matching reader, so the right one of the layouts above is used without you selecting anything.

  2. 2

    Rebuild every transaction

    Dates, narration, debit, credit and running balance are reassembled into one row per transaction, including the multi-line and continuation cases listed above.

  3. 3

    Classify and name the counterparty

    Each line gets a category (what the transaction was) and, where the narration allows it, a party name (who it was with), bound to a ledger that already exists in your Tally company.

  4. 4

    Post into Tally

    Greenote builds the voucher XML for your Tally version and posts it into your local Tally. You review before anything is written.

Get a text PDF, not a scan. Download the statement straight from IDBI net banking as a PDF or Excel file. A text PDF contains the actual characters and can be read exactly. A scanned printout or a phone photo only contains a picture of the text, and every figure in it has to be guessed. How to tell the two apart in three seconds.

Three ways to get a IDBI statement into Tally

  1. 1. Type each row into Tally

    It works with any statement and needs no other software. Every row is a voucher you key in by hand, so a month of a busy IDBI account is hours of entry, and a mistyped amount is still a voucher in the books.

  2. 2. Convert to Excel, then import

    Some firms convert the PDF to a spreadsheet and bring it into Tally with an import. The sheet has to be laid out the way the import expects, and IDBI prints 2 different layouts, so the columns usually need reshaping by hand first, and the ledger for each row still has to be chosen.

  3. 3. Read the PDF straight into vouchers

    Greenote reads the IDBI PDF on your PC, works out the voucher type and the ledger for each row, and posts the vouchers to Tally, then confirms each entry there. No spreadsheet step in between.

Read on your own PC

The IDBI statement is read on your PC

Greenote reads the statement on your own machine and does not upload it to be read. Your firm can tell a client exactly where their statement is and who holds it, which is the answer a client actually wants. For bank statements Greenote is a pass-through to Tally: it reads the statement and posts the vouchers, and reading it puts no copy on our side.

Free trial: 7 days or 5 statements, no card. Works with Tally Prime and ERP 9.

IDBI statement to Tally: common questions

Can I convert a IDBI statement PDF to Excel?
Yes. Greenote exports a formatted Excel workbook from a IDBI Bank statement, containing the full transaction ledger plus category and party summaries, daily balances and separated sheets for cash, transfers and income. The conversion runs on your own PC and the statement is not uploaded anywhere. Posting the same data into Tally is a separate step you do not have to use.
Can Greenote read a IDBI Bank statement PDF?
Yes. Greenote has a reader tuned specifically to IDBI Bank statements and handles all 2 layouts currently in circulation. Give it the PDF you downloaded from net banking and it produces dated, signed transactions with the narration intact.
Which IDBI statement format should I download?
Download the statement as a PDF or Excel file directly from net banking. A text PDF carries the real characters, so it can be read exactly. A scan or a phone photo of a printout carries only an image of the text and has to be guessed at, which is where accuracy is lost.
Does my client's IDBI statement get uploaded anywhere?
No. Greenote runs on your Windows PC and reads the statement there. Reading it does not send the file to Greenote or to anyone else, and the vouchers go straight into your own Tally. Your firm stays the one responsible for that statement under the DPDP Act.
Does it work with Tally Prime and Tally ERP 9?
Yes, both. Greenote builds the correct voucher XML for the version you are running and posts all 8 voucher types, with GST handled where it applies.

And the rest of the year

Greenote does more than one bank

It is one piece of software for a practice, in 57 features: bank statements into Tally, month-end and year-end, GST returns, TDS, tax audit, income tax, company law and your practice. Bills and e-invoices into Tally, the bank reconciliation, GSTR-1, 2B, 3B and 9, missed TDS and 26AS, the cash and MSME checks and the tax audit papers, capital gains, the computation sheet, advance tax and the Return (ITR), the final accounts, and the clients, tasks, fees, documents and notices of the office. Plans carry different parts of it.