Convert a Central Bank of India Statement to Excel
Central Bank of India statement structure, the dense page footers, and how to verify the converted file is complete.
Central Bank of India statements carry a lot of non-transaction text on every page, and separating it from the data is most of the conversion work.
Page furniture
Each page carries a branch address block, an IFSC and MICR line, a page number, and often a computer-generated-statement disclaimer. None of it is transaction data, and all of it sits in or near the same horizontal band as the table.
Converters that identify a table by finding rows of text at consistent positions will happily absorb footer lines. The result is rows with a fragment of an address in the description column and nothing anywhere else.
The rules that filter it out
- A row with no parseable date is not a transaction
- A row containing an IFSC or MICR pattern is account metadata
- A row matching "Page N of M" is furniture
- A row whose text matches the account header block is a repeated header
- A row beginning with a total or balance keyword is summary data
Applied together, these leave the transaction table and nothing else. The summary figures are not wasted: they are what the checks compare the rows against.
Verifying
Central Bank prints opening and closing balances and period totals. Compare all four against your extracted data. If the debits and credits both match and the balance chain holds, the file is complete.
What is kept and what is discarded
| Statement element | Where it goes |
|---|---|
| Transaction rows | The Statement sheet, exactly as printed |
| Account number, holder, branch, IFSC, MICR | Left on the PDF — they are not transactions |
| Opening and closing balance, period totals | Checked against the rows on the Completeness sheet, where the statement prints them |
| Repeated page headers | Kept once, at the top of the table |
| Page footers and disclaimers | Left out |
The account details are not lost: they stay on the PDF, which is the record of whose account this is. They simply do not belong among the transactions.
Verifying
Central Bank prints opening and closing balances and period totals, so both checks are available. If your export contains address fragments as rows, expect the totals check to fail — those rows have no amount, so they will not distort sums, but they will inflate the row count.
Frequently asked questions
Why does my export contain parts of the branch address?
Page footer text being read as transaction rows. Those rows have no date, which is what identifies them as furniture rather than data.
Does the account information get lost?
It stays where it is: on the PDF. The converted file is the transaction table, so the account number, holder, branch and IFSC are not copied into it, and keeping the PDF beside the export keeps both.
Are Central Bank statements password-protected?
Emailed e-statements usually are. The covering email states the password rule.
Related posts
- Convert a Bank of India Statement to Excel
- Convert a Union Bank of India Statement to Excel
- Convert a UCO Bank Statement to Excel or CSV
Convert a statement now
Bank Statement PDF to Excel, or see every format. More in the guides.