OCR - For converting hard copy bank statements into excel?
stevo5678
Registered Posts: 325
Just wondering if anyone has had any experience/success with converting hard copy statements into excel (via a middle piece of software, maybe pdf/image reader).
There are things about and I have read that it is possible?
It could save alot of time for alot of people
Thanks
There are things about and I have read that it is possible?
It could save alot of time for alot of people
Thanks
0
Comments
-
Yeah it's do-able with decent OCR software. We have a nifty Kodak document scanner and the OCR that came with it is decent. But, for analysing columnar info like a bank statement, you'd have a hell of a job formatting it.
Can't you just download a CSV from the online banking?0 -
I have done this a number of times on varying lengths and types of bank statements. Having used 3 or 4 different programs I found it is generally the case that you get what you pay for with them. I didn't have much luck with cheaper ones like the one adobe has built into the acrobat reader.
The most effective one I found for converting to excel was the Cogniview software, specifically I use this version (http://www.cogniview.com/store/pdf2xl-enterprise-purchase). Whilst it is by no means perfect solution, as it largely depends on the quality of the scanned document I have been able to convert 80+ statements in under an hour.
Usually you have to do some deleting and editing of statement lines once its converted to excel but it can be done quickly enough if you are using sort functions and balance checks.
If the bank statement has been ticked or marked next to the amounts you will have all sorts of trouble and is not worth the hassle trying to convert it.
As you have said it is certainly possible and has offered considerable time savings in most circumstances I have tried it, but I haven't managed to find one that converts to excel without requiring some user corrections.
Dom0 -
I looked into this about a year ago as I had a massive report (not a bank statement, but similar looking from what I remember) that I wanted in excel. I downloaded trials of numerous software packages claiming they could help and asked serveral people who I expected to be able to help and nothing really worked - I ended up entering all manually.
I'm not saying that it doesn't exist, but there's def no easy solution!0 -
Hi Everyone,
Smartrex (OCR) is a bank reconciliation and analysis software. It reads bank statements and extracts information and convert bank statements to excel making it an effective bank statement reader software.
www.smartrex.co.uk
Smartrex(OCR) is the web based solution making it only Online Bank Statement Extraction software in the market which extract information convert bank statements to Excel, PDF and CSV.
I came across this software which is real value for money. It is the cheapest I found in the market which convert bank statements to excel. They do not charge per page. In just £50 per month you can convert unlimited bank statements(PDF/TIFF/JPG) to excel. i.e 1000 or 10000 pages of statements. They do not have restrict you. Simply amazing and there is no hidden cost.
http://www.smartrex.co.uk/smartrexpricing.html
Do not forget to thank me if you find that useful. Thank you.0 -
ocrex is very good I,ve used for 12 mths have not tried cogniview mentioned above
Doug0 -
Ocrex is pay as you go it works very well and has an iris or vt+ mapping option0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 323 NEW! Qualifications 2022
- 165 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 88 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership