Guides
Plain-language walkthroughs for the jobs around a bank statement: getting it into Excel without retyping, importing it into accounting software without duplicate vouchers, understanding the file formats importers ask for, and finding the tax figures buried in it.
How to convert a bank statement PDF to Excel (without retyping)
A step-by-step walkthrough for turning any bank statement PDF into a clean Excel sheet with correct Date, Narration, Debit, Credit and Balance columns — including scanned pages and multi-page statements.
Read the guideImport a bank statement into TallyPrime the right way
How Tally XML import works, when to use Banking > Import Bank Statement instead, why Payment, Receipt and Contra matter, and how to avoid duplicate or Suspense-heavy vouchers.
Read the guideOFX, QIF, MT940, CAMT.053 and BAI2 explained for accountants
What each bank-statement file format actually is, which accounting software reads which one, and why a native format imports with no column mapping while a CSV always asks questions.
Read the guideFinding bank charges, interest and TDS in a statement for ITR
How to pull savings interest, TDS deducted by the bank, bank charges with GST and cash deposits out of a bank statement, and where each figure goes in an income tax return.
Read the guideWho these are written for
Mostly accountants, article assistants and small business owners in India who receive statements as PDFs and have to get them into TallyPrime, Busy, Marg, Zoho Books or plain Excel. The steps are written out in full rather than assumed, so they also work if this is the first month you have done the bank reconciliation yourself.
Every guide can be followed by hand with nothing but Excel. Where the converter on this site saves a step, that is pointed out — but the manual route is always described first so you know what the tool is actually doing.