This video goes into the specific steps needed to use Python, pdfplumber, and the pandas libraries to identify the debit and credit amounts on a PDF file where the amount columns only have the amounts under either Debit or Credit, making it hard to tell in each row whether the data is a debit or a credit….(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Can you make a tutorial on this pdf below?
https://drive.google.com/file/d/1h3wfqc7oJ0tMIEb8F9Ble7GzRhlCEo5q/view?usp=share_link
Could you please explain the meaning of the lines below ?
rows_dict = {b: a for a, b in enumerate(sorted(set([word['bottom'] for word in words])))}
last_pos = {rows_dict.get(word['bottom']): word['x1'] for word in words}
How do you combine the Account Name since it has spaces? I have a PDF with names in the 'Last, First MI' format and it keeps confusing/separating the name.
how to convert the result into excel file?
Great video(s)!! They gave me ideas how to convert a challenging 400 page pdf report to csv with addresses and names spilling into multiple lines for cetain accounts.
Hi, I’m a Finance Director in the UK and looking into learning Python for a project I have. Do you have LinkedIn so I can drop you a message for some advice?
can you please provide us the source code
Hi there. Is it possible to build something like this in python: 1)user uploads pdf invoice on a sharepoint 2) the system reads the pdf, 3) the system recognizes that it is a "gasoline invoice" 4) the system automatically books journal entry debit to gasoline expense account and credit to cash account 5) everytime a new invoice is uploaded to the sharepoint the system books the corresponding entry. Is something like this possible in python?
Hi! Any idea how I will be able to do this with a balance column? The balance amount is messing with the last position, therefore I'm not able to extract the data
Fantastic , coool , But How can i create desktop application accounting System with Python ? and to make accounting system with python and become short cut window for it in the desktop i will need to use another Language with Python or Only Python and if only python How make it ? because its a first time to deal with python , only i had set up for anaconda navigator and Jypternoebook , So Please Give Me a hand >>Here Or May you Explain By Email " excelcoool@gmail.com" thank you very much
Amazing! This is exactly what I'm looking for. Thank you so much!!
Github code is here https://github.com/danshorstein/pythonic-accountant/tree/master/022%20PDF%20Extract%20dr%20cr%20columns