How can i pull relevant data from pdfs of bank statements?

There are many softwares available which can convert pdf files into word, excel, or powerpoint.

You can also do this online, but it contains restrictions on number of copies to convert.

Best way is to opt for softwares like Adobe Acrobat for pdf file editing &/or conversion.

The cost of Acrobat will be too high, thus you may opt for other softwares like Foxit Advanced PDF Editor, NITRO pdf, etc. which are comparatively cheaper to buy.

This softwares will let you convert as many of pdf files at instance And then you may work on your Excel format as usual.

Generic PDF-to-Excel converters (Acrobat, Foxit and so on) treat a bank statement as a picture of a table. Wrapped narrations become extra rows, and debit and credit columns shift, so totals quietly go wrong. Whatever you use, two checks catch it:

1. Opening + credits − debits = closing.

2. Each row's balance = previous balance ± that row.

If both pass, filter the Credit column (or use SUMIFS on it) to get the list and total of credit entries per month.

Disclosure: we build KhataSheet (khatasheet.com), a free tool made for Indian bank statements (21 formats including SBI, HDFC, ICICI, Axis, Kotak, PNB, BoB, Canara). It runs both checks automatically, converts several statements at once into one ZIP with a combined sheet, and reads the PDF in your browser so client statements are not uploaded. https://khatasheet.com/?utm_source=caclubindia&utm_medium=community&utm_campaign=2026-w43-launch

Bank statements can be time-consuming to process manually, so it can be useful to extract the data and have it ready in Excel, so you can verify the data.

Here are some top tips:

1)Check if the PDF is editable - if you can select the text within the statement then you can try importing it into Excel or using a PDF to Excel converter. If the statement has been scanned, then you may need to use OCR to extract the text.

2)Extract the relevant data - create columns such as date, descripttion, debits, credits and balance. Also include the customer name and the month of the statement.

3)Keep your files organised -  if you have multiple statements to process, then create a naming convention. For example, ClientName_Bank_Month_Year. Create a simple spreadsheet to track your progress with statuses such as Pending, Extracted and Verified. This will help ensure your data does not get mixed up between clients and that you do not forget to check.

4)Ensure data is clean - check that the dates are in the right format, there are no blanks and that there are no debits or credits. Ensure that the opening balance, total credits, total debits and closing balance match up to the statement. If they do not match, you should check the data.

5)Ensure client data is safe - ensure you are using trusted tools and check the privacy policy.

6)Once you have extracted and verified the data, Excel can help you filter out the credits, summarise and reduce the amount of repetitive work. By using automation you can save time, but it is still important to check the data to ensure your accounting is accurate.

Free option already in Microsoft 365 Excel: Data > Get Data > From File > From PDF, select the statement tables, Append them in Power Query and save the query — next month's statement is a single 'Refresh'; then run the opening + credits − debits = closing check before using the data.