Create a Python application to convert a bank statements into Excel.
The application has to convert 4 different formats of bank statements from different providers. It needs to have an ability to define additional statement formats. One of those formats is attached. Others when job accepted.
The output is as a csv file in the format attached. However, the output format arrangement should be configurable.
The python accepts three parameters, a folder location with pdf files in it, the type of statement and an output folder to put the converted files.
The PDF files may be in secure format.
Column A, Date: Use the date format dd/mm/yyyy. This is the transaction date.
Column B, Amount: Formatted as 'Number' to 2 decimal places, transactions for money paid out of the bank account should have minus signs in front of them (-) and transactions for money coming into the bank account in should not have minus signs in front of them
Column C, Description
Column D, Bank
Other columns as described in the attached file.
In your CSV file make sure:
The date format is dd/mm/yyyy
You've used a single 'amounts' column that contains both money paid out and money paid in
There are no commas in your amounts columns
You haven't included any quote marks (")
Each description is on a single line with no carriage returns
The file format is .csv (not .xls or .xlsx)
A character delimiter of comma ',' is being used when you export your CSV file.
only supports CSV files with a character delimiter of comma ','.
YOu must deliver:
* Working and tested code. After each statement type works, you must demonstrate it.
* Documentation how to add additional statement formats.
23 freelancers are bidding on average £211 for this job
don't have example for now but i have done this kind of job. i will take extra time then others but there would be 100% [url removed, login to view]
I Can do this job perfectly very well,I am requesting for an opportunity to start working on time.I can promise you that their will be room for errror and work shall completed on [url removed, login to view] you.
I am committed to delivering quality service to client and on time. I have achieved many year of experience in this field . I hope proposal i will taken into consideration. Yours Faithfully QuamyCute