We're looking for a data extraction expert to extract transaction details from PDF bank statements into a CSV. There are 44 PDF statements. The fields to be extracted into a CSV:
Date -> Date of the transaction
Description -> Transaction description
Original Description -> Transaction description (same as Description)
Amount -> Transaction amount positive number
Transaction Type -> credit if Amount is positive, debit if Amount is negative
Category -> Blank
Account -> Blank
Name -> Blank
Labels -> Blank
Notes -> Blank
Deliverables:
- All transactions from the statements extracted into a consolidated CSV file
- Proof that the CSV reconciles with the statements (e.g. a separate Excel file with the transaction count, total debits and total credits from each statement matching the totals from the CSV)
Requirements for the project:
- Experience with Microsoft Excel
- Excellent grammar and a high attention to detail
- Experience with a scripting language to parse the statements (Python, Bash, Perl, PowerShell, etc)
- Experience with PDF parsing tool like Tabula useful
In your proposal, please share a brief summary of your experience. Attached are two statements from the two accounts.
About the recuiterMember since Nov 11, 2022 Jhanahan Kumarasamy
from Piemonte, Italy