Bank Statement Data Entry
Budget: $2 – $8 USD
I have more than fifty bank statements in PDF format that I need converted into a clean, ready-to-use Excel workbook. For every single line item, please capture three fields exactly as they appear on the statement: the date, the transaction description, and the amount. Consistent column structure is important so the file can be filtered and reconciled quickly later on.
You may use any reliable PDF-to-Excel tool, OCR software, or manual methods you trust, but the end result must be 100 % accurate—totals in Excel should match each statement’s totals, and dates and descriptions must remain unaltered.
Deliverable: one Excel file (or Google Sheet if you prefer) containing all transactions, clearly separated by statement or with an additional “Statement #” column so I can trace every entry back to its source.
Acceptance criteria:
• Every transaction from every statement present, with no duplicates or omissions.
• Columns in this exact order: Date | Transaction Description | Amount (positive for credits, negative for debits).
• Random spot-checks against the PDFs show perfect matches.
Let me know your turnaround time and any questions you have before starting.
You may use any reliable PDF-to-Excel tool, OCR software, or manual methods you trust, but the end result must be 100 % accurate—totals in Excel should match each statement’s totals, and dates and descriptions must remain unaltered.
Deliverable: one Excel file (or Google Sheet if you prefer) containing all transactions, clearly separated by statement or with an additional “Statement #” column so I can trace every entry back to its source.
Acceptance criteria:
• Every transaction from every statement present, with no duplicates or omissions.
• Columns in this exact order: Date | Transaction Description | Amount (positive for credits, negative for debits).
• Random spot-checks against the PDFs show perfect matches.
Let me know your turnaround time and any questions you have before starting.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
OCR
Data Cleansing
Data Extraction
Data Management